[ DB ] CONNECT:[ UseTime:0.000747s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_yunhui_online2;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.001411s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `is_show` = 1 ORDER BY sort_order desc [ RunTime:0.010314s ]
[ SQL ] SHOW COLUMNS FROM `tp_seller` [ RunTime:0.001327s ]
[ SQL ] SELECT * FROM `tp_seller` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000489s ]
[ SQL ] SHOW COLUMNS FROM `tp_business_manager` [ RunTime:0.000587s ]
[ SQL ] SELECT * FROM `tp_business_manager` WHERE `manager_id` IS NULL LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SHOW COLUMNS FROM `tp_currency` [ RunTime:0.000540s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `lang_code` = 'zh' LIMIT 1 [ RunTime:0.000428s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `is_show` = 1 [ RunTime:0.000490s ]
[ SQL ] SHOW COLUMNS FROM `tp_search_word` [ RunTime:0.000755s ]
[ SQL ] UPDATE `tp_search_word` SET `search_num`=`search_num`+1 WHERE `keywords` = '' [ RunTime:0.005572s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000955s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_goods` WHERE ( (`goods_name` LIKE '%%') OR (`keywords` LIKE '%%') ) AND `is_on_sale` = 1 AND `goods_state` = 1 LIMIT 1 [ RunTime:0.010945s ]
[ SQL ] SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000404s ]
[ SQL ] UPDATE `tp_search_word` SET `goods_num`=8506 WHERE `id` = 1 [ RunTime:0.005038s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` = 652 LIMIT 1 [ RunTime:0.000453s ]
[ SQL ] SELECT `goods_id`,`cat_id3`,`goods_name_zh`,`goods_content_zh` FROM `tp_goods` WHERE ( (`goods_name` LIKE '%%') OR (`keywords` LIKE '%%') ) AND `is_on_sale` = 1 AND `goods_state` = 1 AND `cat_id1` = 652 [ RunTime:0.015056s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` IN (12348,841,842,31389,39457,35808,869,840,21651,22236,10971,31012,831,36671,835,12347,5012,30915,12349,1203,12344,12342,834,12355,30703,30916) [ RunTime:0.001056s ]
[ SQL ] SELECT `shop_price` FROM `tp_goods` WHERE ( is_on_sale = 1 and goods_id in (84,176,277,282,518,1586,2026,2344,2865,2932,2934,3037,3127,3150,3172,3242,3248,3321,3387,3437,3837,3903,3995,4172,4173,4186,4224,4235,4239,4286,4288,4298,4319,4320,4333,4342,4345,4350,4356,4385,4398,4400,4434,4437,4439,4455,4514,4522,4525,4527,4530,4544,4546,4553,4560,4592,4596,4597,4618,4622,4628,4635,4638,4644,4678,4708,4710,4723,4729,4736,4753,4758,4769,4786,4788,4807,4808,4812,4818,4830,4851,4855,4857,4861,4871,4875,4897,4902,4907,4920,4937,4945,4986,5009,5028,5034,5047,5050,5058,5092,5099,5108,5126,5128,5139,5154,5160,5161,5166,5169,5172,5191,5197,5219,5225,5226,5236,5240,5243,5249,5255,5263,5265,5269,5271,5278,5297,5323,5331,5335,5340,5344,5346,5351,5366,5385,5387,5390,5396,5398,5407,5416,5433,5450,5457,5467,5471,5475,5494,5498,5500,5501,5504,5514,5524,5529,5537,5539,5552,5557,5561,5571,5585,5591,5594,5595,5596,5599,5611,5629,5633,5643,5648,5657,5662,5665,5666,5667,5669,5688,5694,5699,5701,5702,5706,5714,5732,5741,5763,5790,5791,5807,5812,5816,5826,5852,5853,5858,5884,5892,5899,5931,5934,5939,5952,5966,5997,6007,6012,6013,6018,6033,6034,6041,6050,6063,6099,6104,6105,6108,6109,6113,6131,6133,6136,6141,6159,6178,6180,6183,6191,6193,6201,6233,6243,6258,6266,6307,6345,6348,6354,6357,6358,6383,6402,6450,6510,6539,6544,6555,6560,6564,6567,6571,6611,6624,6633,6641,6660,6693,6712,6721,6727,6766,6776,6778,6810,7639,7689,7691,8019,8033,8076,8092,8104,8121,8122,8179,8185,8189,8213,8239,8263,8332,8340,8345,8360,8374,8376,8387,8401,8414,8433,8516,8520,8642,8662,8749,8789,8835,8976,8983,8988,8990,9025,9030,9031,9034,9039,9040,9043,9047,9049,9051,9055,9057,9060,9064,9069,9079,9081,9089,9093,9110,9119,9121,9125,9147,9166,9181,9204,9213,9220,9246,9252,9254,9262,9263,9267,9281,9305,9314,9359,9363,9400,9408,9412,9418,9442,9456,9462,9471,9476,9482,9484,9486,9492,9500,9503,9511,9517,9535,9555) ) [ RunTime:0.001997s ]
[ SQL ] SELECT `cat_id1` FROM `tp_goods` WHERE ( is_on_sale = 1 ) AND `goods_id` IN (84,176,277,282,518,1586,2026,2344,2865,2932,2934,3037,3127,3150,3172,3242,3248,3321,3387,3437,3837,3903,3995,4172,4173,4186,4224,4235,4239,4286,4288,4298,4319,4320,4333,4342,4345,4350,4356,4385,4398,4400,4434,4437,4439,4455,4514,4522,4525,4527,4530,4544,4546,4553,4560,4592,4596,4597,4618,4622,4628,4635,4638,4644,4678,4708,4710,4723,4729,4736,4753,4758,4769,4786,4788,4807,4808,4812,4818,4830,4851,4855,4857,4861,4871,4875,4897,4902,4907,4920,4937,4945,4986,5009,5028,5034,5047,5050,5058,5092,5099,5108,5126,5128,5139,5154,5160,5161,5166,5169,5172,5191,5197,5219,5225,5226,5236,5240,5243,5249,5255,5263,5265,5269,5271,5278,5297,5323,5331,5335,5340,5344,5346,5351,5366,5385,5387,5390,5396,5398,5407,5416,5433,5450,5457,5467,5471,5475,5494,5498,5500,5501,5504,5514,5524,5529,5537,5539,5552,5557,5561,5571,5585,5591,5594,5595,5596,5599,5611,5629,5633,5643,5648,5657,5662,5665,5666,5667,5669,5688,5694,5699,5701,5702,5706,5714,5732,5741,5763,5790,5791,5807,5812,5816,5826,5852,5853,5858,5884,5892,5899,5931,5934,5939,5952,5966,5997,6007,6012,6013,6018,6033,6034,6041,6050,6063,6099,6104,6105,6108,6109,6113,6131,6133,6136,6141,6159,6178,6180,6183,6191,6193,6201,6233,6243,6258,6266,6307,6345,6348,6354,6357,6358,6383,6402,6450,6510,6539,6544,6555,6560,6564,6567,6571,6611,6624,6633,6641,6660,6693,6712,6721,6727,6766,6776,6778,6810,7639,7689,7691,8019,8033,8076,8092,8104,8121,8122,8179,8185,8189,8213,8239,8263,8332,8340,8345,8360,8374,8376,8387,8401,8414,8433,8516,8520,8642,8662,8749,8789,8835,8976,8983,8988,8990,9025,9030,9031,9034,9039,9040,9043,9047,9049,9051,9055,9057,9060,9064,9069,9079,9081,9089,9093,9110,9119,9121,9125,9147,9166,9181,9204,9213,9220,9246,9252,9254,9262,9263,9267,9281,9305,9314,9359,9363,9400,9408,9412,9418,9442,9456,9462,9471,9476,9482,9484,9486,9492,9500,9503,9511,9517,9535,9555) [ RunTime:0.002669s ]
[ SQL ] SHOW COLUMNS FROM `tp_brand` [ RunTime:0.001047s ]
[ SQL ] SELECT * FROM `tp_brand` WHERE `cat_id1` IN (652) AND `status` = 0 ORDER BY sort asc [ RunTime:0.001240s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (84,176,277,282,518,1586,2026,2344,2865,2932,2934,3037,3127,3150,3172,3242,3248,3321,3387,3437,3837,3903,3995,4172,4173,4186,4224,4235,4239,4286,4288,4298,4319,4320,4333,4342,4345,4350,4356,4385,4398,4400,4434,4437,4439,4455,4514,4522,4525,4527,4530,4544,4546,4553,4560,4592,4596,4597,4618,4622,4628,4635,4638,4644,4678,4708,4710,4723,4729,4736,4753,4758,4769,4786,4788,4807,4808,4812,4818,4830,4851,4855,4857,4861,4871,4875,4897,4902,4907,4920,4937,4945,4986,5009,5028,5034,5047,5050,5058,5092,5099,5108,5126,5128,5139,5154,5160,5161,5166,5169,5172,5191,5197,5219,5225,5226,5236,5240,5243,5249,5255,5263,5265,5269,5271,5278,5297,5323,5331,5335,5340,5344,5346,5351,5366,5385,5387,5390,5396,5398,5407,5416,5433,5450,5457,5467,5471,5475,5494,5498,5500,5501,5504,5514,5524,5529,5537,5539,5552,5557,5561,5571,5585,5591,5594,5595,5596,5599,5611,5629,5633,5643,5648,5657,5662,5665,5666,5667,5669,5688,5694,5699,5701,5702,5706,5714,5732,5741,5763,5790,5791,5807,5812,5816,5826,5852,5853,5858,5884,5892,5899,5931,5934,5939,5952,5966,5997,6007,6012,6013,6018,6033,6034,6041,6050,6063,6099,6104,6105,6108,6109,6113,6131,6133,6136,6141,6159,6178,6180,6183,6191,6193,6201,6233,6243,6258,6266,6307,6345,6348,6354,6357,6358,6383,6402,6450,6510,6539,6544,6555,6560,6564,6567,6571,6611,6624,6633,6641,6660,6693,6712,6721,6727,6766,6776,6778,6810,7639,7689,7691,8019,8033,8076,8092,8104,8121,8122,8179,8185,8189,8213,8239,8263,8332,8340,8345,8360,8374,8376,8387,8401,8414,8433,8516,8520,8642,8662,8749,8789,8835,8976,8983,8988,8990,9025,9030,9031,9034,9039,9040,9043,9047,9049,9051,9055,9057,9060,9064,9069,9079,9081,9089,9093,9110,9119,9121,9125,9147,9166,9181,9204,9213,9220,9246,9252,9254,9262,9263,9267,9281,9305,9314,9359,9363,9400,9408,9412,9418,9442,9456,9462,9471,9476,9482,9484,9486,9492,9500,9503,9511,9517,9535,9555) ORDER BY `sort` desc LIMIT 0,20 [ RunTime:0.005372s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_images` [ RunTime:0.000851s ]
[ SQL ] SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (5633,6402,4356,5892,6660,9220,9476,518,5126,4871,5128,5385,7689,4618,9482,4875,5387,5643,5899,7691) [ RunTime:0.001158s ]
[ SQL ] SHOW COLUMNS FROM `tp_menu_goods_field` [ RunTime:0.000595s ]
[ SQL ] SELECT * FROM `tp_menu_goods_field` [ RunTime:0.000314s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 6144 limit 2 [ RunTime:0.000595s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 9987 limit 2 [ RunTime:0.000648s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 37893 limit 2 [ RunTime:0.000575s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 35338 limit 2 [ RunTime:0.000548s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 15901 limit 2 [ RunTime:0.000566s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 1315 limit 2 [ RunTime:0.000673s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 1316 limit 2 [ RunTime:0.000649s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 1318 limit 2 [ RunTime:0.000851s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 1319 limit 2 [ RunTime:0.000726s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 6196 limit 2 [ RunTime:0.000810s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 43575 limit 2 [ RunTime:0.000600s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 6728 limit 2 [ RunTime:0.000707s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 6994 limit 2 [ RunTime:0.000635s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 1620 limit 2 [ RunTime:0.000621s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 37462 limit 2 [ RunTime:0.000798s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 6233 limit 2 [ RunTime:0.000787s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 16750 limit 2 [ RunTime:0.000646s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 34675 limit 2 [ RunTime:0.000770s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 27508 limit 2 [ RunTime:0.000847s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 9847 limit 2 [ RunTime:0.000764s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 9855 limit 2 [ RunTime:0.000781s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 652 limit 2 [ RunTime:0.000639s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 670 limit 2 [ RunTime:0.000756s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 5025 limit 2 [ RunTime:0.000671s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 1713 limit 2 [ RunTime:0.000767s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 17329 limit 2 [ RunTime:0.000810s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 34767 limit 2 [ RunTime:0.000672s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 11729 limit 2 [ RunTime:0.000602s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 35025 limit 2 [ RunTime:0.000716s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 36320 limit 2 [ RunTime:0.000648s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 737 limit 2 [ RunTime:0.000540s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 9192 limit 2 [ RunTime:0.000478s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748571757 and end_time > 1748571757 and status = 1 and cat_id1 = 14065 limit 2 [ RunTime:0.000515s ]
[ SQL ] SHOW COLUMNS FROM `tp_config` [ RunTime:0.000504s ]
[ SQL ] SELECT `name`,`value` FROM `tp_config` WHERE `name` IN ('oss_key_id','oss_key_secret','oss_endpoint','oss_bucket') [ RunTime:0.000376s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000465s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000261s ]
[ SQL ] SELECT * FROM `tp_navigation` where is_show = 1 AND position = 2 ORDER BY `sort` DESC [ RunTime:0.000322s ]
