Маркеры

DEBUG enable
Num SQL queries:186
Num fetched rows:1201
including array rows:1
Time of script run:0.54073905944824
Time of SQL queries:0.14167213439941
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0059с
Счетчик "ModIshopTree tree data", время выполнения - 0.0006с
Счетчик "ModIshopTree breads", время выполнения - 0.0008с
Счетчик "ModIshopTree treecache", время выполнения - 0.0008с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0004с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.1439с
Счетчик "ModIshopTree treesort", время выполнения - 0.0002с
Счетчик "ModIshopTree filters", время выполнения - 0.3373с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0003с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.4992с
Счетчик "Block=stat", время выполнения - 0.0002с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=topper", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0008с
Счетчик "Block=header", время выполнения - 0.0007с
Счетчик "Block=catalogtree", время выполнения - 0.0019с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0001с
Счетчик "Block=advert", время выполнения - 0.0002с
Счетчик "Block=subscribe", время выполнения - 0.0002с
Счетчик "Block=footer", время выполнения - 0.0007с
Счетчик "Block=retailrocket", время выполнения - 0.0002с
Счетчик "Block=metrika", время выполнения - 0.0003с
Счетчик "Block=ganalitics", время выполнения - 0.0002с
Счетчик "Block=statmailru", время выполнения - 0.0002с
Счетчик "Block=jivosite", время выполнения - 0.0002с

SELECT id_city,path,name,ishop_id,ishop_name,kladr_id FROM leo_city WHERE path='almaty'; # Num rows 1Run time:Time of run:0.0013511180877686

SELECT index_id,title,domen FROM leonardo_kz.leo_index WHERE parent_index_id=0 AND alias LIKE 'ishop' LIMIT 1; # Num rows 1Run time:Time of run:0.00083303451538086

SELECT index_id,title,domen FROM leonardo_kz.leo_index WHERE parent_index_id=2 AND alias LIKE 'tree_3727272909' LIMIT 1; # Num rows 0Run time:Time of run:0.00097799301147461

SELECT title,template_id,content,domen,index_id FROM leonardo_kz.leo_index WHERE index_id=2; # Num rows 1Run time:Time of run:0.00031304359436035

SELECT html FROM leonardo_kz.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00037598609924316



SELECT t1.treename,t2.treetype,t2.tree_description,t2.tree_meta_description,t1.shop_tree_id,t1.level1,t1.level2,t1.level3,t1.relatedtree,t2.titletag,t2.tree_notice,t2.h1tag,t2.maintitledisable FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo.leo_tree_description AS t2 ON t1.id_tree=t2.tree_id LEFT JOIN leonardo_kz.leo_tree_translate AS t3 ON (t1.id_tree=t3.id_tree) WHERE t3.id_tree IS NOT NULL AND t1.id_tree=3727272909; # Num rows 1Run time:Time of run:0.00062298774719238



SELECT t1.id_tree,t1.treename,t2.id_tree,t2.treename,t3.id_tree,t3.treename,t4.id_tree,t4.treename,t5.id_tree,t5.treename FROM leo_tree AS t1 LEFT JOIN leo_tree AS t2 ON t1.shop_tree_id=t2.id_tree LEFT JOIN leo_tree AS t3 ON t2.shop_tree_id=t3.id_tree LEFT JOIN leo_tree AS t4 ON t3.shop_tree_id=t4.id_tree LEFT JOIN leo_tree AS t5 ON t4.shop_tree_id=t5.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t1_kz ON t1.id_tree=t1_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t2_kz ON t1.shop_tree_id=t2_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t3_kz ON t2.shop_tree_id=t3_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t4_kz ON t3.shop_tree_id=t4_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t5_kz ON t4.shop_tree_id=t5_kz.id_tree WHERE t1.id_tree=3727272909 # Num rows 1Run time:Time of run:0.00070595741271973







SELECT filter_class,indexed,opened FROM leonardo.leo_tree_filters WHERE id_tree= '3727272909' ORDER BY pos ASC; # Num rows 17Run time:Time of run:0.00054812431335449

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=17014864122 LIMIT 1; # Num rows 1Run time:Time of run:0.00054192543029785

SELECT SQL_NO_CACHE t1.id_good,t1_ru.detailname,t1.id_detail,t1.prepic,t1.detailsrating FROM leonardo_kz.leo_details AS t1 LEFT JOIN leonardo.leo_details AS t1_ru ON (t1.id_detail = t1_ru.id_detail) WHERE t1_ru.detailname IS NOT NULL AND t1.id_good=17014864122 LIMIT 1; # Num rows 1Run time:Time of run:0.0014960765838623

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=17014865682 AND id_city=51 # Num rows 1Run time:Time of run:0.00075292587280273

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=31740323662 LIMIT 1; # Num rows 1Run time:Time of run:0.0016191005706787

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=31740323662 AND id_city=51 # Num rows 1Run time:Time of run:0.00038003921508789

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=31743448612 AND t1.id_good=t2.id_good AND t1_ru.id_detail=31743448612 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0010430812835693

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=31743448612 AND id_city=51 # Num rows 1Run time:Time of run:0.00057601928710938

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=52556319962 AND t1.id_good=t2.id_good AND t1_ru.id_detail=52556319962 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0018348693847656

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=52556319962 AND id_city=51 # Num rows 1Run time:Time of run:0.0014188289642334

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=33604500482 LIMIT 1; # Num rows 1Run time:Time of run:0.0012161731719971

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=33604500482 AND id_city=51 # Num rows 1Run time:Time of run:0.00051188468933105

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=33604653362 AND t1.id_good=t2.id_good AND t1_ru.id_detail=33604653362 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0023050308227539

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=33604653362 AND id_city=51 # Num rows 1Run time:Time of run:0.00034809112548828

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=33865328582 LIMIT 1; # Num rows 1Run time:Time of run:0.0014421939849854

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=33865328582 AND id_city=51 # Num rows 1Run time:Time of run:0.0016078948974609

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35857819952 LIMIT 1; # Num rows 1Run time:Time of run:0.00045585632324219

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=35857819952 AND id_city=51 # Num rows 1Run time:Time of run:0.00045204162597656

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35859260152 LIMIT 1; # Num rows 1Run time:Time of run:0.00058603286743164

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=35859260152 AND id_city=51 # Num rows 1Run time:Time of run:0.0003669261932373

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35861226922 LIMIT 1; # Num rows 1Run time:Time of run:0.00053691864013672

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=35861226922 AND id_city=51 # Num rows 1Run time:Time of run:0.00030803680419922

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35861378382 LIMIT 1; # Num rows 1Run time:Time of run:0.00050115585327148

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=35861378382 AND id_city=51 # Num rows 1Run time:Time of run:0.00039887428283691

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36574387422 LIMIT 1; # Num rows 1Run time:Time of run:0.0034389495849609

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=36574387422 AND id_city=51 # Num rows 1Run time:Time of run:0.00032997131347656

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36577492272 LIMIT 1; # Num rows 1Run time:Time of run:0.00075078010559082

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=36577492272 AND id_city=51 # Num rows 1Run time:Time of run:0.000640869140625

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36578179802 LIMIT 1; # Num rows 1Run time:Time of run:0.00054407119750977

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=36578179802 AND id_city=51 # Num rows 1Run time:Time of run:0.00035381317138672

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36580459512 LIMIT 1; # Num rows 1Run time:Time of run:0.00065302848815918

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=36580459512 AND id_city=51 # Num rows 1Run time:Time of run:0.00040578842163086

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36645024982 LIMIT 1; # Num rows 1Run time:Time of run:0.00068020820617676

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=36645024982 AND id_city=51 # Num rows 1Run time:Time of run:0.00029993057250977

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=64233685284 LIMIT 1; # Num rows 1Run time:Time of run:0.00045299530029297

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=64233685284 AND id_city=51 # Num rows 1Run time:Time of run:0.00042605400085449

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=64233903474 LIMIT 1; # Num rows 1Run time:Time of run:0.00054287910461426

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=64233903474 AND id_city=51 # Num rows 1Run time:Time of run:0.00037407875061035

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=64235161464 LIMIT 1; # Num rows 1Run time:Time of run:0.00048208236694336

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=64235161464 AND id_city=51 # Num rows 1Run time:Time of run:0.00036907196044922

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=64235370584 LIMIT 1; # Num rows 1Run time:Time of run:0.00046801567077637

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=64235370584 AND id_city=51 # Num rows 1Run time:Time of run:0.00042581558227539

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=64770070074 LIMIT 1; # Num rows 1Run time:Time of run:0.00043511390686035

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=64770070074 AND id_city=51 # Num rows 1Run time:Time of run:0.00033402442932129

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=64770754624 LIMIT 1; # Num rows 1Run time:Time of run:0.00058603286743164

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=64770754624 AND id_city=51 # Num rows 1Run time:Time of run:0.00026893615722656

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=68512850164 AND t1.id_good=t2.id_good AND t1_ru.id_detail=68512850164 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.00055193901062012

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=68512850164 AND id_city=51 # Num rows 1Run time:Time of run:0.00030779838562012

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=69077127844 LIMIT 1; # Num rows 1Run time:Time of run:0.00050783157348633

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=69077127844 AND id_city=51 # Num rows 1Run time:Time of run:0.00033688545227051

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=69184601014 AND t1.id_good=t2.id_good AND t1_ru.id_detail=69184601014 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0013220310211182

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=69184601014 AND id_city=51 # Num rows 1Run time:Time of run:0.00037288665771484

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=69437606714 AND t1.id_good=t2.id_good AND t1_ru.id_detail=69437606714 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.000885009765625

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=69437606714 AND id_city=51 # Num rows 1Run time:Time of run:0.00032901763916016

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=69455005004 LIMIT 1; # Num rows 1Run time:Time of run:0.0019209384918213

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=69455005004 AND id_city=51 # Num rows 1Run time:Time of run:0.00038504600524902

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=70246741104 LIMIT 1; # Num rows 1Run time:Time of run:0.00055384635925293

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=70246741104 AND id_city=51 # Num rows 1Run time:Time of run:0.0003509521484375

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=70248011144 LIMIT 1; # Num rows 1Run time:Time of run:0.0045380592346191

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=70248011144 AND id_city=51 # Num rows 1Run time:Time of run:0.00040197372436523

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=70613396264 LIMIT 1; # Num rows 1Run time:Time of run:0.00062203407287598

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=70613396264 AND id_city=51 # Num rows 1Run time:Time of run:0.00037908554077148

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=70621242834 LIMIT 1; # Num rows 1Run time:Time of run:0.00057482719421387

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=70621242834 AND id_city=51 # Num rows 1Run time:Time of run:0.00049996376037598

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=70886514514 LIMIT 1; # Num rows 1Run time:Time of run:0.004133939743042

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=70886514514 AND id_city=51 # Num rows 1Run time:Time of run:0.00056886672973633

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=70888122384 LIMIT 1; # Num rows 1Run time:Time of run:0.00054788589477539

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=70888122384 AND id_city=51 # Num rows 1Run time:Time of run:0.00035500526428223

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=71234789774 LIMIT 1; # Num rows 1Run time:Time of run:0.00047898292541504

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=71234789774 AND id_city=51 # Num rows 1Run time:Time of run:0.00036907196044922

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=71550351004 AND t1.id_good=t2.id_good AND t1_ru.id_detail=71550351004 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0083920955657959

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=71550351004 AND id_city=51 # Num rows 1Run time:Time of run:0.00033998489379883

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=73111602394 LIMIT 1; # Num rows 1Run time:Time of run:0.00056719779968262

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=73111602394 AND id_city=51 # Num rows 1Run time:Time of run:0.00040602684020996

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=73276911944 LIMIT 1; # Num rows 1Run time:Time of run:0.00053000450134277

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=73276911944 AND id_city=51 # Num rows 1Run time:Time of run:0.00053310394287109

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=73276949054 LIMIT 1; # Num rows 1Run time:Time of run:0.00050091743469238

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=73276949054 AND id_city=51 # Num rows 1Run time:Time of run:0.0011332035064697

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=73277148864 LIMIT 1; # Num rows 1Run time:Time of run:0.0010011196136475

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=73277148864 AND id_city=51 # Num rows 1Run time:Time of run:0.00049090385437012

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=73277152454 LIMIT 1; # Num rows 1Run time:Time of run:0.00069403648376465

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=73277152454 AND id_city=51 # Num rows 1Run time:Time of run:0.00041913986206055

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=73277328154 LIMIT 1; # Num rows 1Run time:Time of run:0.00053691864013672

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=73277328154 AND id_city=51 # Num rows 1Run time:Time of run:0.00033187866210938

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=73278239144 LIMIT 1; # Num rows 1Run time:Time of run:0.0010170936584473

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=73278239144 AND id_city=51 # Num rows 1Run time:Time of run:0.00027203559875488

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=76175142444 LIMIT 1; # Num rows 1Run time:Time of run:0.00048208236694336

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=76175142444 AND id_city=51 # Num rows 1Run time:Time of run:0.00034379959106445

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=79847505094 LIMIT 1; # Num rows 1Run time:Time of run:0.00087809562683105

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=79847505094 AND id_city=51 # Num rows 1Run time:Time of run:0.00035691261291504

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=79849071334 AND t1.id_good=t2.id_good AND t1_ru.id_detail=79849071334 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.00078606605529785

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=79849071334 AND id_city=51 # Num rows 1Run time:Time of run:0.00040316581726074

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=80634772954 AND t1.id_good=t2.id_good AND t1_ru.id_detail=80634772954 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0015268325805664

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=80634772954 AND id_city=51 # Num rows 1Run time:Time of run:0.00033688545227051

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=86225820914 LIMIT 1; # Num rows 1Run time:Time of run:0.0011301040649414

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=86225820914 AND id_city=51 # Num rows 1Run time:Time of run:0.0005040168762207

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=88367898674 LIMIT 1; # Num rows 1Run time:Time of run:0.0013430118560791

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=88367898674 AND id_city=51 # Num rows 1Run time:Time of run:0.00057101249694824

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=94084746774 LIMIT 1; # Num rows 1Run time:Time of run:0.00098705291748047

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=94084746774 AND id_city=51 # Num rows 1Run time:Time of run:0.00039196014404297

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=100130559784 LIMIT 1; # Num rows 1Run time:Time of run:0.00055980682373047

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=100130559784 AND id_city=51 # Num rows 1Run time:Time of run:0.0002748966217041

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=100132255704 LIMIT 1; # Num rows 1Run time:Time of run:0.00042891502380371

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=100132255704 AND id_city=51 # Num rows 1Run time:Time of run:0.00029587745666504

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=100134668594 LIMIT 1; # Num rows 1Run time:Time of run:0.0019919872283936

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=100134668594 AND id_city=51 # Num rows 1Run time:Time of run:0.0003509521484375

SELECT SQL_NO_CACHE t4.id_tree,t2_ru.goodname,t2_ru.gooddescr,t2.dimension,t2.f_tree_id,t2.nalozh,t2_ru.tis_fullname,t1_ru.detailname,t1.prepic,t1.detailsrating,t2.price,t3.good_id,t1.id_good FROM leonardo_kz.leo_details AS t1, leonardo.leo_details AS t1_ru, leonardo.leo_goods AS t2_ru, leonardo_kz.leo_goods AS t2 LEFT JOIN leo_goods_month AS t3 ON t2.id_good=t3.good_id LEFT JOIN leo_tree_goods AS t4 ON t2.id_good=t4.id_good WHERE t1.id_detail=109175724714 AND t1.id_good=t2.id_good AND t1_ru.id_detail=109175724714 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0009920597076416

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=109175724714 AND id_city=51 # Num rows 1Run time:Time of run:0.00034308433532715





SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=31743448612 # Num rows 1Run time:Time of run:0.0015008449554443

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=32239248382 # Num rows 1Run time:Time of run:0.00037717819213867

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=52556319962 # Num rows 1Run time:Time of run:0.00037479400634766

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=33604653362 # Num rows 1Run time:Time of run:0.00033020973205566

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=64234715674 # Num rows 1Run time:Time of run:0.00043296813964844

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=64234882574 # Num rows 1Run time:Time of run:0.00045299530029297

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=64235046264 # Num rows 1Run time:Time of run:0.00030398368835449

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=64235117894 # Num rows 1Run time:Time of run:0.00033116340637207

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=64772469144 # Num rows 1Run time:Time of run:0.00031709671020508

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=68512521694 # Num rows 1Run time:Time of run:0.00041007995605469

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=68512850164 # Num rows 1Run time:Time of run:0.00031089782714844

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=58961531262 # Num rows 1Run time:Time of run:0.0003199577331543

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=69184601014 # Num rows 1Run time:Time of run:0.00031685829162598

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=69437606714 # Num rows 1Run time:Time of run:0.0003809928894043

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=71549675674 # Num rows 1Run time:Time of run:0.00031614303588867

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=71550351004 # Num rows 1Run time:Time of run:0.00036501884460449

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=73921677304 # Num rows 1Run time:Time of run:0.00037598609924316

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=76194055154 # Num rows 1Run time:Time of run:0.00031089782714844

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=79846200364 # Num rows 1Run time:Time of run:0.00043392181396484

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=79848921764 # Num rows 1Run time:Time of run:0.00043988227844238

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=79849071334 # Num rows 1Run time:Time of run:0.00033688545227051

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=80634772954 # Num rows 1Run time:Time of run:0.00033998489379883

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=102148467494 # Num rows 1Run time:Time of run:0.00034403800964355

SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=109175724714 # Num rows 1Run time:Time of run:0.00033712387084961

SELECT id_detail FROM leo_details WHERE id_good=17014864122 # Num rows 1Run time:Time of run:0.0062839984893799

SELECT id_detail FROM leo_details WHERE id_good=31740323662 # Num rows 3Run time:Time of run:0.0004880428314209

SELECT id_detail FROM leo_details WHERE id_good=33604500482 # Num rows 6Run time:Time of run:0.00029802322387695

SELECT id_detail FROM leo_details WHERE id_good=33865328582 # Num rows 4Run time:Time of run:0.00037622451782227

SELECT id_detail FROM leo_details WHERE id_good=35857819952 # Num rows 10Run time:Time of run:0.00049090385437012

SELECT id_detail FROM leo_details WHERE id_good=35859260152 # Num rows 23Run time:Time of run:0.00061607360839844

SELECT id_detail FROM leo_details WHERE id_good=35861226922 # Num rows 10Run time:Time of run:0.00047183036804199

SELECT id_detail FROM leo_details WHERE id_good=35861378382 # Num rows 10Run time:Time of run:0.00033807754516602

SELECT id_detail FROM leo_details WHERE id_good=36574387422 # Num rows 10Run time:Time of run:0.00058817863464355

SELECT id_detail FROM leo_details WHERE id_good=36577492272 # Num rows 18Run time:Time of run:0.0003969669342041

SELECT id_detail FROM leo_details WHERE id_good=36578179802 # Num rows 10Run time:Time of run:0.00058102607727051

SELECT id_detail FROM leo_details WHERE id_good=36580459512 # Num rows 5Run time:Time of run:0.00048303604125977

SELECT id_detail FROM leo_details WHERE id_good=36645024982 # Num rows 2Run time:Time of run:0.00047993659973145

SELECT id_detail FROM leo_details WHERE id_good=64233685284 # Num rows 6Run time:Time of run:0.00041103363037109

SELECT id_detail FROM leo_details WHERE id_good=64233903474 # Num rows 9Run time:Time of run:0.00059294700622559

SELECT id_detail FROM leo_details WHERE id_good=64235161464 # Num rows 6Run time:Time of run:0.0004122257232666

SELECT id_detail FROM leo_details WHERE id_good=64235370584 # Num rows 2Run time:Time of run:0.0005650520324707

SELECT id_detail FROM leo_details WHERE id_good=64770070074 # Num rows 12Run time:Time of run:0.00041294097900391

SELECT id_detail FROM leo_details WHERE id_good=64770754624 # Num rows 3Run time:Time of run:0.00035905838012695

SELECT id_detail FROM leo_details WHERE id_good=69077127844 # Num rows 2Run time:Time of run:0.00045108795166016

SELECT id_detail FROM leo_details WHERE id_good=69455005004 # Num rows 4Run time:Time of run:0.0011320114135742

SELECT id_detail FROM leo_details WHERE id_good=70246741104 # Num rows 2Run time:Time of run:0.00046992301940918

SELECT id_detail FROM leo_details WHERE id_good=70248011144 # Num rows 3Run time:Time of run:0.00039505958557129

SELECT id_detail FROM leo_details WHERE id_good=70613396264 # Num rows 3Run time:Time of run:0.00047206878662109

SELECT id_detail FROM leo_details WHERE id_good=70621242834 # Num rows 4Run time:Time of run:0.00043082237243652

SELECT id_detail FROM leo_details WHERE id_good=70886514514 # Num rows 2Run time:Time of run:0.00040793418884277

SELECT id_detail FROM leo_details WHERE id_good=70888122384 # Num rows 3Run time:Time of run:0.00044488906860352

SELECT id_detail FROM leo_details WHERE id_good=71234789774 # Num rows 9Run time:Time of run:0.00050592422485352

SELECT id_detail FROM leo_details WHERE id_good=73111602394 # Num rows 5Run time:Time of run:0.00064682960510254

SELECT id_detail FROM leo_details WHERE id_good=73276911944 # Num rows 4Run time:Time of run:0.00040698051452637

SELECT id_detail FROM leo_details WHERE id_good=73276949054 # Num rows 4Run time:Time of run:0.00051307678222656

SELECT id_detail FROM leo_details WHERE id_good=73277148864 # Num rows 3Run time:Time of run:0.00044703483581543

SELECT id_detail FROM leo_details WHERE id_good=73277152454 # Num rows 3Run time:Time of run:0.00051307678222656

SELECT id_detail FROM leo_details WHERE id_good=73277328154 # Num rows 4Run time:Time of run:0.00048398971557617

SELECT id_detail FROM leo_details WHERE id_good=73278239144 # Num rows 4Run time:Time of run:0.00047898292541504

SELECT id_detail FROM leo_details WHERE id_good=76175142444 # Num rows 4Run time:Time of run:0.00033903121948242

SELECT id_detail FROM leo_details WHERE id_good=76193674434 # Num rows 4Run time:Time of run:0.00053119659423828

SELECT id_detail FROM leo_details WHERE id_good=79847505094 # Num rows 4Run time:Time of run:0.00033688545227051

SELECT id_detail FROM leo_details WHERE id_good=86225820914 # Num rows 4Run time:Time of run:0.00045680999755859

SELECT id_detail FROM leo_details WHERE id_good=88367898674 # Num rows 32Run time:Time of run:0.00038886070251465

SELECT id_detail FROM leo_details WHERE id_good=94084746774 # Num rows 5Run time:Time of run:0.0011789798736572

SELECT id_detail FROM leo_details WHERE id_good=100130559784 # Num rows 5Run time:Time of run:0.0019550323486328

SELECT id_detail FROM leo_details WHERE id_good=100132255704 # Num rows 4Run time:Time of run:0.00042510032653809

SELECT id_detail FROM leo_details WHERE id_good=100134668594 # Num rows 2Run time:Time of run:0.00054216384887695

SELECT SQL_NO_CACHE id_good,leo_goods_params.value,id FROM leo_goods_params LEFT JOIN leo_filter_values FORCE INDEX (value_3) ON leo_goods_params.value=leo_filter_values.value WHERE id_param=9097393392 # Num rows 726Run time:Time of run:0.0070819854736328











SELECT phone FROM leonardo.leo_shops WHERE id_city = 51 AND work = 1 # Num rows 2Run time:Time of run:0.0003960132598877

SELECT phone FROM leonardo.leo_shops WHERE id_city = 51 AND work = 1 # Num rows 2Run time:Time of run:0.00041699409484863