SHOW FULL COLUMNS FROM `tj_category_translations` [ RunTime:0.001249s ]
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.000860s ]
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.000476s ]
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.000369s ]
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.000833s ]
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.000377s ]
SHOW FULL COLUMNS FROM `tj_products` [ RunTime:0.001107s ]
SELECT * FROM `tj_products` `p` WHERE `p`.`delete_time` IS NULL AND `p`.`status` = '1' AND `p`.`slug` = 'e-ink-display-7-8-inch-boox-7-5-inch-nfc-e-ink-display-custom-factory-esl-wireless-electronic-shelf--180' LIMIT 1 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `tj_product_translations` [ RunTime:0.001015s ]
SELECT `t`.`name`,`t`.`summary`,`t`.`content`,`t`.`meta_title`,`t`.`meta_description`,te.name AS name_en,te.summary AS summary_en,te.content AS content_en,te.meta_title AS meta_title_en,te.meta_description AS meta_description_en FROM `tj_product_translations` `t` LEFT JOIN `tj_product_translations` `te` ON `te`.`product_id`=t.product_id AND te.lang = 'en' WHERE `t`.`product_id` = '180' AND `t`.`lang` = 'ja' LIMIT 1 [ RunTime:0.000400s ]
SHOW FULL COLUMNS FROM `tj_product_images` [ RunTime:0.000870s ]
SELECT m.path AS img,`m`.`filename` FROM `tj_product_images` `pi` LEFT JOIN `tj_media` `m` ON `m`.`id`=`pi`.`media_id` WHERE `pi`.`product_id` = '180' ORDER BY `pi`.`sort` ASC,`pi`.`id` ASC [ RunTime:0.000369s ]
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.000748s ]
SHOW FULL COLUMNS FROM `tj_categories` [ RunTime:0.001460s ]
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` = '149' LIMIT 1 [ RunTime:0.000399s ]
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` = '142' LIMIT 1 [ RunTime:0.000357s ]
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` = '139' LIMIT 1 [ RunTime:0.000362s ]
SELECT `lang` FROM `tj_product_translations` WHERE `product_id` = 180 AND `status` = 1 [ RunTime:0.000267s ]
English
日本語
Deutsch