| 1 | SELECT `Work`.`id`, `Work`.`name`, `Work`.`media_type`, `Work`.`shoot_year`, `Work`.`publish_year`, `Work`.`summary`, `Work`.`creator`, `Work`.`distributor`, `Work`.`director`, `Work`.`actor`, `Work`.`url`, `Work`.`modified`, `Work`.`created` FROM `crosskyoto_synergy_debug`.`works` AS `Work` WHERE 1 = 1 LIMIT 280, 20 | | 20 | 20 | 1 |
| 2 | SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`name`, `Image`.`attachment`, `Image`.`dir`, `Image`.`type`, `Image`.`size`, `Image`.`active`, `Image`.`memo`, `Image`.`modified`, `Image`.`created` FROM `crosskyoto_synergy_debug`.`attachments` AS `Image` WHERE `Image`.`model` = 'Work' AND `Image`.`foreign_key` IN (352, 353, 355, 357, 358, 359, 360, 361, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375) | | 0 | 0 | 6 |
| 3 | SELECT `Spot`.`id`, `Spot`.`area_id`, `Spot`.`name`, `Spot`.`name_kana`, `Spot`.`zip`, `Spot`.`address`, `Spot`.`access`, `Spot`.`summary`, `Spot`.`works`, `Spot`.`requirement`, `Spot`.`procedures`, `Spot`.`rental_fee`, `Spot`.`available`, `Spot`.`holiday`, `Spot`.`url`, `Spot`.`parking`, `Spot`.`description`, `Spot`.`tel`, `Spot`.`fax`, `Spot`.`email`, `Spot`.`person_post`, `Spot`.`person_name`, `Spot`.`person_tel`, `Spot`.`person_fax`, `Spot`.`person_email`, `Spot`.`map`, `Spot`.`modified`, `Spot`.`created`, `SpotsWork`.`id`, `SpotsWork`.`spot_id`, `SpotsWork`.`work_id`, `SpotsWork`.`created` FROM `crosskyoto_synergy_debug`.`spots` AS `Spot` JOIN `crosskyoto_synergy_debug`.`spots_works` AS `SpotsWork` ON (`SpotsWork`.`work_id` IN (352, 353, 355, 357, 358, 359, 360, 361, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375) AND `SpotsWork`.`spot_id` = `Spot`.`id`) | | 0 | 0 | 1 |
| 4 | SELECT COUNT(DISTINCT Work.id) AS `count` FROM `crosskyoto_synergy_debug`.`works` AS `Work` WHERE 1 = 1 | | 1 | 1 | 1 |
