Query Metrics
10
Database Queries
7
Different statements
11.93 ms
Query time
7
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.19 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.shipping_status AS shipping_status_2, t0.payment_status AS payment_status_3, t0.total_price AS total_price_4, t0.sale_supply_id AS sale_supply_id_5, t0.sale_supply_main_status AS sale_supply_main_status_6, t0.sale_supply_shipment_status AS sale_supply_shipment_status_7, t0.sale_supply_tracking_code AS sale_supply_tracking_code_8, t0.sale_supply_carrier_name AS sale_supply_carrier_name_9, t0.terms_and_conditions AS terms_and_conditions_10, t0.payment_id AS payment_id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.status AS status_14, t0.payment_method AS payment_method_15, t0.user_snapshot AS user_snapshot_16, t0.paid_at AS paid_at_17, t0.shipping_cost AS shipping_cost_18, t0.amount_vat AS amount_vat_19, t0.currency AS currency_20, t0.charge_psp AS charge_psp_21, t0.charge_shipping AS charge_shipping_22, t0.tracking_params AS tracking_params_23, t0.postback_url_date AS postback_url_date_24, t0.tracking_commission AS tracking_commission_25, t0.total_price_ex AS total_price_ex_26, t0.comment AS comment_27, t0.order_number AS order_number_28, t0.count_by_user AS count_by_user_29, t0.charge_pick_and_pack AS charge_pick_and_pack_30, t0.sale_supply_tracking_url AS sale_supply_tracking_url_31, t0.event_id AS event_id_32, t0.event_additional_params AS event_additional_params_33, t0.total_price_to_eur AS total_price_to_eur_34, t0.total_price_ex_to_eur AS total_price_ex_to_eur_35, t0.shipping_cost_to_eur AS shipping_cost_to_eur_36, t0.type AS type_37, t0.product_cost AS product_cost_38, t0.product_cost_to_eur AS product_cost_to_eur_39, t0.return_cost AS return_cost_40, t0.return_cost_to_eur AS return_cost_to_eur_41, t0.is_voucher AS is_voucher_42, t0.is_first_order AS is_first_order_43, t0.ip AS ip_44, t0.payment_provider_id AS payment_provider_id_45, t0.shipping_provider_id AS shipping_provider_id_46, t0.end_user_id AS end_user_id_47, t48.id AS id_49, t48.first_name AS first_name_50, t48.last_name AS last_name_51, t48.email AS email_52, t48.address AS address_53, t48.apartment AS apartment_54, t48.zip AS zip_55, t48.city AS city_56, t48.active AS active_57, t48.locale AS locale_58, t48.subscribed AS subscribed_59, t48.phone_number AS phone_number_60, t48.otp_token AS otp_token_61, t48.remember_token AS remember_token_62, t48.updated_at AS updated_at_63, t48.otp_expired_at AS otp_expired_at_64, t48.mollie_customer_id AS mollie_customer_id_65, t48.klarna_token_id AS klarna_token_id_66, t48.street_name AS street_name_67, t48.house_number AS house_number_68, t48.country_id AS country_id_69, t0.domain_id AS domain_id_70, t0.domain_vat_id AS domain_vat_id_71, t0.country_id AS country_id_72, t0.tracker_id AS tracker_id_73, t74.id AS id_75, t74.name AS name_76, t74.email_address AS email_address_77, t74.postback_url AS postback_url_78, t74.get_variables AS get_variables_79, t74.post_variables AS post_variables_80, t74.event_providers AS event_providers_81, t74.facebook_test_event_code AS facebook_test_event_code_82, t74.facebook_pixel_id AS facebook_pixel_id_83, t74.facebook_access_token AS facebook_access_token_84, t74.facebook_dedicated_pixel AS facebook_dedicated_pixel_85, t74.thank_you_page_custom_code AS thank_you_page_custom_code_86, t74.use_margin AS use_margin_87, t74.domain_id AS domain_id_88, t0.parent_id AS parent_id_89, t90.id AS id_91, t90.status AS status_92, t90.frequency AS frequency_93, t90.period AS period_94, t90.total_price AS total_price_95, t90.shipping_cost AS shipping_cost_96, t90.currency AS currency_97, t90.created_at AS created_at_98, t90.updated_at AS updated_at_99, t90.external_subscription_id AS external_subscription_id_100, t90.rebill_owner AS rebill_owner_101, t90.last_charge_at AS last_charge_at_102, t90.next_charge_at AS next_charge_at_103, t90.deactivation_at AS deactivation_at_104, t90.trial_period AS trial_period_105, t90.is_internal_charge AS is_internal_charge_106, t90.order_id AS order_id_107, t90.end_user_id AS end_user_id_108, t109.id AS id_110, t109.created_at AS created_at_111, t109.sent AS sent_112, t109.sent_at AS sent_at_113, t109.submission_date AS submission_date_114, t109.canceled AS canceled_115, t109.order_id AS order_id_116, t0.first_product_id AS first_product_id_117, t0.warehouse_id AS warehouse_id_118, t119.id AS id_120, t119.external_id AS external_id_121, t119.status AS status_122, t119.shipment_status AS shipment_status_123, t119.carrier_name AS carrier_name_124, t119.tracking_code AS tracking_code_125, t119.tracking_url AS tracking_url_126, t119.created_at AS created_at_127, t119.updated_at AS updated_at_128, t119.order_id AS order_id_129, t130.id AS id_131, t130.shipping_cost AS shipping_cost_132, t130.charge_psp AS charge_psp_133, t130.charge_shipping AS charge_shipping_134, t130.charge_pick_and_pack AS charge_pick_and_pack_135, t130.shipping_cost_to_eur AS shipping_cost_to_eur_136, t130.product_cost AS product_cost_137, t130.product_cost_to_eur AS product_cost_to_eur_138, t130.return_cost AS return_cost_139, t130.return_cost_to_eur AS return_cost_to_eur_140, t130.order_id AS order_id_141, t0.funnel_id AS funnel_id_142, t143.id AS id_144, t143.name AS name_145, t143.created_at AS created_at_146, t143.checkout_btn_selector AS checkout_btn_selector_147, t143.user_id AS user_id_148, t143.tracker_id AS tracker_id_149, t143.domain_id AS domain_id_150 FROM orders t0 LEFT JOIN end_user t48 ON t0.end_user_id = t48.id LEFT JOIN tracker t74 ON t0.tracker_id = t74.id LEFT JOIN order_subscription t90 ON t90.order_id = t0.id LEFT JOIN order_holder t109 ON t109.order_id = t0.id LEFT JOIN order_warehouse_detail t119 ON t119.order_id = t0.id LEFT JOIN order_calculated_data t130 ON t130.order_id = t0.id LEFT JOIN funnel t143 ON t0.funnel_id = t143.id WHERE t0.id = ?
Parameters:
[
"9697"
]
|
|
2.95 ms (0.00%) |
4 |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1" "nl" "App\Entity\Product" ] |
|
1.53 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.cms_title AS cms_title_3, t0.title AS title_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.usp_info AS usp_info_7, t0.usp_days_to_return AS usp_days_to_return_8, t0.usp_shipping AS usp_shipping_9, t0.ean_code AS ean_code_10, t0.sku AS sku_11, t0.in_stock AS in_stock_12, t0.weight AS weight_13, t0.product_cost AS product_cost_14, t0.url_title AS url_title_15, t0.hs_code AS hs_code_16, t0.return_rate AS return_rate_17, t0.default_currency AS default_currency_18, t0.recommend_retail_price AS recommend_retail_price_19, t0.active_languages AS active_languages_20, t0.active AS active_21, t0.main_product AS main_product_22, t0.thanks_page AS thanks_page_23, t0.description AS description_24, t0.shipping_cost AS shipping_cost_25, t0.min_free_shipping_value AS min_free_shipping_value_26, t0.error_page AS error_page_27, t0.conversion_realtime AS conversion_realtime_28, t0.recently_purchased_popup AS recently_purchased_popup_29, t0.reserved_time AS reserved_time_30, t0.number_bought_product AS number_bought_product_31, t0.number_customers_online AS number_customers_online_32, t0.max_quantity AS max_quantity_33, t0.subscription_mandate AS subscription_mandate_34, t0.auto_cart_add AS auto_cart_add_35, t0.is_checkout_warehouse_enabled AS is_checkout_warehouse_enabled_36, t0.free_shipping_progress_bar AS free_shipping_progress_bar_37, t0.push_to_higher_variant AS push_to_higher_variant_38, t0.active_upsell_checkout_page AS active_upsell_checkout_page_39, t0.upsell_page_discount_percentage AS upsell_page_discount_percentage_40, t0.upsell_page_progress_timer AS upsell_page_progress_timer_41, t0.upsell_page_description AS upsell_page_description_42, t0.upsell_page_desc_for_new_customers AS upsell_page_desc_for_new_customers_43, t0.product_type_id AS product_type_id_44, t0.product_detail_id AS product_detail_id_45, t46.id AS id_47, t46.image_path AS image_path_48, t46.title AS title_49, t46.description AS description_50, t46.brand AS brand_51, t46.ean_code AS ean_code_52, t46.sku AS sku_53, t46.hs_code AS hs_code_54, t46.product_cost AS product_cost_55, t46.return_rate AS return_rate_56, t46.recommend_retail_price AS recommend_retail_price_57, t46.weight AS weight_58, t46.out_of_stock AS out_of_stock_59, t46.voucher AS voucher_60, t46.expected_date AS expected_date_61, t46.type_id AS type_id_62, t46.customer_id AS customer_id_63, t64.id AS id_65, t64.template_type AS template_type_66, t64.primary_color AS primary_color_67, t64.secondary_color AS secondary_color_68, t64.primary_bg_color AS primary_bg_color_69, t64.browser_tab_color AS browser_tab_color_70, t64.is_single_page AS is_single_page_71, t64.product_id AS product_id_72, t0.warehouse_id AS warehouse_id_73 FROM product t0 LEFT JOIN product_detail t46 ON t0.product_detail_id = t46.id LEFT JOIN checkout_configuration t64 ON t64.product_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.33 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.languages AS languages_4, t0.active AS active_5, t0.currency_position AS currency_position_6, t0.country_code AS country_code_7, t0.currency_id AS currency_id_8, t0.warehouse_id AS warehouse_id_9 FROM country t0 WHERE t0.id IN (?)
Parameters:
[
[
11
]
]
|
|
1.23 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.homepage AS homepage_4, t0.logo AS logo_5, t0.favicon AS favicon_6, t0.company_name AS company_name_7, t0.address AS address_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.phone AS phone_11, t0.registration_nr AS registration_nr_12, t0.email AS email_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.terms_and_conditions_page AS terms_and_conditions_page_16, t0.privacy_policy_page AS privacy_policy_page_17, t0.active AS active_18, t0.instagram_url AS instagram_url_19, t0.facebook_url AS facebook_url_20, t0.facebook_pixel_id AS facebook_pixel_id_21, t0.facebook_access_token AS facebook_access_token_22, t0.test_event_code AS test_event_code_23, t0.sale_supply_shop_id AS sale_supply_shop_id_24, t0.changed_url AS changed_url_25, t0.changed_translation AS changed_translation_26, t0.google_tag_manager_code AS google_tag_manager_code_27, t0.klaviyo_api_key AS klaviyo_api_key_28, t0.klaviyo_list_id AS klaviyo_list_id_29, t0.google_api_secret AS google_api_secret_30, t0.google_tag_code AS google_tag_code_31, t0.default_event_providers AS default_event_providers_32, t0.customer_id AS customer_id_33, t0.active_email_provider_id AS active_email_provider_id_34, t35.id AS id_36, t35.account_id AS account_id_37, t35.conversion_token AS conversion_token_38, t35.pinterest_tag AS pinterest_tag_39, t35.domain_id AS domain_id_40, t41.id AS id_42, t41.pixel_code AS pixel_code_43, t41.access_token AS access_token_44, t41.test_event_code AS test_event_code_45, t41.domain_id AS domain_id_46, t0.country_id AS country_id_47 FROM domain t0 LEFT JOIN pinterest_event_provider t35 ON t35.domain_id = t0.id LEFT JOIN tik_tok_event_provider t41 ON t41.domain_id = t0.id WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.89 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.homepage AS homepage_4, t0.logo AS logo_5, t0.favicon AS favicon_6, t0.company_name AS company_name_7, t0.address AS address_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.phone AS phone_11, t0.registration_nr AS registration_nr_12, t0.email AS email_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.terms_and_conditions_page AS terms_and_conditions_page_16, t0.privacy_policy_page AS privacy_policy_page_17, t0.active AS active_18, t0.instagram_url AS instagram_url_19, t0.facebook_url AS facebook_url_20, t0.facebook_pixel_id AS facebook_pixel_id_21, t0.facebook_access_token AS facebook_access_token_22, t0.test_event_code AS test_event_code_23, t0.sale_supply_shop_id AS sale_supply_shop_id_24, t0.changed_url AS changed_url_25, t0.changed_translation AS changed_translation_26, t0.google_tag_manager_code AS google_tag_manager_code_27, t0.klaviyo_api_key AS klaviyo_api_key_28, t0.klaviyo_list_id AS klaviyo_list_id_29, t0.google_api_secret AS google_api_secret_30, t0.google_tag_code AS google_tag_code_31, t0.default_event_providers AS default_event_providers_32, t0.customer_id AS customer_id_33, t0.active_email_provider_id AS active_email_provider_id_34, t35.id AS id_36, t35.account_id AS account_id_37, t35.conversion_token AS conversion_token_38, t35.pinterest_tag AS pinterest_tag_39, t35.domain_id AS domain_id_40, t41.id AS id_42, t41.pixel_code AS pixel_code_43, t41.access_token AS access_token_44, t41.test_event_code AS test_event_code_45, t41.domain_id AS domain_id_46, t0.country_id AS country_id_47 FROM domain t0 LEFT JOIN pinterest_event_provider t35 ON t35.domain_id = t0.id LEFT JOIN tik_tok_event_provider t41 ON t41.domain_id = t0.id WHERE t0.active = ?
Parameters:
[
1
]
|
|
0.83 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.currency AS currency_2, t0.amount AS amount_3, t0.is_activated AS is_activated_4, t0.activated_at AS activated_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.end_user_id AS end_user_id_8, t0.order_id AS order_id_9 FROM end_user_vouchers t0 WHERE t0.order_id IN (?)
Parameters:
[
[
9697
]
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Order |
|
| App\Entity\PaymentProvider | No errors. |
| App\Entity\ShippingProvider | No errors. |
| App\Entity\EndUser | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Domain | No errors. |
| App\Entity\DomainVat | No errors. |
| App\Entity\Tracker | No errors. |
| App\Entity\OrderSubscription |
|
| App\Entity\OrderHolder | No errors. |
| App\Entity\Product |
|
| App\Entity\Warehouse | No errors. |
| App\Entity\OrderWarehouseDetail | No errors. |
| App\Entity\OrderCalculatedData | No errors. |
| App\Entity\Funnel |
|
| App\Entity\User |
|
| App\Entity\OrderProduct | No errors. |
| App\Entity\EndUserVoucher |
|
| App\Entity\OrderRefund | No errors. |
| App\Entity\Currency | No errors. |
| App\Entity\ProductType | No errors. |
| App\Entity\ProductDetail |
|
| App\Entity\CheckoutConfiguration | No errors. |
| App\Entity\FAQ | No errors. |
| App\Entity\ProductVariant | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\ProductUpsell | No errors. |
| App\Entity\ProductPostUpsell | No errors. |
| App\Entity\ProductTracker | No errors. |
| App\Entity\ProductImages | No errors. |
| App\Entity\MarketingCost | No errors. |
| App\Entity\FunnelVisitor | No errors. |
| App\Entity\ProductStock | No errors. |
| App\Entity\ProductStockTransaction | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| App\Entity\DomainEmailProvider | No errors. |
| App\Entity\PinterestEventProvider | No errors. |
| App\Entity\TikTokEventProvider | No errors. |
| App\Entity\DomainPaymentProvider | No errors. |