GET https://www.fus.ac-dev.fr/authentification/sign-in

Query Metrics

44 Database Queries
12 Different statements
10.10 ms Query time
2 Invalid entities
40 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.57 ms
(35.36%)
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
]
1.25 ms
(12.40%)
5
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.18 ms
(11.68%)
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"
]
0.70 ms
(6.91%)
3
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"
]
0.69 ms
(6.84%)
4
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:
[
  4
]
0.66 ms
(6.55%)
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
]
0.60 ms
(5.93%)
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
]
0.60 ms
(5.92%)
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"
]
0.24 ms
(2.38%)
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.23 ms
(2.28%)
1
SELECT t0.id AS id_1, t0.has_builder_entities AS has_builder_entities_2 FROM builder_options t0
Parameters:
[]
0.22 ms
(2.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:
[]
0.16 ms
(1.55%)
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
]

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\CoreBundle\Entity\MenuItem 15
Akyos\CoreBundle\Entity\Option 6
Akyos\CoreBundle\Entity\Page 5
Akyos\FileManagerBundle\Entity\File 3
Akyos\CoreBundle\Entity\MenuArea 3
Akyos\CoreBundle\Entity\Menu 3
Akyos\CoreBundle\Entity\OptionCategory 2
Akyos\BuilderBundle\Entity\BuilderOptions 1
Akyos\CoreBundle\Entity\CoreOptions 1
Akyos\CoreBundle\Entity\RgpdOptions 1

Entities Mapping

Class Mapping errors
Akyos\BuilderBundle\Entity\BuilderOptions No errors.
Akyos\CoreBundle\Entity\CoreOptions No errors.
Akyos\CoreBundle\Entity\Page 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\Component No errors.
Akyos\BuilderBundle\Entity\ComponentField No errors.
Akyos\BuilderBundle\Entity\ComponentTemplate No errors.
Akyos\BuilderBundle\Entity\ComponentValue 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\Seo 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.