Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.num_value AS num_value_3,
  t0.bool_value AS bool_value_4,
  t0.string_value AS string_value_5
FROM
  parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.num_value AS num_value_3, t0.bool_value AS bool_value_4, t0.string_value AS string_value_5 FROM parameter t0;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.title AS title_3,
  t0.address AS address_4,
  t0.address_lat AS address_lat_5,
  t0.address_lng AS address_lng_6,
  t0.description AS description_7,
  t0.information AS information_8,
  t0.price AS price_9,
  t0.visit_price AS visit_price_10,
  t0.currency AS currency_11,
  t0.purpose AS purpose_12,
  t0.type AS type_13,
  t0.new_real_state AS new_real_state_14,
  t0.piece AS piece_15,
  t0.surface AS surface_16,
  t0.virtual_tour_id AS virtual_tour_id_17,
  t0.youtube_id AS youtube_id_18,
  t0.status AS status_19,
  t0.payment_process_type AS payment_process_type_20,
  t0.updated_at AS updated_at_21,
  t0.land_document_type AS land_document_type_22,
  t0.land_document_id AS land_document_id_23,
  t0.priority AS priority_24,
  t0.owner_id AS owner_id_25,
  t0.main_advert_id AS main_advert_id_26
FROM
  advert t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.address AS address_4, t0.address_lat AS address_lat_5, t0.address_lng AS address_lng_6, t0.description AS description_7, t0.information AS information_8, t0.price AS price_9, t0.visit_price AS visit_price_10, t0.currency AS currency_11, t0.purpose AS purpose_12, t0.type AS type_13, t0.new_real_state AS new_real_state_14, t0.piece AS piece_15, t0.surface AS surface_16, t0.virtual_tour_id AS virtual_tour_id_17, t0.youtube_id AS youtube_id_18, t0.status AS status_19, t0.payment_process_type AS payment_process_type_20, t0.updated_at AS updated_at_21, t0.land_document_type AS land_document_type_22, t0.land_document_id AS land_document_id_23, t0.priority AS priority_24, t0.owner_id AS owner_id_25, t0.main_advert_id AS main_advert_id_26 FROM advert t0 WHERE t0.id = '3' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.auth_code AS auth_code_3,
  t0.trusted_version AS trusted_version_4,
  t0.enabled AS enabled_5,
  t0.verified AS verified_6,
  t0.banned AS banned_7,
  t0.password AS password_8,
  t0.reset_token AS reset_token_9,
  t0.last_login AS last_login_10,
  t0.roles AS roles_11,
  t0.date AS date_12,
  t0.profile_picture AS profile_picture_13,
  t0.first_name AS first_name_14,
  t0.last_name AS last_name_15,
  t0.id_card_number AS id_card_number_16,
  t0.orbus_api_signer_id AS orbus_api_signer_id_17,
  t0.company_name AS company_name_18,
  t0.ninea AS ninea_19,
  t0.type AS type_20,
  t0.phone AS phone_21,
  t0.about_me AS about_me_22,
  t0.address AS address_23,
  t0.address_lat AS address_lat_24,
  t0.address_lng AS address_lng_25,
  t0.facebook AS facebook_26,
  t0.whatsapp AS whatsapp_27,
  t0.twitter AS twitter_28,
  t0.google AS google_29,
  t0.website AS website_30,
  t0.social_id AS social_id_31,
  t0.api_token AS api_token_32,
  t0.main_user_id AS main_user_id_33,
  t34.id AS id_35,
  t34.alert_notified AS alert_notified_36,
  t34.appraisal_notified AS appraisal_notified_37,
  t34.user_id AS user_id_38
FROM
  user t0
  LEFT JOIN user_parameter t34 ON t34.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.trusted_version AS trusted_version_4, t0.enabled AS enabled_5, t0.verified AS verified_6, t0.banned AS banned_7, t0.password AS password_8, t0.reset_token AS reset_token_9, t0.last_login AS last_login_10, t0.roles AS roles_11, t0.date AS date_12, t0.profile_picture AS profile_picture_13, t0.first_name AS first_name_14, t0.last_name AS last_name_15, t0.id_card_number AS id_card_number_16, t0.orbus_api_signer_id AS orbus_api_signer_id_17, t0.company_name AS company_name_18, t0.ninea AS ninea_19, t0.type AS type_20, t0.phone AS phone_21, t0.about_me AS about_me_22, t0.address AS address_23, t0.address_lat AS address_lat_24, t0.address_lng AS address_lng_25, t0.facebook AS facebook_26, t0.whatsapp AS whatsapp_27, t0.twitter AS twitter_28, t0.google AS google_29, t0.website AS website_30, t0.social_id AS social_id_31, t0.api_token AS api_token_32, t0.main_user_id AS main_user_id_33, t34.id AS id_35, t34.alert_notified AS alert_notified_36, t34.appraisal_notified AS appraisal_notified_37, t34.user_id AS user_id_38 FROM user t0 LEFT JOIN user_parameter t34 ON t34.user_id = t0.id WHERE t0.id = 10036;

SELECT
  t0.id AS id_1,
  t0.address_ip AS address_ip_2
FROM
  adressage t0
WHERE
  t0.address_ip = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.address_ip AS address_ip_2 FROM adressage t0 WHERE t0.address_ip = '216.73.216.223' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO adressage (address_ip)
VALUES
  (?)

INSERT INTO adressage (address_ip) VALUES ('216.73.216.223');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.address_ip AS address_ip_2
FROM
  adressage t0
  INNER JOIN advert_adressage ON t0.id = advert_adressage.adressage_id
WHERE
  advert_adressage.advert_id = ?

SELECT t0.id AS id_1, t0.address_ip AS address_ip_2 FROM adressage t0 INNER JOIN advert_adressage ON t0.id = advert_adressage.adressage_id WHERE advert_adressage.advert_id = 3;

SELECT
  t0.id AS id_1,
  t0.address_ip AS address_ip_2
FROM
  adressage t0
WHERE
  t0.address_ip = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.address_ip AS address_ip_2 FROM adressage t0 WHERE t0.address_ip = '216.73.216.223' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO advert_adressage (advert_id, adressage_id)
VALUES
  (?, ?)

INSERT INTO advert_adressage (advert_id, adressage_id) VALUES (3, 26);

"COMMIT"

"COMMIT";

SELECT
  a0_.id AS id_0,
  a0_.date AS date_1,
  a0_.title AS title_2,
  a0_.address AS address_3,
  a0_.address_lat AS address_lat_4,
  a0_.address_lng AS address_lng_5,
  a0_.description AS description_6,
  a0_.information AS information_7,
  a0_.price AS price_8,
  a0_.visit_price AS visit_price_9,
  a0_.currency AS currency_10,
  a0_.purpose AS purpose_11,
  a0_.type AS type_12,
  a0_.new_real_state AS new_real_state_13,
  a0_.piece AS piece_14,
  a0_.surface AS surface_15,
  a0_.virtual_tour_id AS virtual_tour_id_16,
  a0_.youtube_id AS youtube_id_17,
  a0_.status AS status_18,
  a0_.payment_process_type AS payment_process_type_19,
  a0_.updated_at AS updated_at_20,
  a0_.land_document_type AS land_document_type_21,
  a0_.land_document_id AS land_document_id_22,
  a0_.priority AS priority_23,
  a0_.owner_id AS owner_id_24,
  a0_.main_advert_id AS main_advert_id_25
FROM
  advert a0_
  INNER JOIN user u1_ ON a0_.owner_id = u1_.id
  AND (u1_.enabled = 1)
WHERE
  a0_.purpose LIKE ?
  AND a0_.type LIKE ?
  AND a0_.id <> ?
  AND a0_.status LIKE ?
ORDER BY
  a0_.date DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.title AS title_2, a0_.address AS address_3, a0_.address_lat AS address_lat_4, a0_.address_lng AS address_lng_5, a0_.description AS description_6, a0_.information AS information_7, a0_.price AS price_8, a0_.visit_price AS visit_price_9, a0_.currency AS currency_10, a0_.purpose AS purpose_11, a0_.type AS type_12, a0_.new_real_state AS new_real_state_13, a0_.piece AS piece_14, a0_.surface AS surface_15, a0_.virtual_tour_id AS virtual_tour_id_16, a0_.youtube_id AS youtube_id_17, a0_.status AS status_18, a0_.payment_process_type AS payment_process_type_19, a0_.updated_at AS updated_at_20, a0_.land_document_type AS land_document_type_21, a0_.land_document_id AS land_document_id_22, a0_.priority AS priority_23, a0_.owner_id AS owner_id_24, a0_.main_advert_id AS main_advert_id_25 FROM advert a0_ INNER JOIN user u1_ ON a0_.owner_id = u1_.id AND (u1_.enabled = 1) WHERE a0_.purpose LIKE 'RENTAL' AND a0_.type LIKE 'ROOM_SEMINAR' AND a0_.id <> 3 AND a0_.status LIKE 'PUBLISHED' ORDER BY a0_.date DESC LIMIT 4;

SELECT
  b0_.id AS id_0
FROM
  booking b0_
WHERE
  b0_.client_id = ?
  AND b0_.property_id = ?
  AND (
    b0_.exit_date > CURRENT_DATE
    OR b0_.visit_date > CURRENT_DATE
  )
  AND b0_.status = ?

SELECT b0_.id AS id_0 FROM booking b0_ WHERE b0_.client_id = NULL AND b0_.property_id = 3 AND (b0_.exit_date > CURRENT_DATE OR b0_.visit_date > CURRENT_DATE) AND b0_.status = 'ACCEPTED';

SELECT
  c0_.id AS id_0
FROM
  contract c0_
WHERE
  c0_.contractor_id = ?
  AND c0_.property_id = ?
  AND c0_.end_date > CURRENT_DATE
  AND c0_.status = ?

SELECT c0_.id AS id_0 FROM contract c0_ WHERE c0_.contractor_id = NULL AND c0_.property_id = 3 AND c0_.end_date > CURRENT_DATE AND c0_.status = 'IN_PROGRESS';

SELECT
  t0_.id AS id_0
FROM
  transaction t0_
WHERE
  (
    t0_.contract_id IN (NULL)
    OR t0_.booking_id IN (NULL)
  )
  AND t0_.status LIKE ?

SELECT t0_.id AS id_0 FROM transaction t0_ WHERE (t0_.contract_id IN (NULL) OR t0_.booking_id IN (NULL)) AND t0_.status LIKE 'PAID';

SELECT
  r0_.id AS id_0,
  r0_.score AS score_1,
  r0_.avis AS avis_2,
  r0_.date AS date_3,
  r0_.updated_at AS updated_at_4,
  r0_.travel_booking_id AS travel_booking_id_5,
  r0_.booking_id AS booking_id_6,
  r0_.agency_id AS agency_id_7,
  r0_.user_id AS user_id_8
FROM
  review r0_
  INNER JOIN booking b1_ ON r0_.booking_id = b1_.id
  AND (b1_.property_id = ?)

SELECT r0_.id AS id_0, r0_.score AS score_1, r0_.avis AS avis_2, r0_.date AS date_3, r0_.updated_at AS updated_at_4, r0_.travel_booking_id AS travel_booking_id_5, r0_.booking_id AS booking_id_6, r0_.agency_id AS agency_id_7, r0_.user_id AS user_id_8 FROM review r0_ INNER JOIN booking b1_ ON r0_.booking_id = b1_.id AND (b1_.property_id = 3);

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.terms AS terms_3,
  t0.contractor_first_name AS contractor_first_name_4,
  t0.contractor_last_name AS contractor_last_name_5,
  t0.contractor_company_name AS contractor_company_name_6,
  t0.contractor_email AS contractor_email_7,
  t0.contractor_phone AS contractor_phone_8,
  t0.person_count AS person_count_9,
  t0.price AS price_10,
  t0.date AS date_11,
  t0.updated_at AS updated_at_12,
  t0.start_date AS start_date_13,
  t0.end_date AS end_date_14,
  t0.payment_process AS payment_process_15,
  t0.status AS status_16,
  t0.property_id AS property_id_17,
  t0.contractor_id AS contractor_id_18
FROM
  contract t0
WHERE
  t0.property_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.terms AS terms_3, t0.contractor_first_name AS contractor_first_name_4, t0.contractor_last_name AS contractor_last_name_5, t0.contractor_company_name AS contractor_company_name_6, t0.contractor_email AS contractor_email_7, t0.contractor_phone AS contractor_phone_8, t0.person_count AS person_count_9, t0.price AS price_10, t0.date AS date_11, t0.updated_at AS updated_at_12, t0.start_date AS start_date_13, t0.end_date AS end_date_14, t0.payment_process AS payment_process_15, t0.status AS status_16, t0.property_id AS property_id_17, t0.contractor_id AS contractor_id_18 FROM contract t0 WHERE t0.property_id = 3 AND t0.status = 'IN_PROGRESS' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.client_first_name AS client_first_name_1,
  b0_.client_last_name AS client_last_name_2,
  b0_.client_email AS client_email_3,
  b0_.client_phone AS client_phone_4,
  b0_.date AS date_5,
  b0_.entry_date AS entry_date_6,
  b0_.exit_date AS exit_date_7,
  b0_.visit_date AS visit_date_8,
  b0_.person_count AS person_count_9,
  b0_.payment_type AS payment_type_10,
  b0_.status AS status_11,
  b0_.comment AS comment_12,
  b0_.type AS type_13,
  b0_.promo_code AS promo_code_14,
  b0_.property_id AS property_id_15,
  b0_.client_id AS client_id_16
FROM
  booking b0_
WHERE
  b0_.property_id = ?
  AND b0_.type IN (?)
  AND b0_.status IN (?, ?)
  AND b0_.exit_date >= ?
ORDER BY
  b0_.date DESC

SELECT b0_.id AS id_0, b0_.client_first_name AS client_first_name_1, b0_.client_last_name AS client_last_name_2, b0_.client_email AS client_email_3, b0_.client_phone AS client_phone_4, b0_.date AS date_5, b0_.entry_date AS entry_date_6, b0_.exit_date AS exit_date_7, b0_.visit_date AS visit_date_8, b0_.person_count AS person_count_9, b0_.payment_type AS payment_type_10, b0_.status AS status_11, b0_.comment AS comment_12, b0_.type AS type_13, b0_.promo_code AS promo_code_14, b0_.property_id AS property_id_15, b0_.client_id AS client_id_16 FROM booking b0_ WHERE b0_.property_id = 3 AND b0_.type IN ('SHORT_STAY') AND b0_.status IN ('PENDING', 'ACCEPTED') AND b0_.exit_date >= '2026-07-15 20:43:32' ORDER BY b0_.date DESC;

SELECT
  c0_.id AS id_0,
  c0_.entry_date AS entry_date_1,
  c0_.exit_date AS exit_date_2,
  c0_.excluded_date AS excluded_date_3,
  c0_.value AS value_4,
  c0_.is_flat AS is_flat_5,
  c0_.is_modifier AS is_modifier_6,
  c0_.status AS status_7,
  c0_.type AS type_8,
  c0_.description AS description_9,
  c0_.owner_id AS owner_id_10,
  c0_.advert_id AS advert_id_11
FROM
  calendar c0_
WHERE
  c0_.advert_id = ?
  AND c0_.type = ?
  AND c0_.status IN (?)
  AND c0_.exit_date >= ?

SELECT c0_.id AS id_0, c0_.entry_date AS entry_date_1, c0_.exit_date AS exit_date_2, c0_.excluded_date AS excluded_date_3, c0_.value AS value_4, c0_.is_flat AS is_flat_5, c0_.is_modifier AS is_modifier_6, c0_.status AS status_7, c0_.type AS type_8, c0_.description AS description_9, c0_.owner_id AS owner_id_10, c0_.advert_id AS advert_id_11 FROM calendar c0_ WHERE c0_.advert_id = 3 AND c0_.type = 'CALENDAR_DISABLED_DATES' AND c0_.status IN ('ENABLED') AND c0_.exit_date >= '2026-07-15 20:43:32';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.priority AS priority_4,
  t0.advert_id AS advert_id_5
FROM
  photo t0
WHERE
  t0.advert_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.priority AS priority_4, t0.advert_id AS advert_id_5 FROM photo t0 WHERE t0.advert_id = 3;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.comment AS comment_3,
  t0.advert_option_item_id AS advert_option_item_id_4,
  t0.advert_id AS advert_id_5
FROM
  advert_option t0
WHERE
  t0.advert_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.comment AS comment_3, t0.advert_option_item_id AS advert_option_item_id_4, t0.advert_id AS advert_id_5 FROM advert_option t0 WHERE t0.advert_id = 3;