DEBUG enable
Num SQL queries:147
Num fetched rows:224
including array rows:3
Time of script run:1.1606230735779
Time of SQL queries:0.10620212554932
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0619с
Счетчик "ModIshopTree tree data", время выполнения - 0.0028с
Счетчик "ModIshopTree breads", время выполнения - 0.0073с
Счетчик "ModIshopTree treecache", время выполнения - 0.0012с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0841с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0038с
Счетчик "ModIshopTree treesort", время выполнения - 0.0002с
Счетчик "ModIshopTree filters", время выполнения - 0.9566с
Счетчик "ModIshopTree design", время выполнения - 0.0002с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0003с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 1.0677с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0012с
Счетчик "Block=header", время выполнения - 0.0002с
Счетчик "Block=catalogtree", время выполнения - 0.0009с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0001с
Счетчик "Block=advert", время выполнения - 0.0002с
Счетчик "Block=subscribe", время выполнения - 0.0002с
Счетчик "Block=footer", время выполнения - 0.0003с
Счетчик "Block=retailrocket", время выполнения - 0.0003с
Счетчик "Block=metrika", время выполнения - 0.0003с
Счетчик "Block=ganalitics", время выполнения - 0.0003с
Счетчик "Block=statmailru", время выполнения - 0.0003с
Счетчик "Block=jivosite", время выполнения - 0.0005с

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

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

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

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

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



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



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







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





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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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