Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`model`, `Movie`.`foreign_key`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`width`, `Movie`.`height`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`sortorder`, `Movie`.`created`, `MovieService`.`id`, `MovieService`.`name`, `MovieService`.`home_url`, `MovieService`.`url`, `MovieService`.`thumbnail_url`, `MovieService`.`embed` FROM `akiba`.`movies` AS `Movie` LEFT JOIN `akiba`.`movie_services` AS `MovieService` ON (`Movie`.`movie_service_id` = `MovieService`.`id`) WHERE `Movie`.`model` = 'GirlPR' AND `Movie`.`foreign_key` = '8102ea41-3718-44e6-b7c8-5b90ac1f1680' | 1 | 1 | 1 | |
SELECT `MovieService`.`url` FROM `akiba`.`movie_services` AS `MovieService` WHERE `id` = 'youtube' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MovieService`.`thumbnail_url` FROM `akiba`.`movie_services` AS `MovieService` WHERE `id` = 'youtube' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MovieService`.`embed` FROM `akiba`.`movie_services` AS `MovieService` WHERE `id` = 'youtube' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`model`, `Movie`.`foreign_key`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`width`, `Movie`.`height`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`sortorder`, `Movie`.`created`, `MovieService`.`id`, `MovieService`.`name`, `MovieService`.`home_url`, `MovieService`.`url`, `MovieService`.`thumbnail_url`, `MovieService`.`embed` FROM `akiba`.`movies` AS `Movie` LEFT JOIN `akiba`.`movie_services` AS `MovieService` ON (`Movie`.`movie_service_id` = `MovieService`.`id`) WHERE `Movie`.`model` = 'Girl' AND `Movie`.`foreign_key` = '8102ea41-3718-44e6-b7c8-5b90ac1f1680' | 1 | 1 | 0 | |
SELECT `MovieService`.`url` FROM `akiba`.`movie_services` AS `MovieService` WHERE `id` = 'youtube' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MovieService`.`thumbnail_url` FROM `akiba`.`movie_services` AS `MovieService` WHERE `id` = 'youtube' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MovieService`.`embed` FROM `akiba`.`movie_services` AS `MovieService` WHERE `id` = 'youtube' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`alternative`, `Image`.`checksum`, `Image`.`sortorder`, `Image`.`created` FROM `akiba`.`images` AS `Image` WHERE `Image`.`model` = 'Girl' AND `Image`.`foreign_key` = '8102ea41-3718-44e6-b7c8-5b90ac1f1680' ORDER BY `Image`.`sortorder` ASC | 2 | 2 | 5 | maybe slow |
SELECT `Image`.`id`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`alternative`, `Image`.`checksum`, `Image`.`sortorder`, `Image`.`created` FROM `akiba`.`images` AS `Image` WHERE `model` = 'GirlLink' AND `Image`.`foreign_key` = (23) ORDER BY `sortorder` ASC LIMIT 1 | 1 | 1 | 9 | maybe slow |
SELECT `StorePagesGirl`.`store_page_id` FROM `akiba`.`store_pages_girls` AS `StorePagesGirl` WHERE `girl_id` = '8102ea41-3718-44e6-b7c8-5b90ac1f1680' | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'Girl' AND `Image`.`foreign_key` = ('8102ea41-3718-44e6-b7c8-5b90ac1f1680') ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Category`.`id`, `Category`.`slug`, `Category`.`name` FROM `akiba`.`categories` AS `Category` WHERE `Category`.`id` = '5' | 1 | 1 | 0 | |
SELECT `Prefecture`.`id`, `Prefecture`.`name` FROM `akiba`.`prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 13 | 1 | 1 | 0 | |
SELECT `Tag`.`id`, `Tag`.`name`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `akiba`.`tags` AS `Tag` JOIN `akiba`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` = 6 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'GirlPage' | 0 | 0 | 0 | |
SELECT `Prefecture`.`id`, `Prefecture`.`name` FROM `akiba`.`prefectures` AS `Prefecture` WHERE 1 = 1 | 48 | 48 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `akiba`.`categories` AS `Category` WHERE `model` = 'Girl' | 2 | 2 | 0 | |