[ DB ] CONNECT:[ UseTime:0.000000s ] 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.031250s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='info' [ RunTime:0.046875s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [site].[info] WHERE [url] LIKE '%www.pc-dm.com') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.046875s ]
[ 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.031250s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='lang' [ RunTime:0.031250s ]
[ 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.031250s ]
[ 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.031250s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='currency_v' [ RunTime:0.046875s ]
[ 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.031250s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='category_cus' [ RunTime:0.031250s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [product].[category_cus] WHERE [id] = 10100) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.031250s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [product].[category_cus] WHERE [id] = 10083) AS thinkphp) AS T1 [ RunTime:0.031250s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [id] FROM [product].[category_cus] WHERE [parent_id] = 10100) AS thinkphp) AS T1 [ RunTime:0.031250s ]
[ 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 = 'stock' [ RunTime:0.031250s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='stock' [ RunTime:0.046875s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id asc) AS ROW_NUMBER FROM (SELECT [id],[pn],[mfg],[mfg_st_id],[unit_price],[qty],[moq],[dc],[pck],[pic_main],[ladder] FROM [product].[stock] WHERE [category_st_id] IN (10100) AND [mycoid] = 10002) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 30) [ RunTime:0.062500s ]
