Database Queries

Check application configuration section [log] for traceLevel
Total 19 éléments.
TimeDurationTypeDuplicatedQuery
   
08:42:22.3931,2 msSELECT1
SELECT `short_code`, `id` FROM `admin_lang`

08:42:22.3992,7 msSELECT1
SELECT `item`.`id`, `item`.`nav_id`, `item`.`title`, `item`.`description`, `item`.`keywords`, `item`.`image_id`, `item`.`is_url_strict_parsing_disabled`, `item`.`alias`, `item`.`title_tag`, `item`.`timestamp_create`, `item`.`timestamp_update`, `item`.`create_user_id`, `item`.`update_user_id`, `nav`.`is_home`, `nav`.`parent_nav_id`, `nav`.`sort_index`, `nav`.`is_hidden`, `item`.`nav_item_type`, `item`.`nav_item_type_id`, `nav_container`.`alias` AS `container` FROM `cms_nav_item` `item` LEFT JOIN `cms_nav` `nav` ON nav.id=item.nav_id LEFT JOIN `cms_nav_container` `nav_container` ON nav_container.id=nav.nav_container_id WHERE ((`nav`.`is_deleted`=FALSE) AND (`item`.`lang_id`='2') AND (`nav`.`is_offline`=FALSE) AND (`nav`.`is_draft`=FALSE)) AND ((`publish_from` IS NULL) OR (`publish_from` <= 1775457742)) AND ((`publish_till` IS NULL) OR (`publish_till` >= 1775457742)) ORDER BY `container`, `parent_nav_id`, `nav`.`sort_index`

08:42:22.4060,5 msSELECT1
SELECT * FROM `cms_nav_item` WHERE `id`=3

08:42:22.4072,1 msSHOW1
SHOW FULL COLUMNS FROM `cms_nav_item`
08:42:22.4103,8 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'cms_nav_item' AND kcu.table_name = 'cms_nav_item'

08:42:22.4160,5 msSELECT1
SELECT * FROM `cms_nav` WHERE `id`=1

08:42:22.4171,6 msSHOW1
SHOW FULL COLUMNS FROM `cms_nav`
08:42:22.4191,5 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'cms_nav' AND kcu.table_name = 'cms_nav'

08:42:22.4212,4 msSELECT1
SELECT * FROM `cms_nav_property` WHERE `nav_id`=1

08:42:22.4262,3 msSHOW1
SHOW FULL COLUMNS FROM `cms_nav_item_page`
08:42:22.4281,4 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'cms_nav_item_page' AND kcu.table_name = 'cms_nav_item_page'

08:42:22.4302,0 msSELECT1
SELECT * FROM `cms_nav_item_page` WHERE `id`=3

08:42:22.4342,0 msSELECT1
SELECT * FROM `cms_layout` WHERE `id`=1

08:42:22.4431,9 msSHOW1
SHOW FULL COLUMNS FROM `cms_layout`
08:42:22.4451,5 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'cms_layout' AND kcu.table_name = 'cms_layout'

08:42:22.4524,5 msSELECT1
SELECT `t1`.`id`, `t1`.`block_id`, `t1`.`json_config_values`, `t1`.`json_config_cfg_values`, `t1`.`variation`, `t2`.`class` FROM `cms_nav_item_page_block_item` `t1` INNER JOIN `cms_block` `t2` ON t2.id=t1.block_id WHERE (`nav_item_page_id`=3) AND (`placeholder_var`='content') AND (`prev_id`=0) AND (`is_hidden`=0) ORDER BY `sort_index`

08:42:22.4671,7 msSELECT1
SELECT `id`, `file_id`, `filter_id`, `resolution_width`, `resolution_height` FROM `admin_storage_image`

08:42:22.4702,0 msSELECT1
SELECT `id`, `is_hidden`, `is_deleted`, `folder_id`, `name_original`, `name_new`, `name_new_compound`, `mime_type`, `extension`, `hash_name`, `hash_file`, `upload_timestamp`, `file_size`, `upload_user_id`, `caption` FROM `admin_storage_file`

08:42:22.5041,9 msSELECT1
SELECT `id`, `identifier`, `name` FROM `admin_storage_filter` ORDER BY `name`