[8]Array to string conversion[/websites/wwwroot/www.china-mcc.com/thinkphp/library/think/Url.php:128]
[8]Array to string conversion[/websites/wwwroot/www.china-mcc.com/thinkphp/library/think/Url.php:147]
[8]Array to string conversion[/websites/wwwroot/www.china-mcc.com/thinkphp/library/think/Url.php:147]
[8]Array to string conversion[/websites/wwwroot/www.china-mcc.com/thinkphp/library/think/Url.php:128]
[8]Array to string conversion[/websites/wwwroot/www.china-mcc.com/thinkphp/library/think/Url.php:147]
[8]Array to string conversion[/websites/wwwroot/www.china-mcc.com/thinkphp/library/think/Url.php:147]
[ DB ] CONNECT:[ UseTime:0.001432s ] mysql:host=pc-m5epcw1px949b110u.rwlb.rds.aliyuncs.com;port=3306;dbname=yousedb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_para` [ RunTime:0.002162s ]
[ SQL ] SELECT * FROM `tb_para` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001380s ]
[ SQL ] SHOW COLUMNS FROM `tb_category` [ RunTime:0.001184s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` = 4 ORDER BY `sortId` ASC [ RunTime:0.001008s ]
[ SQL ] SHOW COLUMNS FROM `tb_need` [ RunTime:0.001227s ]
[ SQL ] SELECT get_province_id_by_city(city_id) as province_id,count(*) as num FROM `tb_need` WHERE `check_status` = 1 GROUP BY get_province_id_by_city(city_id) ORDER BY `num` DESC [ RunTime:0.020172s ]
[ SQL ] SHOW COLUMNS FROM `tb_area` [ RunTime:0.001071s ]
[ SQL ] SELECT `id`,`name` FROM `tb_area` WHERE `id` IN (15,16,5,10,3,18,19,27,21,1,11,7,22,17,6,12,23,14,31,28,24,13,3328,4,8,2,25,26,9,30,29,20) [ RunTime:0.001036s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_need` WHERE `check_status` = 1 LIMIT 1 [ RunTime:0.001688s ]
[ SQL ] SELECT * FROM `tb_need` WHERE `check_status` = 1 ORDER BY `submit_date` DESC LIMIT 1620,30 [ RunTime:0.006353s ]
[ SQL ] SELECT `id`,`name`,`pid` FROM `tb_category` WHERE `id` IN (155,164,157,167,159,160,161) [ RunTime:0.000989s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 204 LIMIT 1 [ RunTime:0.000864s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000870s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000790s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.001551s ]
[ SQL ] SHOW COLUMNS FROM `tb_collect` [ RunTime:0.003154s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 80 LIMIT 1 [ RunTime:0.000960s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 204 LIMIT 1 [ RunTime:0.003706s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 18 LIMIT 1 [ RunTime:0.003586s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000835s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000948s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 79 LIMIT 1 [ RunTime:0.001214s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 195 LIMIT 1 [ RunTime:0.000819s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 17 LIMIT 1 [ RunTime:0.013216s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000813s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000773s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 74 LIMIT 1 [ RunTime:0.000967s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 66 LIMIT 1 [ RunTime:0.000801s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000764s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000824s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000806s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 73 LIMIT 1 [ RunTime:0.000967s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 107 LIMIT 1 [ RunTime:0.000805s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000778s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000743s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000819s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 72 LIMIT 1 [ RunTime:0.000916s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 155 LIMIT 1 [ RunTime:0.002092s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000877s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000930s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000946s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 71 LIMIT 1 [ RunTime:0.000947s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 239 LIMIT 1 [ RunTime:0.000927s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000869s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 157 LIMIT 1 [ RunTime:0.000898s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000885s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 70 LIMIT 1 [ RunTime:0.000957s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 97 LIMIT 1 [ RunTime:0.000873s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000874s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 167 LIMIT 1 [ RunTime:0.000983s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000850s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 69 LIMIT 1 [ RunTime:0.000983s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 288 LIMIT 1 [ RunTime:0.000914s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000857s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000874s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000904s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 67 LIMIT 1 [ RunTime:0.000961s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 154 LIMIT 1 [ RunTime:0.000945s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000948s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000855s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000880s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 62 LIMIT 1 [ RunTime:0.008165s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 144 LIMIT 1 [ RunTime:0.000956s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000885s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000875s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000828s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 61 LIMIT 1 [ RunTime:0.001018s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 208 LIMIT 1 [ RunTime:0.000943s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000902s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000935s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.004454s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 53 LIMIT 1 [ RunTime:0.002152s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 205 LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000913s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000942s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000909s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 52 LIMIT 1 [ RunTime:0.001007s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 206 LIMIT 1 [ RunTime:0.001074s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000986s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 159 LIMIT 1 [ RunTime:0.000866s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000840s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 50 LIMIT 1 [ RunTime:0.001051s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 170 LIMIT 1 [ RunTime:0.000789s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000802s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 164 LIMIT 1 [ RunTime:0.001015s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000763s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 49 LIMIT 1 [ RunTime:0.000955s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 143 LIMIT 1 [ RunTime:0.000866s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000881s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000916s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000876s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 48 LIMIT 1 [ RunTime:0.000999s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000932s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000805s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 157 LIMIT 1 [ RunTime:0.000806s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000796s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 47 LIMIT 1 [ RunTime:0.000970s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 94 LIMIT 1 [ RunTime:0.000901s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 10 LIMIT 1 [ RunTime:0.001058s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000851s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000831s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 46 LIMIT 1 [ RunTime:0.001004s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000974s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 4 LIMIT 1 [ RunTime:0.001271s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000898s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.001365s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 45 LIMIT 1 [ RunTime:0.001004s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 320 LIMIT 1 [ RunTime:0.001048s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000895s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 160 LIMIT 1 [ RunTime:0.001004s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.001160s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 44 LIMIT 1 [ RunTime:0.001108s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 358 LIMIT 1 [ RunTime:0.000859s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000864s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 160 LIMIT 1 [ RunTime:0.001790s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000908s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 43 LIMIT 1 [ RunTime:0.000955s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000939s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000888s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 160 LIMIT 1 [ RunTime:0.002431s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000900s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 42 LIMIT 1 [ RunTime:0.000940s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 332 LIMIT 1 [ RunTime:0.002012s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000888s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 160 LIMIT 1 [ RunTime:0.020847s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.002121s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 41 LIMIT 1 [ RunTime:0.001055s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000934s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000884s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 160 LIMIT 1 [ RunTime:0.001445s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.001154s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 40 LIMIT 1 [ RunTime:0.001195s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000824s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 6 LIMIT 1 [ RunTime:0.001107s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 160 LIMIT 1 [ RunTime:0.000944s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.001109s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 39 LIMIT 1 [ RunTime:0.001029s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000938s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000853s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 160 LIMIT 1 [ RunTime:0.000876s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000866s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 38 LIMIT 1 [ RunTime:0.000991s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 41 LIMIT 1 [ RunTime:0.001070s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 5 LIMIT 1 [ RunTime:0.001424s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000813s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.001598s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 34 LIMIT 1 [ RunTime:0.001167s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000846s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000835s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000958s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000968s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 35 LIMIT 1 [ RunTime:0.001010s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 163 LIMIT 1 [ RunTime:0.001140s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.001089s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000816s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.012751s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 33 LIMIT 1 [ RunTime:0.010046s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 54 LIMIT 1 [ RunTime:0.001417s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000981s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 155 LIMIT 1 [ RunTime:0.014427s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000845s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tb_collect` WHERE `table_name` = 'need' AND `table_id` = 32 LIMIT 1 [ RunTime:0.000930s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` IN (31,32,33,34,35) [ RunTime:0.000988s ]
[ SQL ] SHOW COLUMNS FROM `tb_mcc` [ RunTime:0.001157s ]
[ SQL ] SELECT * FROM `tb_mcc` WHERE `classify` = 1 [ RunTime:0.000915s ]
[ SQL ] SELECT * FROM `tb_mcc` WHERE `classify` = 2 [ RunTime:0.000865s ]
[ SQL ] select * from tb_meet_view WHERE start_date>DATE_FORMAT(now(),'%Y-%m-%d') order by start_date asc limit 5 [ RunTime:0.006927s ]
[ SQL ] SELECT `id`,`name` FROM `tb_area` WHERE `id` IN (263,320,170,58,172) [ RunTime:0.000917s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 263 LIMIT 1 [ RunTime:0.000837s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000866s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 320 LIMIT 1 [ RunTime:0.000799s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000804s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 170 LIMIT 1 [ RunTime:0.000891s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000862s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000853s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000816s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 172 LIMIT 1 [ RunTime:0.000872s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000869s ]
[ SQL ] SELECT * FROM (SELECT id FROM tb_prod WHERE check_status = 1 ORDER BY RAND() LIMIT 5) temp JOIN tb_prod p ON temp.id = p.id; [ RunTime:0.032913s ]
[ SQL ] select * from tb_need where check_status=1 and submit_date >= DATE_SUB(NOW(), INTERVAL 12 MONTH) order by hit desc limit 5; [ RunTime:0.003301s ]
[ SQL ] SELECT * FROM (SELECT id FROM tb_need WHERE check_status = 1 and submit_date >= DATE_SUB(NOW(), INTERVAL 12 MONTH) ORDER BY rand() LIMIT 5) AS temp JOIN tb_need AS n ON temp.id = n.id; [ RunTime:0.002134s ]
[ DB ] CONNECT:[ UseTime:0.001463s ] mysql:host=mccbfzy.mysql.polardb.rds.aliyuncs.com;port=3306;dbname=ysscdb;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_industry_report` [ RunTime:0.001097s ]
[ SQL ] SELECT `id`,`cate_aid`,`cate_bid`,`title`,`pic`,`tag`,`price`,`hit`,`mode` FROM `tb_industry_report` [ RunTime:0.001236s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` = 36 ORDER BY `sortid` ASC [ RunTime:0.001043s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` = 37 ORDER BY `sortid` ASC [ RunTime:0.000997s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` = 38 ORDER BY `sortid` ASC [ RunTime:0.001102s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` = 39 ORDER BY `sortid` ASC [ RunTime:0.000995s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` = 40 ORDER BY `sortid` ASC [ RunTime:0.001088s ]
[ SQL ] SELECT * FROM `tb_category` WHERE `pid` = 41 ORDER BY `sortid` ASC [ RunTime:0.001004s ]
[ SQL ] SHOW COLUMNS FROM `tb_advert` [ RunTime:0.001100s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 163 LIMIT 1 [ RunTime:0.000967s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 164 LIMIT 1 [ RunTime:0.002716s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 165 LIMIT 1 [ RunTime:0.000920s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 34 LIMIT 1 [ RunTime:0.005572s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 3 LIMIT 1 [ RunTime:0.001380s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000918s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000906s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000889s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000867s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000888s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 3 LIMIT 1 [ RunTime:0.001951s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000855s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000839s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000907s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.002082s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 154 LIMIT 1 [ RunTime:0.000843s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000926s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 154 LIMIT 1 [ RunTime:0.000834s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000896s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 161 LIMIT 1 [ RunTime:0.000861s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000851s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 56 LIMIT 1 [ RunTime:0.000879s ]
[ SQL ] SELECT * FROM `tb_area` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000834s ]
[ SQL ] SELECT * FROM `tb_advert` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000878s ]