Проволока

DEBUG enable
Num SQL queries:117
Num fetched rows:554
including array rows:1
Time of script run:0.32677102088928
Time of SQL queries:0.064773797988892
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0068с
Счетчик "ModIshopTree tree data", время выполнения - 0.0007с
Счетчик "ModIshopTree breads", время выполнения - 0.0012с
Счетчик "ModIshopTree treecache", время выполнения - 0.0003с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0004с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0571с
Счетчик "ModIshopTree treesort", время выполнения - 0.0002с
Счетчик "ModIshopTree filters", время выполнения - 0.2193с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0002с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.2889с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=topper", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0009с
Счетчик "Block=header", время выполнения - 0.0012с
Счетчик "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.00051689147949219

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

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

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

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



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



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







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

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.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=1020358262 AND t1.id_good=t2.id_good AND t1_ru.id_detail=1020358262 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.00087189674377441

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

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

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

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

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

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

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

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

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

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

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

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

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=5341440962 AND id_city=51 # 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=5364118222 LIMIT 1; # Num rows 1Run time:Time of run:0.00057888031005859

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=5364118222 AND id_city=51 # 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=14298750732 LIMIT 1; # Num rows 1Run time:Time of run:0.00060796737670898

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.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=1020358002 AND t1.id_good=t2.id_good AND t1_ru.id_detail=1020358002 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.00072407722473145

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

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

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

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

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

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

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

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

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

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.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=77025919264 AND t1.id_good=t2.id_good AND t1_ru.id_detail=77025919264 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0012269020080566

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

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.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=77025936434 AND t1.id_good=t2.id_good AND t1_ru.id_detail=77025936434 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.00093913078308105

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

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.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=77025977044 AND t1.id_good=t2.id_good AND t1_ru.id_detail=77025977044 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0010440349578857

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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





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

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

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=1020447592 # Num rows 29Run time:Time of run:0.0007321834564209

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=4521532592 # Num rows 13Run time:Time of run:0.00033903121948242

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

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=14298750732 # Num rows 25Run time:Time of run:0.00037193298339844

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

SELECT id_detail FROM leo_details WHERE id_good=19051401542 # Num rows 21Run time:Time of run:0.00034499168395996

SELECT id_detail FROM leo_details WHERE id_good=19051580812 # Num rows 25Run time:Time of run:0.00032281875610352

SELECT id_detail FROM leo_details WHERE id_good=19051592902 # Num rows 24Run time:Time of run:0.00032782554626465

SELECT id_detail FROM leo_details WHERE id_good=19051600502 # Num rows 22Run time:Time of run:0.00035190582275391

SELECT id_detail FROM leo_details WHERE id_good=19051674622 # Num rows 22Run time:Time of run:0.00033283233642578

SELECT id_detail FROM leo_details WHERE id_good=19051683692 # Num rows 24Run time:Time of run:0.00034594535827637

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

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

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

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

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

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=85325260514 # Num rows 4Run time:Time of run:0.00044989585876465

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

SELECT id_detail FROM leo_details WHERE id_good=86740052504 # Num rows 7Run time:Time of run:0.00031304359436035

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

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

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

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











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

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