基本文件流程错误 SQL 调试

E:\web\pt.topchinatravel.com\index.php ( 1.25 KB )
E:\web\pt.topchinatravel.com\vendor\autoload.php ( 0.18 KB )
E:\web\pt.topchinatravel.com\vendor\composer\autoload_real.php ( 1.64 KB )
E:\web\pt.topchinatravel.com\vendor\composer\ClassLoader.php ( 12.27 KB )
E:\web\pt.topchinatravel.com\vendor\composer\autoload_static.php ( 0.62 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\ThinkPHP.php ( 4.46 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Think.class.php ( 12.66 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Storage.class.php ( 1.36 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Storage\Driver\File.class.php ( 3.52 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Mode\common.php ( 2.77 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Common\functions.php ( 54.21 KB )
E:\web\pt.topchinatravel.com\Application\Common\Common\function.php ( 9.33 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Hook.class.php ( 4.00 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\App.class.php ( 13.36 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Dispatcher.class.php ( 15.63 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Route.class.php ( 13.32 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Controller.class.php ( 11.06 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\View.class.php ( 8.21 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Behavior\BuildLiteBehavior.class.php ( 3.66 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Behavior\ParseTemplateBehavior.class.php ( 3.89 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Behavior\ContentReplaceBehavior.class.php ( 1.89 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Conf\convention.php ( 10.74 KB )
E:\web\pt.topchinatravel.com\Application\Common\Conf\config.php ( 1.42 KB )
E:\web\pt.topchinatravel.com\Application\Common\Conf\router.php ( 3.52 KB )
E:\MSSQL\config.php ( 0.15 KB )
E:\web\pt.topchinatravel.com\Application\Common\Conf\tags.php ( 0.23 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Lang\zh-cn.php ( 2.52 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Conf\debug.php ( 1.42 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Conf\config.php ( 0.06 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Behavior\ReadHtmlCacheBehavior.class.php ( 5.75 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Controller\ArticleController.class.php ( 3.63 KB )
E:\web\pt.topchinatravel.com\Application\Common\Controller\BaseController.class.php ( 1.18 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Service\BasePageService.class.php ( 0.55 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Service\PageService.class.php ( 13.50 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\DocsModel.class.php ( 0.87 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Model.class.php ( 69.18 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Db.class.php ( 5.52 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Db\Driver\Sqlsrv.class.php ( 5.72 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Db\Driver.class.php ( 41.68 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\SeoModel.class.php ( 0.50 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Service\ArticlePageService.class.php ( 9.55 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\AreaModel.class.php ( 2.06 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\PageStructureModel.class.php ( 0.41 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\PageRelationModel.class.php ( 0.34 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\PriceInfoModel.class.php ( 0.35 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\Area2Model.class.php ( 0.17 KB )
E:\web\pt.topchinatravel.com\Application\TopChinaTravel\Model\PageExtendModel.class.php ( 0.14 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Template.class.php ( 28.76 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Template\TagLib\Cx.class.php ( 22.75 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Think\Template\TagLib.class.php ( 9.39 KB )
E:\web\pt.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\20cb67829dd1feff1d16bbee0748c9df.php ( 24.33 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Behavior\WriteHtmlCacheBehavior.class.php ( 1.41 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Behavior\TokenBuildBehavior.class.php ( 2.67 KB )
E:\web\pt.topchinatravel.com\ThinkPHP\Library\Behavior\ShowPageTraceBehavior.class.php ( 5.25 KB )

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 = 'tct_page' [ RunTime:0.0011s ]
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 = 'tct_seoinfo' [ RunTime:0.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0126s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [title],[keywords],[description],[follows],[canonical] FROM [tct_seoinfo] WHERE [P_id] = 187930 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0051s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0045s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0046s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [title],[keywords],[description],[follows],[canonical] FROM [tct_seoinfo] WHERE [P_id] = 187930 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0025s ]
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 = 'tct_area' [ RunTime:0.0003s ]
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 = 'tct_pagestructure' [ RunTime:0.0003s ]
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 = 'tct_pagerelation' [ RunTime:0.0002s ]
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 = 'tct_priceinfo' [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0039s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0041s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187930 AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0006s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY code asc) AS ROW_NUMBER FROM (SELECT a.id,a.code,a2.alias,isnull(a2.continent,'') + isnull(a2.controy,'') + isnull(a2.province,'')+ isnull(a2.city,'') + isnull(a2.district,'') as AreaName FROM tct_area a INNER JOIN TCT_area2 as a2 ON a.id = a2.A_id WHERE a2.LG_id = 6 AND a.WS_id = 7 AND a.id IN ('264313') ) AS thinkphp) AS T1 [ RunTime:0.0003s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0044s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0043s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187930 AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY code asc) AS ROW_NUMBER FROM (SELECT a.id,a.code,a2.alias,isnull(a2.continent,'') + isnull(a2.controy,'') + isnull(a2.province,'')+ isnull(a2.city,'') + isnull(a2.district,'') as AreaName FROM tct_area a INNER JOIN TCT_area2 as a2 ON a.id = a2.A_id WHERE a2.LG_id = 6 AND a.WS_id = 7 AND a.id IN ('264313') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_area] WHERE [parent] = 264313 ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [P_id] FROM [tct_pagerelation] WHERE [TO_id] IN ('264313') AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY recom desc, createtime asc) AS ROW_NUMBER FROM (SELECT * FROM tct_page d WHERE [WS_id] = 7 AND [published] = 2 AND ( pageType = 3 and isNull(isDelete, 0) <> 1 ) AND [id] IN ('187647','187642','187639','187744','187740','187733','187728','187722','187947','187944','187941','187938','187937','187933','187930','187917','187953') ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 8) [ RunTime:0.0006s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0041s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187930 AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY code asc) AS ROW_NUMBER FROM (SELECT a.id,a.code,a2.alias,isnull(a2.continent,'') + isnull(a2.controy,'') + isnull(a2.province,'')+ isnull(a2.city,'') + isnull(a2.district,'') as AreaName FROM tct_area a INNER JOIN TCT_area2 as a2 ON a.id = a2.A_id WHERE a2.LG_id = 6 AND a.WS_id = 7 AND a.id IN ('264313') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_area] WHERE [parent] = 264313 ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
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 = 'tct_area2' [ RunTime:0.0003s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [alias] FROM [tct_area2] WHERE [A_id] = 264313 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT a.id,a2.alias,isnull(a2.continent,'') + isnull(a2.controy,'') + isnull(a2.province,'')+ isnull(a2.city,'') + isnull(a2.district,'') as AreaName FROM tct_area a INNER JOIN TCT_area2 as a2 ON a.id = a2.A_id WHERE a2.LG_id = 6 AND [WS_id] = 7 AND a2.alias IN ('chongqing') ) AS thinkphp) AS T1 [ RunTime:0.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY day asc) AS ROW_NUMBER FROM (SELECT d.id,d.title,d.picUrl,d.pageUrl,d.recom,CAST(CAST(r_1.extValue AS varchar) AS int) AS day FROM tct_page d INNER JOIN TCT_pagerelation as r on d.id = r.p_id INNER JOIN TCT_pageextend as r_1 on r_1.p_id = d.id and r_1.extKey = 'tour_days' WHERE [WS_id] = 7 AND [relationType] = 'Area' AND [published] = 2 AND [pageType] IN (1,2,18) AND ( [TO_id] IN ('264313') ) AND isNull(isDelete, 0) <> 1 AND CAST(CAST(r_1.extValue AS varchar) AS int) BETWEEN '0' AND '99' GROUP BY d.id, d.title, d.picUrl, d.pageUrl, d.recom, CAST(CAST(r_1.extValue AS varchar) AS int) ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 20) [ RunTime:0.0057s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187639 ) AS thinkphp) AS T1 [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264313') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
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 = 'tct_pageextend' [ RunTime:0.0003s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187639 ) AS thinkphp) AS T1 [ RunTime:0.0010s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187642 ) AS thinkphp) AS T1 [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264312',' 264313') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187642 ) AS thinkphp) AS T1 [ RunTime:0.0010s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187647 ) AS thinkphp) AS T1 [ RunTime:0.0007s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264308',' 264313') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187647 ) AS thinkphp) AS T1 [ RunTime:0.0011s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187722 ) AS thinkphp) AS T1 [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264304',' 264306',' 264313',' 264309') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187722 ) AS thinkphp) AS T1 [ RunTime:0.0010s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187728 ) AS thinkphp) AS T1 [ RunTime:0.0008s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264304',' 264306',' 264307',' 264313',' 264309') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187728 ) AS thinkphp) AS T1 [ RunTime:0.0010s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187740 ) AS thinkphp) AS T1 [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264304',' 264306',' 264315',' 264313',' 264309') ) AS thinkphp) AS T1 [ RunTime:0.0003s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187740 ) AS thinkphp) AS T1 [ RunTime:0.0011s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187744 ) AS thinkphp) AS T1 [ RunTime:0.0007s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264304',' 264306',' 264312',' 264313',' 264309') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187744 ) AS thinkphp) AS T1 [ RunTime:0.0011s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187733 ) AS thinkphp) AS T1 [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 7 AND [id] IN ('264304',' 264306',' 264307',' 264320',' 264313',' 264309') ) AS thinkphp) AS T1 [ RunTime:0.0003s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187733 ) AS thinkphp) AS T1 [ RunTime:0.0012s ]
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 = 'tct_pricemargin' [ RunTime:0.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187639 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0003s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187642 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187647 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187722 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187728 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187740 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187744 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187733 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0053s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187930 AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0007s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY code asc) AS ROW_NUMBER FROM (SELECT a.id,a.code,a2.alias,isnull(a2.continent,'') + isnull(a2.controy,'') + isnull(a2.province,'')+ isnull(a2.city,'') + isnull(a2.district,'') as AreaName FROM tct_area a INNER JOIN TCT_area2 as a2 ON a.id = a2.A_id WHERE a2.LG_id = 6 AND a.WS_id = 7 AND a.id IN ('264313') ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_area] WHERE [parent] = 264313 ) AS thinkphp) AS T1 [ RunTime:0.0002s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [P_id] FROM [tct_pagerelation] WHERE [TO_id] IN ('264313') AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0008s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY recom desc, createtime asc) AS ROW_NUMBER FROM (SELECT * FROM tct_page d WHERE [WS_id] = 7 AND [published] = 2 AND ( pageType = 4 and isNull(isDelete, 0) <> 1 ) AND [id] IN ('187647','187642','187639','187744','187740','187733','187728','187722','187947','187944','187941','187938','187937','187933','187930','187917','187953') ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 8) [ RunTime:0.0008s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 7 AND [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0057s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187930 AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0008s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY code asc) AS ROW_NUMBER FROM (SELECT a.id,a.code,a2.alias,isnull(a2.continent,'') + isnull(a2.controy,'') + isnull(a2.province,'')+ isnull(a2.city,'') + isnull(a2.district,'') as AreaName FROM tct_area a INNER JOIN TCT_area2 as a2 ON a.id = a2.A_id WHERE a2.LG_id = 6 AND a.WS_id = 7 AND a.id IN ('264313') ) AS thinkphp) AS T1 [ RunTime:0.0003s ]
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 = 'tct_personview' [ RunTime:0.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_personview] WHERE [ip] = '216.73.216.8' AND [url] = '/attractions/esculturas-rupestres-dazu.htm' AND [webId] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0557s ]
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 = 'tct_page' [ RunTime:0.0005s ]
UPDATE [tct_page] SET [hits]=hits+1 WHERE [pageUrl] = '/attractions/esculturas-rupestres-dazu.htm' [ RunTime:0.0051s ]
INSERT INTO [tct_personview] ([ip],[url],[webId]) VALUES ('216.73.216.8','/attractions/esculturas-rupestres-dazu.htm','2') [ RunTime:0.0007s ]