[ DB ] CONNECT:[ UseTime:0.000679s ] mysql:host=127.0.0.1;port=3306;dbname=tms0012;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `hunuo_web_config` [ RunTime:0.001490s ]
[ SQL ] SELECT * FROM `hunuo_web_config` WHERE `object_name` = 'website' LIMIT 1 [ RunTime:0.000531s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand` [ RunTime:0.001346s ]
[ SQL ] SELECT `id`,`is_open`,`is_recommend`,`thumb`,`search_keywords`,`sort_order`,`create_time`,`update_time`,`delete_time` FROM `hunuo_brand` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000570s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand_lang` [ RunTime:0.000973s ]
[ SQL ] SELECT * FROM `hunuo_brand_lang` WHERE `website_code` = 'en-us' AND `brand_id` = 13 [ RunTime:0.000564s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product` [ RunTime:0.001557s ]
[ SQL ] SELECT `product_id` FROM `hunuo_product` WHERE `is_open` = 1 AND `publish_time` <= 1793109012 AND `brand_id` = 13 LIMIT 18000 [ RunTime:0.006574s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hunuo_product` WHERE `is_open` = 1 AND `product_id` IN (27764,27765,27766,27767,27768,27769,27770,27771,27772,27773,27774,27775,27776,27777,27778,27874,27875,27903,27904,27905,27906,27907,27908,27909,27910,27929,27930,27952,28128,28129,28130,28131,28132,28133,28134,28135,28136,28137,28138,28139,28140,28141,28142,28580,29447,29461,29462,29472,29484,29501,29503,29510,29539,29540,29541,29589,29590,29591,29592,29602,29738,29739,29740,29741,29742,30023,30024,30025,30027,30028,30029,30097,30100,30107,30111,30124,30125,30126,30140,30143,30630,30631,30632,30633,30657,30878,30879,30880,30927,30928,30929,30959,30960,30988,30989,30990,30991,30992,30993,30994,31005,31007,31008,31009,31026,31040,31041,31069,31095,31122,31123,31124,31125,31126,31127,31163,31164,31165,31166,31167,31186,31187,31188,31189,31190,31226,31250,31274,31275,31310,31311,31312,31314,31315,31344,31349,31350,31359,31360,31369,31374,31545,31554,31555,31611,31612,31613,31614,31615,31616,31617,31618,31619,31620,31621,31622,31623,31624,31625,31782,31783,31784,31785,31786,31787,31788,31789,31790,31791,31820,31842,31843,31844,32010,32064,32065,32074,32094,32095,32121,32150,32203,32204,32205,32206,32207,32208,32227,32244,32245,32248,32252,32253,32317,32318,32319,32320,32321,32322,32323,32324,32325,32326,32327,32387,32388,32389,32390,32391,32392,32393,32394,32395,32396,32397,32398,32399,32400,32401,32402,32403,32404,32519,32532,32541,32558,32559,32560,32573,32574,32575,32614,32615,32616,32617,32652,32653,32654,32655,32656,32657,32658,32659,32715,32720,32721,32723,32725,32726,32730,32731,32732,32743,32744,32745,32746,32803,32804,32805,32806,32807,32826,34558,34559,34560,34561,34562,34563,34595,34596,34597,34598,34599,34600,34631,34632,34633,34634,34635,34636,34638,34644,34645,34655,34656,34657,34691,34692,34721,34762,34818,34819,34820,34821,34822,34823,34824,34825,34876,34888,34889,34890,34909,34910,34911,34912,34913,34914,34915,34916,34985,34988,34989,34990,34991,34992,34993,34994,35013,35014,35015,35026,35040,35041,35042,35068,35069,35070,35078,35098,35101,35102,35103,35104,35105,35106,35107,35108,35280,35281,35291,35334,35557,35558,35561,35566,35627,35811,35863,35887) LIMIT 1 [ RunTime:0.002525s ]
[ 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 (27764,27765,27766,27767,27768,27769,27770,27771,27772,27773,27774,27775,27776,27777,27778,27874,27875,27903,27904,27905,27906,27907,27908,27909,27910,27929,27930,27952,28128,28129,28130,28131,28132,28133,28134,28135,28136,28137,28138,28139,28140,28141,28142,28580,29447,29461,29462,29472,29484,29501,29503,29510,29539,29540,29541,29589,29590,29591,29592,29602,29738,29739,29740,29741,29742,30023,30024,30025,30027,30028,30029,30097,30100,30107,30111,30124,30125,30126,30140,30143,30630,30631,30632,30633,30657,30878,30879,30880,30927,30928,30929,30959,30960,30988,30989,30990,30991,30992,30993,30994,31005,31007,31008,31009,31026,31040,31041,31069,31095,31122,31123,31124,31125,31126,31127,31163,31164,31165,31166,31167,31186,31187,31188,31189,31190,31226,31250,31274,31275,31310,31311,31312,31314,31315,31344,31349,31350,31359,31360,31369,31374,31545,31554,31555,31611,31612,31613,31614,31615,31616,31617,31618,31619,31620,31621,31622,31623,31624,31625,31782,31783,31784,31785,31786,31787,31788,31789,31790,31791,31820,31842,31843,31844,32010,32064,32065,32074,32094,32095,32121,32150,32203,32204,32205,32206,32207,32208,32227,32244,32245,32248,32252,32253,32317,32318,32319,32320,32321,32322,32323,32324,32325,32326,32327,32387,32388,32389,32390,32391,32392,32393,32394,32395,32396,32397,32398,32399,32400,32401,32402,32403,32404,32519,32532,32541,32558,32559,32560,32573,32574,32575,32614,32615,32616,32617,32652,32653,32654,32655,32656,32657,32658,32659,32715,32720,32721,32723,32725,32726,32730,32731,32732,32743,32744,32745,32746,32803,32804,32805,32806,32807,32826,34558,34559,34560,34561,34562,34563,34595,34596,34597,34598,34599,34600,34631,34632,34633,34634,34635,34636,34638,34644,34645,34655,34656,34657,34691,34692,34721,34762,34818,34819,34820,34821,34822,34823,34824,34825,34876,34888,34889,34890,34909,34910,34911,34912,34913,34914,34915,34916,34985,34988,34989,34990,34991,34992,34993,34994,35013,35014,35015,35026,35040,35041,35042,35068,35069,35070,35078,35098,35101,35102,35103,35104,35105,35106,35107,35108,35280,35281,35291,35334,35557,35558,35561,35566,35627,35811,35863,35887) ORDER BY `sort_order` DESC,`product_id` DESC LIMIT 0,9 [ RunTime:0.002537s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_lang` [ RunTime:0.001357s ]
[ SQL ] SELECT `lang_id`,`product_id`,`title`,`intro`,`description`,`thumb`,`thumb_alt`,`link` FROM `hunuo_product_lang` WHERE `website_code` = 'en-us' AND `product_id` IN (28580,35887,35863,35811,35627,35566,35561,35558,35557) [ RunTime:0.001785s ]
[ SQL ] SELECT `lang_id`,`brand_id`,`lang_value` FROM `hunuo_brand_lang` WHERE `website_code` = 'en-us' AND `brand_id` IN (13) [ RunTime:0.000563s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_price` [ RunTime:0.000946s ]
[ SQL ] SELECT * FROM `hunuo_product_price` WHERE `product_id` IN (28580,35887,35863,35811,35627,35566,35561,35558,35557) ORDER BY `num` ASC [ RunTime:0.000656s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_sub` [ RunTime:0.000971s ]
[ SQL ] SELECT `id`,`product_id`,`shop_price`,`product_number` FROM `hunuo_product_sub` WHERE `product_id` IN (28580,35887,35863,35811,35627,35566,35561,35558,35557) [ RunTime:0.000452s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category` [ RunTime:0.001258s ]
[ 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.000724s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category_lang` [ RunTime:0.001058s ]
[ SQL ] SELECT * FROM `hunuo_article_category_lang` WHERE `website_code` = 'en-us' 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.000954s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article` [ RunTime:0.001318s ]
[ 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.000770s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_lang` [ RunTime:0.001301s ]
[ 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` = 'en-us' AND `article_id` IN (39,40,41,42) [ RunTime:0.000629s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_album` [ RunTime:0.000922s ]
[ SQL ] SELECT * FROM `hunuo_article_album` WHERE `article_id` IN (39,40,41,42) ORDER BY `sort_order` ASC [ RunTime:0.000395s ]
