SHOW FULL COLUMNS FROM `base_project` [ RunTime:0.000721s ]
SELECT * FROM `base_project` WHERE `id` = 323 LIMIT 1 [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `base_category` [ RunTime:0.000555s ]
SELECT * FROM `base_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000355s ]
SELECT `pid` FROM `base_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000419s ]
SELECT `pid` FROM `base_category` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000206s ]
SELECT `pid` FROM `base_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000213s ]
SELECT `name` FROM `base_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000191s ]
SELECT `id`,`name`,`table` FROM `base_category` WHERE `id` = 39 AND `status` <> 9 LIMIT 1 [ RunTime:0.000221s ]
SHOW FULL COLUMNS FROM `base_project_guanyuan_huanxing` [ RunTime:0.000631s ]
SELECT * FROM `base_project_guanyuan_huanxing` WHERE `id` = 505 LIMIT 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `base_config` [ RunTime:0.000581s ]
SELECT * FROM `base_config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000271s ]
show full columns from base_project_guanyuan_huanxing [ RunTime:0.000524s ]
SELECT `p`.`partner_id`,`p1`.`title`,`p1`.`thumb` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '39' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000542s ]
SELECT `c`.`id`,`c`.`name`,`m`.`file` FROM `base_category` `c` INNER JOIN `base_model` `m` ON `m`.`id`=`c`.`model` WHERE `c`.`status` = '1' AND `c`.`pid` = '0' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000361s ]
SELECT `c`.`id`,`c`.`name`,`c`.`info`,`m`.`file` FROM `base_category` `c` INNER JOIN `base_model` `m` ON `m`.`id`=`c`.`model` WHERE `c`.`status` = '1' AND `c`.`pid` = '1' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000383s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000272s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '2' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000520s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 32 [ RunTime:0.000513s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 8 [ RunTime:0.000406s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 10 [ RunTime:0.000434s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 35 [ RunTime:0.000391s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 3 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000271s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '3' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000490s ]
SELECT * FROM `base_project` WHERE `cid` = 3 AND `status` = 1 AND `partner_id` = 5 [ RunTime:0.000424s ]
SELECT * FROM `base_project` WHERE `cid` = 3 AND `status` = 1 AND `partner_id` = 2 [ RunTime:0.000397s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 28 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000372s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '29' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000556s ]
SELECT * FROM `base_project` WHERE `cid` = 29 AND `status` = 1 AND `partner_id` = 33 [ RunTime:0.000430s ]
SELECT * FROM `base_project` WHERE `cid` = 29 AND `status` = 1 AND `partner_id` = 38 [ RunTime:0.000377s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '30' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000493s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '31' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000638s ]
SELECT * FROM `base_project` WHERE `cid` = 31 AND `status` = 1 AND `partner_id` = 32 [ RunTime:0.000676s ]
SELECT * FROM `base_project` WHERE `cid` = 31 AND `status` = 1 AND `partner_id` = 19 [ RunTime:0.000471s ]
SELECT * FROM `base_project` WHERE `cid` = 31 AND `status` = 1 AND `partner_id` = 10 [ RunTime:0.000853s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '112' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.004417s ]
SELECT * FROM `base_project` WHERE `cid` = 112 AND `status` = 1 AND `partner_id` = 38 [ RunTime:0.000381s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '113' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001041s ]
SELECT * FROM `base_project` WHERE `cid` = 113 AND `status` = 1 AND `partner_id` = 10 [ RunTime:0.001794s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '114' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000468s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 19 [ RunTime:0.000341s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 3 [ RunTime:0.000377s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 8 [ RunTime:0.000364s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 38 [ RunTime:0.000601s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 35 [ RunTime:0.000663s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 32 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000850s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '32' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000660s ]
SELECT * FROM `base_project` WHERE `cid` = 32 AND `status` = 1 AND `partner_id` = 11 [ RunTime:0.000984s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 34 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000783s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '35' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001224s ]
SELECT * FROM `base_project` WHERE `cid` = 35 AND `status` = 1 AND `partner_id` = 15 [ RunTime:0.000856s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '36' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001046s ]
SELECT * FROM `base_project` WHERE `cid` = 36 AND `status` = 1 AND `partner_id` = 23 [ RunTime:0.000955s ]
SELECT * FROM `base_project` WHERE `cid` = 36 AND `status` = 1 AND `partner_id` = 43 [ RunTime:0.000879s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 37 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000854s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '39' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000873s ]
SELECT * FROM `base_project` WHERE `cid` = 39 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000743s ]
SELECT * FROM `base_project` WHERE `cid` = 39 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.000859s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '41' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001138s ]
SELECT * FROM `base_project` WHERE `cid` = 41 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000937s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '42' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001009s ]
SELECT * FROM `base_project` WHERE `cid` = 42 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000881s ]
SELECT * FROM `base_project` WHERE `cid` = 42 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.000885s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '45' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000998s ]
SELECT * FROM `base_project` WHERE `cid` = 45 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000921s ]
SELECT * FROM `base_project` WHERE `cid` = 45 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.000912s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '46' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001011s ]
SELECT * FROM `base_project` WHERE `cid` = 46 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000916s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '47' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001385s ]
SELECT * FROM `base_project` WHERE `cid` = 47 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000912s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '48' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000941s ]
SELECT * FROM `base_project` WHERE `cid` = 48 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000838s ]
SELECT * FROM `base_project` WHERE `cid` = 48 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.000867s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '49' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000925s ]
SELECT * FROM `base_project` WHERE `cid` = 49 AND `status` = 1 AND `partner_id` = 19 [ RunTime:0.000774s ]
SELECT * FROM `base_project` WHERE `cid` = 49 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000927s ]
SELECT * FROM `base_project` WHERE `cid` = 49 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.000864s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '118' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000849s ]
SELECT * FROM `base_project` WHERE `cid` = 118 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000883s ]
SELECT * FROM `base_project` WHERE `cid` = 118 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.000861s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '40' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000934s ]
SELECT * FROM `base_project` WHERE `cid` = 40 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000813s ]
SELECT * FROM `base_project` WHERE `cid` = 40 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.000852s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 51 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000660s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '51' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001063s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 3 [ RunTime:0.001428s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 9 [ RunTime:0.001527s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 39 [ RunTime:0.000961s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 18 [ RunTime:0.001437s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 25 [ RunTime:0.000981s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 52 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001373s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '52' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001151s ]
SELECT * FROM `base_project` WHERE `cid` = 52 AND `status` = 1 AND `partner_id` = 14 [ RunTime:0.001550s ]
SELECT * FROM `base_project` WHERE `cid` = 52 AND `status` = 1 AND `partner_id` = 11 [ RunTime:0.000998s ]
SELECT * FROM `base_project` WHERE `cid` = 52 AND `status` = 1 AND `partner_id` = 26 [ RunTime:0.001059s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 53 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000819s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '53' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.001135s ]
SELECT * FROM `base_project` WHERE `cid` = 53 AND `status` = 1 AND `partner_id` = 11 [ RunTime:0.001028s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 54 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000361s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '54' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000967s ]
SELECT * FROM `base_project` WHERE `cid` = 54 AND `status` = 1 AND `partner_id` = 30 [ RunTime:0.000439s ]
SELECT * FROM `base_project` WHERE `cid` = 54 AND `status` = 1 AND `partner_id` = 2 [ RunTime:0.000390s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 119 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000285s ]
SELECT `p`.`partner_id`,`p1`.`title` FROM `base_project` `p` INNER JOIN `base_partner` `p1` ON `p1`.`id`=`p`.`partner_id` WHERE `p`.`cid` = '119' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000475s ]
SELECT * FROM `base_project` WHERE `cid` = 119 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000406s ]
SELECT `c`.`id`,`c`.`name`,`c`.`info`,`m`.`file` FROM `base_category` `c` INNER JOIN `base_model` `m` ON `m`.`id`=`c`.`model` WHERE `c`.`status` = '1' AND `c`.`pid` = '4' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000401s ]
SELECT `c`.`id`,`c`.`name`,`c`.`info`,`m`.`file` FROM `base_category` `c` INNER JOIN `base_model` `m` ON `m`.`id`=`c`.`model` WHERE `c`.`status` = '1' AND `c`.`pid` = '5' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000379s ]
SELECT `c`.`id`,`c`.`name`,`c`.`info`,`m`.`file` FROM `base_category` `c` INNER JOIN `base_model` `m` ON `m`.`id`=`c`.`model` WHERE `c`.`status` = '1' AND `c`.`pid` = '6' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000280s ]
SELECT `c`.`id`,`c`.`name`,`c`.`info`,`m`.`file` FROM `base_category` `c` INNER JOIN `base_model` `m` ON `m`.`id`=`c`.`model` WHERE `c`.`status` = '1' AND `c`.`pid` = '7' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000332s ]
SELECT `c`.`id`,`c`.`name`,`c`.`info`,`m`.`file` FROM `base_category` `c` INNER JOIN `base_model` `m` ON `m`.`id`=`c`.`model` WHERE `c`.`status` = '1' AND `c`.`pid` = '23' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000279s ]