SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.000788s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.000437s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.000204s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000638s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.000150s ]
SHOW FULL COLUMNS FROM `tp_search_word` [ RunTime:0.000449s ]
UPDATE `tp_search_word` SET `search_num` = `search_num` + 1 WHERE `keywords` = '' [ RunTime:0.004509s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000677s ]
SELECT COUNT(*) AS think_count FROM `tp_goods` WHERE ( `goods_sn` LIKE '%%' OR `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 AND `is_show` = 1 [ RunTime:0.000213s ]
SELECT * FROM `tp_search_word` WHERE `keywords` = '' LIMIT 1 [ RunTime:0.000671s ]
UPDATE `tp_search_word` SET `goods_num` = 9698 WHERE `id` = 997 [ RunTime:0.003159s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000445s ]
SELECT * FROM `tp_goods_category` WHERE `name` LIKE '%%' LIMIT 1 [ RunTime:0.000214s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000408s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 944 [ RunTime:0.000183s ]
SELECT `goods_id`,`cat_id` FROM `tp_goods` WHERE ( `goods_sn` LIKE '%%' OR `goods_name` LIKE '%%' OR `keywords` LIKE '%%' ) AND `is_on_sale` = 1 AND `is_show` = 1 AND `is_virtual` <> 2 OR ( cat_id in (944,958,968,969,970,971,972,973,957,963,964,965,966,967,959,974,975,976,960,980,977,978,979,981,982,983,984,985,986,987,988,989,990,991,992,993,961,994,995,996,962,997) and is_virtual <> 2 and is_on_sale =1 and is_show =1 ) [ RunTime:0.001935s ]
SELECT * FROM `tp_goods_category` WHERE `id` IN (964,963,984,965,1073,988,1038,1012,1000,1049,1002,1037,1046,1047,1044,1144,1045,1067,1040,1105,1019,1050,1169,1304,1205,1170,1283,1542,1540,978,977,1162,1164,1368,1369,1273,1055,1382,1385,1275,1263,1054,1042,1387,1208,1149,1212,975,1565,1214,1581,1580,1579,1213,970,1063,992,1423,1421,1338,1577,1112,1217,1578,1216,1336,1307,1215,1335,1306,1308,995,1309,1057,1232,971,1311,1333,983,1310,1312,972,1332,1313,1285,1230,1321,1229,1228,1320,974,1319,1318,1317,968,1058,1316,1223,1219,1114,1220,1222,1227,1315,1115,969,1113,1314,1569,1571,1573,1553,1148,1129,1204,1262,1135,1357,1274,1481,1134,1422,1620,1132,1203,1131,1551,1509,1137,1143,1269,1624,1272,1290,1218,1289,1288,1379,1409,1287,1432,1434,1479,1399,1472,1083,1403,1470,1355,1086,1468,1396,1075,1393,1159,1416,1243,1248,1376,1466,1377,1464,1082,1390,1374,1465,1375,1122,1124,1386,1076,1395,1276,1261,1373,1259,1277,1391,1392,1372,1404,1389,1258,1257,1394,1371,1251,1341,1256,1249,1253,1546,1298,1299,1250,1265,1270,1271,1297,1295,1106,1514,1515,1370,1663,1343,1675,1677,1168,1018,1198,1749,1084,1356,1359,1171,1686,1687,1035,1296,1294,1293,1292,1278,1255,1254,1252,1649,1666,1349,1397,1405,1653,1654,1656,1406,1354,1440,1658,1189,1381,1193,1194,1476,1195,1510,1197,1383,1133,1519,1107,1508,1659,1660,1334,1805,1305,1420,1667,1668,1670,1669,1671,1672,1673,1056,1691,1693,1694,1575,2095,1059,1178,1698,1584,1109,1703,980,1708,1697,1595,1008,1461,1700,1233,1591,1614,1701,1706,1709,1147,1447,1710,1699,1586,1715,1001,1716,1717,1718,1719,1720,1722,1725,1108,1726,1544,1730,1731,1462,1734,1748,1732,1585,1752,1211,1191,1478,1192,1179,1605,1758,1181,1760,1761,1763,1764,1766,1768,1769,1729,1110,1770,1772,1773,1774,1776,1777,1779,1781,1657,1804,1552,1808,1184,1810,1812,1743,1429,1813,1486,1790,1820,1650,1742,1822,1741,1744,1823,1824,1825,1740,1655,1829,1830,1801,1512,1835,1836,1728,1840,1841,1437,1574,1592,1854,1609,1831,1467,1857,1862,1832,1264,1864,1859,1796,1878,1517,1883,1884,1463,1885,1522,1886,1887,1563,1811,1902,1905,1907,1513,1917,1920,1173,1921,1922,1837,1060,1856,1930,1875,1931,1085,1933,1934,1095,1881,1940,1939,1795,1516,1005,1806,1943,1954,1958,1961,1418,1419,1965,1966,1956,1967,1968,1696,1969,1547,1558,1555,1970,1971,1974,1975,1976,1978,1982,1983,1480,1809,1367,1587,1988,1989,979,1994,1998,2000,1501,1380,1632,1017,1413,1123,1489,2008,1196,1185,2005,1952,2012,1926,2019,2021,2022,1756,2023,2026,1487,1061,2007,1995,1177,2030,1877,2032,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2045,2046,1500,1858,1488,1894,1892,2053,1541,2055,1388,2056,1895,2057,2063,2067,1445,1443,1985,2070,1932,1889,1984,2018,2075,2069,2080,1266,2087,2089,2090,2091,2081,1444,1402,1782,1504,1554,1619,2099,1786,2103,1738,1505,1125,1723,1100,1529,2106,1784,1428,2107,2028,2108,1724,1175,1176,2111,2113,1182,1601,2121,1986,2127,1518,1636,1593,2128,1942,2133,1821,1342,2134,1918,2135,1439,1284,2137,1485,1941,2105,2143,2144,2146,1610,2153,2154,1679,2155,2162,2163,2164,2048,2166,2167,2176,2177,2179,2180,1993,2181,2183,2189,2194,1845,1851,2195,2196,1850,2197,2199,2200,2169,1180,2142,2082,1365,2198,2184,1827,2223,2188,1234,1861,1589,1503,2226,2227,2065,1448,1362,1350,2174,1351,1352,2230,2110,1799,1006,2172,1496,1929,2212,2190,2114,2231,2207,1745,2220,2130,2232,1788,1451,2233,2102,1705,2126,1712,1520,1783,2235,2208,1685,2158,1245,2060,1560,2017,2068,1802,1378,2241,1550,2152,1946,1860,1183,1286,2215,2029,2101,1721,2016,2248,1471,2054,2148,2186,1617,2242,1291,1849,2047,1186,1492,2259,1646,1683) [ RunTime:0.003037s ]
SELECT `goods_id` FROM `tp_goods` WHERE `brand_id` = 7010 [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000493s ]
SELECT `id`,`name` FROM `tp_brand` [ RunTime:0.000738s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (55103,55104,55105,55106,55107,55108,55109,55110,55111,55112,55113,55119,55120,55133) [ RunTime:0.000445s ]
SELECT * FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_id` IN (55103,55104,55105,55106,55107,55108,55109,55110,55111,55112,55113,55119,55120,55133) ORDER BY `sort` ASC LIMIT 0,20 [ RunTime:0.000660s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000430s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (55103,55104,55105,55106,55107,55108,55109,55110,55111,55112,55113,55119,55120,55133) [ RunTime:0.000190s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000456s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000470s ]
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.000198s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000136s ]
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.000194s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000197s ]
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.000176s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000151s ]
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.000173s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000155s ]
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.000192s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
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.000168s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000163s ]
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.000173s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000155s ]
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.000190s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000172s ]
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.000188s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000147s ]
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.000171s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000190s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000143s ]
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.000175s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000169s ]
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.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000149s ]
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.000225s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000156s ]
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.000184s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000168s ]
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.000174s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000157s ]
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.000166s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
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.000190s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
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.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000166s ]
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.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000138s ]
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.000187s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000177s ]
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.000176s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
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.000194s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000160s ]
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.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000145s ]
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.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000161s ]
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.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
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.000178s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
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.000190s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
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.000194s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000178s ]
select * from `tp_goods` where is_recommend = 1 and is_on_sale = 1 and is_show=1 limit 5 [ RunTime:0.000286s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30992 LIMIT 1 [ RunTime:0.000167s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33733 LIMIT 1 [ RunTime:0.000185s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35044 LIMIT 1 [ RunTime:0.000159s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36864 LIMIT 1 [ RunTime:0.000152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41230 LIMIT 1 [ RunTime:0.000162s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55103 LIMIT 1 [ RunTime:0.000240s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55104 LIMIT 1 [ RunTime:0.000239s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55105 LIMIT 1 [ RunTime:0.000749s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55106 LIMIT 1 [ RunTime:0.000273s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55107 LIMIT 1 [ RunTime:0.000217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55108 LIMIT 1 [ RunTime:0.000207s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55109 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55110 LIMIT 1 [ RunTime:0.000221s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55111 LIMIT 1 [ RunTime:0.000236s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55112 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55113 LIMIT 1 [ RunTime:0.000194s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55119 LIMIT 1 [ RunTime:0.000219s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55120 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55133 LIMIT 1 [ RunTime:0.000198s ]
select * from `tp_slogan` [ RunTime:0.000173s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.000181s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000187s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.000184s ]