Query Metrics
66
Database Queries
10
Different statements
221.73 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
149.92 ms (67.61%) |
1 |
SELECT a0_.id AS id_0, a0_.public AS public_1, a0_.publication_date AS publication_date_2, a0_.creation_date AS creation_date_3, a0_.require_user AS require_user_4, a0_.is_model AS is_model_5, a0_.template AS template_6, a0_.sort AS sort_7, a0_.is_template AS is_template_8, u2_.type AS type_9, c3_.is_recommandation AS is_recommandation_10, p9_.id AS id_11, p9_.version_date AS version_date_12, p9_.title AS title_13, p9_.description AS description_14, p9_.image AS image_15, p9_.link AS link_16, e10_.id AS id_17, e10_.template AS template_18, e10_.sort AS sort_19, e11_.id AS id_20, e11_.name AS name_21, e11_.template AS template_22, e11_.description AS description_23, e11_.editor_display AS editor_display_24, e11_.overridable AS overridable_25, a0_.discr AS discr_26, a0_.parent_id AS parent_id_27, a0_.model_id AS model_id_28, u2_.user_id AS user_id_29, c3_.user_id AS user_id_30, p9_.page_id AS page_id_31, e10_.type_id AS type_id_32, e10_.page_version_id AS page_version_id_33 FROM abstract_page a0_ LEFT JOIN static_page s1_ ON a0_.id = s1_.id LEFT JOIN user_page u2_ ON a0_.id = u2_.id LEFT JOIN contract c3_ ON a0_.id = c3_.id LEFT JOIN contract_page c4_ ON a0_.id = c4_.id LEFT JOIN service s5_ ON a0_.id = s5_.id LEFT JOIN service_category s6_ ON a0_.id = s6_.id LEFT JOIN about_item a7_ ON a0_.id = a7_.id LEFT JOIN about_category a8_ ON a0_.id = a8_.id INNER JOIN page_version p9_ ON a0_.id = p9_.page_id LEFT JOIN element e10_ ON p9_.id = e10_.page_version_id LEFT JOIN element_type e11_ ON e10_.type_id = e11_.id INNER JOIN page_version p12_ ON a0_.id = p12_.page_id WHERE ? LIKE CONCAT(?, p12_.link) ORDER BY p9_.version_date DESC
Parameters:
[ "/" "%" ] |
16.76 ms (7.56%) |
17 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = ?
Parameters:
[
1189
]
|
14.29 ms (6.44%) |
15 |
SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = ? ORDER BY t0.version_date DESC
Parameters:
[
11
]
|
11.56 ms (5.21%) |
15 |
SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = ?
Parameters:
[
2335
]
|
8.60 ms (3.88%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"home_page_dashboard"
]
|
7.92 ms (3.57%) |
3 |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ? AND t0.public = ? LIMIT 1
Parameters:
[ "11" 1 ] |
7.51 ms (3.39%) |
4 |
SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = ?
Parameters:
[
10
]
|
2.11 ms (0.95%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sort AS sort_4, t0.public AS public_5, t0.update_date AS update_date_6 FROM form t0 WHERE t0.public = ?
Parameters:
[
1
]
|
1.68 ms (0.76%) |
1 |
SELECT t1.id AS id_2, t1.public AS public_3, t1.publication_date AS publication_date_4, t1.creation_date AS creation_date_5, t1.require_user AS require_user_6, t1.is_model AS is_model_7, t1.template AS template_8, t1.sort AS sort_9, t1.is_template AS is_template_10, t1.parent_id AS parent_id_11, t1.model_id AS model_id_12, t1.discr FROM service_category t0 INNER JOIN abstract_page t1 ON t0.id = t1.id WHERE t1.public = ?
Parameters:
[
1
]
|
1.38 ms (0.62%) |
1 |
SELECT t1.id AS id_2, t1.public AS public_3, t1.publication_date AS publication_date_4, t1.creation_date AS creation_date_5, t1.require_user AS require_user_6, t1.is_model AS is_model_7, t1.template AS template_8, t1.sort AS sort_9, t1.is_template AS is_template_10, t1.parent_id AS parent_id_11, t1.model_id AS model_id_12, t1.discr FROM about_category t0 INNER JOIN abstract_page t1 ON t0.id = t1.id WHERE t1.public = ? ORDER BY t1.sort ASC
Parameters:
[
1
]
|
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\Entity\AbstractPage | No errors. |
App\Entity\PageVersion | No errors. |
App\Entity\Element | No errors. |
App\Entity\ElementType | No errors. |
App\Entity\StaticPage | No errors. |
App\Entity\UserPage | No errors. |
App\Entity\Contract | No errors. |
App\Entity\ContractPage | No errors. |
App\Entity\Service | No errors. |
App\Entity\ServiceCategory | No errors. |
App\Entity\AboutItem | No errors. |
App\Entity\AboutCategory | No errors. |
App\Entity\User | No errors. |
App\Entity\PageVersionAttribute | No errors. |
App\Entity\Form | No errors. |
App\Entity\FormStep | No errors. |
App\Entity\Config | No errors. |