検索結果
Page 8 of 34, showing 15 records out of 500 total, starting on record 106, ending on 120
Page 8 of 34, showing 15 records out of 500 total, starting on record 106, ending on 120
| 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 105, 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 (111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125) | 46 | 46 | 7 | |
| 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 (111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125) AND `CategoriesSpot`.`category_id` = `Category`.`id`) | 45 | 45 | 2 | |
| 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 (111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125) AND `SpotsWork`.`work_id` = `Work`.`id`) | 4 | 4 | 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 |
