[ DB ] CONNECT:[ UseTime:0.000651s ] mysql:host=127.0.0.1;port=3306;dbname=tms0012;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `hunuo_web_config` [ RunTime:0.001538s ]
[ SQL ] SELECT * FROM `hunuo_web_config` WHERE `object_name` = 'website' LIMIT 1 [ RunTime:0.000581s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand` [ RunTime:0.001375s ]
[ SQL ] SELECT `id`,`is_open`,`is_recommend`,`thumb`,`search_keywords`,`sort_order`,`create_time`,`update_time`,`delete_time` FROM `hunuo_brand` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000562s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand_lang` [ RunTime:0.000904s ]
[ SQL ] SELECT * FROM `hunuo_brand_lang` WHERE `website_code` = 'spanish' AND `brand_id` = 4 [ RunTime:0.000544s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product` [ RunTime:0.001392s ]
[ SQL ] SELECT `product_id` FROM `hunuo_product` WHERE `is_open` = 1 AND `publish_time` <= 1787353624 AND `brand_id` = 4 LIMIT 18000 [ RunTime:0.006222s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hunuo_product` WHERE `is_open` = 1 AND `product_id` IN (25856,26535,26536,26537,26538,26539,26540,26643,26644,26646,26663,26674,26688,26696,26703,26723,26727,26728,28079,28080,28081,29897,29996,29998,30521) LIMIT 1 [ RunTime:0.000773s ]
[ SQL ] SELECT `product_id`,`title`,`thumb`,`thumb_alt`,`link`,`sort_order`,`shop_price`,`market_price`,`product_number`,`brand_id`,`product_model`,`prefix_code`,`sku`,`book_num` FROM `hunuo_product` WHERE `is_open` = 1 AND `product_id` IN (25856,26535,26536,26537,26538,26539,26540,26643,26644,26646,26663,26674,26688,26696,26703,26723,26727,26728,28079,28080,28081,29897,29996,29998,30521) ORDER BY `sort_order` DESC,`product_id` DESC LIMIT 0,9 [ RunTime:0.000732s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_lang` [ RunTime:0.001488s ]
[ SQL ] SELECT `lang_id`,`product_id`,`title`,`intro`,`description`,`thumb`,`thumb_alt`,`link` FROM `hunuo_product_lang` WHERE `website_code` = 'spanish' AND `product_id` IN (30521,29998,29996,29897,28081,28080,28079,26728,26727) [ RunTime:0.000922s ]
[ SQL ] SELECT `lang_id`,`brand_id`,`lang_value` FROM `hunuo_brand_lang` WHERE `website_code` = 'spanish' AND `brand_id` IN (4) [ RunTime:0.000529s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_price` [ RunTime:0.000917s ]
[ SQL ] SELECT * FROM `hunuo_product_price` WHERE `product_id` IN (30521,29998,29996,29897,28081,28080,28079,26728,26727) ORDER BY `num` ASC [ RunTime:0.000614s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_sub` [ RunTime:0.001007s ]
[ SQL ] SELECT `id`,`product_id`,`shop_price`,`product_number` FROM `hunuo_product_sub` WHERE `product_id` IN (30521,29998,29996,29897,28081,28080,28079,26728,26727) [ RunTime:0.000563s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category` [ RunTime:0.001150s ]
[ SQL ] SELECT `cat_id`,`parent_id`,`is_open`,`is_home`,`sort_order`,`route_alias`,`thumb`,`thumb_alt`,`attr_id_str`,`create_time`,`update_time` FROM `hunuo_article_category` WHERE `is_open` = 1 ORDER BY `sort_order` ASC,`cat_id` ASC [ RunTime:0.000753s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category_lang` [ RunTime:0.001008s ]
[ SQL ] SELECT * FROM `hunuo_article_category_lang` WHERE `website_code` = 'spanish' AND `cat_id` IN (1,23,2,27,3,4,5,6,7,9,10,11,12,13,14,15,16,20,21,22,24,25,26,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,47,48) [ RunTime:0.000878s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article` [ RunTime:0.001218s ]
[ SQL ] SELECT `article_id`,`is_target`,`is_home`,`is_recommend`,`is_hot`,`is_new`,`thumb`,`thumb_alt`,`file_url`,`link`,`publish_time` FROM `hunuo_article` WHERE `is_open` = 1 AND `cat_id` = 26 ORDER BY `sort_order` ASC,`article_id` ASC LIMIT 0,4 [ RunTime:0.000672s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_lang` [ RunTime:0.001255s ]
[ SQL ] SELECT `lang_id`,`website_code`,`article_id`,`title`,`subtitle`,`intro`,`intro2`,`content`,`thumb`,`thumb_alt`,`link`,`establishment`,`establishment_year`,`office_area`,`office_num`,`staff`,`staff_num` FROM `hunuo_article_lang` WHERE `website_code` = 'spanish' AND `article_id` IN (39,40,41,42) [ RunTime:0.000699s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_album` [ RunTime:0.000969s ]
[ SQL ] SELECT * FROM `hunuo_article_album` WHERE `article_id` IN (39,40,41,42) ORDER BY `sort_order` ASC [ RunTime:0.000471s ]
