Database Queries

SELECT * FROM `cms_website` WHERE (`cms_website`.`is_deleted`=FALSE) AND (`is_active`=TRUE)

SELECT `base_path` FROM `cms_theme` WHERE `is_default`=1

SELECT `value`, `name` FROM `admin_config`

SELECT GET_LOCK('14c2c3805cf9fe67e7c8cb8bd42d65a0479e6079', 3)

SHOW FULL COLUMNS FROM `admin_queue`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'admin_queue' AND `kcu`.`TABLE_NAME` = 'admin_queue'

UPDATE `admin_queue` SET `reserved_at`=NULL WHERE `reserved_at` is not null and `reserved_at` < 1756287628 - `ttr` and `done_at` is null

SELECT * FROM `admin_queue` WHERE ((`channel`='default') AND (`reserved_at` IS NULL)) AND (`pushed_at` <= 1756287628 - `delay`) ORDER BY `priority`, `id` LIMIT 1

SELECT RELEASE_LOCK('14c2c3805cf9fe67e7c8cb8bd42d65a0479e6079')

SELECT * FROM `admin_config` WHERE `name`='queue_timestamp'

SHOW FULL COLUMNS FROM `admin_config`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'admin_config' AND `kcu`.`TABLE_NAME` = 'admin_config'

UPDATE `admin_config` SET `value`='1756287628' WHERE `id`=5

SHOW FULL COLUMNS FROM `news_article`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'news_article' AND `kcu`.`TABLE_NAME` = 'news_article'

SELECT * FROM `news_article` WHERE (`news_article`.`is_deleted`=FALSE) AND ((`id`='20') AND (`is_deleted`=FALSE) AND (`is_online`=TRUE))

SELECT * FROM `admin_lang` WHERE `is_deleted`=FALSE ORDER BY `is_default` DESC

SELECT `id`, `file_id`, `filter_id`, `resolution_width`, `resolution_height` FROM `admin_storage_image`

SELECT `id`, `identifier`, `name` FROM `admin_storage_filter` ORDER BY `name`

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`

SELECT `short_code`, `id` FROM `admin_lang`

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 (`nav_container`.`website_id`=1) AND (`item`.`lang_id`=1) AND (`nav`.`is_offline`=FALSE) AND (`nav`.`is_draft`=FALSE) ORDER BY `container`, `parent_nav_id`, `nav`.`sort_index`

SELECT `id`, `type`, `value`, `target` FROM `cms_nav_item_redirect`

SHOW FULL COLUMNS FROM `cms_nav`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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'

SELECT * FROM `cms_nav` WHERE `id`=16

SELECT * FROM `cms_nav_property` WHERE `nav_id`=16

SELECT * FROM `cms_nav` WHERE `id`=13

SELECT * FROM `cms_nav_property` WHERE `nav_id`=13

SELECT * FROM `cms_nav` WHERE `id`=29

SELECT * FROM `cms_nav_property` WHERE `nav_id`=29

SELECT * FROM `cms_nav` WHERE `id`=15

SELECT * FROM `cms_nav_property` WHERE `nav_id`=15

SELECT * FROM `cms_nav` WHERE `id`=37

SELECT * FROM `cms_nav_property` WHERE `nav_id`=37

SELECT * FROM `cms_nav` WHERE `id`=36

SELECT * FROM `cms_nav_property` WHERE `nav_id`=36

SELECT * FROM `cms_nav` WHERE `id`=32

SELECT * FROM `cms_nav_property` WHERE `nav_id`=32