Конструкторы

DEBUG enable
Num SQL queries:166
Num fetched rows:177
including array rows:1
Time of script run:0.32398796081543
Time of SQL queries:0.095353126525879
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0047с
Счетчик "ModIshopTree tree data", время выполнения - 0.0005с
Счетчик "ModIshopTree breads", время выполнения - 0.0008с
Счетчик "ModIshopTree treecache", время выполнения - 0.0001с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0004с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0618с
Счетчик "ModIshopTree treesort", время выполнения - 0.0004с
Счетчик "ModIshopTree filters", время выполнения - 0.2091с
Счетчик "ModIshopTree design", время выполнения - 0.0002с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0003с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.2819с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=topper", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0009с
Счетчик "Block=header", время выполнения - 0.0008с
Счетчик "Block=catalogtree", время выполнения - 0.0009с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0002с
Счетчик "Block=advert", время выполнения - 0.0002с
Счетчик "Block=subscribe", время выполнения - 0.0002с
Счетчик "Block=footer", время выполнения - 0.0008с
Счетчик "Block=retailrocket", время выполнения - 0.0002с
Счетчик "Block=metrika", время выполнения - 0.0003с
Счетчик "Block=ganalitics", время выполнения - 0.0002с
Счетчик "Block=statmailru", время выполнения - 0.0002с
Счетчик "Block=jivosite", время выполнения - 0.0003с

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

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

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

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

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



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



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







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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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





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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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











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

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