SELECT `id`,`catid`,`title`,`english`,`date`,`image`,`images`,`video`,`remark`,`information`,`info_title`,`sort`,`is_home`,`is_hot`,`status`,`keywords`,`hits`,`custom_download`,`admin_id`,`url`,`diyurl`,`seo_title`,`seo_keywords`,`seo_description` FROM `spzg_product` WHERE ( ( `id` = 1 AND `status` = 1 AND `catid` = 31 ) ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.008354s ]
SELECT `id`,`catid`,`title`,`url`,`sort` FROM `spzg_product` WHERE ( ( `status` = 1 AND `catid` = 31 AND `id` = 1 ) ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.008078s ]
SHOW FULL COLUMNS FROM `spzg_product` [ RunTime:0.008594s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_product` WHERE ( ( `sort` < 100 OR ( `sort` = 100 AND `date` = > ) OR ( `sort` = 100 AND `id` > 1 ) ) AND `status` = 1 AND `catid` = 31 ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.008104s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_product` WHERE ( ( `sort` > 100 OR ( `sort` = 100 AND `date` = < ) OR ( `sort` = 100 AND `id` < 1 ) ) AND `status` = 1 AND `catid` = 31 ) AND `spzg_product`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.008193s ]
UPDATE `spzg_product` SET `hits` = 13 , `update_time` = 1782200730 WHERE ( `id` = 1 ) AND `spzg_product`.`delete_time` = '0' [ RunTime:0.008286s ]
SHOW FULL COLUMNS FROM `spzg_category` [ RunTime:0.008494s ]
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.007857s ]
SELECT `id`,`catid`,`title`,`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.008008s ]
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.007841s ]
SELECT `id`,`catid`,`title`,`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.008003s ]
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.007820s ]
SELECT `id`,`catid`,`title`,`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.007987s ]
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.009057s ]
SELECT `id`,`catid`,`title`,`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.007960s ]
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.008440s ]
SELECT `id`,`catid`,`title`,`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.007966s ]
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.007878s ]
SELECT `id`,`catid`,`title`,`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.007986s ]
SELECT `id`,`catid`,`title`,`image` FROM `spzg_product` WHERE ( `status` = 1 AND `catid` = 31 AND `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.007978s ]
SHOW FULL COLUMNS FROM `spzg_content` [ RunTime:0.008524s ]
SELECT `id`,`catid`,`did`,`title`,`mode`,`d_images`,`d_title`,`d_remark`,`content`,`d_content` FROM `spzg_content` WHERE `status` = 1 AND ( `did` = 1 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.007972s ]
SELECT * FROM `spzg_product` WHERE ( `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.008110s ]
SHOW FULL COLUMNS FROM `spzg_product_application_ass` [ RunTime:0.008181s ]
SELECT `spzg_application`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`catid` AS `pivot__catid`,`pivot`.`pro_id` AS `pivot__pro_id`,`pivot`.`aid` AS `pivot__aid` FROM `spzg_application` INNER JOIN `spzg_product_application_ass` `pivot` ON `pivot`.`aid`=`spzg_application`.`id` WHERE ( ( `pivot`.`pro_id` = '1' ) ) AND `spzg_application`.`delete_time` = '0' ORDER BY `sort` ASC [ RunTime:0.012231s ]
SELECT * FROM `spzg_product` WHERE ( `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.008031s ]
SHOW FULL COLUMNS FROM `spzg_product_software_ass` [ RunTime:0.008206s ]
SELECT `spzg_software`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`catid` AS `pivot__catid`,`pivot`.`pro_id` AS `pivot__pro_id`,`pivot`.`aid` AS `pivot__aid` FROM `spzg_software` INNER JOIN `spzg_product_software_ass` `pivot` ON `pivot`.`aid`=`spzg_software`.`id` WHERE ( ( `pivot`.`pro_id` = '1' ) ) AND `spzg_software`.`delete_time` = '0' ORDER BY `sort` ASC [ RunTime:0.011456s ]
SELECT * FROM `spzg_product` WHERE ( `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.008003s ]
SHOW FULL COLUMNS FROM `spzg_product_download_ass` [ RunTime:0.008206s ]
SELECT `spzg_download`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`catid` AS `pivot__catid`,`pivot`.`pro_id` AS `pivot__pro_id`,`pivot`.`aid` AS `pivot__aid` FROM `spzg_download` INNER JOIN `spzg_product_download_ass` `pivot` ON `pivot`.`aid`=`spzg_download`.`id` WHERE ( ( `pivot`.`pro_id` = '1' ) ) AND `spzg_download`.`delete_time` = '0' ORDER BY `sort` ASC [ RunTime:0.008401s ]
SELECT * FROM `spzg_product` WHERE ( `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.008697s ]
SHOW FULL COLUMNS FROM `spzg_product_case_ass` [ RunTime:0.008308s ]
SELECT `spzg_resource`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`catid` AS `pivot__catid`,`pivot`.`pro_id` AS `pivot__pro_id`,`pivot`.`aid` AS `pivot__aid` FROM `spzg_resource` INNER JOIN `spzg_product_case_ass` `pivot` ON `pivot`.`aid`=`spzg_resource`.`id` WHERE ( ( `pivot`.`pro_id` = '1' ) ) AND `spzg_resource`.`delete_time` = '0' ORDER BY `sort` ASC [ RunTime:0.008645s ]
SELECT * FROM `spzg_product` WHERE ( `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.007980s ]
SHOW FULL COLUMNS FROM `spzg_product_video_ass` [ RunTime:0.008542s ]
SELECT `spzg_video`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`catid` AS `pivot__catid`,`pivot`.`pro_id` AS `pivot__pro_id`,`pivot`.`aid` AS `pivot__aid` FROM `spzg_video` INNER JOIN `spzg_product_video_ass` `pivot` ON `pivot`.`aid`=`spzg_video`.`id` WHERE ( ( `pivot`.`pro_id` = '1' ) ) AND `spzg_video`.`delete_time` = '0' ORDER BY `sort` ASC [ RunTime:0.008302s ]
SELECT `id`,`catid`,`title`,`keywords` FROM `spzg_product` WHERE ( `status` = 1 AND `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.008109s ]
SELECT * FROM `spzg_category` WHERE ( ( `id` = 31 ) ) AND `spzg_category`.`delete_time` = '0' [ RunTime:0.008260s ]
SELECT `a`.`id`,`a`.`catid`,`a`.`title`,`a`.`date`,`a`.`diyurl`,`a`.`url`,`a`.`keywords`,`a`.`sort` FROM `spzg_application` `a` INNER JOIN `spzg_category` `c` ON `a`.`catid`=c.id and c.status = 1 and c.delete_time = 0 WHERE ( ( a.status = 1 and (a.keywords like '光谱成像系统') ) ) AND `a`.`delete_time` = '0' ORDER BY `a`.`sort` ASC,`a`.`date` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.013254s ]
SELECT `a`.`id`,`a`.`catid`,`a`.`title`,`a`.`date`,`a`.`diyurl`,`a`.`url`,`a`.`keywords`,`a`.`sort` FROM `spzg_article` `a` INNER JOIN `spzg_category` `c` ON `a`.`catid`=c.id and c.status = 1 and c.delete_time = 0 WHERE ( ( a.status = 1 and (a.keywords like '光谱成像系统') ) ) AND `a`.`delete_time` = '0' ORDER BY `a`.`sort` ASC,`a`.`date` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.009229s ]
SELECT `id`,`catid`,`title`,`keywords` FROM `spzg_product` WHERE ( `status` = 1 AND `id` = 1 ) AND `spzg_product`.`delete_time` = '0' LIMIT 1 [ RunTime:0.007905s ]
SELECT * FROM `spzg_category` WHERE ( ( `id` = 31 ) ) AND `spzg_category`.`delete_time` = '0' [ RunTime:0.007954s ]
SELECT `a`.`id`,`a`.`catid`,`a`.`title`,`a`.`english`,`a`.`date`,`a`.`url`,`a`.`image`,`a`.`diyurl`,`a`.`is_hot`,`a`.`remark` FROM `spzg_product` `a` INNER JOIN `spzg_category` `c` ON `a`.`catid`=c.id and c.status = 1 and c.delete_time = 0 WHERE ( ( a.status = 1 and a.id <> 1 and (a.keywords like '光谱成像系统') ) ) AND `a`.`delete_time` = '0' ORDER BY `a`.`sort` ASC,`a`.`date` DESC,`a`.`id` DESC LIMIT 4 [ RunTime:0.008258s ]
show tables like 'spzg_visit_logs_202606' [ RunTime:0.008149s ]
SHOW FULL COLUMNS FROM `spzg_visit_logs_202606` [ RunTime:0.011539s ]
SELECT * FROM `spzg_visit_logs_202606` WHERE `session_id` = 'd241d5f183f2fbb978c490b579e78e81' AND `create_time` > 1782198930 LIMIT 1 [ RunTime:0.008877s ]
SHOW FULL COLUMNS FROM `spzg_daily_visits` [ RunTime:0.008260s ]
SELECT * FROM `spzg_daily_visits` WHERE `date` = '2026-06-23' LIMIT 1 [ RunTime:0.007938s ]
SELECT COUNT(*) AS think_count FROM `spzg_visit_logs_202606` WHERE `create_time` BETWEEN 1782144000 AND 1782230400 [ RunTime:0.008109s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `spzg_visit_logs_202606` WHERE `create_time` BETWEEN 1782144000 AND 1782230400 GROUP BY `session_id` ) `_group_count_` [ RunTime:0.010241s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `spzg_visit_logs_202606` WHERE `create_time` BETWEEN 1782144000 AND 1782230400 GROUP BY `ip` ) `_group_count_` [ RunTime:0.008741s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `spzg_visit_logs_202606` WHERE `create_time` BETWEEN 1782144000 AND 1782230400 AND `is_new` = 1 GROUP BY `session_id` ) `_group_count_` [ RunTime:0.008983s ]
