[ DB ] CONNECT:[ UseTime:0.000336s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `t_project_vip` [ RunTime:0.000898s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `t_project_vip` `tpv` LEFT JOIN `t_project_vip_material` `tpvm` ON `tpv`.`id`=`tpvm`.`vip_id` WHERE `tpv`.`status` = 1 AND `tpv`.`is_delete` = 0 GROUP BY `tpv`.`id` ) `_group_count_` [ RunTime:1.918471s ]
[ SQL ] SELECT `tpv`.`id`,`tpv`.`project_name`,`tpv`.`project_industry`,`tpv`.`project_type`,`tpv`.`progress_stage`,`tpv`.`project_nature`,`tpv`.`owner_type`,`tpv`.`province_id`,`tpv`.`city_id`,`tpv`.`area_id`,`tpv`.`area_info`,`tpv`.`project_overview`,`tpvm`.`update_at`,tpvm.id as tpvmid FROM `t_project_vip` `tpv` LEFT JOIN `t_project_vip_material` `tpvm` ON `tpv`.`id`=`tpvm`.`vip_id` WHERE `tpv`.`status` = 1 AND `tpv`.`is_delete` = 0 GROUP BY `tpv`.`id` ORDER BY `tpvm`.`id` DESC,`tpv`.`update_at` DESC,`tpv`.`id` DESC LIMIT 3140,20 [ RunTime:5.573145s ]
[ DB ] CONNECT:[ UseTime:0.000638s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `t_category` [ RunTime:0.000882s ]
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000332s ]
[ DB ] CONNECT:[ UseTime:0.000253s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000224s ]
[ DB ] CONNECT:[ UseTime:0.000233s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `t_area` [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 510000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000265s ]
[ DB ] CONNECT:[ UseTime:0.000281s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `t_contact_info` [ RunTime:0.000590s ]
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 15 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.002618s ]
[ DB ] CONNECT:[ UseTime:0.000241s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `t_project_vip_stage` [ RunTime:0.000697s ]
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 15 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004277s ]
[ DB ] CONNECT:[ UseTime:0.000352s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 15 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004464s ]
[ DB ] CONNECT:[ UseTime:0.000458s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000280s ]
[ DB ] CONNECT:[ UseTime:0.000270s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000259s ]
[ DB ] CONNECT:[ UseTime:0.000214s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 500000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000215s ]
[ DB ] CONNECT:[ UseTime:0.000244s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 11 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.002896s ]
[ DB ] CONNECT:[ UseTime:0.000251s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 11 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004325s ]
[ DB ] CONNECT:[ UseTime:0.000353s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 11 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004384s ]
[ DB ] CONNECT:[ UseTime:0.000374s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000259s ]
[ DB ] CONNECT:[ UseTime:0.000263s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000309s ]
[ DB ] CONNECT:[ UseTime:0.000276s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 510000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000343s ]
[ DB ] CONNECT:[ UseTime:0.000389s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 10 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.002051s ]
[ DB ] CONNECT:[ UseTime:0.000392s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 10 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.005252s ]
[ DB ] CONNECT:[ UseTime:0.000352s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 10 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004381s ]
[ DB ] CONNECT:[ UseTime:0.000382s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000393s ]
[ DB ] CONNECT:[ UseTime:0.000240s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000286s ]
[ DB ] CONNECT:[ UseTime:0.000289s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 500000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000324s ]
[ DB ] CONNECT:[ UseTime:0.000227s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 9 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.001744s ]
[ DB ] CONNECT:[ UseTime:0.000203s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 9 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.006495s ]
[ DB ] CONNECT:[ UseTime:0.000260s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 9 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004409s ]
[ DB ] CONNECT:[ UseTime:0.000312s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000265s ]
[ DB ] CONNECT:[ UseTime:0.000226s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000291s ]
[ DB ] CONNECT:[ UseTime:0.000216s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 510000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000202s ]
[ DB ] CONNECT:[ UseTime:0.000264s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 8 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.001763s ]
[ DB ] CONNECT:[ UseTime:0.000433s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 8 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.006680s ]
[ DB ] CONNECT:[ UseTime:0.000278s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 8 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004432s ]
[ DB ] CONNECT:[ UseTime:0.000279s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000266s ]
[ DB ] CONNECT:[ UseTime:0.000245s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000223s ]
[ DB ] CONNECT:[ UseTime:0.000270s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 510000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000224s ]
[ DB ] CONNECT:[ UseTime:0.000254s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 12 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.001938s ]
[ DB ] CONNECT:[ UseTime:0.000297s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 12 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004997s ]
[ DB ] CONNECT:[ UseTime:0.000377s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 12 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004642s ]
[ DB ] CONNECT:[ UseTime:0.000440s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000386s ]
[ DB ] CONNECT:[ UseTime:0.000307s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000277s ]
[ DB ] CONNECT:[ UseTime:0.000290s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 530000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000254s ]
[ DB ] CONNECT:[ UseTime:0.000263s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 13 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.001838s ]
[ DB ] CONNECT:[ UseTime:0.000751s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 13 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.005309s ]
[ DB ] CONNECT:[ UseTime:0.000342s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 13 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004594s ]
[ DB ] CONNECT:[ UseTime:0.000386s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 118 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000252s ]
[ DB ] CONNECT:[ UseTime:0.000573s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 120 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000236s ]
[ DB ] CONNECT:[ UseTime:0.000329s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 520000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000273s ]
[ DB ] CONNECT:[ UseTime:0.000264s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 14 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.001922s ]
[ DB ] CONNECT:[ UseTime:0.000284s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 14 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.004297s ]
[ DB ] CONNECT:[ UseTime:0.000597s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 14 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.005415s ]
[ DB ] CONNECT:[ UseTime:0.000343s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 117 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000259s ]
[ DB ] CONNECT:[ UseTime:0.000356s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_category` WHERE `id` = 119 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000217s ]
[ DB ] CONNECT:[ UseTime:0.000341s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT * FROM `t_area` WHERE `id` = 500000 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ]
[ DB ] CONNECT:[ UseTime:0.002082s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT COUNT(1) AS tp_count FROM `t_contact_info` WHERE `enter_id` = 7 AND `enter_type` = 1 AND `is_delete` = 0 [ RunTime:0.001809s ]
[ DB ] CONNECT:[ UseTime:0.000258s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `content` FROM `t_project_vip_stage` WHERE `pid` = 7 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.011442s ]
[ DB ] CONNECT:[ UseTime:0.000384s ] mysql:host=127.0.0.1;port=3306;dbname=gxepc;charset=utf8
[ SQL ] SELECT `create_at` FROM `t_project_vip_stage` WHERE `pid` = 7 AND `is_delete` = 0 ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.006480s ]