SHOW FULL COLUMNS FROM `tj_category_translations` [ RunTime:0.000894s ]
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` = 'ja' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000521s ]
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` = 'ja' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000310s ]
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` = 'ja' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000248s ]
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` = 'ja' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000480s ]
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` = 'ja' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `tj_categories` [ RunTime:0.000768s ]
SELECT * FROM `tj_categories` WHERE `delete_time` IS NULL AND `module` = 'solution' AND `slug` = 'smart-home-building' LIMIT 1 [ RunTime:0.000253s ]
SELECT `path`,`id` FROM `tj_categories` WHERE `module` = 'solution' AND `delete_time` IS NULL AND `status` = 1 [ RunTime:0.000258s ]
SELECT `slug` FROM `tj_categories` WHERE `id` = 210 LIMIT 1 [ RunTime:0.000167s ]
SHOW FULL COLUMNS FROM `tj_solutions` [ RunTime:0.000710s ]
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` = 'ja' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000303s ]
SELECT `s`.`id`,`s`.`slug`,`s`.`category_id`,`s`.`cover_media_id`,`s`.`published_at`,`tf`.`title`,te.title AS title_en,`tf`.`summary`,te.summary AS summary_en FROM `tj_solutions` `s` LEFT JOIN `tj_solution_translations` `tf` ON `tf`.`solution_id`=s.id AND tf.lang = 'ja' LEFT JOIN `tj_solution_translations` `te` ON `te`.`solution_id`=s.id AND te.lang = 'en' WHERE `s`.`delete_time` IS NULL AND `s`.`status` = '1' AND `tf`.`status` = '1' AND `s`.`category_id` = '210' ORDER BY `s`.`published_at` DESC,`s`.`id` DESC LIMIT 60 [ RunTime:0.000319s ]
SELECT `t`.`title`,`t`.`description`,te.title AS title_en,te.description AS description_en FROM `tj_category_translations` `t` LEFT JOIN `tj_category_translations` `te` ON `te`.`category_id`=t.category_id AND te.lang = 'en' WHERE `t`.`category_id` = '210' AND `t`.`lang` = 'ja' LIMIT 1 [ RunTime:0.000241s ]
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` = 'ja' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000287s ]
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 = 'ja' 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` = '210' LIMIT 1 [ RunTime:0.000239s ]
English
日本語
Deutsch