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.000303s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000552s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002231s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001052s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.000196s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000232s ]
UPDATE `tp_search_word` SET `goods_num` = 24101 WHERE `id` = 7 [ RunTime:0.001991s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000582s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000182s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000156s ]
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.003174s ]
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.000904s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 1980 and shop_price <= 3960 ) [ RunTime:0.140676s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (106796,106808,106809,106835,106840,106841,106843,106844,106848,106849,106851,106856,106857,106859,106860,106863,106866,106867,106871,106874,106887,106891,106892,106893,106894,106895,106896,106903,106904,106905,106906,106914,106922,106924,106930,106941,106990,106991,106992,106993,106995,107054,107065,107071,107137,107138,107139,107140,107141,107142,107144,107145,107146,107148,107153,107154,107155,107156,107157,107158,107159,107162,107982,107983,107989,107990,107991,108035,108331,108758,109495,109513,110283,112469,112471,112485,112582,112655,112657,112965,112969,112970,112971,112972,112973,112974,112975,112976,112977,112978,112979,112980,112981,112984,112985,112986,112987,112988,112989,112990,112991,112992,112993,112994,112995,112996,112997,112998,112999,113020,113032,113057,113058,113139,113193,113194,113195,113224,113225,113648,113816,113829,113844,113864,113891,113892,113893,113894,113895,113896,113897,113898,113964,113973,113981,113982,113983,113987,113988,113990,113991,113992,113993,114008,114015,114057,114060,114065,114066,114067,114068,114069,114070,114072,114077,114118,114121,114251,114294,114297,114300,114302,114303,114346,114355,114360,114364,114365,114371,114375,114376,114377,114395,114421,114422,114424,114442,114443,114444,114497,114498,114501,114577,114578,114586,114588,114589,114590,114591,114667,114713,114714,114715,114723,114727,114744,114762,114763,114776,114778,114782,114783,114837,114838,114839,114840,114859,114861,114865,114882,115225,115226,115227,115228,115229,115231,115234,115240,115244,115346,115347,115354,115355,115357,115368,115392,115537,115551,115804,115805,115814,115816,115825,116135,116480,116482,116559,116624,116625,116630,116636,116637,116741,125721,126548,131176,131178,131453,131454,131455,131456,131457,131458,131459,131466,131473,131474,131475,131482,131484,131485,131495,131496,131497,131498,131499,131500,131501,131503,132207,132229,133502,133503,134640,134641,134642,134975,134983,134994,135007,135175,135176,135177,135179,138054,139373,139374,139563,139564,151780,176869,176870,176893,176894,176896,176899,176900,176901,176902,176903,176904,176905,176906,176907,176909,176910,176911,176913,176914,176915,176916,176919,176920,176923,176926,176928,176933,176985,176986,176987,176988,176989,176990,176991,177008,177009,177012,177013,177014,177015,177016,177018,177019,177020,177029,177055,177056,177057,177058,177060,177061,177062,177063,177064,177078,177079,177080,177111,177115,177116,177117,177118,177119,177120,177127,177174,177392,177393,177394,177397,177399,177400,177403,177404,177407,177859,177860,177861,177871,177872,177888,177890,177894,177900,177901,177905,177906,177907,177981,177984,177985,177986,177989,177991,178038,178044,178045,178047,178048,178049,178050,178051,178065,178066,178073,178074,178076,178501,178502,178503,178504,178505,178507,178516,178522,178523,178527,178528,178529,178530,178531,178532,178533,178534,178535,178536,178540,178541,178542,178543,178544,178546,178547,178548,178549,178551,178552,178553,178554,178558,178559,178560,178561,178562,178569,178570,178577,178578,178584,178585,178590,178591,178593,178597,178598,178599,178600,178603,178604,178605,178606,178611,178612,178613,178614,178619,178630,178631,178632,178636,178638,178639,178640,178642,178643,178644,178645,178646,178647,178650,178653,178655,178659,178660,178661,178662,178664,178665,178666,178667,178668,178676,179623,179624,179625,179626,179630,179631,179635,179636,179637,179638,179639,179644,179651,179656,179657,179658,179659,179660,179661,179670,179673,179674,179681,179682,179692,179693,179744,179787,179830,179843,179844,179845,179846,179866,179867,179868,179880,179881,179887,179935,179953,180446,180447,180465,180472,180473,180474,180475,180484,180486,180488,180493,180495,180496,180501,180509,180510,180511,180512,180513,180515,180520,180526,180528,180529,180530,180552,180553,180554,180556,180557,180561,180562,180563,180803,181419,181420,181575,181578,181585,181586,181594,181597,181600,181601,181602,181617,181624,181625,181629,181630,181631,181633,182455,182457,182890,183425,183438,183562,183570,183571,183572,183574,183575,183678,183679,183682,184145,184147,184194,184195,184196,184263,184264,184265,184269,184270,184271,184272,184273,184430,184431,184432,184435,184436,184437,184438,184439,186350) AND `brand_id` > 0 [ RunTime:0.004723s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000726s ]
SELECT * FROM `tp_brand` WHERE `id` IN (95,37,28,33,142,65,49,22,43,96,81,24,242,72,52,207,18,246,27,186,188,93,75,63,57,236,244,31,203,276,23,91,68,230,224,46,154,42,176,125,238) LIMIT 30 [ RunTime:0.000271s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (106796,106808,106809,106835,106840,106841,106843,106844,106848,106849,106851,106856,106857,106859,106860,106863,106866,106867,106871,106874,106887,106891,106892,106893,106894,106895,106896,106903,106904,106905,106906,106914,106922,106924,106930,106941,106990,106991,106992,106993,106995,107054,107065,107071,107137,107138,107139,107140,107141,107142,107144,107145,107146,107148,107153,107154,107155,107156,107157,107158,107159,107162,107982,107983,107989,107990,107991,108035,108331,108758,109495,109513,110283,112469,112471,112485,112582,112655,112657,112965,112969,112970,112971,112972,112973,112974,112975,112976,112977,112978,112979,112980,112981,112984,112985,112986,112987,112988,112989,112990,112991,112992,112993,112994,112995,112996,112997,112998,112999,113020,113032,113057,113058,113139,113193,113194,113195,113224,113225,113648,113816,113829,113844,113864,113891,113892,113893,113894,113895,113896,113897,113898,113964,113973,113981,113982,113983,113987,113988,113990,113991,113992,113993,114008,114015,114057,114060,114065,114066,114067,114068,114069,114070,114072,114077,114118,114121,114251,114294,114297,114300,114302,114303,114346,114355,114360,114364,114365,114371,114375,114376,114377,114395,114421,114422,114424,114442,114443,114444,114497,114498,114501,114577,114578,114586,114588,114589,114590,114591,114667,114713,114714,114715,114723,114727,114744,114762,114763,114776,114778,114782,114783,114837,114838,114839,114840,114859,114861,114865,114882,115225,115226,115227,115228,115229,115231,115234,115240,115244,115346,115347,115354,115355,115357,115368,115392,115537,115551,115804,115805,115814,115816,115825,116135,116480,116482,116559,116624,116625,116630,116636,116637,116741,125721,126548,131176,131178,131453,131454,131455,131456,131457,131458,131459,131466,131473,131474,131475,131482,131484,131485,131495,131496,131497,131498,131499,131500,131501,131503,132207,132229,133502,133503,134640,134641,134642,134975,134983,134994,135007,135175,135176,135177,135179,138054,139373,139374,139563,139564,151780,176869,176870,176893,176894,176896,176899,176900,176901,176902,176903,176904,176905,176906,176907,176909,176910,176911,176913,176914,176915,176916,176919,176920,176923,176926,176928,176933,176985,176986,176987,176988,176989,176990,176991,177008,177009,177012,177013,177014,177015,177016,177018,177019,177020,177029,177055,177056,177057,177058,177060,177061,177062,177063,177064,177078,177079,177080,177111,177115,177116,177117,177118,177119,177120,177127,177174,177392,177393,177394,177397,177399,177400,177403,177404,177407,177859,177860,177861,177871,177872,177888,177890,177894,177900,177901,177905,177906,177907,177981,177984,177985,177986,177989,177991,178038,178044,178045,178047,178048,178049,178050,178051,178065,178066,178073,178074,178076,178501,178502,178503,178504,178505,178507,178516,178522,178523,178527,178528,178529,178530,178531,178532,178533,178534,178535,178536,178540,178541,178542,178543,178544,178546,178547,178548,178549,178551,178552,178553,178554,178558,178559,178560,178561,178562,178569,178570,178577,178578,178584,178585,178590,178591,178593,178597,178598,178599,178600,178603,178604,178605,178606,178611,178612,178613,178614,178619,178630,178631,178632,178636,178638,178639,178640,178642,178643,178644,178645,178646,178647,178650,178653,178655,178659,178660,178661,178662,178664,178665,178666,178667,178668,178676,179623,179624,179625,179626,179630,179631,179635,179636,179637,179638,179639,179644,179651,179656,179657,179658,179659,179660,179661,179670,179673,179674,179681,179682,179692,179693,179744,179787,179830,179843,179844,179845,179846,179866,179867,179868,179880,179881,179887,179935,179953,180446,180447,180465,180472,180473,180474,180475,180484,180486,180488,180493,180495,180496,180501,180509,180510,180511,180512,180513,180515,180520,180526,180528,180529,180530,180552,180553,180554,180556,180557,180561,180562,180563,180803,181419,181420,181575,181578,181585,181586,181594,181597,181600,181601,181602,181617,181624,181625,181629,181630,181631,181633,182455,182457,182890,183425,183438,183562,183570,183571,183572,183574,183575,183678,183679,183682,184145,184147,184194,184195,184196,184263,184264,184265,184269,184270,184271,184272,184273,184430,184431,184432,184435,184436,184437,184438,184439,186350) ORDER BY `sort` ASC LIMIT 500,20 [ RunTime:0.006764s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000673s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (179658,110283,179659,178636,179660,179661,184269,107982,178638,184270,107983,177871,178639,184271,177872,178640,184272,184273,178642,178643) [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000655s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000684s ]
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.000201s ]
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.000200s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000219s ]
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.000208s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000167s ]
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.000158s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000174s ]
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.000185s ]
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.000146s ]
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.000162s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000130s ]
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.000168s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000234s ]
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.000187s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
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.000187s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000198s ]
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.000223s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000202s ]
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.000230s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000197s ]
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.000347s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000167s ]
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.000172s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000218s ]
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.000210s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000165s ]
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 * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000166s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000207s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000176s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000144s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000142s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000172s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179658 LIMIT 1 [ RunTime:0.000304s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179659 LIMIT 1 [ RunTime:0.000238s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178636 LIMIT 1 [ RunTime:0.000275s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179660 LIMIT 1 [ RunTime:0.000259s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179661 LIMIT 1 [ RunTime:0.000250s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 184269 LIMIT 1 [ RunTime:0.000255s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178638 LIMIT 1 [ RunTime:0.000252s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 184270 LIMIT 1 [ RunTime:0.000229s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177871 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178639 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 184271 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177872 LIMIT 1 [ RunTime:0.000577s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178640 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 184272 LIMIT 1 [ RunTime:0.000275s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 184273 LIMIT 1 [ RunTime:0.000220s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178642 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178643 LIMIT 1 [ RunTime:0.000214s ]
select * from `tp_slogan` [ RunTime:0.000155s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000164s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000157s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000176s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000187s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000154s ]
