Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.published_at AS published_at_3,
  t0.title AS title_4,
  t0.content AS content_5,
  t0.longitude AS longitude_6,
  t0.latitude AS latitude_7,
  t0.rooms AS rooms_8,
  t0.bedrooms AS bedrooms_9,
  t0.water_hot_device AS water_hot_device_10,
  t0.water_hot_access AS water_hot_access_11,
  t0.area AS area_12,
  t0.city_id AS city_id_13,
  t14.id AS id_15,
  t14.name AS name_16,
  t14.description AS description_17,
  t0.parent_id AS parent_id_18,
  t19.id AS id_20,
  t19.price AS price_21,
  t19.published_at AS published_at_22,
  t19.title AS title_23,
  t19.content AS content_24,
  t19.longitude AS longitude_25,
  t19.latitude AS latitude_26,
  t19.rooms AS rooms_27,
  t19.bedrooms AS bedrooms_28,
  t19.water_hot_device AS water_hot_device_29,
  t19.water_hot_access AS water_hot_access_30,
  t19.area AS area_31,
  t19.city_id AS city_id_32,
  t19.parent_id AS parent_id_33,
  t19.apimo_id AS apimo_id_34,
  t35.id AS id_36,
  t35.price AS price_37,
  t35.published_at AS published_at_38,
  t35.title AS title_39,
  t35.content AS content_40,
  t35.longitude AS longitude_41,
  t35.latitude AS latitude_42,
  t35.rooms AS rooms_43,
  t35.bedrooms AS bedrooms_44,
  t35.water_hot_device AS water_hot_device_45,
  t35.water_hot_access AS water_hot_access_46,
  t35.area AS area_47,
  t35.city_id AS city_id_48,
  t35.parent_id AS parent_id_49,
  t35.apimo_id AS apimo_id_50,
  t0.apimo_id AS apimo_id_51,
  t52.id AS id_53,
  t52.apimo_id AS apimo_id_54,
  t52.reference AS reference_55,
  t52.step AS step_56,
  t52.type AS type_57,
  t52.json AS json_58,
  t52.subtype AS subtype_59,
  t52.status AS status_60,
  t52.category AS category_61,
  t52.apimo_parent_id AS apimo_parent_id_62,
  t52.parent_id AS parent_id_63
FROM
  property t0
  INNER JOIN city t14 ON t0.city_id = t14.id
  LEFT JOIN property t19 ON t0.parent_id = t19.id
  LEFT JOIN property t35 ON t35.parent_id = t0.id
  INNER JOIN apimo t52 ON t0.apimo_id = t52.id
WHERE
  t0.apimo_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price AS price_2, t0.published_at AS published_at_3, t0.title AS title_4, t0.content AS content_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7, t0.rooms AS rooms_8, t0.bedrooms AS bedrooms_9, t0.water_hot_device AS water_hot_device_10, t0.water_hot_access AS water_hot_access_11, t0.area AS area_12, t0.city_id AS city_id_13, t14.id AS id_15, t14.name AS name_16, t14.description AS description_17, t0.parent_id AS parent_id_18, t19.id AS id_20, t19.price AS price_21, t19.published_at AS published_at_22, t19.title AS title_23, t19.content AS content_24, t19.longitude AS longitude_25, t19.latitude AS latitude_26, t19.rooms AS rooms_27, t19.bedrooms AS bedrooms_28, t19.water_hot_device AS water_hot_device_29, t19.water_hot_access AS water_hot_access_30, t19.area AS area_31, t19.city_id AS city_id_32, t19.parent_id AS parent_id_33, t19.apimo_id AS apimo_id_34, t35.id AS id_36, t35.price AS price_37, t35.published_at AS published_at_38, t35.title AS title_39, t35.content AS content_40, t35.longitude AS longitude_41, t35.latitude AS latitude_42, t35.rooms AS rooms_43, t35.bedrooms AS bedrooms_44, t35.water_hot_device AS water_hot_device_45, t35.water_hot_access AS water_hot_access_46, t35.area AS area_47, t35.city_id AS city_id_48, t35.parent_id AS parent_id_49, t35.apimo_id AS apimo_id_50, t0.apimo_id AS apimo_id_51, t52.id AS id_53, t52.apimo_id AS apimo_id_54, t52.reference AS reference_55, t52.step AS step_56, t52.type AS type_57, t52.json AS json_58, t52.subtype AS subtype_59, t52.status AS status_60, t52.category AS category_61, t52.apimo_parent_id AS apimo_parent_id_62, t52.parent_id AS parent_id_63 FROM property t0 INNER JOIN city t14 ON t0.city_id = t14.id LEFT JOIN property t19 ON t0.parent_id = t19.id LEFT JOIN property t35 ON t35.parent_id = t0.id INNER JOIN apimo t52 ON t0.apimo_id = t52.id WHERE t0.apimo_id = 77 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.published_at AS published_at_3,
  t0.title AS title_4,
  t0.content AS content_5,
  t0.longitude AS longitude_6,
  t0.latitude AS latitude_7,
  t0.rooms AS rooms_8,
  t0.bedrooms AS bedrooms_9,
  t0.water_hot_device AS water_hot_device_10,
  t0.water_hot_access AS water_hot_access_11,
  t0.area AS area_12,
  t0.city_id AS city_id_13,
  t14.id AS id_15,
  t14.name AS name_16,
  t14.description AS description_17,
  t0.parent_id AS parent_id_18,
  t19.id AS id_20,
  t19.price AS price_21,
  t19.published_at AS published_at_22,
  t19.title AS title_23,
  t19.content AS content_24,
  t19.longitude AS longitude_25,
  t19.latitude AS latitude_26,
  t19.rooms AS rooms_27,
  t19.bedrooms AS bedrooms_28,
  t19.water_hot_device AS water_hot_device_29,
  t19.water_hot_access AS water_hot_access_30,
  t19.area AS area_31,
  t19.city_id AS city_id_32,
  t19.parent_id AS parent_id_33,
  t19.apimo_id AS apimo_id_34,
  t35.id AS id_36,
  t35.price AS price_37,
  t35.published_at AS published_at_38,
  t35.title AS title_39,
  t35.content AS content_40,
  t35.longitude AS longitude_41,
  t35.latitude AS latitude_42,
  t35.rooms AS rooms_43,
  t35.bedrooms AS bedrooms_44,
  t35.water_hot_device AS water_hot_device_45,
  t35.water_hot_access AS water_hot_access_46,
  t35.area AS area_47,
  t35.city_id AS city_id_48,
  t35.parent_id AS parent_id_49,
  t35.apimo_id AS apimo_id_50,
  t0.apimo_id AS apimo_id_51,
  t52.id AS id_53,
  t52.apimo_id AS apimo_id_54,
  t52.reference AS reference_55,
  t52.step AS step_56,
  t52.type AS type_57,
  t52.json AS json_58,
  t52.subtype AS subtype_59,
  t52.status AS status_60,
  t52.category AS category_61,
  t52.apimo_parent_id AS apimo_parent_id_62,
  t52.parent_id AS parent_id_63,
  t64.id AS id_65,
  t64.url AS url_66,
  t64.property_id AS property_id_67
FROM
  property t0
  INNER JOIN city t14 ON t0.city_id = t14.id
  LEFT JOIN property t19 ON t0.parent_id = t19.id
  LEFT JOIN property t35 ON t35.parent_id = t0.id
  INNER JOIN apimo t52 ON t0.apimo_id = t52.id
  LEFT JOIN image t64 ON t64.property_id = t0.id
  INNER JOIN property_type ON t0.id = property_type.property_id
WHERE
  property_type.type_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.published_at AS published_at_3, t0.title AS title_4, t0.content AS content_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7, t0.rooms AS rooms_8, t0.bedrooms AS bedrooms_9, t0.water_hot_device AS water_hot_device_10, t0.water_hot_access AS water_hot_access_11, t0.area AS area_12, t0.city_id AS city_id_13, t14.id AS id_15, t14.name AS name_16, t14.description AS description_17, t0.parent_id AS parent_id_18, t19.id AS id_20, t19.price AS price_21, t19.published_at AS published_at_22, t19.title AS title_23, t19.content AS content_24, t19.longitude AS longitude_25, t19.latitude AS latitude_26, t19.rooms AS rooms_27, t19.bedrooms AS bedrooms_28, t19.water_hot_device AS water_hot_device_29, t19.water_hot_access AS water_hot_access_30, t19.area AS area_31, t19.city_id AS city_id_32, t19.parent_id AS parent_id_33, t19.apimo_id AS apimo_id_34, t35.id AS id_36, t35.price AS price_37, t35.published_at AS published_at_38, t35.title AS title_39, t35.content AS content_40, t35.longitude AS longitude_41, t35.latitude AS latitude_42, t35.rooms AS rooms_43, t35.bedrooms AS bedrooms_44, t35.water_hot_device AS water_hot_device_45, t35.water_hot_access AS water_hot_access_46, t35.area AS area_47, t35.city_id AS city_id_48, t35.parent_id AS parent_id_49, t35.apimo_id AS apimo_id_50, t0.apimo_id AS apimo_id_51, t52.id AS id_53, t52.apimo_id AS apimo_id_54, t52.reference AS reference_55, t52.step AS step_56, t52.type AS type_57, t52.json AS json_58, t52.subtype AS subtype_59, t52.status AS status_60, t52.category AS category_61, t52.apimo_parent_id AS apimo_parent_id_62, t52.parent_id AS parent_id_63, t64.id AS id_65, t64.url AS url_66, t64.property_id AS property_id_67 FROM property t0 INNER JOIN city t14 ON t0.city_id = t14.id LEFT JOIN property t19 ON t0.parent_id = t19.id LEFT JOIN property t35 ON t35.parent_id = t0.id INNER JOIN apimo t52 ON t0.apimo_id = t52.id LEFT JOIN image t64 ON t64.property_id = t0.id INNER JOIN property_type ON t0.id = property_type.property_id WHERE property_type.type_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  TYPE t0
  INNER JOIN property_type ON t0.id = property_type.type_id
WHERE
  property_type.property_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM TYPE t0 INNER JOIN property_type ON t0.id = property_type.type_id WHERE property_type.property_id = 103;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  category t0
  INNER JOIN property_category ON t0.id = property_category.category_id
WHERE
  property_category.property_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0 INNER JOIN property_category ON t0.id = property_category.category_id WHERE property_category.property_id = 1;

SELECT
  t0.id AS id_1,
  t0.apimo_id AS apimo_id_2,
  t0.reference AS reference_3,
  t0.step AS step_4,
  t0.type AS type_5,
  t0.json AS json_6,
  t0.subtype AS subtype_7,
  t0.status AS status_8,
  t0.category AS category_9,
  t0.apimo_parent_id AS apimo_parent_id_10,
  t0.parent_id AS parent_id_11,
  t12.id AS id_13,
  t12.price AS price_14,
  t12.published_at AS published_at_15,
  t12.title AS title_16,
  t12.content AS content_17,
  t12.longitude AS longitude_18,
  t12.latitude AS latitude_19,
  t12.rooms AS rooms_20,
  t12.bedrooms AS bedrooms_21,
  t12.water_hot_device AS water_hot_device_22,
  t12.water_hot_access AS water_hot_access_23,
  t12.area AS area_24,
  t12.city_id AS city_id_25,
  t12.parent_id AS parent_id_26,
  t12.apimo_id AS apimo_id_27
FROM
  apimo t0
  LEFT JOIN property t12 ON t12.apimo_id = t0.id

SELECT t0.id AS id_1, t0.apimo_id AS apimo_id_2, t0.reference AS reference_3, t0.step AS step_4, t0.type AS type_5, t0.json AS json_6, t0.subtype AS subtype_7, t0.status AS status_8, t0.category AS category_9, t0.apimo_parent_id AS apimo_parent_id_10, t0.parent_id AS parent_id_11, t12.id AS id_13, t12.price AS price_14, t12.published_at AS published_at_15, t12.title AS title_16, t12.content AS content_17, t12.longitude AS longitude_18, t12.latitude AS latitude_19, t12.rooms AS rooms_20, t12.bedrooms AS bedrooms_21, t12.water_hot_device AS water_hot_device_22, t12.water_hot_access AS water_hot_access_23, t12.area AS area_24, t12.city_id AS city_id_25, t12.parent_id AS parent_id_26, t12.apimo_id AS apimo_id_27 FROM apimo t0 LEFT JOIN property t12 ON t12.apimo_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.published_at AS published_at_3,
  t0.title AS title_4,
  t0.content AS content_5,
  t0.longitude AS longitude_6,
  t0.latitude AS latitude_7,
  t0.rooms AS rooms_8,
  t0.bedrooms AS bedrooms_9,
  t0.water_hot_device AS water_hot_device_10,
  t0.water_hot_access AS water_hot_access_11,
  t0.area AS area_12,
  t0.city_id AS city_id_13,
  t14.id AS id_15,
  t14.name AS name_16,
  t14.description AS description_17,
  t0.parent_id AS parent_id_18,
  t19.id AS id_20,
  t19.price AS price_21,
  t19.published_at AS published_at_22,
  t19.title AS title_23,
  t19.content AS content_24,
  t19.longitude AS longitude_25,
  t19.latitude AS latitude_26,
  t19.rooms AS rooms_27,
  t19.bedrooms AS bedrooms_28,
  t19.water_hot_device AS water_hot_device_29,
  t19.water_hot_access AS water_hot_access_30,
  t19.area AS area_31,
  t19.city_id AS city_id_32,
  t19.parent_id AS parent_id_33,
  t19.apimo_id AS apimo_id_34,
  t35.id AS id_36,
  t35.price AS price_37,
  t35.published_at AS published_at_38,
  t35.title AS title_39,
  t35.content AS content_40,
  t35.longitude AS longitude_41,
  t35.latitude AS latitude_42,
  t35.rooms AS rooms_43,
  t35.bedrooms AS bedrooms_44,
  t35.water_hot_device AS water_hot_device_45,
  t35.water_hot_access AS water_hot_access_46,
  t35.area AS area_47,
  t35.city_id AS city_id_48,
  t35.parent_id AS parent_id_49,
  t35.apimo_id AS apimo_id_50,
  t0.apimo_id AS apimo_id_51,
  t52.id AS id_53,
  t52.apimo_id AS apimo_id_54,
  t52.reference AS reference_55,
  t52.step AS step_56,
  t52.type AS type_57,
  t52.json AS json_58,
  t52.subtype AS subtype_59,
  t52.status AS status_60,
  t52.category AS category_61,
  t52.apimo_parent_id AS apimo_parent_id_62,
  t52.parent_id AS parent_id_63,
  t64.id AS id_65,
  t64.url AS url_66,
  t64.property_id AS property_id_67
FROM
  property t0
  INNER JOIN city t14 ON t0.city_id = t14.id
  LEFT JOIN property t19 ON t0.parent_id = t19.id
  LEFT JOIN property t35 ON t35.parent_id = t0.id
  INNER JOIN apimo t52 ON t0.apimo_id = t52.id
  LEFT JOIN image t64 ON t64.property_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.published_at AS published_at_3, t0.title AS title_4, t0.content AS content_5, t0.longitude AS longitude_6, t0.latitude AS latitude_7, t0.rooms AS rooms_8, t0.bedrooms AS bedrooms_9, t0.water_hot_device AS water_hot_device_10, t0.water_hot_access AS water_hot_access_11, t0.area AS area_12, t0.city_id AS city_id_13, t14.id AS id_15, t14.name AS name_16, t14.description AS description_17, t0.parent_id AS parent_id_18, t19.id AS id_20, t19.price AS price_21, t19.published_at AS published_at_22, t19.title AS title_23, t19.content AS content_24, t19.longitude AS longitude_25, t19.latitude AS latitude_26, t19.rooms AS rooms_27, t19.bedrooms AS bedrooms_28, t19.water_hot_device AS water_hot_device_29, t19.water_hot_access AS water_hot_access_30, t19.area AS area_31, t19.city_id AS city_id_32, t19.parent_id AS parent_id_33, t19.apimo_id AS apimo_id_34, t35.id AS id_36, t35.price AS price_37, t35.published_at AS published_at_38, t35.title AS title_39, t35.content AS content_40, t35.longitude AS longitude_41, t35.latitude AS latitude_42, t35.rooms AS rooms_43, t35.bedrooms AS bedrooms_44, t35.water_hot_device AS water_hot_device_45, t35.water_hot_access AS water_hot_access_46, t35.area AS area_47, t35.city_id AS city_id_48, t35.parent_id AS parent_id_49, t35.apimo_id AS apimo_id_50, t0.apimo_id AS apimo_id_51, t52.id AS id_53, t52.apimo_id AS apimo_id_54, t52.reference AS reference_55, t52.step AS step_56, t52.type AS type_57, t52.json AS json_58, t52.subtype AS subtype_59, t52.status AS status_60, t52.category AS category_61, t52.apimo_parent_id AS apimo_parent_id_62, t52.parent_id AS parent_id_63, t64.id AS id_65, t64.url AS url_66, t64.property_id AS property_id_67 FROM property t0 INNER JOIN city t14 ON t0.city_id = t14.id LEFT JOIN property t19 ON t0.parent_id = t19.id LEFT JOIN property t35 ON t35.parent_id = t0.id INNER JOIN apimo t52 ON t0.apimo_id = t52.id LEFT JOIN image t64 ON t64.property_id = t0.id WHERE t0.parent_id = 75;

SELECT
  t0_.name AS name_0,
  t0_.content AS content_1,
  t0_.id AS id_2,
  t0_.created_at AS created_at_3,
  t0_.updated_at AS updated_at_4,
  t0_.section_id AS section_id_5,
  t0_.page_id AS page_id_6
FROM
  text_tracol t0_
  INNER JOIN page_tracol p1_ ON t0_.page_id = p1_.id
  INNER JOIN section_tracol s2_ ON t0_.section_id = s2_.id
WHERE
  p1_.name = ?
  AND s2_.name = ?

SELECT t0_.name AS name_0, t0_.content AS content_1, t0_.id AS id_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.section_id AS section_id_5, t0_.page_id AS page_id_6 FROM text_tracol t0_ INNER JOIN page_tracol p1_ ON t0_.page_id = p1_.id INNER JOIN section_tracol s2_ ON t0_.section_id = s2_.id WHERE p1_.name = 'Bien-detail' AND s2_.name = 'Section-1';

SELECT
  t0.id AS id_1,
  t0.apimo_id AS apimo_id_2,
  t0.reference AS reference_3,
  t0.step AS step_4,
  t0.type AS type_5,
  t0.json AS json_6,
  t0.subtype AS subtype_7,
  t0.status AS status_8,
  t0.category AS category_9,
  t0.apimo_parent_id AS apimo_parent_id_10,
  t0.parent_id AS parent_id_11,
  t12.id AS id_13,
  t12.price AS price_14,
  t12.published_at AS published_at_15,
  t12.title AS title_16,
  t12.content AS content_17,
  t12.longitude AS longitude_18,
  t12.latitude AS latitude_19,
  t12.rooms AS rooms_20,
  t12.bedrooms AS bedrooms_21,
  t12.water_hot_device AS water_hot_device_22,
  t12.water_hot_access AS water_hot_access_23,
  t12.area AS area_24,
  t12.city_id AS city_id_25,
  t12.parent_id AS parent_id_26,
  t12.apimo_id AS apimo_id_27
FROM
  apimo t0
  LEFT JOIN property t12 ON t12.apimo_id = t0.id
WHERE
  t0.apimo_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.apimo_id AS apimo_id_2, t0.reference AS reference_3, t0.step AS step_4, t0.type AS type_5, t0.json AS json_6, t0.subtype AS subtype_7, t0.status AS status_8, t0.category AS category_9, t0.apimo_parent_id AS apimo_parent_id_10, t0.parent_id AS parent_id_11, t12.id AS id_13, t12.price AS price_14, t12.published_at AS published_at_15, t12.title AS title_16, t12.content AS content_17, t12.longitude AS longitude_18, t12.latitude AS latitude_19, t12.rooms AS rooms_20, t12.bedrooms AS bedrooms_21, t12.water_hot_device AS water_hot_device_22, t12.water_hot_access AS water_hot_access_23, t12.area AS area_24, t12.city_id AS city_id_25, t12.parent_id AS parent_id_26, t12.apimo_id AS apimo_id_27 FROM apimo t0 LEFT JOIN property t12 ON t12.apimo_id = t0.id WHERE t0.apimo_id = '84031881' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.property_id AS property_id_3
FROM
  image t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.property_id AS property_id_3 FROM image t0 WHERE t0.property_id = 95;

SELECT
  t0.id AS id_1,
  t0.apimo_id AS apimo_id_2,
  t0.reference AS reference_3,
  t0.step AS step_4,
  t0.type AS type_5,
  t0.json AS json_6,
  t0.subtype AS subtype_7,
  t0.status AS status_8,
  t0.category AS category_9,
  t0.apimo_parent_id AS apimo_parent_id_10,
  t0.parent_id AS parent_id_11,
  t12.id AS id_13,
  t12.price AS price_14,
  t12.published_at AS published_at_15,
  t12.title AS title_16,
  t12.content AS content_17,
  t12.longitude AS longitude_18,
  t12.latitude AS latitude_19,
  t12.rooms AS rooms_20,
  t12.bedrooms AS bedrooms_21,
  t12.water_hot_device AS water_hot_device_22,
  t12.water_hot_access AS water_hot_access_23,
  t12.area AS area_24,
  t12.city_id AS city_id_25,
  t12.parent_id AS parent_id_26,
  t12.apimo_id AS apimo_id_27
FROM
  apimo t0
  LEFT JOIN property t12 ON t12.apimo_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.apimo_id AS apimo_id_2, t0.reference AS reference_3, t0.step AS step_4, t0.type AS type_5, t0.json AS json_6, t0.subtype AS subtype_7, t0.status AS status_8, t0.category AS category_9, t0.apimo_parent_id AS apimo_parent_id_10, t0.parent_id AS parent_id_11, t12.id AS id_13, t12.price AS price_14, t12.published_at AS published_at_15, t12.title AS title_16, t12.content AS content_17, t12.longitude AS longitude_18, t12.latitude AS latitude_19, t12.rooms AS rooms_20, t12.bedrooms AS bedrooms_21, t12.water_hot_device AS water_hot_device_22, t12.water_hot_access AS water_hot_access_23, t12.area AS area_24, t12.city_id AS city_id_25, t12.parent_id AS parent_id_26, t12.apimo_id AS apimo_id_27 FROM apimo t0 LEFT JOIN property t12 ON t12.apimo_id = t0.id WHERE t0.id IN (92);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  city t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id IN (6);