[ DB ] CONNECT:[ UseTime:0.000243s ] mysql:host=localhost;port=3306;dbname=0731jiaju;charset=utf8
[ SQL ] SHOW COLUMNS FROM `0731_product_category` [ RunTime:0.000913s ]
[ SQL ] SELECT `product_category_id`,`category_name`,`parent_id`,`order_by` FROM `0731_product_category` WHERE `category_name` <> '其它' AND `product_category_id` NOT IN (321) AND `parent_id` NOT IN (321) ORDER BY `order_by` [ RunTime:0.000714s ]
[ SQL ] SHOW COLUMNS FROM `0731_brand` [ RunTime:0.000738s ]
[ SQL ] SELECT `b`.`product_category_id`,`b`.`brand_id`,`b`.`user_id`,`b`.`name`,`b`.`img`,`b`.`url`,`b`.`sort`,`cp`.`grade`,`cp`.`company_name` FROM `0731_brand` `b` LEFT JOIN `0731_company_profile` `cp` ON `cp`.`user_id`=`b`.`user_id` WHERE `cp`.`grade` = '1' ORDER BY `b`.`sort` DESC [ RunTime:0.001630s ]
[ SQL ] SHOW COLUMNS FROM `0731_help_category` [ RunTime:0.000685s ]
[ SQL ] SELECT * FROM `0731_help_category` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000250s ]
[ SQL ] SHOW COLUMNS FROM `0731_help_article` [ RunTime:0.000903s ]
[ SQL ] SELECT `help_article_id`,`title`,`name`,`help_category_id` FROM `0731_help_article` WHERE `help_category_id` IN (1,2,3,4,5,6) ORDER BY `sort` ASC [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `0731_product_category` WHERE `product_category_id` = 7002 LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT * FROM `0731_product_category` WHERE `product_category_id` = 11 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT `product_category_id`,`category_name`,`parent_id`,`order_by` FROM `0731_product_category` WHERE ( `product_category_id` = 11 OR `parent_id` = 11 ) ORDER BY `order_by` ASC [ RunTime:0.000567s ]
[ SQL ] SELECT `brand_id`,`product_category_id`,`user_id`,`name`,`img`,`url`,`checkup`,`sort` FROM `0731_brand` WHERE `checkup` = 1 AND `product_category_id` IN (11,7002) ORDER BY `sort` DESC [ RunTime:0.000229s ]
[ SQL ] SHOW COLUMNS FROM `0731_product` [ RunTime:0.000760s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `0731_product` `p` LEFT JOIN `0731_company_profile` `cp` ON `cp`.`user_id`=`p`.`user_id` WHERE `p`.`product_category_id` IN ('7002') AND `p`.`checkup` = '1' LIMIT 1 [ RunTime:0.000413s ]
[ SQL ] SELECT `p`.`product_id`,`p`.`product_category_id`,`p`.`user_id`,`p`.`product_name`,`p`.`date`,`p`.`is_highlighted`,`p`.`img_url`,`p`.`checkup`,`p`.`view_count`,`p`.`commend`,`p`.`price`,`p`.`yprice`,`p`.`sprice`,`p`.`is_buy`,`p`.`buy_checkup`,`cp`.`company_name`,`cp`.`grade`,`cp`.`checkup`,`cp`.`gold` FROM `0731_product` `p` LEFT JOIN `0731_company_profile` `cp` ON `cp`.`user_id`=`p`.`user_id` WHERE `p`.`product_category_id` IN ('7002') AND `p`.`checkup` = '1' ORDER BY `cp`.`grade` DESC,`p`.`commend` DESC,`p`.`date` DESC LIMIT 0,20 [ RunTime:0.000972s ]
[ SQL ] SELECT DISTINCT `sub`.`user_id` FROM ( SELECT `p`.`user_id` FROM `0731_product` `p` LEFT JOIN `0731_company_profile` `cp` ON `cp`.`user_id`=`p`.`user_id` WHERE `p`.`commend` = '1' AND `p`.`is_buy` = '1' AND `p`.`buy_checkup` = '1' AND `cp`.`grade` = '1' ORDER BY `p`.`date` DESC LIMIT 400 )sub LIMIT 8 [ RunTime:0.054887s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 37200 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000553s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 1021 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000386s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 38572 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 23301 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000646s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 75668 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000196s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 75522 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 75534 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT `product_id`,`product_name`,`user_id`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE `is_buy` = 1 AND `buy_checkup` = 1 AND `user_id` = 75742 ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SHOW COLUMNS FROM `0731_ask` [ RunTime:0.000834s ]
[ SQL ] SELECT `ask_id`,`title`,`user_id`,`time`,`status`,`checkup`,`product_cateid` FROM `0731_ask` WHERE `product_cateid` IN (11,7002) AND `status` = 1 AND `checkup` = 1 ORDER BY `ask_id` DESC LIMIT 5 [ RunTime:0.000201s ]
[ SQL ] SELECT `product_category_id` FROM `0731_product_category` WHERE `parent_id` = 20 ORDER BY `product_category_id` DESC [ RunTime:0.000239s ]
[ SQL ] SELECT DISTINCT `sub`.`user_id` FROM ( SELECT `p`.`user_id` FROM `0731_product` `p` LEFT JOIN `0731_company_profile` `cp` ON `cp`.`user_id`=`p`.`user_id` WHERE `p`.`commend` = '1' AND `p`.`is_buy` = '1' AND `p`.`buy_checkup` = '1' AND `p`.`product_category_id` IN ('7014','369','353','310','302','301','300','299','283','282','281','280','279','278','277') ORDER BY `p`.`product_id` LIMIT 250 )sub LIMIT 5 [ RunTime:0.158425s ]
[ SQL ] SELECT `product_id`,`product_name`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE ( `user_id` = 75522 AND `is_buy` = 1 AND `buy_checkup` = 1 ) ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000438s ]
[ SQL ] SELECT `product_id`,`product_name`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE ( `user_id` = 75522 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 922 AND `is_buy` = 1 AND `buy_checkup` = 1 ) ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `product_id`,`product_name`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE ( `user_id` = 75522 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 922 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 22941 AND `is_buy` = 1 AND `buy_checkup` = 1 ) ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT `product_id`,`product_name`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE ( `user_id` = 75522 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 922 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 22941 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 72997 AND `is_buy` = 1 AND `buy_checkup` = 1 ) ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000156s ]
[ SQL ] SELECT `product_id`,`product_name`,`img_url`,`price`,`yprice`,`sprice` FROM `0731_product` WHERE ( `user_id` = 75522 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 922 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 22941 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 72997 AND `is_buy` = 1 AND `buy_checkup` = 1 ) AND ( `user_id` = 36038 AND `is_buy` = 1 AND `buy_checkup` = 1 ) ORDER BY `product_id` DESC LIMIT 1 [ RunTime:0.000174s ]
