app/controllers/api/v1/guide_book_papers_controller.rb:155
- Average Self
-
84ms
- Average calls
- 1x
- Total Self
- 84ms
- Total Children
- 0ms
- Total runtime
- 84ms
SELECT guide_book_papers.*, crags.latitude, crags.longitude, `guide_book_papers`.`id` AS t0_r0, `guide_book_papers`.`name` AS t0_r1, `guide_book_papers`.`author` AS t0_r2, `guide_book_papers`.`editor` AS t0_r3, `guide_book_papers`.`publication_year` AS t0_r4, `guide_book_papers`.`price_cents` AS t0_r5, `guide_book_papers`.`ean` AS t0_r6, `guide_book_papers`.`vc_reference` AS t0_r7, `guide_book_papers`.`number_of_page` AS t0_r8, `guide_book_papers`.`weight` AS t0_r9, `guide_book_papers`.`user_id` AS t0_r10, `guide_book_papers`.`legacy_id` AS t0_r11, `guide_book_papers`.`created_at` AS t0_r12, `guide_book_papers`.`updated_at` AS t0_r13, `guide_book_papers`.`slug_name` AS t0_r14, `guide_book_papers`.`follows_count` AS t0_r15, `guide_book_papers`.`articles_count` AS t0_r16, `guide_book_papers`.`comments_count` AS t0_r17, `guide_book_papers`.`funding_status` AS t0_r18, `guide_book_papers`.`next_guide_book_paper_id` AS t0_r19, `crags`.`id` AS t1_r0, `crags`.`name` AS t1_r1, `crags`.`rocks` AS t1_r2, `crags`.`rain` AS t1_r3, `crags`.`sun` AS t1_r4, `crags`.`latitude` AS t1_r5, `crags`.`longitude` AS t1_r6, `crags`.`code_country` AS t1_r7, `crags`.`country` AS t1_r8, `crags`.`city` AS t1_r9, `crags`.`region` AS t1_r10, `crags`.`sport_climbing` AS t1_r11, `crags`.`bouldering` AS t1_r12, `crags`.`multi_pitch` AS t1_r13, `crags`.`trad_climbing` AS t1_r14, `crags`.`aid_climbing` AS t1_r15, `crags`.`deep_water` AS t1_r16, `crags`.`via_ferrata` AS t1_r17, `crags`.`summer` AS t1_r18, `crags`.`autumn` AS t1_r19, `crags`.`winter` AS t1_r20, `crags`.`spring` AS t1_r21, `crags`.`north` AS t1_r22, `crags`.`north_east` AS t1_r23, `crags`.`east` AS t1_r24, `crags`.`south_east` AS t1_r25, `crags`.`south` AS t1_r26, `crags`.`south_west` AS t1_r27, `crags`.`west` AS t1_r28, `crags`.`north_west` AS t1_r29, `crags`.`user_id` AS t1_r30, `crags`.`crag_routes_count` AS t1_r31, `crags`.`min_grade_value` AS t1_r32, `crags`.`max_grade_value` AS t1_r33, `crags`.`max_grade_text` AS t1_r34, `crags`.`min_grade_text` AS t1_r35, `crags`.`legacy_id` AS t1_r36, `crags`.`created_at` AS t1_r37, `crags`.`updated_at` AS t1_r38, `crags`.`deleted_at` AS t1_r39, `crags`.`photo_id` AS t1_r40, `crags`.`slug_name` AS t1_r41, `crags`.`comments_count` AS t1_r42, `crags`.`videos_count` AS t1_r43, `crags`.`photos_count` AS t1_r44, `crags`.`follows_count` AS t1_r45, `crags`.`articles_count` AS t1_r46, `crags`.`elevation` AS t1_r47, `crags`.`department_id` AS t1_r48, `crags`.`min_approach_time` AS t1_r49, `crags`.`max_approach_time` AS t1_r50, `crags`.`ascent_users_count` AS t1_r51, `crags`.`ascents_count` AS t1_r52, `active_storage_attachments`.`id` AS t2_r0, `active_storage_attachments`.`name` AS t2_r1, `active_storage_attachments`.`record_type` AS t2_r2, `active_storage_attachments`.`record_id` AS t2_r3, `active_storage_attachments`.`blob_id` AS t2_r4, `active_storage_attachments`.`created_at` AS t2_r5, `active_storage_blobs`.`id` AS t3_r0, `active_storage_blobs`.`key` AS t3_r1, `active_storage_blobs`.`filename` AS t3_r2, `active_storage_blobs`.`content_type` AS t3_r3, `active_storage_blobs`.`metadata` AS t3_r4, `active_storage_blobs`.`byte_size` AS t3_r5, `active_storage_blobs`.`checksum` AS t3_r6, `active_storage_blobs`.`created_at` AS t3_r7 FROM `guide_book_papers` LEFT OUTER JOIN `guide_book_paper_crags` ON `guide_book_paper_crags`.`guide_book_paper_id` = `guide_book_papers`.`id` LEFT OUTER JOIN `crags` ON `crags`.`id` = `guide_book_paper_crags`.`crag_id` AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) LEFT OUTER JOIN `active_storage_attachments` ON `active_storage_attachments`.`record_type` = ? AND `active_storage_attachments`.`name` = ? AND `active_storage_attachments`.`record_id` = `guide_book_papers`.`id` LEFT OUTER JOIN `active_storage_blobs` ON `active_storage_blobs`.`id` = `active_storage_attachments`.`blob_id` WHERE `guide_book_papers`.`next_guide_book_paper_id` IS NULL
|