Symfony Profiler

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 m0_.privacy = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  12

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 m0_.privacy = 'all' ORDER BY m0_.created_at DESC LIMIT 12;

SELECT
  t0_.name AS name_0,
  t0_.slug AS slug_1,
  COUNT(t0_.id) AS sclr_2
FROM
  media m1_
  LEFT JOIN media_photo m2_ ON m1_.id = m2_.id
  LEFT JOIN media_video m3_ ON m1_.id = m3_.id
  INNER JOIN media_tag m4_ ON m1_.id = m4_.media_id
  INNER JOIN tags t0_ ON t0_.id = m4_.tag_id
WHERE
  m1_.active = 1
  AND m1_.privacy = ?
GROUP BY
  t0_.id
ORDER BY
  t0_.name ASC
LIMIT
  12

SELECT t0_.name AS name_0, t0_.slug AS slug_1, COUNT(t0_.id) AS sclr_2 FROM media m1_ LEFT JOIN media_photo m2_ ON m1_.id = m2_.id LEFT JOIN media_video m3_ ON m1_.id = m3_.id INNER JOIN media_tag m4_ ON m1_.id = m4_.media_id INNER JOIN tags t0_ ON t0_.id = m4_.tag_id WHERE m1_.active = 1 AND m1_.privacy = 'all' GROUP BY t0_.id ORDER BY t0_.name ASC LIMIT 12;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.legal_name AS legal_name_2,
  p0_.email AS email_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.country AS country_6,
  p0_.city AS city_7,
  p0_.location AS location_8,
  p0_.enable_contact AS enable_contact_9,
  p0_.languages AS languages_10,
  p0_.use_english AS use_english_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.deleted_at AS deleted_at_14,
  p1_.transport AS transport_15,
  p2_.own_location AS own_location_16,
  p2_.hair_length AS hair_length_17,
  p2_.tattoos AS tattoos_18,
  p2_.hair_color AS hair_color_19,
  p2_.eyes AS eyes_20,
  p2_.ethnicity AS ethnicity_21,
  p2_.height AS height_22,
  p2_.weight AS weight_23,
  p2_.hips AS hips_24,
  p2_.waist AS waist_25,
  p2_.chest AS chest_26,
  p0_.type AS type_27,
  p0_.user_id AS user_id_28,
  p0_.profile_type_id AS profile_type_id_29,
  p0_.created_by_id AS created_by_id_30,
  p0_.updated_by_id AS updated_by_id_31
FROM
  profile p0_
  LEFT JOIN profile_person p1_ ON p0_.id = p1_.id
  LEFT JOIN profile_model p2_ ON p0_.id = p2_.id
  LEFT JOIN media m3_ ON p0_.id = m3_.profile_id
  LEFT JOIN media_photo m4_ ON m3_.id = m4_.id
  LEFT JOIN media_video m5_ ON m3_.id = m5_.id
WHERE
  (p0_.deleted_at IS NULL)
GROUP BY
  p0_.id
HAVING
  count(m3_.id) > 0
ORDER BY
  p0_.created_at DESC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.legal_name AS legal_name_2, p0_.email AS email_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.country AS country_6, p0_.city AS city_7, p0_.location AS location_8, p0_.enable_contact AS enable_contact_9, p0_.languages AS languages_10, p0_.use_english AS use_english_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.deleted_at AS deleted_at_14, p1_.transport AS transport_15, p2_.own_location AS own_location_16, p2_.hair_length AS hair_length_17, p2_.tattoos AS tattoos_18, p2_.hair_color AS hair_color_19, p2_.eyes AS eyes_20, p2_.ethnicity AS ethnicity_21, p2_.height AS height_22, p2_.weight AS weight_23, p2_.hips AS hips_24, p2_.waist AS waist_25, p2_.chest AS chest_26, p0_.type AS type_27, p0_.user_id AS user_id_28, p0_.profile_type_id AS profile_type_id_29, p0_.created_by_id AS created_by_id_30, p0_.updated_by_id AS updated_by_id_31 FROM profile p0_ LEFT JOIN profile_person p1_ ON p0_.id = p1_.id LEFT JOIN profile_model p2_ ON p0_.id = p2_.id LEFT JOIN media m3_ ON p0_.id = m3_.profile_id LEFT JOIN media_photo m4_ ON m3_.id = m4_.id LEFT JOIN media_video m5_ ON m3_.id = m5_.id WHERE (p0_.deleted_at IS NULL) GROUP BY p0_.id HAVING count(m3_.id) > 0 ORDER BY p0_.created_at DESC LIMIT 12;

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
  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
  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
  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.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.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.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.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
  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 = 'home' LIMIT 1;

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
  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.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;