Открыт интернет-магазин. Делайте заказы!

(0) товаров | 0 теңге
Оформить заказ
Тауарлардың каталогы

Капронды

DEBUG enable
Num SQL queries:111
Num fetched rows:1575
including array rows:14
Time of script run:0.31506586074829
Time of SQL queries:0.046418428421021
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.002с
Счетчик "ModIshopTree tree data", время выполнения - 0.0008с
Счетчик "ModIshopTree breads", время выполнения - 0.0025с
Счетчик "ModIshopTree treecache", время выполнения - 0.0026с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0377с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0046с
Счетчик "ModIshopTree treesort", время выполнения - 0.0001с
Счетчик "ModIshopTree filters", время выполнения - 0.2291с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0001с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.2899с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0с
Счетчик "Block=header", время выполнения - 0с
Счетчик "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.0005с
Счетчик "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='astana'; # Num rows 1Run time:Time of run:0.00043106079101562

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

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

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

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



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



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



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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1458790362) GROUP BY t1.id_good # Num rows 3Run time:Time of run:0.00071501731872559

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=11854323422 # Num rows 6Run time:Time of run:0.00020599365234375

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=11854402052 # Num rows 8Run time:Time of run:0.00022602081298828

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=11854932992 # Num rows 14Run time:Time of run:0.0001990795135498



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=1457724362 ORDER BY t1.pos # Num rows 10Run time:Time of run:0.0075199604034424

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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1457746462) GROUP BY t1.id_good # Num rows 13Run time:Time of run:0.001788854598999

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=263235341 # Num rows 403Run time:Time of run:0.00042295455932617

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=263238381 # Num rows 268Run time:Time of run:0.00033712387084961

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=299755821 # Num rows 22Run time:Time of run:0.00019598007202148

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=819862301 # Num rows 30Run time:Time of run:0.00021696090698242

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=819870831 # Num rows 27Run time:Time of run:0.00018811225891113

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=1396614692 # Num rows 11Run time:Time of run:0.00018000602722168

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=2840677082 # Num rows 22Run time:Time of run:0.00018596649169922

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=2840777302 # Num rows 15Run time:Time of run:0.00027203559875488

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=3507099192 # Num rows 27Run time:Time of run:0.00025486946105957

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=3508148182 # Num rows 17Run time:Time of run:0.00026988983154297

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=5449055802 # Num rows 2Run time:Time of run:0.00024199485778809

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=23229234242 # Num rows 50Run time:Time of run:0.00028800964355469

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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1458358662) GROUP BY t1.id_good # Num rows 12Run time:Time of run:0.001903772354126

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=52035063272 # Num rows 7Run time:Time of run:0.00020194053649902

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

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

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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1499538862) GROUP BY t1.id_good # Num rows 9Run time:Time of run:0.0011050701141357

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=883867352 # Num rows 11Run time:Time of run:0.00020718574523926

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=1553274032 # Num rows 200Run time:Time of run:0.00032615661621094

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=1553326462 # Num rows 3Run time:Time of run:0.00019502639770508

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=19857713602 # Num rows 21Run time:Time of run:0.00020313262939453

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=20060788952 # Num rows 24Run time:Time of run:0.00023293495178223

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=20063714022 # Num rows 15Run time:Time of run:0.00021696090698242

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=20066069782 # Num rows 16Run time:Time of run:0.00019216537475586

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=29144608082 # Num rows 7Run time:Time of run:0.00019001960754395

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=65054756144 # Num rows 9Run time:Time of run:0.00018501281738281

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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1458799462) GROUP BY t1.id_good # Num rows 3Run time:Time of run:0.00070810317993164

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=12293906182 # Num rows 2Run time:Time of run:0.00023221969604492

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=12294073202 # Num rows 2Run time:Time of run:0.0001978874206543

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=12294152122 # Num rows 2Run time:Time of run:0.00018787384033203

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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1458708862) GROUP BY t1.id_good # Num rows 2Run time:Time of run:0.00049495697021484

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=12331161 # Num rows 3Run time:Time of run:0.00020813941955566

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

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

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

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

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=401 OR t3.dep_id=401) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=1458149562) GROUP BY t2.id_detail # Num rows 7Run time:Time of run:0.00061607360839844

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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1458194862) GROUP BY t1.id_good # Num rows 20Run time:Time of run:0.0010590553283691

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

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=22704480362 # Num rows 20Run time:Time of run:0.00020384788513184

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=29806780112 # Num rows 2Run time:Time of run:0.00020599365234375

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=52767657642 # Num rows 5Run time:Time of run:0.00020909309387207

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=66988816084 # Num rows 7Run time:Time of run:0.00021195411682129

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

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

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

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

SELECT SQL_NO_CACHE t1.id_good,t1.oncedetail,t1.detailcount FROM leonardo.leo_tree_goods AS tn,leonardo.leo_goods AS t1,leonardo.leo_good_price AS t3 WHERE tn.id_good=t1.id_good AND t1.id_good=t3.id_good AND t3.id_city=46 AND (t3.maxprice>0) AND (tn.id_tree=1458777862) GROUP BY t1.id_good # Num rows 2Run time:Time of run:0.0006868839263916

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=20056612052 # Num rows 35Run time:Time of run:0.00034308433532715

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

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

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

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

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=401 OR t3.dep_id=401) AND t3.price>0 AND t3.sizes>0 AND (tn.id_tree=9538924617) GROUP BY t2.id_detail # Num rows 17Run time:Time of run:0.0006260871887207



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

SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 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.id_good=11854323422 LIMIT 1; # Num rows 1Run time:Time of run:0.00058484077453613

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

SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 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.id_good=11854402052 LIMIT 1; # Num rows 1Run time:Time of run:0.00038909912109375

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

SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 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.id_good=11854932992 LIMIT 1; # Num rows 1Run time:Time of run:0.0003209114074707

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





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

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

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

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

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

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

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











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

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