| 1 | DESCRIBE `actresses` | | 22 | 22 | 0 |
| 2 | DESCRIBE `actresscounts` | | 5 | 5 | 0 |
| 3 | DESCRIBE `upload_images` | | 13 | 13 | 0 |
| 4 | DESCRIBE `sites` | | 16 | 16 | 0 |
| 5 | DESCRIBE `samary_reviews` | | 4 | 4 | 0 |
| 6 | DESCRIBE `evaluations` | | 12 | 12 | 0 |
| 7 | DESCRIBE `evaluation_returns` | | 11 | 11 | 0 |
| 8 | DESCRIBE `reviews` | | 9 | 9 | 0 |
| 9 | DESCRIBE `reviews_evalutions` | | 5 | 5 | 0 |
| 10 | DESCRIBE `actress_images` | | 6 | 6 | 0 |
| 11 | DESCRIBE `admins` | | 10 | 10 | 0 |
| 12 | DESCRIBE `tops` | | 17 | 17 | 0 |
| 13 | DESCRIBE `information` | | 7 | 7 | 0 |
| 14 | DESCRIBE `items` | | 5 | 5 | 0 |
| 15 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'prefecture' ORDER BY `item_id` ASC | | 48 | 48 | 0 |
| 16 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'blood_type' ORDER BY `item_id` ASC | | 4 | 4 | 0 |
| 17 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'bast_size' ORDER BY `item_id` ASC | | 10 | 10 | 0 |
| 18 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'category' ORDER BY `item_id` ASC | | 8 | 8 | 0 |
| 19 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'type' ORDER BY `item_id` ASC | | 3 | 3 | 0 |
| 20 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'body_type' ORDER BY `item_id` ASC | | 5 | 5 | 0 |
| 21 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'icon' ORDER BY `item_id` ASC | | 4 | 4 | 0 |
| 22 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'type' ORDER BY `item_id` ASC | | 3 | 3 | 0 |
| 23 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'category' ORDER BY `item_id` ASC | | 8 | 8 | 0 |
| 24 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'body_type' ORDER BY `item_id` ASC | | 5 | 5 | 0 |
| 25 | SELECT `Item`.`item_id`, `Item`.`item_value` FROM `items` AS `Item` WHERE `item_kbn` = 'bast_size' ORDER BY `item_id` ASC | | 10 | 10 | 0 |
| 26 | 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 |
| 27 | 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 |
| 28 | 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 |
| 29 | 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 |
| 30 | SELECT COUNT(*) AS `count` FROM `evaluations` AS `Evaluation` WHERE 1 = 1 | | 1 | 1 | 0 |
| 31 | SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` WHERE 1 = 1 | | 1 | 1 | 0 |
| 32 | SELECT COUNT(*) AS `count` FROM `sites` AS `Site` WHERE `del_flg` = '1' | | 1 | 1 | 0 |
| 33 | SELECT COUNT(*) AS `count` FROM `upload_images` AS `UploadImage` WHERE `UploadImage`.`del_flg` = '1' | | 1 | 1 | 0 |
| 34 | SELECT COUNT(*) AS `count` FROM `actresses` AS `Actress` WHERE 1 = 1 | | 1 | 1 | 0 |
| 35 | 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 |
| 36 | SELECT COUNT(*) AS `count` FROM `actresses` AS `Actress` WHERE `Actress`.`del_flg` = '1' | | 1 | 1 | 0 |
| 37 | 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 |
| 38 | 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 |
| 39 | (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 "あ%")
UNION
(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 "ぁ%")
LIMIT 20 | | 0 | 0 | 1 |
| 40 | (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 "い%")
UNION
(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 "ぃ%")
LIMIT 20 | | 0 | 0 | 0 |
| 41 | (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 "う%")
UNION
(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 "ぅ%")
LIMIT 20 | | 0 | 0 | 0 |
| 42 | (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 "え%")
UNION
(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 "ぇ%")
LIMIT 20 | | 0 | 0 | 0 |
| 43 | (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 "お%")
UNION
(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 "ぉ%")
LIMIT 20 | | 0 | 0 | 0 |
