Symfony Profiler

SELECT
  t0.lft AS lft_1,
  t0.lvl AS lvl_2,
  t0.rgt AS rgt_3,
  t0.categories AS categories_4,
  t0.equipment AS equipment_5,
  t0.exclude_from_equipments AS exclude_from_equipments_6,
  t0.group_item AS group_item_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.published AS published_11,
  t0.published_at AS published_at_12,
  t0.notes AS notes_13,
  t0.reference AS reference_14,
  t0.tree_root AS tree_root_15,
  t0.parent_id AS parent_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.publisher AS publisher_19
FROM
  training_material t0
WHERE
  t0.id = ?

SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.categories AS categories_4, t0.equipment AS equipment_5, t0.exclude_from_equipments AS exclude_from_equipments_6, t0.group_item AS group_item_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.published AS published_11, t0.published_at AS published_at_12, t0.notes AS notes_13, t0.reference AS reference_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.publisher AS publisher_19 FROM training_material t0 WHERE t0.id = '29';

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  training_material_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_material_translation t0 WHERE t0.translatable_id = 29;

SELECT
  t0.source AS source_1,
  t0.zone AS zone_2,
  t0.url_external AS url_external_3,
  t0.id AS id_4,
  t0.notes AS notes_5,
  t0.tiers_id AS tiers_id_6,
  t0.tiers_name AS tiers_name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.file_name AS file_name_10,
  t0.file_original_name AS file_original_name_11,
  t0.file_mime_type AS file_mime_type_12,
  t0.file_size AS file_size_13,
  t0.file_dimensions AS file_dimensions_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.media
FROM
  media t0
  INNER JOIN training_material_images ON t0.id = training_material_images.image_id
WHERE
  training_material_images.material_id = ?
  AND t0.media IN ('image')
LIMIT
  1

SELECT t0.source AS source_1, t0.zone AS zone_2, t0.url_external AS url_external_3, t0.id AS id_4, t0.notes AS notes_5, t0.tiers_id AS tiers_id_6, t0.tiers_name AS tiers_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.file_name AS file_name_10, t0.file_original_name AS file_original_name_11, t0.file_mime_type AS file_mime_type_12, t0.file_size AS file_size_13, t0.file_dimensions AS file_dimensions_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.media FROM media t0 INNER JOIN training_material_images ON t0.id = training_material_images.image_id WHERE training_material_images.material_id = 29 AND t0.media IN ('image') LIMIT 1;

SELECT
  m0_.id AS id_0
FROM
  muscle m0_
WHERE
  m0_.parent_id IN (NULL)

SELECT m0_.id AS id_0 FROM muscle m0_ WHERE m0_.parent_id IN (NULL);

SELECT
  DISTINCT count(DISTINCT t0_.id) AS sclr_0
FROM
  training_exercise t0_
  LEFT JOIN training_exercise_material_rel t2_ ON t0_.id = t2_.exercise_id
  LEFT JOIN training_material t1_ ON t1_.id = t2_.material_id
WHERE
  (
    t0_.published = ?
    AND (
      t0_.status NOT IN (?, ?, ?)
      OR t0_.status IS NULL
    )
    AND t1_.id IN (?)
  )
  AND (t0_.deleted_at IS NULL)

SELECT DISTINCT count(DISTINCT t0_.id) AS sclr_0 FROM training_exercise t0_ LEFT JOIN training_exercise_material_rel t2_ ON t0_.id = t2_.exercise_id LEFT JOIN training_material t1_ ON t1_.id = t2_.material_id WHERE (t0_.published = 1 AND (t0_.status NOT IN ('proposal', 'abandoned', 'duplicated') OR t0_.status IS NULL) AND t1_.id IN (29)) AND (t0_.deleted_at IS NULL);

SELECT
  DISTINCT t0_.id AS id_0
FROM
  training_exercise t0_
  LEFT JOIN training_exercise_material_rel t2_ ON t0_.id = t2_.exercise_id
  LEFT JOIN training_material t1_ ON t1_.id = t2_.material_id
WHERE
  (
    t0_.published = ?
    AND (
      t0_.status NOT IN (?, ?, ?)
      OR t0_.status IS NULL
    )
    AND t1_.id IN (?)
  )
  AND (t0_.deleted_at IS NULL)
LIMIT
  10
OFFSET
  30

SELECT DISTINCT t0_.id AS id_0 FROM training_exercise t0_ LEFT JOIN training_exercise_material_rel t2_ ON t0_.id = t2_.exercise_id LEFT JOIN training_material t1_ ON t1_.id = t2_.material_id WHERE (t0_.published = 1 AND (t0_.status NOT IN ('proposal', 'abandoned', 'duplicated') OR t0_.status IS NULL) AND t1_.id IN (29)) AND (t0_.deleted_at IS NULL) LIMIT 10 OFFSET 30;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.token AS token_1,
  t0_.status AS status_2,
  t0_.status_internal AS status_internal_3,
  t0_.public_status AS public_status_4,
  t0_.difficulty AS difficulty_5,
  t0_.focus AS focus_6,
  t0_.execution_type AS execution_type_7,
  t0_.workout_parts AS workout_parts_8,
  t0_.tension_type AS tension_type_9,
  t0_.validate_at AS validate_at_10,
  t0_.is_avatar_default_back_view AS is_avatar_default_back_view_11,
  t0_.grips AS grips_12,
  t0_.is_suggestion AS is_suggestion_13,
  t0_.preferred_gender_view AS preferred_gender_view_14,
  t0_.default_unit AS default_unit_15,
  t0_.side AS side_16,
  t0_.created_at AS created_at_17,
  t0_.updated_at AS updated_at_18,
  t0_.deleted_at AS deleted_at_19,
  t0_.published AS published_20,
  t0_.published_at AS published_at_21,
  t0_.notes AS notes_22,
  t0_.view_counter AS view_counter_23,
  t0_.tiers_id AS tiers_id_24,
  t0_.tiers_name AS tiers_name_25,
  t0_.source AS source_26,
  t0_.source_model AS source_model_27,
  t0_.normalized_name AS normalized_name_28,
  t0_.metaphone_name AS metaphone_name_29,
  0 AS sclr_30,
  0 AS sclr_31,
  0 AS sclr_32,
  t0_.main_exercise_id AS main_exercise_id_33,
  t0_.exercise_group_id AS exercise_group_id_34,
  t0_.suggest_by_id AS suggest_by_id_35,
  t0_.exercise_proposal_id AS exercise_proposal_id_36,
  t0_.created_by_id AS created_by_id_37,
  t0_.updated_by_id AS updated_by_id_38,
  t0_.publisher AS publisher_39
FROM
  training_exercise t0_
  LEFT JOIN training_exercise_material_rel t2_ ON t0_.id = t2_.exercise_id
  LEFT JOIN training_material t1_ ON t1_.id = t2_.material_id
WHERE
  (
    t0_.published = ?
    AND (
      t0_.status NOT IN (?, ?, ?)
      OR t0_.status IS NULL
    )
    AND t1_.id IN (?)
    AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (t0_.deleted_at IS NULL)

SELECT DISTINCT t0_.id AS id_0, t0_.token AS token_1, t0_.status AS status_2, t0_.status_internal AS status_internal_3, t0_.public_status AS public_status_4, t0_.difficulty AS difficulty_5, t0_.focus AS focus_6, t0_.execution_type AS execution_type_7, t0_.workout_parts AS workout_parts_8, t0_.tension_type AS tension_type_9, t0_.validate_at AS validate_at_10, t0_.is_avatar_default_back_view AS is_avatar_default_back_view_11, t0_.grips AS grips_12, t0_.is_suggestion AS is_suggestion_13, t0_.preferred_gender_view AS preferred_gender_view_14, t0_.default_unit AS default_unit_15, t0_.side AS side_16, t0_.created_at AS created_at_17, t0_.updated_at AS updated_at_18, t0_.deleted_at AS deleted_at_19, t0_.published AS published_20, t0_.published_at AS published_at_21, t0_.notes AS notes_22, t0_.view_counter AS view_counter_23, t0_.tiers_id AS tiers_id_24, t0_.tiers_name AS tiers_name_25, t0_.source AS source_26, t0_.source_model AS source_model_27, t0_.normalized_name AS normalized_name_28, t0_.metaphone_name AS metaphone_name_29, 0 AS sclr_30, 0 AS sclr_31, 0 AS sclr_32, t0_.main_exercise_id AS main_exercise_id_33, t0_.exercise_group_id AS exercise_group_id_34, t0_.suggest_by_id AS suggest_by_id_35, t0_.exercise_proposal_id AS exercise_proposal_id_36, t0_.created_by_id AS created_by_id_37, t0_.updated_by_id AS updated_by_id_38, t0_.publisher AS publisher_39 FROM training_exercise t0_ LEFT JOIN training_exercise_material_rel t2_ ON t0_.id = t2_.exercise_id LEFT JOIN training_material t1_ ON t1_.id = t2_.material_id WHERE (t0_.published = 1 AND (t0_.status NOT IN ('proposal', 'abandoned', 'duplicated') OR t0_.status IS NULL) AND t1_.id IN (29) AND t0_.id IN (205, 206, 208, 211, 216, 221, 222, 223, 224, 225)) AND (t0_.deleted_at IS NULL);

SELECT
  t0.name AS name_1,
  t0.caption AS caption_2,
  t0.alt AS alt_3,
  t0.copyright AS copyright_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.locale AS locale_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.translatable_id AS translatable_id_11
FROM
  media_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.name AS name_1, t0.caption AS caption_2, t0.alt AS alt_3, t0.copyright AS copyright_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.translatable_id AS translatable_id_11 FROM media_translation t0 WHERE t0.translatable_id = 379;

SELECT
  t0.body_parts AS body_parts_1,
  t0.is_on_avatar AS is_on_avatar_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.published AS published_9,
  t0.published_at AS published_at_10,
  t0.notes AS notes_11,
  t0.reference AS reference_12,
  t0.tree_root AS tree_root_13,
  t0.parent_id AS parent_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.publisher AS publisher_17
FROM
  muscle t0
WHERE
  t0.id IN (?)

SELECT t0.body_parts AS body_parts_1, t0.is_on_avatar AS is_on_avatar_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.notes AS notes_11, t0.reference AS reference_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.publisher AS publisher_17 FROM muscle t0 WHERE t0.id IN (6);

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  muscle_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM muscle_translation t0 WHERE t0.translatable_id = 6;

SELECT
  t0.lft AS lft_1,
  t0.lvl AS lvl_2,
  t0.rgt AS rgt_3,
  t0.sections AS sections_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.published AS published_8,
  t0.published_at AS published_at_9,
  t0.notes AS notes_10,
  t0.reference AS reference_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.publisher AS publisher_16
FROM
  training_category t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?)

SELECT t0.lft AS lft_1, t0.lvl AS lvl_2, t0.rgt AS rgt_3, t0.sections AS sections_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published AS published_8, t0.published_at AS published_at_9, t0.notes AS notes_10, t0.reference AS reference_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.publisher AS publisher_16 FROM training_category t0 WHERE t0.id IN (67, 68, 57, 56, 62, 60);

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  training_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_category_translation t0 WHERE t0.translatable_id = 56;

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  training_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_category_translation t0 WHERE t0.translatable_id = 57;

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  training_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.translatable_id AS translatable_id_10 FROM training_category_translation t0 WHERE t0.translatable_id = 60;

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.locale AS locale_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.translatable_id AS translatable_id_10
FROM
  training_category_translation t0
WHERE
  t0.translatable_id = ?