GET https://www.preprod.hk-groupe.fr/

Query Metrics

9 Database Queries
7 Different statements
16.52 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 4.18 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.url = ? LIMIT 1
Parameters:
[
  "app_home"
]
2 1.71 ms
SELECT t0.id AS id_1, t0.highlight_title AS highlight_title_2, t0.title AS title_3, t0.label_cta AS label_cta_4, t0.cover_image AS cover_image_5, t0.position AS position_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.page_id AS page_id_10 FROM mod_img_full_page t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
3 1.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.cover_image AS cover_image_3, t0.position AS position_4, t0.name AS name_5, t0.label_cta AS label_cta_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.page_id AS page_id_9 FROM mod_offers t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
4 0.42 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.url = ? LIMIT 1
Parameters:
[
  "app_home"
]
5 0.33 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.page_id AS page_id_5 FROM text_editabled t0 WHERE t0.page_id = ? LIMIT 1
Parameters:
[
  1
]
6 0.40 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.is_published = ?
Parameters:
[
  1
]
7 0.36 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.url = ? LIMIT 1
Parameters:
[
  "app_home"
]
8 1.24 ms
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.title AS title_3, t0.description AS description_4, t0.meta AS meta_5, t0.script AS script_6, t0.style AS style_7, t0.icon AS icon_8, t0.facebook AS facebook_9, t0.instagram AS instagram_10, t0.youtube AS youtube_11, t0.twitter AS twitter_12, t0.adresse AS adresse_13, t0.mail AS mail_14, t0.phone AS phone_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM param_site t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 6.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.started_at AS started_at_3, t0.finished_at AS finished_at_4, t0.details AS details_5, t0.rules AS rules_6, t0.cover AS cover_7, t0.short_description AS short_description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM contests t0 ORDER BY t0.started_at DESC LIMIT 5
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Pages 5
App\Entity\Contests 5
App\Entity\ModOffers 3
App\Entity\TextEditabled 2
App\Entity\ModImgFullPage 1
App\Entity\ParamSite 1

Entities Mapping

Class Mapping errors
App\Entity\Pages No errors.
App\Entity\TextEditabled No errors.
App\Entity\ModImgFullPage No errors.
App\Entity\ModOffers No errors.
App\Entity\ParamSite No errors.
App\Entity\Contests No errors.
App\Entity\Sponsors No errors.
App\Entity\ContestParticipation No errors.