[ DB ] CONNECT:[ UseTime:0.000870s ] mysql:host=119.23.172.220;port=3306;dbname=old999;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ht_position` [ RunTime:0.001184s ]
[ 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.000569s ]
[ SQL ] SHOW COLUMNS FROM `ht_ad` [ RunTime:0.003672s ]
[ 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.000540s ]
[ 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.000546s ]
[ SQL ] SHOW COLUMNS FROM `ht_nav_menu` [ RunTime:0.001026s ]
[ SQL ] SELECT `id`,name as title,nav_id as type FROM `ht_nav_menu` WHERE `parent_id` = '61' AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 6 [ RunTime:0.000509s ]
[ SQL ] SHOW COLUMNS FROM `ht_article` [ RunTime:0.001158s ]
[ SQL ] SELECT `id`,`title`,`from`,`add_time`,`picture` FROM `ht_article` WHERE `nav_menu_id` = 22 AND `status` = 1 AND `is_delete` = 0 ORDER BY `list_order` ASC,`add_time` DESC LIMIT 6 [ RunTime:0.001193s ]
[ SQL ] SELECT `id`,name as title,nav_id as type FROM `ht_nav_menu` WHERE `parent_id` = '62' AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 5 [ RunTime:0.000479s ]
[ SQL ] SELECT `id`,`title`,`from`,`add_time`,`picture` FROM `ht_article` WHERE `nav_menu_id` = 25 AND `status` = 1 AND `is_delete` = 0 ORDER BY `list_order` ASC,`add_time` DESC LIMIT 5 [ RunTime:0.004889s ]
[ SQL ] SELECT `id`,name as title,`parent_id` FROM `ht_nav_menu` WHERE `parent_id` = '61' AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000632s ]
[ 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` = '22' [ RunTime:0.001118s ]
[ 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` = '22' ORDER BY `l`.`list_order` ASC,`l`.`add_time` DESC LIMIT 0,20 [ RunTime:0.001509s ]
