SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.002189s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.001360s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.001794s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.004656s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.013501s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.000687s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001265s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1809 LIMIT 1 [ RunTime:0.000811s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1662 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.004555s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.003179s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1809 [ RunTime:0.001255s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.002930s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (42807,42808,44150,44972,44973,45887,46127,46128,46129,46133,47389,50353,51031,51032,59006,62440,62441,62442,62443) [ RunTime:0.002041s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (42807,42808,44150,44972,44973,45887,46127,46128,46129,46133,47389,50353,51031,51032,59006,62440,62441,62442,62443) AND `brand_id` > 0 [ RunTime:0.001818s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001600s ]
SELECT * FROM `tp_brand` WHERE `id` IN (6004,6005,6266,6292,6544,7139,4936,5154,5187,7423,6898) GROUP BY `name` LIMIT 30 [ RunTime:0.004079s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(42807,42808,44150,44972,44973,45887,46127,46128,46129,46133,47389,50353,51031,51032,59006,62440,62441,62442,62443) [ RunTime:0.019635s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.018217s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (42807,42808,44150,44972,44973,45887,46127,46128,46129,46133,47389,50353,51031,51032,59006,62440,62441,62442,62443) AND `attr_value` <> '' [ RunTime:0.020322s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.017368s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.019656s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (42807,42808,44150,44972,44973,45887,46127,46128,46129,46133,47389,50353,51031,51032,59006,62440,62441,62442,62443) ORDER BY `sales_sum` ASC LIMIT 0,20 [ RunTime:0.012058s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.008114s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (42807,42808,45887,59006,50353,62440,62441,62442,62443,51031,51032,44150,46127,46128,46129,46133,47389,44972,44973) [ RunTime:0.017215s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.003897s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.016354s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.022608s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.015681s ]
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.012169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005450s ]
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.005882s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.016500s ]
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.011882s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.011526s ]
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.006377s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.011513s ]
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.012643s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.007134s ]
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.011543s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.057678s ]
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.023550s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005443s ]
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.005708s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006896s ]
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.008837s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006921s ]
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.003863s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006260s ]
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.005907s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004217s ]
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.005437s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.013835s ]
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.015281s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006399s ]
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.003984s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.030337s ]
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.014936s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008188s ]
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.009574s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008349s ]
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.014495s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005494s ]
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.009502s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.007268s ]
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.008477s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006386s ]
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.005172s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004038s ]
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.003927s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005247s ]
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.003986s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004677s ]
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.006211s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004080s ]
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.003540s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004212s ]
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.004707s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005765s ]
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.003912s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003877s ]
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.004732s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003727s ]
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.004096s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006089s ]
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.003478s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003470s ]
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.005118s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.004378s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.006775s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.004303s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.004980s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.005851s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.003877s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42807 LIMIT 1 [ RunTime:0.004143s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42808 LIMIT 1 [ RunTime:0.005197s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 45887 LIMIT 1 [ RunTime:0.005870s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 59006 LIMIT 1 [ RunTime:0.008028s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50353 LIMIT 1 [ RunTime:0.009496s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 62440 LIMIT 1 [ RunTime:0.004051s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 62441 LIMIT 1 [ RunTime:0.004148s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 62442 LIMIT 1 [ RunTime:0.003613s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 62443 LIMIT 1 [ RunTime:0.003829s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51031 LIMIT 1 [ RunTime:0.002503s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 51032 LIMIT 1 [ RunTime:0.045316s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44150 LIMIT 1 [ RunTime:0.007098s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46127 LIMIT 1 [ RunTime:0.006361s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46128 LIMIT 1 [ RunTime:0.005791s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46129 LIMIT 1 [ RunTime:0.007656s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46133 LIMIT 1 [ RunTime:0.004434s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47389 LIMIT 1 [ RunTime:0.003457s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44972 LIMIT 1 [ RunTime:0.003690s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44973 LIMIT 1 [ RunTime:0.002424s ]
select * from `tp_slogan` [ RunTime:0.003344s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.002766s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.003649s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.003807s ]