SELECT `id`,`catid`,`title`,`date`,`image`,`buy_time`,`customer`,`content`,`sort`,`status`,`hits`,`admin_id`,`url`,`subtitle`,`diyurl`,`seo_title`,`seo_keywords`,`seo_description`,`keywords`,`acceptance_products` FROM `spzg_resource` WHERE ( ( `id` = 10 AND `status` = 1 AND `catid` = 38 ) ) AND `spzg_resource`.`delete_time` = '0' LIMIT 1 [ RunTime:0.009745s ]
SELECT `id`,`catid`,`title`,`url`,`sort` FROM `spzg_resource` WHERE ( ( `status` = 1 AND `catid` = 38 AND `id` = 10 ) ) AND `spzg_resource`.`delete_time` = '0' LIMIT 1 [ RunTime:0.009393s ]
SHOW FULL COLUMNS FROM `spzg_resource` [ RunTime:0.009783s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_resource` WHERE ( ( `sort` < 100 OR ( `sort` = 100 AND `date` = > ) OR ( `sort` = 100 AND `id` > 10 ) ) AND `status` = 1 AND `catid` = 38 ) AND `spzg_resource`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.009517s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_resource` WHERE ( ( `sort` > 100 OR ( `sort` = 100 AND `date` = < ) OR ( `sort` = 100 AND `id` < 10 ) ) AND `status` = 1 AND `catid` = 38 ) AND `spzg_resource`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.009448s ]
UPDATE `spzg_resource` SET `hits` = 12 , `update_time` = 1787510130 WHERE ( `id` = 10 ) AND `spzg_resource`.`delete_time` = '0' [ RunTime:0.009415s ]
SHOW FULL COLUMNS FROM `spzg_search_index` [ RunTime:0.009827s ]
SELECT * FROM `spzg_search_index` WHERE ( `module_key` = 'resource' AND `data_id` = 10 AND `catid` = 38 ) AND `spzg_search_index`.`delete_time` = '0' LIMIT 1 [ RunTime:0.009524s ]
SHOW FULL COLUMNS FROM `spzg_category` [ RunTime:0.009777s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|31|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009291s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 31 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009285s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|33|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009383s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 33 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009300s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|34|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009349s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 34 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009553s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|35|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009316s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 35 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009344s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|36|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009377s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 36 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009417s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|63|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009359s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 63 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009293s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|32|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009338s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 32 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009420s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|59|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009354s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 59 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009345s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|64|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009337s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 64 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009367s ]
SELECT `id` FROM `spzg_category` WHERE ( `status` = 1 AND FIND_IN_SET('|72|', `parent`) ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009340s ]
SELECT `id`,`catid`,`title`,`english`,`image`,`date`,`url`,`diyurl` FROM `spzg_product` WHERE ( ( status = 1 and catid = 72 ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 5 [ RunTime:0.009345s ]
SELECT * FROM `spzg_resource` WHERE ( `id` = 10 ) AND `spzg_resource`.`delete_time` = '0' LIMIT 1 [ RunTime:0.009451s ]
SHOW FULL COLUMNS FROM `spzg_application_product_ass` [ RunTime:0.009680s ]
SELECT `spzg_product`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`did` AS `pivot__did`,`pivot`.`pro_id` AS `pivot__pro_id`,`pivot`.`catid` AS `pivot__catid` FROM `spzg_product` INNER JOIN `spzg_application_product_ass` `pivot` ON `pivot`.`pro_id`=`spzg_product`.`id` WHERE ( ( `pivot`.`did` = '10' ) ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 4 [ RunTime:0.009443s ]
SELECT `id`,`catid`,`title`,`keywords` FROM `spzg_resource` WHERE ( `status` = 1 AND `id` = 10 ) AND `spzg_resource`.`delete_time` = '0' LIMIT 1 [ RunTime:0.009411s ]
SELECT * FROM `spzg_category` WHERE ( ( `id` = 38 ) ) AND `spzg_category`.`delete_time` = '0' [ RunTime:0.009478s ]
show tables like 'spzg_visit_logs_202608' [ RunTime:0.009730s ]
SHOW FULL COLUMNS FROM `spzg_visit_logs_202608` [ RunTime:0.009803s ]
SELECT * FROM `spzg_visit_logs_202608` WHERE `session_id` = '2120c7cbed2b2f97b0a8d9c1a0afccb4' AND `create_time` > 1787508330 LIMIT 1 [ RunTime:0.012381s ]
SHOW FULL COLUMNS FROM `spzg_daily_visits` [ RunTime:0.009614s ]
SELECT * FROM `spzg_daily_visits` WHERE `date` = '2026-08-24' LIMIT 1 [ RunTime:0.009373s ]
SELECT COUNT(*) AS think_count FROM `spzg_visit_logs_202608` WHERE `create_time` BETWEEN 1787500800 AND 1787587200 [ RunTime:0.010387s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `spzg_visit_logs_202608` WHERE `create_time` BETWEEN 1787500800 AND 1787587200 GROUP BY `session_id` ) `_group_count_` [ RunTime:0.011274s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `spzg_visit_logs_202608` WHERE `create_time` BETWEEN 1787500800 AND 1787587200 GROUP BY `ip` ) `_group_count_` [ RunTime:0.010776s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `spzg_visit_logs_202608` WHERE `create_time` BETWEEN 1787500800 AND 1787587200 AND `is_new` = 1 GROUP BY `session_id` ) `_group_count_` [ RunTime:0.012393s ]
