Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `StorePage`.`id`, `StorePage`.`store_user_id`, `StorePage`.`language_id`, `StorePage`.`category_id`, `StorePage`.`prefecture_id`, `StorePage`.`slug`, `StorePage`.`location`, `StorePage`.`formatted_location`, `StorePage`.`lat`, `StorePage`.`lng`, `StorePage`.`for_vip_active`, `StorePage`.`with_official_guide`, `StorePage`.`created`, `Category`.`id`, `Category`.`slug`, `Category`.`name`, `Prefecture`.`id`, `Prefecture`.`name` FROM `akiba`.`store_pages` AS `StorePage` LEFT JOIN `akiba`.`categories` AS `Category` ON (`StorePage`.`category_id` = `Category`.`id`) LEFT JOIN `akiba`.`prefectures` AS `Prefecture` ON (`StorePage`.`prefecture_id` = `Prefecture`.`id`) WHERE 1 = 1 ORDER BY `StorePage`.`created` DESC LIMIT 8 | 8 | 8 | 1 | maybe slow |
SELECT `StorePageContent`.`id`, `StorePageContent`.`store_page_id`, `StorePageContent`.`language_id`, `StorePageContent`.`catchcopy`, `StorePageContent`.`name`, `StorePageContent`.`tel`, `StorePageContent`.`body`, `StorePageContent`.`created` FROM `akiba`.`store_page_contents` AS `StorePageContent` WHERE `StorePageContent`.`store_page_id` IN (9, 3, 1, 2, 4, 5, 6, 7) | 9 | 9 | 1 | maybe slow |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (9) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (3) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (1) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (2) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (4) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (5) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (6) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 9 | maybe slow |
SELECT `Image`.`id`, `Image`.`dirname`, `Image`.`basename`, `Image`.`path`, `Image`.`width`, `Image`.`height`, `Image`.`foreign_key` FROM `akiba`.`images` AS `Image` WHERE `model` = 'StorePage' AND `Image`.`foreign_key` = (7) ORDER BY `Image`.`sortorder` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (9) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 0 | 0 | 4 | maybe slow |
SELECT `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (3) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 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 `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (1) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 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 | 10 | maybe slow |
SELECT `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (2) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 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 `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (4) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 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 `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (5) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 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 `Movie`.`id`, `Movie`.`movie_service_id`, `Movie`.`unique_id`, `Movie`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (6) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 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 | 29 | maybe slow |
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`.`url`, `Movie`.`thumbnail_url`, `Movie`.`title`, `Movie`.`alternative`, `Movie`.`foreign_key` FROM `akiba`.`movies` AS `Movie` WHERE `model` = 'StorePage' AND `Movie`.`foreign_key` = (7) ORDER BY `Movie`.`sortorder` ASC LIMIT 1 | 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 `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` IN (9, 3, 1, 2, 4, 5, 6, 7) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'StorePage' | 27 | 27 | 10 | maybe slow |
SELECT COUNT(*) AS `count` FROM `akiba`.`store_pages` AS `StorePage` LEFT JOIN `akiba`.`categories` AS `Category` ON (`StorePage`.`category_id` = `Category`.`id`) LEFT JOIN `akiba`.`prefectures` AS `Prefecture` ON (`StorePage`.`prefecture_id` = `Prefecture`.`id`) WHERE 1 = 1 | 1 | 1 | 1 | |
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` = 'StorePage' | 3 | 3 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `akiba`.`categories` AS `Category` WHERE `model` = 'StorePage' | 3 | 3 | 0 | |