DEBUG enable
Num SQL queries:151
Num fetched rows:230
including array rows:3
Time of script run:0.3641369342804
Time of SQL queries:0.044411182403564
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0019с
Счетчик "ModIshopTree tree data", время выполнения - 0.0008с
Счетчик "ModIshopTree breads", время выполнения - 0.0027с
Счетчик "ModIshopTree treecache", время выполнения - 0.0001с
Счетчик "ModIshopTree leftmenu", время выполнения - 0.0007с
Счетчик "ModIshopTree cardcollect", время выполнения - 0.0115с
Счетчик "ModIshopTree treesort", время выполнения - 0.0002с
Счетчик "ModIshopTree filters", время выполнения - 0.311с
Счетчик "ModIshopTree design", время выполнения - 0.0001с
Счетчик "ModIshopTree cardsviews", время выполнения - 0.0002с
Счетчик "ModIshopTree paginator", время выполнения - 0с
Счетчик "ModIshopTree mclasses", время выполнения - 0с
Счетчик "Module=ishop", время выполнения - 0.3339с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0.0001с
Счетчик "Block=header", время выполнения - 0.0001с
Счетчик "Block=catalogtree", время выполнения - 0.0009с
Счетчик "Block=header", время выполнения - 0.0006с
Счетчик "Block=catalogtree", время выполнения - 0.0008с
Счетчик "Block=retailrocketblocks", время выполнения - 0.0001с
Счетчик "Block=advert", время выполнения - 0.0002с
Счетчик "Block=subscribe", время выполнения - 0.0002с
Счетчик "Block=footer", время выполнения - 0.0006с
Счетчик "Block=retailrocket", время выполнения - 0.0003с
Счетчик "Block=metrika", время выполнения - 0.0002с
Счетчик "Block=ganalitics", время выполнения - 0.0003с
Счетчик "Block=statmailru", время выполнения - 0.0002с
Счетчик "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.00028514862060547

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

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

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

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



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



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







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





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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 1Run time:Time of run:0.00030517578125

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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











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

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