Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.profile_image AS profile_image_4,
  p0_.bio AS bio_5,
  p0_.portfolio_link AS portfolio_link_6,
  p0_.instagram_handle AS instagram_handle_7,
  p0_.availability_notes AS availability_notes_8,
  p0_.publish_start_at AS publish_start_at_9,
  p0_.publish_end_at AS publish_end_at_10,
  p0_.status AS status_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.is_verified AS is_verified_14,
  p0_.verified_at AS verified_at_15,
  p0_.view_count AS view_count_16,
  p0_.favorite_count AS favorite_count_17,
  p0_.contact_count AS contact_count_18,
  p0_.average_rating AS average_rating_19,
  p0_.review_count AS review_count_20,
  p0_.phone1 AS phone1_21,
  p0_.whatsapp AS whatsapp_22,
  p0_.contact_email AS contact_email_23,
  p0_.instagram AS instagram_24,
  p0_.facebook AS facebook_25,
  p0_.x AS x_26,
  p0_.webpage AS webpage_27,
  p0_.phone2 AS phone2_28,
  p0_.user_id AS user_id_29,
  p0_.venue_id AS venue_id_30
FROM
  profile p0_
  LEFT JOIN profile_attribute_value p1_ ON p0_.id = p1_.profile_id
  LEFT JOIN profile_attribute p2_ ON p1_.attribute_id = p2_.id
  LEFT JOIN profile_image p3_ ON p0_.id = p3_.profile_id
  LEFT JOIN profile_service p4_ ON p0_.id = p4_.profile_id
  LEFT JOIN profile_area p5_ ON p0_.id = p5_.profile_id
  LEFT JOIN profile_video p6_ ON p0_.id = p6_.profile_id
  LEFT JOIN user u7_ ON p0_.user_id = u7_.id
  LEFT JOIN venue v8_ ON p0_.venue_id = v8_.id
WHERE
  p0_.slug = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.profile_image AS profile_image_4, p0_.bio AS bio_5, p0_.portfolio_link AS portfolio_link_6, p0_.instagram_handle AS instagram_handle_7, p0_.availability_notes AS availability_notes_8, p0_.publish_start_at AS publish_start_at_9, p0_.publish_end_at AS publish_end_at_10, p0_.status AS status_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.is_verified AS is_verified_14, p0_.verified_at AS verified_at_15, p0_.view_count AS view_count_16, p0_.favorite_count AS favorite_count_17, p0_.contact_count AS contact_count_18, p0_.average_rating AS average_rating_19, p0_.review_count AS review_count_20, p0_.phone1 AS phone1_21, p0_.whatsapp AS whatsapp_22, p0_.contact_email AS contact_email_23, p0_.instagram AS instagram_24, p0_.facebook AS facebook_25, p0_.x AS x_26, p0_.webpage AS webpage_27, p0_.phone2 AS phone2_28, p0_.user_id AS user_id_29, p0_.venue_id AS venue_id_30 FROM profile p0_ LEFT JOIN profile_attribute_value p1_ ON p0_.id = p1_.profile_id LEFT JOIN profile_attribute p2_ ON p1_.attribute_id = p2_.id LEFT JOIN profile_image p3_ ON p0_.id = p3_.profile_id LEFT JOIN profile_service p4_ ON p0_.id = p4_.profile_id LEFT JOIN profile_area p5_ ON p0_.id = p5_.profile_id LEFT JOIN profile_video p6_ ON p0_.id = p6_.profile_id LEFT JOIN user u7_ ON p0_.user_id = u7_.id LEFT JOIN venue v8_ ON p0_.venue_id = v8_.id WHERE p0_.slug = 'xxx-at-vg';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  profile
SET
  view_count = ?
WHERE
  id = ?

UPDATE profile SET view_count = 81 WHERE id = 37;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.content AS content_1,
  c0_.status AS status_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.lft AS lft_5,
  c0_.rgt AS rgt_6,
  c0_.depth AS depth_7,
  c0_.reference_type AS reference_type_8,
  c0_.reference_id AS reference_id_9,
  c0_.moderated_at AS moderated_at_10,
  c0_.moderation_notes AS moderation_notes_11,
  c0_.user_id AS user_id_12,
  c0_.parent_id AS parent_id_13,
  c0_.moderated_by AS moderated_by_14
FROM
  comment c0_
WHERE
  c0_.reference_type = ?
  AND c0_.reference_id = ?
  AND c0_.status = 1
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.status AS status_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.lft AS lft_5, c0_.rgt AS rgt_6, c0_.depth AS depth_7, c0_.reference_type AS reference_type_8, c0_.reference_id AS reference_id_9, c0_.moderated_at AS moderated_at_10, c0_.moderation_notes AS moderation_notes_11, c0_.user_id AS user_id_12, c0_.parent_id AS parent_id_13, c0_.moderated_by AS moderated_by_14 FROM comment c0_ WHERE c0_.reference_type = 'profile' AND c0_.reference_id = 37 AND c0_.status = 1 ORDER BY c0_.created_at DESC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4
FROM
  area a0_
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4
FROM
  service s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.thumbnail_path AS thumbnail_path_3,
  t0.is_main AS is_main_4,
  t0.sort_order AS sort_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.profile_id AS profile_id_8
FROM
  profile_image t0
WHERE
  t0.profile_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.thumbnail_path AS thumbnail_path_3, t0.is_main AS is_main_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.profile_id AS profile_id_8 FROM profile_image t0 WHERE t0.profile_id = 37 ORDER BY t0.sort_order ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.position AS position_2,
  b0_.image_path AS image_path_3,
  b0_.link_url AS link_url_4,
  b0_.start_date AS start_date_5,
  b0_.end_date AS end_date_6,
  b0_.is_active AS is_active_7,
  b0_.click_count AS click_count_8,
  b0_.view_count AS view_count_9,
  b0_.sort_order AS sort_order_10,
  b0_.created_at AS created_at_11
FROM
  banner b0_
WHERE
  b0_.is_active = 1
  AND (
    (
      b0_.start_date IS NULL
      OR b0_.start_date <= ?
    )
  )
  AND (
    (
      b0_.end_date IS NULL
      OR b0_.end_date >= ?
    )
  )
  AND b0_.position = ?
ORDER BY
  b0_.sort_order ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= 1780470752)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780470752)) AND b0_.position = 'header' ORDER BY b0_.sort_order ASC;

SELECT
  a0_.id AS id_0,
  a0_.page_type AS page_type_1,
  a0_.slot_name AS slot_name_2,
  a0_.display_name AS display_name_3,
  a0_.rotation_mode AS rotation_mode_4,
  a0_.allowed_formats AS allowed_formats_5,
  a0_.dimensions AS dimensions_6,
  a0_.is_active AS is_active_7,
  a0_.created_at AS created_at_8
FROM
  ad_slot a0_
WHERE
  a0_.page_type = ?
  AND a0_.slot_name = ?
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = 'model_profile' AND a0_.slot_name = 'model_profile-top-landscape' AND a0_.is_active = 1;

SELECT
  a0_.id AS id_0,
  a0_.priority AS priority_1,
  a0_.start_at AS start_at_2,
  a0_.end_at AS end_at_3,
  a0_.is_active AS is_active_4,
  a0_.created_at AS created_at_5,
  a0_.advert_id AS advert_id_6,
  a0_.ad_slot_id AS ad_slot_id_7
FROM
  ad_schedule a0_
  INNER JOIN advert a1_ ON a0_.advert_id = a1_.id
  INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id
WHERE
  a2_.page_type = ?
  AND a2_.slot_name = ?
  AND a2_.is_active = 1
  AND a0_.is_active = 1
  AND a1_.is_active = 1
  AND (
    (
      a0_.start_at IS NULL
      OR a0_.start_at <= ?
    )
  )
  AND (
    (
      a0_.end_at IS NULL
      OR a0_.end_at >= ?
    )
  )
ORDER BY
  a0_.priority DESC,
  a0_.created_at ASC

SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = 'model_profile' AND a2_.slot_name = 'model_profile-top-landscape' AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= '2026-06-03 09:12:32')) AND ((a0_.end_at IS NULL OR a0_.end_at >= '2026-06-03 09:12:32')) ORDER BY a0_.priority DESC, a0_.created_at ASC;

SELECT
  a0_.id AS id_0,
  a0_.page_type AS page_type_1,
  a0_.slot_name AS slot_name_2,
  a0_.display_name AS display_name_3,
  a0_.rotation_mode AS rotation_mode_4,
  a0_.allowed_formats AS allowed_formats_5,
  a0_.dimensions AS dimensions_6,
  a0_.is_active AS is_active_7,
  a0_.created_at AS created_at_8
FROM
  ad_slot a0_
WHERE
  a0_.page_type = ?
  AND a0_.slot_name = ?
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = 'model_profile' AND a0_.slot_name = 'model_profile-top-portrait' AND a0_.is_active = 1;

SELECT
  a0_.id AS id_0,
  a0_.priority AS priority_1,
  a0_.start_at AS start_at_2,
  a0_.end_at AS end_at_3,
  a0_.is_active AS is_active_4,
  a0_.created_at AS created_at_5,
  a0_.advert_id AS advert_id_6,
  a0_.ad_slot_id AS ad_slot_id_7
FROM
  ad_schedule a0_
  INNER JOIN advert a1_ ON a0_.advert_id = a1_.id
  INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id
WHERE
  a2_.page_type = ?
  AND a2_.slot_name = ?
  AND a2_.is_active = 1
  AND a0_.is_active = 1
  AND a1_.is_active = 1
  AND (
    (
      a0_.start_at IS NULL
      OR a0_.start_at <= ?
    )
  )
  AND (
    (
      a0_.end_at IS NULL
      OR a0_.end_at >= ?
    )
  )
ORDER BY
  a0_.priority DESC,
  a0_.created_at ASC

SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = 'model_profile' AND a2_.slot_name = 'model_profile-top-portrait' AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= '2026-06-03 09:12:32')) AND ((a0_.end_at IS NULL OR a0_.end_at >= '2026-06-03 09:12:32')) ORDER BY a0_.priority DESC, a0_.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.profile_id AS profile_id_5,
  t0.attribute_id AS attribute_id_6
FROM
  profile_attribute_value t0
WHERE
  t0.profile_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.profile_id AS profile_id_5, t0.attribute_id AS attribute_id_6 FROM profile_attribute_value t0 WHERE t0.profile_id = 37;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.field_type AS field_type_4,
  t0.status AS status_5,
  t0.is_visible AS is_visible_6,
  t0.is_functional AS is_functional_7,
  t0.default_value AS default_value_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  profile_attribute t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_type AS field_type_4, t0.status AS status_5, t0.is_visible AS is_visible_6, t0.is_functional AS is_functional_7, t0.default_value AS default_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM profile_attribute t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.field_type AS field_type_4,
  t0.status AS status_5,
  t0.is_visible AS is_visible_6,
  t0.is_functional AS is_functional_7,
  t0.default_value AS default_value_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  profile_attribute t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_type AS field_type_4, t0.status AS status_5, t0.is_visible AS is_visible_6, t0.is_functional AS is_functional_7, t0.default_value AS default_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM profile_attribute t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.field_type AS field_type_4,
  t0.status AS status_5,
  t0.is_visible AS is_visible_6,
  t0.is_functional AS is_functional_7,
  t0.default_value AS default_value_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  profile_attribute t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_type AS field_type_4, t0.status AS status_5, t0.is_visible AS is_visible_6, t0.is_functional AS is_functional_7, t0.default_value AS default_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM profile_attribute t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.field_type AS field_type_4,
  t0.status AS status_5,
  t0.is_visible AS is_visible_6,
  t0.is_functional AS is_functional_7,
  t0.default_value AS default_value_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  profile_attribute t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_type AS field_type_4, t0.status AS status_5, t0.is_visible AS is_visible_6, t0.is_functional AS is_functional_7, t0.default_value AS default_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM profile_attribute t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.field_type AS field_type_4,
  t0.status AS status_5,
  t0.is_visible AS is_visible_6,
  t0.is_functional AS is_functional_7,
  t0.default_value AS default_value_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  profile_attribute t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_type AS field_type_4, t0.status AS status_5, t0.is_visible AS is_visible_6, t0.is_functional AS is_functional_7, t0.default_value AS default_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM profile_attribute t0 WHERE t0.id = 5;