Query Metrics
6
Database Queries
5
Different statements
3.92 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.90 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.salaire_brut_annuel AS salaire_brut_annuel_3, t0.salaire_net_annuel AS salaire_net_annuel_4, t0.salaire_brut_heure AS salaire_brut_heure_5, t0.salaire_net_heure AS salaire_net_heure_6, t0.salaire_brut_mensuel AS salaire_brut_mensuel_7, t0.salaire_net_mensuel AS salaire_net_mensuel_8, t0.status AS status_9, t0.type AS type_10, t0.description AS description_11, t0.complement_information AS complement_information_12, t0.advantage AS advantage_13, t0.prime AS prime_14, t0.tele_travail AS tele_travail_15, t0.started_at AS started_at_16, t0.ended_at AS ended_at_17, t0.number_position AS number_position_18, t0.position_status AS position_status_19, t0.experience AS experience_20, t0.foreign_language AS foreign_language_21, t0.profil AS profil_22, t0.mission AS mission_23, t0.establishment_description AS establishment_description_24, t0.reference AS reference_25, t0.job_start_date AS job_start_date_26, t0.job_address AS job_address_27, t0.job_time AS job_time_28, t0.offert_type AS offert_type_29, t0.remuneration AS remuneration_30, t0.offert_link AS offert_link_31, t0.id AS id_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.operator_id AS operator_id_35 FROM job_offert t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"offre-de-formation-securite-et-gestion-de-linformation-en-entreprise-comment-preparer-et-bien-vivre-"
]
|
||||||||||||||||||||||
| 2 | 0.64 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.salaire_brut_annuel AS salaire_brut_annuel_3, t0.salaire_net_annuel AS salaire_net_annuel_4, t0.salaire_brut_heure AS salaire_brut_heure_5, t0.salaire_net_heure AS salaire_net_heure_6, t0.salaire_brut_mensuel AS salaire_brut_mensuel_7, t0.salaire_net_mensuel AS salaire_net_mensuel_8, t0.status AS status_9, t0.type AS type_10, t0.description AS description_11, t0.complement_information AS complement_information_12, t0.advantage AS advantage_13, t0.prime AS prime_14, t0.tele_travail AS tele_travail_15, t0.started_at AS started_at_16, t0.ended_at AS ended_at_17, t0.number_position AS number_position_18, t0.position_status AS position_status_19, t0.experience AS experience_20, t0.foreign_language AS foreign_language_21, t0.profil AS profil_22, t0.mission AS mission_23, t0.establishment_description AS establishment_description_24, t0.reference AS reference_25, t0.job_start_date AS job_start_date_26, t0.job_address AS job_address_27, t0.job_time AS job_time_28, t0.offert_type AS offert_type_29, t0.remuneration AS remuneration_30, t0.offert_link AS offert_link_31, t0.id AS id_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.operator_id AS operator_id_35 FROM job_offert t0 WHERE t0.id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||
| 3 | 0.39 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.salaire_brut_annuel AS salaire_brut_annuel_3, t0.salaire_net_annuel AS salaire_net_annuel_4, t0.salaire_brut_heure AS salaire_brut_heure_5, t0.salaire_net_heure AS salaire_net_heure_6, t0.salaire_brut_mensuel AS salaire_brut_mensuel_7, t0.salaire_net_mensuel AS salaire_net_mensuel_8, t0.status AS status_9, t0.type AS type_10, t0.description AS description_11, t0.complement_information AS complement_information_12, t0.advantage AS advantage_13, t0.prime AS prime_14, t0.tele_travail AS tele_travail_15, t0.started_at AS started_at_16, t0.ended_at AS ended_at_17, t0.number_position AS number_position_18, t0.position_status AS position_status_19, t0.experience AS experience_20, t0.foreign_language AS foreign_language_21, t0.profil AS profil_22, t0.mission AS mission_23, t0.establishment_description AS establishment_description_24, t0.reference AS reference_25, t0.job_start_date AS job_start_date_26, t0.job_address AS job_address_27, t0.job_time AS job_time_28, t0.offert_type AS offert_type_29, t0.remuneration AS remuneration_30, t0.offert_link AS offert_link_31, t0.id AS id_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.operator_id AS operator_id_35 FROM job_offert t0 WHERE t0.id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||
| 4 | 0.84 ms |
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN job_offert_category ON t0.id = job_offert_category.category_id WHERE job_offert_category.job_offert_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||
| 5 | 0.49 ms |
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.job_offert_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||
| 6 | 0.66 ms |
SELECT t0.name AS name_1, t0.note AS note_2, t0.manager AS manager_3, t0.reference AS reference_4, t0.phone AS phone_5, t0.description AS description_6, t0.website AS website_7, t0.email AS email_8, t0.phone2 AS phone2_9, t0.view_number AS view_number_10, t0.verified AS verified_11, t0.score AS score_12, t0.keywords AS keywords_13, t0.place_id AS place_id_14, t0.platform AS platform_15, t0.version AS version_16, t0.google_type AS google_type_17, t0.google_photos AS google_photos_18, t0.map_url AS map_url_19, t0.weekday_text AS weekday_text_20, t0.enabled AS enabled_21, t0.ranks AS ranks_22, t0.full_address AS full_address_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.slug AS slug_28, t0.id AS id_29, t0.facebook AS facebook_30, t0.youtube AS youtube_31, t0.instagram AS instagram_32, t0.twitter AS twitter_33, t0.google_plus AS google_plus_34, t0.region_id AS region_id_35, t0.commune_id AS commune_id_36, t0.city_id AS city_id_37, t0.quartier_id AS quartier_id_38, t0.sub_prefecture_id AS sub_prefecture_id_39, t0.prefecture_id AS prefecture_id_40, t0.campagne_id AS campagne_id_41, t0.operator_id AS operator_id_42, t0.quotation_id AS quotation_id_43 FROM establishment t0 INNER JOIN job_offert_establishment ON t0.id = job_offert_establishment.establishment_id WHERE job_offert_establishment.job_offert_id = ?
Parameters:
[
4
]
|
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\JobOffert | No errors. |
| App\Entity\Operator | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Establishment | No errors. |
| App\Entity\PopularCategory | No errors. |
| App\Entity\Quotation | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Campagne | No errors. |
| App\Entity\LandingPage | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Quartier | No errors. |
| App\Entity\SubPrefecture | No errors. |
| App\Entity\Prefecture | No errors. |