Query Metrics
9
Database Queries
6
Different statements
9.71 ms
Query time
7
Invalid entities
12
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3.34 ms |
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.name AS name_40, p3_.description AS description_41, p3_.short_description AS short_description_42, p3_.code AS code_43, p3_.ean AS ean_44, p3_.unit AS unit_45, p3_.active AS active_46, p3_.can_be_bought AS can_be_bought_47, p3_.in_stock_text AS in_stock_text_48, p3_.out_of_stock_text AS out_of_stock_text_49, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50, p3_.filter_variant_value_ids AS filter_variant_value_ids_51, p3_.seo_title AS seo_title_52, p3_.seo_description AS seo_description_53, p3_.seo_url AS seo_url_54, p3_.stock_stock AS stock_stock_55, p3_.stock_reserved AS stock_reserved_56, p3_.logistic_weight AS logistic_weight_57, p3_.logistic_size_width AS logistic_size_width_58, p3_.logistic_size_height AS logistic_size_height_59, p3_.logistic_size_length AS logistic_size_length_60, p3_.price_amount AS price_amount_61, p3_.price_currency AS price_currency_62, p3_.purchase_price_amount AS purchase_price_amount_63, p3_.purchase_price_currency AS purchase_price_currency_64, c0_.customer_id AS customer_id_65, c0_.shipping_method_id AS shipping_method_id_66, c1_.cart_id AS cart_id_67, c1_.product_variant_id AS product_variant_id_68, p2_.product_id AS product_id_69, p3_.vat_id AS vat_id_70, p3_.main_category_id AS main_category_id_71 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
Parameters:
[ "0ce2942c722a03477bcf532a9831a801" "active" ] |
||||||||||||||||||||||||||||||||
| 2 | 2.54 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.code AS code_4, p0_.ean AS ean_5, p0_.unit AS unit_6, p0_.active AS active_7, p0_.can_be_bought AS can_be_bought_8, p0_.in_stock_text AS in_stock_text_9, p0_.out_of_stock_text AS out_of_stock_text_10, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_11, p0_.filter_variant_value_ids AS filter_variant_value_ids_12, p0_.seo_title AS seo_title_13, p0_.seo_description AS seo_description_14, p0_.seo_url AS seo_url_15, p0_.stock_stock AS stock_stock_16, p0_.stock_reserved AS stock_reserved_17, p0_.logistic_weight AS logistic_weight_18, p0_.logistic_size_width AS logistic_size_width_19, p0_.logistic_size_height AS logistic_size_height_20, p0_.logistic_size_length AS logistic_size_length_21, p0_.price_amount AS price_amount_22, p0_.price_currency AS price_currency_23, p0_.purchase_price_amount AS purchase_price_amount_24, p0_.purchase_price_currency AS purchase_price_currency_25, p1_.id AS id_26, p1_.code AS code_27, p1_.is_default AS is_default_28, p1_.weight_modification AS weight_modification_29, p1_.price_modification_amount AS price_modification_amount_30, p1_.price_modification_currency AS price_modification_currency_31, p1_.stock_stock AS stock_stock_32, p1_.stock_reserved AS stock_reserved_33, v2_.id AS id_34, v2_.name AS name_35, v2_.slug AS slug_36, v2_.color AS color_37, v3_.id AS id_38, v3_.name AS name_39, v3_.slug AS slug_40, v3_.type AS type_41, p4_.id AS id_42, p4_.custom_value AS custom_value_43, p5_.id AS id_44, p5_.name AS name_45, p5_.slug AS slug_46, p6_.id AS id_47, p6_.name AS name_48, p6_.slug AS slug_49, p0_.vat_id AS vat_id_50, p0_.main_category_id AS main_category_id_51, p1_.product_id AS product_id_52, v2_.variant_id AS variant_id_53, p4_.product_id AS product_id_54, p4_.parameter_id AS parameter_id_55, p4_.parameter_value_id AS parameter_value_id_56, p6_.parameter_id AS parameter_id_57 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p7_ ON p1_.id = p7_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p7_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id WHERE p0_.id = ?
Parameters:
[ Symfony\Component\Uid\UuidV6 {#2325 : "7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f" } ] |
||||||||||||||||||||||||||||||||
| 3 | 1.04 ms |
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.name AS name_40, p3_.description AS description_41, p3_.short_description AS short_description_42, p3_.code AS code_43, p3_.ean AS ean_44, p3_.unit AS unit_45, p3_.active AS active_46, p3_.can_be_bought AS can_be_bought_47, p3_.in_stock_text AS in_stock_text_48, p3_.out_of_stock_text AS out_of_stock_text_49, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50, p3_.filter_variant_value_ids AS filter_variant_value_ids_51, p3_.seo_title AS seo_title_52, p3_.seo_description AS seo_description_53, p3_.seo_url AS seo_url_54, p3_.stock_stock AS stock_stock_55, p3_.stock_reserved AS stock_reserved_56, p3_.logistic_weight AS logistic_weight_57, p3_.logistic_size_width AS logistic_size_width_58, p3_.logistic_size_height AS logistic_size_height_59, p3_.logistic_size_length AS logistic_size_length_60, p3_.price_amount AS price_amount_61, p3_.price_currency AS price_currency_62, p3_.purchase_price_amount AS purchase_price_amount_63, p3_.purchase_price_currency AS purchase_price_currency_64, c0_.customer_id AS customer_id_65, c0_.shipping_method_id AS shipping_method_id_66, c1_.cart_id AS cart_id_67, c1_.product_variant_id AS product_variant_id_68, p2_.product_id AS product_id_69, p3_.vat_id AS vat_id_70, p3_.main_category_id AS main_category_id_71 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
Parameters:
[ "0ce2942c722a03477bcf532a9831a801" "active" ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.89 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v1_.id AS id_2, v1_.name AS name_3, v0_.type AS type_4, v1_.color AS color_5, MAX(CASE WHEN (p2_.stock_stock - p2_.stock_reserved) > 0 THEN 1 ELSE 0 END) AS sclr_6 FROM product_variant p2_ INNER JOIN product_variant_variant_value p3_ ON p2_.id = p3_.product_variant_id INNER JOIN variant_value v1_ ON v1_.id = p3_.variant_value_id INNER JOIN variant v0_ ON v1_.variant_id = v0_.id WHERE p2_.product_id = ? GROUP BY v0_.name, v1_.id, v0_.id
Parameters:
[ Symfony\Component\Uid\UuidV6 {#2402 : "7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f" } ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.52 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.show_contact_form AS show_contact_form_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.seo_title AS seo_title_7, s0_.seo_description AS seo_description_8, s0_.seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_.title ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
| 6 | 0.29 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.show_contact_form AS show_contact_form_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.seo_title AS seo_title_7, s0_.seo_description AS seo_description_8, s0_.seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_.title ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
| 7 | 0.52 ms |
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
"7d3e9f2b-4c8a-6e1d-9f5a-2b7c4e8d1a6f"
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.34 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3 FROM file t0 WHERE t0.id = ?
Parameters:
[
"376adaad-6815-40ae-a0da-1e6a4bf9f07c"
]
|
||||||||||||||||||||||||||||||||
| 9 | 0.23 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3 FROM file t0 WHERE t0.id = ?
Parameters:
[
"b8361e72-2f46-484f-bf31-d196d98872c3"
]
|
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\PageBuilder\Domain\Entity\StaticPage | 3 |
| App\Frontoffice\Domain\Entity\Cart | 2 |
| App\Product\Domain\Entity\ProductImage | 2 |
| App\File\Domain\Entity\File | 2 |
| App\Product\Domain\Entity\Product | 1 |
| App\Accounting\Domain\Entity\TaxRate | 1 |
| App\Product\Domain\Entity\ProductVariant | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Configuration\Domain\Entity\Configuration | No errors. |
| App\Shared\Domain\Entity\Address | No errors. |
| App\Frontoffice\Domain\Entity\Cart | No errors. |
| App\Frontoffice\Domain\Entity\CartItem | No errors. |
| App\Shared\Domain\Entity\NullablePrice | No errors. |
| App\Product\Domain\Entity\Stock | No errors. |
| App\Product\Domain\Entity\ProductVariant | No errors. |
| App\SEO\Domain\Entity\SEO | No errors. |
| App\Logistic\Domain\Entity\Size | No errors. |
| App\Logistic\Domain\Entity\Logistic | No errors. |
| App\Shared\Domain\Entity\Price | No errors. |
| App\Product\Domain\Entity\Product | No errors. |
| App\Customer\Domain\Entity\Customer | No errors. |
| App\Shipping\Domain\Entity\ShippingMethod |
|
| App\Accounting\Domain\Entity\TaxRate | No errors. |
| App\Product\Domain\Entity\Category | No errors. |
| App\Configuration\Domain\Entity\Country | No errors. |
| App\Configuration\Domain\Entity\Currency | No errors. |
| App\Configuration\Domain\Entity\ExchangeRate | No errors. |
| App\Filter\Domain\Entity\FilterConfiguration | No errors. |
| App\Filter\Domain\Entity\ParameterFilterConfiguration | No errors. |
| App\Filter\Domain\Entity\VariantFilterConfiguration | No errors. |
| App\Shipping\Domain\Entity\CarrierConfiguration | No errors. |
| App\Shipping\Domain\Entity\CarrierShippingOption | No errors. |
| App\Shipping\Domain\Entity\ShippingMethodFee | No errors. |
| App\Payment\Domain\Entity\PaymentMethodConfiguration |
|
| App\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration |
|
| App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration |
|
| App\Payment\Domain\Entity\PaymentMethodPaymentCardConfiguration |
|
| App\Order\Domain\Entity\Order |
|
| App\Order\Domain\Entity\OrderStatus |
|
| App\User\Domain\Entity\User | No errors. |
| App\User\Domain\Entity\UserRole | No errors. |
| App\Product\Domain\Entity\Parameter | No errors. |
| App\Product\Domain\Entity\VariantValue | No errors. |
| App\Product\Domain\Entity\Variant | No errors. |
| App\Product\Domain\Entity\ProductParameter | No errors. |
| App\Product\Domain\Entity\ParameterValue | No errors. |
| App\Product\Domain\Entity\ProductImage | No errors. |
| App\Product\Domain\Entity\ProductFile | No errors. |
| App\PageBuilder\Domain\Entity\StaticPage | No errors. |
| App\File\Domain\Entity\File | No errors. |