SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.011115s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.005745s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.005987s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.003362s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.030492s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.005656s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.009445s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1940 LIMIT 1 [ RunTime:0.006580s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1938 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.016955s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.012925s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1940 [ RunTime:0.012614s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.005345s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (41595,41604,41605,41606,41608,41609,41610,41615,41616,41617,41618,41619,41621,41627,41628,41632,41633,41636,41637,41640,41641,41642,41643,41644,41650,41651,41655,41656,41657,41658,41659,41660,41661,41662,41665,41666,41667,41669,41670,41671,41672,41674,41675,41676,41677,41678,41679,41680,41681,41682,41683,41684,41685,41686,41687,41691,41692,41693,41695,41696,41699,41700,41701,41702,41703,41704,41705,41706,41712,41714,41715,41716,41717,41719,41720) [ RunTime:0.006281s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (41595,41604,41605,41606,41608,41609,41610,41615,41616,41617,41618,41619,41621,41627,41628,41632,41633,41636,41637,41640,41641,41642,41643,41644,41650,41651,41655,41656,41657,41658,41659,41660,41661,41662,41665,41666,41667,41669,41670,41671,41672,41674,41675,41676,41677,41678,41679,41680,41681,41682,41683,41684,41685,41686,41687,41691,41692,41693,41695,41696,41699,41700,41701,41702,41703,41704,41705,41706,41712,41714,41715,41716,41717,41719,41720) AND `brand_id` > 0 [ RunTime:0.010350s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.011423s ]
SELECT * FROM `tp_brand` WHERE `id` IN (5824,5826,5827,5829,5830,5835,5834,5833,5832,5831) GROUP BY `name` LIMIT 30 [ RunTime:0.008593s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(41595,41604,41605,41606,41608,41609,41610,41615,41616,41617,41618,41619,41621,41627,41628,41632,41633,41636,41637,41640,41641,41642,41643,41644,41650,41651,41655,41656,41657,41658,41659,41660,41661,41662,41665,41666,41667,41669,41670,41671,41672,41674,41675,41676,41677,41678,41679,41680,41681,41682,41683,41684,41685,41686,41687,41691,41692,41693,41695,41696,41699,41700,41701,41702,41703,41704,41705,41706,41712,41714,41715,41716,41717,41719,41720) [ RunTime:0.010429s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.011332s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (41595,41604,41605,41606,41608,41609,41610,41615,41616,41617,41618,41619,41621,41627,41628,41632,41633,41636,41637,41640,41641,41642,41643,41644,41650,41651,41655,41656,41657,41658,41659,41660,41661,41662,41665,41666,41667,41669,41670,41671,41672,41674,41675,41676,41677,41678,41679,41680,41681,41682,41683,41684,41685,41686,41687,41691,41692,41693,41695,41696,41699,41700,41701,41702,41703,41704,41705,41706,41712,41714,41715,41716,41717,41719,41720) AND `attr_value` <> '' [ RunTime:0.006352s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.008125s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.010227s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (41595,41604,41605,41606,41608,41609,41610,41615,41616,41617,41618,41619,41621,41627,41628,41632,41633,41636,41637,41640,41641,41642,41643,41644,41650,41651,41655,41656,41657,41658,41659,41660,41661,41662,41665,41666,41667,41669,41670,41671,41672,41674,41675,41676,41677,41678,41679,41680,41681,41682,41683,41684,41685,41686,41687,41691,41692,41693,41695,41696,41699,41700,41701,41702,41703,41704,41705,41706,41712,41714,41715,41716,41717,41719,41720) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.011065s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.004653s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.034381s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005448s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.011059s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.010370s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008818s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005892s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.009344s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005662s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008872s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.007546s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.007451s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.007542s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.010865s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.010552s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008441s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.004661s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006824s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.010655s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008411s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.012603s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002887s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.003940s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004963s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.003491s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003904s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005532s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004012s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.003994s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005470s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.003851s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004350s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005373s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004833s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.006543s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005530s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.003804s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.013832s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005303s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004820s ]
SELECT * FROM `tp_ad` WHERE ( pid=110 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.004484s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003211s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.009432s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005338s ]
SELECT * FROM `tp_ad` WHERE ( pid=111 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005676s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004709s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005676s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003512s ]
SELECT * FROM `tp_ad` WHERE ( pid=112 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005691s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004669s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.006734s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006318s ]
SELECT * FROM `tp_ad` WHERE ( pid=113 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.003731s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003695s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.005592s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004089s ]
SELECT * FROM `tp_ad` WHERE ( pid=114 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.006755s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003783s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.003642s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005619s ]
SELECT * FROM `tp_ad` WHERE ( pid=115 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.005701s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005356s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765785600 and end_time > 1765785600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.006081s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.004638s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.003105s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.005558s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.005666s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.005604s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.005591s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41595 LIMIT 1 [ RunTime:0.004387s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41604 LIMIT 1 [ RunTime:0.005663s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41605 LIMIT 1 [ RunTime:0.007015s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41606 LIMIT 1 [ RunTime:0.002925s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41608 LIMIT 1 [ RunTime:0.005260s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41609 LIMIT 1 [ RunTime:0.004178s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41610 LIMIT 1 [ RunTime:0.008826s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41615 LIMIT 1 [ RunTime:0.004027s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41616 LIMIT 1 [ RunTime:0.004982s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41617 LIMIT 1 [ RunTime:0.004527s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41618 LIMIT 1 [ RunTime:0.004904s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41619 LIMIT 1 [ RunTime:0.004718s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41621 LIMIT 1 [ RunTime:0.005408s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41627 LIMIT 1 [ RunTime:0.007149s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41628 LIMIT 1 [ RunTime:0.006657s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41632 LIMIT 1 [ RunTime:0.009353s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41633 LIMIT 1 [ RunTime:0.005584s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41636 LIMIT 1 [ RunTime:0.005091s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41637 LIMIT 1 [ RunTime:0.006441s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41640 LIMIT 1 [ RunTime:0.005952s ]
select * from `tp_slogan` [ RunTime:0.015405s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.007305s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.004645s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.007483s ]