https://icf-new.demo.slsitservices.com/location/seattle?lang=hu

Query Metrics

5 Database Queries
4 Different statements
151.09 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 ms
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.code = ? LIMIT 1
Parameters:
[
  "seattle"
]
2 111.28 ms
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_.location_id = ?
Parameters:
[
  1
]
3 38.55 ms
SELECT l0_.locale AS locale_0, l0_.headquarter AS headquarter_1, l0_.description AS description_2, l0_.city AS city_3, l0_.id AS id_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.location_id AS location_id_7, l0_.created_by_id AS created_by_id_8, l0_.updated_by_id AS updated_by_id_9 FROM location_translation l0_ WHERE l0_.location_id = ? AND l0_.locale = ?
Parameters:
[
  1
  "hu"
]
4 0.40 ms
SELECT l0_.locale AS locale_0, l0_.headquarter AS headquarter_1, l0_.description AS description_2, l0_.city AS city_3, l0_.id AS id_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.location_id AS location_id_7, l0_.created_by_id AS created_by_id_8, l0_.updated_by_id AS updated_by_id_9 FROM location_translation l0_ WHERE l0_.location_id = ? AND l0_.locale = ?
Parameters:
[
  1
  "hu"
]
5 0.38 ms
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:
[]

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\Location No errors.
App\Entity\User No errors.
App\Entity\LocationTranslation No errors.
App\Entity\Job No errors.
App\Entity\Message No errors.
App\Entity\JobApplication No errors.