SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.001414s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000389s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.001111s ]
SELECT `id`,`pid`,`name`,`icon` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `sort` DESC [ RunTime:0.000783s ]
SHOW FULL COLUMNS FROM `sp_virtuoso_service_cate` [ RunTime:0.001054s ]
SELECT `id`,`cate_name`,`cate_code`,`icon`,`description` FROM `sp_virtuoso_service_cate` WHERE ( `pid` = 0 AND `is_show` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `sp_set_city` [ RunTime:0.000936s ]
SELECT * FROM `sp_set_city` WHERE `pid` = 0 [ RunTime:0.000395s ]
SELECT v.id, v.realname, v.nickname, v.avatar, v.work_years,
v.introduction, v.province_id, v.city_id, v.address, v.phone
FROM sp_virtuoso v
WHERE v.status = '1' AND v.delete_time IS NULL ORDER BY v.id DESC [ RunTime:0.000666s ]
SELECT * FROM `sp_set_city` WHERE `id` = 430000 LIMIT 1 [ RunTime:0.000256s ]
SELECT * FROM `sp_set_city` WHERE `id` = 430000 LIMIT 1 [ RunTime:0.000266s ]
SELECT * FROM `sp_set_city` WHERE `id` = 350000 LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `sp_set_city` WHERE `id` = 361000 LIMIT 1 [ RunTime:0.000304s ]
SELECT * FROM `sp_set_city` WHERE `id` = 210000 LIMIT 1 [ RunTime:0.000282s ]
SELECT * FROM `sp_set_city` WHERE `id` = 214000 LIMIT 1 [ RunTime:0.000255s ]
SELECT * FROM `sp_set_city` WHERE `id` = 300000 LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `sp_set_city` WHERE `id` = 300000 LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `sp_set_city` WHERE `id` = 310000 LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `sp_set_city` WHERE `id` = 315000 LIMIT 1 [ RunTime:0.000245s ]
SELECT * FROM `sp_set_city` WHERE `id` = 210000 LIMIT 1 [ RunTime:0.000222s ]
SELECT * FROM `sp_set_city` WHERE `id` = 215000 LIMIT 1 [ RunTime:0.000226s ]
SELECT * FROM `sp_set_city` WHERE `id` = 510000 LIMIT 1 [ RunTime:0.000229s ]
SELECT * FROM `sp_set_city` WHERE `id` = 518000 LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `sp_set_city` WHERE `id` = 200000 LIMIT 1 [ RunTime:0.000208s ]
SELECT * FROM `sp_set_city` WHERE `id` = 200000 LIMIT 1 [ RunTime:0.000197s ]
SELECT * FROM `sp_set_city` WHERE `id` = 100000 LIMIT 1 [ RunTime:0.000190s ]
SELECT * FROM `sp_set_city` WHERE `id` = 100000 LIMIT 1 [ RunTime:0.000205s ]
SELECT * FROM `sp_set_city` WHERE `id` = 610000 LIMIT 1 [ RunTime:0.000202s ]
SELECT * FROM `sp_set_city` WHERE `id` = 610000 LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `sp_set_city` WHERE `id` = 250000 LIMIT 1 [ RunTime:0.000198s ]
SELECT * FROM `sp_set_city` WHERE `id` = 266000 LIMIT 1 [ RunTime:0.000192s ]
SELECT * FROM `sp_set_city` WHERE `id` = 210000 LIMIT 1 [ RunTime:0.000366s ]
SELECT * FROM `sp_set_city` WHERE `id` = 210000 LIMIT 1 [ RunTime:0.000316s ]
SELECT * FROM `sp_set_city` WHERE `id` = 510000 LIMIT 1 [ RunTime:0.000243s ]
SELECT * FROM `sp_set_city` WHERE `id` = 510000 LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `sp_set_city` WHERE `id` = 300000 LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `sp_set_city` WHERE `id` = 300000 LIMIT 1 [ RunTime:0.000198s ]
SELECT * FROM `sp_set_city` WHERE `id` = 310000 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `sp_set_city` WHERE `id` = 310000 LIMIT 1 [ RunTime:0.000217s ]
SELECT * FROM `sp_set_city` WHERE `id` = 210000 LIMIT 1 [ RunTime:0.000205s ]
SELECT * FROM `sp_set_city` WHERE `id` = 215000 LIMIT 1 [ RunTime:0.000222s ]
SELECT * FROM `sp_set_city` WHERE `id` = 510000 LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `sp_set_city` WHERE `id` = 518000 LIMIT 1 [ RunTime:0.000205s ]
SELECT * FROM `sp_set_city` WHERE `id` = 200000 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `sp_set_city` WHERE `id` = 200000 LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `sp_set_city` WHERE `id` = 100000 LIMIT 1 [ RunTime:0.000237s ]
SELECT * FROM `sp_set_city` WHERE `id` = 100000 LIMIT 1 [ RunTime:0.000219s ]
