SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.007686s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.009876s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.003966s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.005492s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.021589s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.005165s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.003419s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 947 LIMIT 1 [ RunTime:0.004309s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.004937s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.007308s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 6467 [ RunTime:0.004153s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003680s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.005522s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32637,32644,32649,32692,32726,32728,32796,32798,32801,32836,32847,32917,32921,32923,32924,32926,32927,32973,32978,32992,32993,32999,33002,33018,33081,33163,33246,33249,33253,33256,33258,33268,33274,33276,33277,33974,33975,33976,33980,34699,34700,34701,34702,34789,34794,32557,33647,33649,33656,33747,33775,33783,33929,33964,34780,34798,34800,35495,32577,33263,33287,33305,33307,33312,33436,33438,33456,33494,33948,33949,35562,35564,35567,35568,35570,37099) [ RunTime:0.010890s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32637,32644,32649,32692,32726,32728,32796,32798,32801,32836,32847,32917,32921,32923,32924,32926,32927,32973,32978,32992,32993,32999,33002,33018,33081,33163,33246,33249,33253,33256,33258,33268,33274,33276,33277,33974,33975,33976,33980,34699,34700,34701,34702,34789,34794,32557,33647,33649,33656,33747,33775,33783,33929,33964,34780,34798,34800,35495,32577,33263,33287,33305,33307,33312,33436,33438,33456,33494,33948,33949,35562,35564,35567,35568,35570,37099) [ RunTime:0.004443s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.002933s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32637,32644,32649,32692,32726,32728,32796,32798,32801,32836,32847,32917,32921,32923,32924,32926,32927,32973,32978,32992,32993,32999,33002,33018,33081,33163,33246,33249,33253,33256,33258,33268,33274,33276,33277,33974,33975,33976,33980,34699,34700,34701,34702,34789,34794,32557,33647,33649,33656,33747,33775,33783,33929,33964,34780,34798,34800,35495,32577,33263,33287,33305,33307,33312,33436,33438,33456,33494,33948,33949,35562,35564,35567,35568,35570,37099) AND `attr_value` <> '' [ RunTime:0.005412s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.004072s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.002407s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32637,32644,32649,32692,32726,32728,32796,32798,32801,32836,32847,32917,32921,32923,32924,32926,32927,32973,32978,32992,32993,32999,33002,33018,33081,33163,33246,33249,33253,33256,33258,33268,33274,33276,33277,33974,33975,33976,33980,34699,34700,34701,34702,34789,34794,32557,33647,33649,33656,33747,33775,33783,33929,33964,34780,34798,34800,35495,32577,33263,33287,33305,33307,33312,33436,33438,33456,33494,33948,33949,35562,35564,35567,35568,35570,37099) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.005246s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.004688s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.007661s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003524s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.004122s ]
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.004358s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003771s ]
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.005847s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005420s ]
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.002869s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005570s ]
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.003716s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005272s ]
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.003702s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003778s ]
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.005700s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003332s ]
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.002948s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004704s ]
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.005544s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005547s ]
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.006463s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003072s ]
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.005421s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003286s ]
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.002711s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006402s ]
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.005666s ]
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.005443s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003808s ]
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.003682s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004787s ]
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.004537s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004977s ]
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.002475s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005670s ]
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.005369s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005829s ]
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.005631s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004921s ]
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.007886s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003544s ]
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.005943s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006935s ]
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.004847s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.007004s ]
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.002220s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004766s ]
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.004701s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003770s ]
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.004702s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005465s ]
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.005668s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003812s ]
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.003700s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005264s ]
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.003551s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004798s ]
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.005707s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005614s ]
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.004664s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004914s ]
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.004576s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.004690s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.005900s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.004673s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.004665s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.002680s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.004692s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33287 LIMIT 1 [ RunTime:0.004358s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33305 LIMIT 1 [ RunTime:0.006738s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33307 LIMIT 1 [ RunTime:0.004151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32796 LIMIT 1 [ RunTime:0.004514s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32798 LIMIT 1 [ RunTime:0.003144s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33312 LIMIT 1 [ RunTime:0.006198s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32801 LIMIT 1 [ RunTime:0.004228s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32557 LIMIT 1 [ RunTime:0.005364s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33081 LIMIT 1 [ RunTime:0.004039s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32577 LIMIT 1 [ RunTime:0.007539s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32836 LIMIT 1 [ RunTime:0.006281s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32847 LIMIT 1 [ RunTime:0.003926s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33647 LIMIT 1 [ RunTime:0.000492s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33649 LIMIT 1 [ RunTime:0.000353s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33656 LIMIT 1 [ RunTime:0.001056s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32637 LIMIT 1 [ RunTime:0.000637s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32644 LIMIT 1 [ RunTime:0.000908s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32649 LIMIT 1 [ RunTime:0.001505s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33929 LIMIT 1 [ RunTime:0.001801s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33163 LIMIT 1 [ RunTime:0.000670s ]
select * from `tp_slogan` [ RunTime:0.000769s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.001033s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000733s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.000677s ]