SHOW FULL COLUMNS FROM `px_users` [ RunTime:0.002617s ]
SELECT * FROM `px_users` WHERE `admin_id` IS NULL LIMIT 1 [ RunTime:0.541122s ]
UPDATE `px_users` SET `ent_id` = NULL WHERE `admin_id` IS NULL [ RunTime:1.065716s ]
SHOW FULL COLUMNS FROM `px_pingxuan` [ RunTime:0.004155s ]
SELECT `pxid`,`ent_id`,`uid`,`title`,`is_kaifang`,`is_jiang_kaifang` FROM `px_pingxuan` WHERE `pxid` = 418 LIMIT 1 [ RunTime:0.000764s ]
SHOW FULL COLUMNS FROM `px_pingxuan_cate` [ RunTime:0.003572s ]
SELECT `catename` FROM `px_pingxuan_cate` WHERE `pxcid` = 1418 LIMIT 1 [ RunTime:0.000699s ]
SHOW FULL COLUMNS FROM `px_pingxuan_jiang` [ RunTime:0.002479s ]
SELECT * FROM `px_pingxuan_jiang` WHERE `pxid` = 418 AND ( sysjid < 4 ) ORDER BY `ord` ASC [ RunTime:0.003286s ]
SHOW FULL COLUMNS FROM `px_pingxuan_zuopin` [ RunTime:0.004467s ]
SELECT `px_pingxuan_zuopin`.`pxzpid`,`px_pingxuan_zuopin`.`title`,`px_company`.`ent_id`,`pxzpid`,`title` FROM `px_pingxuan_zuopin` LEFT JOIN `px_company` ON `px_pingxuan_zuopin`.`ent_id`=`px_company`.`ent_id` WHERE `pxid` = 418 AND `pxcid` = 1418 AND `state` = 1 AND `jid` = 1163 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.025348s ]
SHOW FULL COLUMNS FROM `p_ent` [ RunTime:0.004663s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 25 LIMIT 1 [ RunTime:0.000690s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000528s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000644s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000574s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000615s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000676s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000563s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 215 LIMIT 1 [ RunTime:0.000632s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000579s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000707s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000667s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000607s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000628s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000650s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 996 LIMIT 1 [ RunTime:0.000624s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000739s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1874 LIMIT 1 [ RunTime:0.000571s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000565s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000752s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000587s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000575s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000903s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000751s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 548 LIMIT 1 [ RunTime:0.000560s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 25 LIMIT 1 [ RunTime:0.000649s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3902 LIMIT 1 [ RunTime:0.000487s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000602s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000562s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000529s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3394 LIMIT 1 [ RunTime:0.000509s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 182 LIMIT 1 [ RunTime:0.000513s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 490 LIMIT 1 [ RunTime:0.000594s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000493s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 125 LIMIT 1 [ RunTime:0.000518s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 125 LIMIT 1 [ RunTime:0.000704s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 215 LIMIT 1 [ RunTime:0.000698s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 182 LIMIT 1 [ RunTime:0.000665s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 182 LIMIT 1 [ RunTime:0.000523s ]
SELECT `px_pingxuan_zuopin`.`pxzpid`,`px_pingxuan_zuopin`.`title`,`px_company`.`ent_id`,`pxzpid`,`title` FROM `px_pingxuan_zuopin` LEFT JOIN `px_company` ON `px_pingxuan_zuopin`.`ent_id`=`px_company`.`ent_id` WHERE `pxid` = 418 AND `pxcid` = 1418 AND `state` = 1 AND `jid` = 1164 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.025767s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000844s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000495s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000566s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000577s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000498s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1151 LIMIT 1 [ RunTime:0.000460s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 563 LIMIT 1 [ RunTime:0.000466s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1506 LIMIT 1 [ RunTime:0.000495s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 393 LIMIT 1 [ RunTime:0.000448s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1780 LIMIT 1 [ RunTime:0.000578s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 563 LIMIT 1 [ RunTime:0.000482s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 563 LIMIT 1 [ RunTime:0.000539s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2510 LIMIT 1 [ RunTime:0.000484s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 125 LIMIT 1 [ RunTime:0.000474s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 267 LIMIT 1 [ RunTime:0.000677s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000486s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 393 LIMIT 1 [ RunTime:0.000644s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 215 LIMIT 1 [ RunTime:0.000535s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 996 LIMIT 1 [ RunTime:0.000483s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 259 LIMIT 1 [ RunTime:0.000484s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000479s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000475s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2510 LIMIT 1 [ RunTime:0.000501s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 6931 LIMIT 1 [ RunTime:0.000500s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 190 LIMIT 1 [ RunTime:0.000474s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 393 LIMIT 1 [ RunTime:0.000706s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1096 LIMIT 1 [ RunTime:0.000703s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1096 LIMIT 1 [ RunTime:0.000615s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 843 LIMIT 1 [ RunTime:0.000492s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 563 LIMIT 1 [ RunTime:0.000466s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 182 LIMIT 1 [ RunTime:0.000555s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2219 LIMIT 1 [ RunTime:0.000540s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1506 LIMIT 1 [ RunTime:0.000545s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 690 LIMIT 1 [ RunTime:0.000504s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 259 LIMIT 1 [ RunTime:0.000512s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1291 LIMIT 1 [ RunTime:0.000465s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 182 LIMIT 1 [ RunTime:0.000484s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 677 LIMIT 1 [ RunTime:0.000574s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 6931 LIMIT 1 [ RunTime:0.000531s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 259 LIMIT 1 [ RunTime:0.000487s ]
SELECT `px_pingxuan_zuopin`.`pxzpid`,`px_pingxuan_zuopin`.`title`,`px_company`.`ent_id`,`pxzpid`,`title` FROM `px_pingxuan_zuopin` LEFT JOIN `px_company` ON `px_pingxuan_zuopin`.`ent_id`=`px_company`.`ent_id` WHERE `pxid` = 418 AND `pxcid` = 1418 AND `state` = 1 AND `jid` = 1165 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.020393s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1780 LIMIT 1 [ RunTime:0.000791s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1291 LIMIT 1 [ RunTime:0.000768s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2302 LIMIT 1 [ RunTime:0.000532s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7145 LIMIT 1 [ RunTime:0.000504s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7145 LIMIT 1 [ RunTime:0.000486s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1874 LIMIT 1 [ RunTime:0.000456s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1762 LIMIT 1 [ RunTime:0.000715s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 393 LIMIT 1 [ RunTime:0.000522s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2530 LIMIT 1 [ RunTime:0.000521s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 190 LIMIT 1 [ RunTime:0.000490s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 843 LIMIT 1 [ RunTime:0.000463s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 182 LIMIT 1 [ RunTime:0.000634s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1853 LIMIT 1 [ RunTime:0.000469s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1853 LIMIT 1 [ RunTime:0.000511s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2336 LIMIT 1 [ RunTime:0.000642s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 561 LIMIT 1 [ RunTime:0.000581s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 563 LIMIT 1 [ RunTime:0.000532s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 259 LIMIT 1 [ RunTime:0.000581s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 644 LIMIT 1 [ RunTime:0.000596s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1956 LIMIT 1 [ RunTime:0.000582s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1762 LIMIT 1 [ RunTime:0.000743s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7140 LIMIT 1 [ RunTime:0.000482s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 259 LIMIT 1 [ RunTime:0.000561s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1874 LIMIT 1 [ RunTime:0.000499s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1291 LIMIT 1 [ RunTime:0.000470s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 490 LIMIT 1 [ RunTime:0.000499s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7157 LIMIT 1 [ RunTime:0.000485s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 563 LIMIT 1 [ RunTime:0.000599s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2302 LIMIT 1 [ RunTime:0.000485s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3394 LIMIT 1 [ RunTime:0.000487s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 872 LIMIT 1 [ RunTime:0.000521s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 872 LIMIT 1 [ RunTime:0.000601s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1806 LIMIT 1 [ RunTime:0.000483s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 333 LIMIT 1 [ RunTime:0.000511s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 561 LIMIT 1 [ RunTime:0.000479s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 393 LIMIT 1 [ RunTime:0.000664s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 268 LIMIT 1 [ RunTime:0.000505s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 333 LIMIT 1 [ RunTime:0.000527s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1291 LIMIT 1 [ RunTime:0.000498s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1704 LIMIT 1 [ RunTime:0.000567s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1518 LIMIT 1 [ RunTime:0.000510s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1291 LIMIT 1 [ RunTime:0.000480s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7140 LIMIT 1 [ RunTime:0.000489s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1874 LIMIT 1 [ RunTime:0.000522s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7140 LIMIT 1 [ RunTime:0.000481s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7152 LIMIT 1 [ RunTime:0.000456s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7145 LIMIT 1 [ RunTime:0.000485s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7145 LIMIT 1 [ RunTime:0.000482s ]
SHOW FULL COLUMNS FROM `px_company` [ RunTime:0.003130s ]
SELECT * FROM `px_company` ORDER BY `ent_id` DESC LIMIT 10 [ RunTime:0.018264s ]
SELECT * FROM `px_pingxuan_cate` WHERE `pxid` = 418 [ RunTime:0.000816s ]
