Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 498
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Workflow
• Payum
• Themes 0
• Twig Hooks
• Configuration

Query Metrics

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1

[
  "deltacore.alwaysdata.net"
  1
]

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'deltacore.alwaysdata.net' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

SELECT COUNT(*) FROM sylius_channel t0

[]

SELECT
  COUNT(*)
FROM
  sylius_channel t0

SELECT COUNT(*) FROM sylius_channel t0;

SELECT t0.id AS id_1, t0.source_namespace AS source_namespace_2, t0.source_entry_no AS source_entry_no_3, t0.dealer_customer_code AS dealer_customer_code_4, t0.article_code AS article_code_5, t0.serial_number AS serial_number_6, t0.registration_number AS registration_number_7, t0.delta_mics_sold_on AS delta_mics_sold_on_8, t0.delta_mics_invoice_number AS delta_mics_invoice_number_9, t0.warranty_starts_on AS warranty_starts_on_10, t0.warranty_ends_on AS warranty_ends_on_11, t0.status AS status_12, t0.warranty_duration_months AS warranty_duration_months_13, t0.warranty_rule_reference AS warranty_rule_reference_14, t0.warranty_rule_version AS warranty_rule_version_15, t0.warranty_decision_source AS warranty_decision_source_16, t0.source_comment AS source_comment_17, t0.initial_owner_source_code AS initial_owner_source_code_18, t0.source_synchronized_at AS source_synchronized_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.selling_dealer_id AS selling_dealer_id_22, t0.product_variant_id AS product_variant_id_23, t0.current_ownership_id AS current_ownership_id_24 FROM delta_vehicle t0 WHERE t0.source_namespace = ? AND t0.source_entry_no = ? LIMIT 1

[
  "BC"
  67341
]

SELECT
  t0.id AS id_1,
  t0.source_namespace AS source_namespace_2,
  t0.source_entry_no AS source_entry_no_3,
  t0.dealer_customer_code AS dealer_customer_code_4,
  t0.article_code AS article_code_5,
  t0.serial_number AS serial_number_6,
  t0.registration_number AS registration_number_7,
  t0.delta_mics_sold_on AS delta_mics_sold_on_8,
  t0.delta_mics_invoice_number AS delta_mics_invoice_number_9,
  t0.warranty_starts_on AS warranty_starts_on_10,
  t0.warranty_ends_on AS warranty_ends_on_11,
  t0.status AS status_12,
  t0.warranty_duration_months AS warranty_duration_months_13,
  t0.warranty_rule_reference AS warranty_rule_reference_14,
  t0.warranty_rule_version AS warranty_rule_version_15,
  t0.warranty_decision_source AS warranty_decision_source_16,
  t0.source_comment AS source_comment_17,
  t0.initial_owner_source_code AS initial_owner_source_code_18,
  t0.source_synchronized_at AS source_synchronized_at_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.selling_dealer_id AS selling_dealer_id_22,
  t0.product_variant_id AS product_variant_id_23,
  t0.current_ownership_id AS current_ownership_id_24
FROM
  delta_vehicle t0
WHERE
  t0.source_namespace = ?
  AND t0.source_entry_no = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.source_namespace AS source_namespace_2, t0.source_entry_no AS source_entry_no_3, t0.dealer_customer_code AS dealer_customer_code_4, t0.article_code AS article_code_5, t0.serial_number AS serial_number_6, t0.registration_number AS registration_number_7, t0.delta_mics_sold_on AS delta_mics_sold_on_8, t0.delta_mics_invoice_number AS delta_mics_invoice_number_9, t0.warranty_starts_on AS warranty_starts_on_10, t0.warranty_ends_on AS warranty_ends_on_11, t0.status AS status_12, t0.warranty_duration_months AS warranty_duration_months_13, t0.warranty_rule_reference AS warranty_rule_reference_14, t0.warranty_rule_version AS warranty_rule_version_15, t0.warranty_decision_source AS warranty_decision_source_16, t0.source_comment AS source_comment_17, t0.initial_owner_source_code AS initial_owner_source_code_18, t0.source_synchronized_at AS source_synchronized_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.selling_dealer_id AS selling_dealer_id_22, t0.product_variant_id AS product_variant_id_23, t0.current_ownership_id AS current_ownership_id_24 FROM delta_vehicle t0 WHERE t0.source_namespace = 'BC' AND t0.source_entry_no = 67341 LIMIT 1;

SELECT t0.id AS id_1, t0.source_owner_code AS source_owner_code_2, t0.provenance AS provenance_3, t0.last_name AS last_name_4, t0.first_name AS first_name_5, t0.address_line_1 AS address_line_1_6, t0.address_line_2 AS address_line_2_7, t0.city AS city_8, t0.postal_code AS postal_code_9, t0.country_code AS country_code_10, t0.email AS email_11, t0.phone_number AS phone_number_12, t0.started_at AS started_at_13, t0.ended_at AS ended_at_14, t0.recorded_at AS recorded_at_15, t0.updated_at AS updated_at_16, t0.vehicle_id AS vehicle_id_17 FROM delta_vehicle_ownership t0 WHERE t0.vehicle_id = ? ORDER BY t0.started_at ASC, t0.id ASC

[
  5
]

SELECT
  t0.id AS id_1,
  t0.source_owner_code AS source_owner_code_2,
  t0.provenance AS provenance_3,
  t0.last_name AS last_name_4,
  t0.first_name AS first_name_5,
  t0.address_line_1 AS address_line_1_6,
  t0.address_line_2 AS address_line_2_7,
  t0.city AS city_8,
  t0.postal_code AS postal_code_9,
  t0.country_code AS country_code_10,
  t0.email AS email_11,
  t0.phone_number AS phone_number_12,
  t0.started_at AS started_at_13,
  t0.ended_at AS ended_at_14,
  t0.recorded_at AS recorded_at_15,
  t0.updated_at AS updated_at_16,
  t0.vehicle_id AS vehicle_id_17
FROM
  delta_vehicle_ownership t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.started_at ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.source_owner_code AS source_owner_code_2, t0.provenance AS provenance_3, t0.last_name AS last_name_4, t0.first_name AS first_name_5, t0.address_line_1 AS address_line_1_6, t0.address_line_2 AS address_line_2_7, t0.city AS city_8, t0.postal_code AS postal_code_9, t0.country_code AS country_code_10, t0.email AS email_11, t0.phone_number AS phone_number_12, t0.started_at AS started_at_13, t0.ended_at AS ended_at_14, t0.recorded_at AS recorded_at_15, t0.updated_at AS updated_at_16, t0.vehicle_id AS vehicle_id_17 FROM delta_vehicle_ownership t0 WHERE t0.vehicle_id = 5 ORDER BY t0.started_at ASC, t0.id ASC;