SHOW FULL COLUMNS FROM `cs_goods_category` [ RunTime:0.002604s ]
SELECT `id`,`pid`,`sortrank`,`name`,`status`,`is_last`,`thumb_url` FROM `cs_goods_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sortrank` DESC,`pid` DESC,`id` DESC [ RunTime:0.000719s ]
SELECT `id`,`pid`,`sortrank`,`name`,`status`,`is_last`,`thumb_url` FROM `cs_goods_category` WHERE `pid` = 247 AND `status` = 1 ORDER BY `sortrank` DESC,`pid` DESC,`id` DESC [ RunTime:0.000941s ]
SELECT `id`,`pid`,`sortrank`,`name`,`status`,`is_last`,`thumb_url` FROM `cs_goods_category` WHERE `pid` = 249 AND `status` = 1 ORDER BY `sortrank` DESC,`pid` DESC,`id` DESC [ RunTime:0.002155s ]
SELECT `id`,`pid`,`sortrank`,`name`,`status`,`is_last`,`thumb_url` FROM `cs_goods_category` WHERE `pid` = 251 AND `status` = 1 ORDER BY `sortrank` DESC,`pid` DESC,`id` DESC [ RunTime:0.000859s ]
SHOW FULL COLUMNS FROM `cs_project_category` [ RunTime:0.002036s ]
SELECT `id`,`name`,`thumb_url`,`big_pic` FROM `cs_project_category` WHERE `status` = 1 AND `is_last` = 1 ORDER BY `sortrank` DESC,`id` DESC [ RunTime:0.000821s ]
SELECT COUNT(*) AS think_count FROM `cs_project_category` WHERE `status` = 1 AND `is_last` = 1 LIMIT 1 [ RunTime:0.000748s ]
SHOW FULL COLUMNS FROM `cs_project_creativity` [ RunTime:0.002339s ]
SELECT `id`,`sortrank`,`project_code`,`category_id`,`initiator_id`,`title`,`main_pic`,`check_status`,`unpassed_reason`,`shelf_status`,`is_recommend`,`recommend_time`,`create_time` FROM `cs_project_creativity` WHERE `check_status` = 2 AND `shelf_status` = 1 AND `create_time` >= 1772726400 AND `is_deleted` = 0 ORDER BY `sortrank` DESC,`id` DESC LIMIT 0,9 [ RunTime:0.001120s ]
SELECT COUNT(*) AS think_count FROM `cs_project_creativity` WHERE `check_status` = 2 AND `shelf_status` = 1 AND `create_time` >= 1772726400 AND `is_deleted` = 0 LIMIT 1 [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `cs_project_crowd_fund` [ RunTime:0.002816s ]
SELECT `id`,`sortrank`,`project_code`,`category_id`,`initiator_type`,`initiator_id`,`crowd_type`,`title`,`main_pic`,`target_amount`,`real_amount`,`crowd_begin_time`,`crowd_end_time`,`check_status`,`shelf_status`,`is_recommend`,`recommend_time`,`create_time`,`display_amount`,`display_support_num`,`display_supporter_num` FROM `cs_project_crowd_fund` WHERE `check_status` = 2 AND `shelf_status` = 1 AND `is_deleted` = 0 ORDER BY `is_recommend` DESC,`id` DESC LIMIT 0,3 [ RunTime:0.001387s ]
SELECT `id`,`name` FROM `cs_project_category` WHERE `id` = 15 [ RunTime:0.001042s ]
SHOW FULL COLUMNS FROM `cs_project_crowd_fund_package` [ RunTime:0.003033s ]
SELECT SUM(`num`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 757 AND `status` = 1 LIMIT 1 [ RunTime:0.001143s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_package` WHERE `project_id` = 757 AND `status` = 1 LIMIT 1 [ RunTime:0.001260s ]
SELECT SUM(`sales`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 757 AND `status` = 1 LIMIT 1 [ RunTime:0.000980s ]
SELECT SUM(`display_sales`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 757 AND `status` = 1 LIMIT 1 [ RunTime:0.000994s ]
SELECT MAX(`price`) AS think_max FROM `cs_project_crowd_fund_package` WHERE `project_id` = 757 AND `status` = 1 LIMIT 1 [ RunTime:0.000612s ]
SELECT MIN(`price`) AS think_min FROM `cs_project_crowd_fund_package` WHERE `project_id` = 757 AND `status` = 1 LIMIT 1 [ RunTime:0.000609s ]
SELECT * FROM `cs_project_crowd_fund` WHERE `id` = 757 LIMIT 1 [ RunTime:0.000957s ]
SHOW FULL COLUMNS FROM `cs_project_order` [ RunTime:0.009724s ]
SELECT COUNT(*) AS think_count FROM `cs_project_order` WHERE `project_id` = 757 AND `is_deleted` = 0 AND `order_status` IN (1,2,3,4,-4,-5) LIMIT 1 [ RunTime:0.001621s ]
SELECT `id`,`buyer_id`,`project_id` FROM `cs_project_order` WHERE `project_id` = 757 AND `is_deleted` = 0 AND `order_status` IN (1,2,3,4,-4,-5) ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.001251s ]
SHOW FULL COLUMNS FROM `cs_project_department` [ RunTime:0.005035s ]
SELECT `id`,`name`,`logo` FROM `cs_project_department` WHERE `id` = 29 LIMIT 1 [ RunTime:0.001319s ]
SHOW FULL COLUMNS FROM `cs_project_crowd_fund_member_praise` [ RunTime:0.006125s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_member_praise` WHERE `project_id` = 757 LIMIT 1 [ RunTime:0.003624s ]
SELECT * FROM `cs_project_crowd_fund_member_praise` WHERE `project_id` = 757 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.001944s ]
SHOW FULL COLUMNS FROM `cs_project_crowd_fund_appointment` [ RunTime:0.003870s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_appointment` WHERE `project_id` = 757 LIMIT 1 [ RunTime:0.002937s ]
SELECT * FROM `cs_project_crowd_fund_appointment` WHERE `project_id` = 757 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000858s ]
SELECT SUM(`num`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 753 AND `status` = 1 LIMIT 1 [ RunTime:0.000960s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_package` WHERE `project_id` = 753 AND `status` = 1 LIMIT 1 [ RunTime:0.000696s ]
SELECT SUM(`sales`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 753 AND `status` = 1 LIMIT 1 [ RunTime:0.001154s ]
SELECT SUM(`display_sales`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 753 AND `status` = 1 LIMIT 1 [ RunTime:0.000617s ]
SELECT MAX(`price`) AS think_max FROM `cs_project_crowd_fund_package` WHERE `project_id` = 753 AND `status` = 1 LIMIT 1 [ RunTime:0.000675s ]
SELECT MIN(`price`) AS think_min FROM `cs_project_crowd_fund_package` WHERE `project_id` = 753 AND `status` = 1 LIMIT 1 [ RunTime:0.000667s ]
SELECT * FROM `cs_project_crowd_fund` WHERE `id` = 753 LIMIT 1 [ RunTime:0.000676s ]
SELECT COUNT(*) AS think_count FROM `cs_project_order` WHERE `project_id` = 753 AND `is_deleted` = 0 AND `order_status` IN (1,2,3,4,-4,-5) LIMIT 1 [ RunTime:0.001173s ]
SELECT `id`,`buyer_id`,`project_id` FROM `cs_project_order` WHERE `project_id` = 753 AND `is_deleted` = 0 AND `order_status` IN (1,2,3,4,-4,-5) ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000689s ]
SELECT `id`,`name`,`logo` FROM `cs_project_department` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000853s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_member_praise` WHERE `project_id` = 753 LIMIT 1 [ RunTime:0.000529s ]
SELECT * FROM `cs_project_crowd_fund_member_praise` WHERE `project_id` = 753 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000647s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_appointment` WHERE `project_id` = 753 LIMIT 1 [ RunTime:0.000447s ]
SELECT * FROM `cs_project_crowd_fund_appointment` WHERE `project_id` = 753 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000891s ]
SELECT SUM(`num`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 751 AND `status` = 1 LIMIT 1 [ RunTime:0.000936s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_package` WHERE `project_id` = 751 AND `status` = 1 LIMIT 1 [ RunTime:0.000765s ]
SELECT SUM(`sales`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 751 AND `status` = 1 LIMIT 1 [ RunTime:0.000675s ]
SELECT SUM(`display_sales`) AS think_sum FROM `cs_project_crowd_fund_package` WHERE `project_id` = 751 AND `status` = 1 LIMIT 1 [ RunTime:0.000662s ]
SELECT MAX(`price`) AS think_max FROM `cs_project_crowd_fund_package` WHERE `project_id` = 751 AND `status` = 1 LIMIT 1 [ RunTime:0.001632s ]
SELECT MIN(`price`) AS think_min FROM `cs_project_crowd_fund_package` WHERE `project_id` = 751 AND `status` = 1 LIMIT 1 [ RunTime:0.000656s ]
SELECT * FROM `cs_project_crowd_fund` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000732s ]
SELECT COUNT(*) AS think_count FROM `cs_project_order` WHERE `project_id` = 751 AND `is_deleted` = 0 AND `order_status` IN (1,2,3,4,-4,-5) LIMIT 1 [ RunTime:0.000873s ]
SELECT `id`,`buyer_id`,`project_id` FROM `cs_project_order` WHERE `project_id` = 751 AND `is_deleted` = 0 AND `order_status` IN (1,2,3,4,-4,-5) ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000986s ]
SELECT `id`,`name`,`logo` FROM `cs_project_department` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000743s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_member_praise` WHERE `project_id` = 751 LIMIT 1 [ RunTime:0.000753s ]
SELECT * FROM `cs_project_crowd_fund_member_praise` WHERE `project_id` = 751 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000713s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund_appointment` WHERE `project_id` = 751 LIMIT 1 [ RunTime:0.000626s ]
SELECT * FROM `cs_project_crowd_fund_appointment` WHERE `project_id` = 751 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000483s ]
SELECT COUNT(*) AS think_count FROM `cs_project_crowd_fund` WHERE `check_status` = 2 AND `shelf_status` = 1 AND `is_deleted` = 0 LIMIT 1 [ RunTime:0.001149s ]
SHOW FULL COLUMNS FROM `cs_banner` [ RunTime:0.002398s ]
SELECT `b`.`id`,`b`.`name`,`b`.`pic_url`,`p`.`tag`,`b`.`click_type`,`b`.`link_url`,`b`.`valid_time_type`,`b`.`valid_time_begin`,`b`.`valid_time_end` FROM `cs_banner` `b` INNER JOIN `cs_banner_position` `p` ON `b`.`position_id`=`p`.`id` WHERE `b`.`status` = '1' AND `b`.`type` = '2' AND `p`.`tag` = 'web_creative_carousel' ORDER BY `b`.`sortrank` DESC,`b`.`id` DESC [ RunTime:0.000741s ]
SELECT COUNT(*) AS think_count FROM `cs_banner` `b` INNER JOIN `cs_banner_position` `p` ON `b`.`position_id`=`p`.`id` WHERE `b`.`status` = '1' AND `b`.`type` = '2' AND `p`.`tag` = 'web_creative_carousel' LIMIT 1 [ RunTime:0.001505s ]