[ DB ] CONNECT:[ UseTime:0.000663s ] mysql:host=127.0.0.1;port=3306;dbname=tms0012;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `hunuo_web_config` [ RunTime:0.002662s ]
[ SQL ] SELECT * FROM `hunuo_web_config` WHERE `object_name` = 'website' LIMIT 1 [ RunTime:0.000590s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand` [ RunTime:0.002471s ]
[ SQL ] SELECT `id`,`is_open`,`is_recommend`,`thumb`,`search_keywords`,`sort_order`,`create_time`,`update_time`,`delete_time` FROM `hunuo_brand` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000568s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_brand_lang` [ RunTime:0.001951s ]
[ SQL ] SELECT * FROM `hunuo_brand_lang` WHERE `website_code` = 'spanish' AND `brand_id` = 5 [ RunTime:0.000633s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product` [ RunTime:0.002787s ]
[ SQL ] SELECT `product_id` FROM `hunuo_product` WHERE `is_open` = 1 AND `publish_time` <= 1787353624 AND `brand_id` = 5 LIMIT 18000 [ RunTime:0.009154s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hunuo_product` WHERE `is_open` = 1 AND `product_id` IN (25306,25318,25319,25334,25335,25336,25344,25345,25346,25748,25749,25750,25753,25754,25769,25770,25774,25775,25776,25777,25778,25779,25780,25781,25857,25858,25860,25862,25863,25900,25901,25902,25903,25904,25905,25906,25907,25908,25909,25945,25946,25947,25948,25949,25950,25951,25952,25953,25954,25955,25956,25957,25958,25959,25960,26012,26046,26047,26048,26050,26051,26052,26053,26054,26055,26056,26057,26058,26059,26060,26061,26062,26114,26115,26436,26480,26481,26482,26483,26484,26485,26486,26487,26488,26489,26506,26508,26512,26522,26523,26557,26558,26559,26560,26561,26562,26563,26564,26639,26658,26668,26695,26733,26734,26735,26736,26737,26738,26788,26806,26808,26812,26949,26984,26985,26986,26987,26988,26989,26990,26991,26992,26993,27025,27028,27040,27041,27042,27043,27142,27143,27236,27237,27238,27239,27240,27241,27242,27243,27244,27245,27246,27247,27248,27249,27250,27251,27252,27253,27254,27255,27303,27309,27314,27334,27339,27342,27343,27347,27348,27354,27565,27566,27567,27568,27569,27570,27571,27589,27590,27591,27592,27593,27594,27595,27596,27597,27598,27599,27693,27694,27695,27696,27697,27698,27700,27701,27702,27703,27704,27705,27706,27707,27737,27797,27807,27812,27872,27873,27889,27890,27891,27892,27893,27894,27923,27924,27938,27939,27957,27972,28021,28022,28023,28024,28025,28026,28027,28028,28029,28030,28031,28032,28033,28034,28035,28036,28037,28038,28039,28040,28041,28042,28043,28044,28045,28046,28047,28048,28049,28050,28051,28052,28053,28054,28055,28056,28057,28058,28059,28060,28061,28062,28063,28064,28179,29426,29442,29443,29456,29459,29463,29474,29475,29476,29478,29491,29506,29515,29523,29526,29536,29566,29569,29577,29578,29579,29580,29581,29582,29583,29584,29688,29689,29690,29724,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29736,29737,29764,29786,29787,29788,29789,29790,29791,29792,29793,29828,29829,29830,29831,29832,29833,29834,29835,29836,29852,29863,29895,29913,29974,29977,29979,29982,29984,29986,29993,29995,29997,29999,30006,30019,30030,30031,30032,30045,30047,30062,30067,30069,30088,30091,30092,30098,30108,30113,30120,30129,30130,30131,30132,30133,30485,30487,30511,30517,30519,30522,30528,30531,30533,30544,30546,30594,30595,30596,30620,30621,30622,30623,30624,30625,30626,30627,30637,30645,30646,30661,30667,30675,30682,30684,30689,30721,30729,30732,30747,30754,30755,30772,30780,30828,30829,30830,30831,30832,30862,30863,30864,30865,30891,30893,30895,30896,30897,30898,30899,30900,30901,30902,30956,30957,30958,30985,30986,30987,31018,31028,31036,31047,31051,31054,31055,31058,31059,31060,31061,31084,31096,31097,31098,31099,31161,31162,31220,31227,31228,31255,31261,31287,31320,31321,31331,31338,31366,31367,31370,31373,31553,31588,31589,31597,31629,31723,31724,31725,31726,31727,31728,31729,31730,31731,31732,31733,31734,31735,31736,31737,31738,31739,31740,31741,31742,31743,31778,31781,31796,31801,31807,31808,31813,31816,31817,31833,31834,32000,32043,32044) LIMIT 1 [ RunTime:0.004475s ]
[ 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 (25306,25318,25319,25334,25335,25336,25344,25345,25346,25748,25749,25750,25753,25754,25769,25770,25774,25775,25776,25777,25778,25779,25780,25781,25857,25858,25860,25862,25863,25900,25901,25902,25903,25904,25905,25906,25907,25908,25909,25945,25946,25947,25948,25949,25950,25951,25952,25953,25954,25955,25956,25957,25958,25959,25960,26012,26046,26047,26048,26050,26051,26052,26053,26054,26055,26056,26057,26058,26059,26060,26061,26062,26114,26115,26436,26480,26481,26482,26483,26484,26485,26486,26487,26488,26489,26506,26508,26512,26522,26523,26557,26558,26559,26560,26561,26562,26563,26564,26639,26658,26668,26695,26733,26734,26735,26736,26737,26738,26788,26806,26808,26812,26949,26984,26985,26986,26987,26988,26989,26990,26991,26992,26993,27025,27028,27040,27041,27042,27043,27142,27143,27236,27237,27238,27239,27240,27241,27242,27243,27244,27245,27246,27247,27248,27249,27250,27251,27252,27253,27254,27255,27303,27309,27314,27334,27339,27342,27343,27347,27348,27354,27565,27566,27567,27568,27569,27570,27571,27589,27590,27591,27592,27593,27594,27595,27596,27597,27598,27599,27693,27694,27695,27696,27697,27698,27700,27701,27702,27703,27704,27705,27706,27707,27737,27797,27807,27812,27872,27873,27889,27890,27891,27892,27893,27894,27923,27924,27938,27939,27957,27972,28021,28022,28023,28024,28025,28026,28027,28028,28029,28030,28031,28032,28033,28034,28035,28036,28037,28038,28039,28040,28041,28042,28043,28044,28045,28046,28047,28048,28049,28050,28051,28052,28053,28054,28055,28056,28057,28058,28059,28060,28061,28062,28063,28064,28179,29426,29442,29443,29456,29459,29463,29474,29475,29476,29478,29491,29506,29515,29523,29526,29536,29566,29569,29577,29578,29579,29580,29581,29582,29583,29584,29688,29689,29690,29724,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29736,29737,29764,29786,29787,29788,29789,29790,29791,29792,29793,29828,29829,29830,29831,29832,29833,29834,29835,29836,29852,29863,29895,29913,29974,29977,29979,29982,29984,29986,29993,29995,29997,29999,30006,30019,30030,30031,30032,30045,30047,30062,30067,30069,30088,30091,30092,30098,30108,30113,30120,30129,30130,30131,30132,30133,30485,30487,30511,30517,30519,30522,30528,30531,30533,30544,30546,30594,30595,30596,30620,30621,30622,30623,30624,30625,30626,30627,30637,30645,30646,30661,30667,30675,30682,30684,30689,30721,30729,30732,30747,30754,30755,30772,30780,30828,30829,30830,30831,30832,30862,30863,30864,30865,30891,30893,30895,30896,30897,30898,30899,30900,30901,30902,30956,30957,30958,30985,30986,30987,31018,31028,31036,31047,31051,31054,31055,31058,31059,31060,31061,31084,31096,31097,31098,31099,31161,31162,31220,31227,31228,31255,31261,31287,31320,31321,31331,31338,31366,31367,31370,31373,31553,31588,31589,31597,31629,31723,31724,31725,31726,31727,31728,31729,31730,31731,31732,31733,31734,31735,31736,31737,31738,31739,31740,31741,31742,31743,31778,31781,31796,31801,31807,31808,31813,31816,31817,31833,31834,32000,32043,32044) ORDER BY `sort_order` DESC,`product_id` DESC LIMIT 0,9 [ RunTime:0.003505s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_lang` [ RunTime:0.002755s ]
[ 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 (32044,32043,32000,31834,31833,31817,31816,31813,31808) [ RunTime:0.001107s ]
[ SQL ] SELECT `lang_id`,`brand_id`,`lang_value` FROM `hunuo_brand_lang` WHERE `website_code` = 'spanish' AND `brand_id` IN (5) [ RunTime:0.000596s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_price` [ RunTime:0.001944s ]
[ SQL ] SELECT * FROM `hunuo_product_price` WHERE `product_id` IN (32044,32043,32000,31834,31833,31817,31816,31813,31808) ORDER BY `num` ASC [ RunTime:0.000647s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_product_sub` [ RunTime:0.002005s ]
[ SQL ] SELECT `id`,`product_id`,`shop_price`,`product_number` FROM `hunuo_product_sub` WHERE `product_id` IN (32044,32043,32000,31834,31833,31817,31816,31813,31808) [ RunTime:0.000588s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category` [ RunTime:0.002496s ]
[ 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.000780s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_category_lang` [ RunTime:0.002004s ]
[ 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.001014s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article` [ RunTime:0.002450s ]
[ 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.000699s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_lang` [ RunTime:0.002400s ]
[ 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.000748s ]
[ SQL ] SHOW COLUMNS FROM `hunuo_article_album` [ RunTime:0.001812s ]
[ SQL ] SELECT * FROM `hunuo_article_album` WHERE `article_id` IN (39,40,41,42) ORDER BY `sort_order` ASC [ RunTime:0.000556s ]
