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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.40 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:
[
  "luxembourg"
]
2 0.32 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:
[
  5
]
3 5.53 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:
[
  5
  "hu"
]
4 0.44 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:
[
  5
  "hu"
]
5 0.40 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.