Наши магазины

DEBUG enable
Num SQL queries:20
Num fetched rows:79
including array rows:69
Time of script run:0.050713062286377
Time of SQL queries:0.0195631980896
Timers out:
Счетчик "Подгототовка страницы", время выполнения - 0.0029с
Счетчик "Module=shops", время выполнения - 0.0102с
Счетчик "Block=stat", время выполнения - 0.0001с
Счетчик "Block=mainjs", время выполнения - 0с
Счетчик "Block=topper", время выполнения - 0с
Счетчик "Block=header", время выполнения - 0с
Счетчик "Block=catalogtree", время выполнения - 0.001с
Счетчик "Block=header", время выполнения - 0.0006с
Счетчик "Block=catalogtree", время выполнения - 0.0006с
Счетчик "Block=submenu", время выполнения - 0.001с
Счетчик "Block=festival", время выполнения - 0.0002с
Счетчик "Block=banners", время выполнения - 0.0002с
Счетчик "Block=newsleftsidebar", время выполнения - 0.0002с
Счетчик "Block=advert", время выполнения - 0.0001с
Счетчик "Block=rentmagazin", время выполнения - 0.0071с
Счетчик "Block=advert", время выполнения - 0.0002с
Счетчик "Block=subscribe", время выполнения - 0.0002с
Счетчик "Block=footer", время выполнения - 0.0006с
Счетчик "Block=retailrocket", время выполнения - 0.0002с
Счетчик "Block=metrika", время выполнения - 0.0002с
Счетчик "Block=ganalitics", время выполнения - 0.0002с
Счетчик "Block=statmailru", время выполнения - 0.0002с
Счетчик "Block=jivosite", время выполнения - 0.0002с

SELECT id_city,path,name,ishop_id,ishop_name,kladr_id FROM leo_city WHERE path='almaty'; # Num rows 1Run time:Time of run:0.00050115585327148

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

SELECT title,template_id,content,domen,index_id FROM leonardo_kz.leo_index WHERE index_id=15; # Num rows 1Run time:Time of run:0.00032711029052734

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



SELECT COUNT(*) FROM leo_shops WHERE work=1 # Num rows 1Run time:Time of run:0.00040078163146973

SELECT t1.* FROM leo_city AS t1,leo_shops AS t2 WHERE t2.work=1 AND t2.id_city=t1.id_city GROUP BY id_city # Num rows 63Run time:Time of run:0.0029330253601074

SELECT t1.* FROM leo_city AS t1 LEFT JOIN leo_shops AS t3 ON t1.id_city=t3.id_city AND t3.work=0 WHERE t3.id_city IS NOT NULL GROUP BY t1.id_city # Num rows 4Run time:Time of run:0.0011069774627686

SELECT t1.* FROM leo_city AS t1,leo_shops AS t2 WHERE t2.work=1 AND t2.id_city=t1.id_city AND t1.country_id=3 GROUP BY id_city ORDER BY t1.name # Num rows 2Run time:Time of run:0.00075101852416992

SELECT COUNT(*) FROM leo_shops WHERE work=1 # Num rows 1Run time:Time of run:0.00043821334838867

SELECT t1.* FROM leo_city AS t1,leo_shops AS t2 WHERE t2.work=1 AND t2.id_city=t1.id_city AND t1.country_id=1 GROUP BY id_city ORDER BY t1.name # Num rows 60Run time:Time of run:0.0034909248352051

SELECT COUNT(*) FROM leo_shops WHERE work=1 # Num rows 1Run time:Time of run:0.0004270076751709

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

SELECT menu,parent_index_id,alias FROM leonardo_kz.leo_index WHERE index_id=15 # Num rows 1Run time:Time of run:0.0003669261932373

SELECT title,alias FROM leonardo_kz.leo_index WHERE parent_index_id=15 AND visible=1 AND menu=4 ORDER BY order_id # Num rows 0Run time:Time of run:0.00041818618774414

SELECT id FROM leo_shops AS t1 LEFT JOIN leo_city AS t2 ON t1.id_city=t2.id_city WHERE work=1 ; # Num rows 146Run time:Time of run:0.0035028457641602

SELECT id FROM leo_shops AS t1 LEFT JOIN leo_city AS t2 ON t1.id_city=t2.id_city WHERE work=1 AND t2.country_id=1; # Num rows 140Run time:Time of run:0.0010612010955811

SELECT t2.id_city FROM leo_shops AS t1 LEFT JOIN leo_city AS t2 ON t1.id_city=t2.id_city WHERE t1.work=1 AND t2.country_id=1 GROUP BY t2.id_city # Num rows 60Run time:Time of run:0.0011811256408691

SELECT id FROM leo_shops AS t1 LEFT JOIN leo_city AS t2 ON t1.id_city=t2.id_city WHERE work=1 AND t2.country_id=2; # Num rows 3Run time:Time of run:0.00049304962158203

SELECT t2.id_city FROM leo_shops AS t1 LEFT JOIN leo_city AS t2 ON t1.id_city=t2.id_city WHERE t1.work=1 AND t2.country_id=2 GROUP BY t2.id_city # Num rows 1Run time:Time of run:0.00043916702270508

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