[ DB ] CONNECT:[ UseTime:0.000612s ] mysql:host=127.0.0.1;port=3306;dbname=tms0012;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `hunuo_web_config` [ RunTime:0.001386s ]
[ SQL ] SELECT * FROM `hunuo_web_config` WHERE `object_name` = 'website' LIMIT 1 [ RunTime:0.000639s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand` [ RunTime:0.002450s ]
[ SQL ] SELECT `id`,`is_open`,`is_recommend`,`thumb`,`search_keywords`,`sort_order`,`create_time`,`update_time`,`delete_time` FROM `hunuo_brand` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000509s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand_lang` [ RunTime:0.000980s ]
[ SQL ] SELECT * FROM `hunuo_brand_lang` WHERE `website_code` = 'en-us' AND `brand_id` = 1 [ RunTime:0.000603s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product` [ RunTime:0.001604s ]
[ SQL ] SELECT `product_id` FROM `hunuo_product` WHERE `is_open` = 1 AND `publish_time` <= 1793106124 AND `brand_id` = 1 LIMIT 18000 [ RunTime:0.010158s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hunuo_product` WHERE `is_open` = 1 AND `product_id` IN (27674,27675,27676,27677,27679,27680,27681,27682,27683,27684,27685,27686,27687,27688,27689,27690,27691,27692,27830,27842,27844,27846,27859,27885,27886,27887,27888,27936,27937,28065,28066,28067,28068,28069,28070,28071,28072,28073,28074,28075,28076,28077,28078,28175,28577,29431,29432,29433,29434,29435,29436,29437,29488,29490,29496,29497,29498,29504,29508,29511,29513,29518,29520,29530,29532,29561,29562,29563,29564,29565,29571,29597,29599,29600,29691,29692,29694,29714,29715,29717,29718,29719,29720,29721,29722,29723,29853,29854,30021,30074,30080,30093,30099,30101,30109,30117,30119,30121,30122,30123,30134,30138,30139,30603,30604,30605,30606,30607,30608,30671,30673,30674,30871,30872,30873,30874,30875,30876,30877,30924,30925,30926,30969,30970,31039,31066,31067,31068,31116,31118,31119,31120,31121,31159,31160,31172,31174,31175,31176,31177,31179,31180,31181,31196,31241,31245,31246,31248,31256,31270,31271,31272,31273,31286,31290,31336,31337,31574,31590,31591,31592,31654,31673,31675,31686,31691,31693,31744,31745,31746,31747,31748,31749,31750,31751,31752,31753,31780,31792,31795,31818,31819,31823,31836,31837,31841,31852,32014,32023,32034,32038,32040,32048,32059,32060,32061,32066,32067,32073,32089,32090,32091,32092,32093,32097,32098,32099,32105,32122,32123,32142,32183,32185,32199,32200,32201,32202,32228,32242,32243,32328,32329,32330,32331,32332,32333,32334,32335,32336,32337,32338,32339,32340,32341,32342,32343,32344,32345,32346,32347,32348,32349,32405,32406,32407,32408,32409,32410,32411,32412,32413,32414,32415,32416,32417,32418,32419,32420,32518,32521,32524,32525,32533,32536,32538,32549,32550,32551,32552,32579,32580,32635,32636,32637,32638,32639,32640,32683,32684,32685,32686,32687,32710,32711,32716,32717,32718,32749,32787,32788,32789,32790,32791,32792,32793,32821,32823,34565,34566,34602,34603,34604,34605,34606,34607,34608,34609,34610,34712,34713,34714,34715,34716,34717,34718,34719,34720,34745,34746,34764,34765,34766,34767,34768,34769,34770,34893,34904,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,34956,34957,34958,34959,35007,35011,35012,35016,35023,35024,35025,35028,35029,35030,35031,35034,35035,35036,35071,35079,35080,35081,35112,35150,35182,35192,35279,35288,35289,35295,35296,35297,35313,35314,35315,35316,35317,35318,35319,35320,35377,35378,35379,35381,35383,35385,35387,35389,35391,35393,35429,35431,35433,35435,35438,35442,35444,35450,35452,35457,35463,35465,35467,35469,35489,35491,35523,35527,35530,35533,35536,35538,35540,35554,35585,35587,35593,35596,35603,35605,35610,35733,35735,35737,35739,35786,35787,35788,35789,35790,35791,35792,35793,35800,35817,35826,35864,35865,35866,35867,35868,35869,35870,35871,35872,35873,35874,35875,35876) LIMIT 1 [ RunTime:0.003738s ]
[ 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 (27674,27675,27676,27677,27679,27680,27681,27682,27683,27684,27685,27686,27687,27688,27689,27690,27691,27692,27830,27842,27844,27846,27859,27885,27886,27887,27888,27936,27937,28065,28066,28067,28068,28069,28070,28071,28072,28073,28074,28075,28076,28077,28078,28175,28577,29431,29432,29433,29434,29435,29436,29437,29488,29490,29496,29497,29498,29504,29508,29511,29513,29518,29520,29530,29532,29561,29562,29563,29564,29565,29571,29597,29599,29600,29691,29692,29694,29714,29715,29717,29718,29719,29720,29721,29722,29723,29853,29854,30021,30074,30080,30093,30099,30101,30109,30117,30119,30121,30122,30123,30134,30138,30139,30603,30604,30605,30606,30607,30608,30671,30673,30674,30871,30872,30873,30874,30875,30876,30877,30924,30925,30926,30969,30970,31039,31066,31067,31068,31116,31118,31119,31120,31121,31159,31160,31172,31174,31175,31176,31177,31179,31180,31181,31196,31241,31245,31246,31248,31256,31270,31271,31272,31273,31286,31290,31336,31337,31574,31590,31591,31592,31654,31673,31675,31686,31691,31693,31744,31745,31746,31747,31748,31749,31750,31751,31752,31753,31780,31792,31795,31818,31819,31823,31836,31837,31841,31852,32014,32023,32034,32038,32040,32048,32059,32060,32061,32066,32067,32073,32089,32090,32091,32092,32093,32097,32098,32099,32105,32122,32123,32142,32183,32185,32199,32200,32201,32202,32228,32242,32243,32328,32329,32330,32331,32332,32333,32334,32335,32336,32337,32338,32339,32340,32341,32342,32343,32344,32345,32346,32347,32348,32349,32405,32406,32407,32408,32409,32410,32411,32412,32413,32414,32415,32416,32417,32418,32419,32420,32518,32521,32524,32525,32533,32536,32538,32549,32550,32551,32552,32579,32580,32635,32636,32637,32638,32639,32640,32683,32684,32685,32686,32687,32710,32711,32716,32717,32718,32749,32787,32788,32789,32790,32791,32792,32793,32821,32823,34565,34566,34602,34603,34604,34605,34606,34607,34608,34609,34610,34712,34713,34714,34715,34716,34717,34718,34719,34720,34745,34746,34764,34765,34766,34767,34768,34769,34770,34893,34904,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,34956,34957,34958,34959,35007,35011,35012,35016,35023,35024,35025,35028,35029,35030,35031,35034,35035,35036,35071,35079,35080,35081,35112,35150,35182,35192,35279,35288,35289,35295,35296,35297,35313,35314,35315,35316,35317,35318,35319,35320,35377,35378,35379,35381,35383,35385,35387,35389,35391,35393,35429,35431,35433,35435,35438,35442,35444,35450,35452,35457,35463,35465,35467,35469,35489,35491,35523,35527,35530,35533,35536,35538,35540,35554,35585,35587,35593,35596,35603,35605,35610,35733,35735,35737,35739,35786,35787,35788,35789,35790,35791,35792,35793,35800,35817,35826,35864,35865,35866,35867,35868,35869,35870,35871,35872,35873,35874,35875,35876) ORDER BY `sort_order` DESC,`product_id` DESC LIMIT 0,9 [ RunTime:0.002109s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_lang` [ RunTime:0.001502s ]
[ 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 (35876,35875,35874,35873,35872,35871,35870,35869,35868) [ RunTime:0.001678s ]
[ SQL ] SELECT `lang_id`,`brand_id`,`lang_value` FROM `hunuo_brand_lang` WHERE `website_code` = 'en-us' AND `brand_id` IN (1) [ RunTime:0.000536s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_price` [ RunTime:0.001928s ]
[ SQL ] SELECT * FROM `hunuo_product_price` WHERE `product_id` IN (35876,35875,35874,35873,35872,35871,35870,35869,35868) ORDER BY `num` ASC [ RunTime:0.000595s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_sub` [ RunTime:0.002008s ]
[ SQL ] SELECT `id`,`product_id`,`shop_price`,`product_number` FROM `hunuo_product_sub` WHERE `product_id` IN (35876,35875,35874,35873,35872,35871,35870,35869,35868) [ RunTime:0.000466s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category` [ RunTime:0.002644s ]
[ 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.000838s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category_lang` [ RunTime:0.002073s ]
[ 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.001026s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article` [ RunTime:0.002662s ]
[ 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.002125s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_lang` [ RunTime:0.002885s ]
[ 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.001281s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_album` [ RunTime:0.002115s ]
[ SQL ] SELECT * FROM `hunuo_article_album` WHERE `article_id` IN (39,40,41,42) ORDER BY `sort_order` ASC [ RunTime:0.000965s ]
