検索結果
Page 10 of 34, showing 15 records out of 500 total, starting on record 136, ending on 150
Page 10 of 34, showing 15 records out of 500 total, starting on record 136, ending on 150
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT DISTINCT `Spot`.*, `Spot`.`id` FROM `crosskyoto_synergy_debug`.`spots` AS `Spot` LEFT JOIN `crosskyoto_synergy_debug`.`areas` AS `Area` ON (`Spot`.`area_id` = `Area`.`id`) WHERE 1 = 1 LIMIT 135, 15 | 15 | 15 | 6 | |
| 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` = 'Spot' AND `Image`.`foreign_key` IN (142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156) | 65 | 65 | 4 | |
| 3 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`sort_order`, `CategoriesSpot`.`id`, `CategoriesSpot`.`spot_id`, `CategoriesSpot`.`category_id`, `CategoriesSpot`.`created` FROM `crosskyoto_synergy_debug`.`categories` AS `Category` JOIN `crosskyoto_synergy_debug`.`categories_spots` AS `CategoriesSpot` ON (`CategoriesSpot`.`spot_id` IN (142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156) AND `CategoriesSpot`.`category_id` = `Category`.`id`) | 29 | 29 | 1 | |
| 4 | 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`, `SpotsWork`.`id`, `SpotsWork`.`spot_id`, `SpotsWork`.`work_id`, `SpotsWork`.`created` FROM `crosskyoto_synergy_debug`.`works` AS `Work` JOIN `crosskyoto_synergy_debug`.`spots_works` AS `SpotsWork` ON (`SpotsWork`.`spot_id` IN (142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156) AND `SpotsWork`.`work_id` = `Work`.`id`) | 5 | 5 | 1 | |
| 5 | SELECT COUNT(DISTINCT Spot.id) AS `count` FROM `crosskyoto_synergy_debug`.`spots` AS `Spot` LEFT JOIN `crosskyoto_synergy_debug`.`areas` AS `Area` ON (`Spot`.`area_id` = `Area`.`id`) WHERE 1 = 1 | 1 | 1 | 2 |
