AI 智搜 · 智慧图库

基本文件流程错误 SQL 调试

D:\www\thinkcmf8q\public\index.php ( 1.05 KB )
D:\www\thinkcmf8q\vendor\autoload.php ( 0.73 KB )
D:\www\thinkcmf8q\vendor\composer\autoload_real.php ( 1.63 KB )
D:\www\thinkcmf8q\vendor\composer\platform_check.php ( 0.90 KB )
D:\www\thinkcmf8q\vendor\composer\ClassLoader.php ( 15.99 KB )
D:\www\thinkcmf8q\vendor\composer\autoload_static.php ( 9.62 KB )
D:\www\thinkcmf8q\vendor\topthink\think-helper\src\helper.php ( 7.77 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\stubs\load_stubs.php ( 0.16 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Exception.php ( 1.69 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Facade.php ( 2.71 KB )
D:\www\thinkcmf8q\vendor\ezyang\htmlpurifier\library\HTMLPurifier.composer.php ( 0.10 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\common.php ( 69.14 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\App.php ( 17.72 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Container.php ( 15.39 KB )
D:\www\thinkcmf8q\vendor\psr\container\src\ContainerInterface.php ( 1.02 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-app\src\provider.php ( 0.24 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\Http.php ( 7.16 KB )
D:\www\thinkcmf8q\vendor\topthink\think-helper\src\helper\Str.php ( 7.28 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Env.php ( 4.68 KB )
D:\www\thinkcmf8q\app\common.php ( 5.39 KB )
D:\www\thinkcmf8q\app\collector\common.php ( 4.43 KB )
D:\www\thinkcmf8q\app\tools\common.php ( 5.95 KB )
D:\www\thinkcmf8q\app\imagelib\common.php ( 9.72 KB )
D:\www\thinkcmf8q\app\activity\common.php ( 4.11 KB )
D:\www\thinkcmf8q\app\exhibition\common.php ( 2.28 KB )
D:\www\thinkcmf8q\app\travel\common.php ( 4.73 KB )
D:\www\thinkcmf8q\app\magazine\common.php ( 1.86 KB )
D:\www\thinkcmf8q\app\dhall\common.php ( 4.93 KB )
D:\www\thinkcmf8q\app\interactive\common.php ( 3.53 KB )
D:\www\thinkcmf8q\app\multisite\common.php ( 13.00 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\helper.php ( 18.47 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Config.php ( 4.62 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\config\app.php ( 1.35 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\facade\Env.php ( 1.67 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\config\cache.php ( 0.80 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\config\console.php ( 1.10 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\config\log.php ( 1.37 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\config\route.php ( 1.54 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\config\template.php ( 0.64 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\config\view.php ( 1.06 KB )
D:\www\thinkcmf8q\config\captcha.php ( 0.69 KB )
D:\www\thinkcmf8q\config\gallery.php ( 1.62 KB )
D:\www\thinkcmf8q\data\config\database.php ( 2.40 KB )
D:\www\thinkcmf8q\data\config\template.php ( 0.11 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-app\src\event.php ( 0.55 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Event.php ( 6.97 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Lang.php ( 7.22 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\lang\zh-cn.php ( 13.27 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\listener\InitHookListener.php ( 2.53 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\facade\Route.php ( 4.68 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\Route.php ( 23.46 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\route\RuleName.php ( 5.34 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\route\Domain.php ( 5.53 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\route\RuleGroup.php ( 13.42 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\route\Rule.php ( 23.63 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\route\RuleItem.php ( 9.19 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\facade\Cache.php ( 2.06 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Cache.php ( 4.91 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Manager.php ( 3.92 KB )
D:\www\thinkcmf8q\vendor\psr\simple-cache\src\CacheInterface.php ( 4.71 KB )
D:\www\thinkcmf8q\vendor\topthink\think-helper\src\helper\Arr.php ( 16.08 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\cache\driver\File.php ( 7.60 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\cache\Driver.php ( 8.17 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\contract\CacheHandlerInterface.php ( 1.99 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\facade\Db.php ( 0.93 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Db.php ( 2.88 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\DbManager.php ( 8.33 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Log.php ( 6.27 KB )
D:\www\thinkcmf8q\vendor\psr\log\src\LoggerInterface.php ( 2.71 KB )
D:\www\thinkcmf8q\vendor\psr\log\src\LoggerTrait.php ( 2.69 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\connector\Mysql.php ( 4.33 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\PDOConnection.php ( 51.60 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\Connection.php ( 8.79 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\ConnectionInterface.php ( 4.86 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\builder\Mysql.php ( 16.56 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\Builder.php ( 22.26 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\BaseBuilder.php ( 27.29 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\Query.php ( 14.21 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\BaseQuery.php ( 41.17 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\TimeFieldQuery.php ( 7.43 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\AggregateQuery.php ( 3.26 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\ModelRelationQuery.php ( 18.93 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\ParamsBind.php ( 3.66 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\ResultOperation.php ( 6.64 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\Transaction.php ( 2.77 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\WhereQuery.php ( 17.77 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\JoinAndViewQuery.php ( 6.98 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\concern\TableFieldInfo.php ( 2.46 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\log\driver\File.php ( 6.17 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\contract\LogHandlerInterface.php ( 0.86 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\log\Channel.php ( 3.88 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\event\LogRecord.php ( 0.86 KB )
D:\www\thinkcmf8q\vendor\topthink\think-helper\src\Collection.php ( 16.48 KB )
D:\www\thinkcmf8q\vendor\topthink\think-helper\src\contract\Arrayable.php ( 0.09 KB )
D:\www\thinkcmf8q\vendor\topthink\think-helper\src\contract\Jsonable.php ( 0.13 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\initializer\Error.php ( 3.27 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\initializer\RegisterService.php ( 1.33 KB )
D:\www\thinkcmf8q\vendor\services.php ( 0.22 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\service\PaginatorService.php ( 1.52 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Service.php ( 1.64 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\service\ValidateService.php ( 0.99 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\service\ModelService.php ( 1.75 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-appstore\src\AppStoreService.php ( 1.09 KB )
D:\www\thinkcmf8q\vendor\topthink\think-trace\src\Service.php ( 0.77 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Middleware.php ( 6.65 KB )
D:\www\thinkcmf8q\vendor\xia\migration\src\Service.php ( 1.97 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\initializer\BootService.php ( 0.77 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\Paginator.php ( 11.67 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Validate.php ( 46.72 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\Model.php ( 26.64 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\concern\Attribute.php ( 18.43 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\concern\RelationShip.php ( 26.41 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\concern\ModelEvent.php ( 2.24 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\concern\TimeStamp.php ( 5.69 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\concern\AutoWriteId.php ( 1.44 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\concern\Conversion.php ( 10.86 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\Console.php ( 22.69 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Request.php ( 54.47 KB )
D:\www\thinkcmf8q\app\middleware.php ( 0.54 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-app\src\middleware.php ( 0.25 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Pipeline.php ( 2.61 KB )
D:\www\thinkcmf8q\vendor\topthink\think-trace\src\TraceDebug.php ( 2.94 KB )
D:\www\thinkcmf8q\app\http\middleware\SmartTemplateSwitch.php ( 8.34 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\facade\Cookie.php ( 1.48 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Cookie.php ( 5.97 KB )
D:\www\thinkcmf8q\app\multisite\service\ChannelResolveService.php ( 8.92 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\facade\Config.php ( 1.37 KB )
D:\www\thinkcmf8q\app\http\middleware\CorsMiddleware.php ( 2.14 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\middleware\LangDetect.php ( 5.77 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\middleware\SessionInit.php ( 1.94 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Session.php ( 1.80 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\session\driver\File.php ( 6.27 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\contract\SessionHandlerInterface.php ( 0.87 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\session\Store.php ( 7.06 KB )
D:\www\thinkcmf8q\data\route\route.php ( 0.32 KB )
D:\www\thinkcmf8q\route\activity.php ( 2.21 KB )
D:\www\thinkcmf8q\route\api.php ( 8.38 KB )
D:\www\thinkcmf8q\route\contest.php ( 2.26 KB )
D:\www\thinkcmf8q\route\dhall.php ( 1.91 KB )
D:\www\thinkcmf8q\route\exhibition.php ( 3.13 KB )
D:\www\thinkcmf8q\route\interactive.php ( 1.32 KB )
D:\www\thinkcmf8q\route\magazine.php ( 2.04 KB )
D:\www\thinkcmf8q\route\member.php ( 0.73 KB )
D:\www\thinkcmf8q\route\multisite.php ( 4.71 KB )
D:\www\thinkcmf8q\route\portal.php ( 0.67 KB )
D:\www\thinkcmf8q\route\space.php ( 4.83 KB )
D:\www\thinkcmf8q\route\tools.php ( 6.80 KB )
D:\www\thinkcmf8q\route\tourmap.php ( 1.31 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\route\dispatch\Url.php ( 3.59 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\route\dispatch\Controller.php ( 7.52 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\route\Dispatch.php ( 6.07 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\listener\ModuleInitListener.php ( 2.14 KB )
D:\www\thinkcmf8q\app\imagelib\event.php ( 0.19 KB )
D:\www\thinkcmf8q\app\imagelib\controller\SearchController.php ( 5.04 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\controller\HomeBaseController.php ( 11.21 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\controller\BaseController.php ( 10.69 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\View.php ( 4.99 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\facade\Event.php ( 1.79 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\view\driver\Think.php ( 8.42 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\Template.php ( 53.66 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\template\driver\File.php ( 2.33 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\listener\HomeLangListener.php ( 3.32 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\facade\Session.php ( 1.79 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\lang\zh-cn.php ( 6.92 KB )
D:\www\thinkcmf8q\app\demo\lang\zh-cn\common.php ( 0.08 KB )
D:\www\thinkcmf8q\app\portal\lang\zh-cn\common.php ( 0.76 KB )
D:\www\thinkcmf8q\app\portal - 20260320\lang\zh-cn\common.php ( 0.76 KB )
D:\www\thinkcmf8q\app\demo\lang\zh-cn\home.php ( 0.62 KB )
D:\www\thinkcmf8q\app\portal\lang\zh-cn\home.php ( 0.62 KB )
D:\www\thinkcmf8q\app\portal - 20260320\lang\zh-cn\home.php ( 0.62 KB )
D:\www\thinkcmf8q\app\imagelib\model\ImageModel.php ( 4.94 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\concern\SoftDelete.php ( 5.87 KB )
D:\www\thinkcmf8q\app\imagelib\model\CategoryModel.php ( 3.91 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\Raw.php ( 1.22 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\db\Fetch.php ( 13.25 KB )
D:\www\thinkcmf8q\vendor\topthink\think-orm\src\model\Collection.php ( 6.65 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\src\paginator\Bootstrap.php ( 7.37 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-app\src\admin\model\ThemeModel.php ( 12.28 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-app\src\admin\model\ThemeFileModel.php ( 1.91 KB )
D:\www\thinkcmf8q\data\runtime\temp\zh-cn_1b289c65006628939ae659bb83ad76dc.php ( 19.92 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-app\src\admin\model\RouteModel.php ( 8.92 KB )
D:\www\thinkcmf8q\app\demo\url.php ( 1.55 KB )
D:\www\thinkcmf8q\app\portal\url.php ( 1.55 KB )
D:\www\thinkcmf8q\app\portal - 20260320\url.php ( 1.55 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf-app\src\user\url.php ( 0.99 KB )
D:\www\thinkcmf8q\vendor\thinkcmf\cmf\think\route\Url.php ( 16.58 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\Response.php ( 8.65 KB )
D:\www\thinkcmf8q\vendor\topthink\framework\src\think\response\Html.php ( 0.97 KB )
D:\www\thinkcmf8q\vendor\topthink\think-trace\src\Html.php ( 4.37 KB )

CONNECT:[ UseTime:0.000775s ] mysql:host=127.0.0.1;port=3306;dbname=yzcmf8;charset=utf8mb4
SHOW FULL COLUMNS FROM `cmf_hook` [ RunTime:0.001766s ]
SELECT `hook`,`id` FROM `cmf_hook` WHERE ( ( `app` = '' OR `app` = 'cmf' ) AND `type` = 3 ) OR `type` = 1 [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.001458s ]
SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image','user_login_start') ORDER BY `list_order` ASC [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `cmf_imagelib_album` [ RunTime:0.002964s ]
SELECT `id` FROM `cmf_imagelib_album` WHERE ( `deleted_at` IS NOT NULL OR `status` <> 2 ) [ RunTime:0.008000s ]
SHOW FULL COLUMNS FROM `cmf_imagelib_category` [ RunTime:0.002390s ]
SELECT `id` FROM `cmf_imagelib_category` WHERE `parent_id` = 78 [ RunTime:0.000384s ]
SHOW FULL COLUMNS FROM `cmf_imagelib_image` [ RunTime:0.004555s ]
SHOW FULL COLUMNS FROM `cmf_imagelib_image_tag` [ RunTime:0.002057s ]
SELECT COUNT(*) AS think_count FROM `cmf_imagelib_image` WHERE ( `status` = 2 AND `category_id` NOT IN (53,84,85,66,86) AND `album_id` NOT IN (8272,8273,8274) AND `album_id` NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,33,34,35,57,60,118,119,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135,136,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019,9020,9021,9022,9023,9024,9025,9050) AND `access_level` = 1 AND ( ( `title` LIKE '%海洋%' AND ( JSON_SEARCH(COALESCE(ai_keywords,'[]'), 'one', '海洋') IS NOT NULL ) AND EXISTS ( SELECT * FROM `cmf_imagelib_image_tag` `it` INNER JOIN `cmf_imagelib_tag` `t` ON `t`.`id`=`it`.`tag_id` WHERE ( it.image_id = cmf_imagelib_image.id ) AND `t`.`name` LIKE '%海洋%' ) OR `ai_description` LIKE '%海洋%' OR `ai_scene` LIKE '%海洋%' OR `author` LIKE '%海洋%' ) ) AND `category_id` = 78 ) AND `cmf_imagelib_image`.`deleted_at` IS NULL [ RunTime:0.021842s ]
SELECT COUNT(*) AS think_count FROM `cmf_imagelib_image` WHERE ( `status` = 2 AND `category_id` NOT IN (53,84,85,66,86) AND `album_id` NOT IN (8272,8273,8274) AND `album_id` NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,33,34,35,57,60,118,119,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135,136,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019,9020,9021,9022,9023,9024,9025,9050) AND `access_level` = 1 AND ( ( `title` LIKE '%海洋%' AND ( JSON_SEARCH(COALESCE(ai_keywords,'[]'), 'one', '海洋') IS NOT NULL ) AND EXISTS ( SELECT * FROM `cmf_imagelib_image_tag` `it` INNER JOIN `cmf_imagelib_tag` `t` ON `t`.`id`=`it`.`tag_id` WHERE ( it.image_id = cmf_imagelib_image.id ) AND `t`.`name` LIKE '%海洋%' ) OR `ai_description` LIKE '%海洋%' OR `ai_scene` LIKE '%海洋%' OR `author` LIKE '%海洋%' ) ) AND `category_id` = 78 ) AND `cmf_imagelib_image`.`deleted_at` IS NULL [ RunTime:0.014277s ]
SELECT * FROM `cmf_imagelib_image` WHERE ( `status` = 2 AND `category_id` NOT IN (53,84,85,66,86) AND `album_id` NOT IN (8272,8273,8274) AND `album_id` NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,33,34,35,57,60,118,119,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135,136,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019,9020,9021,9022,9023,9024,9025,9050) AND `access_level` = 1 AND ( ( `title` LIKE '%海洋%' AND ( JSON_SEARCH(COALESCE(ai_keywords,'[]'), 'one', '海洋') IS NOT NULL ) AND EXISTS ( SELECT * FROM `cmf_imagelib_image_tag` `it` INNER JOIN `cmf_imagelib_tag` `t` ON `t`.`id`=`it`.`tag_id` WHERE ( it.image_id = cmf_imagelib_image.id ) AND `t`.`name` LIKE '%海洋%' ) OR `ai_description` LIKE '%海洋%' OR `ai_scene` LIKE '%海洋%' OR `author` LIKE '%海洋%' ) ) AND `category_id` = 78 ) AND `cmf_imagelib_image`.`deleted_at` IS NULL ORDER BY `id` DESC LIMIT 0,24 [ RunTime:0.023943s ]
SELECT `title`,`view_count`,`image_count`,`id` FROM `cmf_imagelib_album` WHERE `id` = 8401 [ RunTime:0.000394s ]
SELECT * FROM `cmf_imagelib_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort_order` ASC LIMIT 50 [ RunTime:0.000831s ]
SELECT `id` FROM `cmf_imagelib_album` WHERE ( `deleted_at` IS NOT NULL OR `status` <> 2 ) [ RunTime:0.007765s ]
SELECT `source_code` FROM `cmf_imagelib_image` WHERE ( `status` = 2 AND `category_id` NOT IN (53,84,85,66,86) AND `album_id` NOT IN (8272,8273,8274) AND `album_id` NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,33,34,35,57,60,118,119,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135,136,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019,9020,9021,9022,9023,9024,9025,9050) AND `source_code` <> '' ) AND `cmf_imagelib_image`.`deleted_at` IS NULL GROUP BY `source_code` [ RunTime:0.155499s ]
SELECT `id` FROM `cmf_imagelib_album` WHERE ( `deleted_at` IS NOT NULL OR `status` <> 2 ) [ RunTime:0.007759s ]
SELECT `ai_scene` FROM `cmf_imagelib_image` WHERE ( `status` = 2 AND `category_id` NOT IN (53,84,85,66,86) AND `album_id` NOT IN (8272,8273,8274) AND `album_id` NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,33,34,35,57,60,118,119,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135,136,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019,9020,9021,9022,9023,9024,9025,9050) AND `ai_scene` <> '' ) AND `cmf_imagelib_image`.`deleted_at` IS NULL GROUP BY `ai_scene` ORDER BY count(*) desc LIMIT 20 [ RunTime:0.184194s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.003020s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'lynx_pc' [ RunTime:0.000532s ]
SHOW FULL COLUMNS FROM `cmf_theme` [ RunTime:0.002430s ]
UPDATE `cmf_theme` SET `name` = 'Lynx PC 中文' , `version` = '1.0.0' , `demo_url` = '' , `author` = 'Lynx Team' , `lang` = 'zh-cn' , `description` = 'PC端中文模板' , `keywords` = 'photography,contest,pc,chinese' WHERE `theme` = 'lynx_pc' [ RunTime:0.000416s ]
SELECT `more`,`file`,`id`,`is_public` FROM `cmf_theme_file` WHERE `theme` = 'lynx_pc' AND ( `is_public` = 1 OR `file` = 'imagelib/search/index' ) ORDER BY `is_public` DESC [ RunTime:0.000404s ]

AI 智能检索

《多彩贵州城海洋馆-双双海豚在水中嬉戏》