GET https://www.fus.ac-dev.fr/avis/?page=5

Query Metrics

166 Database Queries
17 Different statements
77.06 ms Query time
2 Invalid entities
406 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
28.33 ms
(36.77%)
59
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:
[
  2710
]
27.56 ms
(35.77%)
60
SELECT t0.ref AS ref_1, t0.message AS message_2, t0.is_payment_in_shop AS is_payment_in_shop_3, t0.is_shop_order AS is_shop_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.tracking_number AS tracking_number_8, t0.carrier_url AS carrier_url_9, t0.discount_token AS discount_token_10, t0.had_discount AS had_discount_11, t0.discount_creation_date AS discount_creation_date_12, t0.payment_id AS payment_id_13, t0.client_id AS client_id_14, t0.shipping_mode_id AS shipping_mode_id_15, t0.treatment_delay_id AS treatment_delay_id_16, t0.order_status_id AS order_status_id_17, t0.invoice_address_id AS invoice_address_id_18, t0.delivery_address_id AS delivery_address_id_19, t0.cart_id AS cart_id_20, t0.discount_id AS discount_id_21, t0.review_id AS review_id_22 FROM `order` t0 WHERE t0.review_id = ?
Parameters:
[
  154
]
6.08 ms
(7.89%)
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.78 ms
(2.31%)
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"
]
1.75 ms
(2.27%)
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.67 ms
(2.16%)
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
]
1.64 ms
(2.13%)
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.25 ms
(1.62%)
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.19 ms
(1.54%)
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.17 ms
(1.51%)
1
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.published = 1
Parameters:
[]
1.03 ms
(1.34%)
1
SELECT r0_.id AS id_0, r0_.grade AS grade_1, r0_.comment AS comment_2, r0_.published AS published_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5 FROM review r0_ WHERE r0_.published = 1 AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.created_at DESC
Parameters:
[
  154
  153
  152
  151
  150
  149
  148
  147
  146
  145
  144
  143
  142
  141
  139
  138
  137
  136
  135
  134
  133
  132
  131
  130
  129
  128
  127
  126
  125
  124
  123
  122
  121
  120
  119
  118
  117
  116
  115
  114
  113
  112
  111
  110
  109
  108
  107
  106
  105
  104
  103
  102
  101
  100
  99
  98
  97
  96
  95
  94
]
1.02 ms
(1.32%)
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:
[]
0.74 ms
(0.97%)
1
SELECT DISTINCT r0_.id AS id_0, r0_.created_at AS created_at_1 FROM review r0_ WHERE r0_.published = 1 ORDER BY r0_.created_at DESC LIMIT 60 OFFSET 240
Parameters:
[]
0.70 ms
(0.91%)
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.52 ms
(0.67%)
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.38 ms
(0.49%)
1
SELECT t0.id AS id_1, t0.has_builder_entities AS has_builder_entities_2 FROM builder_options t0
Parameters:
[]
0.26 ms
(0.34%)
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
App\Entity\Review\Review 60
App\Entity\Shop\Order 60
Akyos\ShopBundle\Entity\Payment 60
Akyos\ShopBundle\Entity\ShopAddress 60
Akyos\ShopBundle\Entity\Cart 60
Akyos\ShopBundle\Entity\BaseUserShop 59
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\ShopBundle\Entity\ShippingMode 2
Akyos\ShopBundle\Entity\TreatmentDelay 2
Akyos\ShopBundle\Entity\Discount 2
Akyos\CoreBundle\Entity\OptionCategory 2
Akyos\ShopBundle\Entity\OrderStatus 1
Akyos\BuilderBundle\Entity\BuilderOptions 1
Akyos\CoreBundle\Entity\CoreOptions 1
Akyos\CoreBundle\Entity\RgpdOptions 1

Entities Mapping

Class Mapping 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.
Akyos\ShopBundle\Entity\Payment No errors.
Akyos\CoreBundle\Entity\BaseUser No errors.
Akyos\ShopBundle\Entity\BaseUserShop No errors.
Akyos\ShopBundle\Entity\ShippingMode No errors.
Akyos\ShopBundle\Entity\TreatmentDelay 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\ShopAddress No errors.
Akyos\ShopBundle\Entity\Cart No errors.
Akyos\ShopBundle\Entity\Discount No errors.
Akyos\ShopBundle\Entity\OrderStatusLog No 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\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\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\PaymentType No errors.
Akyos\ShopBundle\Entity\ShopOptions No errors.
Akyos\ShopBundle\Entity\OrderMail No errors.
Akyos\ShopBundle\Entity\CartItem No errors.