https://icf-new.demo.slsitservices.com/career/dutch-speaking-account-manager

Query Metrics

4 Database Queries
4 Different statements
13.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.40 ms
(78.94%)
1
SELECT j0_.name AS name_0, j0_.level AS level_1, j0_.working_hours AS working_hours_2, j0_.description AS description_3, j0_.external_apply_url AS external_apply_url_4, j0_.short_description AS short_description_5, j0_.id AS id_6, j0_.slug AS slug_7, j0_.enabled AS enabled_8, j0_.created_at AS created_at_9, j0_.updated_at AS updated_at_10, j0_.location_id AS location_id_11, j0_.created_by_id AS created_by_id_12, j0_.updated_by_id AS updated_by_id_13 FROM job j0_ WHERE j0_.enabled = 1 AND j0_.slug = ?
Parameters:
[
  "dutch-speaking-account-manager"
]
1.61 ms
(12.20%)
1
SELECT t0.name AS name_1, t0.email AS email_2, t0.cover_letter AS cover_letter_3, t0.cv_file_path AS cv_file_path_4, t0.privacy_policy_accepted AS privacy_policy_accepted_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.job_id AS job_id_9 FROM job_application t0 WHERE t0.job_id = ?
Parameters:
[
  5
]
0.59 ms
(4.49%)
1
SELECT l0_.code AS code_0, l0_.headquarter AS headquarter_1, l0_.company AS company_2, l0_.description AS description_3, l0_.country_code AS country_code_4, l0_.city AS city_5, l0_.address AS address_6, l0_.email AS email_7, l0_.message_email AS message_email_8, l0_.phone_number AS phone_number_9, l0_.facebook_link AS facebook_link_10, l0_.linkedin_link AS linkedin_link_11, l0_.gps_latitude AS gps_latitude_12, l0_.gps_longitude AS gps_longitude_13, l0_.id AS id_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, l0_.created_by_id AS created_by_id_17, l0_.updated_by_id AS updated_by_id_18 FROM location l0_
Parameters:
[]
0.58 ms
(4.37%)
1
SELECT t0.code AS code_1, t0.headquarter AS headquarter_2, t0.company AS company_3, t0.description AS description_4, t0.country_code AS country_code_5, t0.city AS city_6, t0.address AS address_7, t0.email AS email_8, t0.message_email AS message_email_9, t0.phone_number AS phone_number_10, t0.facebook_link AS facebook_link_11, t0.linkedin_link AS linkedin_link_12, t0.gps_latitude AS gps_latitude_13, t0.gps_longitude AS gps_longitude_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19 FROM location t0 WHERE t0.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\Job No errors.
App\Entity\Location No errors.
App\Entity\User No errors.
App\Entity\JobApplication No errors.
App\Entity\LocationTranslation No errors.
App\Entity\Message No errors.