Query Metrics
166
Database Queries
17
Different statements
68.54 ms
Query time
2
Invalid entities
404
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
30.29 ms (44.19%) |
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:
[
1999
]
|
|
27.77 ms (40.52%) |
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:
[
93
]
|
|
2.87 ms (4.19%) |
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
]
|
|
0.96 ms (1.39%) |
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:
[ 93 92 91 90 89 88 87 86 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 ] |
|
0.89 ms (1.30%) |
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.77 ms (1.13%) |
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 300
Parameters:
[] |
|
0.77 ms (1.12%) |
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 (1.01%) |
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.93%) |
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.63 ms (0.92%) |
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.52 ms (0.76%) |
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.49 ms (0.72%) |
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.31 ms (0.45%) |
1 |
SELECT t0.id AS id_1, t0.has_builder_entities AS has_builder_entities_2 FROM builder_options t0
Parameters:
[] |
|
0.27 ms (0.40%) |
1 |
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.published = 1
Parameters:
[] |
|
0.27 ms (0.39%) |
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.32%) |
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.18 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
]
|
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\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 |