[ DB ] CONNECT:[ UseTime:0.010109s ] mysql:host=119.23.172.220;port=3306;dbname=old999;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ht_position` [ RunTime:0.007414s ]
[ 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.006834s ]
[ SQL ] SHOW COLUMNS FROM `ht_nav_menu` [ RunTime:0.007766s ]
[ 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.007093s ]
[ SQL ] SHOW COLUMNS FROM `ht_ad` [ RunTime:0.007638s ]
[ 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.006829s ]
[ 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.006758s ]
[ 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.006815s ]
[ SQL ] SHOW COLUMNS FROM `ht_article` [ RunTime:0.007720s ]
[ 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.006818s ]
[ 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.006743s ]
[ 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.006789s ]
[ 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.006658s ]
[ 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(263,l.category_id) ) [ RunTime:0.009453s ]
[ 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(263,l.category_id) ) ORDER BY `l`.`list_order` ASC,`l`.`add_time` DESC LIMIT 0,20 [ RunTime:0.009532s ]
