GET https://www.askanbi.com/index.php/ad/fr-sn/menu/immovable

Query Metrics

31 Database Queries
20 Different statements
46.37 ms Query time
3 Invalid entities
245 Managed entities

Queries

Group similar statements

# Time Info
1 8.78 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 sn_ad_menu t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "immovable"
]
2 3.48 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.marketing_code AS marketing_code_1, s0_.chrono AS chrono_2, s0_.ref AS ref_3, s0_.motel AS motel_4, s0_.immovable AS immovable_5, s0_.agricultural AS agricultural_6, s0_.machinery AS machinery_7, s0_.vehicle AS vehicle_8, s0_.slug AS slug_9, s0_.sum_by_hour AS sum_by_hour_10, s0_.sum_by_day AS sum_by_day_11, s0_.sum_by_night AS sum_by_night_12, s0_.sum_by_month AS sum_by_month_13, s0_.deposit_month AS deposit_month_14, s0_.content AS content_15, s0_.url AS url_16, s0_.is_enabled AS is_enabled_17, s0_.telephone AS telephone_18, s0_.filename AS filename_19, s0_.file_url AS file_url_20, s0_.file_url_mobile AS file_url_mobile_21, s0_.created_at AS created_at_22, s0_.updated_at AS updated_at_23, s0_.premium_end AS premium_end_24, CASE WHEN s0_.created_at IS NULL THEN 1 ELSE 0 END AS sclr_25 FROM sn_ad s0_ INNER JOIN sn_ad_sub_menu s1_ ON s0_.sub_menu_id = s1_.id INNER JOIN sn_author s2_ ON s0_.author_id = s2_.id INNER JOIN sn_ad_menu s3_ ON s1_.menu_id = s3_.id WHERE s0_.is_enabled = true AND s2_.is_enabled = true AND s3_.slug = ? ORDER BY sclr_25 DESC, s0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "immovable"
]
3 4.38 ms
SELECT s0_.name AS name_0, s0_.slug AS slug_1 FROM sn_ad_billing s0_ ORDER BY s0_.id ASC
Parameters:
[]
4 0.21 ms
SELECT s0_.name AS name_0, s0_.slug AS slug_1 FROM sn_ad_menu s0_ ORDER BY s0_.id ASC
Parameters:
[]
5 0.50 ms
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 sn_country s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_enabled = true LIMIT 1
Parameters:
[
  "sn"
]
6 0.18 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 sn_ad_menu t0
Parameters:
[]
7 1.23 ms
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 sn_country_recruitment s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
8 1.68 ms
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 sn_country_restaurant s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
9 2.48 ms
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 sn_country_insurance s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
10 0.41 ms
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 sn_country_jackpot s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
11 4.69 ms
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 sn_country_restaurant s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
12 0.46 ms
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 sn_country_land s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
13 0.44 ms
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 sn_country_car s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
14 4.68 ms
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 sn_country_ad s0_ WHERE LOWER(s0_.code) = ? AND s0_.is_visible = true LIMIT 1
Parameters:
[
  "sn"
]
15 0.66 ms
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 sn_country s0_ WHERE s0_.is_enabled = true ORDER BY s0_.id ASC
Parameters:
[]
16 0.29 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
17 2.65 ms
SELECT DISTINCT id_0, MIN(sclr_26) AS dctrn_minrownum FROM (SELECT s0_.id AS id_0, s0_.marketing_code AS marketing_code_1, s0_.chrono AS chrono_2, s0_.ref AS ref_3, s0_.motel AS motel_4, s0_.immovable AS immovable_5, s0_.agricultural AS agricultural_6, s0_.machinery AS machinery_7, s0_.vehicle AS vehicle_8, s0_.slug AS slug_9, s0_.sum_by_hour AS sum_by_hour_10, s0_.sum_by_day AS sum_by_day_11, s0_.sum_by_night AS sum_by_night_12, s0_.sum_by_month AS sum_by_month_13, s0_.deposit_month AS deposit_month_14, s0_.content AS content_15, s0_.url AS url_16, s0_.is_enabled AS is_enabled_17, s0_.telephone AS telephone_18, s0_.filename AS filename_19, s0_.file_url AS file_url_20, s0_.file_url_mobile AS file_url_mobile_21, s0_.created_at AS created_at_22, s0_.updated_at AS updated_at_23, s0_.premium_end AS premium_end_24, CASE WHEN s0_.created_at IS NULL THEN 1 ELSE 0 END AS sclr_25, ROW_NUMBER() OVER(ORDER BY CASE WHEN s0_.created_at IS NULL THEN 1 ELSE 0 END DESC, s0_.created_at DESC) AS sclr_26 FROM sn_ad s0_ INNER JOIN sn_ad_sub_menu s1_ ON s0_.sub_menu_id = s1_.id INNER JOIN sn_author s2_ ON s0_.author_id = s2_.id INNER JOIN sn_ad_menu s3_ ON s1_.menu_id = s3_.id WHERE s0_.is_enabled = true AND s2_.is_enabled = true AND s3_.slug = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10
Parameters:
[
  "immovable"
]
18 1.40 ms
SELECT s0_.id AS id_0, s0_.marketing_code AS marketing_code_1, s0_.chrono AS chrono_2, s0_.ref AS ref_3, s0_.motel AS motel_4, s0_.immovable AS immovable_5, s0_.agricultural AS agricultural_6, s0_.machinery AS machinery_7, s0_.vehicle AS vehicle_8, s0_.slug AS slug_9, s0_.sum_by_hour AS sum_by_hour_10, s0_.sum_by_day AS sum_by_day_11, s0_.sum_by_night AS sum_by_night_12, s0_.sum_by_month AS sum_by_month_13, s0_.deposit_month AS deposit_month_14, s0_.content AS content_15, s0_.url AS url_16, s0_.is_enabled AS is_enabled_17, s0_.telephone AS telephone_18, s0_.filename AS filename_19, s0_.file_url AS file_url_20, s0_.file_url_mobile AS file_url_mobile_21, s0_.created_at AS created_at_22, s0_.updated_at AS updated_at_23, s0_.premium_end AS premium_end_24, CASE WHEN s0_.created_at IS NULL THEN 1 ELSE 0 END AS sclr_25, s0_.billing_id AS billing_id_26, s0_.sub_menu_id AS sub_menu_id_27, s0_.author_id AS author_id_28, s0_.country_id AS country_id_29, s0_.marketing_id AS marketing_id_30 FROM sn_ad s0_ INNER JOIN sn_ad_sub_menu s1_ ON s0_.sub_menu_id = s1_.id INNER JOIN sn_author s2_ ON s0_.author_id = s2_.id INNER JOIN sn_ad_menu s3_ ON s1_.menu_id = s3_.id WHERE s0_.is_enabled = true AND s2_.is_enabled = true AND s3_.slug = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_25 DESC, s0_.created_at DESC
Parameters:
[
  "immovable"
  32
  31
  30
  29
  28
  27
  26
  25
  24
  23
]
19 0.74 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.slug AS slug_4, t0.phone_code AS phone_code_5, t0.phone AS phone_6, t0.telephone AS telephone_7, t0.password AS password_8, t0.borned_at AS borned_at_9, t0.age AS age_10, t0.email AS email_11, t0.address AS address_12, t0.job AS job_13, t0.marital_status AS marital_status_14, t0.confirmation_token AS confirmation_token_15, t0.is_enabled AS is_enabled_16, t0.department AS department_17, t0.region AS region_18, t0.locale AS locale_19, t0.country AS country_20, t0.flag AS flag_21, t0.currency AS currency_22, t0.last_login_at AS last_login_at_23, t0.insurance_commercial_bonus AS insurance_commercial_bonus_24, t0.username AS username_25, t0.roles AS roles_26, t0.grades AS grades_27, t0.pseudo AS pseudo_28, t0.nickname AS nickname_29, t0.url AS url_30, t0.description AS description_31, t0.filename AS filename_32, t0.file_url AS file_url_33, t0.file_url_mobile AS file_url_mobile_34, t0.is_teleworker AS is_teleworker_35, t0.telework_created_at AS telework_created_at_36, t0.marketing_code AS marketing_code_37, t0.marketing_code_visible AS marketing_code_visible_38, t0.marketing AS marketing_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41, t0.notifications_read_at AS notifications_read_at_42, t0.gender AS gender_43, t0.visiting_card_url AS visiting_card_url_44, t0.badge_url AS badge_url_45, t0.is_check_telephone_update AS is_check_telephone_update_46, t0.phone_code_update AS phone_code_update_47, t0.telephone_update AS telephone_update_48, t0.insurer_id AS insurer_id_49, t0.ticketer_id AS ticketer_id_50 FROM sn_author t0 WHERE t0.id = ?
Parameters:
[
  19
]
20 1.84 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
21 0.24 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 sn_ad_billing t0 WHERE t0.id = ?
Parameters:
[
  4
]
22 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, t0.menu_id AS menu_id_5 FROM sn_ad_sub_menu t0 WHERE t0.id = ?
Parameters:
[
  4
]
23 0.24 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
24 0.22 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
25 0.22 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
26 0.23 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
27 0.24 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
28 2.24 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
29 0.24 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
30 0.24 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]
31 0.81 ms
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 sn_country t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sn"
]

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\Ad 10
App\Entity\AdMenu 5
App\Entity\CountryRecruitment 1
App\Entity\CountryRestaurant 1
App\Entity\CountryInsurance 1
App\Entity\CountryJackpot 1
App\Entity\CountryLand 1
App\Entity\CountryCar 1
App\Entity\CountryAd 1
App\Entity\AdBilling 1
App\Entity\AdSubMenu 1
App\Entity\Author 1
App\Entity\Insurer 1
App\Entity\Ticketer 1

Entities Mapping

Class Mapping errors
App\Entity\AdMenu No errors.
App\Entity\Ad No errors.
App\Entity\AdSubMenu No errors.
App\Entity\Author
  • The mappings App\Entity\Author#followers and App\Entity\Follower#author are inconsistent with each other.
App\Entity\AdBilling No errors.
App\Entity\Country No errors.
App\Entity\CountryRecruitment No errors.
App\Entity\Recruitment No errors.
App\Entity\CountryRestaurant No errors.
App\Entity\Restaurant No errors.
App\Entity\CountryInsurance No errors.
App\Entity\AutoCategory No errors.
App\Entity\Insurance No errors.
App\Entity\CountryJackpot No errors.
App\Entity\Jackpot
  • The association App\Entity\Jackpot#author refers to the inverse side field App\Entity\Author#jackpots which does not exist.
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\AdAlbum No errors.
App\Entity\Insurer No errors.
App\Entity\Ticketer No errors.
App\Entity\AuthorAlbum No errors.
App\Entity\Follower No errors.
App\Entity\Car No errors.
App\Entity\TicketingNumbering No errors.
App\Entity\TicketingReceipt No errors.
App\Entity\TicketingSubscription No errors.
App\Entity\TicketBill No errors.