SHOW FULL COLUMNS FROM `px_users` [ RunTime:0.003200s ]
SELECT * FROM `px_users` WHERE `admin_id` IS NULL LIMIT 1 [ RunTime:0.019187s ]
UPDATE `px_users` SET `ent_id` = NULL WHERE `admin_id` IS NULL [ RunTime:0.304754s ]
SHOW FULL COLUMNS FROM `px_pingxuan` [ RunTime:0.002200s ]
SELECT `pxid`,`ent_id`,`uid`,`title`,`is_kaifang`,`is_jiang_kaifang` FROM `px_pingxuan` WHERE `pxid` = 544 LIMIT 1 [ RunTime:0.000614s ]
SHOW FULL COLUMNS FROM `px_pingxuan_jiang` [ RunTime:0.001400s ]
SELECT * FROM `px_pingxuan_jiang` WHERE `pxid` = 544 AND ( sysjid < 4 ) ORDER BY `ord` ASC [ RunTime:0.002541s ]
SHOW FULL COLUMNS FROM `px_pingxuan_zuopin` [ RunTime:0.003906s ]
SELECT DISTINCT `px_pingxuan_zuopin`.`pxzpid`,`px_pingxuan_zuopin`.`title`,`px_company`.`ent_id` FROM `px_pingxuan_zuopin` LEFT JOIN `px_company` ON `px_pingxuan_zuopin`.`ent_id`=`px_company`.`ent_id` WHERE `pxid` = 544 AND `state` = 1 AND `jid` = 1373 AND `is_title` = 0 ORDER BY `px_pingxuan_zuopin`.`ranking` ASC,`px_pingxuan_zuopin`.`sysjid`,`px_pingxuan_zuopin`.`yesqzpjfen`,`px_pingxuan_zuopin`.`pxzpid`,`px_pingxuan_zuopin`.`ent_id` ASC [ RunTime:0.089166s ]
SHOW FULL COLUMNS FROM `p_ent` [ RunTime:0.005903s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 147 LIMIT 1 [ RunTime:0.000915s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 120 LIMIT 1 [ RunTime:0.000754s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 389 LIMIT 1 [ RunTime:0.000698s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 389 LIMIT 1 [ RunTime:0.000598s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1721 LIMIT 1 [ RunTime:0.000639s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2086 LIMIT 1 [ RunTime:0.000554s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 389 LIMIT 1 [ RunTime:0.000608s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 389 LIMIT 1 [ RunTime:0.000632s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 147 LIMIT 1 [ RunTime:0.000617s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2662 LIMIT 1 [ RunTime:0.000631s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2086 LIMIT 1 [ RunTime:0.000504s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 148 LIMIT 1 [ RunTime:0.000850s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1451 LIMIT 1 [ RunTime:0.000483s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1749 LIMIT 1 [ RunTime:0.000517s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 389 LIMIT 1 [ RunTime:0.000644s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 148 LIMIT 1 [ RunTime:0.000542s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 147 LIMIT 1 [ RunTime:0.000536s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 634 LIMIT 1 [ RunTime:0.000509s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 146 LIMIT 1 [ RunTime:0.000602s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 46 LIMIT 1 [ RunTime:0.000466s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1749 LIMIT 1 [ RunTime:0.000474s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2086 LIMIT 1 [ RunTime:0.000516s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 194 LIMIT 1 [ RunTime:0.000486s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 452 LIMIT 1 [ RunTime:0.000486s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 193 LIMIT 1 [ RunTime:0.000483s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1451 LIMIT 1 [ RunTime:0.000453s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2085 LIMIT 1 [ RunTime:0.000530s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2662 LIMIT 1 [ RunTime:0.000474s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 120 LIMIT 1 [ RunTime:0.000504s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 164 LIMIT 1 [ RunTime:0.000498s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 147 LIMIT 1 [ RunTime:0.000443s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 634 LIMIT 1 [ RunTime:0.000465s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 999 LIMIT 1 [ RunTime:0.000487s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1022 LIMIT 1 [ RunTime:0.000486s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1808 LIMIT 1 [ RunTime:0.000475s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 164 LIMIT 1 [ RunTime:0.000511s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 452 LIMIT 1 [ RunTime:0.000461s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1259 LIMIT 1 [ RunTime:0.000474s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 409 LIMIT 1 [ RunTime:0.000510s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1688 LIMIT 1 [ RunTime:0.000503s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 409 LIMIT 1 [ RunTime:0.000693s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1016 LIMIT 1 [ RunTime:0.000530s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3188 LIMIT 1 [ RunTime:0.000520s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1852 LIMIT 1 [ RunTime:0.000486s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 120 LIMIT 1 [ RunTime:0.000548s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1022 LIMIT 1 [ RunTime:0.000503s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8052 LIMIT 1 [ RunTime:0.000614s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 589 LIMIT 1 [ RunTime:0.000606s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 999 LIMIT 1 [ RunTime:0.000539s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2094 LIMIT 1 [ RunTime:0.000549s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 120 LIMIT 1 [ RunTime:0.000539s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1451 LIMIT 1 [ RunTime:0.000566s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 46 LIMIT 1 [ RunTime:0.000530s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 164 LIMIT 1 [ RunTime:0.000558s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 137 LIMIT 1 [ RunTime:0.000502s ]
SHOW FULL COLUMNS FROM `px_company` [ RunTime:0.001896s ]
SELECT * FROM `px_company` ORDER BY `ent_id` DESC LIMIT 10 [ RunTime:0.019120s ]
SHOW FULL COLUMNS FROM `px_pingxuan_cate` [ RunTime:0.001849s ]
SELECT * FROM `px_pingxuan_cate` WHERE `pxid` = 544 [ RunTime:0.000718s ]