SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.003616s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.004916s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.004032s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.003448s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.010937s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.005065s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.006423s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1086 LIMIT 1 [ RunTime:0.007445s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1072 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.006699s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.003872s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1086 [ RunTime:0.003905s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.007628s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (33284,33285,33288,33308,33309,33310,33316,33335,33337,34586,38382,38685,39530,41387,42481,42784,42785,43345,43583,43754,45599,45611,45940,45942,45944,45948,45950,45962,46925,49747,54546,54804,54851,54870,55005,55103,55105,55710,56111,56138,56260,56397,56525,57602,57604,58786,58788,58789,58801,59197,62950,68118,68460) [ RunTime:0.005219s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (33284,33285,33288,33308,33309,33310,33316,33335,33337,34586,38382,38685,39530,41387,42481,42784,42785,43345,43583,43754,45599,45611,45940,45942,45944,45948,45950,45962,46925,49747,54546,54804,54851,54870,55005,55103,55105,55710,56111,56138,56260,56397,56525,57602,57604,58786,58788,58789,58801,59197,62950,68118,68460) AND `brand_id` > 0 [ RunTime:0.005275s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.005709s ]
SELECT * FROM `tp_brand` WHERE `id` IN (6519,6521,4621,4478,5296,5528,4505,5007,4737,6531,4450,4738,5485,6870,6931,6094,6629,7010,6738,6661,7639,5817,5172,4735) GROUP BY `name` LIMIT 30 [ RunTime:0.004463s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(33284,33285,33288,33308,33309,33310,33316,33335,33337,34586,38382,38685,39530,41387,42481,42784,42785,43345,43583,43754,45599,45611,45940,45942,45944,45948,45950,45962,46925,49747,54546,54804,54851,54870,55005,55103,55105,55710,56111,56138,56260,56397,56525,57602,57604,58786,58788,58789,58801,59197,62950,68118,68460) [ RunTime:0.005929s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.004056s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (33284,33285,33288,33308,33309,33310,33316,33335,33337,34586,38382,38685,39530,41387,42481,42784,42785,43345,43583,43754,45599,45611,45940,45942,45944,45948,45950,45962,46925,49747,54546,54804,54851,54870,55005,55103,55105,55710,56111,56138,56260,56397,56525,57602,57604,58786,58788,58789,58801,59197,62950,68118,68460) AND `attr_value` <> '' [ RunTime:0.006449s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.003968s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.003584s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (33284,33285,33288,33308,33309,33310,33316,33335,33337,34586,38382,38685,39530,41387,42481,42784,42785,43345,43583,43754,45599,45611,45940,45942,45944,45948,45950,45962,46925,49747,54546,54804,54851,54870,55005,55103,55105,55710,56111,56138,56260,56397,56525,57602,57604,58786,58788,58789,58801,59197,62950,68118,68460) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.005043s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.007563s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.006347s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005904s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.003715s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005352s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005774s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005689s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004682s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005614s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005828s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.004676s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006315s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005888s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003588s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005682s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004415s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005687s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005820s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005740s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005304s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005677s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005831s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005657s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004014s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.003664s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004857s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005624s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005485s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005641s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005854s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005610s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004518s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005697s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005785s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005698s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004483s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.004651s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004788s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.007738s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005862s ]
SELECT * FROM `tp_ad` WHERE ( pid=110 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.010675s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006835s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.009649s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003307s ]
SELECT * FROM `tp_ad` WHERE ( pid=111 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.012731s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008784s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.011539s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.011719s ]
SELECT * FROM `tp_ad` WHERE ( pid=112 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.008678s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006825s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.008707s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004365s ]
SELECT * FROM `tp_ad` WHERE ( pid=113 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.006683s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008771s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005662s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004829s ]
SELECT * FROM `tp_ad` WHERE ( pid=114 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.011693s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.010737s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.007677s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.011510s ]
SELECT * FROM `tp_ad` WHERE ( pid=115 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005606s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.009773s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.008655s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.005630s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.008566s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.007802s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.007730s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.008411s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.011760s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57602 LIMIT 1 [ RunTime:0.006104s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33284 LIMIT 1 [ RunTime:0.010537s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57604 LIMIT 1 [ RunTime:0.005293s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33285 LIMIT 1 [ RunTime:0.007227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33288 LIMIT 1 [ RunTime:0.010658s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54546 LIMIT 1 [ RunTime:0.005827s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54804 LIMIT 1 [ RunTime:0.006244s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68118 LIMIT 1 [ RunTime:0.009789s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34586 LIMIT 1 [ RunTime:0.006671s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33308 LIMIT 1 [ RunTime:0.004286s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33309 LIMIT 1 [ RunTime:0.007294s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 38685 LIMIT 1 [ RunTime:0.008470s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33310 LIMIT 1 [ RunTime:0.006740s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 45599 LIMIT 1 [ RunTime:0.009350s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42784 LIMIT 1 [ RunTime:0.008416s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42785 LIMIT 1 [ RunTime:0.005251s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33316 LIMIT 1 [ RunTime:0.003262s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 45611 LIMIT 1 [ RunTime:0.005287s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 56111 LIMIT 1 [ RunTime:0.003519s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33335 LIMIT 1 [ RunTime:0.007237s ]
select * from `tp_slogan` [ RunTime:0.003204s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.007717s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.007610s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.001875s ]