SHOW FULL COLUMNS FROM `px_users` [ RunTime:0.003106s ]
SELECT * FROM `px_users` WHERE `admin_id` IS NULL LIMIT 1 [ RunTime:0.001492s ]
UPDATE `px_users` SET `ent_id` = NULL WHERE `admin_id` IS NULL [ RunTime:0.687091s ]
SHOW FULL COLUMNS FROM `px_pingxuan` [ RunTime:0.003604s ]
SELECT `pxid`,`ent_id`,`uid`,`title`,`is_kaifang`,`is_jiang_kaifang` FROM `px_pingxuan` WHERE `pxid` = 383 LIMIT 1 [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `px_pingxuan_cate` [ RunTime:0.002138s ]
SELECT `catename` FROM `px_pingxuan_cate` WHERE `pxcid` = 1307 LIMIT 1 [ RunTime:0.000558s ]
SHOW FULL COLUMNS FROM `px_pingxuan_jiang` [ RunTime:0.001913s ]
SELECT * FROM `px_pingxuan_jiang` WHERE `pxid` = 383 AND ( sysjid < 4 ) ORDER BY `ord` ASC [ RunTime:0.002151s ]
SHOW FULL COLUMNS FROM `px_pingxuan_zuopin` [ RunTime:0.003061s ]
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` = 383 AND `pxcid` = 1307 AND `state` = 1 AND `jid` = 1120 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.015266s ]
SHOW FULL COLUMNS FROM `p_ent` [ RunTime:0.005194s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3322 LIMIT 1 [ RunTime:0.000557s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3322 LIMIT 1 [ RunTime:0.000524s ]
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` = 383 AND `pxcid` = 1307 AND `state` = 1 AND `jid` = 1121 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.015186s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7296 LIMIT 1 [ RunTime:0.000535s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7282 LIMIT 1 [ RunTime:0.000632s ]
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` = 383 AND `pxcid` = 1307 AND `state` = 1 AND `jid` = 1122 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.015442s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7296 LIMIT 1 [ RunTime:0.000832s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3322 LIMIT 1 [ RunTime:0.000491s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3322 LIMIT 1 [ RunTime:0.000481s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1022 LIMIT 1 [ RunTime:0.000471s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1022 LIMIT 1 [ RunTime:0.000488s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7282 LIMIT 1 [ RunTime:0.000490s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7282 LIMIT 1 [ RunTime:0.000622s ]
SHOW FULL COLUMNS FROM `px_company` [ RunTime:0.002038s ]
SELECT * FROM `px_company` ORDER BY `ent_id` DESC LIMIT 10 [ RunTime:0.016914s ]
SELECT * FROM `px_pingxuan_cate` WHERE `pxid` = 383 [ RunTime:0.001194s ]
