GET http://193.70.3.237/job/offer/superviseur-departement-appui-aux-entreprises/details

Query Metrics

6 Database Queries
5 Different statements
3.93 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 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:
[
  "superviseur-departement-appui-aux-entreprises"
]
2 0.71 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:
[
  27
]
3 0.44 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:
[
  29
]
4 0.64 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:
[
  28
]
5 0.53 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:
[
  28
]
6 0.75 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:
[
  28
]

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