Query Metrics
14
Database Queries
13
Different statements
19.76 ms
Query time
2
Invalid entities
227
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.38 ms (37.36%) |
2 |
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"
]
|
|
3.10 ms (15.70%) |
1 |
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:
[] |
|
1.91 ms (9.66%) |
1 |
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gh_ad_billing g0_ ORDER BY g0_.id ASC
Parameters:
[] |
|
1.78 ms (9.02%) |
1 |
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gh_ad_menu g0_ ORDER BY g0_.id ASC
Parameters:
[] |
|
1.51 ms (7.62%) |
1 |
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"
]
|
|
0.70 ms (3.55%) |
1 |
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:
[] |
|
0.66 ms (3.35%) |
1 |
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"
]
|
|
0.63 ms (3.18%) |
1 |
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"
]
|
|
0.55 ms (2.76%) |
1 |
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"
]
|
|
0.50 ms (2.52%) |
1 |
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"
]
|
|
0.42 ms (2.14%) |
1 |
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"
]
|
|
0.41 ms (2.09%) |
1 |
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"
]
|
|
0.21 ms (1.05%) |
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 gh_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 |
|---|---|
| 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 |
|