SHOW FULL COLUMNS FROM `base_project` [ RunTime:0.000644s ]
SELECT * FROM `base_project` WHERE `id` = 352 LIMIT 1 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `base_category` [ RunTime:0.000559s ]
SELECT * FROM `base_category` WHERE `id` = 118 LIMIT 1 [ RunTime:0.000307s ]
SELECT `pid` FROM `base_category` WHERE `id` = 118 LIMIT 1 [ RunTime:0.000227s ]
SELECT `pid` FROM `base_category` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000905s ]
SELECT `pid` FROM `base_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000216s ]
SELECT `name` FROM `base_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`name`,`table` FROM `base_category` WHERE `id` = 118 AND `status` <> 9 LIMIT 1 [ RunTime:0.000928s ]
SHOW FULL COLUMNS FROM `base_project_guangyuan_xian` [ RunTime:0.000839s ]
SELECT * FROM `base_project_guangyuan_xian` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000723s ]
SHOW FULL COLUMNS FROM `base_config` [ RunTime:0.000872s ]
SELECT * FROM `base_config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000879s ]
show full columns from base_project_guangyuan_xian [ RunTime:0.001849s ]
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` = '118' AND `p`.`status` = '1' GROUP BY `p`.`partner_id` ORDER BY `p1`.`title` ASC [ RunTime:0.000972s ]
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.002539s ]
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.001869s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000309s ]
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.000535s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 32 [ RunTime:0.000445s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 8 [ RunTime:0.000978s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 10 [ RunTime:0.001053s ]
SELECT * FROM `base_project` WHERE `cid` = 2 AND `status` = 1 AND `partner_id` = 35 [ RunTime:0.000902s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 3 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001025s ]
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.001152s ]
SELECT * FROM `base_project` WHERE `cid` = 3 AND `status` = 1 AND `partner_id` = 5 [ RunTime:0.001032s ]
SELECT * FROM `base_project` WHERE `cid` = 3 AND `status` = 1 AND `partner_id` = 2 [ RunTime:0.001000s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 28 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000929s ]
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.001084s ]
SELECT * FROM `base_project` WHERE `cid` = 29 AND `status` = 1 AND `partner_id` = 33 [ RunTime:0.001167s ]
SELECT * FROM `base_project` WHERE `cid` = 29 AND `status` = 1 AND `partner_id` = 38 [ RunTime:0.001063s ]
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.001154s ]
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.000973s ]
SELECT * FROM `base_project` WHERE `cid` = 31 AND `status` = 1 AND `partner_id` = 32 [ RunTime:0.001032s ]
SELECT * FROM `base_project` WHERE `cid` = 31 AND `status` = 1 AND `partner_id` = 19 [ RunTime:0.000965s ]
SELECT * FROM `base_project` WHERE `cid` = 31 AND `status` = 1 AND `partner_id` = 10 [ RunTime:0.001103s ]
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.001392s ]
SELECT * FROM `base_project` WHERE `cid` = 112 AND `status` = 1 AND `partner_id` = 38 [ RunTime:0.003249s ]
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.001170s ]
SELECT * FROM `base_project` WHERE `cid` = 113 AND `status` = 1 AND `partner_id` = 10 [ RunTime:0.001026s ]
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.001260s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 19 [ RunTime:0.001048s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 3 [ RunTime:0.000962s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 8 [ RunTime:0.002287s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 38 [ RunTime:0.001585s ]
SELECT * FROM `base_project` WHERE `cid` = 114 AND `status` = 1 AND `partner_id` = 35 [ RunTime:0.001745s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 32 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001024s ]
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.001274s ]
SELECT * FROM `base_project` WHERE `cid` = 32 AND `status` = 1 AND `partner_id` = 11 [ RunTime:0.001217s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 34 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001345s ]
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.001375s ]
SELECT * FROM `base_project` WHERE `cid` = 35 AND `status` = 1 AND `partner_id` = 15 [ RunTime:0.001355s ]
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.001986s ]
SELECT * FROM `base_project` WHERE `cid` = 36 AND `status` = 1 AND `partner_id` = 23 [ RunTime:0.001690s ]
SELECT * FROM `base_project` WHERE `cid` = 36 AND `status` = 1 AND `partner_id` = 43 [ RunTime:0.001377s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 37 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001678s ]
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.001217s ]
SELECT * FROM `base_project` WHERE `cid` = 39 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001771s ]
SELECT * FROM `base_project` WHERE `cid` = 39 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.002557s ]
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.001367s ]
SELECT * FROM `base_project` WHERE `cid` = 41 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000777s ]
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.001267s ]
SELECT * FROM `base_project` WHERE `cid` = 42 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.000709s ]
SELECT * FROM `base_project` WHERE `cid` = 42 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.001717s ]
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.001887s ]
SELECT * FROM `base_project` WHERE `cid` = 45 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001585s ]
SELECT * FROM `base_project` WHERE `cid` = 45 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.001688s ]
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.001721s ]
SELECT * FROM `base_project` WHERE `cid` = 46 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001615s ]
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.001706s ]
SELECT * FROM `base_project` WHERE `cid` = 47 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001641s ]
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.001671s ]
SELECT * FROM `base_project` WHERE `cid` = 48 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001679s ]
SELECT * FROM `base_project` WHERE `cid` = 48 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.001818s ]
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.001831s ]
SELECT * FROM `base_project` WHERE `cid` = 49 AND `status` = 1 AND `partner_id` = 19 [ RunTime:0.001748s ]
SELECT * FROM `base_project` WHERE `cid` = 49 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001595s ]
SELECT * FROM `base_project` WHERE `cid` = 49 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.001241s ]
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.002084s ]
SELECT * FROM `base_project` WHERE `cid` = 118 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001360s ]
SELECT * FROM `base_project` WHERE `cid` = 118 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.001376s ]
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.001749s ]
SELECT * FROM `base_project` WHERE `cid` = 40 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.001748s ]
SELECT * FROM `base_project` WHERE `cid` = 40 AND `status` = 1 AND `partner_id` = 29 [ RunTime:0.001578s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 51 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001562s ]
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.002248s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 3 [ RunTime:0.001564s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 9 [ RunTime:0.001723s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 39 [ RunTime:0.001642s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 18 [ RunTime:0.001534s ]
SELECT * FROM `base_project` WHERE `cid` = 51 AND `status` = 1 AND `partner_id` = 25 [ RunTime:0.001538s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 52 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001364s ]
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.001626s ]
SELECT * FROM `base_project` WHERE `cid` = 52 AND `status` = 1 AND `partner_id` = 14 [ RunTime:0.001670s ]
SELECT * FROM `base_project` WHERE `cid` = 52 AND `status` = 1 AND `partner_id` = 11 [ RunTime:0.002626s ]
SELECT * FROM `base_project` WHERE `cid` = 52 AND `status` = 1 AND `partner_id` = 26 [ RunTime:0.002099s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 53 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001601s ]
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.001866s ]
SELECT * FROM `base_project` WHERE `cid` = 53 AND `status` = 1 AND `partner_id` = 11 [ RunTime:0.002732s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 54 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000862s ]
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.001841s ]
SELECT * FROM `base_project` WHERE `cid` = 54 AND `status` = 1 AND `partner_id` = 30 [ RunTime:0.002581s ]
SELECT * FROM `base_project` WHERE `cid` = 54 AND `status` = 1 AND `partner_id` = 2 [ RunTime:0.001445s ]
SELECT `id`,`name`,`info` FROM `base_category` WHERE `status` = 1 AND `pid` = 119 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001679s ]
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.001632s ]
SELECT * FROM `base_project` WHERE `cid` = 119 AND `status` = 1 AND `partner_id` = 1 [ RunTime:0.002289s ]
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.001705s ]
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.001206s ]
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.001573s ]
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.001359s ]
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.001443s ]