| 1 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'prefecture' ORDER BY `item_id` ASC | | 48 | 48 | 0 |
| 2 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'blood_type' ORDER BY `item_id` ASC | | 4 | 4 | 0 |
| 3 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'bast_size' ORDER BY `item_id` ASC | | 10 | 10 | 0 |
| 4 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'category' ORDER BY `item_id` ASC | | 8 | 8 | 0 |
| 5 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'type' ORDER BY `item_id` ASC | | 3 | 3 | 0 |
| 6 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'body_type' ORDER BY `item_id` ASC | | 5 | 5 | 0 |
| 7 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'icon' ORDER BY `item_id` ASC | | 4 | 4 | 0 |
| 8 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'type' ORDER BY `item_id` ASC | | 3 | 3 | 0 |
| 9 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'category' ORDER BY `item_id` ASC | | 8 | 8 | 0 |
| 10 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'body_type' ORDER BY `item_id` ASC | | 5 | 5 | 0 |
| 11 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'bast_size' ORDER BY `item_id` ASC | | 10 | 10 | 0 |
| 12 | SELECT `Item`.`item_id`, `Item`.`item_name`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'menu' ORDER BY `item_id` ASC | | 6 | 6 | 0 |
| 13 | SELECT `Review`.`id`, `Review`.`site_id`, `Review`.`name`, `Review`.`satisfaction`, `Review`.`title`, `Review`.`comment`, `Review`.`del_flg`, `Review`.`created`, `Review`.`modified`, `Site`.`id`, `Site`.`title`, `Site`.`url`, `Site`.`price`, `Site`.`settlement`, `Site`.`update_movie`, `Site`.`movie_count`, `Site`.`quality`, `Site`.`freguency`, `Site`.`category_id`, `Site`.`remark`, `Site`.`explanation`, `Site`.`image_path`, `Site`.`del_flg`, `Site`.`created`, `Site`.`modified` FROM `reviews` AS `Review` LEFT JOIN `sites` AS `Site` ON (`Review`.`site_id` = `Site`.`id`) WHERE `Review`.`del_flg` = '1' ORDER BY `Review`.`created` desc LIMIT 5 | | 1 | 1 | 0 |
| 14 | SELECT `ReviewsEvalution`.`id`, `ReviewsEvalution`.`review_id`, `ReviewsEvalution`.`ans_flg`, `ReviewsEvalution`.`created`, `ReviewsEvalution`.`modified` FROM `reviews_evalutions` AS `ReviewsEvalution` WHERE `ReviewsEvalution`.`review_id` = (2) | | 0 | 0 | 0 |
| 15 | SELECT `Information`.`id`, `Information`.`title`, `Information`.`body`, `Information`.`category_id`, `Information`.`del_flg`, `Information`.`created`, `Information`.`modified` FROM `information` AS `Information` WHERE `Information`.`del_flg` = 1 ORDER BY `Information`.`created` desc LIMIT 5 | | 0 | 0 | 0 |
| 16 | SELECT COUNT(*) AS `count` FROM `evaluations` AS `Evaluation` WHERE 1 = 1 | | 1 | 1 | 0 |
| 17 | SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE 1 = 1 | | 1 | 1 | 0 |
| 18 | SELECT COUNT(*) AS `count` FROM `sites` AS `Site` WHERE `del_flg` = '1' | | 1 | 1 | 0 |
| 19 | SELECT COUNT(*) AS `count` FROM `upload_images` AS `UploadImage` WHERE `UploadImage`.`del_flg` = '1' | | 1 | 1 | 0 |
| 20 | SELECT COUNT(*) AS `count` FROM `actresses` AS `Actress` WHERE 1 = 1 | | 1 | 1 | 0 |
| 21 | SELECT `Top`.`id`, `Top`.`movie_url`, `Top`.`image1`, `Top`.`image1_url`, `Top`.`image2`, `Top`.`image2_url`, `Top`.`image3`, `Top`.`image3_url`, `Top`.`image4`, `Top`.`image4_url`, `Top`.`image5`, `Top`.`image5_url`, `Top`.`image6`, `Top`.`image6_url`, `Top`.`created`, `Top`.`modified`, `Top`.`links_url` FROM `tops` AS `Top` WHERE 1 = 1 | | 0 | 0 | 0 |
| 22 | SELECT COUNT(*) AS `count` FROM `actresses` AS `Actress` WHERE `Actress`.`del_flg` = '1' | | 1 | 1 | 0 |
| 23 | SELECT * FROM `actresses` AS `Actress` INNER JOIN actresscounts AS `Actresscount` ON (`Actress`.`id` = `Actresscount`.`actress_id`) WHERE `Actress`.`del_flg` = '1' ORDER BY `Actresscount`.`count` DESC, `Actress`.`id` ASC LIMIT 10 | | 1 | 1 | 0 |
| 24 | SELECT COUNT(*) AS `count` FROM `actresses` AS `Actress` WHERE `Actress`.`del_flg` = '1' AND substr(`Actress`.`kana`,1,1) between "わ" and "ん" | 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(`Actress`.`kana`,1,1) between "わ" and "ん"' at line 1 | | | 0 |
| 25 | SELECT * FROM `actresses` AS `Actress` INNER JOIN actresscounts AS `Actresscount` ON (`Actress`.`id` = `Actresscount`.`actress_id`) WHERE `Actress`.`del_flg` = '1' AND `Actress`.`kana` LIKE 'わ%' ORDER BY `Actresscount`.`count` DESC, `Actress`.`id` ASC LIMIT 20 | | 0 | 0 | 1 |
| 26 | SELECT * FROM `actresses` AS `Actress` INNER JOIN actresscounts AS `Actresscount` ON (`Actress`.`id` = `Actresscount`.`actress_id`) WHERE `Actress`.`del_flg` = '1' AND `Actress`.`kana` LIKE 'を%' ORDER BY `Actresscount`.`count` DESC, `Actress`.`id` ASC LIMIT 20 | | 0 | 0 | 0 |
| 27 | SELECT * FROM `actresses` AS `Actress` INNER JOIN actresscounts AS `Actresscount` ON (`Actress`.`id` = `Actresscount`.`actress_id`) WHERE `Actress`.`del_flg` = '1' AND `Actress`.`kana` LIKE 'ん%' ORDER BY `Actresscount`.`count` DESC, `Actress`.`id` ASC LIMIT 20 | | 0 | 0 | 0 |
