Query Metrics
8Database Queries
7Different statements
15.73 msQuery time
0Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.85 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.url AS url_6, t0.visibility AS visibility_7, t0.type AS type_8 FROM seo_redirection t0 WHERE t0.slug = ? AND t0.visibility = ? LIMIT 1 Parameters: [ "candidates" 1 ] |
2 | 0.50 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.folder_slug AS folder_slug_5, t0.folder_slug2 AS folder_slug2_6, t0.folder_slug3 AS folder_slug3_7, t0.title AS title_8, t0.short_title AS short_title_9, t0.description AS description_10, t0.short_description AS short_description_11, t0.views AS views_12, t0.locale AS locale_13, t0.noblock AS noblock_14, t0.robots AS robots_15, t0.type AS type_16, t0.sitemap AS sitemap_17, t0.menu_absolute AS menu_absolute_18, t0.theme AS theme_19, t0.style AS style_20, t0.javascript AS javascript_21, t0.redirect AS redirect_22, t0.identifiant AS identifiant_23, t0.sequence AS sequence_24, t0.canonical AS canonical_25, t0.author AS author_26, t0.premium AS premium_27, t0.navbar AS navbar_28, t0.navbar_background_color AS navbar_background_color_29, t0.image_name AS image_name_30, t0.image_original_name AS image_original_name_31, t0.image_mime_type AS image_mime_type_32, t0.image_size AS image_size_33, t0.image_dimensions AS image_dimensions_34, t0.fiche_id AS fiche_id_35 FROM pages_pages t0 WHERE t0.name = ? LIMIT 1 Parameters: [
"candidates"
] |
3 | 0.39 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.icon AS icon_7, t0.short_title AS short_title_8, t0.short_description AS short_description_9, t0.big_category_id AS big_category_id_10 FROM cvs_categories t0 Parameters: [] |
4 | 0.55 ms | SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.lastname AS lastname_4, c0_.phone AS phone_5, c0_.email AS email_6, c0_.address AS address_7, c0_.city AS city_8, c0_.zipcode AS zipcode_9, c0_.country AS country_10, c0_.slug AS slug_11, c0_.slug_anonyme AS slug_anonyme_12, c0_.title_job AS title_job_13, c0_.description_cover AS description_cover_14, c0_.description_cover_anonyme AS description_cover_anonyme_15, c0_.description_services AS description_services_16, c0_.description_services_anonyme AS description_services_anonyme_17, c0_.description_cta AS description_cta_18, c0_.description_cta_anonyme AS description_cta_anonyme_19, c0_.description AS description_20, c0_.description_anonyme AS description_anonyme_21, c0_.description_experience AS description_experience_22, c0_.description_experience_anonyme AS description_experience_anonyme_23, c0_.website_url AS website_url_24, c0_.linkedin_url AS linkedin_url_25, c0_.salary AS salary_26, c0_.freelance AS freelance_27, c0_.alternance AS alternance_28, c0_.stage AS stage_29, c0_.on_search AS on_search_30, c0_.on_discussion AS on_discussion_31, c0_.notifications AS notifications_32, c0_.online AS online_33, c0_.online_classic AS online_classic_34, c0_.invitation_code AS invitation_code_35, c0_.invitation_code_anonyme AS invitation_code_anonyme_36, c0_.views AS views_37, c0_.exp_years AS exp_years_38, c0_.views_anonyme AS views_anonyme_39, c0_.first AS first_40, c0_.point_x AS point_x_41, c0_.point_y AS point_y_42, -1 AS sclr_43, c0_.category_id AS category_id_44 FROM cvs_candidates c0_ ORDER BY c0_.updated_at DESC Parameters: [] |
5 | 0.28 ms | SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.title_page AS title_page_3, c0_.name AS name_4, c0_.description AS description_5, c0_.sequence AS sequence_6, c0_.type AS type_7, c0_.category AS category_8, c0_.type_website AS type_website_9, c0_.tool_id AS tool_id_10 FROM core_tools c0_ WHERE c0_.type_website LIKE ? ORDER BY c0_.id ASC Parameters: [
"%blog%"
] |
6 | 0.18 ms | SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.title_page AS title_page_3, c0_.name AS name_4, c0_.description AS description_5, c0_.sequence AS sequence_6, c0_.type AS type_7, c0_.category AS category_8, c0_.type_website AS type_website_9, c0_.tool_id AS tool_id_10 FROM core_tools c0_ WHERE c0_.type_website LIKE ? ORDER BY c0_.id ASC Parameters: [
"%socialmedia%"
] |
7 | 0.19 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.description AS description_6, t0.short_title AS short_title_7, t0.short_description AS short_description_8, t0.project AS project_9 FROM cvs_big_categories t0 ORDER BY t0.title ASC Parameters: [] |
8 | 12.79 ms | SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.title AS title_3, c0_.description AS description_4, c0_.fav AS fav_5, c0_.candidate_id AS candidate_id_6 FROM cvs_candidates_has_skills c0_ WHERE c0_.candidate_id = ? ORDER BY c0_.title ASC LIMIT 4 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\Seo\Redirection | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |
App\Entity\Pages\Pages | No errors. |
App\Entity\Fiches\Articles | No errors. |
App\Entity\Cvs\Categories | No errors. |
App\Entity\Cvs\BigCategories | No errors. |
App\Entity\Cvs\Candidates | No errors. |
App\Entity\Core\Tools | No errors. |
App\Entity\Cvs\CandidatesHasSkills | No errors. |