SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.019513s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.038518s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.013569s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.005769s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.003375s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.004161s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.004992s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1741 LIMIT 1 [ RunTime:0.003230s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1327 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.006838s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.003387s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1741 [ RunTime:0.002477s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.004800s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (38930,38950,40248,40250,40252,42675,43081,43083,45168,45412,45413,45414,45415,45416,45442,45892,45895,47321,47324,51185,51441,52196,52197,52198,53190,56201,56627,56628,57426,57427,57430,57431,57432,57433,57434,57437,57438,57439,57440,57457,57458,57603,58057,58716,62959,62960,68187) [ RunTime:0.004709s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (38930,38950,40248,40250,40252,42675,43081,43083,45168,45412,45413,45414,45415,45416,45442,45892,45895,47321,47324,51185,51441,52196,52197,52198,53190,56201,56627,56628,57426,57427,57430,57431,57432,57433,57434,57437,57438,57439,57440,57457,57458,57603,58057,58716,62959,62960,68187) AND `brand_id` > 0 [ RunTime:0.005786s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003138s ]
SELECT * FROM `tp_brand` WHERE `id` IN (5446,5623,4781,6266,6321,6489,6964,6549,6629,7139,6661,4450,7327,6091,5253,5616) GROUP BY `name` LIMIT 30 [ RunTime:0.002090s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(38930,38950,40248,40250,40252,42675,43081,43083,45168,45412,45413,45414,45415,45416,45442,45892,45895,47321,47324,51185,51441,52196,52197,52198,53190,56201,56627,56628,57426,57427,57430,57431,57432,57433,57434,57437,57438,57439,57440,57457,57458,57603,58057,58716,62959,62960,68187) [ RunTime:0.005311s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.004008s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (38930,38950,40248,40250,40252,42675,43081,43083,45168,45412,45413,45414,45415,45416,45442,45892,45895,47321,47324,51185,51441,52196,52197,52198,53190,56201,56627,56628,57426,57427,57430,57431,57432,57433,57434,57437,57438,57439,57440,57457,57458,57603,58057,58716,62959,62960,68187) AND `attr_value` <> '' [ RunTime:0.003457s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.005100s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.003585s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (38930,38950,40248,40250,40252,42675,43081,43083,45168,45412,45413,45414,45415,45416,45442,45892,45895,47321,47324,51185,51441,52196,52197,52198,53190,56201,56627,56628,57426,57427,57430,57431,57432,57433,57434,57437,57438,57439,57440,57457,57458,57603,58057,58716,62959,62960,68187) ORDER BY `comment_count` ASC LIMIT 0,20 [ RunTime:0.008240s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.003450s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (57603,38930,38950,56627,56628,40248,40250,40252,45892,45895,43081,43083,57426,57427,57430,57431,57432,57433,57434,68187) [ RunTime:0.026830s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.007710s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.018623s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.015272s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.006038s ]
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.015924s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.014915s ]
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.022728s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.050889s ]
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.020616s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.015001s ]
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.039968s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.058199s ]
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.013515s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.009601s ]
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.019871s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.049947s ]
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.021849s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004762s ]
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.009005s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.036500s ]
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.005854s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.011424s ]
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.008699s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.037782s ]
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.023349s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.011863s ]
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.006052s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.020304s ]
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.015237s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.010816s ]
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.015987s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.048482s ]
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.003410s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003657s ]
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.004684s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.019002s ]
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.005173s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.007058s ]
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.014366s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.024699s ]
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.014414s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.021730s ]
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.014837s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.021990s ]
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.005718s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005004s ]
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.006747s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.028915s ]
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.010890s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003661s ]
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.008051s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.028728s ]
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.008552s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003831s ]
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.002536s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004027s ]
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.005615s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004263s ]
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.004170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003587s ]
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.004697s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003456s ]
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.002102s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.003756s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.001454s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.004490s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.001625s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.006808s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.003741s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57603 LIMIT 1 [ RunTime:0.002171s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 38930 LIMIT 1 [ RunTime:0.002691s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 38950 LIMIT 1 [ RunTime:0.004547s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 56627 LIMIT 1 [ RunTime:0.002611s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 56628 LIMIT 1 [ RunTime:0.002698s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40248 LIMIT 1 [ RunTime:0.001652s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40250 LIMIT 1 [ RunTime:0.002799s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40252 LIMIT 1 [ RunTime:0.003481s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 45892 LIMIT 1 [ RunTime:0.002421s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 45895 LIMIT 1 [ RunTime:0.003448s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43081 LIMIT 1 [ RunTime:0.003498s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43083 LIMIT 1 [ RunTime:0.002290s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57426 LIMIT 1 [ RunTime:0.002609s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57427 LIMIT 1 [ RunTime:0.002717s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57430 LIMIT 1 [ RunTime:0.003396s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57431 LIMIT 1 [ RunTime:0.003394s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57432 LIMIT 1 [ RunTime:0.003522s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57433 LIMIT 1 [ RunTime:0.003354s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57434 LIMIT 1 [ RunTime:0.004783s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68187 LIMIT 1 [ RunTime:0.002780s ]
select * from `tp_slogan` [ RunTime:0.001696s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.002771s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.002775s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.002518s ]