Басқатырғыштар

DEBUG enable
Num SQL queries:227
Num fetched rows:4323
including array rows:32
Time of script run:0.54406404495239
Time of SQL queries:0.39569091796875
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0031с
Счетчик "ModIshopTree tree data", время выполнения - 0.0005с
Счетчик "ModIshopTree breads", время выполнения - 0.0005с
Счетчик "ModIshopTree treecache", время выполнения - 0.0963с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.2508с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0053с
Счетчик "ModIshopTree treesort", время выполнения - 0.0001с
Счетчик "ModIshopTree filters", время выполнения - 0.1549с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0002с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.5132с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=topper", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0008с
Счетчик "Block=header", время выполнения - 0.0006с
Счетчик "Block=catalogtree", время выполнения - 0.0006с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0001с
Счетчик "Block=advert", время выполнения - 0.0001с
Счетчик "Block=subscribe", время выполнения - 0.0002с
Счетчик "Block=footer", время выполнения - 0.0006с
Счетчик "Block=retailrocket", время выполнения - 0.0002с
Счетчик "Block=metrika", время выполнения - 0.0002с
Счетчик "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.00042891502380371

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

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

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

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



SELECT t3.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=3811876809; # Num rows 1Run time:Time of run:0.00046682357788086



SELECT t1.id_tree,t1_kz.treename,t2.id_tree,t2_kz.treename,t3.id_tree,t3_kz.treename,t4.id_tree,t4_kz.treename,t5.id_tree,t5_kz.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=3811876809 # Num rows 1Run time:Time of run:0.00045084953308105



SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811876809 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00040602684020996

SELECT * FROM leo_tree WHERE id_tree=3811876809 # Num rows 1Run time:Time of run:0.00030303001403809

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811876809 # Num rows 1Run time:Time of run:0.00029110908508301

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.0003199577331543

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811876809) GROUP BY t2.id_detail # Num rows 60Run time:Time of run:0.094521999359131



SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811735609 ORDER BY t1.pos # Num rows 11Run time:Time of run:0.00067400932312012

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925339 ORDER BY t1.pos # Num rows 9Run time:Time of run:0.00063586235046387

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811819509 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0006248950958252

SELECT * FROM leo_tree WHERE id_tree=3811819509 # Num rows 1Run time:Time of run:0.00074100494384766

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811819509 # Num rows 1Run time:Time of run:0.00043511390686035

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00070595741271973

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811819509) GROUP BY t2.id_detail # Num rows 3Run time:Time of run:0.0094020366668701

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925340 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00063705444335938

SELECT * FROM leo_tree WHERE id_tree=9538925340 # Num rows 1Run time:Time of run:0.00044512748718262

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925340 # Num rows 1Run time:Time of run:0.00049686431884766

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.0005340576171875

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925340) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.0031440258026123

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925345 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00049400329589844

SELECT * FROM leo_tree WHERE id_tree=9538925345 # Num rows 1Run time:Time of run:0.00042891502380371

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925345 # Num rows 1Run time:Time of run:0.00040006637573242

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.0004119873046875

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925345) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.0016169548034668

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925341 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0006110668182373

SELECT * FROM leo_tree WHERE id_tree=9538925341 # Num rows 1Run time:Time of run:0.00047993659973145

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925341 # Num rows 1Run time:Time of run:0.00053000450134277

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00067996978759766

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925341) GROUP BY t2.id_detail # Num rows 3Run time:Time of run:0.0037980079650879

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925342 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00065398216247559

SELECT * FROM leo_tree WHERE id_tree=9538925342 # Num rows 1Run time:Time of run:0.00060486793518066

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925342 # Num rows 1Run time:Time of run:0.00040483474731445

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00052404403686523

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925342) GROUP BY t2.id_detail # Num rows 27Run time:Time of run:0.0027449131011963

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925343 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00058197975158691

SELECT * FROM leo_tree WHERE id_tree=9538925343 # Num rows 1Run time:Time of run:0.00045299530029297

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925343 # Num rows 1Run time:Time of run:0.00051593780517578

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00059008598327637

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925343) GROUP BY t2.id_detail # Num rows 5Run time:Time of run:0.0016210079193115

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925389 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00061416625976562

SELECT * FROM leo_tree WHERE id_tree=9538925389 # Num rows 1Run time:Time of run:0.0004420280456543

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925389 # Num rows 1Run time:Time of run:0.00051403045654297

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00056982040405273

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925389) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.00085806846618652

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811234009 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00064706802368164

SELECT * FROM leo_tree WHERE id_tree=3811234009 # Num rows 1Run time:Time of run:0.00055503845214844

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811234009 # Num rows 1Run time:Time of run:0.00043392181396484

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00057101249694824

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811234009) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.0022819042205811

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811858609 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00058507919311523

SELECT * FROM leo_tree WHERE id_tree=3811858609 # Num rows 1Run time:Time of run:0.0004420280456543

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811858609 # Num rows 1Run time:Time of run:0.00045514106750488

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00043511390686035

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811858609) GROUP BY t2.id_detail # Num rows 108Run time:Time of run:0.016136169433594

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811878609 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0006248950958252

SELECT * FROM leo_tree WHERE id_tree=3811878609 # Num rows 1Run time:Time of run:0.00064611434936523

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811878609 # Num rows 1Run time:Time of run:0.0005190372467041

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00048422813415527

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811878609) GROUP BY t2.id_detail # Num rows 333Run time:Time of run:0.032424926757812

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811885809 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00045609474182129

SELECT * FROM leo_tree WHERE id_tree=3811885809 # Num rows 1Run time:Time of run:0.00033783912658691

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811885809 # Num rows 1Run time:Time of run:0.00032615661621094

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00034904479980469

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811885809) GROUP BY t2.id_detail # Num rows 311Run time:Time of run:0.032289981842041

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538924523 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00039005279541016

SELECT * FROM leo_tree WHERE id_tree=9538924523 # Num rows 1Run time:Time of run:0.00031709671020508

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538924523 # Num rows 1Run time:Time of run:0.00033378601074219

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00034785270690918

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538924523) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.0014729499816895

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811874809 ORDER BY t1.pos # Num rows 11Run time:Time of run:0.00043892860412598

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925384 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0003821849822998

SELECT * FROM leo_tree WHERE id_tree=9538925384 # Num rows 1Run time:Time of run:0.00031399726867676

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925384 # Num rows 1Run time:Time of run:0.00029087066650391

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00032901763916016

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925384) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.0006709098815918

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925387 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00037288665771484

SELECT * FROM leo_tree WHERE id_tree=9538925387 # Num rows 1Run time:Time of run:0.00031495094299316

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925387 # Num rows 1Run time:Time of run:0.00033998489379883

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.0003659725189209

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925387) GROUP BY t2.id_detail # Num rows 5Run time:Time of run:0.0015699863433838

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925393 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00052809715270996

SELECT * FROM leo_tree WHERE id_tree=9538925393 # Num rows 1Run time:Time of run:0.00033092498779297

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925393 # Num rows 1Run time:Time of run:0.00029110908508301

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.0003049373626709

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925393) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.00052404403686523

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925390 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00034093856811523

SELECT * FROM leo_tree WHERE id_tree=9538925390 # Num rows 1Run time:Time of run:0.00033903121948242

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925390 # Num rows 1Run time:Time of run:0.00032401084899902

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00032591819763184

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925390) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.00060892105102539

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925385 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00033688545227051

SELECT * FROM leo_tree WHERE id_tree=9538925385 # Num rows 1Run time:Time of run:0.00031304359436035

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925385 # Num rows 1Run time:Time of run:0.00029206275939941

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00031495094299316

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925385) GROUP BY t2.id_detail # Num rows 21Run time:Time of run:0.0022261142730713

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811868409 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00039911270141602

SELECT * FROM leo_tree WHERE id_tree=3811868409 # Num rows 1Run time:Time of run:0.00030708312988281

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811868409 # Num rows 1Run time:Time of run:0.00033712387084961

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00032496452331543

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811868409) GROUP BY t2.id_detail # Num rows 142Run time:Time of run:0.0085740089416504

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925386 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00038790702819824

SELECT * FROM leo_tree WHERE id_tree=9538925386 # Num rows 1Run time:Time of run:0.00033092498779297

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925386 # Num rows 1Run time:Time of run:0.00047802925109863

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00044798851013184

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925386) GROUP BY t2.id_detail # Num rows 17Run time:Time of run:0.0054101943969727

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925391 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00040006637573242

SELECT * FROM leo_tree WHERE id_tree=9538925391 # Num rows 1Run time:Time of run:0.00034093856811523

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925391 # Num rows 1Run time:Time of run:0.00030612945556641

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00033879280090332

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925391) GROUP BY t2.id_detail # Num rows 28Run time:Time of run:0.0041921138763428

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925388 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00039100646972656

SELECT * FROM leo_tree WHERE id_tree=9538925388 # Num rows 1Run time:Time of run:0.00031590461730957

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925388 # Num rows 1Run time:Time of run:0.00038313865661621

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00035786628723145

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925388) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.00076603889465332

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925392 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00038790702819824

SELECT * FROM leo_tree WHERE id_tree=9538925392 # Num rows 1Run time:Time of run:0.00030112266540527

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925392 # Num rows 1Run time:Time of run:0.00027894973754883

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00035190582275391

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925392) GROUP BY t2.id_detail # Num rows 3Run time:Time of run:0.00081586837768555

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925400 ORDER BY t1.pos # Num rows 4Run time:Time of run:0.00038599967956543

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811798809 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00043106079101562

SELECT * FROM leo_tree WHERE id_tree=3811798809 # Num rows 1Run time:Time of run:0.00030112266540527

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811798809 # Num rows 1Run time:Time of run:0.00027608871459961

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00034499168395996

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811798809) GROUP BY t2.id_detail # Num rows 82Run time:Time of run:0.004148006439209

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925528 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00041508674621582

SELECT * FROM leo_tree WHERE id_tree=9538925528 # Num rows 1Run time:Time of run:0.00030088424682617

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3870322009 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00034284591674805

SELECT * FROM leo_tree WHERE id_tree=3870322009 # Num rows 1Run time:Time of run:0.00030207633972168

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3870322009 # Num rows 1Run time:Time of run:0.00024700164794922

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00030708312988281

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3870322009) GROUP BY t2.id_detail # Num rows 7Run time:Time of run:0.00088000297546387

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=3811743109 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00035905838012695

SELECT * FROM leo_tree WHERE id_tree=3811743109 # Num rows 1Run time:Time of run:0.00031709671020508

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811743109 # Num rows 1Run time:Time of run:0.00027203559875488

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00032901763916016

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=3811743109) GROUP BY t2.id_detail # Num rows 789Run time:Time of run:0.038201808929443

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925609 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0004570484161377

SELECT * FROM leo_tree WHERE id_tree=9538925609 # Num rows 1Run time:Time of run:0.00034189224243164

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925609 # Num rows 1Run time:Time of run:0.0003509521484375

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00037693977355957

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925609) GROUP BY t2.id_detail # Num rows 34Run time:Time of run:0.0030629634857178

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925405 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00038599967956543

SELECT * FROM leo_tree WHERE id_tree=9538925405 # Num rows 1Run time:Time of run:0.0004119873046875

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925405 # Num rows 1Run time:Time of run:0.00087094306945801

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00035285949707031

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925405) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.0049459934234619

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925209 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00051403045654297

SELECT * FROM leo_tree WHERE id_tree=9538925209 # Num rows 1Run time:Time of run:0.00029516220092773

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925209 # Num rows 1Run time:Time of run:0.0002748966217041

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00038409233093262

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925209) GROUP BY t2.id_detail # Num rows 3Run time:Time of run:0.0010890960693359

SELECT SQL_NO_CACHE t1.id_tree,t2.treename FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo_kz.leo_tree_translate AS t2 ON (t1.id_tree=t2.id_tree) WHERE t2.id_tree IS NOT NULL AND t1.shop_tree_id=9538925280 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00040316581726074

SELECT * FROM leo_tree WHERE id_tree=9538925280 # Num rows 1Run time:Time of run:0.00033903121948242

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925280 # Num rows 1Run time:Time of run:0.00060200691223145

SELECT dep_id FROM leo_shops WHERE id_city=51 /*AND work=1*/ AND dep_id>0 # Num rows 2Run time:Time of run:0.00036001205444336

SELECT SQL_NO_CACHE t2.id_good,t2.id_detail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_details AS t2,leonardo.tis_dep AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t2.id_good AND t2.id_detail=t3.code AND (t3.dep_id=402 OR t3.dep_id=402 OR t3.dep_id=403) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538925280) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.00058507919311523



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





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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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=32749594402 # Num rows 2011Run time:Time of run:0.036943912506104











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

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