GET https://preprod-website.kaza-senza.com/page/formations-revit-mep-a-paris-eligibles-cpf-opco

Query Metrics

5 Database Queries
5 Different statements
0.89 ms Query time
1 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.show_on_home_page AS show_on_home_page_5, t0.total_trainings AS total_trainings_6, t0.slug AS slug_7, t0.content AS content_8, t0.content2 AS content2_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_canonical AS seo_canonical_12, t0.seo_indexed AS seo_indexed_13, t0.place_id AS place_id_14 FROM listing_page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "formations-revit-mep-a-paris-eligibles-cpf-opco"
]
2 0.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.pdf_name AS pdf_name_4, t0.pdf_mime_type AS pdf_mime_type_5, t0.updated_at AS updated_at_6, t0.show_on_home_page AS show_on_home_page_7, t0.featured_on_search AS featured_on_search_8, t0.price AS price_9, t0.cpf AS cpf_10, t0.collective_face_to_face_hours AS collective_face_to_face_hours_11, t0.individual_face_to_face_hours AS individual_face_to_face_hours_12, t0.individual_videoconference_hours AS individual_videoconference_hours_13, t0.collective_videoconference_hours AS collective_videoconference_hours_14, t0.elearning_hours AS elearning_hours_15, t0.format AS format_16, t0.description AS description_17, t0.min_period AS min_period_18, t0.max_period AS max_period_19, t0.public AS public_20, t0.prerequisites AS prerequisites_21, t0.code AS code_22, t0.face_to_face_hours_text AS face_to_face_hours_text_23, t0.satisfaction_rate AS satisfaction_rate_24, t0.cpf_link AS cpf_link_25, t0.completion_rate AS completion_rate_26, t0.slug_history AS slug_history_27, t0.sub_title AS sub_title_28, t0.pixels AS pixels_29, t0.status AS status_30, t0.seo_title AS seo_title_31, t0.seo_description AS seo_description_32, t0.seo_canonical AS seo_canonical_33, t0.seo_indexed AS seo_indexed_34, t0.certification_id AS certification_id_35, t0.category_id AS category_id_36, t0.created_by_id AS created_by_id_37 FROM training t0 INNER JOIN listing_page_training ON t0.id = listing_page_training.training_id WHERE listing_page_training.listing_page_id = ?
Parameters:
[
  77
]
3 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 INNER JOIN listing_page_training_category ON t0.id = listing_page_training_category.training_category_id WHERE listing_page_training_category.listing_page_id = ?
Parameters:
[
  77
]
4 0.16 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 WHERE t0.id = ?
Parameters:
[
  5
]
5 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ListingPage 1
App\Entity\Place 1

Entities Mapping

Class Mapping errors
App\Entity\ListingPage No errors.
App\Entity\Place No errors.
App\Entity\Training
  • The association App\Entity\Training#createdBy refers to the inverse side field App\Entity\User#trainings which does not exist.
App\Entity\TrainingCategory No errors.
App\Entity\Certification No errors.
App\Entity\User No errors.
App\Entity\PlacePicture No errors.
App\Entity\Cms\CmsPage No errors.