精通级-Excel函数在商业中的应用

基本文件流程错误 SQL 调试

/data/user/htdocs/public/index.php ( 1.49 KB )
/data/user/htdocs/vendor/autoload.php ( 0.75 KB )
/data/user/htdocs/vendor/composer/autoload_real.php ( 1.63 KB )
/data/user/htdocs/vendor/composer/platform_check.php ( 0.90 KB )
/data/user/htdocs/vendor/composer/ClassLoader.php ( 15.99 KB )
/data/user/htdocs/vendor/composer/autoload_static.php ( 11.07 KB )
/data/user/htdocs/vendor/topthink/think-helper/src/helper.php ( 7.62 KB )
/data/user/htdocs/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.17 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/data/user/htdocs/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.21 KB )
/data/user/htdocs/vendor/symfony/polyfill-php80/bootstrap.php ( 1.54 KB )
/data/user/htdocs/vendor/symfony/polyfill-ctype/bootstrap.php ( 1.56 KB )
/data/user/htdocs/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/data/user/htdocs/vendor/ramsey/uuid/src/functions.php ( 2.31 KB )
/data/user/htdocs/vendor/symfony/polyfill-php72/bootstrap.php ( 1.94 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/helper.php ( 0.01 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Support/helpers.php ( 2.55 KB )
/data/user/htdocs/vendor/overtrue/pinyin/src/const.php ( 0.50 KB )
/data/user/htdocs/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.83 KB )
/data/user/htdocs/vendor/tinify/tinify/lib/Tinify.php ( 2.16 KB )
/data/user/htdocs/vendor/tinify/tinify/lib/Tinify/Exception.php ( 1.11 KB )
/data/user/htdocs/vendor/topthink/think-captcha/src/helper.php ( 1.42 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/App.php ( 14.17 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Container.php ( 15.38 KB )
/data/user/htdocs/vendor/psr/container/src/ContainerInterface.php ( 1.05 KB )
/data/user/htdocs/app/provider.php ( 0.21 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Http.php ( 6.12 KB )
/data/user/htdocs/vendor/topthink/think-helper/src/helper/Str.php ( 7.51 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Env.php ( 4.64 KB )
/data/user/htdocs/app/common.php ( 25.19 KB )
/data/user/htdocs/app/cms/function.php ( 41.92 KB )
/data/user/htdocs/vendor/topthink/framework/src/helper.php ( 18.44 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Config.php ( 5.03 KB )
/data/user/htdocs/config/app.php ( 1.80 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/data/user/htdocs/config/auth.php ( 0.64 KB )
/data/user/htdocs/config/backup.php ( 0.41 KB )
/data/user/htdocs/config/cache.php ( 0.80 KB )
/data/user/htdocs/config/captcha.php ( 1.06 KB )
/data/user/htdocs/config/console.php ( 0.24 KB )
/data/user/htdocs/config/cookie.php ( 0.58 KB )
/data/user/htdocs/config/database.php ( 2.23 KB )
/data/user/htdocs/config/filesystem.php ( 0.66 KB )
/data/user/htdocs/config/lang.php ( 1.02 KB )
/data/user/htdocs/config/log.php ( 1.41 KB )
/data/user/htdocs/config/middleware.php ( 0.20 KB )
/data/user/htdocs/config/route.php ( 1.59 KB )
/data/user/htdocs/config/session.php ( 0.58 KB )
/data/user/htdocs/config/trace.php ( 0.35 KB )
/data/user/htdocs/config/view.php ( 1.30 KB )
/data/user/htdocs/app/event.php ( 0.27 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Event.php ( 6.96 KB )
/data/user/htdocs/app/service.php ( 0.14 KB )
/data/user/htdocs/app/AppService.php ( 0.28 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Lang.php ( 7.60 KB )
/data/user/htdocs/vendor/topthink/framework/src/lang/zh-cn.php ( 12.88 KB )
/data/user/htdocs/app/lang/zh-cn/zh-cn.php ( 81.63 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/initializer/Error.php ( 3.32 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/data/user/htdocs/vendor/services.php ( 0.22 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/service/ModelService.php ( 1.76 KB )
/data/user/htdocs/vendor/topthink/think-captcha/src/CaptchaService.php ( 0.54 KB )
/data/user/htdocs/vendor/topthink/think-multi-app/src/Service.php ( 1.08 KB )
/data/user/htdocs/vendor/topthink/think-trace/src/Service.php ( 0.79 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/Paginator.php ( 12.33 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Validate.php ( 46.10 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/Model.php ( 26.33 KB )
/data/user/htdocs/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.10 KB )
/data/user/htdocs/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.14 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 18.27 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.94 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.35 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.92 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.78 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Db.php ( 2.87 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/DbManager.php ( 8.86 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Manager.php ( 3.98 KB )
/data/user/htdocs/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.16 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/data/user/htdocs/vendor/psr/simple-cache/src/CacheInterface.php ( 4.61 KB )
/data/user/htdocs/vendor/topthink/think-helper/src/helper/Arr.php ( 16.16 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.42 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/cache/Driver.php ( 8.06 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Console.php ( 22.65 KB )
/data/user/htdocs/app/Request.php ( 0.10 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Request.php ( 54.04 KB )
/data/user/htdocs/app/middleware.php ( 0.35 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/data/user/htdocs/vendor/topthink/think-trace/src/TraceDebug.php ( 3.05 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/middleware/LoadLangPack.php ( 3.52 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Cookie.php ( 6.28 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.06 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/session/driver/File.php ( 6.28 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/session/Store.php ( 7.26 KB )
/data/user/htdocs/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.29 KB )
/data/user/htdocs/app/cms/common.php ( 10.03 KB )
/data/user/htdocs/app/cms/config/app.php ( 0.85 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
/data/user/htdocs/app/cms/config/view.php ( 1.68 KB )
/data/user/htdocs/app/cms/provider.php ( 0.83 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Route.php ( 23.96 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/route/RuleName.php ( 5.33 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/route/Domain.php ( 5.55 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.61 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/route/Rule.php ( 22.85 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/route/RuleItem.php ( 8.81 KB )
/data/user/htdocs/app/cms/route/cn_route.php ( 1.52 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/Route.php ( 4.88 KB )
/data/user/htdocs/app/cms/route/ow_route.php ( 1.43 KB )
/data/user/htdocs/app/cms/route/route.php ( 2.27 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 6.61 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.49 KB )
/data/user/htdocs/app/middleware/Redirect.php ( 0.58 KB )
/data/user/htdocs/app/service/RedirectService.php ( 1.00 KB )
/data/user/htdocs/app/cms/controller/Index.php ( 13.69 KB )
/data/user/htdocs/app/cms/controller/Base.php ( 3.71 KB )
/data/user/htdocs/app/BaseController.php ( 8.46 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/Lang.php ( 1.68 KB )
/data/user/htdocs/app/addons/lang/automatically/zh-cn/automatically.php ( 0.65 KB )
/data/user/htdocs/app/addons/lang/generalNotice/zh-cn/generalNotice.php ( 10.66 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/View.php ( 1.71 KB )
/data/user/htdocs/app/model/WebMultiLang.php ( 1.60 KB )
/data/user/htdocs/app/BaseModel.php ( 14.54 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.55 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/PDOConnection.php ( 54.32 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/Connection.php ( 8.01 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.75 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.40 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/Builder.php ( 42.92 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/Query.php ( 11.08 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/BaseQuery.php ( 37.78 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.71 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.38 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 16.61 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.51 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.97 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.74 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.08 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.49 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.61 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/log/Channel.php ( 6.54 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/Session.php ( 1.15 KB )
/data/user/htdocs/app/service/admin/SiteService.php ( 3.35 KB )
/data/user/htdocs/app/service/BaseService.php ( 11.03 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/View.php ( 4.41 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Blade.php ( 10.62 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.71 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/BladeInstance.php ( 6.41 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/BladeInterface.php ( 3.06 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Contracts/View/Factory.php ( 1.45 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Factory.php ( 11.55 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Support/Traits/Macroable.php ( 2.75 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Concerns/ManagesComponents.php ( 3.20 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Concerns/ManagesLayouts.php ( 5.06 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Concerns/ManagesLoops.php ( 2.19 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Concerns/ManagesStacks.php ( 4.25 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Concerns/ManagesTranslations.php ( 0.75 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Engines/EngineResolver.php ( 1.26 KB )
/data/user/htdocs/app/model/system/WebDisableIp.php ( 1.84 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/CacheItem.php ( 4.77 KB )
/data/user/htdocs/app/model/system/WebUrlRedirect.php ( 1.69 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/Cache.php ( 2.02 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/View.php ( 8.51 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Contracts/View/View.php ( 0.53 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Contracts/Support/Renderable.php ( 0.19 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Support/Arr.php ( 14.99 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Support/Str.php ( 25.51 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/BladeCompiler.php ( 14.24 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Compiler.php ( 1.97 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/CompilerInterface.php ( 0.55 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesAuthorizations.php ( 2.45 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesComments.php ( 0.40 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesComponents.php ( 1.48 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesConditionals.php ( 4.72 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesEchos.php ( 3.08 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesErrors.php ( 0.78 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesHelpers.php ( 0.97 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesIncludes.php ( 2.38 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesInjections.php ( 0.49 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesJson.php ( 0.71 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesLayouts.php ( 2.48 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesLoops.php ( 4.34 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesRawPhp.php ( 0.61 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesStacks.php ( 1.24 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Compilers/Concerns/CompilesTranslations.php ( 1.03 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Filesystem/Filesystem.php ( 14.31 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Engines/CompilerEngine.php ( 2.60 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/View/Engines/PhpEngine.php ( 1.65 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Contracts/View/Engine.php ( 0.26 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Support/Collection.php ( 30.04 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Support/Enumerable.php ( 21.30 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Contracts/Support/Arrayable.php ( 0.18 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Contracts/Support/Jsonable.php ( 0.24 KB )
/data/user/htdocs/vendor/isszz/think-blade/src/Support/Traits/EnumeratesValues.php ( 22.66 KB )
/data/user/htdocs/runtime/cms/view/default/bead3addd6f9bdeef2d2e692c827b523cff5c5eb.course-info.blade.php ( 12.20 KB )
/data/user/htdocs/runtime/cms/view/default/e70d6408aedada1d0cd0a3deb318e28e87743ce0.header.blade.php ( 10.33 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/facade/Request.php ( 8.92 KB )
/data/user/htdocs/extend/VieTrue/util/Image.php ( 1.71 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/exception/ErrorException.php ( 1.73 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/facade/Db.php ( 0.97 KB )
/data/user/htdocs/app/model/Other.php ( 0.09 KB )
/data/user/htdocs/vendor/topthink/think-helper/src/Collection.php ( 16.74 KB )
/data/user/htdocs/app/model/cms/CmsColumn.php ( 2.45 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/db/Raw.php ( 1.46 KB )
/data/user/htdocs/vendor/topthink/think-orm/src/model/Collection.php ( 7.05 KB )
/data/user/htdocs/runtime/cms/view/default/a225ca3f19037469a432e24e7c6c6c6ce655b836.jyb.blade.php ( 0.66 KB )
/data/user/htdocs/runtime/cms/view/default/949d5cadcdac4491d0af590dabe422839a89bd4f.footer.blade.php ( 13.21 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/Response.php ( 8.60 KB )
/data/user/htdocs/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/data/user/htdocs/vendor/topthink/think-trace/src/Html.php ( 4.49 KB )

CONNECT:[ UseTime:0.014140s ] mysql:host=sdm723416350.my3w.com;port=3306;dbname=sdm723416350_db;charset=utf8
SHOW FULL COLUMNS FROM `web_multi_lang` [ RunTime:0.467702s ]
SELECT * FROM `web_multi_lang` WHERE `ident` = 'intelligentOffice-1' AND `status` = 1 LIMIT 1 [ RunTime:0.019744s ]
SELECT `ident` FROM `web_multi_lang` WHERE `default` = 1 LIMIT 1 [ RunTime:0.009125s ]
SHOW FULL COLUMNS FROM `cn_web_disable_ip` [ RunTime:0.009670s ]
SHOW FULL COLUMNS FROM `cn_web_url_redirect` [ RunTime:0.009691s ]
SELECT `target_url` FROM `cn_web_url_redirect` WHERE `source_url` = '/intelligentOffice-1/10' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.009276s ]
SELECT `target_url` FROM `cn_web_url_redirect` WHERE `source_url` = '/intelligentOffice-1/10' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.009006s ]
SHOW FULL COLUMNS FROM `cn_web_basic_setting` [ RunTime:0.010081s ]
SELECT * FROM `cn_web_basic_setting` WHERE `field_key` = 'obituary_mode' AND `website_id` IS NULL LIMIT 1 [ RunTime:0.009182s ]
SHOW FULL COLUMNS FROM `other` [ RunTime:0.009689s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009264s ]
SELECT * FROM `cn_web_basic_setting` [ RunTime:0.009325s ]
SHOW FULL COLUMNS FROM `cn_cms_column` [ RunTime:0.012109s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 0 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.011432s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 1 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010098s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 2 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010644s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 2 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009250s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 39 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010370s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 40 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.011348s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 41 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010756s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 3 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010981s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 3 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009276s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 4 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.011678s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 4 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009386s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 5 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010453s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 6 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010172s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 7 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.011237s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 7 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009173s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 8 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.015769s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009064s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.012011s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009061s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 0 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009484s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 1 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009156s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 1 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009585s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 2 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009289s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 2 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009534s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 39 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010028s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 39 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009321s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 40 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009100s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 40 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009072s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 40 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009736s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 41 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009186s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 41 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009194s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 41 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009414s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 3 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009174s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 3 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009776s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 3 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009195s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 4 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009153s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 4 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009148s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 4 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009160s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 5 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009167s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 5 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009141s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 6 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009254s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 6 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009439s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 7 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009204s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 7 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009229s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 7 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009279s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 8 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009446s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 8 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(1, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009251s ]
SHOW FULL COLUMNS FROM `cn_jsjs` [ RunTime:0.010225s ]
SELECT * FROM `cn_jsjs` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( `id`=25 ) ORDER BY `listorder` DESC,`id` DESC [ RunTime:0.009616s ]
SHOW FULL COLUMNS FROM `cn_model_course` [ RunTime:0.010173s ]
SELECT * FROM `cn_model_course` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=42 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.009624s ]
SELECT * FROM `cn_model_course` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=43 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.009708s ]
SELECT * FROM `cn_model_course` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=44 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.009461s ]
SHOW FULL COLUMNS FROM `cn_model_case` [ RunTime:0.009881s ]
SELECT * FROM `cn_model_case` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=5 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.014164s ]
SELECT * FROM `cn_model_case` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=23 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.009689s ]
SELECT * FROM `cn_model_case` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=28 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.010764s ]
SELECT * FROM `cn_model_case` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=5 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.012186s ]
SELECT * FROM `cn_model_case` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=23 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.009327s ]
SELECT * FROM `cn_model_case` WHERE `status` = 1 AND `is_delete` = 0 AND `recycle` = 0 AND `drafts` = 0 AND ( id=28 ) ORDER BY `listorder` DESC,`id` DESC LIMIT 1 [ RunTime:0.009201s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009090s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009069s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009413s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009053s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009025s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009030s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009078s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009017s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009020s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 0 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( (FIND_IN_SET(2, isnav)) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.012664s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 2 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(2, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010591s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 3 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(2, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010647s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 4 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(2, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.010167s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 7 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(2, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.013729s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 0 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( (FIND_IN_SET(2, isnav)) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.009379s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009119s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009437s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009155s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009072s ]
SHOW FULL COLUMNS FROM `cn_web_medium_links` [ RunTime:0.009862s ]
SELECT * FROM `cn_web_medium_links` WHERE `status` = 1 [ RunTime:0.009334s ]
SELECT * FROM `cn_web_basic_setting` [ RunTime:0.013826s ]
SELECT * FROM `cn_web_basic_setting` [ RunTime:0.009126s ]
SELECT `cate`.*,`cus`.`content` FROM `cn_cms_column` `cate` INNER JOIN `cn_cms_column_customs` `cus` ON `cus`.`catid`=`cate`.`id` WHERE `parentid` = 60 AND `cate`.`status` = '1' AND `cate`.`is_delete` = '0' AND ( FIND_IN_SET(2, isnav) ) ORDER BY `cate`.`listorder` DESC,`cate`.`id` DESC [ RunTime:0.012378s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009024s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.008995s ]
SELECT * FROM `other` WHERE `id` = 1 LIMIT 1 [ RunTime:0.009370s ]

精通级-Excel函数在商业中的应用

适合人群

讲师介绍

学习收获

课程目录

1.1 课程概述

2.1 单元格地址灵活锁定

2.2 常见函数错误的分析和处理

2.3 保护和隐藏工作表中的公式

3.1 余额累计里的函数处理思维

3.2 给合并单元格添加序号

3.3 单表求和

3.4 多表求和

3.5 分类汇总函数subtotal

4.1 If-And-Or灵活使用：考勤统计

4.2 If-And-Or多层嵌套的思维整理技巧

4.3 2016版函数ifs

4.4 2016版函数switch

5.1 Countif、Sumif实现多列条件统计

5.2 数据区间的条件统计

5.3“或者”关系的条件统计

5.4 模糊条件统计

5.5 2016版函数minifs-maxifs

5.6 乘积之和Sumproduct

5.7 Sumproduct条件统计

5.8 不重复计数

5.9 Rank、Large、Small对业绩排名次

6.1 超复杂的条件统计轻松解决

6.2 模糊统计里的坑

7.1 区分Vlook精确匹配和模糊匹配

7.2 Vlookup获取查询值的所有相关数据

7.3 Vlookup使用陷阱分析

7.4 如何查找引用照片

7.5 indirect跨多表引用

7.6 Hlookup按行索数据

7.7 一个Lookup搞定多条件查询

7.8 动态数据源范围Offset

8.1 TEXT提取身份证中的出生日期

8.2 利用Find找文本位置

8.3 2016版函数Concat、Textjion

9.1 datedif轻松计算年龄、工龄，精确到多少月多少天

9.2 Networkdays与workday

10.1 认识数组的概念和特性

10.2 数组公式的不同维度运算

10.3 Textjoin根据部门将所有人员姓名放在一个单元格里

10.4 公式里的转置TRANSPOSE

11.1 Get.Cell根据单元格颜色求和

11.2 Get.Workbook批量获取工作表名字

11.3 Files批量提取文件夹里所有文档名字

11.4 Evaluate运算文本算式

12.1 王炸XLOOKUP来袭

12.2 FILTER函数：条件筛选

12.3 Sort函数

12.4 Sortby多条件排序

12.5 UNIQUE函数动态提取唯一值

12.6 SEQUENCE解决单行单列转多行多列问题

12.7 RANDARRAY创建随机数组

13.1 每位员工在部门内部的排名

13.2 Vlookup一对多，返回多个结果

13.3 新旧两表，核对每个单元格数据差异

13.4 跨多表查询

13.5 Sort FILTER筛选最新信息做排序

13.6 特殊排序：Sortby部门按其金额合计排序

13.7 截止日期的余额累计

同类课程推荐

Excel高效数据管理

Excel智能交互仪表板

Excel-Python高效数字化办公

相关案例

零基础Python训练营助力上汽集团办公自动化人才培养

上海市口腔医院“1+1>2”培训融合项目

AI工具赋能训练营—助力世界500强车企高质高效搞定工作

适合人群

讲师介绍

学习收获

相关案例

零基础Python训练营助力上汽集团办公自动化人才培养

上海市口腔医院“1+1>2”培训融合项目

AI工具赋能训练营—助力世界500强车企高质高效搞定工作

如果想进一步了解我们更多信息