GET https://www.fus.ac-dev.fr/

Query Metrics

290 Database Queries
21 Different statements
97.91 ms Query time
2 Invalid entities
758 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
24.99 ms
(25.52%)
86
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.type AS type_4, t0.slug AS slug_5, t0.field_values AS field_values_6, t0.groups AS groups_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.component_template_id AS component_template_id_10 FROM component_field t0 WHERE t0.id = ?
Parameters:
[
  22
]
24.54 ms
(25.06%)
69
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.component_id AS component_id_5, t0.component_field_id AS component_field_id_6 FROM component_value t0 WHERE t0.component_id = ?
Parameters:
[
  16602
]
12.53 ms
(12.80%)
31
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.custom_classes AS custom_classes_3, t0.type AS type_4, t0.type_id AS type_id_5, t0.position AS position_6, t0.visibility_xs AS visibility_xs_7, t0.visibility_s AS visibility_s_8, t0.visibility_m AS visibility_m_9, t0.visibility_l AS visibility_l_10, t0.visibility_xl AS visibility_xl_11, t0.is_temp AS is_temp_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.component_template_id AS component_template_id_15, t0.parent_component_id AS parent_component_id_16 FROM component t0 WHERE t0.parent_component_id = ? ORDER BY t0.position ASC
Parameters:
[
  16602
]
11.13 ms
(11.37%)
37
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alt AS alt_4, t0.description AS description_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "1595"
]
5.36 ms
(5.47%)
15
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.is_parent AS is_parent_4, t0.type AS type_5, t0.id_type AS id_type_6, t0.is_list AS is_list_7, t0.position AS position_8, t0.slug AS slug_9, t0.target AS target_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_id AS menu_id_13, t0.menu_item_parent_id AS menu_item_parent_id_14 FROM menu_item t0 WHERE t0.menu_item_parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
4.54 ms
(4.64%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.is_container AS is_container_5, t0.prototype AS prototype_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM component_template t0 WHERE t0.id = ?
Parameters:
[
  4
]
1.88 ms
(1.92%)
5
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.published AS published_4, t0.template AS template_5, t0.position AS position_6, t0.content AS content_7, t0.thumbnail AS thumbnail_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM page t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.82 ms
(1.86%)
5
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.is_verified AS is_verified_11, t0.verify_token AS verify_token_12 FROM base_user_shop t0 WHERE t0.id = ?
Parameters:
[
  8876
]
1.33 ms
(1.36%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.is_parent AS is_parent_4, t0.type AS type_5, t0.id_type AS id_type_6, t0.is_list AS is_list_7, t0.position AS position_8, t0.slug AS slug_9, t0.target AS target_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_id AS menu_id_13, t0.menu_item_parent_id AS menu_item_parent_id_14 FROM menu_item t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
1.21 ms
(1.24%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.id AS id_7, t6.name AS name_8, t6.slug AS slug_9, t6.description AS description_10, t6.created_at AS created_at_11, t6.updated_at AS updated_at_12, t6.menu_id AS menu_id_13 FROM menu t0 LEFT JOIN menu_area t6 ON t6.menu_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
1.18 ms
(1.20%)
1
SELECT t0.id AS id_1, t0.grade AS grade_2, t0.comment AS comment_3, t0.published AS published_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t7.ref AS ref_8, t7.message AS message_9, t7.is_payment_in_shop AS is_payment_in_shop_10, t7.is_shop_order AS is_shop_order_11, t7.created_at AS created_at_12, t7.updated_at AS updated_at_13, t7.id AS id_14, t7.tracking_number AS tracking_number_15, t7.carrier_url AS carrier_url_16, t7.discount_token AS discount_token_17, t7.had_discount AS had_discount_18, t7.discount_creation_date AS discount_creation_date_19, t7.payment_id AS payment_id_20, t7.client_id AS client_id_21, t7.shipping_mode_id AS shipping_mode_id_22, t7.treatment_delay_id AS treatment_delay_id_23, t7.order_status_id AS order_status_id_24, t7.invoice_address_id AS invoice_address_id_25, t7.delivery_address_id AS delivery_address_id_26, t7.cart_id AS cart_id_27, t7.discount_id AS discount_id_28, t7.review_id AS review_id_29 FROM review t0 LEFT JOIN `order` t7 ON t7.review_id = t0.id WHERE t0.published = ? ORDER BY t0.created_at DESC LIMIT 5
Parameters:
[
  1
]
1.14 ms
(1.17%)
6
SELECT t0.id AS id_1, t0.site_title AS site_title_2, t0.favicon AS favicon_3, t0.site_logo AS site_logo_4, t0.back_main_color AS back_main_color_5, t0.has_posts AS has_posts_6, t0.has_archive_entities AS has_archive_entities_7, t0.has_single_entities AS has_single_entities_8, t0.has_seo_entities AS has_seo_entities_9, t0.agency_link AS agency_link_10, t0.agency_name AS agency_name_11, t0.recaptcha_public_key AS recaptcha_public_key_12, t0.recaptcha_private_key AS recaptcha_private_key_13, t0.homepage_id AS homepage_id_14 FROM core_options t0
Parameters:
[]
1.11 ms
(1.14%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.menu_id AS menu_id_7 FROM menu_area t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "menu-principal"
]
1.07 ms
(1.10%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.value AS value_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.option_category_id AS option_category_id_8 FROM `option` t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "fb"
]
1.04 ms
(1.06%)
1
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.custom_classes AS custom_classes_3, t0.type AS type_4, t0.type_id AS type_id_5, t0.position AS position_6, t0.visibility_xs AS visibility_xs_7, t0.visibility_s AS visibility_s_8, t0.visibility_m AS visibility_m_9, t0.visibility_l AS visibility_l_10, t0.visibility_xl AS visibility_xl_11, t0.is_temp AS is_temp_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.component_template_id AS component_template_id_15, t0.parent_component_id AS parent_component_id_16 FROM component t0 WHERE t0.type = ? AND t0.type_id = ? AND t0.is_temp = ? AND t0.parent_component_id IS NULL ORDER BY t0.position ASC
Parameters:
[
  "Page"
  1
  0
]
0.78 ms
(0.80%)
1
SELECT p0_.id AS id_0, p0_.date_start AS date_start_1, p0_.date_end AS date_end_2, p0_.title AS title_3, p0_.text AS text_4 FROM popup p0_ WHERE p0_.date_start <= ? AND p0_.date_end >= ?
Parameters:
[
  "2026-10-09 14:24:43"
  "2026-10-09 14:24:43"
]
0.56 ms
(0.58%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM option_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "footer"
]
0.55 ms
(0.56%)
1
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.no_index AS no_index_4, t0.meta_robots AS meta_robots_5, t0.type AS type_6, t0.type_id AS type_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM seo t0 WHERE t0.type = ? AND t0.type_id = ? LIMIT 1
Parameters:
[
  "Page"
  1
]
0.51 ms
(0.52%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.value AS value_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.option_category_id AS option_category_id_8 FROM `option` t0 WHERE t0.option_category_id = ?
Parameters:
[
  1
]
0.42 ms
(0.43%)
2
SELECT t0.id AS id_1, t0.has_builder_entities AS has_builder_entities_2 FROM builder_options t0
Parameters:
[]
0.21 ms
(0.21%)
1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.contact_mail AS contact_mail_3, t0.address AS address_4, t0.analytics_code AS analytics_code_5, t0.tag_manager_code AS tag_manager_code_6, t0.has_youtube_videos AS has_youtube_videos_7, t0.sopp_customer_id AS sopp_customer_id_8, t0.id_sir_data_user AS id_sir_data_user_9, t0.id_sir_data_site AS id_sir_data_site_10, t0.service_used AS service_used_11, t0.contact_page_id AS contact_page_id_12, t0.policy_page_id AS policy_page_id_13 FROM rgpd_options 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
Akyos\BuilderBundle\Entity\ComponentValue 479
Akyos\BuilderBundle\Entity\ComponentField 86
Akyos\BuilderBundle\Entity\Component 69
Akyos\FileManagerBundle\Entity\File 37
Akyos\CoreBundle\Entity\MenuItem 15
Akyos\BuilderBundle\Entity\ComponentTemplate 14
Akyos\CoreBundle\Entity\Option 6
Akyos\CoreBundle\Entity\Page 5
App\Entity\Review\Review 5
App\Entity\Shop\Order 5
Akyos\ShopBundle\Entity\Payment 5
Akyos\ShopBundle\Entity\BaseUserShop 5
Akyos\ShopBundle\Entity\ShopAddress 5
Akyos\ShopBundle\Entity\Cart 5
Akyos\CoreBundle\Entity\MenuArea 3
Akyos\CoreBundle\Entity\Menu 3
Akyos\ShopBundle\Entity\TreatmentDelay 2
Akyos\CoreBundle\Entity\OptionCategory 2
Akyos\CoreBundle\Entity\CoreOptions 1
Akyos\BuilderBundle\Entity\BuilderOptions 1
Akyos\CoreBundle\Entity\Seo 1
Akyos\CoreBundle\Entity\RgpdOptions 1
Akyos\ShopBundle\Entity\ShippingMode 1
Akyos\ShopBundle\Entity\OrderStatus 1
Akyos\ShopBundle\Entity\Discount 1

Entities Mapping

Class Mapping errors
Akyos\CoreBundle\Entity\CoreOptions No errors.
Akyos\CoreBundle\Entity\Page No errors.
Akyos\BuilderBundle\Entity\BuilderOptions No errors.
Akyos\BuilderBundle\Entity\Component No errors.
Akyos\BuilderBundle\Entity\ComponentTemplate No errors.
Akyos\BuilderBundle\Entity\ComponentValue No errors.
Akyos\CoreBundle\Entity\Seo No errors.
Akyos\CoreBundle\Entity\RgpdOptions No errors.
Akyos\FileManagerBundle\Entity\File No errors.
Akyos\CoreBundle\Entity\MenuArea No errors.
Akyos\CoreBundle\Entity\Menu No errors.
Akyos\CoreBundle\Entity\MenuItem No errors.
App\Entity\Agrafe No errors.
App\Entity\AgrafeShape No errors.
App\Entity\AgrafeSize No errors.
App\Entity\AgrafesColor No errors.
App\Entity\Category No errors.
App\Entity\DefaultAgrafe No errors.
App\Entity\Echelon No errors.
App\Entity\FAQ No errors.
App\Entity\Grade No errors.
Akyos\ShopBundle\Entity\BaseProduct No errors.
App\Entity\Shop\Product No errors.
App\Entity\Medal No errors.
App\Entity\Mounting No errors.
App\Entity\MountingMedal No errors.
App\Entity\MountingMedalAgrafe No errors.
App\Entity\MountingOption No errors.
App\Entity\MountingOptionsGroup No errors.
App\Entity\MountingSet No errors.
App\Entity\MountingUnknownMedal No errors.
App\Entity\Popup No errors.
App\Entity\RankedMedal No errors.
App\Entity\Review\Review No errors.
Akyos\ShopBundle\Entity\BaseOrder
  • The referenced column name 'id' has to be a primary key column on the target entity class 'Akyos\ShopBundle\Entity\BaseOrder'.
  • The join columns of the many-to-many table 'base_order_shop_address' have to contain to ALL identifier columns of the source entity 'Akyos\ShopBundle\Entity\BaseOrder', however '' are missing.
App\Entity\Shop\Order No errors.
App\Entity\SteppedMedal No errors.
App\Entity\Type No errors.
App\Entity\TypedAgrafe No errors.
App\Entity\TypedMedal No errors.
Akyos\BuilderBundle\Entity\ComponentField No errors.
Akyos\CoreBundle\Entity\BaseUser No errors.
Akyos\CoreBundle\Entity\NewPasswordRequest No errors.
Akyos\CoreBundle\Entity\Option No errors.
Akyos\CoreBundle\Entity\OptionCategory No errors.
Akyos\CoreBundle\Entity\Post No errors.
Akyos\CoreBundle\Entity\PostCategory No errors.
Akyos\CoreBundle\Entity\Redirect301 No errors.
Akyos\CoreBundle\Entity\User No errors.
Akyos\FormBundle\Entity\ContactForm No errors.
Akyos\FormBundle\Entity\ContactFormField No errors.
Akyos\ShopBundle\Entity\BaseUserShop No errors.
Akyos\ShopBundle\Entity\Cart No errors.
Akyos\ShopBundle\Entity\CartItem No errors.
Akyos\ShopBundle\Entity\Discount No errors.
Akyos\ShopBundle\Entity\OrderMail No errors.
Akyos\ShopBundle\Entity\OrderStatus
  • The mappings Akyos\ShopBundle\Entity\OrderStatus#orderShopEmail and Akyos\ShopBundle\Entity\OrderMail#orderStatus are inconsistent with each other.
Akyos\ShopBundle\Entity\OrderStatusLog No errors.
Akyos\ShopBundle\Entity\Payment No errors.
Akyos\ShopBundle\Entity\PaymentType No errors.
Akyos\ShopBundle\Entity\ShippingMode No errors.
Akyos\ShopBundle\Entity\ShopAddress No errors.
Akyos\ShopBundle\Entity\ShopOptions No errors.
Akyos\ShopBundle\Entity\TreatmentDelay No errors.