Путеводитель по Юньнаню 2025/2026

基本文件流程错误 SQL 调试

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

[8] Use of undefined constant recom - assumed 'recom' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 182 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant picUrl - assumed 'picUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant picDesc - assumed 'picDesc' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Undefined index: picDesc E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 187 行.
[8] Use of undefined constant title - assumed 'title' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 187 行.
[8] Use of undefined constant ext - assumed 'ext' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 191 行.
[8] Use of undefined constant cities - assumed 'cities' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 191 行.
[8] Use of undefined constant ext - assumed 'ext' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 199 行.
[8] Use of undefined constant pricefrom - assumed 'pricefrom' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 199 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 203 行.
[8] Use of undefined constant recom - assumed 'recom' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 182 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant picUrl - assumed 'picUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant picDesc - assumed 'picDesc' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Undefined index: picDesc E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 187 行.
[8] Use of undefined constant title - assumed 'title' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 187 行.
[8] Use of undefined constant ext - assumed 'ext' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 191 行.
[8] Use of undefined constant cities - assumed 'cities' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 191 行.
[8] Use of undefined constant ext - assumed 'ext' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 199 行.
[8] Use of undefined constant pricefrom - assumed 'pricefrom' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 199 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 203 行.
[8] Use of undefined constant recom - assumed 'recom' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 182 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant picUrl - assumed 'picUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant picDesc - assumed 'picDesc' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Undefined index: picDesc E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 185 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 187 行.
[8] Use of undefined constant title - assumed 'title' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 187 行.
[8] Use of undefined constant ext - assumed 'ext' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 191 行.
[8] Use of undefined constant cities - assumed 'cities' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 191 行.
[8] Use of undefined constant ext - assumed 'ext' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 199 行.
[8] Use of undefined constant pricefrom - assumed 'pricefrom' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 199 行.
[8] Use of undefined constant pageUrl - assumed 'pageUrl' E:\web\ru.topchinatravel.com\Application\Runtime\Cache\TopChinaTravel\66978e4b58c8e31878125a81fc93169c.php 第 203 行.

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] = 6 AND [pageUrl] = '/yunnan/' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0121s ]
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] = 187174 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0062s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 6 AND [pageUrl] = '/yunnan/' 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] = 6 AND [pageUrl] = '/yunnan/' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0055s ]
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] = 187174 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0037s ]
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.0008s ]
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.0005s ]
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.0004s ]
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.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_page] WHERE [WS_id] = 6 AND [pageUrl] = '/yunnan/' AND ( isNull(isDelete, 0) <> 1 ) AND [published] = 2 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0052s ]
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 = 5 AND a.WS_id = 6 AND a2.alias = 'yunnan' ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0007s ]
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 = 5 AND a.WS_id = 6 AND a2.alias = 'yunnan' ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_area] WHERE [parent] = 264290 ) AS thinkphp) AS T1 [ RunTime:0.0004s ]
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 ('264290') AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0026s ]
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] = 6 AND [published] = 2 AND ( pageType = 3 and isNull(isDelete, 0) <> 1 ) AND [id] IN ('187243','187294','187303') ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 8) [ RunTime:0.0071s ]
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 = 5 AND a.WS_id = 6 AND a2.alias = 'yunnan' ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_area] WHERE [parent] = 264290 ) AS thinkphp) AS T1 [ RunTime:0.0003s ]
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 ('264290') AND [relationType] = 'Area' ) AS thinkphp) AS T1 [ RunTime:0.0006s ]
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] = 6 AND [published] = 2 AND ( pageType = 4 and isNull(isDelete, 0) <> 1 ) AND [id] IN ('187243','187294','187303') ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 8) [ RunTime:0.0056s ]
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 = 5 AND a.WS_id = 6 AND a2.alias = 'yunnan' ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [tct_area] WHERE [parent] = 264290 ) 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_area2' [ RunTime:0.0006s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [alias] FROM [tct_area2] WHERE [A_id] = 264290 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0004s ]
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 = 5 AND [WS_id] = 6 AND a2.alias IN ('yunnan') ) AS thinkphp) AS T1 [ RunTime:0.0008s ]
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] = 6 AND [relationType] = 'Area' AND [published] = 2 AND [pageType] IN (1,2,18) AND ( [TO_id] IN ('264290') ) 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.0178s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187243 ) AS thinkphp) AS T1 [ RunTime:0.0010s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [deep],[describe] FROM [tct_pagestructure] WHERE [WS_id] = 6 AND [id] IN ('264290') ) AS thinkphp) AS T1 [ RunTime:0.0004s ]
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.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187243 ) 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] = 187294 ) 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] = 6 AND [id] IN ('264290') ) 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] = 187294 ) AS thinkphp) AS T1 [ RunTime:0.0008s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [TO_id] FROM [tct_pagerelation] WHERE [P_id] = 187303 ) 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] = 6 AND [id] IN ('264281',' 264282',' 264283',' 264284',' 264286',' 264288',' 264290') ) AS thinkphp) AS T1 [ RunTime:0.0004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [extKey],[extValue] FROM [tct_pageextend] WHERE [P_id] = 187303 ) AS thinkphp) AS T1 [ RunTime:0.0014s ]
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.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187243 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ 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] = 187294 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [margin],[discount] FROM [tct_pricemargin] WHERE [P_id] = 187303 ) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0003s ]

Путеводитель по Юньнаню

Туры по Юньнань