SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001767s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.001229s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.002970s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001996s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 [ RunTime:0.000252s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tp_search_word` SET `goods_num` = 33630 WHERE `id` = 7 [ RunTime:0.002902s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001196s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000243s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000274s ]
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.008101s ]
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.001248s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 37 [ RunTime:0.000404s ]
SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 0 and shop_price <= 10560 ) [ RunTime:0.245588s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003704s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000304s ]
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 60,20 [ RunTime:0.003462s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000936s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (182828,189228,189229,6958,6959,63279,146485,194615,197434,74811,196927,130111,189248,193089,209218,193091,193092,189253,74566,189254) [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000885s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000912s ]
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.000195s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000152s ]
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.000180s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000130s ]
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.000174s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
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.000135s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000155s ]
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.000152s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000168s ]
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.000177s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000137s ]
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.000181s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000165s ]
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.000187s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000151s ]
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.000168s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000173s ]
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.000176s ]
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 < 1761847200 and end_time > 1761847200 ) 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.000162s ]
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.000168s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000163s ]
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.000228s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000167s ]
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.000216s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000186s ]
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.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000169s ]
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.000201s ]
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.000172s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000174s ]
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.000178s ]
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 < 1761847200 and end_time > 1761847200 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000180s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000164s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 363 LIMIT 1 [ RunTime:0.000201s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 383 LIMIT 1 [ RunTime:0.000152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 400 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 416 LIMIT 1 [ RunTime:0.000160s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 430 LIMIT 1 [ RunTime:0.000152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 182828 LIMIT 1 [ RunTime:0.000264s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189228 LIMIT 1 [ RunTime:0.000460s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189229 LIMIT 1 [ RunTime:0.000292s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 6958 LIMIT 1 [ RunTime:0.000267s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 6959 LIMIT 1 [ RunTime:0.000266s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63279 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 146485 LIMIT 1 [ RunTime:0.000217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 194615 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 197434 LIMIT 1 [ RunTime:0.000291s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 74811 LIMIT 1 [ RunTime:0.000256s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 196927 LIMIT 1 [ RunTime:0.000221s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 130111 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189248 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 193089 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 209218 LIMIT 1 [ RunTime:0.000228s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 193091 LIMIT 1 [ RunTime:0.000260s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 193092 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189253 LIMIT 1 [ RunTime:0.000254s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 74566 LIMIT 1 [ RunTime:0.000286s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 189254 LIMIT 1 [ RunTime:0.000240s ]
select * from `tp_slogan` [ RunTime:0.000146s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000190s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000175s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000191s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000603s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000184s ]
