Query Metrics
33
Database Queries
19
Different statements
190.88 ms
Query time
0
Invalid entities
111
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.49 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"shop_status"
]
|
| 2 | 7.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.label AS label_4, t0.available AS available_5, t0.slug AS slug_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sku AS sku_10, t0.short_description AS short_description_11, t0.stock AS stock_12, t0.delivery_time AS delivery_time_13, t0.weight AS weight_14, t0.length AS length_15, t0.width AS width_16, t0.height AS height_17, t0.manufacturer AS manufacturer_18, t0.ean AS ean_19, t0.is_active AS is_active_20, t0.special_price AS special_price_21, t0.uvp AS uvp_22, t0.tags AS tags_23, t0.video_url AS video_url_24, t0.material AS material_25, t0.country_of_origin AS country_of_origin_26, t0.custom1 AS custom1_27, t0.custom2 AS custom2_28, t0.mwst AS mwst_29, t0.versandkosten AS versandkosten_30, t0.pickup_available AS pickup_available_31, t0.pickup_only AS pickup_only_32, t0.pickup_note AS pickup_note_33, t0.category_id AS category_id_34, t0.seo_meta_id AS seo_meta_id_35, t0.shipping_method_id AS shipping_method_id_36 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"chieftec-ct-01b-350gpb"
]
|
| 3 | 3.66 ms |
SELECT t0.id AS id_1, t0.base_product_id AS base_product_id_2 FROM product_configurator t0 WHERE t0.base_product_id = ? LIMIT 1
Parameters:
[
3568
]
|
| 4 | 0.64 ms |
SELECT t0.id AS id_1, t0.product_id AS product_id_2 FROM configurable_product t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
3568
]
|
| 5 | 2.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0
Parameters:
[] |
| 6 | 0.68 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.scope AS scope_6 FROM system_setting t0 WHERE t0.settings_key = ? LIMIT 1
Parameters:
[
"shop_menu_config"
]
|
| 7 | 5.44 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC
Parameters:
[] |
| 8 | 4.74 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC
Parameters:
[
"main"
]
|
| 9 | 6.02 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC
Parameters:
[
"legal"
]
|
| 10 | 5.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placeholder AS placeholder_3, t0.template_content AS template_content_4 FROM widget t0
Parameters:
[] |
| 11 | 35.81 ms |
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
Parameters:
[ "en" "messages" ] |
| 12 | 39.93 ms |
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
Parameters:
[ "de" "messages" ] |
| 13 | 0.78 ms |
SELECT p0_.id AS id_0, p0_.author_name AS author_name_1, p0_.author_email AS author_email_2, p0_.question AS question_3, p0_.answer AS answer_4, p0_.status AS status_5, p0_.created_at AS created_at_6, p0_.answered_at AS answered_at_7, p0_.product_id AS product_id_8 FROM product_question p0_ WHERE p0_.product_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 20
Parameters:
[ 3568 "answered" ] |
| 14 | 0.86 ms |
SELECT p0_.id AS id_0, p0_.author_name AS author_name_1, p0_.author_email AS author_email_2, p0_.title AS title_3, p0_.body AS body_4, p0_.rating AS rating_5, p0_.status AS status_6, p0_.verified_purchase AS verified_purchase_7, p0_.featured AS featured_8, p0_.ip_address AS ip_address_9, p0_.admin_note AS admin_note_10, p0_.created_at AS created_at_11, p0_.moderated_at AS moderated_at_12, p0_.product_id AS product_id_13, p0_.customer_id AS customer_id_14 FROM product_review p0_ WHERE p0_.product_id = ? AND p0_.status = ? ORDER BY p0_.created_at DESC LIMIT 30
Parameters:
[ 3568 "approved" ] |
| 15 | 4.50 ms |
SELECT AVG(p0_.rating) AS sclr_0 FROM product_review p0_ WHERE p0_.product_id = ? AND p0_.status = ?
Parameters:
[ 3568 "approved" ] |
| 16 | 3.53 ms |
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
Parameters:
[ "en" "frontend_shop" ] |
| 17 | 5.77 ms |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.meta_keywords AS meta_keywords_4, t0.og_title AS og_title_5, t0.og_description AS og_description_6, t0.og_image AS og_image_7, t0.canonical AS canonical_8, t0.next AS next_9, t0.meta_robots AS meta_robots_10, t0.og_locale AS og_locale_11, t0.og_type AS og_type_12, t0.og_url AS og_url_13, t0.og_site_name AS og_site_name_14, t0.article_modified_time AS article_modified_time_15 FROM seo_meta t0 WHERE t0.id = ?
Parameters:
[
10064
]
|
| 18 | 6.67 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"shop_currency"
]
|
| 19 | 0.59 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? AND s0_.scope = ?
Parameters:
[ "cart_session_lifetime" "frontend" ] |
| 20 | 10.40 ms |
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1
Parameters:
[ "mq5lkuegpbbk8om2df5eem7tk0" "open" ] |
| 21 | 3.12 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"sitename"
]
|
| 22 | 7.97 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"siteslogan"
]
|
| 23 | 1.65 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"shop_phone"
]
|
| 24 | 6.60 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"site_email"
]
|
| 25 | 0.85 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"site_opening_hours"
]
|
| 26 | 0.33 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"site_city"
]
|
| 27 | 3.46 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"site_top_location"
]
|
| 28 | 0.31 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"site_opening_hours_header"
]
|
| 29 | 1.66 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"shop_logo"
]
|
| 30 | 5.97 ms |
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1
Parameters:
[ "mq5lkuegpbbk8om2df5eem7tk0" "open" ] |
| 31 | 4.43 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3568
]
|
| 32 | 2.40 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3568
]
|
| 33 | 5.65 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3568
]
|
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\SeoMeta | 40 |
| App\Entity\Category | 33 |
| App\Entity\Widget | 18 |
| App\Entity\Page | 10 |
| App\Entity\SystemSetting | 8 |
| App\Entity\Product | 1 |
| App\Entity\ProductImage | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SystemSetting | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\SeoMeta | No errors. |
| App\Entity\ShippingMethod | No errors. |
| App\Entity\ProductImage | No errors. |
| App\Entity\ProductConfigurator | No errors. |
| App\Entity\ConfigurableProduct | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Widget | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\ProductQuestion | No errors. |
| App\Entity\ProductReview | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Coupon | No errors. |