Query Metrics
14
Database Queries
13
Different statements
58.84 ms
Query time
2
Invalid entities
227
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.55 ms |
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gh_ad_billing g0_ ORDER BY g0_.id ASC
Parameters:
[] |
| 2 | 2.08 ms |
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gh_ad_menu g0_ ORDER BY g0_.id ASC
Parameters:
[] |
| 3 | 5.49 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 gh_country g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_enabled = true LIMIT 1
Parameters:
[
"gh"
]
|
| 4 | 0.27 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 gh_ad_menu t0
Parameters:
[] |
| 5 | 6.19 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 gh_country_recruitment g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 6 | 2.63 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 gh_country_restaurant g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 7 | 4.02 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 gh_country_insurance g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 8 | 1.07 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 gh_country_jackpot g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 9 | 5.00 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 gh_country_restaurant g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 10 | 7.23 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 gh_country_land g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 11 | 2.99 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 gh_country_car g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 12 | 0.47 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 gh_country_ad g0_ WHERE LOWER(g0_.code) = ? AND g0_.is_visible = true LIMIT 1
Parameters:
[
"gh"
]
|
| 13 | 9.63 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 gh_country g0_ WHERE g0_.is_enabled = true ORDER BY g0_.id ASC
Parameters:
[] |
| 14 | 10.24 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 gh_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 |
|
| App\Entity\CountryAd | No errors. |
| App\Entity\Ad | No errors. |
| App\Entity\Author |
|