SHOW FULL COLUMNS FROM `px_users` [ RunTime:0.002506s ]
SELECT * FROM `px_users` WHERE `admin_id` IS NULL LIMIT 1 [ RunTime:0.527203s ]
UPDATE `px_users` SET `ent_id` = NULL WHERE `admin_id` IS NULL [ RunTime:0.743294s ]
SHOW FULL COLUMNS FROM `px_pingxuan` [ RunTime:0.004167s ]
SELECT `pxid`,`ent_id`,`uid`,`title`,`is_kaifang`,`is_jiang_kaifang` FROM `px_pingxuan` WHERE `pxid` = 287 LIMIT 1 [ RunTime:0.000728s ]
SHOW FULL COLUMNS FROM `px_pingxuan_cate` [ RunTime:0.003588s ]
SELECT `catename` FROM `px_pingxuan_cate` WHERE `pxcid` = 1034 LIMIT 1 [ RunTime:0.000565s ]
SHOW FULL COLUMNS FROM `px_pingxuan_jiang` [ RunTime:0.002405s ]
SELECT * FROM `px_pingxuan_jiang` WHERE `pxid` = 287 AND ( sysjid < 4 ) ORDER BY `ord` ASC [ RunTime:0.003238s ]
SHOW FULL COLUMNS FROM `px_pingxuan_zuopin` [ RunTime:0.004559s ]
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` = 287 AND `pxcid` = 1034 AND `state` = 1 AND `jid` = 863 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.024311s ]
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` = 287 AND `pxcid` = 1034 AND `state` = 1 AND `jid` = 864 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.021066s ]
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` = 287 AND `pxcid` = 1034 AND `state` = 1 AND `jid` = 865 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.019753s ]
SHOW FULL COLUMNS FROM `px_company` [ RunTime:0.002345s ]
SELECT * FROM `px_company` ORDER BY `ent_id` DESC LIMIT 10 [ RunTime:0.018756s ]
SELECT * FROM `px_pingxuan_cate` WHERE `pxid` = 287 [ RunTime:0.000740s ]
