Мұқабалар

DEBUG enable
Num SQL queries:209
Num fetched rows:1405
including array rows:33
Time of script run:0.39034008979797
Time of SQL queries:0.2062873840332
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0038с
Счетчик "ModIshopTree tree data", время выполнения - 0.0005с
Счетчик "ModIshopTree breads", время выполнения - 0.0006с
Счетчик "ModIshopTree treecache", время выполнения - 0.0052с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.1758с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0066с
Счетчик "ModIshopTree treesort", время выполнения - 0.0002с
Счетчик "ModIshopTree filters", время выполнения - 0.1648с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0003с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.3577с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=topper", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0009с
Счетчик "Block=header", время выполнения - 0.0005с
Счетчик "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.00052094459533691

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

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

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

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



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



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



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=9538925456 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00043702125549316

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

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

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

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=9538925456) GROUP BY t2.id_detail # Num rows 34Run time:Time of run:0.0032331943511963



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=3727030909 ORDER BY t1.pos # Num rows 13Run time:Time of run:0.00065398216247559

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=9538925351 ORDER BY t1.pos # Num rows 4Run time:Time of run:0.00052809715270996

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=9538925355 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00045204162597656

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

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

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=9538925355) GROUP BY t2.id_detail # Num rows 4Run time:Time of run:0.0031421184539795

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=9538925353 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00041794776916504

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

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

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

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=9538925353) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.00071978569030762

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=9538925354 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00042104721069336

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

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

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=9538925354) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.0020339488983154

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=9538925352 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00051498413085938

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

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

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

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=9538925352) GROUP BY t2.id_detail # Num rows 4Run time:Time of run:0.0011889934539795

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=3727111109 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00060081481933594

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

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

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

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=3727111109) GROUP BY t2.id_detail # Num rows 11Run time:Time of run:0.0040948390960693

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=3727132609 ORDER BY t1.pos # Num rows 4Run time:Time of run:0.00065708160400391

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=9538925452 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00046920776367188

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

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

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

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=9538925452) GROUP BY t2.id_detail # Num rows 10Run time:Time of run:0.001317024230957

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=9538925453 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00041890144348145

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

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

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

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=9538925453) GROUP BY t2.id_detail # Num rows 76Run time:Time of run:0.0072920322418213

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=9538925451 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00038003921508789

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

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

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

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=9538925451) GROUP BY t2.id_detail # Num rows 7Run time:Time of run:0.0011599063873291

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=9538925455 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00047087669372559

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

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

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

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=9538925455) GROUP BY t2.id_detail # Num rows 30Run time:Time of run:0.0023360252380371

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=3727339209 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00039410591125488

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

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

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

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=3727339209) GROUP BY t2.id_detail # Num rows 263Run time:Time of run:0.020601987838745

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=3727341909 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0027139186859131

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

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

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

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=3727341909) GROUP BY t2.id_detail # Num rows 7Run time:Time of run:0.0021820068359375

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=9538925556 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00055098533630371

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

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

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

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=9538925556) GROUP BY t2.id_detail # Num rows 13Run time:Time of run:0.0018720626831055

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=9538925348 ORDER BY t1.pos # Num rows 16Run 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=9538925349 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0004279613494873

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

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

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

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=9538925349) GROUP BY t2.id_detail # Num rows 5Run time:Time of run:0.0014510154724121

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=9538925360 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00045204162597656

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

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

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

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=9538925360) GROUP BY t2.id_detail # Num rows 6Run time:Time of run:0.0016748905181885

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=9538925244 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00070905685424805

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

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

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

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=9538925244) GROUP BY t2.id_detail # Num rows 8Run time:Time of run:0.0013740062713623

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=9538924849 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.000518798828125

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

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

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

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=9538924849) GROUP BY t2.id_detail # Num rows 35Run time:Time of run:0.00661301612854

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=3727275909 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00043416023254395

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

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

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

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=3727275909) GROUP BY t2.id_detail # Num rows 10Run time:Time of run:0.0031900405883789

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=9538925359 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00038886070251465

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

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

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=9538925359) GROUP BY t2.id_detail # Num rows 7Run time:Time of run:0.001356840133667

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=3727131209 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00052976608276367

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

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

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

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=3727131209) GROUP BY t2.id_detail # Num rows 18Run time:Time of run:0.0026149749755859

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=3727263509 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0004570484161377

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

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

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

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=3727263509) GROUP BY t2.id_detail # Num rows 121Run time:Time of run:0.011106967926025

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=9538925350 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00058889389038086

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

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

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

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=9538925350) GROUP BY t2.id_detail # Num rows 13Run time:Time of run:0.0039060115814209

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=3727323309 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00044798851013184

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

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

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

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=3727323309) GROUP BY t2.id_detail # Num rows 16Run time:Time of run:0.0019710063934326

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=9538924555 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00069713592529297

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

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

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

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=9538924555) GROUP BY t2.id_detail # Num rows 41Run time:Time of run:0.0031919479370117

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=9538925429 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00049400329589844

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

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

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

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=9538925429) GROUP BY t2.id_detail # Num rows 0Run time:Time of run:0.00054502487182617

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=9538925506 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00040793418884277

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

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

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

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=9538925506) GROUP BY t2.id_detail # Num rows 2Run 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=9538925358 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00037002563476562

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

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

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

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=9538925358) GROUP BY t2.id_detail # Num rows 7Run time:Time of run:0.0014810562133789

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=3727282709 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00036501884460449

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

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

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

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=3727282709) GROUP BY t2.id_detail # Num rows 10Run time:Time of run:0.0027480125427246

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=9538925347 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00043296813964844

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

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

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=9538925347) GROUP BY t2.id_detail # Num rows 31Run time:Time of run:0.00319504737854

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=9538925450 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0004580020904541

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

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

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

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=9538925450) GROUP BY t2.id_detail # Num rows 95Run time:Time of run:0.0069451332092285

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=3727335909 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.0004880428314209

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

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

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

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=3727335909) GROUP BY t2.id_detail # Num rows 2Run time:Time of run:0.0039670467376709

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=9538925553 ORDER BY t1.pos # Num rows 0Run time:Time of run:0.00037908554077148

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

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

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

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=9538925553) GROUP BY t2.id_detail # Num rows 3Run time:Time of run:0.00077390670776367



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





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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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=29391709612 # Num rows 197Run time:Time of run:0.023734092712402











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

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