Query Metrics

14 Database Queries
13 Different statements
24.42 ms Query time
2 Invalid entities
227 Managed entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gp_ad_billing g0_ ORDER BY g0_.id ASC
Parameters:
[]
2 0.43 ms
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gp_ad_menu g0_ ORDER BY g0_.id ASC
Parameters:
[]
3 1.06 ms
SELECT g0_.id AS id_0, g0_.is_enabled AS is_enabled_1, g0_.code AS code_2, g0_.flag AS flag_3, g0_.currency AS currency_4, g0_.phone_code AS phone_code_5, g0_.language AS language_6, g0_.name AS name_7, g0_.name_en AS name_en_8, g0_.created_at AS created_at_9, g0_.updated_at AS updated_at_10 FROM gp_country g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_enabled = true LIMIT 1
Parameters:
[
  "gp"
]
4 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.slug AS slug_4 FROM gp_ad_menu t0
Parameters:
[]
5 0.60 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_recruitment g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
6 1.39 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_restaurant g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
7 0.61 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_insurance g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
8 0.91 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_jackpot g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
9 0.48 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_restaurant g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
10 0.50 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_land g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
11 2.51 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_car g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
12 0.43 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.code AS code_2, g0_.is_visible AS is_visible_3, g0_.created_at AS created_at_4, g0_.updated_at AS updated_at_5 FROM gp_country_ad g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
  "gp"
]
13 5.62 ms
SELECT g0_.id AS id_0, g0_.is_enabled AS is_enabled_1, g0_.code AS code_2, g0_.flag AS flag_3, g0_.currency AS currency_4, g0_.phone_code AS phone_code_5, g0_.language AS language_6, g0_.name AS name_7, g0_.name_en AS name_en_8, g0_.created_at AS created_at_9, g0_.updated_at AS updated_at_10 FROM gp_country g0_ WHERE g0_.is_enabled = true ORDER BY g0_.id ASC
Parameters:
[]
14 8.67 ms
SELECT g0_.id AS id_0, g0_.marketing_code AS marketing_code_1, g0_.chrono AS chrono_2, g0_.ref AS ref_3, g0_.motel AS motel_4, g0_.immovable AS immovable_5, g0_.agricultural AS agricultural_6, g0_.machinery AS machinery_7, g0_.vehicle AS vehicle_8, g0_.slug AS slug_9, g0_.sum_by_hour AS sum_by_hour_10, g0_.sum_by_day AS sum_by_day_11, g0_.sum_by_night AS sum_by_night_12, g0_.sum_by_month AS sum_by_month_13, g0_.deposit_month AS deposit_month_14, g0_.content AS content_15, g0_.url AS url_16, g0_.is_enabled AS is_enabled_17, g0_.telephone AS telephone_18, g0_.filename AS filename_19, g0_.file_url AS file_url_20, g0_.file_url_mobile AS file_url_mobile_21, g0_.created_at AS created_at_22, g0_.updated_at AS updated_at_23, g0_.premium_end AS premium_end_24, g0_.billing_id AS billing_id_25, g0_.sub_menu_id AS sub_menu_id_26, g0_.author_id AS author_id_27, g0_.country_id AS country_id_28, g0_.marketing_id AS marketing_id_29 FROM gp_ad g0_ WHERE g0_.is_enabled = true ORDER BY RANDOM() ASC LIMIT 50
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
App\Entity\Country 218
App\Entity\AdMenu 5
App\Entity\CountryRestaurant 1
App\Entity\CountryLand 1
App\Entity\CountryCar 1
App\Entity\CountryAd 1

Entities Mapping

Class Mapping errors
App\Entity\AdBilling No errors.
App\Entity\AdMenu No errors.
App\Entity\Country No errors.
App\Entity\AdSubMenu No errors.
App\Entity\CountryRecruitment No errors.
App\Entity\CountryRestaurant No errors.
App\Entity\Restaurant No errors.
App\Entity\CountryInsurance No errors.
App\Entity\CountryJackpot No errors.
App\Entity\CountryTicketer No errors.
App\Entity\CountryLand No errors.
App\Entity\Land 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.
App\Entity\Ad No errors.
App\Entity\Author
  • The mappings App\Entity\Author#followers and App\Entity\Follower#author are inconsistent with each other.