Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://sedaimmo.beaversoft.tech/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u879680891_sedadb"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u879680891_sedadb"
    "serverVersion" => "8"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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, p1_.ID AS ID_22, p1_.UUID AS UUID_23, p1_.SLUG AS SLUG_24, p1_.ADDRESS_DETAIL AS ADDRESS_DETAIL_25, p1_.LATITUDE AS LATITUDE_26, p1_.LONGITUDE AS LONGITUDE_27, p1_.SURFACE AS SURFACE_28, p1_.LAND_SURFACE AS LAND_SURFACE_29, p1_.BEDROOMS AS BEDROOMS_30, p1_.BATHROOMS AS BATHROOMS_31, p1_.ROOM_COUNT AS ROOM_COUNT_32, p1_.FLOOR_COUNT AS FLOOR_COUNT_33, p1_.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_34, p1_.PROPERTY_CONDITION AS PROPERTY_CONDITION_35, p1_.PROPERTY_NOTES AS PROPERTY_NOTES_36, p1_.TITLE AS TITLE_37, p1_.CREATED_AT AS CREATED_AT_38, p1_.UPDATED_AT AS UPDATED_AT_39, p1_.DELETED_AT AS DELETED_AT_40, g2_.ID AS ID_41, g2_.UUID AS UUID_42, g2_.SLUG AS SLUG_43, g2_.NAME AS NAME_44, g2_.NAME_LOCAL AS NAME_LOCAL_45, g2_.CODE AS CODE_46, g2_.ISO_CODE AS ISO_CODE_47, g2_.PHONE_PREFIX AS PHONE_PREFIX_48, g2_.LATITUDE AS LATITUDE_49, g2_.LONGITUDE AS LONGITUDE_50, g2_.IS_ACTIVE AS IS_ACTIVE_51, g2_.CREATED_AT AS CREATED_AT_52, g2_.UPDATED_AT AS UPDATED_AT_53, g2_.DELETED_AT AS DELETED_AT_54, r3_.ID AS ID_55, r3_.UUID AS UUID_56, r3_.SLUG AS SLUG_57, r3_.CODE AS CODE_58, r3_.LABEL AS LABEL_59, r3_.SORT_ORDER AS SORT_ORDER_60, r3_.IS_ACTIVE AS IS_ACTIVE_61, r3_.CREATED_AT AS CREATED_AT_62, r3_.UPDATED_AT AS UPDATED_AT_63, r3_.DELETED_AT AS DELETED_AT_64, r4_.ID AS ID_65, r4_.UUID AS UUID_66, r4_.SLUG AS SLUG_67, r4_.CODE AS CODE_68, r4_.LABEL AS LABEL_69, r4_.SORT_ORDER AS SORT_ORDER_70, r4_.IS_ACTIVE AS IS_ACTIVE_71, r4_.CREATED_AT AS CREATED_AT_72, r4_.UPDATED_AT AS UPDATED_AT_73, r4_.DELETED_AT AS DELETED_AT_74, r5_.ID AS ID_75, r5_.UUID AS UUID_76, r5_.SLUG AS SLUG_77, r5_.CODE AS CODE_78, r5_.LABEL AS LABEL_79, r5_.SORT_ORDER AS SORT_ORDER_80, r5_.IS_ACTIVE AS IS_ACTIVE_81, r5_.CREATED_AT AS CREATED_AT_82, r5_.UPDATED_AT AS UPDATED_AT_83, r5_.DELETED_AT AS DELETED_AT_84, l0_.PROPERTY AS PROPERTY_85, l0_.SUBMITTED_BY AS SUBMITTED_BY_86, l0_.TRANSACTION_TYPE AS TRANSACTION_TYPE_87, l0_.STATUS AS STATUS_88, l0_.PRICE_MODE AS PRICE_MODE_89, l0_.VALIDATED_BY AS VALIDATED_BY_90, l0_.PUBLISHED_BY AS PUBLISHED_BY_91, p1_.OWNER AS OWNER_92, p1_.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_93, p1_.PROPERTY_TYPE AS PROPERTY_TYPE_94, p1_.STATUS AS STATUS_95, p1_.LOCATION AS LOCATION_96, p1_.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_97, g2_.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_98, g2_.PARENT AS PARENT_99, r3_.DOMAIN AS DOMAIN_100, r4_.DOMAIN AS DOMAIN_101, r5_.DOMAIN AS DOMAIN_102 FROM listing l0_ INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID INNER JOIN geographic_entity g2_ ON p1_.LOCATION = g2_.ID INNER JOIN ref_value r3_ ON p1_.PROPERTY_TYPE = r3_.ID INNER JOIN ref_value r4_ ON l0_.STATUS = r4_.ID INNER JOIN ref_value r5_ ON l0_.TRANSACTION_TYPE = r5_.ID WHERE l0_.DELETED_AT IS NULL AND p1_.DELETED_AT IS NULL AND r4_.CODE = ? AND l0_.IS_SPONSORED = 1 ORDER BY l0_.PUBLISHED_AT DESC LIMIT 4"
  "params" => [
    1 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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, p1_.ID AS ID_22, p1_.UUID AS UUID_23, p1_.SLUG AS SLUG_24, p1_.ADDRESS_DETAIL AS ADDRESS_DETAIL_25, p1_.LATITUDE AS LATITUDE_26, p1_.LONGITUDE AS LONGITUDE_27, p1_.SURFACE AS SURFACE_28, p1_.LAND_SURFACE AS LAND_SURFACE_29, p1_.BEDROOMS AS BEDROOMS_30, p1_.BATHROOMS AS BATHROOMS_31, p1_.ROOM_COUNT AS ROOM_COUNT_32, p1_.FLOOR_COUNT AS FLOOR_COUNT_33, p1_.CONSTRUCTION_YEAR AS CONSTRUCTION_YEAR_34, p1_.PROPERTY_CONDITION AS PROPERTY_CONDITION_35, p1_.PROPERTY_NOTES AS PROPERTY_NOTES_36, p1_.TITLE AS TITLE_37, p1_.CREATED_AT AS CREATED_AT_38, p1_.UPDATED_AT AS UPDATED_AT_39, p1_.DELETED_AT AS DELETED_AT_40, g2_.ID AS ID_41, g2_.UUID AS UUID_42, g2_.SLUG AS SLUG_43, g2_.NAME AS NAME_44, g2_.NAME_LOCAL AS NAME_LOCAL_45, g2_.CODE AS CODE_46, g2_.ISO_CODE AS ISO_CODE_47, g2_.PHONE_PREFIX AS PHONE_PREFIX_48, g2_.LATITUDE AS LATITUDE_49, g2_.LONGITUDE AS LONGITUDE_50, g2_.IS_ACTIVE AS IS_ACTIVE_51, g2_.CREATED_AT AS CREATED_AT_52, g2_.UPDATED_AT AS UPDATED_AT_53, g2_.DELETED_AT AS DELETED_AT_54, r3_.ID AS ID_55, r3_.UUID AS UUID_56, r3_.SLUG AS SLUG_57, r3_.CODE AS CODE_58, r3_.LABEL AS LABEL_59, r3_.SORT_ORDER AS SORT_ORDER_60, r3_.IS_ACTIVE AS IS_ACTIVE_61, r3_.CREATED_AT AS CREATED_AT_62, r3_.UPDATED_AT AS UPDATED_AT_63, r3_.DELETED_AT AS DELETED_AT_64, r4_.ID AS ID_65, r4_.UUID AS UUID_66, r4_.SLUG AS SLUG_67, r4_.CODE AS CODE_68, r4_.LABEL AS LABEL_69, r4_.SORT_ORDER AS SORT_ORDER_70, r4_.IS_ACTIVE AS IS_ACTIVE_71, r4_.CREATED_AT AS CREATED_AT_72, r4_.UPDATED_AT AS UPDATED_AT_73, r4_.DELETED_AT AS DELETED_AT_74, r5_.ID AS ID_75, r5_.UUID AS UUID_76, r5_.SLUG AS SLUG_77, r5_.CODE AS CODE_78, r5_.LABEL AS LABEL_79, r5_.SORT_ORDER AS SORT_ORDER_80, r5_.IS_ACTIVE AS IS_ACTIVE_81, r5_.CREATED_AT AS CREATED_AT_82, r5_.UPDATED_AT AS UPDATED_AT_83, r5_.DELETED_AT AS DELETED_AT_84, l0_.PROPERTY AS PROPERTY_85, l0_.SUBMITTED_BY AS SUBMITTED_BY_86, l0_.TRANSACTION_TYPE AS TRANSACTION_TYPE_87, l0_.STATUS AS STATUS_88, l0_.PRICE_MODE AS PRICE_MODE_89, l0_.VALIDATED_BY AS VALIDATED_BY_90, l0_.PUBLISHED_BY AS PUBLISHED_BY_91, p1_.OWNER AS OWNER_92, p1_.DECLARED_PRIMARY_PARTY AS DECLARED_PRIMARY_PARTY_93, p1_.PROPERTY_TYPE AS PROPERTY_TYPE_94, p1_.STATUS AS STATUS_95, p1_.LOCATION AS LOCATION_96, p1_.LOCATION_VISIBILITY AS LOCATION_VISIBILITY_97, g2_.GEOGRAPHIC_ENTITY_TYPE AS GEOGRAPHIC_ENTITY_TYPE_98, g2_.PARENT AS PARENT_99, r3_.DOMAIN AS DOMAIN_100, r4_.DOMAIN AS DOMAIN_101, r5_.DOMAIN AS DOMAIN_102 FROM listing l0_ INNER JOIN property p1_ ON l0_.PROPERTY = p1_.ID INNER JOIN geographic_entity g2_ ON p1_.LOCATION = g2_.ID INNER JOIN ref_value r3_ ON p1_.PROPERTY_TYPE = r3_.ID INNER JOIN ref_value r4_ ON l0_.STATUS = r4_.ID INNER JOIN ref_value r5_ ON l0_.TRANSACTION_TYPE = r5_.ID WHERE l0_.DELETED_AT IS NULL AND p1_.DELETED_AT IS NULL AND r4_.CODE = ? AND l0_.IS_SPONSORED = 0 ORDER BY l0_.PUBLISHED_AT DESC LIMIT 6"
  "params" => [
    1 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "PROPERTY_TYPE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1226
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 100
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 104
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 101
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 102
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "banner-top-accueil"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 >= ?"
  "params" => [
    1 => 1
    2 => "2026-04-29 07:43:15"
    3 => "2026-04-29 07:43:15"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#755
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#692}
  ]
]

[
  "sql" => "UPDATE ad_banner SET IMPRESSIONS_COUNT = ?, UPDATED_AT = ? WHERE ID = ?"
  "params" => [
    1 => 8676
    2 => "2026-04-29 07:43:15"
    3 => 100
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#755
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#692}
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 107
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 103
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#692
      +name: "STRING"
    }
  ]
]