SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001054s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000663s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002364s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001139s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.142997s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tp_search_word` SET `goods_num` = 24375 WHERE `id` = 7 [ RunTime:0.002378s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000778s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000202s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000166s ]
SELECT `goods_id`,`cat_id` FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 AND `is_virtual` <> 2 OR ( cat_id in (54,372,373,374,375,376,377,639,651,780) and is_virtual <> 2 and is_on_sale =1 ) [ RunTime:0.158512s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (380,789,592,593,595,594,605,379,606,608,659,609,611,612,615,617,618,619,623,624,641,640,642,373,639,374,607,343,345,628,588,382,0,589,634,635,636,620,377,788,647,381,372,375,376,344,651,672,697,696,603,621,596,712,597,610,591,660,643,715,784,614,644,770,598,704,658,378,346,783,805,796,700,673,767,754,780,668,795,768,613,764,600,730,822,771,726,756,798,723,736,797,852,799,590,749,759,760,627,54,616,803,802,823,725,655,820,731,691,342,348,699) [ RunTime:0.001134s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 1960 and shop_price <= 2940 ) [ RunTime:0.155660s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (106796,106808,106835,106840,106843,106848,106851,106859,106863,106871,106874,106887,106891,106892,106893,106894,106903,106904,106905,106922,106924,106930,106941,106990,106992,107054,107065,107071,107137,107138,107139,107140,107141,107148,107153,107154,107155,107156,107169,107989,107990,107991,108035,108331,108366,109495,109513,110283,112655,112657,112965,112969,112970,112971,112972,112973,112974,112975,112977,112978,112979,112981,112984,112986,113020,113057,113139,113193,113194,113195,113224,113648,113864,113891,113892,113893,113895,113896,113897,113898,113964,113981,113982,113987,113988,113990,113991,113992,113993,114060,114065,114066,114067,114068,114069,114070,114072,114077,114118,114121,114297,114300,114355,114360,114364,114421,114424,114442,114443,114497,114501,114577,114578,114585,114586,114588,114589,114590,114591,114667,114727,114762,114763,114778,114782,114783,114838,114839,114840,114859,114861,114865,114882,115226,115228,115229,115234,115240,115244,115347,115355,115368,115392,115537,115814,115825,116135,116480,116559,116624,116625,116630,116637,116741,126548,131453,131454,131455,131466,131473,131474,131475,131482,131484,131485,131495,131496,131498,131503,132229,133502,134640,134641,134642,134983,134994,135007,135175,135176,135177,135179,138054,139373,139374,139563,139564,176870,176893,176894,176896,176899,176900,176901,176902,176903,176904,176906,176913,176914,176985,176986,176987,176988,176989,176990,176991,177008,177009,177012,177029,177055,177056,177057,177058,177063,177078,177079,177080,177111,177115,177116,177117,177118,177119,177120,177127,177392,177393,177397,177399,177403,177861,177872,177888,177890,177900,177905,177906,177981,177984,177985,177986,177991,178038,178044,178045,178047,178048,178049,178050,178516,178522,178530,178531,178532,178533,178534,178535,178536,178544,178546,178552,178553,178560,178562,178577,178578,178584,178590,178591,178598,178599,178600,178604,178611,178613,178614,178630,178631,178632,178636,178638,178639,178640,178644,178645,178646,178647,178650,178659,178660,178661,178662,178664,178665,179623,179625,179626,179630,179635,179636,179670,179673,179674,179692,179693,179744,179843,179845,179866,179868,179881,179935,179953,180446,180447,180465,180472,180473,180474,180484,180493,180495,180496,180501,180509,180510,180511,180512,180513,180515,180520,180528,180556,180557,180561,180563,180803,181419,181420,181586,181594,181617,181625,181629,181630,182890,183425,183570,183571,183678,183679,183682,184147,184194,184195,184263,184264,184265,184269,184271,184272,184273,184430,184431,184435,184436,184439,186350) AND `brand_id` > 0 [ RunTime:0.003127s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000792s ]
SELECT * FROM `tp_brand` WHERE `id` IN (95,37,33,28,142,65,49,22,96,81,24,242,75,72,18,246,93,63,57,236,31,203,27,276,43,23,91,230,224,154,52,42,125,238) LIMIT 30 [ RunTime:0.000252s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (106796,106808,106835,106840,106843,106848,106851,106859,106863,106871,106874,106887,106891,106892,106893,106894,106903,106904,106905,106922,106924,106930,106941,106990,106992,107054,107065,107071,107137,107138,107139,107140,107141,107148,107153,107154,107155,107156,107169,107989,107990,107991,108035,108331,108366,109495,109513,110283,112655,112657,112965,112969,112970,112971,112972,112973,112974,112975,112977,112978,112979,112981,112984,112986,113020,113057,113139,113193,113194,113195,113224,113648,113864,113891,113892,113893,113895,113896,113897,113898,113964,113981,113982,113987,113988,113990,113991,113992,113993,114060,114065,114066,114067,114068,114069,114070,114072,114077,114118,114121,114297,114300,114355,114360,114364,114421,114424,114442,114443,114497,114501,114577,114578,114585,114586,114588,114589,114590,114591,114667,114727,114762,114763,114778,114782,114783,114838,114839,114840,114859,114861,114865,114882,115226,115228,115229,115234,115240,115244,115347,115355,115368,115392,115537,115814,115825,116135,116480,116559,116624,116625,116630,116637,116741,126548,131453,131454,131455,131466,131473,131474,131475,131482,131484,131485,131495,131496,131498,131503,132229,133502,134640,134641,134642,134983,134994,135007,135175,135176,135177,135179,138054,139373,139374,139563,139564,176870,176893,176894,176896,176899,176900,176901,176902,176903,176904,176906,176913,176914,176985,176986,176987,176988,176989,176990,176991,177008,177009,177012,177029,177055,177056,177057,177058,177063,177078,177079,177080,177111,177115,177116,177117,177118,177119,177120,177127,177392,177393,177397,177399,177403,177861,177872,177888,177890,177900,177905,177906,177981,177984,177985,177986,177991,178038,178044,178045,178047,178048,178049,178050,178516,178522,178530,178531,178532,178533,178534,178535,178536,178544,178546,178552,178553,178560,178562,178577,178578,178584,178590,178591,178598,178599,178600,178604,178611,178613,178614,178630,178631,178632,178636,178638,178639,178640,178644,178645,178646,178647,178650,178659,178660,178661,178662,178664,178665,179623,179625,179626,179630,179635,179636,179670,179673,179674,179692,179693,179744,179843,179845,179866,179868,179881,179935,179953,180446,180447,180465,180472,180473,180474,180484,180493,180495,180496,180501,180509,180510,180511,180512,180513,180515,180520,180528,180556,180557,180561,180563,180803,181419,181420,181586,181594,181617,181625,181629,181630,182890,183425,183570,183571,183678,183679,183682,184147,184194,184195,184263,184264,184265,184269,184271,184272,184273,184430,184431,184435,184436,184439,186350) ORDER BY `sales_sum` ASC LIMIT 360,20 [ RunTime:0.004143s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000586s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (180473,180474,177403,176893,176894,132229,115347,177906,115368) [ RunTime:0.000480s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000553s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000168s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000544s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000149s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000170s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000154s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000174s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000156s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000201s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000149s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000145s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000184s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000122s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000134s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000143s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000118s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000140s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000145s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000133s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000129s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000156s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000151s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000149s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000148s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000155s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000156s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000126s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000149s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000243s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000281s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000380s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000276s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180473 LIMIT 1 [ RunTime:0.000219s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180474 LIMIT 1 [ RunTime:0.000276s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177403 LIMIT 1 [ RunTime:0.000206s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 176893 LIMIT 1 [ RunTime:0.000283s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 176894 LIMIT 1 [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177906 LIMIT 1 [ RunTime:0.000317s ]
select * from `tp_slogan` [ RunTime:0.000141s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000178s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000163s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000156s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000176s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000158s ]
