Балалар косметикасы

DEBUG enable
Num SQL queries:119
Num fetched rows:1007
including array rows:15
Time of script run:0.27863502502441
Time of SQL queries:0.10189580917358
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.003с
Счетчик "ModIshopTree tree data", время выполнения - 0.0004с
Счетчик "ModIshopTree breads", время выполнения - 0.0005с
Счетчик "ModIshopTree treecache", время выполнения - 0.004с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0911с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0086с
Счетчик "ModIshopTree treesort", время выполнения - 0.0001с
Счетчик "ModIshopTree filters", время выполнения - 0.1381с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0001с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.2483с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0с
Счетчик "Block=topper", время выполнения - 0с
Счетчик "Block=header", время выполнения - 0с
Счетчик "Block=catalogtree", время выполнения - 0.0009с
Счетчик "Block=header", время выполнения - 0.0007с
Счетчик "Block=catalogtree", время выполнения - 0.0007с
Счетчик "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.00037884712219238

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

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

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

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



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



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



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

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

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=9538925211 # 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.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=9538925211) GROUP BY t2.id_detail # Num rows 13Run time:Time of run:0.0021648406982422



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=3717272109 ORDER BY t1.pos # Num rows 11Run time:Time of run:0.00048303604125977

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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=9538925431 ORDER BY t1.pos # Num rows 8Run time:Time of run:0.00045299530029297

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

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

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

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

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

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

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

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

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

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

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

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

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3717279309 # 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.00030303001403809

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=51 AND (t3.maxprice>0) AND (tn.id_tree=3717279309) GROUP BY t1.id_good # Num rows 13Run time:Time of run:0.0017499923706055

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

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

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=50604427682 # Num rows 4Run time:Time of run:0.00059700012207031

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=52579709652 # Num rows 23Run time:Time of run:0.00037002563476562

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=68797492094 # Num rows 10Run time:Time of run:0.00036501884460449

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=68800237964 # Num rows 4Run time:Time of run:0.00034809112548828

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

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

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

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=94238325534 # Num rows 10Run time:Time of run:0.0003659725189209

SELECT SQL_NO_CACHE id_detail FROM leonardo.leo_details WHERE id_good=94238719994 # Num rows 4Run time:Time of run:0.00032997131347656

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT SQL_NO_CACHE treeshow,treetype,`sql-query` FROM leo_tree_description WHERE tree_id=3811216109 # 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.00030994415283203

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



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

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

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

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

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

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

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

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

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

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

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

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

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





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

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

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

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

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

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

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

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

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

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

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

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

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











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

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