DELETE FROM `dr_7_zhuan_search`
WHERE `inputtime` < 1748690915
Event: dbquery
Events
0.14 ms
Query
Database
1.66 ms
SELECT count(*) as t FROM `dr_7_zhuan` WHERE `dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238))) ORDERBYNULL
Event: dbquery
Events
0.13 ms
Query
Database
11.11 ms
REPLACE INTO `dr_7_zhuan_search` (`id`, `catid`, `params`, `keyword`, `contentid`, `inputtime`) VALUES ('a13d78bb5666015f8371c1c21d24aaf2', 1, '{\"param\":{\"zczj\":\"1000,0\",\"address\":\"guangdong\",\"catid\":1},\"sql\":\"SELECT `dr_7_zhuan`.`id` FROM `dr_7_zhuan` WHERE `dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238))) ORDERBYNULL \",\"where\":\"`dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238)))\"}', '', 7, 1748694515)
Event: dbquery
Events
0.16 ms
Query
Database
0.89 ms
SHOW COLUMNS FROM `dr_7_zhuan_category_data`
Event: dbquery
Events
0.05 ms
Query
Database
2.33 ms
SELECT `dr_7_zhuan`.*,`dr_7_zhuan_category_data`.`jiancheng`,`dr_7_zhuan_category_data`.`biaoqian`,`dr_7_zhuan_category_data`.`gslx`,`dr_7_zhuan_category_data`.`clsj`,`dr_7_zhuan_category_data`.`zczj`,`dr_7_zhuan_category_data`.`nslx`,`dr_7_zhuan_category_data`.`csjg`,`dr_7_zhuan_category_data`.`address`,`dr_7_zhuan_category_data`.`jiyu`,`dr_7_zhuan_category_data`.`zzbiaoqian`,`dr_7_zhuan_category_data`.`zzsgzcb`,`dr_7_zhuan_category_data`.`zzzycb` FROM `dr_7_zhuan` LEFTJOIN dr_7_zhuan_category_data ON `dr_7_zhuan_category_data`.`id`=`dr_7_zhuan`.`id` WHERE `dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238))) ORDERBY `dr_7_zhuan`.`updatetime` DESCLIMIT 0,9
Event: dbquery
Events
0.06 ms
After Filters
Timer
0.56 ms
Database (5 total Queries, 5 of them unique across 1 Connection)
Time
Query String
3.35 ms
DELETE FROM `dr_7_zhuan_search`
WHERE `inputtime` < 1748690915
SELECT count(*) as t FROM `dr_7_zhuan` WHERE `dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238))) ORDERBYNULL
REPLACE INTO `dr_7_zhuan_search` (`id`, `catid`, `params`, `keyword`, `contentid`, `inputtime`) VALUES ('a13d78bb5666015f8371c1c21d24aaf2', 1, '{\"param\":{\"zczj\":\"1000,0\",\"address\":\"guangdong\",\"catid\":1},\"sql\":\"SELECT `dr_7_zhuan`.`id` FROM `dr_7_zhuan` WHERE `dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238))) ORDERBYNULL \",\"where\":\"`dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238)))\"}', '', 7, 1748694515)
SELECT `dr_7_zhuan`.*,`dr_7_zhuan_category_data`.`jiancheng`,`dr_7_zhuan_category_data`.`biaoqian`,`dr_7_zhuan_category_data`.`gslx`,`dr_7_zhuan_category_data`.`clsj`,`dr_7_zhuan_category_data`.`zczj`,`dr_7_zhuan_category_data`.`nslx`,`dr_7_zhuan_category_data`.`csjg`,`dr_7_zhuan_category_data`.`address`,`dr_7_zhuan_category_data`.`jiyu`,`dr_7_zhuan_category_data`.`zzbiaoqian`,`dr_7_zhuan_category_data`.`zzsgzcb`,`dr_7_zhuan_category_data`.`zzzycb` FROM `dr_7_zhuan` LEFTJOIN dr_7_zhuan_category_data ON `dr_7_zhuan_category_data`.`id`=`dr_7_zhuan`.`id` WHERE `dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238))) ORDERBY `dr_7_zhuan`.`updatetime` DESCLIMIT 0,9
'SELECT `dr_7_zhuan`.`id` FROM `dr_7_zhuan` WHERE `dr_7_zhuan`.`catid`=1 AND `dr_7_zhuan`.`id` IN (SELECT `id` FROM `dr_7_zhuan_category_data` WHERE `dr_7_zhuan_category_data`.`zczj` > 1000 AND (`dr_7_zhuan_category_data`.`address` IN (23,269,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,270,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,271,2141,2142,2143,2144,2145,2146,272,2147,2148,2149,273,2150,2151,2152,2153,2154,2155,2156,274,2157,2158,2159,2160,2161,275,2162,2163,2164,2165,2166,2167,2168,276,2169,2170,2171,2172,2173,2174,2175,2176,2177,277,2178,2179,2180,2181,2182,278,2183,2184,2185,2186,2187,2188,2189,2190,279,2191,2192,2193,2194,2195,280,2196,2197,2198,2199,2200,2201,2202,2203,281,2204,2205,2206,2207,282,2208,2209,2210,2211,2212,2213,283,2214,2215,2216,2217,284,2218,2219,2220,2221,2222,2223,2224,2225,285,286,287,2226,2227,2228,288,2229,2230,2231,2232,2233,289,2234,2235,2236,2237,2238))) ORDER BY NULL '