[ DB ] CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;port=3306;dbname=tms0012;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `hunuo_web_config` [ RunTime:0.001491s ]
[ SQL ] SELECT * FROM `hunuo_web_config` WHERE `object_name` = 'website' LIMIT 1 [ RunTime:0.000562s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand` [ RunTime:0.001189s ]
[ SQL ] SELECT `id`,`is_open`,`is_recommend`,`thumb`,`search_keywords`,`sort_order`,`create_time`,`update_time`,`delete_time` FROM `hunuo_brand` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000661s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand_lang` [ RunTime:0.001115s ]
[ SQL ] SELECT * FROM `hunuo_brand_lang` WHERE `website_code` = 'en-us' AND `brand_id` = 21 [ RunTime:0.000562s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product` [ RunTime:0.001532s ]
[ SQL ] SELECT `product_id` FROM `hunuo_product` WHERE `is_open` = 1 AND `publish_time` <= 1793106132 AND `brand_id` = 21 LIMIT 18000 [ RunTime:0.006560s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hunuo_product` WHERE `is_open` = 1 AND `product_id` IN (27729,27730,27731,27732,27733,27734,27735,27736,27738,27739,27740,27741,27742,27743,27744,27745,27746,27897,27925,27927,27928,27942,27943,27944,27945,27946,27947,27951,28110,28111,28112,28113,28114,28115,28116,28117,28118,28119,28120,28121,28122,28123,28124,28125,28126,28165,28166,28167,28168,28169,28170,28171,28172,28173,28174,28176,28579,29438,29441,29457,29458,29464,29468,29470,29473,29479,29482,29489,29500,29502,29505,29521,29528,29529,29531,29555,29556,29557,29558,29559,29560,29573,29574,29575,29576,29598,29693,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29711,29712,29713,29839,29840,29841,29842,29843,29844,29845,29846,29850,29851,30018,30022,30046,30060,30070,30094,30095,30096,30102,30103,30104,30105,30106,30110,30118,30127,30128,30135,30597,30600,30609,30610,30611,30612,30613,30614,30615,30616,30617,30618,30619,30641,30651,30662,30663,30664,30665,30672,30870,30892,30912,30913,30914,30915,30916,30917,30918,30919,30920,30921,30922,30923,30944,30945,30946,30947,30948,30949,30950,30951,30952,30953,30971,30972,30973,30974,30975,30976,30977,30978,30979,30980,30981,31034,31038,31045,31064,31065,31080,31081,31107,31108,31109,31110,31111,31112,31113,31114,31115,31142,31143,31144,31145,31146,31147,31182,31183,31194,31202,31203,31204,31209,31218,31223,31224,31225,31238,31265,31266,31267,31268,31269,31281,31282,31295,31298,31299,31300,31301,31302,31313,31322,31323,31332,31333,31340,31341,31353,31354,31355,31356,31362,31363,31364,31365,31371,31375,31376,31377,31378,31552,31584,31585,31586,31587,31705,31706,31707,31708,31709,31710,31711,31712,31713,31714,31715,31716,31717,31718,31719,31720,31721,31722,31777,31803,31804,31805,31806,31809,31810,31829,31830,31831,31832,31850,31963,31977,31982,32004,32005,32006,32013,32082,32083,32084,32085,32086,32103,32104,32106,32108,32114,32146,32147,32160,32161,32162,32163,32164,32165,32166,32167,32168,32169,32170,32229,32230,32233,32249,32254,32350,32351,32352,32353,32354,32355,32356,32421,32422,32423,32424,32425,32426,32427,32428,32429,32430,32431,32432,32433,32434,32435,32436,32437,32438,32439,32440,32441,32442,32443,32444,32445,32446,32447,32448,32449,32522,32529,32530,32531,32534,32554,32555,32570,32572,32597,32598,32599,32600,32601,32602,32603,32604,32605,32606,32607,32608,32609,32610,32611,32612,32613,32644,32645,32646,32647,32648,32649,32650,32651,32709,32722,32728,32729,32742,32794,32795,32796,32797,32798,32799,32800,32801,32802,34550,34551,34552,34568,34569,34570,34571,34572,34573,34574,34575,34576,34577,34578,34579,34580,34581,34640,34649,34650,34665,34666,34667,34668,34669,34670,34671,34723,34725,34726,34727,34728,34732,34736,34738,34739,34742,34743,34744,34754,34755,34782,34783,34784,34785,34786,34787,34788,34789,34790,34791,34792,34793,34794,34795,34796,34797,34798,34856,34857,34858,34861,34862,34863,34864,34865,34866,34867,34868,34869,34870,34871,34873,34874,34883,34884,34885,34886,34887,34932,34933,34934,34935,34936,34937,34938,34939,34940,34941,34999,35010,35032,35043,35044,35045,35048,35049,35050,35051,35052,35053,35064,35065,35066,35067,35073,35075,35076,35077,35300,35301,35302,35303,35335,35336,35337,35338,35339,35340,35341,35342,35343,35344,35345,35406,35408,35409,35411,35504,35505,35506,35507,35550,35559,35560,35563,35626,35727,35772,35773,35774,35775,35776,35780,35797,35809,35839,35840,35841,35842,35843,35844,35845,35846,35847,35848,35849) LIMIT 1 [ RunTime:0.004230s ]
[ 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 (27729,27730,27731,27732,27733,27734,27735,27736,27738,27739,27740,27741,27742,27743,27744,27745,27746,27897,27925,27927,27928,27942,27943,27944,27945,27946,27947,27951,28110,28111,28112,28113,28114,28115,28116,28117,28118,28119,28120,28121,28122,28123,28124,28125,28126,28165,28166,28167,28168,28169,28170,28171,28172,28173,28174,28176,28579,29438,29441,29457,29458,29464,29468,29470,29473,29479,29482,29489,29500,29502,29505,29521,29528,29529,29531,29555,29556,29557,29558,29559,29560,29573,29574,29575,29576,29598,29693,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29711,29712,29713,29839,29840,29841,29842,29843,29844,29845,29846,29850,29851,30018,30022,30046,30060,30070,30094,30095,30096,30102,30103,30104,30105,30106,30110,30118,30127,30128,30135,30597,30600,30609,30610,30611,30612,30613,30614,30615,30616,30617,30618,30619,30641,30651,30662,30663,30664,30665,30672,30870,30892,30912,30913,30914,30915,30916,30917,30918,30919,30920,30921,30922,30923,30944,30945,30946,30947,30948,30949,30950,30951,30952,30953,30971,30972,30973,30974,30975,30976,30977,30978,30979,30980,30981,31034,31038,31045,31064,31065,31080,31081,31107,31108,31109,31110,31111,31112,31113,31114,31115,31142,31143,31144,31145,31146,31147,31182,31183,31194,31202,31203,31204,31209,31218,31223,31224,31225,31238,31265,31266,31267,31268,31269,31281,31282,31295,31298,31299,31300,31301,31302,31313,31322,31323,31332,31333,31340,31341,31353,31354,31355,31356,31362,31363,31364,31365,31371,31375,31376,31377,31378,31552,31584,31585,31586,31587,31705,31706,31707,31708,31709,31710,31711,31712,31713,31714,31715,31716,31717,31718,31719,31720,31721,31722,31777,31803,31804,31805,31806,31809,31810,31829,31830,31831,31832,31850,31963,31977,31982,32004,32005,32006,32013,32082,32083,32084,32085,32086,32103,32104,32106,32108,32114,32146,32147,32160,32161,32162,32163,32164,32165,32166,32167,32168,32169,32170,32229,32230,32233,32249,32254,32350,32351,32352,32353,32354,32355,32356,32421,32422,32423,32424,32425,32426,32427,32428,32429,32430,32431,32432,32433,32434,32435,32436,32437,32438,32439,32440,32441,32442,32443,32444,32445,32446,32447,32448,32449,32522,32529,32530,32531,32534,32554,32555,32570,32572,32597,32598,32599,32600,32601,32602,32603,32604,32605,32606,32607,32608,32609,32610,32611,32612,32613,32644,32645,32646,32647,32648,32649,32650,32651,32709,32722,32728,32729,32742,32794,32795,32796,32797,32798,32799,32800,32801,32802,34550,34551,34552,34568,34569,34570,34571,34572,34573,34574,34575,34576,34577,34578,34579,34580,34581,34640,34649,34650,34665,34666,34667,34668,34669,34670,34671,34723,34725,34726,34727,34728,34732,34736,34738,34739,34742,34743,34744,34754,34755,34782,34783,34784,34785,34786,34787,34788,34789,34790,34791,34792,34793,34794,34795,34796,34797,34798,34856,34857,34858,34861,34862,34863,34864,34865,34866,34867,34868,34869,34870,34871,34873,34874,34883,34884,34885,34886,34887,34932,34933,34934,34935,34936,34937,34938,34939,34940,34941,34999,35010,35032,35043,35044,35045,35048,35049,35050,35051,35052,35053,35064,35065,35066,35067,35073,35075,35076,35077,35300,35301,35302,35303,35335,35336,35337,35338,35339,35340,35341,35342,35343,35344,35345,35406,35408,35409,35411,35504,35505,35506,35507,35550,35559,35560,35563,35626,35727,35772,35773,35774,35775,35776,35780,35797,35809,35839,35840,35841,35842,35843,35844,35845,35846,35847,35848,35849) ORDER BY `sort_order` DESC,`product_id` DESC LIMIT 0,9 [ RunTime:0.002938s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_lang` [ RunTime:0.001682s ]
[ 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 (35849,35848,35847,35846,35845,35844,35843,35842,35841) [ RunTime:0.001035s ]
[ SQL ] SELECT `lang_id`,`brand_id`,`lang_value` FROM `hunuo_brand_lang` WHERE `website_code` = 'en-us' AND `brand_id` IN (21) [ RunTime:0.000562s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_price` [ RunTime:0.000965s ]
[ SQL ] SELECT * FROM `hunuo_product_price` WHERE `product_id` IN (35849,35848,35847,35846,35845,35844,35843,35842,35841) ORDER BY `num` ASC [ RunTime:0.000586s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_sub` [ RunTime:0.000972s ]
[ SQL ] SELECT `id`,`product_id`,`shop_price`,`product_number` FROM `hunuo_product_sub` WHERE `product_id` IN (35849,35848,35847,35846,35845,35844,35843,35842,35841) [ RunTime:0.000455s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category` [ RunTime:0.001051s ]
[ 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.000752s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category_lang` [ RunTime:0.001031s ]
[ 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.000871s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article` [ RunTime:0.001300s ]
[ 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.000617s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_lang` [ RunTime:0.001322s ]
[ 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.000632s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_album` [ RunTime:0.000911s ]
[ SQL ] SELECT * FROM `hunuo_article_album` WHERE `article_id` IN (39,40,41,42) ORDER BY `sort_order` ASC [ RunTime:0.000413s ]
