Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.address AS address_3,
  p0_.postal_code AS postal_code_4,
  p0_.city AS city_5,
  p0_.price AS price_6,
  p0_.surface AS surface_7,
  p0_.rooms AS rooms_8,
  p0_.bedrooms AS bedrooms_9,
  p0_.bathrooms AS bathrooms_10,
  p0_.type AS type_11,
  p0_.status AS status_12,
  p0_.is_active AS is_active_13,
  p0_.has_parking AS has_parking_14,
  p0_.has_garden AS has_garden_15,
  p0_.has_balcony AS has_balcony_16,
  p0_.has_elevator AS has_elevator_17,
  p0_.has_air_conditioning AS has_air_conditioning_18,
  p0_.has_heating AS has_heating_19,
  p0_.has_wifi AS has_wifi_20,
  p0_.has_kitchen AS has_kitchen_21,
  p0_.has_tv AS has_tv_22,
  p0_.has_washing_machine AS has_washing_machine_23,
  p0_.has_dishwasher AS has_dishwasher_24,
  p0_.has_pet_friendly AS has_pet_friendly_25,
  p0_.has_smoking_allowed AS has_smoking_allowed_26,
  p0_.max_guests AS max_guests_27,
  p0_.min_stay AS min_stay_28,
  p0_.max_stay AS max_stay_29,
  p0_.amenities AS amenities_30,
  p0_.images AS images_31,
  p0_.house_rules AS house_rules_32,
  p0_.pricing AS pricing_33,
  p0_.created_at AS created_at_34,
  p0_.updated_at AS updated_at_35,
  p0_.latitude AS latitude_36,
  p0_.longitude AS longitude_37,
  p0_.reference AS reference_38,
  p0_.notes AS notes_39,
  p0_.check_in_time AS check_in_time_40,
  p0_.check_out_time AS check_out_time_41,
  p0_.instant_booking AS instant_booking_42,
  p0_.self_check_in AS self_check_in_43,
  p0_.check_in_instructions AS check_in_instructions_44,
  p0_.cleaning_fee AS cleaning_fee_45,
  p0_.service_fee AS service_fee_46,
  p0_.ical_url_airbnb AS ical_url_airbnb_47,
  p0_.ical_url_booking AS ical_url_booking_48,
  p0_.ical_secret AS ical_secret_49,
  p0_.ical_enabled AS ical_enabled_50,
  p0_.last_ical_sync AS last_ical_sync_51,
  p0_.external_bookings AS external_bookings_52,
  p0_.owner_id AS owner_id_53
FROM
  property p0_
WHERE
  p0_.is_active = ?
  AND p0_.status IN (?, ?)
  AND LOWER(p0_.title) NOT LIKE ?
  AND LOWER(p0_.title) NOT LIKE ?
  AND LOWER(p0_.title) NOT LIKE ?
  AND LOWER(p0_.description) NOT LIKE ?
  AND LOWER(p0_.description) NOT LIKE ?
  AND LOWER(p0_.description) NOT LIKE ?
ORDER BY
  p0_.created_at DESC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.address AS address_3, p0_.postal_code AS postal_code_4, p0_.city AS city_5, p0_.price AS price_6, p0_.surface AS surface_7, p0_.rooms AS rooms_8, p0_.bedrooms AS bedrooms_9, p0_.bathrooms AS bathrooms_10, p0_.type AS type_11, p0_.status AS status_12, p0_.is_active AS is_active_13, p0_.has_parking AS has_parking_14, p0_.has_garden AS has_garden_15, p0_.has_balcony AS has_balcony_16, p0_.has_elevator AS has_elevator_17, p0_.has_air_conditioning AS has_air_conditioning_18, p0_.has_heating AS has_heating_19, p0_.has_wifi AS has_wifi_20, p0_.has_kitchen AS has_kitchen_21, p0_.has_tv AS has_tv_22, p0_.has_washing_machine AS has_washing_machine_23, p0_.has_dishwasher AS has_dishwasher_24, p0_.has_pet_friendly AS has_pet_friendly_25, p0_.has_smoking_allowed AS has_smoking_allowed_26, p0_.max_guests AS max_guests_27, p0_.min_stay AS min_stay_28, p0_.max_stay AS max_stay_29, p0_.amenities AS amenities_30, p0_.images AS images_31, p0_.house_rules AS house_rules_32, p0_.pricing AS pricing_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.latitude AS latitude_36, p0_.longitude AS longitude_37, p0_.reference AS reference_38, p0_.notes AS notes_39, p0_.check_in_time AS check_in_time_40, p0_.check_out_time AS check_out_time_41, p0_.instant_booking AS instant_booking_42, p0_.self_check_in AS self_check_in_43, p0_.check_in_instructions AS check_in_instructions_44, p0_.cleaning_fee AS cleaning_fee_45, p0_.service_fee AS service_fee_46, p0_.ical_url_airbnb AS ical_url_airbnb_47, p0_.ical_url_booking AS ical_url_booking_48, p0_.ical_secret AS ical_secret_49, p0_.ical_enabled AS ical_enabled_50, p0_.last_ical_sync AS last_ical_sync_51, p0_.external_bookings AS external_bookings_52, p0_.owner_id AS owner_id_53 FROM property p0_ WHERE p0_.is_active = 1 AND p0_.status IN ('disponible', 'occupé') AND LOWER(p0_.title) NOT LIKE '%test%' AND LOWER(p0_.title) NOT LIKE '%demo%' AND LOWER(p0_.title) NOT LIKE '%sample%' AND LOWER(p0_.description) NOT LIKE '%test%' AND LOWER(p0_.description) NOT LIKE '%demo%' AND LOWER(p0_.description) NOT LIKE '%sample%' ORDER BY p0_.created_at DESC LIMIT 6;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.excerpt AS excerpt_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.tags AS tags_11,
  b0_.reading_time AS reading_time_12,
  b0_.view_count AS view_count_13,
  b0_.is_featured AS is_featured_14,
  b0_.allow_comments AS allow_comments_15,
  b0_.seo_title AS seo_title_16,
  b0_.seo_description AS seo_description_17,
  b0_.seo_keywords AS seo_keywords_18,
  b0_.seo_no_index AS seo_no_index_19,
  b0_.seo_no_follow AS seo_no_follow_20,
  b0_.author_id AS author_id_21,
  b0_.category_id AS category_id_22
FROM
  blog_post b0_
WHERE
  b0_.status = ?
  AND b0_.published_at IS NOT NULL
  AND b0_.published_at <= ?
  AND LOWER(b0_.title) NOT LIKE ?
  AND LOWER(b0_.title) NOT LIKE ?
  AND LOWER(b0_.title) NOT LIKE ?
  AND LOWER(b0_.content) NOT LIKE ?
  AND LOWER(b0_.content) NOT LIKE ?
  AND LOWER(b0_.content) NOT LIKE ?
ORDER BY
  b0_.published_at DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ WHERE b0_.status = 'published' AND b0_.published_at IS NOT NULL AND b0_.published_at <= '2025-12-14 07:00:49' AND LOWER(b0_.title) NOT LIKE '%test%' AND LOWER(b0_.title) NOT LIKE '%demo%' AND LOWER(b0_.title) NOT LIKE '%sample%' AND LOWER(b0_.content) NOT LIKE '%test%' AND LOWER(b0_.content) NOT LIKE '%demo%' AND LOWER(b0_.content) NOT LIKE '%sample%' ORDER BY b0_.published_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.color AS color_5,
  t0.icon AS icon_6,
  t0.image AS image_7,
  t0.is_active AS is_active_8,
  t0.sort_order AS sort_order_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.seo_title AS seo_title_12,
  t0.seo_description AS seo_description_13,
  t0.seo_keywords AS seo_keywords_14
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.image AS image_7, t0.is_active AS is_active_8, t0.sort_order AS sort_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM blog_category t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.color AS color_5,
  t0.icon AS icon_6,
  t0.image AS image_7,
  t0.is_active AS is_active_8,
  t0.sort_order AS sort_order_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.seo_title AS seo_title_12,
  t0.seo_description AS seo_description_13,
  t0.seo_keywords AS seo_keywords_14
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.image AS image_7, t0.is_active AS is_active_8, t0.sort_order AS sort_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM blog_category t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.color AS color_5,
  t0.icon AS icon_6,
  t0.image AS image_7,
  t0.is_active AS is_active_8,
  t0.sort_order AS sort_order_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.seo_title AS seo_title_12,
  t0.seo_description AS seo_description_13,
  t0.seo_keywords AS seo_keywords_14
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.image AS image_7, t0.is_active AS is_active_8, t0.sort_order AS sort_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM blog_category t0 WHERE t0.id = 2;