API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 29th, 2017
58
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.38 KB | None | 0 0
raw download clone embed print report
  1. phinx [nil, {:with=>{:rubric_l3_id=>130683, :state=>[1, 2, 3, 5], :public_state=>1, :is_company_public=>1}, :sphinx_select=>" IF(regional_packet_sort.1 IS NOT NULL,\n INTEGER(regional_packet_sort.1),\n INTEGER(regional_packet_sort.256)\n)\n\n+ rate/100\n+ (actualized_at > 1495715510) AS virtual_ranking_factor\n,random_float() as random_f,FLOOR(price * standard_currency_rate * POW(10, round_precision - 10) + 0.5) / POW(10, round_precision - 10) AS converted_price,actualized_at > 1490963510 AS is_actual, IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\nAS virtual_regional_packet\n, (( IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\n) =\n 0) AS is_free\n,random_float() as random_f_in_group,IN(main_region_id, 1) AS boosted_region,sphinx_internal_id", :match_mode=>:extended2, :conditions=>{:rubrics_idx=>"rubric_l3_id_130683"}, :classes=>[Apress::Products::Product(id: integer, name: string, announce: string, description: text, company_id: integer, created_at: datetime, rubric_id: integer, is_public: boolean, regions: string, moderator_comment: text, position: integer, updated_by: integer, moderated_at: datetime, moderated_by: integer, state: string, url_name: string, rubric_l4_priority: boolean, rubric_l5_priority: boolean, paid_conditions: string, delivery_time: string, mainpage_position: integer, rand_sort: integer, product_group_id: integer, article: string, order_url: string, yml_id: string, deleted_at: datetime, measure_unit_id: integer, page_title: string, min_qty: integer, qty_measure_unit_id: integer, announce_valid: boolean, archived_at: datetime, created_by: integer, public_state: string, created_by_tool_type: , updated_by_tool_type: , user_traits: string, create_user_type: string, update_user_type: string, multi_group_id: integer, user_note: string, deleted_by_tool: )], :group=>:public_regions, :limit=>5000, :page=>1, :rank_mode=>:none}]
  2. Sphinx [nil, {:with=>{:rubric_l3_id=>130683, :public_regions=>[1, 256], :state=>[1, 2, 3, 5], :public_state=>1, :is_company_public=>1, :has_geopoint=>0}, :sphinx_select=>" IF(regional_packet_sort.1 IS NOT NULL,\n INTEGER(regional_packet_sort.1),\n INTEGER(regional_packet_sort.256)\n)\n\n+ rate/100\n+ (actualized_at > 1495715510) AS virtual_ranking_factor\n,random_float() as random_f,FLOOR(price * standard_currency_rate * POW(10, round_precision - 10) + 0.5) / POW(10, round_precision - 10) AS converted_price,actualized_at > 1490963510 AS is_actual, IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\nAS virtual_regional_packet\n, (( IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\n) =\n 0) AS is_free\n,random_float() as random_f_in_group,IN(main_region_id, 1) AS boosted_region,sphinx_internal_id", :match_mode=>:extended2, :conditions=>{:rubrics_idx=>"rubric_l3_id_130683"}, :classes=>[Apress::Products::Product(id: integer, name: string, announce: string, description: text, company_id: integer, created_at: datetime, rubric_id: integer, is_public: boolean, regions: string, moderator_comment: text, position: integer, updated_by: integer, moderated_at: datetime, moderated_by: integer, state: string, url_name: string, rubric_l4_priority: boolean, rubric_l5_priority: boolean, paid_conditions: string, delivery_time: string, mainpage_position: integer, rand_sort: integer, product_group_id: integer, article: string, order_url: string, yml_id: string, deleted_at: datetime, measure_unit_id: integer, page_title: string, min_qty: integer, qty_measure_unit_id: integer, announce_valid: boolean, archived_at: datetime, created_by: integer, public_state: string, created_by_tool_type: , updated_by_tool_type: , user_traits: string, create_user_type: string, update_user_type: string, multi_group_id: integer, user_note: string, deleted_by_tool: )], :group=>:districts, :limit=>5000, :page=>1, :rank_mode=>:none}]
  3. Sphinx [nil, {:with=>{:rubric_l3_id=>130683, :public_regions=>[1, 256], :state=>[1, 2, 3, 5], :public_state=>1, :is_company_public=>1, :has_geopoint=>0}, :sphinx_select=>" IF(regional_packet_sort.1 IS NOT NULL,\n INTEGER(regional_packet_sort.1),\n INTEGER(regional_packet_sort.256)\n)\n\n+ rate/100\n+ (actualized_at > 1495715510) AS virtual_ranking_factor\n,random_float() as random_f,FLOOR(price * standard_currency_rate * POW(10, round_precision - 10) + 0.5) / POW(10, round_precision - 10) AS converted_price,actualized_at > 1490963510 AS is_actual, IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\nAS virtual_regional_packet\n, (( IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\n) =\n 0) AS is_free\n,random_float() as random_f_in_group,IN(main_region_id, 1) AS boosted_region,sphinx_internal_id", :match_mode=>:extended2, :conditions=>{:rubrics_idx=>"rubric_l3_id_130683"}, :classes=>[Apress::Products::Product(id: integer, name: string, announce: string, description: text, company_id: integer, created_at: datetime, rubric_id: integer, is_public: boolean, regions: string, moderator_comment: text, position: integer, updated_by: integer, moderated_at: datetime, moderated_by: integer, state: string, url_name: string, rubric_l4_priority: boolean, rubric_l5_priority: boolean, paid_conditions: string, delivery_time: string, mainpage_position: integer, rand_sort: integer, product_group_id: integer, article: string, order_url: string, yml_id: string, deleted_at: datetime, measure_unit_id: integer, page_title: string, min_qty: integer, qty_measure_unit_id: integer, announce_valid: boolean, archived_at: datetime, created_by: integer, public_state: string, created_by_tool_type: , updated_by_tool_type: , user_traits: string, create_user_type: string, update_user_type: string, multi_group_id: integer, user_note: string, deleted_by_tool: )], :group=>:nearest_subways, :limit=>5000, :page=>1, :rank_mode=>:none}]
  4. Sphinx [nil, {:with=>{:rubric_l3_id=>130683, :public_regions=>[1, 256], :state=>[1, 2, 3, 5], :public_state=>1, :is_company_public=>1, :has_geopoint=>0}, :sphinx_select=>" IF(regional_packet_sort.1 IS NOT NULL,\n INTEGER(regional_packet_sort.1),\n INTEGER(regional_packet_sort.256)\n)\n\n+ rate/100\n+ (actualized_at > 1495715510) AS virtual_ranking_factor\n,random_float() as random_f,FLOOR(price * standard_currency_rate * POW(10, round_precision - 10) + 0.5) / POW(10, round_precision - 10) AS converted_price,actualized_at > 1490963510 AS is_actual, IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\nAS virtual_regional_packet\n, (( IF(regional_packet.1 IS NOT NULL,\n INTEGER(regional_packet.1),\n INTEGER(regional_packet.256)\n )\n) =\n 0) AS is_free\n,random_float() as random_f_in_group,IN(main_region_id, 1) AS boosted_region,sphinx_internal_id", :match_mode=>:extended2, :conditions=>{:rubrics_idx=>"rubric_l3_id_130683"}, :classes=>[Apress::Products::Product(id: integer, name: string, announce: string, description: text, company_id: integer, created_at: datetime, rubric_id: integer, is_public: boolean, regions: string, moderator_comment: text, position: integer, updated_by: integer, moderated_at: datetime, moderated_by: integer, state: string, url_name: string, rubric_l4_priority: boolean, rubric_l5_priority: boolean, paid_conditions: string, delivery_time: string, mainpage_position: integer, rand_sort: integer, product_group_id: integer, article: string, order_url: string, yml_id: string, deleted_at: datetime, measure_unit_id: integer, page_title: string, min_qty: integer, qty_measure_unit_id: integer, announce_valid: boolean, archived_at: datetime, created_by: integer, public_state: string, created_by_tool_type: , updated_by_tool_type: , user_traits: string, create_user_type: string, update_user_type: string, multi_group_id: integer, user_note: string, deleted_by_tool: )], :group=>:cities, :limit=>5000, :page=>1, :rank_mode=>:none}]
  5. Sphinx Query (8.5ms) Bundled Query
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!