skip to content | Accessibility Information

Sport category on ManMetLife

(default) 117 queries took 77 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `news_categories`11111
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `news_posts`15151
4SHOW FULL COLUMNS FROM `news_statuses`771
5SHOW FULL COLUMNS FROM `users`11111
6SHOW FULL COLUMNS FROM `news_channels`881
7SHOW FULL COLUMNS FROM `news_levels`881
8SHOW FULL COLUMNS FROM `news_attachments`13131
9SHOW FULL COLUMNS FROM `news_tags`881
10SHOW FULL COLUMNS FROM `news_posts_news_tags`221
11SHOW FULL COLUMNS FROM `news_categories_news_posts`221
12SELECT `NewsCategory`.`id`, `NewsCategory`.`parent_id`, `NewsCategory`.`lft`, `NewsCategory`.`rght`, `NewsCategory`.`name`, `NewsCategory`.`slug`, `NewsCategory`.`news_post_count`, `NewsCategory`.`created`, `NewsCategory`.`created_by`, `NewsCategory`.`modified`, `NewsCategory`.`modified_by` FROM `news_categories` AS `NewsCategory` WHERE `NewsCategory`.`slug` = 'sport' LIMIT 1111
13SELECT `NewsPost`.`id`, `NewsPost`.`news_status_id`, `NewsPost`.`news_channel_id`, `NewsPost`.`news_level_id`, `NewsPost`.`ordering`, `NewsPost`.`title`, `NewsPost`.`slug`, `NewsPost`.`excerpt`, `NewsPost`.`content`, `NewsPost`.`post_date`, `NewsPost`.`show_author`, `NewsPost`.`created`, `NewsPost`.`created_by`, `NewsPost`.`modified`, `NewsPost`.`modified_by`, `NewsCategoriesNewsPost`.`news_category_id`, `NewsCategoriesNewsPost`.`news_post_id` FROM `news_posts` AS `NewsPost` JOIN `news_categories_news_posts` AS `NewsCategoriesNewsPost` ON (`NewsCategoriesNewsPost`.`news_category_id` = 142 AND `NewsCategoriesNewsPost`.`news_post_id` = `NewsPost`.`id`) WHERE `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:22:58' ORDER BY `NewsPost`.`post_date` DESC 1021029
14SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
15SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
16SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
17SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
18SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
19SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
20SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
21SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
22SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
23SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
24SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
25SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
26SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
27SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
28SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
29SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
30SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
31SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
32SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
33SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
34SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
35SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
36SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
37SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
38SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 111
39SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
40SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
41SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
42SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
43SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
44SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
45SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
46SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
47SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
48SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
49SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
50SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
51SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
52SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
53SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
54SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
55SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
56SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
57SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
58SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
59SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
60SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
61SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
62SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
63SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
64SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
65SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
66SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
67SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
68SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
69SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
70SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
71SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
72SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
73SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
74SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
75SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
76SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
77SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
78SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
79SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
80SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
81SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
82SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
83SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
84SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
85SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
86SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
87SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
88SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
89SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
90SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
91SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
92SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
93SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
94SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
95SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
96SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
97SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
98SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
99SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
100SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
101SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
102SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
103SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
104SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
105SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
106SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
107SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
108SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
109SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
110SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
111SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
112SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
113SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 3 110
114SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
115SELECT `NewsChannel`.`id`, `NewsChannel`.`slug` FROM `news_channels` AS `NewsChannel` WHERE `NewsChannel`.`id` = 1 110
116SELECT `NewsCategory`.`id`, `NewsCategory`.`parent_id`, `NewsCategory`.`lft`, `NewsCategory`.`rght`, `NewsCategory`.`name`, `NewsCategory`.`slug`, `NewsCategory`.`news_post_count`, `NewsCategory`.`created`, `NewsCategory`.`created_by`, `NewsCategory`.`modified`, `NewsCategory`.`modified_by` FROM `news_categories` AS `NewsCategory` WHERE `NewsCategory`.`news_post_count` > 0 ORDER BY `NewsCategory`.`lft` asc 1151151
117SELECT DISTINCT WEEKOFYEAR(`NewsPost`.`post_date`) AS `week`, YEAR(`NewsPost`.`post_date`) AS `yr`, DATE_FORMAT( `NewsPost`.`post_date` , '%Y-%m-%d' ) AS `yyyymmdd`, count(`NewsPost`.`id`) AS `posts` FROM `news_posts` AS `NewsPost` WHERE `NewsPost`.`news_channel_id` = 3 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:22:58' GROUP BY WEEKOFYEAR(`NewsPost`.`post_date`) , YEAR( `NewsPost`.`post_date` ) ORDER BY `NewsPost`.`post_date` DESC 22022054