SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001183s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000693s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.003139s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001458s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.165293s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tp_search_word` SET `goods_num` = 24375 WHERE `id` = 7 [ RunTime:0.003253s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000690s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000213s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000179s ]
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.158313s ]
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.001040s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 1960 and shop_price <= 2940 ) [ RunTime:0.141427s ]
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.003834s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000754s ]
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 `sales_sum` ASC LIMIT 20,20 [ RunTime:0.004142s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000743s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (180495,180496,176913,112657,176914,183570,183571,180501,115226,115228,180509,115229,180510,180511,179744,180512,180513,115234,180515,114727) [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000640s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000534s ]
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.000217s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000136s ]
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.000178s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000169s ]
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.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.000270s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000234s ]
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.000237s ]
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.000191s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000193s ]
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.000320s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000214s ]
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.000173s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
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.000179s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000147s ]
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.000248s ]
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.000206s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000146s ]
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.000194s ]
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.000181s ]
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.000250s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000178s ]
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.000196s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000161s ]
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.000201s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000160s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 335 LIMIT 1 [ RunTime:0.000287s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 351 LIMIT 1 [ RunTime:0.000241s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 355 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 357 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000280s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180495 LIMIT 1 [ RunTime:0.000247s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180496 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 176913 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 112657 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 176914 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 183570 LIMIT 1 [ RunTime:0.000240s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 183571 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180501 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180509 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 115229 LIMIT 1 [ RunTime:0.000272s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180510 LIMIT 1 [ RunTime:0.000295s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180511 LIMIT 1 [ RunTime:0.000440s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 179744 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180512 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180513 LIMIT 1 [ RunTime:0.000240s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 180515 LIMIT 1 [ RunTime:0.000323s ]
select * from `tp_slogan` [ RunTime:0.000168s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000188s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000161s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000218s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000216s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000210s ]
