Query Metrics
14
Database Queries
13
Different statements
58.84 ms
Query time
2
Invalid entities
227
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.24 ms (17.40%) |
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:
[] |
|
9.63 ms (16.37%) |
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:
[] |
|
7.63 ms (12.96%) |
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"
]
|
|
7.23 ms (12.29%) |
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"
]
|
|
6.19 ms (10.51%) |
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"
]
|
|
5.49 ms (9.32%) |
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"
]
|
|
4.02 ms (6.82%) |
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"
]
|
|
2.99 ms (5.08%) |
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"
]
|
|
2.08 ms (3.54%) |
1 |
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gh_ad_menu g0_ ORDER BY g0_.id ASC
Parameters:
[] |
|
1.55 ms (2.63%) |
1 |
SELECT g0_.name AS name_0, g0_.slug AS slug_1 FROM gh_ad_billing g0_ ORDER BY g0_.id ASC
Parameters:
[] |
|
1.07 ms (1.82%) |
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.47 ms (0.79%) |
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.27 ms (0.46%) |
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 |
|