Products (6) - Teejoin

基本文件流程错误 SQL 调试

/www/wwwroot/teejoin-new/public/index.php ( 0.79 KB )
/www/wwwroot/teejoin-new/vendor/autoload.php ( 0.73 KB )
/www/wwwroot/teejoin-new/vendor/composer/autoload_real.php ( 1.63 KB )
/www/wwwroot/teejoin-new/vendor/composer/platform_check.php ( 0.90 KB )
/www/wwwroot/teejoin-new/vendor/composer/ClassLoader.php ( 15.99 KB )
/www/wwwroot/teejoin-new/vendor/composer/autoload_static.php ( 5.11 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/www/wwwroot/teejoin-new/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
/www/wwwroot/teejoin-new/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
/www/wwwroot/teejoin-new/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/App.php ( 14.17 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Container.php ( 15.38 KB )
/www/wwwroot/teejoin-new/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
/www/wwwroot/teejoin-new/app/provider.php ( 0.19 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Http.php ( 6.12 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Env.php ( 4.64 KB )
/www/wwwroot/teejoin-new/app/common.php ( 0.03 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/helper.php ( 18.44 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Config.php ( 5.03 KB )
/www/wwwroot/teejoin-new/config/app.php ( 1.63 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/www/wwwroot/teejoin-new/config/cache.php ( 0.80 KB )
/www/wwwroot/teejoin-new/config/console.php ( 0.35 KB )
/www/wwwroot/teejoin-new/config/cookie.php ( 0.56 KB )
/www/wwwroot/teejoin-new/config/database.php ( 2.22 KB )
/www/wwwroot/teejoin-new/config/filesystem.php ( 0.63 KB )
/www/wwwroot/teejoin-new/config/lang.php ( 0.81 KB )
/www/wwwroot/teejoin-new/config/log.php ( 1.37 KB )
/www/wwwroot/teejoin-new/config/middleware.php ( 0.19 KB )
/www/wwwroot/teejoin-new/config/route.php ( 1.54 KB )
/www/wwwroot/teejoin-new/config/session.php ( 0.63 KB )
/www/wwwroot/teejoin-new/config/trace.php ( 0.34 KB )
/www/wwwroot/teejoin-new/config/translate.php ( 1.08 KB )
/www/wwwroot/teejoin-new/config/view.php ( 0.82 KB )
/www/wwwroot/teejoin-new/app/event.php ( 0.25 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Event.php ( 6.96 KB )
/www/wwwroot/teejoin-new/app/service.php ( 0.13 KB )
/www/wwwroot/teejoin-new/app/AppService.php ( 0.26 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Lang.php ( 7.60 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/lang/zh-cn.php ( 12.88 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/initializer/Error.php ( 3.27 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/www/wwwroot/teejoin-new/vendor/services.php ( 0.18 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/service/ModelService.php ( 1.76 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-multi-app/src/Service.php ( 1.08 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/Paginator.php ( 11.80 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Validate.php ( 46.10 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/Model.php ( 25.67 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 17.61 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.12 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.27 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.70 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.41 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Db.php ( 2.87 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/DbManager.php ( 8.28 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Manager.php ( 3.98 KB )
/www/wwwroot/teejoin-new/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/www/wwwroot/teejoin-new/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-helper/src/helper/Arr.php ( 16.63 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.42 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/cache/Driver.php ( 8.06 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Console.php ( 22.65 KB )
/www/wwwroot/teejoin-new/app/Request.php ( 0.09 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Request.php ( 54.04 KB )
/www/wwwroot/teejoin-new/app/middleware.php ( 0.26 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-multi-app/src/MultiApp.php ( 7.06 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Route.php ( 23.96 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/route/RuleName.php ( 5.33 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/route/Domain.php ( 5.55 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.61 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/route/Rule.php ( 22.85 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/route/RuleItem.php ( 8.81 KB )
/www/wwwroot/teejoin-new/app/index/route/app.php ( 1.81 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/facade/Route.php ( 4.88 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/route/dispatch/Callback.php ( 0.93 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.49 KB )
/www/wwwroot/teejoin-new/app/index/controller/Product.php ( 8.07 KB )
/www/wwwroot/teejoin-new/app/index/BaseController.php ( 21.82 KB )
/www/wwwroot/teejoin-new/app/BaseController.php ( 2.03 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/facade/Cache.php ( 2.02 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/facade/Db.php ( 0.94 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.39 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/PDOConnection.php ( 52.45 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/Connection.php ( 7.67 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.56 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 15.93 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/Builder.php ( 41.58 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/Query.php ( 10.64 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/BaseQuery.php ( 36.47 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 16.06 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.29 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.85 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.22 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.86 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.36 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/log/Channel.php ( 6.54 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/facade/View.php ( 1.71 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/View.php ( 4.41 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-orm/src/db/Raw.php ( 1.39 KB )
/www/wwwroot/teejoin-new/app/index/service/SeoService.php ( 7.61 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-view/src/Think.php ( 8.42 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-template/src/Template.php ( 47.01 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-template/src/template/driver/File.php ( 2.33 KB )
/www/wwwroot/teejoin-new/runtime/index/temp/be7c2b54dc8cbfbd5e5e46d9db52821b.php ( 18.32 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Response.php ( 8.60 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/www/wwwroot/teejoin-new/vendor/topthink/framework/src/think/Cookie.php ( 6.28 KB )
/www/wwwroot/teejoin-new/vendor/topthink/think-trace/src/Html.php ( 4.49 KB )

CONNECT:[ UseTime:0.000301s ] mysql:host=127.0.0.1;port=3306;dbname=new_teejoin;charset=utf8mb4
SHOW FULL COLUMNS FROM `tj_category_translations` [ RunTime:0.000853s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000641s ]
SHOW FULL COLUMNS FROM `tj_products` [ RunTime:0.000755s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_products` `m` INNER JOIN `tj_product_translations` `t` ON `t`.`product_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.001489s ]
SHOW FULL COLUMNS FROM `tj_categories` [ RunTime:0.000723s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (107,104,106,0,102,111,101,108,105,103,109,110,135,137,138,142,145,143,144,147,179,151,149,141,180,165,167,168,178,177,146,148,169,170,171,173,183,184,185,186,187,188,189,190,196,163,191,160,164,162,161,159,153,158,154,157,156,155,175) AND `module` = 'product' [ RunTime:0.000462s ]
SELECT `c`.`id`,`c`.`parent_id`,`c`.`slug`,`t`.`title`,m.path AS img FROM `tj_categories` `c` LEFT JOIN `tj_category_translations` `t` ON `t`.`category_id`=c.id AND t.lang = 'de' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `c`.`status` = '1' AND `c`.`id` IN ('101','102','103','104','105','106','107','108','109','110','111','135','136','137','138','139','141','142','143','144','145','146','147','148','149','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','173','175','176','177','178','179','180','182','183','184','185','186','187','188','189','190','191','196') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.001126s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'solution' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `tj_solutions` [ RunTime:0.000699s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_solutions` `m` INNER JOIN `tj_solution_translations` `t` ON `t`.`solution_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000270s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'news' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `tj_news` [ RunTime:0.000660s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_news` `m` INNER JOIN `tj_news_translations` `t` ON `t`.`news_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000321s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000563s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_products` `m` INNER JOIN `tj_product_translations` `t` ON `t`.`product_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.001425s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (107,104,106,0,102,111,101,108,105,103,109,110,135,137,138,142,145,143,144,147,179,151,149,141,180,165,167,168,178,177,146,148,169,170,171,173,183,184,185,186,187,188,189,190,196,163,191,160,164,162,161,159,153,158,154,157,156,155,175) AND `module` = 'product' [ RunTime:0.000447s ]
SELECT `c`.`id`,`c`.`parent_id`,`c`.`slug`,`t`.`title`,m.path AS img FROM `tj_categories` `c` LEFT JOIN `tj_category_translations` `t` ON `t`.`category_id`=c.id AND t.lang = 'de' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `c`.`status` = '1' AND `c`.`id` IN ('101','102','103','104','105','106','107','108','109','110','111','135','136','137','138','139','141','142','143','144','145','146','147','148','149','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','173','175','176','177','178','179','180','182','183','184','185','186','187','188','189','190','191','196') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000846s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'solution' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000299s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_solutions` `m` INNER JOIN `tj_solution_translations` `t` ON `t`.`solution_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000272s ]
SELECT * FROM `tj_categories` WHERE `delete_time` IS NULL AND `module` = 'product' AND `slug` = 'smart-home-hub' LIMIT 1 [ RunTime:0.000272s ]
SELECT `id` FROM `tj_categories` WHERE `module` = 'product' AND `id` = 111 OR `path` LIKE '0-101-111-%' [ RunTime:0.000252s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000560s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_products` `m` INNER JOIN `tj_product_translations` `t` ON `t`.`product_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.001407s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (107,104,106,0,102,111,101,108,105,103,109,110,135,137,138,142,145,143,144,147,179,151,149,141,180,165,167,168,178,177,146,148,169,170,171,173,183,184,185,186,187,188,189,190,196,163,191,160,164,162,161,159,153,158,154,157,156,155,175) AND `module` = 'product' [ RunTime:0.000472s ]
SELECT `c`.`id`,`c`.`parent_id`,`c`.`slug`,`t`.`title`,te.title AS title_en FROM `tj_categories` `c` LEFT JOIN `tj_category_translations` `t` ON `t`.`category_id`=c.id AND t.lang = 'de' LEFT JOIN `tj_category_translations` `te` ON `te`.`category_id`=c.id AND te.lang = 'en' WHERE `c`.`delete_time` IS NULL AND `c`.`id` = '111' LIMIT 1 [ RunTime:0.000274s ]
SELECT `c`.`id`,`c`.`parent_id`,`c`.`slug`,`t`.`title`,te.title AS title_en FROM `tj_categories` `c` LEFT JOIN `tj_category_translations` `t` ON `t`.`category_id`=c.id AND t.lang = 'de' LEFT JOIN `tj_category_translations` `te` ON `te`.`category_id`=c.id AND te.lang = 'en' WHERE `c`.`delete_time` IS NULL AND `c`.`id` = '101' LIMIT 1 [ RunTime:0.000340s ]
SELECT COUNT(*) AS think_count FROM `tj_products` `p` LEFT JOIN `tj_product_translations` `tf` ON `tf`.`product_id`=p.id AND tf.lang = 'de' WHERE `p`.`delete_time` IS NULL AND `p`.`status` = '1' AND `tf`.`status` = '1' AND `p`.`category_id` = '111' LIMIT 1 [ RunTime:0.000295s ]
SELECT `p`.`id` FROM `tj_products` `p` LEFT JOIN `tj_product_translations` `tf` ON `tf`.`product_id`=p.id AND tf.lang = 'de' WHERE `p`.`delete_time` IS NULL AND `p`.`status` = '1' AND `tf`.`status` = '1' AND `p`.`category_id` = '111' ORDER BY `p`.`sort` ASC,`p`.`id` DESC LIMIT 0,12 [ RunTime:0.000298s ]
SELECT `p`.`id`,`p`.`slug`,`t`.`name`,te.name AS name_en,`t`.`summary`,te.summary AS summary_en,m.path AS img FROM `tj_products` `p` LEFT JOIN `tj_product_translations` `t` ON `t`.`product_id`=p.id AND t.lang = 'de' LEFT JOIN `tj_product_translations` `te` ON `te`.`product_id`=p.id AND te.lang = 'en' LEFT JOIN `tj_media` `m` ON `m`.`id`=`p`.`cover_media_id` WHERE `p`.`id` IN ('9','13','14','280','281','282') ORDER BY FIELD(p.id, 9,13,14,280,281,282) [ RunTime:0.000431s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000564s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_products` `m` INNER JOIN `tj_product_translations` `t` ON `t`.`product_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.001376s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (107,104,106,0,102,111,101,108,105,103,109,110,135,137,138,142,145,143,144,147,179,151,149,141,180,165,167,168,178,177,146,148,169,170,171,173,183,184,185,186,187,188,189,190,196,163,191,160,164,162,161,159,153,158,154,157,156,155,175) AND `module` = 'product' [ RunTime:0.000445s ]
SELECT `c`.`id`,`c`.`parent_id`,`c`.`slug`,`t`.`title`,m.path AS img FROM `tj_categories` `c` LEFT JOIN `tj_category_translations` `t` ON `t`.`category_id`=c.id AND t.lang = 'de' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `c`.`status` = '1' AND `c`.`id` IN ('101','102','103','104','105','106','107','108','109','110','111','135','136','137','138','139','141','142','143','144','145','146','147','148','149','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','173','175','176','177','178','179','180','182','183','184','185','186','187','188','189','190','191','196') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000869s ]
SELECT `t`.`category_id` FROM `tj_category_translations` `t` INNER JOIN `tj_categories` `c` ON `c`.`id`=`t`.`category_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `t`.`lang` = 'de' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000560s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_products` `m` INNER JOIN `tj_product_translations` `t` ON `t`.`product_id`=m.id AND t.lang = 'de' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.001400s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (107,104,106,0,102,111,101,108,105,103,109,110,135,137,138,142,145,143,144,147,179,151,149,141,180,165,167,168,178,177,146,148,169,170,171,173,183,184,185,186,187,188,189,190,196,163,191,160,164,162,161,159,153,158,154,157,156,155,175) AND `module` = 'product' [ RunTime:0.000452s ]
SELECT `c`.`id`,`c`.`parent_id`,`c`.`slug`,`t`.`title`,m.path AS img FROM `tj_categories` `c` LEFT JOIN `tj_category_translations` `t` ON `t`.`category_id`=c.id AND t.lang = 'de' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'product' AND `c`.`status` = '1' AND `c`.`id` IN ('101','102','103','104','105','106','107','108','109','110','111','135','136','137','138','139','141','142','143','144','145','146','147','148','149','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','173','175','176','177','178','179','180','182','183','184','185','186','187','188','189','190','191','196') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000804s ]

smart-home-hub (6)