Query Metrics

13 Database Queries
12 Different statements
8.62 ms Query time
1 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.34 ms
(15.49%)
1
SELECT u0_.name AS name_0, u0_.slug AS slug_1 FROM us_ad_menu u0_ ORDER BY u0_.id ASC
Parameters:
[]
0.96 ms
(11.18%)
1
SELECT u0_.name AS name_0, u0_.slug AS slug_1 FROM us_ad_billing u0_ ORDER BY u0_.id ASC
Parameters:
[]
0.89 ms
(10.28%)
1
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.code AS code_2, u0_.is_visible AS is_visible_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5 FROM us_country_insurance u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
0.85 ms
(9.87%)
1
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.code AS code_2, u0_.is_visible AS is_visible_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5 FROM us_country_ad u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
0.85 ms
(9.83%)
2
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.code AS code_2, u0_.is_visible AS is_visible_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5 FROM us_country_restaurant u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
0.77 ms
(8.92%)
1
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.code AS code_2, u0_.is_visible AS is_visible_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5 FROM us_country_jackpot u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
0.72 ms
(8.36%)
1
SELECT u0_.id AS id_0, u0_.is_enabled AS is_enabled_1, u0_.code AS code_2, u0_.flag AS flag_3, u0_.currency AS currency_4, u0_.phone_code AS phone_code_5, u0_.language AS language_6, u0_.name AS name_7, u0_.name_en AS name_en_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10 FROM us_country u0_ WHERE u0_.is_enabled = true ORDER BY u0_.id ASC
Parameters:
[]
0.59 ms
(6.85%)
1
SELECT u0_.id AS id_0, u0_.is_enabled AS is_enabled_1, u0_.code AS code_2, u0_.flag AS flag_3, u0_.currency AS currency_4, u0_.phone_code AS phone_code_5, u0_.language AS language_6, u0_.name AS name_7, u0_.name_en AS name_en_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10 FROM us_country u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_enabled = true LIMIT 1
Parameters:
[
  "us"
]
0.55 ms
(6.41%)
1
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.code AS code_2, u0_.is_visible AS is_visible_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5 FROM us_country_recruitment u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
0.44 ms
(5.11%)
1
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.code AS code_2, u0_.is_visible AS is_visible_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5 FROM us_country_land u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
0.42 ms
(4.92%)
1
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.code AS code_2, u0_.is_visible AS is_visible_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5 FROM us_country_car u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
0.24 ms
(2.78%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.slug AS slug_4 FROM us_ad_menu t0
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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
App\Entity\AdBilling No errors.
App\Entity\AdMenu No errors.
App\Entity\Country No errors.
App\Entity\CountryRecruitment No errors.
App\Entity\CountryRestaurant No errors.
App\Entity\CountryInsurance No errors.
App\Entity\CountryJackpot No errors.
App\Entity\CountryTicketer No errors.
App\Entity\CountryLand No errors.
App\Entity\CountryCar
  • The mappings App\Entity\CountryCar#cars and App\Entity\Restaurant#country are inconsistent with each other.
App\Entity\CountryAd No errors.