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

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

DEBUG enable
Num SQL queries:181
Num fetched rows:1594
including array rows:3
Time of script run:0.64337778091431
Time of SQL queries:0.17613840103149
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.004с
Счетчик "ModIshopTree tree data", время выполнения - 0.0036с
Счетчик "ModIshopTree breads", время выполнения - 0.0043с
Счетчик "ModIshopTree treecache", время выполнения - 0.001с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0005с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0823с
Счетчик "ModIshopTree treesort", время выполнения - 0.0004с
Счетчик "ModIshopTree filters", время выполнения - 0.4927с
Счетчик "ModIshopTree design", время выполнения - 0.0002с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0002с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.5969с
Счетчик "Block=stat", время выполнения - 0.0002с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.002с
Счетчик "Block=header", время выполнения - 0.0003с
Счетчик "Block=catalogtree", время выполнения - 0.001с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0002с
Счетчик "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.00078010559082031

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

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

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

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



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



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







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

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

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

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

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=11881458832 AND id_city=46 # 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=14207931542 AND t1.id_good=t2.id_good AND t1_ru.id_detail=14207931542 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0033359527587891

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

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

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

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

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

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

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

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=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.0016520023345947

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

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

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

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=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.0007169246673584

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

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=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.00068187713623047

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

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

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_details_price WHERE id_detail=31744253252 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.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=31744315742 AND t1.id_good=t2.id_good AND t1_ru.id_detail=31744315742 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.0014941692352295

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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=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.0017220973968506

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

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

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

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

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

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

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

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

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

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

SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leonardo.leo_good_price WHERE id_good=58224456862 AND id_city=46 # 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=58634415762 AND t1.id_good=t2.id_good AND t1_ru.id_detail=58634415762 AND t1.id_good=t2_ru.id_good LIMIT 1 # Num rows 1Run time:Time of run:0.00075411796569824

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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





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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT SQL_NO_CACHE t1.dep_id,t2.name FROM tis_dep_goods AS t1,leo_shops AS t2 WHERE t1.code=52160725032 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.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=52160725032 LIMIT 1; # Num rows 1Run time:Time of run:0.00054192543029785

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=11881458832 # Num rows 1Run time:Time of run:0.00037693977355957

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

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

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

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

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

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

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

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

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

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

SELECT id_detail FROM leo_details WHERE id_good=58224456862 # Num rows 12Run time:Time of run:0.0053980350494385

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

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

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

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

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

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

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

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

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 126Run time:Time of run:0.0055301189422607

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=9097393392 # Num rows 768Run time:Time of run:0.030591011047363

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