Symfony Profiler

SELECT
  DISTINCT l0_.ID AS ID_0,
  l0_.IS_SPONSORED AS IS_SPONSORED_1,
  l0_.PUBLISHED_AT AS PUBLISHED_AT_2
FROM
  listing l0_
  INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID
  INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID
  INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID
  LEFT JOIN listing_media l4_ ON l0_.ID = l4_.LISTING
WHERE
  l0_.DELETED_AT IS NULL
  AND p1_.DELETED_AT IS NULL
  AND r2_.CODE = ?
  AND r3_.CODE = ?
ORDER BY
  l0_.IS_SPONSORED DESC,
  l0_.PUBLISHED_AT DESC
LIMIT
  12

SELECT DISTINCT l0_.ID AS ID_0, l0_.IS_SPONSORED AS IS_SPONSORED_1, l0_.PUBLISHED_AT AS PUBLISHED_AT_2 FROM listing l0_ INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID LEFT JOIN listing_media l4_ ON l0_.ID = l4_.LISTING WHERE l0_.DELETED_AT IS NULL AND p1_.DELETED_AT IS NULL AND r2_.CODE = 'published' AND r3_.CODE = 'rent' ORDER BY l0_.IS_SPONSORED DESC, l0_.PUBLISHED_AT DESC LIMIT 12;

SELECT
  t0.ID AS ID_1,
  t0.UUID AS UUID_2,
  t0.SLUG AS SLUG_3,
  t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4,
  t0.LATITUDE AS LATITUDE_5,
  t0.LONGITUDE AS LONGITUDE_6,
  t0.SURFACE AS SURFACE_7,
  t0.LAND_SURFACE AS LAND_SURFACE_8,
  t0.BEDROOMS AS BEDROOMS_9,
  t0.BATHROOMS AS BATHROOMS_10,
  t0.ROOM_COUNT AS ROOM_COUNT_11,
  t0.FLOOR_COUNT AS FLOOR_COUNT_12,
  t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13,
  t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14,
  t0.PROPERTY_NOTES AS PROPERTY_NOTES_15,
  t0.TITLE AS TITLE_16,
  t0.CREATED_AT AS CREATED_AT_17,
  t0.UPDATED_AT AS UPDATED_AT_18,
  t0.DELETED_AT AS DELETED_AT_19,
  t0.OWNER AS OWNER_20,
  t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21,
  t0.PROPERTY_TYPE AS PROPERTY_TYPE_22,
  t0.STATUS AS STATUS_23,
  t0.LOCATION AS LOCATION_24,
  t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25
FROM
  property t0
WHERE
  t0.ID = ?

SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.ADDRESS_DETAIL AS ADDRESS_DETAIL_4, t0.LATITUDE AS LATITUDE_5, t0.LONGITUDE AS LONGITUDE_6, t0.SURFACE AS SURFACE_7, t0.LAND_SURFACE AS LAND_SURFACE_8, t0.BEDROOMS AS BEDROOMS_9, t0.BATHROOMS AS BATHROOMS_10, t0.ROOM_COUNT AS ROOM_COUNT_11, t0.FLOOR_COUNT AS FLOOR_COUNT_12, t0.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_13, t0.PROPERTY_CONDITION AS PROPERTY_CONDITION_14, t0.PROPERTY_NOTES AS PROPERTY_NOTES_15, t0.TITLE AS TITLE_16, t0.CREATED_AT AS CREATED_AT_17, t0.UPDATED_AT AS UPDATED_AT_18, t0.DELETED_AT AS DELETED_AT_19, t0.OWNER AS OWNER_20, t0.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_21, t0.PROPERTY_TYPE AS PROPERTY_TYPE_22, t0.STATUS AS STATUS_23, t0.LOCATION AS LOCATION_24, t0.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_25 FROM property t0 WHERE t0.ID = 101;

SELECT
  t0.ID AS ID_1,
  t0.UUID AS UUID_2,
  t0.FILE_PATH AS FILE_PATH_3,
  t0.FILE_NAME AS FILE_NAME_4,
  t0.MIME_TYPE AS MIME_TYPE_5,
  t0.FILE_SIZE AS FILE_SIZE_6,
  t0.CAPTION AS CAPTION_7,
  t0.IS_COVER AS IS_COVER_8,
  t0.SORT_ORDER AS SORT_ORDER_9,
  t0.CREATED_AT AS CREATED_AT_10,
  t0.UPDATED_AT AS UPDATED_AT_11,
  t0.DELETED_AT AS DELETED_AT_12,
  t0.LISTING AS LISTING_13,
  t0.MEDIA_TYPE AS MEDIA_TYPE_14
FROM
  listing_media t0
WHERE
  t0.LISTING = ?

SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.FILE_PATH AS FILE_PATH_3, t0.FILE_NAME AS FILE_NAME_4, t0.MIME_TYPE AS MIME_TYPE_5, t0.FILE_SIZE AS FILE_SIZE_6, t0.CAPTION AS CAPTION_7, t0.IS_COVER AS IS_COVER_8, t0.SORT_ORDER AS SORT_ORDER_9, t0.CREATED_AT AS CREATED_AT_10, t0.UPDATED_AT AS UPDATED_AT_11, t0.DELETED_AT AS DELETED_AT_12, t0.LISTING AS LISTING_13, t0.MEDIA_TYPE AS MEDIA_TYPE_14 FROM listing_media t0 WHERE t0.LISTING = 101;

SELECT
  t0.ID AS ID_1,
  t0.UUID AS UUID_2,
  t0.SLUG AS SLUG_3,
  t0.NAME AS NAME_4,
  t0.NAME_LOCAL AS NAME_LOCAL_5,
  t0.CODE AS CODE_6,
  t0.ISO_CODE AS ISO_CODE_7,
  t0.PHONE_PREFIX AS PHONE_PREFIX_8,
  t0.LATITUDE AS LATITUDE_9,
  t0.LONGITUDE AS LONGITUDE_10,
  t0.IS_ACTIVE AS IS_ACTIVE_11,
  t0.CREATED_AT AS CREATED_AT_12,
  t0.UPDATED_AT AS UPDATED_AT_13,
  t0.DELETED_AT AS DELETED_AT_14,
  t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15,
  t0.PARENT AS PARENT_16
FROM
  geographic_entity t0
WHERE
  t0.ID = ?

SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.NAME AS NAME_4, t0.NAME_LOCAL AS NAME_LOCAL_5, t0.CODE AS CODE_6, t0.ISO_CODE AS ISO_CODE_7, t0.PHONE_PREFIX AS PHONE_PREFIX_8, t0.LATITUDE AS LATITUDE_9, t0.LONGITUDE AS LONGITUDE_10, t0.IS_ACTIVE AS IS_ACTIVE_11, t0.CREATED_AT AS CREATED_AT_12, t0.UPDATED_AT AS UPDATED_AT_13, t0.DELETED_AT AS DELETED_AT_14, t0.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_15, t0.PARENT AS PARENT_16 FROM geographic_entity t0 WHERE t0.ID = 53;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  a0_.ID AS ID_0,
  a0_.UUID AS UUID_1,
  a0_.IMAGE_PATH AS IMAGE_PATH_2,
  a0_.TARGET_URL AS TARGET_URL_3,
  a0_.ALT_TEXT AS ALT_TEXT_4,
  a0_.IS_ACTIVE AS IS_ACTIVE_5,
  a0_.IMPRESSIONS_COUNT AS IMPRESSIONS_COUNT_6,
  a0_.CLICKS_COUNT AS CLICKS_COUNT_7,
  a0_.CREATED_AT AS CREATED_AT_8,
  a0_.UPDATED_AT AS UPDATED_AT_9,
  a1_.ID AS ID_10,
  a1_.UUID AS UUID_11,
  a1_.NAME AS NAME_12,
  a1_.ADVERTISER_NAME AS ADVERTISER_NAME_13,
  a1_.STARTS_AT AS STARTS_AT_14,
  a1_.ENDS_AT AS ENDS_AT_15,
  a1_.BUDGET AS BUDGET_16,
  a1_.NOTES AS NOTES_17,
  a1_.CREATED_AT AS CREATED_AT_18,
  a1_.UPDATED_AT AS UPDATED_AT_19,
  a0_.CAMPAIGN AS CAMPAIGN_20,
  a0_.AD_SLOT AS AD_SLOT_21,
  a1_.STATUS AS STATUS_22
FROM
  ad_banner a0_
  INNER JOIN ad_campaign a1_ ON a0_.CAMPAIGN = a1_.ID
WHERE
  a0_.AD_SLOT = ?
  AND a0_.IS_ACTIVE = 1
  AND a1_.STARTS_AT <= ?
  AND a1_.ENDS_AT >= ?

SELECT a0_.ID AS ID_0, a0_.UUID AS UUID_1, a0_.IMAGE_PATH AS IMAGE_PATH_2, a0_.TARGET_URL AS TARGET_URL_3, a0_.ALT_TEXT AS ALT_TEXT_4, a0_.IS_ACTIVE AS IS_ACTIVE_5, a0_.IMPRESSIONS_COUNT AS IMPRESSIONS_COUNT_6, a0_.CLICKS_COUNT AS CLICKS_COUNT_7, a0_.CREATED_AT AS CREATED_AT_8, a0_.UPDATED_AT AS UPDATED_AT_9, a1_.ID AS ID_10, a1_.UUID AS UUID_11, a1_.NAME AS NAME_12, a1_.ADVERTISER_NAME AS ADVERTISER_NAME_13, a1_.STARTS_AT AS STARTS_AT_14, a1_.ENDS_AT AS ENDS_AT_15, a1_.BUDGET AS BUDGET_16, a1_.NOTES AS NOTES_17, a1_.CREATED_AT AS CREATED_AT_18, a1_.UPDATED_AT AS UPDATED_AT_19, a0_.CAMPAIGN AS CAMPAIGN_20, a0_.AD_SLOT AS AD_SLOT_21, a1_.STATUS AS STATUS_22 FROM ad_banner a0_ INNER JOIN ad_campaign a1_ ON a0_.CAMPAIGN = a1_.ID WHERE a0_.AD_SLOT = 2 AND a0_.IS_ACTIVE = 1 AND a1_.STARTS_AT <= '2026-04-29 08:37:26' AND a1_.ENDS_AT >= '2026-04-29 08:37:26';

SELECT
  l0_.ID AS ID_0,
  l0_.UUID AS UUID_1,
  l0_.SLUG AS SLUG_2,
  l0_.TITLE AS TITLE_3,
  l0_.DESCRIPTION AS DESCRIPTION_4,
  l0_.PRICE AS PRICE_5,
  l0_.PRICE_MIN AS PRICE_MIN_6,
  l0_.PRICE_MAX AS PRICE_MAX_7,
  l0_.CURRENCY AS CURRENCY_8,
  l0_.IS_PRICE_VISIBLE AS IS_PRICE_VISIBLE_9,
  l0_.IS_SPONSORED AS IS_SPONSORED_10,
  l0_.SPONSORED_UNTIL AS SPONSORED_UNTIL_11,
  l0_.VIEWS_COUNT AS VIEWS_COUNT_12,
  l0_.REJECTION_REASON AS REJECTION_REASON_13,
  l0_.CORRECTION_NOTES AS CORRECTION_NOTES_14,
  l0_.SUBMITTED_AT AS SUBMITTED_AT_15,
  l0_.VALIDATED_AT AS VALIDATED_AT_16,
  l0_.PUBLISHED_AT AS PUBLISHED_AT_17,
  l0_.EXPIRES_AT AS EXPIRES_AT_18,
  l0_.CREATED_AT AS CREATED_AT_19,
  l0_.UPDATED_AT AS UPDATED_AT_20,
  l0_.DELETED_AT AS DELETED_AT_21,
  l0_.PROPERTY AS PROPERTY_22,
  l0_.SUBMITTED_BY AS SUBMITTED_BY_23,
  l0_.TRANSACTION_TYPE AS TRANSACTION_TYPE_24,
  l0_.STATUS AS STATUS_25,
  l0_.PRICE_MODE AS PRICE_MODE_26,
  l0_.VALIDATED_BY AS VALIDATED_BY_27,
  l0_.PUBLISHED_BY AS PUBLISHED_BY_28
FROM
  listing l0_
  INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID
  INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID
  INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID
  LEFT JOIN listing_media l4_ ON l0_.ID = l4_.LISTING
WHERE
  l0_.DELETED_AT IS NULL
  AND p1_.DELETED_AT IS NULL
  AND r2_.CODE = ?
  AND r3_.CODE = ?
  AND l0_.ID IN (?, ?, ?, ?)
ORDER BY
  l0_.IS_SPONSORED DESC,
  l0_.PUBLISHED_AT DESC

SELECT l0_.ID AS ID_0, l0_.UUID AS UUID_1, l0_.SLUG AS SLUG_2, l0_.TITLE AS TITLE_3, l0_.DESCRIPTION AS DESCRIPTION_4, l0_.PRICE AS PRICE_5, l0_.PRICE_MIN AS PRICE_MIN_6, l0_.PRICE_MAX AS PRICE_MAX_7, l0_.CURRENCY AS CURRENCY_8, l0_.IS_PRICE_VISIBLE AS IS_PRICE_VISIBLE_9, l0_.IS_SPONSORED AS IS_SPONSORED_10, l0_.SPONSORED_UNTIL AS SPONSORED_UNTIL_11, l0_.VIEWS_COUNT AS VIEWS_COUNT_12, l0_.REJECTION_REASON AS REJECTION_REASON_13, l0_.CORRECTION_NOTES AS CORRECTION_NOTES_14, l0_.SUBMITTED_AT AS SUBMITTED_AT_15, l0_.VALIDATED_AT AS VALIDATED_AT_16, l0_.PUBLISHED_AT AS PUBLISHED_AT_17, l0_.EXPIRES_AT AS EXPIRES_AT_18, l0_.CREATED_AT AS CREATED_AT_19, l0_.UPDATED_AT AS UPDATED_AT_20, l0_.DELETED_AT AS DELETED_AT_21, l0_.PROPERTY AS PROPERTY_22, l0_.SUBMITTED_BY AS SUBMITTED_BY_23, l0_.TRANSACTION_TYPE AS TRANSACTION_TYPE_24, l0_.STATUS AS STATUS_25, l0_.PRICE_MODE AS PRICE_MODE_26, l0_.VALIDATED_BY AS VALIDATED_BY_27, l0_.PUBLISHED_BY AS PUBLISHED_BY_28 FROM listing l0_ INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID LEFT JOIN listing_media l4_ ON l0_.ID = l4_.LISTING WHERE l0_.DELETED_AT IS NULL AND p1_.DELETED_AT IS NULL AND r2_.CODE = 'published' AND r3_.CODE = 'rent' AND l0_.ID IN (101, 107, 103, 105) ORDER BY l0_.IS_SPONSORED DESC, l0_.PUBLISHED_AT DESC;

SELECT
  t0.ID AS ID_1,
  t0.UUID AS UUID_2,
  t0.CODE AS CODE_3,
  t0.NAME AS NAME_4,
  t0.DESCRIPTION AS DESCRIPTION_5,
  t0.WIDTH AS WIDTH_6,
  t0.HEIGHT AS HEIGHT_7,
  t0.IS_ACTIVE AS IS_ACTIVE_8,
  t0.CREATED_AT AS CREATED_AT_9,
  t0.UPDATED_AT AS UPDATED_AT_10
FROM
  ad_slot t0
WHERE
  t0.CODE = ?
LIMIT
  1

SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.CODE AS CODE_3, t0.NAME AS NAME_4, t0.DESCRIPTION AS DESCRIPTION_5, t0.WIDTH AS WIDTH_6, t0.HEIGHT AS HEIGHT_7, t0.IS_ACTIVE AS IS_ACTIVE_8, t0.CREATED_AT AS CREATED_AT_9, t0.UPDATED_AT AS UPDATED_AT_10 FROM ad_slot t0 WHERE t0.CODE = 'sidebar-annonces' LIMIT 1;

SELECT
  t0.ID AS ID_1,
  t0.UUID AS UUID_2,
  t0.SLUG AS SLUG_3,
  t0.CODE AS CODE_4,
  t0.LABEL AS LABEL_5,
  t0.SORT_ORDER AS SORT_ORDER_6,
  t0.IS_ACTIVE AS IS_ACTIVE_7,
  t0.CREATED_AT AS CREATED_AT_8,
  t0.UPDATED_AT AS UPDATED_AT_9,
  t0.DELETED_AT AS DELETED_AT_10,
  t0.DOMAIN AS DOMAIN_11
FROM
  ref_value t0
WHERE
  t0.ID = ?

SELECT t0.ID AS ID_1, t0.UUID AS UUID_2, t0.SLUG AS SLUG_3, t0.CODE AS CODE_4, t0.LABEL AS LABEL_5, t0.SORT_ORDER AS SORT_ORDER_6, t0.IS_ACTIVE AS IS_ACTIVE_7, t0.CREATED_AT AS CREATED_AT_8, t0.UPDATED_AT AS UPDATED_AT_9, t0.DELETED_AT AS DELETED_AT_10, t0.DOMAIN AS DOMAIN_11 FROM ref_value t0 WHERE t0.ID = 1154;

SELECT
  count(DISTINCT l0_.ID) AS sclr_0
FROM
  listing l0_
  INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID
  INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID
  INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID
  LEFT JOIN listing_media l4_ ON l0_.ID = l4_.LISTING
WHERE
  l0_.DELETED_AT IS NULL
  AND p1_.DELETED_AT IS NULL
  AND r2_.CODE = ?
  AND r3_.CODE = ?

SELECT count(DISTINCT l0_.ID) AS sclr_0 FROM listing l0_ INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID INNER JOIN ref_value r2_ ON l0_.STATUS = r2_.ID INNER JOIN ref_value r3_ ON l0_.TRANSACTION_TYPE = r3_.ID LEFT JOIN listing_media l4_ ON l0_.ID = l4_.LISTING WHERE l0_.DELETED_AT IS NULL AND p1_.DELETED_AT IS NULL AND r2_.CODE = 'published' AND r3_.CODE = 'rent';

SELECT
  r0_.ID AS ID_0,
  r0_.UUID AS UUID_1,
  r0_.SLUG AS SLUG_2,
  r0_.CODE AS CODE_3,
  r0_.LABEL AS LABEL_4,
  r0_.SORT_ORDER AS SORT_ORDER_5,
  r0_.IS_ACTIVE AS IS_ACTIVE_6,
  r0_.CREATED_AT AS CREATED_AT_7,
  r0_.UPDATED_AT AS UPDATED_AT_8,
  r0_.DELETED_AT AS DELETED_AT_9,
  r0_.DOMAIN AS DOMAIN_10
FROM
  ref_value r0_
  INNER JOIN ref_domain r1_ ON r0_.DOMAIN = r1_.ID
WHERE
  r1_.CODE = ?
  AND r0_.IS_ACTIVE = 1
  AND r0_.DELETED_AT IS NULL
ORDER BY
  r0_.SORT_ORDER ASC

SELECT r0_.ID AS ID_0, r0_.UUID AS UUID_1, r0_.SLUG AS SLUG_2, r0_.CODE AS CODE_3, r0_.LABEL AS LABEL_4, r0_.SORT_ORDER AS SORT_ORDER_5, r0_.IS_ACTIVE AS IS_ACTIVE_6, r0_.CREATED_AT AS CREATED_AT_7, r0_.UPDATED_AT AS UPDATED_AT_8, r0_.DELETED_AT AS DELETED_AT_9, r0_.DOMAIN AS DOMAIN_10 FROM ref_value r0_ INNER JOIN ref_domain r1_ ON r0_.DOMAIN = r1_.ID WHERE r1_.CODE = 'PROPERTY_TYPE' AND r0_.IS_ACTIVE = 1 AND r0_.DELETED_AT IS NULL ORDER BY r0_.SORT_ORDER ASC;

UPDATE
  ad_banner
SET
  IMPRESSIONS_COUNT = ?,
  UPDATED_AT = ?
WHERE
  ID = ?

UPDATE ad_banner SET IMPRESSIONS_COUNT = 4305, UPDATED_AT = '2026-04-29 08:37:26' WHERE ID = 101;

"COMMIT"

"COMMIT";