| 0.0146 |
SELECT *
FROM `language_m`
WHERE `name` = 'english'
LIMIT 1
|
| 0.0686 |
SELECT *
FROM `language_m`
WHERE url like '%/takkyu-navi.jp%'
LIMIT 1
|
| 0.0160 |
SELECT *
FROM `language_m`
WHERE `name` = 'japanese'
LIMIT 1
|
| 0.0434 |
SELECT *
FROM `language_m`
WHERE `name` = 'japanese'
LIMIT 1
|
| 0.0021 |
SELECT *
FROM `language_m`
ORDER BY `id` ASC
|
| 0.0137 |
SELECT *
FROM `language_m`
WHERE `name` = 'japanese'
ORDER BY `id` ASC
|
| 0.0075 |
SELECT `company`.*, `company_language`.`name`, `company_language`.`translate_flag`, `company_language`.`open_racket_top_flag`, `company_language`.`open_rubber_top_flag`
FROM `company`
LEFT JOIN `company_language` ON `company`.`id` = `company_language`.`company_id`
WHERE `company`.`id` = 27
AND `company_language`.`lang` = 2
LIMIT 1
|
| 0.0203 |
SELECT `wear`.*, count(product_id) as player_count, `wear_language`.`name`, `wear_language`.`headline`, `wear_language`.`content`
FROM `wear`
LEFT JOIN `wear_language` ON `wear`.`id` = `wear_language`.`wear_id`
LEFT JOIN `product_player_map` ON `wear`.`id` = `product_player_map`.`product_id` AND `product_player_map`.`genre_id` = 2
WHERE `wear_language`.`open_lang_flag` = 1
AND `company_id` = 27
AND `wear`.`open_flag` = 1
AND `wear`.`delete_flag` = 0
AND `wear_language`.`lang` = 2
GROUP BY `wear`.`id`
ORDER BY `player_count` desc, `all_average` desc, `rank` desc, `id` desc
LIMIT 30, 10
|
| 0.0153 |
SELECT COUNT(*) AS `numrows`
FROM `wear`
LEFT JOIN `wear_language` ON `wear`.`id` = `wear_language`.`wear_id`
WHERE `wear_language`.`open_lang_flag` = 1
AND `company_id` = 27
AND `wear`.`open_flag` = 1
AND `wear`.`delete_flag` = 0
AND `wear_language`.`lang` = 2
|
| 0.0197 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '605'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.1324 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '544'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0202 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '512'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0145 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '511'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0184 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '510'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0168 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '509'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0173 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '472'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0212 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '471'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0125 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '470'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0216 |
SELECT `player`.*, `product_player_map`.`id` as `product_player_map_id`, `product_player_map`.`photo` as `product_player_map_photo`, `player_language`.`name`, `player_language`.`description`, `player_language`.`open_lang_flag`
FROM `product_player_map`
LEFT JOIN `player` ON `player`.`id` = `product_player_map`.`player_id`
LEFT JOIN `player_language` ON `player`.`id` = `player_language`.`player_id`
WHERE `product_player_map`.`genre_id` = '2'
AND `product_player_map`.`product_id` = '468'
AND `player`.`open_flag` = 1
AND `player_language`.`lang` = 2
ORDER BY ISNULL(player.world_ranking), `player`.`world_ranking` ASC, `product_player_map`.`rank` desc, `player`.`rank` desc, `player`.`photo1` DESC, `player`.`photo2` DESC, `player`.`photo3` DESC, `player`.`id` desc
|
| 0.0066 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 605
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0023 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 544
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0130 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 512
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0027 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 511
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0187 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 510
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0370 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 509
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0302 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 472
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0022 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 471
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0211 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 470
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
| 0.0022 |
SELECT `review_wear`.*, `review_wear_language`.`user_name`, `review_wear_language`.`headline`, `review_wear_language`.`content`
FROM `review_wear`
LEFT JOIN `review_wear_language` ON `review_wear`.`id` = `review_wear_language`.`review_id`
WHERE `review_wear`.`wear_id` = 468
AND `review_wear`.`open_flag` = 1
AND `review_wear_language`.`open_lang_flag` = 1
AND `review_wear_language`.`lang` = 2
ORDER BY `review_wear`.`good_point` DESC, `review_wear`.`created` DESC
LIMIT 1
|
