SHOW FULL COLUMNS FROM `px_users` [ RunTime:0.003898s ]
SELECT * FROM `px_users` WHERE `admin_id` IS NULL LIMIT 1 [ RunTime:0.002050s ]
UPDATE `px_users` SET `ent_id` = NULL WHERE `admin_id` IS NULL [ RunTime:1.072921s ]
SHOW FULL COLUMNS FROM `px_pingxuan` [ RunTime:0.004339s ]
SELECT `pxid`,`ent_id`,`uid`,`title`,`is_kaifang`,`is_jiang_kaifang` FROM `px_pingxuan` WHERE `pxid` = 456 LIMIT 1 [ RunTime:0.000770s ]
SHOW FULL COLUMNS FROM `px_pingxuan_cate` [ RunTime:0.003389s ]
SELECT `catename` FROM `px_pingxuan_cate` WHERE `pxcid` = 1623 LIMIT 1 [ RunTime:0.000739s ]
SHOW FULL COLUMNS FROM `px_pingxuan_jiang` [ RunTime:0.002617s ]
SELECT * FROM `px_pingxuan_jiang` WHERE `pxid` = 456 AND ( sysjid < 4 ) ORDER BY `ord` ASC [ RunTime:0.003511s ]
SHOW FULL COLUMNS FROM `px_pingxuan_zuopin` [ RunTime:0.004450s ]
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` = 456 AND `pxcid` = 1623 AND `state` = 1 AND `jid` = 1224 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.033653s ]
SHOW FULL COLUMNS FROM `p_ent` [ RunTime:0.005954s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8529 LIMIT 1 [ RunTime:0.000820s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3226 LIMIT 1 [ RunTime:0.000866s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8534 LIMIT 1 [ RunTime:0.000696s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8560 LIMIT 1 [ RunTime:0.000657s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8543 LIMIT 1 [ RunTime:0.000678s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7020 LIMIT 1 [ RunTime:0.000608s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8526 LIMIT 1 [ RunTime:0.000686s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8470 LIMIT 1 [ RunTime:0.000689s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8384 LIMIT 1 [ RunTime:0.000685s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7985 LIMIT 1 [ RunTime:0.000673s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8426 LIMIT 1 [ RunTime:0.000673s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7197 LIMIT 1 [ RunTime:0.000594s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3865 LIMIT 1 [ RunTime:0.000591s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3337 LIMIT 1 [ RunTime:0.000651s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3333 LIMIT 1 [ RunTime:0.000707s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3064 LIMIT 1 [ RunTime:0.000578s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8492 LIMIT 1 [ RunTime:0.000638s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 794 LIMIT 1 [ RunTime:0.000543s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3587 LIMIT 1 [ RunTime:0.000563s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8517 LIMIT 1 [ RunTime:0.000586s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3104 LIMIT 1 [ RunTime:0.000624s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8541 LIMIT 1 [ RunTime:0.000694s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7971 LIMIT 1 [ RunTime:0.000601s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8536 LIMIT 1 [ RunTime:0.000752s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8510 LIMIT 1 [ RunTime:0.000736s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3301 LIMIT 1 [ RunTime:0.000594s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8490 LIMIT 1 [ RunTime:0.000593s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8490 LIMIT 1 [ RunTime:0.000685s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7993 LIMIT 1 [ RunTime:0.000587s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7432 LIMIT 1 [ RunTime:0.000541s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 5751 LIMIT 1 [ RunTime:0.000541s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7309 LIMIT 1 [ RunTime:0.000555s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8563 LIMIT 1 [ RunTime:0.000670s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8279 LIMIT 1 [ RunTime:0.000571s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3841 LIMIT 1 [ RunTime:0.000552s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 8538 LIMIT 1 [ RunTime:0.000538s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3289 LIMIT 1 [ RunTime:0.000551s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7276 LIMIT 1 [ RunTime:0.000564s ]
SHOW FULL COLUMNS FROM `px_company` [ RunTime:0.003369s ]
SELECT * FROM `px_company` ORDER BY `ent_id` DESC LIMIT 10 [ RunTime:0.029840s ]
SELECT * FROM `px_pingxuan_cate` WHERE `pxid` = 456 [ RunTime:0.000901s ]