SHOW FULL COLUMNS FROM `website_domains` [ RunTime:0.001390s ]
SELECT * FROM `website_domains` WHERE `domain` = 'binguolai.com' LIMIT 1 [ RunTime:0.000999s ]
SHOW FULL COLUMNS FROM `websites` [ RunTime:0.001401s ]
SELECT * FROM `websites` WHERE `id` = 59 AND `status` = 1 AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000912s ]
SHOW FULL COLUMNS FROM `website_templates` [ RunTime:0.001281s ]
SELECT * FROM `website_templates` WHERE `id` = 33 AND `status` = 1 AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000796s ]
SHOW FULL COLUMNS FROM `website_slot_bindings` [ RunTime:0.001236s ]
SELECT `b`.*,c.name collection_name,`c`.`table_suffix`,`c`.`physical_table` FROM `website_slot_bindings` `b` LEFT JOIN `data_collections` `c` ON `c`.`id`=`b`.`collection_id` WHERE `b`.`site_id` = '59' ORDER BY `b`.`id` [ RunTime:0.000940s ]
SHOW FULL COLUMNS FROM `website_data_source_overrides` [ RunTime:0.001201s ]
SELECT * FROM `website_data_source_overrides` WHERE `site_id` = 59 AND `status` = 1 ORDER BY `id` [ RunTime:0.000819s ]
SHOW FULL COLUMNS FROM `data_collections` [ RunTime:0.001273s ]
SELECT `id` FROM `data_collections` WHERE `collection_code` = 'fenleixinxi' AND `deleted_at` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000747s ]
SELECT * FROM `data_collections` WHERE `id` = 22 AND `deleted_at` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000774s ]
SHOW FULL COLUMNS FROM `data_set_fields` [ RunTime:0.001555s ]
SELECT * FROM `data_set_fields` WHERE `collection_id` = 22 ORDER BY `sort_order`,`id` [ RunTime:0.001101s ]
SHOW FULL COLUMNS FROM `website_data_visibilities` [ RunTime:0.001237s ]
SELECT * FROM `website_data_visibilities` WHERE `site_id` = 59 AND `source_alias` = 'fenleixinxi' LIMIT 1 [ RunTime:0.000747s ]
SELECT `id` FROM `data_collections` WHERE `collection_code` = 'shop_jd' AND `deleted_at` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000731s ]
SELECT * FROM `data_collections` WHERE `id` = 25 AND `deleted_at` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000767s ]
SELECT * FROM `data_set_fields` WHERE `collection_id` = 25 ORDER BY `sort_order`,`id` [ RunTime:0.001068s ]
SELECT * FROM `website_data_visibilities` WHERE `site_id` = 59 AND `source_alias` = 'goods' LIMIT 1 [ RunTime:0.000751s ]
SHOW FULL COLUMNS FROM `website_documents` [ RunTime:0.001311s ]
SELECT * FROM `website_documents` WHERE `site_id` = 59 AND `deleted_at` IS NULL AND `status` = 1 ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000938s ]
SHOW FULL COLUMNS FROM `system_settings` [ RunTime:0.001157s ]
SELECT * FROM `system_settings` WHERE `setting_key` = 'content_search_engine' LIMIT 1 [ RunTime:0.000724s ]
SELECT * FROM `system_settings` WHERE `setting_key` = 'content_search_engine' LIMIT 1 [ RunTime:0.000721s ]
SELECT * FROM `system_settings` WHERE `setting_key` = 'content_search_engine' LIMIT 1 [ RunTime:0.000709s ]
CREATE TABLE IF NOT EXISTS `content_search_logs` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`operation` VARCHAR(64) NOT NULL DEFAULT '',
`entry_path` VARCHAR(255) NOT NULL DEFAULT '',
`source` VARCHAR(128) NOT NULL DEFAULT '',
`index_uid` VARCHAR(128) NOT NULL DEFAULT '',
`collection_code` VARCHAR(64) NOT NULL DEFAULT '',
`keyword` VARCHAR(255) NOT NULL DEFAULT '',
`filter_expr` VARCHAR(1000) NOT NULL DEFAULT '',
`sort_expr` VARCHAR(255) NOT NULL DEFAULT '',
`method` VARCHAR(12) NOT NULL DEFAULT '',
`path` VARCHAR(255) NOT NULL DEFAULT '',
`status_code` INT NOT NULL DEFAULT 0,
`duration_ms` INT NOT NULL DEFAULT 0,
`result_count` INT NULL,
`total_hits` INT NULL,
`error_message` VARCHAR(1000) NULL,
`created_at` DATETIME NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_created` (`created_at`),
KEY `idx_collection_created` (`collection_code`, `created_at`),
KEY `idx_operation_created` (`operation`, `created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.004174s ]
SHOW COLUMNS FROM `content_search_logs` LIKE 'entry_path' [ RunTime:0.001169s ]
SHOW FULL COLUMNS FROM `content_search_logs` [ RunTime:0.001202s ]