Query Metrics

9 Database Queries
8 Different statements
11.51 ms Query time
1 Invalid entities
12 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.77 ms
(76.26%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.image_name AS image_name_3, a0_.author AS author_4, a0_.summary AS summary_5, a0_.content AS content_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.state AS state_9, a0_.seo_title AS seo_title_10, a0_.seo_description AS seo_description_11, a0_.seo_canonical AS seo_canonical_12, a0_.seo_indexed AS seo_indexed_13, a0_.category_id AS category_id_14 FROM article a0_ INNER JOIN article_category a1_ ON a0_.category_id = a1_.id AND (a1_.id = ?) WHERE a0_.id <> ? AND a0_.state = ? ORDER BY RANDOM() ASC LIMIT 3
Parameters:
[
  31
  245
  "ONLINE"
]
1.16 ms
(10.09%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.author AS author_5, t0.summary AS summary_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.state AS state_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_canonical AS seo_canonical_13, t0.seo_indexed AS seo_indexed_14, t0.category_id AS category_id_15 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "comment-corriger-les-couleurs-et-appliquer-des-filtres-dans-capcut"
]
0.50 ms
(4.35%)
1
SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33, t0_.certification_id AS certification_id_34, t0_.category_id AS category_id_35, t0_.created_by_id AS created_by_id_36 FROM training t0_ WHERE t0_.category_id IN (?) ORDER BY RANDOM() ASC LIMIT 4
Parameters:
[
  16
]
0.31 ms
(2.67%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = ?
Parameters:
[
  22
]
0.29 ms
(2.49%)
1
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 article_training ON t0.id = article_training.training_id WHERE article_training.article_id = ?
Parameters:
[
  245
]
0.20 ms
(1.71%)
1
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.ebook_title AS ebook_title_5, t0.ebook_sub_title AS ebook_sub_title_6, t0.pdf_name AS pdf_name_7, t0.pdf_mime_type AS pdf_mime_type_8 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
  31
]
0.18 ms
(1.55%)
1
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
]
0.10 ms
(0.88%)
1
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 article_training_category ON t0.id = article_training_category.training_category_id WHERE article_training_category.article_id = ?
Parameters:
[
  245
]

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\Article 4
App\Entity\Training 4
App\Entity\Certification 2
App\Entity\ArticleCategory 1
App\Entity\TrainingCategory 1

Entities Mapping

Class Mapping errors
App\Entity\Article No errors.
App\Entity\ArticleCategory 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\TrainingObjective No errors.
App\Entity\Financing No errors.
App\Entity\TrainingProgramPart No errors.
App\Entity\Place No errors.
App\Entity\Session No errors.
App\Entity\TrainingCityChild No errors.
App\Entity\FAQ No errors.
App\Entity\Trainer\Trainer No errors.
App\Entity\Cms\CmsPage No errors.