[ DB ] CONNECT:[ UseTime:0.235418s ] sqlsrv:Database=icmall;Server=101.37.35.21,1433
[ SQL ] 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 = 'info' [ RunTime:0.035823s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='info' [ RunTime:0.035706s ]
[ SQL ] 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 = 'lang' [ RunTime:0.035714s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='lang' [ RunTime:0.041943s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [id],[name_cn],[name_local] FROM [w].[lang] WHERE [id] IN (1,2)) AS thinkphp) AS T1 [ RunTime:0.034908s ]
[ SQL ] 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 = 'currency_v' [ RunTime:0.040459s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='currency_v' [ RunTime:0.035498s ]
[ SQL ] 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 = 'category_my_v' [ RunTime:0.035257s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='category_my_v' [ RunTime:0.034901s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT category_id as id,[category_id],[parent_id],[category_name] FROM [product].[category_my_v] WHERE [lang_id] = 1 AND [category_id] = 385) AS thinkphp) AS T1 [ RunTime:0.035221s ]
[ SQL ] 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 = 'category_cus' [ RunTime:0.035571s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='category_cus' [ RunTime:0.043907s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY xh asc) AS ROW_NUMBER FROM (SELECT * FROM [product].[category_cus] WHERE [parent_id] = -1 AND [is_show] = 1 AND [mycoid] = 10008 AND [lang_id] = 1) AS thinkphp) AS T1 [ RunTime:0.034985s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY xh asc) AS ROW_NUMBER FROM (SELECT * FROM [product].[category_cus] WHERE ( parent_id != -1 ) AND [is_show] = 1 AND [mycoid] = 10008 AND [lang_id] = 1) AS thinkphp) AS T1 [ RunTime:0.095874s ]
[ SQL ] 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 = 'nav' [ RunTime:0.039585s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='nav' [ RunTime:0.035149s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [xh]) AS ROW_NUMBER FROM (SELECT [name_dis],[url],[tag],[xh] FROM [site].[nav] WHERE [lang_id] = 1 AND [mycoid] = 10008 AND ( del = 0 )) AS thinkphp) AS T1 [ RunTime:0.034954s ]
