[ DB ] CONNECT:[ UseTime:0.000400s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_yunhui_online2;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.000654s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `is_show` = 1 ORDER BY sort_order desc [ RunTime:0.006154s ]
[ SQL ] SHOW COLUMNS FROM `tp_seller` [ RunTime:0.000996s ]
[ SQL ] SELECT * FROM `tp_seller` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000462s ]
[ SQL ] SHOW COLUMNS FROM `tp_business_manager` [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `tp_business_manager` WHERE `manager_id` IS NULL LIMIT 1 [ RunTime:0.000323s ]
[ SQL ] SHOW COLUMNS FROM `tp_currency` [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `lang_code` = 'zh' LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `is_show` = 1 [ RunTime:0.000340s ]
[ SQL ] SHOW COLUMNS FROM `tp_search_word` [ RunTime:0.000611s ]
[ SQL ] UPDATE `tp_search_word` SET `search_num`=`search_num`+1 WHERE `keywords` = '' [ RunTime:0.004912s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.001047s ]
[ 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.010731s ]
[ SQL ] SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000445s ]
[ SQL ] UPDATE `tp_search_word` SET `goods_num`=8179 WHERE `id` = 1 [ RunTime:0.005299s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` = 652 LIMIT 1 [ RunTime:0.000572s ]
[ 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.014668s ]
[ 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.000947s ]
[ 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) ) [ RunTime:0.001693s ]
[ 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) [ RunTime:0.002522s ]
[ SQL ] SHOW COLUMNS FROM `tp_brand` [ RunTime:0.000885s ]
[ SQL ] SELECT * FROM `tp_brand` WHERE `cat_id1` IN (652) AND `status` = 0 ORDER BY sort asc [ RunTime:0.001029s ]
[ 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) ORDER BY `sort` desc LIMIT 0,20 [ RunTime:0.007035s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_images` [ RunTime:0.001472s ]
[ SQL ] SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (5633,6402,4356,5892,6660,9220,518,5126,4871,5128,5385,7689,4618,4875,5387,5643,5899,7691,4622,5390) [ RunTime:0.001166s ]
[ SQL ] SHOW COLUMNS FROM `tp_menu_goods_field` [ RunTime:0.001193s ]
[ SQL ] SELECT * FROM `tp_menu_goods_field` [ RunTime:0.001280s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 6144 limit 2 [ RunTime:0.000950s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 9987 limit 2 [ RunTime:0.001008s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 37893 limit 2 [ RunTime:0.000869s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 35338 limit 2 [ RunTime:0.001019s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 15901 limit 2 [ RunTime:0.001980s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 1315 limit 2 [ RunTime:0.001870s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 1316 limit 2 [ RunTime:0.001200s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 1318 limit 2 [ RunTime:0.001418s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 1319 limit 2 [ RunTime:0.001499s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 6196 limit 2 [ RunTime:0.001419s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 43575 limit 2 [ RunTime:0.000853s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 6728 limit 2 [ RunTime:0.001197s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 6994 limit 2 [ RunTime:0.000853s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 1620 limit 2 [ RunTime:0.001052s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 37462 limit 2 [ RunTime:0.001624s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 6233 limit 2 [ RunTime:0.001564s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 16750 limit 2 [ RunTime:0.000990s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 34675 limit 2 [ RunTime:0.000797s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 27508 limit 2 [ RunTime:0.000809s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 9847 limit 2 [ RunTime:0.001571s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 9855 limit 2 [ RunTime:0.001318s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 652 limit 2 [ RunTime:0.000833s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 670 limit 2 [ RunTime:0.001463s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 5025 limit 2 [ RunTime:0.000861s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 1713 limit 2 [ RunTime:0.000531s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 17329 limit 2 [ RunTime:0.000821s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 34767 limit 2 [ RunTime:0.000750s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 11729 limit 2 [ RunTime:0.001640s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 35025 limit 2 [ RunTime:0.001127s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 36320 limit 2 [ RunTime:0.000824s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 737 limit 2 [ RunTime:0.001042s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 9192 limit 2 [ RunTime:0.002075s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1748498962 and end_time > 1748498962 and status = 1 and cat_id1 = 14065 limit 2 [ RunTime:0.001249s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5633 LIMIT 1 [ RunTime:0.001065s ]
[ SQL ] SHOW COLUMNS FROM `tp_config` [ RunTime:0.000807s ]
[ SQL ] SELECT `name`,`value` FROM `tp_config` WHERE `name` IN ('oss_key_id','oss_key_secret','oss_endpoint','oss_bucket') [ RunTime:0.000408s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 6402 LIMIT 1 [ RunTime:0.000315s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4356 LIMIT 1 [ RunTime:0.000574s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5892 LIMIT 1 [ RunTime:0.000584s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 6660 LIMIT 1 [ RunTime:0.000526s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 9220 LIMIT 1 [ RunTime:0.000993s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5126 LIMIT 1 [ RunTime:0.000643s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4871 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5128 LIMIT 1 [ RunTime:0.000470s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5385 LIMIT 1 [ RunTime:0.000359s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 7689 LIMIT 1 [ RunTime:0.000418s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4618 LIMIT 1 [ RunTime:0.000410s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4875 LIMIT 1 [ RunTime:0.000690s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5387 LIMIT 1 [ RunTime:0.000475s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5643 LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5899 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 7691 LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 4622 LIMIT 1 [ RunTime:0.000290s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 5390 LIMIT 1 [ RunTime:0.000377s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000431s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `tp_navigation` where is_show = 1 AND position = 2 ORDER BY `sort` DESC [ RunTime:0.000312s ]
