Query Metrics
167
Database Queries
17
Different statements
81.24 ms
Query time
2
Invalid entities
405
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
40.02 ms (49.27%) |
60 |
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:
[
7882
]
|
|
30.01 ms (36.94%) |
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:
[
351
]
|
|
2.71 ms (3.34%) |
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.23 ms (1.52%) |
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:
[ 351 350 349 347 346 338 336 334 330 329 328 327 326 325 324 323 322 321 320 319 318 317 316 315 314 313 312 311 310 309 308 307 306 305 304 303 302 301 300 299 298 297 296 295 294 293 292 291 290 289 288 287 286 285 284 283 282 281 280 279 ] |
|
0.94 ms (1.16%) |
1 |
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.published = 1
Parameters:
[] |
|
0.89 ms (1.10%) |
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.75 ms (0.92%) |
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 60
Parameters:
[] |
|
0.74 ms (0.91%) |
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.64 ms (0.79%) |
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.63 ms (0.77%) |
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.56 ms (0.69%) |
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.52 ms (0.64%) |
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.48 ms (0.59%) |
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.43 ms (0.53%) |
1 |
SELECT t0.id AS id_1, t0.has_builder_entities AS has_builder_entities_2 FROM builder_options t0
Parameters:
[] |
|
0.25 ms (0.30%) |
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.22 ms (0.27%) |
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.21 ms (0.26%) |
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\BaseUserShop | 60 |
| Akyos\ShopBundle\Entity\ShopAddress | 60 |
| Akyos\ShopBundle\Entity\Cart | 60 |
| 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\TreatmentDelay | 2 |
| Akyos\CoreBundle\Entity\OptionCategory | 2 |
| Akyos\ShopBundle\Entity\ShippingMode | 1 |
| Akyos\ShopBundle\Entity\OrderStatus | 1 |
| Akyos\ShopBundle\Entity\Discount | 1 |
| Akyos\BuilderBundle\Entity\BuilderOptions | 1 |
| Akyos\CoreBundle\Entity\CoreOptions | 1 |
| Akyos\CoreBundle\Entity\RgpdOptions | 1 |