Query Metrics
8
Database Queries
8
Different statements
2.86 ms
Query time
5
Invalid entities
11
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.08 ms |
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:
[
"le-guide-pratique-pour-utiliser-excel-365-sur-pc-tablette-et-mobile"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.18 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.sub_title AS sub_title_18, t0.show_on_home_page AS show_on_home_page_19, t0.format AS format_20, t0.collective_face_to_face_hours AS collective_face_to_face_hours_21, t0.individual_face_to_face_hours AS individual_face_to_face_hours_22, t0.individual_videoconference_hours AS individual_videoconference_hours_23, t0.collective_videoconference_hours AS collective_videoconference_hours_24, t0.elearning_hours AS elearning_hours_25, t0.face_to_face_hours_text AS face_to_face_hours_text_26, t0.min_period AS min_period_27, t0.max_period AS max_period_28, t0.public AS public_29, t0.prerequisites AS prerequisites_30, t0.cpf AS cpf_31, t0.cpf_link AS cpf_link_32, t0.pdf_name AS pdf_name_33, t0.pdf_mime_type AS pdf_mime_type_34, t0.created_by_id AS created_by_id_35, t0.category_id AS category_id_36, t0.certification_id AS certification_id_37, t0.type FROM training t0 INNER JOIN article_training_professional ON t0.id = article_training_professional.training_professional_id WHERE article_training_professional.article_id = ? AND t0.type IN ('professional')
Parameters:
[
200
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.13 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 article_training_category ON t0.id = article_training_category.training_category_id WHERE article_training_category.article_id = ?
Parameters:
[
200
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.43 ms |
SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.sub_title AS sub_title_17, t0_.show_on_home_page AS show_on_home_page_18, t0_.format AS format_19, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_20, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_21, t0_.individual_videoconference_hours AS individual_videoconference_hours_22, t0_.collective_videoconference_hours AS collective_videoconference_hours_23, t0_.elearning_hours AS elearning_hours_24, t0_.face_to_face_hours_text AS face_to_face_hours_text_25, t0_.min_period AS min_period_26, t0_.max_period AS max_period_27, t0_.public AS public_28, t0_.prerequisites AS prerequisites_29, t0_.cpf AS cpf_30, t0_.cpf_link AS cpf_link_31, t0_.pdf_name AS pdf_name_32, t0_.pdf_mime_type AS pdf_mime_type_33, t0_.type AS type_34, t0_.created_by_id AS created_by_id_35, t0_.category_id AS category_id_36, t0_.certification_id AS certification_id_37 FROM training t0_ WHERE (t0_.category_id IN (?)) AND t0_.type IN ('professional') ORDER BY RANDOM() ASC LIMIT 4
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.50 ms |
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:
[ 40 200 "ONLINE" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.17 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.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:
[
40
]
|
||||||||||||||||||||||||||||||||
| 7 | 0.19 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
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.17 ms |
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:
[
29
]
|
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\ArticleCategory | 1 |
| App\Entity\TrainingCategory | 1 |
| App\Entity\Certification | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Article | No errors. |
| App\Entity\ArticleCategory | No errors. |
| App\Entity\Training |
|
| App\Entity\TrainingProfessional |
|
| App\Entity\TrainingCategory | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Certification | No errors. |
| App\Entity\TrainingObjective | No errors. |
| App\Entity\FAQ | No errors. |
| App\Entity\Trainer\Trainer | No errors. |
| App\Entity\TrainingProgramPart |
|
| App\Entity\Financing | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\Session |
|
| App\Entity\TrainingCityChild |
|
| App\Entity\Cms\CmsPage | No errors. |