Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.display_name AS display_name_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  setting t0
WHERE
  t0.name = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.display_name AS display_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM setting t0 WHERE t0.name = 'disclaimer_cookie_toggle' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  DISTINCT m0_.id AS id_0
FROM
  media m0_
  LEFT JOIN media_photo m1_ ON m0_.id = m1_.id
  LEFT JOIN media_video m2_ ON m0_.id = m2_.id
WHERE
  m0_.active = 1
  AND EXISTS (
    SELECT
      1
    FROM
      media_tag m3_
      INNER JOIN tags t4_ ON m3_.tag_id = t4_.id
    WHERE
      m3_.media_id = m0_.id
      AND t4_.id IN (?)
  )
  AND m0_.privacy = ?
LIMIT
  42

SELECT DISTINCT m0_.id AS id_0 FROM media m0_ LEFT JOIN media_photo m1_ ON m0_.id = m1_.id LEFT JOIN media_video m2_ ON m0_.id = m2_.id WHERE m0_.active = 1 AND EXISTS (SELECT 1 FROM media_tag m3_ INNER JOIN tags t4_ ON m3_.tag_id = t4_.id WHERE m3_.media_id = m0_.id AND t4_.id IN (106)) AND m0_.privacy = 'all' LIMIT 42;

SELECT
  t0.id AS id_3,
  t0.name AS name_4,
  t0.legal_name AS legal_name_5,
  t0.email AS email_6,
  t0.slug AS slug_7,
  t0.description AS description_8,
  t0.country AS country_9,
  t0.city AS city_10,
  t0.location AS location_11,
  t0.enable_contact AS enable_contact_12,
  t0.languages AS languages_13,
  t0.use_english AS use_english_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.deleted_at AS deleted_at_17,
  t0.user_id AS user_id_18,
  t0.profile_type_id AS profile_type_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.updated_by_id AS updated_by_id_21,
  t0.type,
  t1.transport AS transport_22,
  t2.own_location AS own_location_23,
  t2.hair_length AS hair_length_24,
  t2.tattoos AS tattoos_25,
  t2.hair_color AS hair_color_26,
  t2.eyes AS eyes_27,
  t2.ethnicity AS ethnicity_28,
  t2.height AS height_29,
  t2.weight AS weight_30,
  t2.hips AS hips_31,
  t2.waist AS waist_32,
  t2.chest AS chest_33
FROM
  profile t0
  LEFT JOIN profile_person t1 ON t0.id = t1.id
  LEFT JOIN profile_model t2 ON t0.id = t2.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_3, t0.name AS name_4, t0.legal_name AS legal_name_5, t0.email AS email_6, t0.slug AS slug_7, t0.description AS description_8, t0.country AS country_9, t0.city AS city_10, t0.location AS location_11, t0.enable_contact AS enable_contact_12, t0.languages AS languages_13, t0.use_english AS use_english_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.user_id AS user_id_18, t0.profile_type_id AS profile_type_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.type, t1.transport AS transport_22, t2.own_location AS own_location_23, t2.hair_length AS hair_length_24, t2.tattoos AS tattoos_25, t2.hair_color AS hair_color_26, t2.eyes AS eyes_27, t2.ethnicity AS ethnicity_28, t2.height AS height_29, t2.weight AS weight_30, t2.hips AS hips_31, t2.waist AS waist_32, t2.chest AS chest_33 FROM profile t0 LEFT JOIN profile_person t1 ON t0.id = t1.id LEFT JOIN profile_model t2 ON t0.id = t2.id WHERE t0.id = 5 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.slug AS slug_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  page_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  menu_item_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM menu_item_translation t0 WHERE t0.translatable_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_date AS created_date_3,
  t0.profile_id AS profile_id_4
FROM
  profile_cover t0
WHERE
  t0.profile_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_date AS created_date_3, t0.profile_id AS profile_id_4 FROM profile_cover t0 WHERE t0.profile_id = 5;

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.hash AS hash_2,
  m0_.description AS description_3,
  m0_.active AS active_4,
  m0_.views AS views_5,
  m0_.privacy AS privacy_6,
  m0_.adult AS adult_7,
  m0_.location AS location_8,
  m0_.created_at AS created_at_9,
  m0_.updated_at AS updated_at_10,
  m0_.deleted_at AS deleted_at_11,
  m1_.filename AS filename_12,
  m2_.embed_code AS embed_code_13,
  m2_.platform AS platform_14,
  m0_.type AS type_15,
  m0_.profile_id AS profile_id_16,
  m0_.created_by_id AS created_by_id_17,
  m0_.updated_by_id AS updated_by_id_18
FROM
  media m0_
  LEFT JOIN media_photo m1_ ON m0_.id = m1_.id
  LEFT JOIN media_video m2_ ON m0_.id = m2_.id
WHERE
  m0_.active = 1
  AND EXISTS (
    SELECT
      1
    FROM
      media_tag m3_
      INNER JOIN tags t4_ ON m3_.tag_id = t4_.id
    WHERE
      m3_.media_id = m0_.id
      AND t4_.id IN (?)
  )
  AND m0_.privacy = ?
  AND m0_.id IN (?)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.hash AS hash_2, m0_.description AS description_3, m0_.active AS active_4, m0_.views AS views_5, m0_.privacy AS privacy_6, m0_.adult AS adult_7, m0_.location AS location_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.deleted_at AS deleted_at_11, m1_.filename AS filename_12, m2_.embed_code AS embed_code_13, m2_.platform AS platform_14, m0_.type AS type_15, m0_.profile_id AS profile_id_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18 FROM media m0_ LEFT JOIN media_photo m1_ ON m0_.id = m1_.id LEFT JOIN media_video m2_ ON m0_.id = m2_.id WHERE m0_.active = 1 AND EXISTS (SELECT 1 FROM media_tag m3_ INNER JOIN tags t4_ ON m3_.tag_id = t4_.id WHERE m3_.media_id = m0_.id AND t4_.id IN (106)) AND m0_.privacy = 'all' AND m0_.id IN (25, 70);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.display_name AS display_name_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  setting t0
WHERE
  t0.name IN (?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.display_name AS display_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM setting t0 WHERE t0.name IN ('seo_allow_indexing', 'seo_default_title', 'seo_default_description', 'core_site_name', 'seo_default_keywords', 'core_site_logo') AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_by_id AS created_by_id_5,
  t0.updated_by_id AS updated_by_id_6
FROM
  page t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM page t0 WHERE t0.id = '3' AND ((t0.deleted_at IS NULL));

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.path AS path_2,
  m0_.icon AS icon_3,
  m0_.privacy AS privacy_4,
  m0_.groups AS groups_5,
  m0_.sort_order AS sort_order_6,
  m0_.options AS options_7,
  m0_.active AS active_8,
  m0_.menu_id AS menu_id_9,
  m0_.parent_id AS parent_id_10
FROM
  menu_item m0_
WHERE
  m0_.menu_id = ?
  AND (
    (
      m0_.privacy = ?
      OR m0_.privacy = ?
    )
  )
ORDER BY
  m0_.sort_order ASC

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.path AS path_2, m0_.icon AS icon_3, m0_.privacy AS privacy_4, m0_.groups AS groups_5, m0_.sort_order AS sort_order_6, m0_.options AS options_7, m0_.active AS active_8, m0_.menu_id AS menu_id_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.menu_id = 1 AND ((m0_.privacy = 'all' OR m0_.privacy = 'guests')) ORDER BY m0_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.meta_data AS meta_data_2,
  t0.route AS route_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  seo t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_data AS meta_data_2, t0.route AS route_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM seo t0 WHERE t0.route = 'media_tag' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  tags t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM tags t0 WHERE t0.slug = 'pool' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_date AS created_date_3,
  t0.profile_id AS profile_id_4
FROM
  profile_avatar t0
WHERE
  t0.profile_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_date AS created_date_3, t0.profile_id AS profile_id_4 FROM profile_avatar t0 WHERE t0.profile_id = 5;

SELECT
  count(m0_.id) AS sclr_0
FROM
  media m0_
  LEFT JOIN media_photo m1_ ON m0_.id = m1_.id
  LEFT JOIN media_video m2_ ON m0_.id = m2_.id
WHERE
  m0_.active = 1
  AND EXISTS (
    SELECT
      1
    FROM
      media_tag m3_
      INNER JOIN tags t4_ ON m3_.tag_id = t4_.id
    WHERE
      m3_.media_id = m0_.id
      AND t4_.id IN (?)
  )
  AND m0_.privacy = ?

SELECT count(m0_.id) AS sclr_0 FROM media m0_ LEFT JOIN media_photo m1_ ON m0_.id = m1_.id LEFT JOIN media_video m2_ ON m0_.id = m2_.id WHERE m0_.active = 1 AND EXISTS (SELECT 1 FROM media_tag m3_ INNER JOIN tags t4_ ON m3_.tag_id = t4_.id WHERE m3_.media_id = m0_.id AND t4_.id IN (106)) AND m0_.privacy = 'all';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  menu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM menu t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3 FROM language t0 WHERE t0.id = 1;