DEBUG enable
Num SQL queries:167
Num fetched rows:1315
including array rows:3
Time of script run:0.59718585014343
Time of SQL queries:0.13464975357056
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.002с
Счетчик "ModIshopTree tree data", время выполнения - 0.0011с
Счетчик "ModIshopTree breads", время выполнения - 0.0047с
Счетчик "ModIshopTree treecache", время выполнения - 0.0004с
Счетчик "ModIshopTree leftmenu", время выполнения - 0с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0852с
Счетчик "ModIshopTree treesort", время выполнения - 0.0006с
Счетчик "ModIshopTree filters", время выполнения - 0.4583с
Счетчик "ModIshopTree design", время выполнения - 0.0002с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0003с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.5633с
Счетчик "Block=stat", время выполнения - 0.0002с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0012с
Счетчик "Block=header", время выполнения - 0.0003с
Счетчик "Block=catalogtree", время выполнения - 0.001с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0002с
Счетчик "Block=advert", время выполнения - 0.0002с
Счетчик "Block=subscribe", время выполнения - 0.0003с
Счетчик "Block=footer", время выполнения - 0.0003с
Счетчик "Block=retailrocket", время выполнения - 0.0003с
Счетчик "Block=metrika", время выполнения - 0.0003с
Счетчик "Block=ganalitics", время выполнения - 0.0003с
Счетчик "Block=statmailru", время выполнения - 0.0003с
Счетчик "Block=jivosite", время выполнения - 0.0003с

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

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.0001380443572998

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

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.0001680850982666

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



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=1457724362; # Num rows 1Run time:Time of run:0.0011191368103027



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=1457724362 # Num rows 1Run time:Time of run:0.0046060085296631







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

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=263235341 LIMIT 1; # Num rows 1Run time:Time of run:0.0011270046234131

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

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=263238381 LIMIT 1; # Num rows 1Run time:Time of run:0.0014679431915283

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

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=1396614692 LIMIT 1; # Num rows 1Run time:Time of run:0.0004727840423584

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

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=5449045052 LIMIT 1; # Num rows 1Run time:Time of run:0.0012249946594238

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=5449045052 AND id_city=46 # 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=5449055802 LIMIT 1; # Num rows 1Run time:Time of run:0.00045990943908691

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

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_ru.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=50576011 AND t1.id_good=t2.id_good AND t1_ru.id_detail=50576011 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0024189949035645

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

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_ru.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=3570305092 AND t1.id_good=t2.id_good AND t1_ru.id_detail=3570305092 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0020010471343994

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

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_ru.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=6690812982 AND t1.id_good=t2.id_good AND t1_ru.id_detail=6690812982 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0028510093688965

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

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_ru.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=14022454032 AND t1.id_good=t2.id_good AND t1_ru.id_detail=14022454032 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0013489723205566

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

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_ru.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=15708486102 AND t1.id_good=t2.id_good AND t1_ru.id_detail=15708486102 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0025041103363037

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

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_ru.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=15708891532 AND t1.id_good=t2.id_good AND t1_ru.id_detail=15708891532 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0012080669403076

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

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_ru.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=15709103722 AND t1.id_good=t2.id_good AND t1_ru.id_detail=15709103722 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0014030933380127

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

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_ru.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=15709225952 AND t1.id_good=t2.id_good AND t1_ru.id_detail=15709225952 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.00049400329589844

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

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_ru.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=18683760782 AND t1.id_good=t2.id_good AND t1_ru.id_detail=18683760782 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0012378692626953

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

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=52035063272 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=52035063272 AND id_city=46 # Num rows 1Run time:Time of run:0.00026798248291016

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_ru.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=53331587942 AND t1.id_good=t2.id_good AND t1_ru.id_detail=53331587942 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0041229724884033

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

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_ru.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=56672240492 AND t1.id_good=t2.id_good AND t1_ru.id_detail=56672240492 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0029709339141846

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

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=12293906182 LIMIT 1; # Num rows 1Run time:Time of run:0.00049805641174316

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

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=12294073202 LIMIT 1; # Num rows 1Run time:Time of run:0.00044393539428711

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

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=12294152122 LIMIT 1; # Num rows 1Run time:Time of run:0.00096702575683594

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

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=12331161 LIMIT 1; # Num rows 1Run time:Time of run:0.0010879039764404

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

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=17468007162 LIMIT 1; # Num rows 1Run time:Time of run:0.00044679641723633

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

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=17468599622 LIMIT 1; # Num rows 1Run time:Time of run:0.0005500316619873

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

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=17468616412 LIMIT 1; # Num rows 1Run time:Time of run:0.00044584274291992

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=17468616412 LIMIT 1; # Num rows 1Run time:Time of run:0.012237787246704

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

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=17468654392 LIMIT 1; # Num rows 1Run time:Time of run:0.00049281120300293

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=17468654392 LIMIT 1; # Num rows 1Run time:Time of run:0.00032305717468262

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

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=20056612052 LIMIT 1; # Num rows 1Run time:Time of run:0.0005338191986084

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





SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=263235341 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00085902214050293

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=263238381 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00042605400085449

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=1396614692 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00049710273742676

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=5449045052 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 0Run time:Time of run:0.00042486190795898

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=5449055802 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00043702125549316

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=50576011 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00055193901062012

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=3570305092 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00048089027404785

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=6690812982 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00041389465332031

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=14022454032 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00043392181396484

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=15708486102 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00043988227844238

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=15708891532 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00037503242492676

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=15709103722 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.0003819465637207

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=15709225952 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00037193298339844

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=18683760782 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00039291381835938

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=52035063272 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00049614906311035

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53331587942 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 0Run time:Time of run:0.00042200088500977

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=56672240492 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00039100646972656

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=1553274032 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00062990188598633

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=1553326462 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00037693977355957

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=19857713602 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.0004730224609375

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=20060788952 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00045990943908691

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=20063714022 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00041890144348145

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=20066069782 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00044703483581543

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=11854323422 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00046420097351074

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=11854384952 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 0Run time:Time of run:0.00041103363037109

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=11854402052 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00041103363037109

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=11854932992 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.0003809928894043

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=12293906182 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00043106079101562

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=12294073202 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00037598609924316

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=12294152122 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00047206878662109

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=12331161 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00039410591125488

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=17468007162 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00048494338989258

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=17468599622 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00038504600524902

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=17468616412 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00041604042053223

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=17468654392 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00039100646972656

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=883867352 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00043702125549316

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=5171021092 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00038814544677734

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=27606319512 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00039792060852051

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=27606861092 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00040102005004883

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=27607032942 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 0Run time:Time of run:0.00037908554077148

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=27851540532 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00038290023803711

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=29806780112 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00049090385437012

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=30452982622 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.0057120323181152

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53953509972 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00041484832763672

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53954155862 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00040698051452637

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53954535602 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.0028080940246582

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53955315192 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00051689147949219

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53955534242 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00038886070251465

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53955697962 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 0Run time:Time of run:0.00037789344787598

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=20056612052 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00051403045654297

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=2955037022 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00045299530029297

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=18135433752 AND t1.dep_id=t2.dep_id AND t2.id_city=46 AND t1.sizes>0 GROUP BY dep_id # Num rows 1Run time:Time of run:0.00055599212646484

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=263235341 # Num rows 403Run time:Time of run:0.0019259452819824

SELECT id_detail FROM leo_details WHERE id_good=263238381 # Num rows 271Run time:Time of run:0.00075602531433105

SELECT id_detail FROM leo_details WHERE id_good=1396614692 # Num rows 11Run time:Time of run:0.00046610832214355

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

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

SELECT id_detail FROM leo_details WHERE id_good=52035063272 # Num rows 7Run time:Time of run:0.00027680397033691

SELECT id_detail FROM leo_details WHERE id_good=1553274032 # Num rows 200Run time:Time of run:0.00057005882263184

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

SELECT id_detail FROM leo_details WHERE id_good=19857713602 # Num rows 21Run time:Time of run:0.00030303001403809

SELECT id_detail FROM leo_details WHERE id_good=20060788952 # Num rows 24Run time:Time of run:0.0003359317779541

SELECT id_detail FROM leo_details WHERE id_good=20063714022 # Num rows 15Run time:Time of run:0.00032401084899902

SELECT id_detail FROM leo_details WHERE id_good=20066069782 # Num rows 16Run time:Time of run:0.00074195861816406

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

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

SELECT id_detail FROM leo_details WHERE id_good=11854402052 # Num rows 8Run time:Time of run:0.0010108947753906

SELECT id_detail FROM leo_details WHERE id_good=11854932992 # Num rows 14Run time:Time of run:0.0013020038604736

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

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

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

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

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

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=883867352 # Num rows 11Run time:Time of run:0.00071406364440918

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

SELECT id_detail FROM leo_details WHERE id_good=20056612052 # Num rows 35Run time:Time of run:0.00061678886413574

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

SELECT id_detail FROM leo_details WHERE id_good=18135433752 # Num rows 16Run time:Time of run:0.00049781799316406

SELECT leo_shops.* ,leo_metro_lines.line_class as lineclass FROM leo_shops LEFT JOIN leo_metro_lines ON (leo_metro_lines.id = leo_shops.metro_line) WHERE leo_shops.id_city=46 AND dep_id>0 AND work=1 # Num rows 1Run time:Time of run:0.00018692016601562