[ DB ] CONNECT:[ UseTime:0.000575s ] mysql:host=127.0.0.1;port=3306;dbname=tms0012;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `hunuo_web_config` [ RunTime:0.002258s ]
[ SQL ] SELECT * FROM `hunuo_web_config` WHERE `object_name` = 'website' LIMIT 1 [ RunTime:0.000470s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand` [ RunTime:0.002318s ]
[ 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.000466s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand_lang` [ RunTime:0.001700s ]
[ SQL ] SELECT * FROM `hunuo_brand_lang` WHERE `website_code` = 'spanish' AND `brand_id` = 13 [ RunTime:0.000474s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product` [ RunTime:0.002597s ]
[ SQL ] SELECT `product_id` FROM `hunuo_product` WHERE `is_open` = 1 AND `publish_time` <= 1787353460 AND `brand_id` = 13 LIMIT 18000 [ RunTime:0.009116s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hunuo_product` WHERE `is_open` = 1 AND `product_id` IN (25325,25326,25772,25831,25832,25833,25834,25835,25836,25870,25871,25874,25896,25897,25898,25899,25936,25937,25938,25939,25940,25941,25942,25943,25944,26008,26013,26014,26016,26018,26019,26023,26024,26025,26036,26037,26038,26039,26094,26095,26096,26097,26098,26116,26428,26429,26430,26431,26432,26464,26465,26466,26467,26468,26469,26500,26501,26502,26503,26504,26505,26507,26513,26514,26518,26529,26530,26549,26550,26551,26552,26553,26554,26555,26556,26626,26629,26630,26631,26632,26633,26634,26635,26654,26655,26656,26667,26681,26682,26683,26709,26710,26711,26719,26739,26742,26743,26744,26745,26746,26747,26748,26749,26946,26947,26948,26982,26983,27012,27037,27038,27102,27103,27104,27105,27106,27107,27108,27109,27110,27111,27112,27173,27174,27175,27176,27177,27178,27179,27180,27181,27182,27183,27184,27185,27186,27187,27188,27189,27190,27305,27318,27327,27344,27345,27346,27580,27636,27637,27638,27639,27640,27641,27642,27643,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,29762,29763,29773,29816,30023,30024,30025,30027,30028,30029,30097,30100,30107,30111,30124,30125,30126,30140,30143,30523,30524,30527,30532,30593,30630,30631,30632,30633,30657,30781,30833,30857,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) LIMIT 1 [ RunTime:0.003244s ]
[ 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 (25325,25326,25772,25831,25832,25833,25834,25835,25836,25870,25871,25874,25896,25897,25898,25899,25936,25937,25938,25939,25940,25941,25942,25943,25944,26008,26013,26014,26016,26018,26019,26023,26024,26025,26036,26037,26038,26039,26094,26095,26096,26097,26098,26116,26428,26429,26430,26431,26432,26464,26465,26466,26467,26468,26469,26500,26501,26502,26503,26504,26505,26507,26513,26514,26518,26529,26530,26549,26550,26551,26552,26553,26554,26555,26556,26626,26629,26630,26631,26632,26633,26634,26635,26654,26655,26656,26667,26681,26682,26683,26709,26710,26711,26719,26739,26742,26743,26744,26745,26746,26747,26748,26749,26946,26947,26948,26982,26983,27012,27037,27038,27102,27103,27104,27105,27106,27107,27108,27109,27110,27111,27112,27173,27174,27175,27176,27177,27178,27179,27180,27181,27182,27183,27184,27185,27186,27187,27188,27189,27190,27305,27318,27327,27344,27345,27346,27580,27636,27637,27638,27639,27640,27641,27642,27643,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,29762,29763,29773,29816,30023,30024,30025,30027,30028,30029,30097,30100,30107,30111,30124,30125,30126,30140,30143,30523,30524,30527,30532,30593,30630,30631,30632,30633,30657,30781,30833,30857,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) ORDER BY `sort_order` DESC,`product_id` DESC LIMIT 0,9 [ RunTime:0.002456s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_lang` [ RunTime:0.002533s ]
[ 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 (28580,32065,32064,32010,31844,31843,31842,31820,31791) [ RunTime:0.001012s ]
[ SQL ] SELECT `lang_id`,`brand_id`,`lang_value` FROM `hunuo_brand_lang` WHERE `website_code` = 'spanish' AND `brand_id` IN (13) [ RunTime:0.000469s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_price` [ RunTime:0.001717s ]
[ SQL ] SELECT * FROM `hunuo_product_price` WHERE `product_id` IN (28580,32065,32064,32010,31844,31843,31842,31820,31791) ORDER BY `num` ASC [ RunTime:0.000497s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_sub` [ RunTime:0.001766s ]
[ SQL ] SELECT `id`,`product_id`,`shop_price`,`product_number` FROM `hunuo_product_sub` WHERE `product_id` IN (28580,32065,32064,32010,31844,31843,31842,31820,31791) [ RunTime:0.000443s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category` [ RunTime:0.001961s ]
[ 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.000604s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category_lang` [ RunTime:0.001727s ]
[ 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.000890s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article` [ RunTime:0.002096s ]
[ 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.000554s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_lang` [ RunTime:0.002187s ]
[ 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.000592s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_album` [ RunTime:0.001763s ]
[ SQL ] SELECT * FROM `hunuo_article_album` WHERE `article_id` IN (39,40,41,42) ORDER BY `sort_order` ASC [ RunTime:0.000448s ]
