Query Metrics
14
Database Queries
7
Different statements
11.02 ms
Query time
8
Invalid entities
15
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.83 ms |
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.61 ms |
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.54 ms |
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.43 ms |
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.52 ms |
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.43 ms |
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 7 | 2.21 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:
[
""
"active"
]
|
||||||||||||||||||||||||||||||||
| 8 | 0.91 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:
[
""
"active"
]
|
||||||||||||||||||||||||||||||||
| 9 | 1.53 ms |
SELECT s0_.id AS id_0, s0_.range_from AS range_from_1, s0_.range_to AS range_to_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.price_amount AS price_amount_5, s0_.price_currency AS price_currency_6, s0_.shipping_method_id AS shipping_method_id_7, s0_.country_id AS country_id_8 FROM shipping_method_fee s0_ INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id WHERE (((s1_.fee_based_on = ? AND s0_.range_from <= ? AND s0_.range_to > ?) OR (s1_.fee_based_on = ? AND s0_.range_from <= ? AND s0_.range_to > ?)) OR (s1_.behaviour_outside_fee_range = ? AND (NOT EXISTS (SELECT 1 AS sclr_9 FROM shipping_method_fee s2_ INNER JOIN shipping_method s3_ ON s2_.shipping_method_id = s3_.id WHERE s3_.id = s1_.id AND ((s3_.fee_based_on = ? AND s2_.range_from <= ? AND s2_.range_to > ?) OR (s3_.fee_based_on = ? AND s2_.range_from <= ? AND s2_.range_to > ?)))) AND s0_.price_amount = (SELECT MAX(s4_.price_amount) AS sclr_10 FROM shipping_method_fee s5_, shipping_method_fee s4_ WHERE s4_.shipping_method_id = s1_.id))) AND s1_.is_active = true AND s1_.carrier IS NOT NULL ORDER BY s0_.price_amount ASC LIMIT 1
Parameters:
[ "price" 0.0 0.0 "weight" 0 0 "highest_price" "price" 0.0 0.0 "weight" 0 0 ] |
||||||||||||||||||||||||||||||||
| 10 | 0.57 ms |
SELECT s0_.id AS id_0, s0_.range_from AS range_from_1, s0_.range_to AS range_to_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.price_amount AS price_amount_5, s0_.price_currency AS price_currency_6, s0_.shipping_method_id AS shipping_method_id_7, s0_.country_id AS country_id_8 FROM shipping_method_fee s0_ INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id WHERE s1_.is_active = true AND s1_.carrier IS NOT NULL AND s0_.price_amount = 0 AND s0_.range_from IS NOT NULL ORDER BY s0_.range_from ASC LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||||||||||
| 11 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.fee_based_on AS fee_based_on_4, t0.behaviour_outside_fee_range AS behaviour_outside_fee_range_5, t0.carrier AS carrier_6, t0.allow_home_delivery AS allow_home_delivery_7, t0.allow_box_delivery AS allow_box_delivery_8, t0.allow_pickup_point AS allow_pickup_point_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.logo_id AS logo_id_12, t0.tax_rate_id AS tax_rate_id_13, t0.carrier_shipping_option_id AS carrier_shipping_option_id_14 FROM shipping_method t0 WHERE t0.id = ?
Parameters:
[
"9a3917fc-0a87-42c9-a1b7-9b97b867218a"
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.36 ms |
SELECT t0.id AS id_1, t0.rate AS rate_2 FROM tax_rate t0 WHERE t0.id = ?
Parameters:
[
"d4cbf291-83a9-4c10-97a6-39675f525c02"
]
|
||||||||||||||||||||||||||||||||
| 13 | 0.51 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:
[] |
||||||||||||||||||||||||||||||||
| 14 | 0.26 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:
[] |
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\Configuration\Domain\Entity\Currency | 3 |
| App\PageBuilder\Domain\Entity\StaticPage | 3 |
| App\Configuration\Domain\Entity\ExchangeRate | 2 |
| App\Frontoffice\Domain\Entity\Cart | 2 |
| App\Shipping\Domain\Entity\ShippingMethodFee | 1 |
| App\Shipping\Domain\Entity\ShippingMethod | 1 |
| App\Configuration\Domain\Entity\Country | 1 |
| App\File\Domain\Entity\File | 1 |
| App\Accounting\Domain\Entity\TaxRate | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Configuration\Domain\Entity\Configuration | No errors. |
| App\Configuration\Domain\Entity\Currency | No errors. |
| App\Configuration\Domain\Entity\ExchangeRate | No errors. |
| App\Payment\Domain\Entity\PaymentMethodConfiguration |
|
| App\Shipping\Domain\Entity\ShippingMethod |
|
| App\Shared\Domain\Entity\Price | No errors. |
| App\Shipping\Domain\Entity\ShippingMethodFee | 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\Product\Domain\Entity\Product | No errors. |
| App\Customer\Domain\Entity\Customer | No errors. |
| App\Accounting\Domain\Entity\TaxRate | No errors. |
| App\Product\Domain\Entity\Category | No errors. |
| App\Configuration\Domain\Entity\Country | No errors. |
| App\File\Domain\Entity\File | No errors. |
| App\Shipping\Domain\Entity\CarrierShippingOption | No errors. |
| App\Order\Domain\Entity\Order |
|
| App\PageBuilder\Domain\Entity\StaticPage | No errors. |
| App\Order\Domain\Entity\OrderStatus |
|
| 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\Payment\Domain\Entity\PaymentMethodBankTransferConfiguration |
|
| App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryConfiguration |
|
| App\Payment\Domain\Entity\PaymentMethodPaymentCardConfiguration |
|
| 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\Variant | No errors. |
| App\Payment\Domain\Entity\PaymentMethodCountryConfiguration | No errors. |
| App\Product\Domain\Entity\VariantValue | No errors. |
| App\Product\Domain\Entity\ProductImage | No errors. |
| App\Product\Domain\Entity\ProductFile | No errors. |
| App\Product\Domain\Entity\ProductParameter | No errors. |
| App\Customer\Domain\Entity\CustomerGroup |
|
| App\Order\Domain\Entity\OrderItem | No errors. |
| App\Order\Domain\Entity\OrderHistory | No errors. |
| App\Email\Domain\Entity\EmailTemplate | No errors. |
| App\Payment\Domain\Entity\PaymentMethodBankTransferCurrencyConfiguration | No errors. |
| App\Payment\Domain\Entity\PaymentMethodCashOnDeliveryCountryConfiguration | No errors. |
| App\Product\Domain\Entity\ParameterValue | No errors. |