[ DB ] CONNECT:[ UseTime:0.009419s ] mysql:host=119.23.172.220;port=3306;dbname=old999;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ht_position` [ RunTime:0.006757s ]
[ SQL ] SELECT `id`,`name`,`nav_menu_id` FROM `ht_position` WHERE `type` = 0 AND `is_delete` = 0 AND `status` = 1 ORDER BY `list_order` ASC,`add_time` ASC [ RunTime:0.006058s ]
[ SQL ] SHOW COLUMNS FROM `ht_nav_menu` [ RunTime:0.006437s ]
[ SQL ] SELECT `id`,`name`,parent_id as parentId FROM `ht_nav_menu` WHERE `nav_id` = 3 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.006107s ]
[ SQL ] SHOW COLUMNS FROM `ht_ad` [ RunTime:0.006796s ]
[ SQL ] SELECT `id`,`cover`,`title`,`product_id`,`type` FROM `ht_ad` WHERE `position` = 3 AND `status` = 1 ORDER BY `list_order` ASC,`add_time` DESC [ RunTime:0.006317s ]
[ SQL ] SELECT `p`.`id`,`p`.`name`,`p`.`nav_menu_id`,`p`.`cover`,`p`.`limit` FROM `ht_position` `p` WHERE `p`.`type` = '4' AND `p`.`is_delete` = '0' AND `p`.`status` = '1' ORDER BY `p`.`list_order` ASC,`p`.`id` ASC [ RunTime:0.006136s ]
[ SQL ] SELECT `id`,name as title,nav_id as type FROM `ht_nav_menu` WHERE `parent_id` = '65' AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 12 [ RunTime:0.006015s ]
[ SQL ] SHOW COLUMNS FROM `ht_article` [ RunTime:0.007041s ]
[ SQL ] SELECT `id`,`title`,`from`,`add_time`,`picture` FROM `ht_article` WHERE `nav_menu_id` = 26 AND `status` = 1 AND `is_delete` = 0 ORDER BY `list_order` ASC,`add_time` DESC LIMIT 12 [ RunTime:0.006233s ]
[ SQL ] SELECT `id`,name as title,nav_id as type FROM `ht_nav_menu` WHERE `parent_id` = '69' AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 3 [ RunTime:0.006224s ]
[ SQL ] SELECT `id`,`title`,`from`,`add_time`,`picture` FROM `ht_article` WHERE `nav_menu_id` = 30 AND `status` = 1 AND `is_delete` = 0 ORDER BY `list_order` ASC,`add_time` DESC LIMIT 3 [ RunTime:0.006050s ]
[ SQL ] SELECT `id`,name as title,`parent_id`,`is_publish`,`publish_title` FROM `ht_nav_menu` WHERE `id` IN (26) AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 1 [ RunTime:0.005998s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ht_article` `l` LEFT JOIN `ht_user` `u` ON `u`.`id`=`l`.`admin_id` WHERE `l`.`status` = '1' AND `l`.`is_delete` = '0' AND ( FIND_IN_SET(287,l.category_id) ) [ RunTime:0.009016s ]
[ SQL ] SELECT `l`.`id`,`l`.`title`,`l`.`from`,`l`.`add_time`,`l`.`picture`,`l`.`visit_num`,`l`.`visit_num_real`,`l`.`nav_menu_id`,`l`.`desc`,`l`.`publish_date`,`l`.`project_position`,u.user_login as username FROM `ht_article` `l` LEFT JOIN `ht_user` `u` ON `u`.`id`=`l`.`admin_id` WHERE `l`.`status` = '1' AND `l`.`is_delete` = '0' AND ( FIND_IN_SET(287,l.category_id) ) ORDER BY `l`.`list_order` ASC,`l`.`add_time` DESC LIMIT 0,20 [ RunTime:0.009467s ]
