SHOW FULL COLUMNS FROM `tj_category_translations` [ RunTime:0.000877s ]
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.000567s ]
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.000295s ]
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.000247s ]
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.000473s ]
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.000263s ]
SHOW FULL COLUMNS FROM `tj_news` [ RunTime:0.000726s ]
SELECT * FROM `tj_news` WHERE `delete_time` IS NULL AND `status` = 1 AND `slug` = 'explaining-10-point-multi-touch-and-why-it-matters' LIMIT 1 [ RunTime:0.000238s ]
SHOW FULL COLUMNS FROM `tj_news_translations` [ RunTime:0.000684s ]
SELECT `t`.`title`,`t`.`summary`,`t`.`content`,`t`.`meta_title`,`t`.`meta_description`,te.title AS title_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_news_translations` `t` LEFT JOIN `tj_news_translations` `te` ON `te`.`news_id`=t.news_id AND te.lang = 'en' WHERE `t`.`news_id` = '27' AND `t`.`lang` = 'ja' LIMIT 1 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `tj_media` [ RunTime:0.000680s ]
SELECT `path` FROM `tj_media` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000170s ]
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.000274s ]
SHOW FULL COLUMNS FROM `tj_categories` [ RunTime:0.000678s ]
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` = '198' LIMIT 1 [ RunTime:0.000267s ]
SELECT `n`.`slug`,`n`.`published_at`,`tf`.`title` FROM `tj_news` `n` LEFT JOIN `tj_news_translations` `tf` ON `tf`.`news_id`=n.id AND tf.lang = 'ja' WHERE `n`.`delete_time` IS NULL AND `n`.`status` = '1' AND `tf`.`status` = '1' AND `n`.`category_id` = '198' AND `n`.`id` <> '27' ORDER BY `n`.`published_at` DESC LIMIT 3 [ RunTime:0.000342s ]
SELECT `lang` FROM `tj_news_translations` WHERE `news_id` = 27 AND `status` = 1 [ RunTime:0.000232s ]
English
日本語
Deutsch