SHOW FULL COLUMNS FROM `tj_category_translations` [ RunTime:0.000882s ]
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.000707s ]
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.000280s ]
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.000279s ]
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.000458s ]
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.000252s ]
SHOW FULL COLUMNS FROM `tj_categories` [ RunTime:0.000706s ]
SELECT * FROM `tj_categories` WHERE `delete_time` IS NULL AND `module` = 'product' AND `slug` = '13-3-inch-esl' LIMIT 1 [ RunTime:0.000258s ]
SELECT `id` FROM `tj_categories` WHERE `module` = 'product' AND `id` = 173 OR `path` LIKE '0-139-142-173-%' [ RunTime:0.000244s ]
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 `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` = '173' LIMIT 1 [ RunTime:0.000246s ]
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.000245s ]
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.000231s ]
SHOW FULL COLUMNS FROM `tj_products` [ RunTime:0.000713s ]
SELECT COUNT(*) AS think_count FROM `tj_products` `p` LEFT JOIN `tj_product_translations` `tf` ON `tf`.`product_id`=p.id AND tf.lang = 'ja' WHERE `p`.`delete_time` IS NULL AND `p`.`status` = '1' AND `tf`.`status` = '1' AND `p`.`category_id` = '173' LIMIT 1 [ RunTime:0.000266s ]
SELECT `p`.`id` FROM `tj_products` `p` LEFT JOIN `tj_product_translations` `tf` ON `tf`.`product_id`=p.id AND tf.lang = 'ja' WHERE `p`.`delete_time` IS NULL AND `p`.`status` = '1' AND `tf`.`status` = '1' AND `p`.`category_id` = '173' ORDER BY `p`.`sort` ASC,`p`.`id` DESC LIMIT 0,12 [ RunTime:0.000292s ]
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.000436s ]
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.000460s ]