SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001316s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000767s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.003135s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001083s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.000206s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000226s ]
UPDATE `tp_search_word` SET `goods_num` = 23712 WHERE `id` = 7 [ RunTime:0.002139s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000613s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000196s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000192s ]
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.003081s ]
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,344,651,672,697,696,603,621,596,712,597,610,591,660,376,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.001058s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 1980 and shop_price <= 3960 ) [ RunTime:0.000292s ]
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,177859,177860,177861,177871,177872,177888,177890,177894,177900,177901,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.003594s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000785s ]
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.000351s ]
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,177859,177860,177861,177871,177872,177888,177890,177894,177900,177901,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 540,20 [ RunTime:0.008322s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000753s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (177119,178655,179935,180447,177120,177888,179681,177890,179682,178659,113891,151780,178660,113892,176869,178661,113893,176870,177894,178662) [ RunTime:0.000467s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000687s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000550s ]
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.000204s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000144s ]
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.000161s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000191s ]
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.000159s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000133s ]
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.000151s ]
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.000138s ]
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.000147s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
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.000132s ]
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.000135s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000125s ]
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.000146s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000124s ]
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.000138s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000140s ]
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.000136s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000117s ]
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.000133s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000154s ]
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.000136s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000129s ]
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.000157s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000135s ]
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.000169s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000175s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000169s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000189s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177119 LIMIT 1 [ RunTime:0.000180s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178655 LIMIT 1 [ RunTime:0.000141s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180447 LIMIT 1 [ RunTime:0.000148s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177120 LIMIT 1 [ RunTime:0.000252s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177888 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179681 LIMIT 1 [ RunTime:0.000253s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177890 LIMIT 1 [ RunTime:0.000179s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179682 LIMIT 1 [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178659 LIMIT 1 [ RunTime:0.000177s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 113891 LIMIT 1 [ RunTime:0.000175s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178660 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 113892 LIMIT 1 [ RunTime:0.000177s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 176869 LIMIT 1 [ RunTime:0.000178s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178661 LIMIT 1 [ RunTime:0.000183s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 176870 LIMIT 1 [ RunTime:0.000177s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 177894 LIMIT 1 [ RunTime:0.000205s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178662 LIMIT 1 [ RunTime:0.000174s ]
select * from `tp_slogan` [ RunTime:0.000125s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000158s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000136s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000166s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000137s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000136s ]
