Redirect 302 redirect from GET @to_index (d2f9cd)

GET https://www.askanbi.com/index.php/en-sg/account/login

Query Metrics

14 Database Queries
13 Different statements
10.15 ms Query time
1 Invalid entities
227 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.43 ms
(23.95%)
1
SELECT t0.id AS id_1, t0.is_enabled AS is_enabled_2, t0.code AS code_3, t0.flag AS flag_4, t0.currency AS currency_5, t0.phone_code AS phone_code_6, t0.language AS language_7, t0.name AS name_8, t0.name_en AS name_en_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM sg_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "us"
]
1.65 ms
(16.23%)
2
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_visible AS is_visible_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sg_country_restaurant s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sg"
]
1.36 ms
(13.40%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_visible AS is_visible_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sg_country_ad s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sg"
]
0.80 ms
(7.87%)
1
SELECT s0_.name AS name_0, s0_.slug AS slug_1 FROM sg_ad_billing s0_ ORDER BY s0_.id ASC
Parameters:
[]
0.65 ms
(6.45%)
1
SELECT s0_.id AS id_0, s0_.is_enabled AS is_enabled_1, s0_.code AS code_2, s0_.flag AS flag_3, s0_.currency AS currency_4, s0_.phone_code AS phone_code_5, s0_.language AS language_6, s0_.name AS name_7, s0_.name_en AS name_en_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM sg_country s0_ WHERE s0_.is_enabled = true ORDER BY s0_.id ASC
Parameters:
[]
0.50 ms
(4.97%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_visible AS is_visible_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sg_country_land s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sg"
]
0.47 ms
(4.62%)
1
SELECT s0_.id AS id_0, s0_.is_enabled AS is_enabled_1, s0_.code AS code_2, s0_.flag AS flag_3, s0_.currency AS currency_4, s0_.phone_code AS phone_code_5, s0_.language AS language_6, s0_.name AS name_7, s0_.name_en AS name_en_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM sg_country s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_enabled = true LIMIT 1
Parameters:
[
  "sg"
]
0.47 ms
(4.61%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_visible AS is_visible_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sg_country_recruitment s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sg"
]
0.44 ms
(4.33%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_visible AS is_visible_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sg_country_car s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sg"
]
0.43 ms
(4.22%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_visible AS is_visible_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sg_country_insurance s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sg"
]
0.41 ms
(4.06%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_visible AS is_visible_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM sg_country_jackpot s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sg"
]
0.33 ms
(3.21%)
1
SELECT s0_.name AS name_0, s0_.slug AS slug_1 FROM sg_ad_menu s0_ ORDER BY s0_.id ASC
Parameters:
[]
0.21 ms
(2.09%)
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 sg_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\Country No errors.
App\Entity\AdBilling No errors.
App\Entity\AdMenu 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.