Pagina: 1196 - Queries (21/28)
Aantal queries unique: 21
Aantal queries total: 28

[2] SELECT SQL_CALC_FOUND_ROWS `template_id`,`active`,`deleted`,`custom_template`,`newsletter_ready`,`name`,`version`,`creation_date`,`author`,`directory`,`front_js`,`create_id`,`alter_id`,`create_date`,`alter_date`,`support_page_id`,`bootstrap` FROM `sys_template` WHERE (`template_id`=111) AND (`active`=1) AND (`deleted`=0)
[1] SELECT r.target_id, r.target_system_id, r.primary, r.path FROM `sys_route` AS r LEFT JOIN `sys_repository_item` sri ON (sri.item_id = r.target_id AND sri.item_system_id = r.target_system_id) WHERE (r.site_id=2 OR r.site_id IS NULL) AND r.`active` = "1" AND r.target_type = "page" AND (r.path LIKE "ebooks_en_e_readers_bij_de_bibliotheek_maastricht" OR r.path LIKE "ebooks_en_e_readers_bij_de_bibliotheek_maastricht_") AND sri.deleted = "0" AND r.regex = "0"
[1] SELECT SQL_CALC_FOUND_ROWS `item_id`,`item_system_id`,`source_id`,`source_system_id`,`status`,`comment` FROM `sys_repository_item_status` WHERE (`item_id`=1196) AND (`item_system_id`=127)
[2] SELECT SQL_CALC_FOUND_ROWS `item_id`,`item_system_id`,`item_type`,`node_id`,`node_system_id`,`name`,`deleted`,`create_id`,`alter_id`,`create_date`,`alter_date`,`lockable` FROM `sys_repository_item` WHERE (`item_id`=1196) AND (`item_system_id`=127) AND (`item_type`=10) AND (`deleted`=0)
[2] SELECT SQL_CALC_FOUND_ROWS `page_id`,`page_system_id`,`layout`,`title`,`searchable` FROM `mod_page` WHERE (`page_id`=1196) AND (`page_system_id`=127)
[1] SELECT fieldname,value FROM `sys_repository_item_metadata` WHERE `item_id` = 1196
[1] SELECT tag FROM `sys_repository_item_tag` WHERE `item_id` = 1196
[1] SELECT layout_file FROM `sys_template_panel` WHERE template_id=111 AND layout='Homepage' GROUP BY layout
[1] SELECT SQL_CALC_FOUND_ROWS `template_id`,`name`,`impl` FROM `sys_template_smarty_plugin` WHERE (`template_id`=111)
[1] SELECT FOUND_ROWS()
[1] SELECT SQL_CALC_FOUND_ROWS `node_id`,`node_system_id`,`parent_id`,`parent_system_id`,`name`,`deleted`,`create_id`,`alter_id`,`create_date`,`alter_date` FROM `sys_repository_node` WHERE (`node_id`=137) AND (`node_system_id`=127)
[1] SELECT SQL_CALC_FOUND_ROWS `node_id`,`node_system_id`,`parent_id`,`parent_system_id`,`name`,`deleted`,`create_id`,`alter_id`,`create_date`,`alter_date` FROM `sys_repository_node` WHERE (`node_id`=14) AND (`node_system_id`=127)
[2] SELECT SQL_CALC_FOUND_ROWS `node_id`,`node_system_id`,`parent_id`,`parent_system_id`,`name`,`deleted`,`create_id`,`alter_id`,`create_date`,`alter_date` FROM `sys_repository_node` WHERE (`node_id`=3) AND (`node_system_id`=127)
[4] SELECT SQL_CALC_FOUND_ROWS `node_id`,`node_system_id`,`parent_id`,`parent_system_id`,`name`,`deleted`,`create_id`,`alter_id`,`create_date`,`alter_date` FROM `sys_repository_node` WHERE (`node_id`=1) AND (`node_system_id`=127)
[1] SELECT IF(r.restriction_id IS NULL OR r.restriction_id = 0, 0, IF(r.restriction_system_id = 127, r.restriction_id, CONCAT(r.restriction_id,"-",r.restriction_system_id))) FROM mod_restriction r INNER JOIN sys_repository_item ri ON (r.restriction_id=ri.item_id AND r.restriction_system_id=ri.item_system_id) LEFT JOIN mod_restriction_page rp ON r.restriction_id=rp.restriction_id AND r.restriction_system_id=rp.restriction_system_id LEFT JOIN mod_restriction_folder rf ON r.restriction_id=rf.restriction_id AND r.restriction_system_id=rf.restriction_system_id LEFT JOIN mod_restriction_site rs ON r.restriction_id=rs.restriction_id AND r.restriction_system_id=rs.restriction_system_id WHERE ri.deleted=0 AND ((rp.page_id=1196 AND rp.page_system_id=127) OR (rs.site_id=2) OR (rf.folder_id=14 AND rf.folder_system_id=127) OR (rf.folder_id=3 AND rf.folder_system_id=127) OR (rf.folder_id=1 AND rf.folder_system_id=127) OR (rf.folder_id=137 AND rf.folder_system_id=127)) GROUP BY r.restriction_id, r.restriction_system_id
[1] SELECT tp.name FROM `sys_template_panel` AS tp INNER JOIN `sys_template` AS t ON t.template_id=tp.template_id WHERE t.active=1 AND t.deleted=0 AND tp.layout="Homepage" GROUP BY tp.name
[1] SELECT mp.*, IF(mp.panel_id IS NULL OR mp.panel_id = 0, 0, IF(mp.panel_system_id = 127, mp.panel_id, CONCAT(mp.panel_id,"-",mp.panel_system_id))) AS _panel_id, IF(mp.page_id IS NULL OR mp.page_id = 0, 0, IF(mp.page_system_id = 127, mp.page_id, CONCAT(mp.page_id,"-",mp.page_system_id))) AS _page_id, IF(stp.layout IS NULL, 0, 1) AS in_layout FROM mod_page_panel AS mp LEFT JOIN sys_template_panel AS stp ON ((stp.name = mp.name) AND (stp.layout = "Homepage")) WHERE mp.page_id = "1196" AND mp.page_system_id = "127" AND NOT stp.layout IS NULL GROUP BY mp.name ORDER BY stp.taborder
[1] SELECT sri.*, sp.name as `panel_name`, mpi.panel_item_id, mpi.panel_item_id AS _panel_item_id, IF(sri.item_id IS NULL OR sri.item_id = 0, 0, IF(sri.item_system_id = 127, sri.item_id, CONCAT(sri.item_id,"-",sri.item_system_id))) AS _item_id, IF(sri.node_id IS NULL OR sri.node_id = 0, 0, IF(sri.node_system_id = 127, sri.node_id, CONCAT(sri.node_id,"-",sri.node_system_id))) AS _node_id, IF(srim.fieldname = "file_type", srim.value, null) as "file_type", mpi.exe_priority, mpi.active FROM sys_repository_item AS sri LEFT JOIN sys_repository_item_metadata AS srim ON (sri.item_id = srim.item_id) AND (sri.item_system_id = srim.item_system_id AND srim.fieldname = "file_type") INNER JOIN sys_site_panel_item AS mpi ON (sri.item_id = mpi.item_id) INNER JOIN sys_site_panel AS sp ON ( mpi.panel_id = sp.panel_id ) WHERE sp.name IN ("blh_logo","blh_topmenu","blh_submenu","blh_mainmenu","blh_search","blh_breadcrumb","blh_right_dc","blh_footer_banner","blh_footer_menu","blh_bottom","blh_head_hidden") AND sp.site_id = 2 AND sri.deleted=0 ORDER BY mpi.order_id
[1] SELECT * FROM `sys_site_panel_display_option` WHERE panel_item_id IN (60,61,62,59,58,64)
[1] SELECT sri.*, mpi.panel_item_id, mpi.panel_item_system_id, IF(mpi.panel_item_id IS NULL OR mpi.panel_item_id = 0, 0, IF(mpi.panel_item_system_id = 127, mpi.panel_item_id, CONCAT(mpi.panel_item_id,"-",mpi.panel_item_system_id))) AS _panel_item_id, IF(sri.item_id IS NULL OR sri.item_id = 0, 0, IF(sri.item_system_id = 127, sri.item_id, CONCAT(sri.item_id,"-",sri.item_system_id))) AS _item_id, IF(sri.node_id IS NULL OR sri.node_id = 0, 0, IF(sri.node_system_id = 127, sri.node_id, CONCAT(sri.node_id,"-",sri.node_system_id))) AS _node_id, IF(mpi.panel_id IS NULL OR mpi.panel_id = 0, 0, IF(mpi.panel_system_id = 127, mpi.panel_id, CONCAT(mpi.panel_id,"-",mpi.panel_system_id))) AS _panel_id, IF(srim.fieldname = "file_type", srim.value, null) as "file_type", sri.alter_date, mpi.exe_priority, mpi.active FROM sys_repository_item AS sri LEFT JOIN sys_repository_item_metadata AS srim ON (sri.item_id = srim.item_id) AND (sri.item_system_id = srim.item_system_id AND srim.fieldname = "file_type") INNER JOIN mod_page_panel_item AS mpi ON (sri.item_id = mpi.item_id) AND (sri.item_system_id = mpi.item_system_id) WHERE ( mpi.panel_id = 2398 OR mpi.panel_id = 2400 OR mpi.panel_id = 4507) AND sri.deleted=0 ORDER BY mpi.order_id ASC
[1] SELECT * FROM mod_page_panel_display_option WHERE (panel_item_id = 4520 AND panel_item_system_id = 127) OR (panel_item_id = 4363 AND panel_item_system_id = 127) OR (panel_item_id = 4521 AND panel_item_system_id = 127) OR (panel_item_id = 4477 AND panel_item_system_id = 127) OR (panel_item_id = 4364 AND panel_item_system_id = 127) OR (panel_item_id = 700 AND panel_item_system_id = 127) OR (panel_item_id = 2706 AND panel_item_system_id = 127) OR (panel_item_id = 3130 AND panel_item_system_id = 127) OR (panel_item_id = 2413 AND panel_item_system_id = 127) OR (panel_item_id = 2412 AND panel_item_system_id = 127) OR (panel_item_id = 699 AND panel_item_system_id = 127)