SHOW FULL COLUMNS FROM `tj_category_translations` [ RunTime:0.001239s ]
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` = 'en' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.001016s ]
SHOW FULL COLUMNS FROM `tj_products` [ RunTime:0.001010s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_products` `m` INNER JOIN `tj_product_translations` `t` ON `t`.`product_id`=m.id AND t.lang = 'en' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.002550s ]
SHOW FULL COLUMNS FROM `tj_categories` [ RunTime:0.001056s ]
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.000753s ]
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 = 'en' 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.001396s ]
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` = 'en' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `tj_solutions` [ RunTime:0.000970s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_solutions` `m` INNER JOIN `tj_solution_translations` `t` ON `t`.`solution_id`=m.id AND t.lang = 'en' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000422s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (209,210,211,212,213,214) AND `module` = 'solution' [ RunTime:0.000315s ]
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 = 'en' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'solution' AND `c`.`status` = '1' AND `c`.`id` IN ('209','210','211','212','213','214') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000512s ]
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` = 'en' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `tj_news` [ RunTime:0.001004s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_news` `m` INNER JOIN `tj_news_translations` `t` ON `t`.`news_id`=m.id AND t.lang = 'en' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000616s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (4,197,198,199) AND `module` = 'news' [ RunTime:0.000328s ]
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 = 'en' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'news' AND `c`.`status` = '1' AND `c`.`id` IN ('4','197','198','199') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000516s ]
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` = 'en' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000907s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_products` `m` INNER JOIN `tj_product_translations` `t` ON `t`.`product_id`=m.id AND t.lang = 'en' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.002350s ]
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.000695s ]
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 = 'en' 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.001292s ]
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` = 'en' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000401s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_solutions` `m` INNER JOIN `tj_solution_translations` `t` ON `t`.`solution_id`=m.id AND t.lang = 'en' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000362s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (209,210,211,212,213,214) AND `module` = 'solution' [ RunTime:0.000316s ]
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 = 'en' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'solution' AND `c`.`status` = '1' AND `c`.`id` IN ('209','210','211','212','213','214') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000488s ]
SELECT * FROM `tj_categories` WHERE `delete_time` IS NULL AND `module` = 'solution' AND `slug` = 'retail-esl' LIMIT 1 [ RunTime:0.000341s ]
SELECT `path`,`id` FROM `tj_categories` WHERE `module` = 'solution' AND `delete_time` IS NULL AND `status` = 1 [ RunTime:0.000289s ]
SELECT `slug` FROM `tj_categories` WHERE `id` = 209 LIMIT 1 [ RunTime:0.000226s ]
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` = 'en' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000357s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_solutions` `m` INNER JOIN `tj_solution_translations` `t` ON `t`.`solution_id`=m.id AND t.lang = 'en' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000382s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (209,210,211,212,213,214) AND `module` = 'solution' [ RunTime:0.000306s ]
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 = 'en' LEFT JOIN `tj_media` `m` ON `m`.`id`=`c`.`image_media_id` WHERE `c`.`delete_time` IS NULL AND `c`.`module` = 'solution' AND `c`.`status` = '1' AND `c`.`id` IN ('209','210','211','212','213','214') ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.000515s ]
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 = 'en' 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` = '209' ORDER BY `s`.`published_at` DESC,`s`.`id` DESC LIMIT 60 [ RunTime:0.000433s ]
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` = '209' AND `t`.`lang` = 'en' LIMIT 1 [ 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` = 'solution' AND `t`.`lang` = 'en' AND `t`.`status` = '1' AND `t`.`title` <> '' [ RunTime:0.000438s ]
SELECT DISTINCT `m`.`category_id` FROM `tj_solutions` `m` INNER JOIN `tj_solution_translations` `t` ON `t`.`solution_id`=m.id AND t.lang = 'en' WHERE `m`.`delete_time` IS NULL AND `m`.`status` = '1' AND `t`.`status` = '1' [ RunTime:0.000366s ]
SELECT `path` FROM `tj_categories` WHERE `id` IN (209,210,211,212,213,214) AND `module` = 'solution' [ RunTime:0.000318s ]
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 = 'en' 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` = '209' LIMIT 1 [ RunTime:0.000316s ]
English
日本語
Deutsch