Query Metrics
853
Database Queries
11
Different statements
1080.64 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
695.61 ms (64.37%) |
525 |
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
Parameters:
[
18
]
|
105.39 ms (9.75%) |
131 |
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 = ?
Parameters:
[
18
]
|
86.85 ms (8.04%) |
131 |
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 = ?
Parameters:
[
6
]
|
84.46 ms (7.82%) |
20 |
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 = ?
Parameters:
[
8
]
|
41.54 ms (3.84%) |
4 |
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
Parameters:
[] |
23.54 ms (2.18%) |
10 |
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 = ?
Parameters:
[
18
]
|
15.07 ms (1.39%) |
7 |
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 = ?
Parameters:
[ "Bien-detail" "Section-1" ] |
11.23 ms (1.04%) |
15 |
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 = ?
Parameters:
[
93
]
|
7.56 ms (0.70%) |
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
Parameters:
[
"5890643"
]
|
7.56 ms (0.70%) |
6 |
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 (?)
Parameters:
[
[
79
]
]
|
1.84 ms (0.17%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id IN (?)
Parameters:
[
[
2
]
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Domain\Entity\Apimo |
|
App\Domain\Entity\Property |
|
App\Domain\Entity\Text | No errors. |
App\Domain\Entity\Post | No errors. |
App\Domain\Entity\User | No errors. |
App\Domain\Entity\City | No errors. |
App\Domain\Entity\Image | No errors. |
App\Domain\Entity\Type | No errors. |
App\Domain\Entity\Category | No errors. |
App\Domain\Entity\Page | No errors. |
App\Domain\Entity\Section | No errors. |
App\Domain\Entity\Picture | No errors. |
App\Domain\Entity\Movie | No errors. |