SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001362s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000889s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002614s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001379s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.179147s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000245s ]
UPDATE `tp_search_word` SET `goods_num` = 33630 WHERE `id` = 7 [ RunTime:0.002144s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.002356s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000207s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000183s ]
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.205990s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (380,789,594,605,379,606,608,659,609,611,612,615,617,619,621,672,624,641,640,642,372,639,54,607,343,0,588,628,589,382,374,345,634,376,635,636,377,373,620,788,647,618,381,591,375,344,700,603,597,595,723,592,660,651,671,712,715,784,644,614,658,770,598,726,783,805,796,346,771,795,780,797,668,378,764,826,610,855,596,798,755,799,590,749,760,756,627,754,593,616,803,802,704,853,852,774,820,613,691,348,699,645,838) [ RunTime:0.001125s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 37 [ RunTime:0.000676s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 10560 ) [ RunTime:0.206363s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003610s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000223s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (920,6940,6949,6958,6959,7926,7928,8515,13661,13662,13938,14322,21120,21121,36370,44787,44886,46831,59812,63279,69790,72650,74566,74811,77091,78873,84589,85101,86684,93715,93716,93717,93718,93719,106838,106839,106842,106848,106922,106923,106924,106928,106930,106942,106990,106991,110742,110743,110744,110745,112713,113889,113890,114579,114921,115439,115440,115441,115442,116633,130111,131171,131914,138062,138232,138233,138234,138235,139779,146281,146282,146485,149953,153700,157091,157092,158879,160747,165144,166855,167344,176715,176716,176717,176718,180106,180107,180108,180109,180882,180883,180884,182828,183416,185077,186220,188507,189031,189032,189037,189038,189039,189040,189041,189042,189043,189044,189045,189046,189048,189049,189050,189051,189053,189054,189057,189058,189060,189062,189063,189066,189069,189070,189077,189078,189080,189083,189195,189196,189197,189198,189199,189200,189204,189205,189206,189207,189209,189210,189212,189213,189214,189215,189216,189217,189220,189222,189224,189226,189228,189229,189248,189253,189254,189258,189260,189267,189275,189278,189279,189280,189281,189283,189285,189286,189288,189289,189290,189291,189292,189295,189326,189327,189328,189547,189549,189551,189552,189570,189571,189577,189578,189581,189631,189632,189633,189634,189637,189638,189639,189643,189644,189645,189646,189652,189653,189655,189685,189686,189690,189691,189692,189693,189695,189696,189697,189698,189699,189701,189703,189704,189706,189708,189712,189713,189714,189800,190727,191056,191782,191919,191921,191922,191969,191970,192239,192245,192326,192328,192329,192332,192333,192336,192339,192343,192344,192345,192346,192347,192348,193012,193013,193014,193089,193091,193092,194615,196523,196524,196527,196574,196927,196964,197434,197908,198590,198735,199169,199254,199256,199257,199258,199259,200018,200607,200669,200674,200675,203522,203523,203525,203526,203527,203548,203549,203551,203552,203553,203623,203742,204701,207435,207483,209218,209829,210092,211808,212582,216353,217830,218085,220127) ORDER BY `sort` ASC LIMIT 220,20 [ RunTime:0.003840s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000964s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (191919,196527,167344,106928,191921,106930,191922,198590,106942,189631,189632,149953,189633,189634,189637,189638,166855,189639,72650,189643) [ RunTime:0.000188s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000876s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000220s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.001067s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000195s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000214s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000242s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000550s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000192s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000185s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000145s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000150s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000168s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000159s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000171s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000140s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000241s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000234s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000218s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000226s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000229s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000231s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000199s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000236s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000207s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000207s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000226s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000220s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000236s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000199s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000281s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000223s ]
SELECT * FROM `tp_ad` WHERE ( pid=110 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) 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.000196s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000221s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000235s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 400 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 416 LIMIT 1 [ RunTime:0.000199s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 430 LIMIT 1 [ RunTime:0.000206s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 191919 LIMIT 1 [ RunTime:0.000336s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 196527 LIMIT 1 [ RunTime:0.000280s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 167344 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 191921 LIMIT 1 [ RunTime:0.000261s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 191922 LIMIT 1 [ RunTime:0.000357s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 198590 LIMIT 1 [ RunTime:0.000269s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189631 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189632 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 149953 LIMIT 1 [ RunTime:0.000228s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189633 LIMIT 1 [ RunTime:0.000201s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189634 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189637 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189638 LIMIT 1 [ RunTime:0.000252s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 166855 LIMIT 1 [ RunTime:0.000219s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189639 LIMIT 1 [ RunTime:0.000254s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 72650 LIMIT 1 [ RunTime:0.000365s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189643 LIMIT 1 [ RunTime:0.000240s ]
select * from `tp_slogan` [ RunTime:0.000162s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000193s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000165s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000189s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000199s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000202s ]
