MySQL Debugger Results |
Count |
SQL query |
Time to execute |
1 |
SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='RSHKARTINGKRYG1KUSTENDILNEDELQ' LIMIT 1 |
0,0297 |
2 |
SELECT config_value FROM 3w_config WHERE config_title='site_status' LIMIT 1 |
0,0001 |
3 |
SELECT rule_power FROM 3w_access_rules WHERE rule_section=:section AND rule_package=:package AND rule_controller=:controller AND rule_action=:action LIMIT 1 |
0,0001 |
4 |
SELECT config_value FROM 3w_config WHERE config_title = 'default_lang' |
0,0001 |
5 |
SELECT * FROM 3w_lang ORDER BY lang_id DESC |
0,0001 |
6 |
SELECT * FROM 3w_meta WHERE meta_langId='11' LIMIT 1 |
0,0001 |
7 |
SELECT config_value FROM 3w_config WHERE config_title = 'site_logo' |
0,0001 |
8 |
SELECT n.n_id,n.n_seoUrl, n.n_name, n.n_datePublish, n.n_dateAdded,n.n_introCleared,n.n_textCleared, i.ni_filename, i.ni_alt FROM 3w_news n LEFT JOIN 3w_news_images i ON n.n_id=i.ni_newsId WHERE n.n_archived=1 AND n.n_datePublish <= NOW() AND n.n_isactive = '1' GROUP BY n.n_id ORDER BY n.n_datePublish DESC LIMIT 5,2 |
0,0157 |
9 |
SELECT n.n_id,n.n_seoUrl,n.n_dateModified, n.n_datePublish, n.n_name, n.n_dateAdded,n.n_introCleared,n.n_textCleared, i.ni_filename, i.ni_alt FROM 3w_news n LEFT JOIN 3w_news_images i ON n.n_id=i.ni_newsId WHERE n.n_archived=1 AND n.n_datePublish <= NOW() AND n.n_isactive = '1' GROUP BY n.n_id ORDER BY n.n_datePublish DESC LIMIT 5 |
0,0153 |
10 |
SELECT n.n_id,n.n_seoUrl,n.n_dateModified, n.n_datePublish, n.n_name, n.n_dateAdded,n.n_introCleared,n.n_textCleared, i.ni_filename, i.ni_alt FROM 3w_news n LEFT JOIN 3w_news_images i ON n.n_id=i.ni_newsId WHERE n.n_archived=1 AND n.n_datePublish <= NOW() AND n.n_isactive = '1' GROUP BY n.n_id ORDER BY n.n_datePublish DESC LIMIT 5 |
0,0152 |
11 |
SELECT *, name_bg AS name FROM 3w_photo_categories WHERE parent_id=0 ORDER BY id ASC |
0,0168 |
12 |
SELECT *, name_bg AS name FROM 3w_photo_categories WHERE id=1387 LIMIT 1 |
0,0002 |
13 |
SELECT *, name_bg AS name FROM 3w_photo_categories WHERE parent_id=1387 ORDER BY id ASC |
0,0001 |
14 |
SELECT parent_id FROM 3w_photo_categories WHERE id=1387 LIMIT 1 |
0,0001 |
15 |
SELECT *, name_bg AS name FROM 3w_photo_categories WHERE parent_id=0 ORDER BY id ASC |
0,0191 |
16 |
SELECT *, name_bg AS name FROM 3w_photo_categories WHERE parent_id=1387 ORDER BY id ASC |
0,0001 |
17 |
SELECT * FROM 3w_banner_position WHERE bp_isactive=1 ORDER BY bp_id ASC |
0 |
18 |
SELECT * FROM 3w_banner WHERE b_positionId=1 ORDER BY RAND() LIMIT 1 |
0,0004 |
19 |
SELECT * FROM 3w_banner WHERE b_positionId=2 ORDER BY RAND() LIMIT 1 |
0,0002 |
20 |
SELECT * FROM 3w_banner WHERE b_positionId=3 ORDER BY RAND() LIMIT 1 |
0,0002 |
21 |
SELECT * FROM 3w_slider ORDER BY show_order ASC |
0 |
22 |
SELECT *, name_bg AS name FROM 3w_photo_categories WHERE id=1387 LIMIT 1 |
0 |
23 |
SELECT *, name_bg AS name FROM 3w_photo_categories WHERE parent_id=1387 ORDER BY id ASC |
0 |
24 |
SELECT COUNT(p.id) FROM 3w_photos AS p, 3w_photo_categories AS pc WHERE p.category_id=pc.id AND oleft >= AND oright <= |
0,0048 |
25 |
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND oright <=' at line 1 |
0,0048 |
- - |
All Queries Time |
0,1233 |