PAC Blogue

(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(stppacca_fr_stp-pac_ca) 44 queries took 39 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `contents`13131
2DESCRIBE `texts`11111
3DESCRIBE `shortcuts`441
4DESCRIBE `sidebars`661
5DESCRIBE `footers`662
6DESCRIBE `comments`661
7DESCRIBE `users`881
8DESCRIBE `groups`551
9DESCRIBE `rights`331
10DESCRIBE `systemrights`221
11DESCRIBE `page_group_permissions`551
12DESCRIBE `aros`771
13DESCRIBE `acos`771
14DESCRIBE `aros_acos`771
15DESCRIBE `settings`881
16SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`modified`, `Setting`.`parent`, `Setting`.`type`, `Setting`.`input`, `Setting`.`description`, `parent`.`id`, `parent`.`name`, `parent`.`value`, `parent`.`modified`, `parent`.`parent`, `parent`.`type`, `parent`.`input`, `parent`.`description` FROM `settings` AS `Setting` LEFT JOIN `settings` AS `parent` ON (`Setting`.`parent` = `parent`.`id`) WHERE 1 = 1 21211
17SELECT `Text`.`id`, `Text`.`content_id`, `Text`.`name`, `Text`.`text`, `Text`.`current`, `Text`.`lft`, `Text`.`rght`, `Text`.`created`, `Text`.`user`, `Text`.`meta_keywords`, `Text`.`meta_description`, `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire` FROM `texts` AS `Text` LEFT JOIN `contents` AS `Content` ON (`Text`.`content_id` = `Content`.`id`) WHERE `Content`.`page_type` = 'meta' AND `Text`.`current` = 1 331
18SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire`, `Text`.`id`, `Text`.`content_id`, `Text`.`name`, `Text`.`text`, `Text`.`current`, `Text`.`lft`, `Text`.`rght`, `Text`.`created`, `Text`.`user`, `Text`.`meta_keywords`, `Text`.`meta_description`, `Shortcut`.`id`, `Shortcut`.`content_id`, `Shortcut`.`url`, `Shortcut`.`current`, `Sidebar`.`id`, `Sidebar`.`content_id`, `Sidebar`.`value`, `Sidebar`.`created`, `Sidebar`.`modified`, `Sidebar`.`current`, `Footer`.`id`, `Footer`.`value`, `Footer`.`created`, `Footer`.`modified`, `Footer`.`current`, `Footer`.`content_id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE `Content`.`show_in_nav` = 1 AND `Content`.`status` = 'active' ORDER BY `Content`.`lft` asc 18185
19SELECT `Permissions`.`id`, `Permissions`.`content_id`, `Permissions`.`group_id`, `Permissions`.`allow_view`, `Permissions`.`allow_edit` FROM `page_group_permissions` AS `Permissions` WHERE `Permissions`.`content_id` IN (907, 921, 922, 923, 926, 940, 927, 928, 924, 930, 931, 932, 942, 925, 934, 943, 935, 936) 661
20SELECT `Comment`.`id`, `Comment`.`content_id`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`user_id` FROM `comments` AS `Comment` WHERE `Comment`.`content_id` IN (907, 921, 922, 923, 926, 940, 927, 928, 924, 930, 931, 932, 942, 925, 934, 943, 935, 936) 000
21SELECT `Shortcut`.`id`, `Shortcut`.`content_id`, `Shortcut`.`url`, `Shortcut`.`current`, `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire` FROM `shortcuts` AS `Shortcut` LEFT JOIN `contents` AS `Content` ON (`Shortcut`.`content_id` = `Content`.`id`) WHERE `Shortcut`.`url` = 'pac-blogue' LIMIT 1111
22SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire`, `Text`.`id`, `Text`.`content_id`, `Text`.`name`, `Text`.`text`, `Text`.`current`, `Text`.`lft`, `Text`.`rght`, `Text`.`created`, `Text`.`user`, `Text`.`meta_keywords`, `Text`.`meta_description`, `Shortcut`.`id`, `Shortcut`.`content_id`, `Shortcut`.`url`, `Shortcut`.`current`, `Sidebar`.`id`, `Sidebar`.`content_id`, `Sidebar`.`value`, `Sidebar`.`created`, `Sidebar`.`modified`, `Sidebar`.`current`, `Footer`.`id`, `Footer`.`value`, `Footer`.`created`, `Footer`.`modified`, `Footer`.`current`, `Footer`.`content_id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE `Content`.`id` = 938 LIMIT 1111
23SELECT `Permissions`.`id`, `Permissions`.`content_id`, `Permissions`.`group_id`, `Permissions`.`allow_view`, `Permissions`.`allow_edit` FROM `page_group_permissions` AS `Permissions` WHERE `Permissions`.`content_id` = (938) 000
24SELECT `Comment`.`id`, `Comment`.`content_id`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`user_id` FROM `comments` AS `Comment` WHERE `Comment`.`content_id` = (938) 000
25SELECT `Shortcut`.`url`, `Content`.*, `Content`.`id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE `Content`.`status` = 'active' AND ((`Content`.`release` <= '2017-10-21 04:38:47') OR (`Content`.`release` is NULL)) AND `Content`.`parent_id` = 938 ORDER BY `Content`.`lft` asc LIMIT 30001
26SELECT COUNT(*) AS `count` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE ((`Shortcut`.`current` = 1) AND (`Content`.`parent_id` = 938) AND (`Content`.`status` = 'active') AND (((`Content`.`release` <= '2017-10-21 04:38:47') OR (`Content`.`release` is NULL)))) 111
27SELECT `Shortcut`.`url`, `Content`.*, `Text`.`text`, `Content`.`id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE ((`Shortcut`.`current` = 1) AND (`Content`.`parent_id` = 938) AND (`Content`.`status` = 'active') AND (((`Content`.`release` <= '2017-10-21 04:38:47') OR (`Content`.`release` is NULL)))) ORDER BY `Content`.`release` DESC LIMIT 20001
28SELECT `Content`.`lft`, `Content`.`rght`, `Content`.`id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE `Content`.`id` = 938 LIMIT 1111
29SELECT `Permissions`.`id`, `Permissions`.`content_id`, `Permissions`.`group_id`, `Permissions`.`allow_view`, `Permissions`.`allow_edit` FROM `page_group_permissions` AS `Permissions` WHERE `Permissions`.`content_id` = (938) 000
30SELECT `Comment`.`id`, `Comment`.`content_id`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`user_id` FROM `comments` AS `Comment` WHERE `Comment`.`content_id` = (938) 000
31SELECT `Shortcut`.`url`, `Content`.*, `Content`.`id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE 1 = 1 AND `Content`.`lft` <= 54 AND `Content`.`rght` >= 55 ORDER BY `Content`.`lft` asc 221
32SELECT `Permissions`.`id`, `Permissions`.`content_id`, `Permissions`.`group_id`, `Permissions`.`allow_view`, `Permissions`.`allow_edit` FROM `page_group_permissions` AS `Permissions` WHERE `Permissions`.`content_id` IN (1, 938) 000
33SELECT `Comment`.`id`, `Comment`.`content_id`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`user_id` FROM `comments` AS `Comment` WHERE `Comment`.`content_id` IN (1, 938) 000
34SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire`, `Text`.`id`, `Text`.`content_id`, `Text`.`name`, `Text`.`text`, `Text`.`current`, `Text`.`lft`, `Text`.`rght`, `Text`.`created`, `Text`.`user`, `Text`.`meta_keywords`, `Text`.`meta_description`, `Shortcut`.`id`, `Shortcut`.`content_id`, `Shortcut`.`url`, `Shortcut`.`current`, `Sidebar`.`id`, `Sidebar`.`content_id`, `Sidebar`.`value`, `Sidebar`.`created`, `Sidebar`.`modified`, `Sidebar`.`current`, `Footer`.`id`, `Footer`.`value`, `Footer`.`created`, `Footer`.`modified`, `Footer`.`current`, `Footer`.`content_id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE ((`Content`.`page_type` = 'news_article') AND (`Content`.`release` <= '2017-10-21 04:38:47') AND (`Content`.`expire` > '2017-10-21 04:38:47') AND (`Content`.`status` = 'active')) LIMIT 5001
35SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire`, `Text`.`id`, `Text`.`content_id`, `Text`.`name`, `Text`.`text`, `Text`.`current`, `Text`.`lft`, `Text`.`rght`, `Text`.`created`, `Text`.`user`, `Text`.`meta_keywords`, `Text`.`meta_description`, `Shortcut`.`id`, `Shortcut`.`content_id`, `Shortcut`.`url`, `Shortcut`.`current`, `Sidebar`.`id`, `Sidebar`.`content_id`, `Sidebar`.`value`, `Sidebar`.`created`, `Sidebar`.`modified`, `Sidebar`.`current`, `Footer`.`id`, `Footer`.`value`, `Footer`.`created`, `Footer`.`modified`, `Footer`.`current`, `Footer`.`content_id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE ((`Content`.`page_type` = 'news_archive') AND (`Content`.`status` = 'active')) 221
36SELECT `Permissions`.`id`, `Permissions`.`content_id`, `Permissions`.`group_id`, `Permissions`.`allow_view`, `Permissions`.`allow_edit` FROM `page_group_permissions` AS `Permissions` WHERE `Permissions`.`content_id` IN (912, 916) 000
37SELECT `Comment`.`id`, `Comment`.`content_id`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`user_id` FROM `comments` AS `Comment` WHERE `Comment`.`content_id` IN (912, 916) 001
38SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire`, `Text`.`id`, `Text`.`content_id`, `Text`.`name`, `Text`.`text`, `Text`.`current`, `Text`.`lft`, `Text`.`rght`, `Text`.`created`, `Text`.`user`, `Text`.`meta_keywords`, `Text`.`meta_description`, `Shortcut`.`id`, `Shortcut`.`content_id`, `Shortcut`.`url`, `Shortcut`.`current`, `Sidebar`.`id`, `Sidebar`.`content_id`, `Sidebar`.`value`, `Sidebar`.`created`, `Sidebar`.`modified`, `Sidebar`.`current`, `Footer`.`id`, `Footer`.`value`, `Footer`.`created`, `Footer`.`modified`, `Footer`.`current`, `Footer`.`content_id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE ((`Content`.`page_type` = 'event_calendar') AND (`Content`.`status` = 'active')) 001
39SELECT `Shortcut`.`url`, `Text`.`text`, `Content`.*, MONTHNAME(`Content`.`release`) AS month, YEAR(`Content`.`release`) AS year, `Content`.`id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE ((`Content`.`page_type` = 'blog_article') AND (`Content`.`status` = 'active')) 001
40SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`name`, `Content`.`windowtitle`, `Content`.`page_type`, `Content`.`show_in_nav`, `Content`.`status`, `Content`.`created`, `Content`.`modified`, `Content`.`release`, `Content`.`expire`, `Text`.`id`, `Text`.`content_id`, `Text`.`name`, `Text`.`text`, `Text`.`current`, `Text`.`lft`, `Text`.`rght`, `Text`.`created`, `Text`.`user`, `Text`.`meta_keywords`, `Text`.`meta_description`, `Shortcut`.`id`, `Shortcut`.`content_id`, `Shortcut`.`url`, `Shortcut`.`current`, `Sidebar`.`id`, `Sidebar`.`content_id`, `Sidebar`.`value`, `Sidebar`.`created`, `Sidebar`.`modified`, `Sidebar`.`current`, `Footer`.`id`, `Footer`.`value`, `Footer`.`created`, `Footer`.`modified`, `Footer`.`current`, `Footer`.`content_id` FROM `contents` AS `Content` LEFT JOIN `texts` AS `Text` ON (`Text`.`content_id` = `Content`.`id` AND `Text`.`current` = 1) LEFT JOIN `shortcuts` AS `Shortcut` ON (`Shortcut`.`content_id` = `Content`.`id` AND `Shortcut`.`current` = 1) LEFT JOIN `sidebars` AS `Sidebar` ON (`Sidebar`.`content_id` = `Content`.`id` AND `Sidebar`.`current` = 1) LEFT JOIN `footers` AS `Footer` ON (`Footer`.`content_id` = `Content`.`id` AND `Footer`.`current` = 1) WHERE ((`Content`.`page_type` = 'blog') AND (`Content`.`status` = 'active')) 111
41SELECT `Permissions`.`id`, `Permissions`.`content_id`, `Permissions`.`group_id`, `Permissions`.`allow_view`, `Permissions`.`allow_edit` FROM `page_group_permissions` AS `Permissions` WHERE `Permissions`.`content_id` = (938) 001
42SELECT `Comment`.`id`, `Comment`.`content_id`, `Comment`.`comment`, `Comment`.`status`, `Comment`.`created`, `Comment`.`user_id` FROM `comments` AS `Comment` WHERE `Comment`.`content_id` = (938) 000
43SELECT `Permissions`.`id`, `Permissions`.`content_id`, `Permissions`.`group_id`, `Permissions`.`allow_view`, `Permissions`.`allow_edit` FROM `page_group_permissions` AS `Permissions` WHERE `content_id` = 938 AND `group_id` = 2 001
44SELECT `Right`.`id`, `Right`.`group_id`, `Right`.`systemright_id` FROM `rights` AS `Right` WHERE `group_id` = 2 AND `systemright_id` = 'ViewPages' 110