Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 75
• Events
• Routing
• Cache
• Translation
• Twig
• HTTP Client
• Debug
• Doctrine
• Messages
• Scripts
• Active Rules
• Cache tags
• Cart 0
• Elasticsearch
• Emails
• Serializer
• Vite
• Feature flags
• Configuration

Query Metrics

Grouped Statements

Show all queries

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  "account/order"
  "account/order/"
]

# seo-url::resolve
SELECT
  id,
  path_info pathInfo,
  is_canonical isCanonical,
  sales_channel_id salesChannelId
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (
    (
      seo_path_info = ?
      OR seo_path_info = ?
    )
  )

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x2A5CD912562C4AEBBBD2EE2C9F3D14BB OR sales_channel_id IS NULL)) AND ((seo_path_info = 'account/order' OR seo_path_info = 'account/order/'));

SELECT `key`, `value` FROM `app_config`

[]

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  b"\t,¿}{¸Eχ\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–슽\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
]

SELECT
  `rule`.`id` as `rule.id`,
  `rule`.`name` as `rule.name`,
  `rule`.`priority` as `rule.priority`,
  `rule`.`description` as `rule.description`,
  `rule`.`payload` as `rule.payload`,
  `rule`.`invalid` as `rule.invalid`,
  `rule`.`areas` as `rule.areas`,
  `rule`.`custom_fields` as `rule.customFields`,
  `rule`.`module_types` as `rule.moduleTypes`,
  `rule`.`created_at` as `rule.createdAt`,
  `rule`.`updated_at` as `rule.updatedAt`
FROM
  `rule`
WHERE
  `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (0x092CBF7D7BB845CF871F8BC35847021A, 0x2CF59896AF66475896EC8ABD03AC26B6, 0x3858957016644DE4AE48C0500BF3CCC8, 0x3C9D7D926B6A47FE8D4AE20D0A993424, 0x69E0E90BD44D465989887976752EFDFC, 0xE1378DB7808A478F919E0D740D5D6C1A, 0xE92B366FE0CE497B9B5E2B4C2A2CB0F6, 0xFA9FEB38521B4C508AF91AFAFCF89EAA, 0x26D71577E36549C88B704BB9E7F73918, 0x28CAAE75A5624F0D985ABD0EB32AA160, 0x53D34850DC394BD7806D5818C3011A2D, 0x71012C3C5BF6413D83B96241E47BD9DD);

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;

[]

SELECT
  custom_entity.name,
  custom_entity.fields,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;

[]

# dbal-plugin-loader
SELECT
  `name`,
  `base_class` AS baseClass,
  IF(
    `active` = 1
    AND `installed_at` IS NOT NULL,
    1,
    0
  ) AS active,
  `path`,
  `version`,
  `autoload`,
  `managed_by_composer` AS managedByComposer,
  composer_name as composerName
FROM
  `plugin`
ORDER BY
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  "/account/order"
]

# seo-url::resolve-fallback
SELECT
  path_info pathInfo,
  seo_path_info seoPathInfo
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (sales_channel_id = ?)
  AND (path_info = ?)
  AND (is_canonical = 1)
LIMIT
  1

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x2A5CD912562C4AEBBBD2EE2C9F3D14BB) AND (path_info = '/account/order') AND (is_canonical = 1) LIMIT 1;

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1

[
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  "o3mkMAUCCWa3lFZkSEC4lBrcoWHCQv6I"
]

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x2A5CD912562C4AEBBBD2EE2C9F3D14BB) AND (token = 'o3mkMAUCCWa3lFZkSEC4lBrcoWHCQv6I') LIMIT 1;

SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)

[
  b"*\Ù\x12V,Jë»Òî,Ÿ=\x14»"
  b"/NñAš(Bû©tûÓëE:{"
]

SELECT
  `sales_channel_country`.`sales_channel_id`,
  `sales_channel_country`.`country_id`
FROM
  `sales_channel_country`
WHERE
  (
    `sales_channel_country`.`sales_channel_id` = ?
    AND `sales_channel_country`.`country_id` = ?
  )

SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = 0x2A5CD912562C4AEBBBD2EE2C9F3D14BB AND `sales_channel_country`.`country_id` = 0x2F4EF1419A2842FBA974FBD3EB453A7B);

Database Connections

Entity Managers

Second Level Cache