Каталог товаров

Маркеры и корректоры

DEBUG enable
Num SQL queries:114
Num fetched rows:823
including array rows:3
Time of script run:0.45604300498962
Time of SQL queries:0.10118222236633
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0035с
Счетчик "ModIshopTree tree data", время выполнения - 0.0015с
Счетчик "ModIshopTree breads", время выполнения - 0.0045с
Счетчик "ModIshopTree treecache", время выполнения - 0.0012с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0019с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0467с
Счетчик "ModIshopTree treesort", время выполнения - 0.0007с
Счетчик "ModIshopTree filters", время выполнения - 0.3527с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0002с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.42с
Счетчик "Block=stat", время выполнения - 0.0002с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0012с
Счетчик "Block=header", время выполнения - 0.0003с
Счетчик "Block=catalogtree", время выполнения - 0.001с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0003с
Счетчик "Block=advert", время выполнения - 0.0002с
Счетчик "Block=subscribe", время выполнения - 0.0003с
Счетчик "Block=footer", время выполнения - 0.0003с
Счетчик "Block=retailrocket", время выполнения - 0.0003с
Счетчик "Block=metrika", время выполнения - 0.0003с
Счетчик "Block=ganalitics", время выполнения - 0.0003с
Счетчик "Block=statmailru", время выполнения - 0.0003с
Счетчик "Block=jivosite", время выполнения - 0.0003с

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

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

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

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

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



SELECT t1.treename,t2.treetype,t2.tree_description,t2.tree_meta_description,t1.shop_tree_id,t1.level1,t1.level2,t1.level3,t1.relatedtree,t2.titletag,t2.tree_notice,t2.h1tag,t2.maintitledisable FROM leonardo.leo_tree AS t1 LEFT JOIN leonardo.leo_tree_description AS t2 ON t1.id_tree=t2.tree_id LEFT JOIN leonardo_kz.leo_tree_translate AS t3 ON (t1.id_tree=t3.id_tree) WHERE t3.id_tree IS NOT NULL AND t1.id_tree=3727272909; # Num rows 1Run time:Time of run:0.0015058517456055



SELECT t1.id_tree,t1.treename,t2.id_tree,t2.treename,t3.id_tree,t3.treename,t4.id_tree,t4.treename,t5.id_tree,t5.treename FROM leo_tree AS t1 LEFT JOIN leo_tree AS t2 ON t1.shop_tree_id=t2.id_tree LEFT JOIN leo_tree AS t3 ON t2.shop_tree_id=t3.id_tree LEFT JOIN leo_tree AS t4 ON t3.shop_tree_id=t4.id_tree LEFT JOIN leo_tree AS t5 ON t4.shop_tree_id=t5.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t1_kz ON t1.id_tree=t1_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t2_kz ON t1.shop_tree_id=t2_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t3_kz ON t2.shop_tree_id=t3_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t4_kz ON t3.shop_tree_id=t4_kz.id_tree LEFT JOIN leonardo_kz.leo_tree_translate AS t5_kz ON t4.shop_tree_id=t5_kz.id_tree WHERE t1.id_tree=3727272909 # Num rows 1Run time:Time of run:0.0044019222259521







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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=28753297152 LIMIT 1; # Num rows 1Run time:Time of run:0.00091314315795898

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

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

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

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

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=31740323662 LIMIT 1; # Num rows 1Run time:Time of run:0.0014069080352783

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

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

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

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

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=33503937392 LIMIT 1; # Num rows 1Run time:Time of run:0.0035049915313721

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=33504308062 LIMIT 1; # Num rows 1Run time:Time of run:0.0013718605041504

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=33512866992 LIMIT 1; # Num rows 1Run time:Time of run:0.0013301372528076

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=33834092822 LIMIT 1; # Num rows 1Run time:Time of run:0.00054287910461426

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35857819952 LIMIT 1; # Num rows 1Run time:Time of run:0.00048589706420898

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35859260152 LIMIT 1; # Num rows 1Run time:Time of run:0.00050806999206543

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35861226922 LIMIT 1; # Num rows 1Run time:Time of run:0.0005028247833252

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=35861378382 LIMIT 1; # Num rows 1Run time:Time of run:0.00042581558227539

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36574387422 LIMIT 1; # Num rows 1Run time:Time of run:0.0004580020904541

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36577492272 LIMIT 1; # Num rows 1Run time:Time of run:0.00046992301940918

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36578179802 LIMIT 1; # Num rows 1Run time:Time of run:0.00044584274291992

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36580459512 LIMIT 1; # Num rows 1Run time:Time of run:0.00049996376037598

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36581001742 LIMIT 1; # Num rows 1Run time:Time of run:0.00046586990356445

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=36645024982 LIMIT 1; # Num rows 1Run time:Time of run:0.002208948135376

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=48967008632 LIMIT 1; # Num rows 1Run time:Time of run:0.00046801567077637

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

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

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

SELECT SQL_NO_CACHE t4.id_tree,t1_ru.goodname,t1_ru.gooddescr,t1_ru.dimension,t1.f_tree_id,t1.cardtype,t1_ru.tis_fullname,t1.prepic,t1.detailcount,t1.goodrating,t1.oncedetail,t1.price,good_id,t1.id_good FROM leonardo_kz.leo_goods AS t1 LEFT JOIN leonardo.leo_goods AS t1_ru ON (t1.id_good=t1_ru.id_good) LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1_ru.goodname IS NOT NULL AND t1.id_good=60327623792 LIMIT 1; # Num rows 1Run time:Time of run:0.00050187110900879

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





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

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

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

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

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

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

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=28753297152 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.00096917152404785

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

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=29738185092 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.00051093101501465

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=29739115542 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.00053095817565918

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=31738603362 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.00052309036254883

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=31738649442 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.00042891502380371

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=31740323662 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.00053811073303223

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=31743448612 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.00046110153198242

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

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=33503937392 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.00048017501831055

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=33504308062 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.00040411949157715

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

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=33834092822 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.0005800724029541

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

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

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

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

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

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

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

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

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

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

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=48967008632 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.00052595138549805

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=49983570382 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.00047898292541504

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep AS t1,leo_shops AS t2 WHERE t1.code=53020949352 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.00051093101501465

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=59982279552 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.00049114227294922

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=59982310232 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.00046682357788086

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=60327623792 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.00052595138549805

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=32745481982 # Num rows 109Run time:Time of run:0.008512020111084

SELECT id_detail FROM leo_details WHERE id_good=28753297152 # Num rows 10Run time:Time of run:0.003525972366333

SELECT id_detail FROM leo_details WHERE id_good=29737314932 # Num rows 9Run time:Time of run:0.004011869430542

SELECT id_detail FROM leo_details WHERE id_good=29738185092 # Num rows 9Run time:Time of run:0.00023603439331055

SELECT id_detail FROM leo_details WHERE id_good=29739115542 # Num rows 9Run time:Time of run:0.00029897689819336

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

SELECT id_detail FROM leo_details WHERE id_good=33503937392 # Num rows 5Run time:Time of run:0.0017030239105225

SELECT id_detail FROM leo_details WHERE id_good=33504308062 # Num rows 5Run time:Time of run:0.00081706047058105

SELECT id_detail FROM leo_details WHERE id_good=33512866992 # Num rows 36Run time:Time of run:0.00084710121154785

SELECT id_detail FROM leo_details WHERE id_good=33834092822 # Num rows 168Run time:Time of run:0.0015249252319336

SELECT id_detail FROM leo_details WHERE id_good=35857819952 # Num rows 10Run time:Time of run:0.00054693222045898

SELECT id_detail FROM leo_details WHERE id_good=35859260152 # Num rows 23Run time:Time of run:0.0020849704742432

SELECT id_detail FROM leo_details WHERE id_good=35861226922 # Num rows 10Run time:Time of run:0.0013139247894287

SELECT id_detail FROM leo_details WHERE id_good=35861378382 # Num rows 10Run time:Time of run:0.0018031597137451

SELECT id_detail FROM leo_details WHERE id_good=36574387422 # Num rows 10Run time:Time of run:0.0010240077972412

SELECT id_detail FROM leo_details WHERE id_good=36577492272 # Num rows 18Run time:Time of run:0.0027539730072021

SELECT id_detail FROM leo_details WHERE id_good=36578179802 # Num rows 10Run time:Time of run:0.003432035446167

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=48967008632 # Num rows 168Run time:Time of run:0.0021219253540039

SELECT id_detail FROM leo_details WHERE id_good=59982279552 # Num rows 18Run time:Time of run:0.00027108192443848

SELECT id_detail FROM leo_details WHERE id_good=59982310232 # Num rows 18Run time:Time of run:0.00047111511230469

SELECT id_detail FROM leo_details WHERE id_good=60327623792 # Num rows 10Run time:Time of run:0.0023841857910156

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