SHOW FULL COLUMNS FROM `px_users` [ RunTime:0.003644s ]
SELECT * FROM `px_users` WHERE `admin_id` IS NULL LIMIT 1 [ RunTime:0.120397s ]
UPDATE `px_users` SET `ent_id` = NULL WHERE `admin_id` IS NULL [ RunTime:0.366680s ]
SHOW FULL COLUMNS FROM `px_pingxuan` [ RunTime:0.002475s ]
SELECT `pxid`,`ent_id`,`uid`,`title`,`is_kaifang`,`is_jiang_kaifang` FROM `px_pingxuan` WHERE `pxid` = 306 LIMIT 1 [ RunTime:0.000466s ]
SHOW FULL COLUMNS FROM `px_pingxuan_jiang` [ RunTime:0.001458s ]
SELECT * FROM `px_pingxuan_jiang` WHERE `pxid` = 306 AND ( sysjid < 4 ) ORDER BY `ord` ASC [ RunTime:0.002107s ]
SHOW FULL COLUMNS FROM `px_pingxuan_zuopin` [ RunTime:0.002761s ]
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` = 306 AND `state` = 1 AND `jid` = 1013 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.049563s ]
SHOW FULL COLUMNS FROM `p_ent` [ RunTime:0.006112s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000712s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000558s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000790s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000526s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000689s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000567s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000445s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000541s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000549s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000495s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 923 LIMIT 1 [ RunTime:0.000460s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000523s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000464s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000482s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000467s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1844 LIMIT 1 [ RunTime:0.000466s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000480s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000435s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000448s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000475s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000468s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000472s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000402s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000440s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1844 LIMIT 1 [ RunTime:0.000491s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000460s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000447s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000481s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1844 LIMIT 1 [ RunTime:0.000469s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1844 LIMIT 1 [ RunTime:0.000449s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000557s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000472s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000524s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000453s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 558 LIMIT 1 [ RunTime:0.000473s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000466s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000435s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000460s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000414s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000412s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000455s ]
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` = 306 AND `state` = 1 AND `jid` = 1014 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.017741s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000697s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000490s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000671s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000451s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000427s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000437s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000574s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 923 LIMIT 1 [ RunTime:0.000425s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000421s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1861 LIMIT 1 [ RunTime:0.000502s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000495s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1844 LIMIT 1 [ RunTime:0.000639s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2313 LIMIT 1 [ RunTime:0.000475s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1565 LIMIT 1 [ RunTime:0.000429s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000429s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000478s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000474s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000461s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000557s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000439s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000453s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 558 LIMIT 1 [ RunTime:0.000452s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000439s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000416s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000493s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 401 LIMIT 1 [ RunTime:0.000458s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000439s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000448s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000462s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000454s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000466s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000431s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000399s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000474s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000435s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3414 LIMIT 1 [ RunTime:0.000483s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000428s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000539s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000383s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000359s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000413s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000402s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000414s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1861 LIMIT 1 [ RunTime:0.000387s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000402s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000415s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000399s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000406s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000399s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 558 LIMIT 1 [ RunTime:0.000417s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000426s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000400s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000411s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000405s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000402s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000400s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2447 LIMIT 1 [ RunTime:0.000401s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000394s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000398s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 401 LIMIT 1 [ RunTime:0.000411s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000390s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 211 LIMIT 1 [ RunTime:0.000379s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000412s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000380s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000393s ]
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` = 306 AND `state` = 1 AND `jid` = 1015 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.016391s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000590s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000492s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000465s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000445s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000457s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000434s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 272 LIMIT 1 [ RunTime:0.000532s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000453s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000447s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000418s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2442 LIMIT 1 [ RunTime:0.000434s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 692 LIMIT 1 [ RunTime:0.000439s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 272 LIMIT 1 [ RunTime:0.000446s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000461s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1263 LIMIT 1 [ RunTime:0.000417s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 401 LIMIT 1 [ RunTime:0.000399s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2313 LIMIT 1 [ RunTime:0.000616s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2313 LIMIT 1 [ RunTime:0.000591s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 508 LIMIT 1 [ RunTime:0.000572s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000613s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000610s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000552s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1121 LIMIT 1 [ RunTime:0.000433s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1121 LIMIT 1 [ RunTime:0.000709s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000600s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000504s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000507s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2447 LIMIT 1 [ RunTime:0.000520s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 558 LIMIT 1 [ RunTime:0.000517s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000567s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000512s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000531s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 6898 LIMIT 1 [ RunTime:0.000463s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1861 LIMIT 1 [ RunTime:0.000528s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000464s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1826 LIMIT 1 [ RunTime:0.000512s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 558 LIMIT 1 [ RunTime:0.000465s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3414 LIMIT 1 [ RunTime:0.000473s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000489s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 923 LIMIT 1 [ RunTime:0.000613s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 923 LIMIT 1 [ RunTime:0.000409s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000575s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 571 LIMIT 1 [ RunTime:0.000448s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000394s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000397s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1875 LIMIT 1 [ RunTime:0.000407s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1569 LIMIT 1 [ RunTime:0.000404s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000375s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000404s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000379s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000420s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000371s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2447 LIMIT 1 [ RunTime:0.000379s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 401 LIMIT 1 [ RunTime:0.000377s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000398s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 7185 LIMIT 1 [ RunTime:0.000388s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000406s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000382s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2313 LIMIT 1 [ RunTime:0.000416s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000396s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1121 LIMIT 1 [ RunTime:0.000399s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1496 LIMIT 1 [ RunTime:0.000546s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3348 LIMIT 1 [ RunTime:0.000447s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 571 LIMIT 1 [ RunTime:0.000527s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000415s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000408s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000503s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 923 LIMIT 1 [ RunTime:0.000459s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000468s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000503s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000422s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1875 LIMIT 1 [ RunTime:0.000423s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1861 LIMIT 1 [ RunTime:0.000496s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1861 LIMIT 1 [ RunTime:0.000475s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000411s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000498s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000423s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000442s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 508 LIMIT 1 [ RunTime:0.000493s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3414 LIMIT 1 [ RunTime:0.000478s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3415 LIMIT 1 [ RunTime:0.000458s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000430s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000535s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1121 LIMIT 1 [ RunTime:0.000514s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1565 LIMIT 1 [ RunTime:0.000427s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 6898 LIMIT 1 [ RunTime:0.000431s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1875 LIMIT 1 [ RunTime:0.000465s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1497 LIMIT 1 [ RunTime:0.000409s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1497 LIMIT 1 [ RunTime:0.000414s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000408s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000446s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000432s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1844 LIMIT 1 [ RunTime:0.000445s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000437s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000435s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3414 LIMIT 1 [ RunTime:0.000473s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 558 LIMIT 1 [ RunTime:0.000672s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000419s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000439s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2405 LIMIT 1 [ RunTime:0.000406s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3348 LIMIT 1 [ RunTime:0.000458s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000470s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000449s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000412s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000438s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000484s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000440s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000511s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 272 LIMIT 1 [ RunTime:0.000494s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1820 LIMIT 1 [ RunTime:0.000393s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000453s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000423s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 956 LIMIT 1 [ RunTime:0.000593s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1263 LIMIT 1 [ RunTime:0.000505s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 558 LIMIT 1 [ RunTime:0.000432s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 508 LIMIT 1 [ RunTime:0.000436s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2313 LIMIT 1 [ RunTime:0.000435s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 923 LIMIT 1 [ RunTime:0.000424s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000417s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1875 LIMIT 1 [ RunTime:0.000460s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 571 LIMIT 1 [ RunTime:0.000439s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000451s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1636 LIMIT 1 [ RunTime:0.000442s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000422s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1473 LIMIT 1 [ RunTime:0.000533s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000471s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000432s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000452s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000414s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000421s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1826 LIMIT 1 [ RunTime:0.000556s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1826 LIMIT 1 [ RunTime:0.000588s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 401 LIMIT 1 [ RunTime:0.000459s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 3415 LIMIT 1 [ RunTime:0.000433s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000491s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 567 LIMIT 1 [ RunTime:0.000557s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000438s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1565 LIMIT 1 [ RunTime:0.000506s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000528s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000467s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000459s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1843 LIMIT 1 [ RunTime:0.000475s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1789 LIMIT 1 [ RunTime:0.000466s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1897 LIMIT 1 [ RunTime:0.000377s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1526 LIMIT 1 [ RunTime:0.000426s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 2447 LIMIT 1 [ RunTime:0.000420s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000414s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 805 LIMIT 1 [ RunTime:0.000464s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 923 LIMIT 1 [ RunTime:0.000486s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 471 LIMIT 1 [ RunTime:0.000513s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1875 LIMIT 1 [ RunTime:0.000509s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1497 LIMIT 1 [ RunTime:0.000490s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1761 LIMIT 1 [ RunTime:0.000503s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1617 LIMIT 1 [ RunTime:0.000555s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1541 LIMIT 1 [ RunTime:0.000456s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 642 LIMIT 1 [ RunTime:0.000442s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000430s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1383 LIMIT 1 [ RunTime:0.000434s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 401 LIMIT 1 [ RunTime:0.000423s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1873 LIMIT 1 [ RunTime:0.000412s ]
SELECT `ent_name`,`ent_province` FROM `p_ent` WHERE `ent_id` = 1565 LIMIT 1 [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `px_company` [ RunTime:0.003069s ]
SELECT * FROM `px_company` ORDER BY `ent_id` DESC LIMIT 10 [ RunTime:0.024690s ]
SHOW FULL COLUMNS FROM `px_pingxuan_cate` [ RunTime:0.002675s ]
SELECT * FROM `px_pingxuan_cate` WHERE `pxid` = 306 [ RunTime:0.000814s ]