Redirect 302 redirect from GET @index (4a4783)

GET https://askanbi.com/en-us/

Query Metrics

9 Database Queries
9 Different statements
58.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
17.04 ms
(29.30%)
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"
]
14.94 ms
(25.69%)
1
SELECT u0_.id AS id_0, u0_.chrono AS chrono_1, u0_.ref AS ref_2, u0_.motel AS motel_3, u0_.immovable AS immovable_4, u0_.agricultural AS agricultural_5, u0_.machinery AS machinery_6, u0_.vehicle AS vehicle_7, u0_.slug AS slug_8, u0_.sum_by_hour AS sum_by_hour_9, u0_.sum_by_day AS sum_by_day_10, u0_.sum_by_night AS sum_by_night_11, u0_.sum_by_month AS sum_by_month_12, u0_.deposit_month AS deposit_month_13, u0_.content AS content_14, u0_.is_enabled AS is_enabled_15, u0_.disabled_title AS disabled_title_16, u0_.disabled_message AS disabled_message_17, u0_.filename AS filename_18, u0_.file_url AS file_url_19, u0_.created_at AS created_at_20, u0_.updated_at AS updated_at_21, u0_.premium_end AS premium_end_22, u0_.billing_id AS billing_id_23, u0_.sub_menu_id AS sub_menu_id_24, u0_.author_id AS author_id_25 FROM us_ad u0_ WHERE u0_.is_enabled = true GROUP BY u0_.id, u0_.chrono, u0_.ref, u0_.motel, u0_.immovable, u0_.agricultural, u0_.machinery, u0_.vehicle, u0_.slug, u0_.sum_by_hour, u0_.sum_by_day, u0_.sum_by_night, u0_.sum_by_month, u0_.deposit_month, u0_.content, u0_.is_enabled, u0_.disabled_title, u0_.disabled_message, u0_.filename, u0_.file_url, u0_.created_at, u0_.updated_at, u0_.premium_end, u0_.billing_id, u0_.sub_menu_id, u0_.author_id ORDER BY RANDOM() ASC LIMIT 50
Parameters:
[]
7.93 ms
(13.63%)
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"
]
7.34 ms
(12.62%)
1
SELECT u0_.name AS name_0, u0_.slug AS slug_1 FROM us_ad_billing u0_ ORDER BY u0_.id ASC
Parameters:
[]
6.54 ms
(11.25%)
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_restaurant u0_ WHERE LOWER(u0_.code) = ? AND u0_.is_visible = true LIMIT 1
Parameters:
[
  "us"
]
3.43 ms
(5.89%)
1
SELECT u0_.name AS name_0, u0_.slug AS slug_1 FROM us_ad_menu u0_ ORDER BY u0_.id ASC
Parameters:
[]
0.40 ms
(0.69%)
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.35 ms
(0.61%)
1
SELECT u0_.id AS id_0, u0_.chrono AS chrono_1, u0_.ref AS ref_2, u0_.motel AS motel_3, u0_.immovable AS immovable_4, u0_.agricultural AS agricultural_5, u0_.machinery AS machinery_6, u0_.vehicle AS vehicle_7, u0_.slug AS slug_8, u0_.sum_by_hour AS sum_by_hour_9, u0_.sum_by_day AS sum_by_day_10, u0_.sum_by_night AS sum_by_night_11, u0_.sum_by_month AS sum_by_month_12, u0_.deposit_month AS deposit_month_13, u0_.content AS content_14, u0_.is_enabled AS is_enabled_15, u0_.disabled_title AS disabled_title_16, u0_.disabled_message AS disabled_message_17, u0_.filename AS filename_18, u0_.file_url AS file_url_19, u0_.created_at AS created_at_20, u0_.updated_at AS updated_at_21, u0_.premium_end AS premium_end_22, u0_.billing_id AS billing_id_23, u0_.sub_menu_id AS sub_menu_id_24, u0_.author_id AS author_id_25 FROM us_ad u0_ WHERE u0_.is_enabled = true ORDER BY RANDOM() ASC LIMIT 50
Parameters:
[]
0.19 ms
(0.33%)
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.

Entities Mapping

Class Mapping errors
App\Entity\Ad No errors.
App\Entity\CountryInsurance No errors.
App\Entity\CountryRestaurant No errors.
App\Entity\AdBilling No errors.
App\Entity\AdSubMenu No errors.
App\Entity\Author No errors.
App\Entity\AdMenu No errors.
App\Entity\Country No errors.