SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'xian' [ RunTime:0.001035s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [ID],[js],[xname],[sheng],[pyjc],[shengname] FROM [xian] WHERE [id] = '6') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000809s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [id],[xname],[sheng],[xiaoxian] FROM [xian] WHERE [js] = 0) AS thinkphp) AS T1 [ RunTime:0.000632s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [id],[xname],[sheng],[xiaoxian],[pyjc] FROM [xian] WHERE [xname] IN ('北京','上海','天津','重庆','台湾','澳门')) AS thinkphp) AS T1 [ RunTime:0.023014s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [id],[xname],[sheng],[xiaoxian] FROM [xian] WHERE [id] = '3108') AS thinkphp) AS T1 [ RunTime:0.007504s ]
SELECT T1.id,ctoname,qianming,updatetime,xiancn,tel,lianxiren,lianxitel,xxaddress,xianlustr,ywms,litpic,bosstel FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [updatetime] desc) AS ROW_NUMBER FROM (SELECT * FROM [ctouser] WHERE [xiancn] = '郑州' AND [stop] = 1 AND [user_type] = 3) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 23) [ RunTime:0.092968s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'xianlu' [ RunTime:0.001481s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [xianlu] WHERE [id] = 39670011) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000691s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'ctouser' [ RunTime:0.002201s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ctouser] WHERE [id] = 287684) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.004277s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'ctouser_wangdian' [ RunTime:0.007398s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ctouser_wangdian] WHERE ( [address] LIKE '%西安%' OR [wdname] LIKE '%西安%' OR [city2] LIKE '%西安%' ) AND [sid] = 287684) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000675s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ctouser_wangdian] WHERE ( [address] LIKE '%北京%' OR [wdname] LIKE '%北京%' ) AND [sid] = 287684) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001152s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ctouser_wangdian] WHERE [zb] = 1 AND [sid] = 287684) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000910s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [ordernum]) AS ROW_NUMBER FROM (SELECT * FROM [xianlu] WHERE [sid] = 287684) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 12) [ RunTime:0.025595s ]