[ DB ] CONNECT:[ UseTime:0.007457s ] mysql:host=119.23.172.220;port=3306;dbname=old999;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ht_position` [ RunTime:0.005190s ]
[ 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.004548s ]
[ SQL ] SHOW COLUMNS FROM `ht_nav_menu` [ RunTime:0.005111s ]
[ 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.004640s ]
[ SQL ] SHOW COLUMNS FROM `ht_ad` [ RunTime:0.005086s ]
[ 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.004637s ]
[ 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.004582s ]
[ 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.004502s ]
[ SQL ] SHOW COLUMNS FROM `ht_article` [ RunTime:0.005221s ]
[ 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.007129s ]
[ 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.004489s ]
[ 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.006898s ]
[ SQL ] SELECT `id`,name as title,`parent_id`,`is_publish`,`publish_title` FROM `ht_nav_menu` WHERE `parent_id` = '65' AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.004572s ]
[ 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 `l`.`nav_menu_id` = '26' [ RunTime:0.006980s ]
[ 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 `l`.`nav_menu_id` = '26' ORDER BY `l`.`list_order` ASC,`l`.`add_time` DESC LIMIT 0,20 [ RunTime:0.007137s ]
