SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000944s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000550s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002323s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001002s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.000222s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000229s ]
UPDATE `tp_search_word` SET `goods_num` = 24101 WHERE `id` = 7 [ RunTime:0.001896s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000576s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000175s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000154s ]
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.003148s ]
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.000885s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 1960 and shop_price <= 2940 ) [ RunTime:0.138410s ]
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.003135s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000707s ]
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.000269s ]
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 `sort` ASC LIMIT 340,20 [ RunTime:0.004315s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000566s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (113898,114667,177900,179692,179693,106990,186350,134640,106992,177392,113648,134641,177393,177905,179953,180465,134642,177906,113139,177397) [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000558s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000546s ]
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.000176s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
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.000153s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000251s ]
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.000244s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000232s ]
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.000264s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000224s ]
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.000241s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000211s ]
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.000228s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000216s ]
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.000227s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000223s ]
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.000254s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000264s ]
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.000216s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000210s ]
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.000191s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000189s ]
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.000181s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000179s ]
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.000184s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000204s ]
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.000202s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000192s ]
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.000185s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000198s ]
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.000215s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000198s ]
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.000189s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000247s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000207s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000409s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 113898 LIMIT 1 [ RunTime:0.000859s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177900 LIMIT 1 [ RunTime:0.000316s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179692 LIMIT 1 [ RunTime:0.000326s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179693 LIMIT 1 [ RunTime:0.000408s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 106990 LIMIT 1 [ RunTime:0.000479s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 186350 LIMIT 1 [ RunTime:0.000490s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 134640 LIMIT 1 [ RunTime:0.000334s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177392 LIMIT 1 [ RunTime:0.000293s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 113648 LIMIT 1 [ RunTime:0.000323s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177393 LIMIT 1 [ RunTime:0.000352s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177905 LIMIT 1 [ RunTime:0.000393s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180465 LIMIT 1 [ RunTime:0.000294s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177906 LIMIT 1 [ RunTime:0.000312s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177397 LIMIT 1 [ RunTime:0.000332s ]
select * from `tp_slogan` [ RunTime:0.000210s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000243s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000240s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000233s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000233s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000224s ]
