Symfony Profiler

• Pimcore
• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 269
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Httplug 0/0
• Messages
• JMS Serializer 0 + 0
• Payum
• Themes 1
• Emails
• Workflow
• Notifications
• CoreShop: Rules
• Configuration

Query Metrics

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)

[
  1773970420
  "site_domain_30b361376c41bdfc6ac22d9a0797cc4b"
]

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970420 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_30b361376c41bdfc6ac22d9a0797cc4b');

SELECT DISTINCT c0_.isoCode AS isoCode_0, c0_.name AS name_1, c0_.numericIsoCode AS numericIsoCode_2, c0_.symbol AS symbol_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6 FROM coreshop_currency c0_ LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id WHERE c1_.active = 1 AND c2_.id = ?

[
  1
]

SELECT
  DISTINCT c0_.isoCode AS isoCode_0,
  c0_.name AS name_1,
  c0_.numericIsoCode AS numericIsoCode_2,
  c0_.symbol AS symbol_3,
  c0_.creationDate AS creationDate_4,
  c0_.modificationDate AS modificationDate_5,
  c0_.id AS id_6
FROM
  coreshop_currency c0_
  LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId
  INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id
  INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id
WHERE
  c1_.active = 1
  AND c2_.id = ?

SELECT DISTINCT c0_.isoCode AS isoCode_0, c0_.name AS name_1, c0_.numericIsoCode AS numericIsoCode_2, c0_.symbol AS symbol_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6 FROM coreshop_currency c0_ LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id WHERE c1_.active = 1 AND c2_.id = 1;

SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC

[
  "/aktualitasok/hirek/110th-anniversary-limited"
  "path"
  "auto_create"
  "/aktualitasok/hirek/110th-anniversary-limited"
  "path_query"
  "https://boutique.local.szerver.online/aktualitasok/hirek/110th-anniversary-limited"
  "entire_uri"
]

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/aktualitasok/hirek/110th-anniversary-limited' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/aktualitasok/hirek/110th-anniversary-limited' AND `type` = 'path_query') OR
                (source = 'https://boutique.local.szerver.online/aktualitasok/hirek/110th-anniversary-limited' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?

[
  "/aktualitasok/hirek/"
  "110th-anniversary-limited"
]

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/aktualitasok/hirek/' AND `key` = BINARY '110th-anniversary-limited';

SELECT * FROM settings_store WHERE id = ? AND scope = ?

[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)

[
  1773970420
  "system\x01tags\x01"
  "site\x01tags\x01"
]

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970420 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

SELECT name FROM classes WHERE id = ?

[
  "cs_order"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'cs_order';

SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE `slug` = '110th-anniversary-limited'  AND  object_3.type IN ('variant','object') LIMIT 1

[]

SELECT
  object_3.id as id,
  object_3.type as `type`
FROM
  object_3
WHERE
  `slug` = '110th-anniversary-limited'
  AND object_3.type IN ('variant', 'object')
LIMIT
  1

SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE `slug` = '110th-anniversary-limited'  AND  object_3.type IN ('variant','object') LIMIT 1;

SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t0.baseCountryId AS baseCountryId_10, t11.isoCode AS isoCode_12, t11.active AS active_13, t11.addressFormat AS addressFormat_14, t11.salutations AS salutations_15, t11.creationDate AS creationDate_16, t11.modificationDate AS modificationDate_17, t11.id AS id_18, t11.zoneId AS zoneId_19, t11.currencyId AS currencyId_20 FROM coreshop_store t0 LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.id WHERE t0.id = ?

[
  1
]

SELECT
  t0.name AS name_1,
  t0.template AS template_2,
  t0.isDefault AS isDefault_3,
  t0.siteId AS siteId_4,
  t0.creationDate AS creationDate_5,
  t0.modificationDate AS modificationDate_6,
  t0.id AS id_7,
  t0.useGrossPrice AS useGrossPrice_8,
  t0.currencyId AS currencyId_9,
  t0.baseCountryId AS baseCountryId_10,
  t11.isoCode AS isoCode_12,
  t11.active AS active_13,
  t11.addressFormat AS addressFormat_14,
  t11.salutations AS salutations_15,
  t11.creationDate AS creationDate_16,
  t11.modificationDate AS modificationDate_17,
  t11.id AS id_18,
  t11.zoneId AS zoneId_19,
  t11.currencyId AS currencyId_20
FROM
  coreshop_store t0
  LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t0.baseCountryId AS baseCountryId_10, t11.isoCode AS isoCode_12, t11.active AS active_13, t11.addressFormat AS addressFormat_14, t11.salutations AS salutations_15, t11.creationDate AS creationDate_16, t11.modificationDate AS modificationDate_17, t11.id AS id_18, t11.zoneId AS zoneId_19, t11.currencyId AS currencyId_20 FROM coreshop_store t0 LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.id WHERE t0.id = 1;

SELECT id FROM documents_page WHERE prettyUrl = ?

[
  "/aktualitasok/hirek/110th-anniversary-limited"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/aktualitasok/hirek/110th-anniversary-limited';

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1773970420
  "object_459686\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_17125\x01tags\x01"
  "asset_17123\x01tags\x01"
  "asset_17126\x01tags\x01"
  "asset_17124\x01tags\x01"
  "asset_17149\x01tags\x01"
  "asset_17120\x01tags\x01"
  "asset_17110\x01tags\x01"
  "asset_17107\x01tags\x01"
  "asset_17129\x01tags\x01"
  "asset_17121\x01tags\x01"
  "asset_17109\x01tags\x01"
  "asset_17108\x01tags\x01"
  "asset_17148\x01tags\x01"
  "asset_17106\x01tags\x01"
  "asset_17099\x01tags\x01"
  "asset_17118\x01tags\x01"
  "asset_17101\x01tags\x01"
  "asset_17111\x01tags\x01"
  "asset_17117\x01tags\x01"
  "asset_17131\x01tags\x01"
  "asset_17138\x01tags\x01"
  "asset_17137\x01tags\x01"
  "asset_17135\x01tags\x01"
  "asset_17119\x01tags\x01"
  "asset_17139\x01tags\x01"
  "asset_17136\x01tags\x01"
  "asset_17116\x01tags\x01"
  "asset_17133\x01tags\x01"
  "asset_17105\x01tags\x01"
  "asset_17098\x01tags\x01"
  "asset_17141\x01tags\x01"
  "asset_17140\x01tags\x01"
]

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970420 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_459686
tags
', 'class_3
tags
', 'asset_17125
tags
', 'asset_17123
tags
', 'asset_17126
tags
', 'asset_17124
tags
', 'asset_17149
tags
', 'asset_17120
tags
', 'asset_17110
tags
', 'asset_17107
tags
', 'asset_17129
tags
', 'asset_17121
tags
', 'asset_17109
tags
', 'asset_17108
tags
', 'asset_17148
tags
', 'asset_17106
tags
', 'asset_17099
tags
', 'asset_17118
tags
', 'asset_17101
tags
', 'asset_17111
tags
', 'asset_17117
tags
', 'asset_17131
tags
', 'asset_17138
tags
', 'asset_17137
tags
', 'asset_17135
tags
', 'asset_17119
tags
', 'asset_17139
tags
', 'asset_17136
tags
', 'asset_17116
tags
', 'asset_17133
tags
', 'asset_17105
tags
', 'asset_17098
tags
', 'asset_17141
tags
', 'asset_17140
tags
');

SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (?)

[
  1
]

SELECT
  t0.configKey AS configKey_1,
  t0.data AS data_2,
  t0.creationDate AS creationDate_3,
  t0.modificationDate AS modificationDate_4,
  t0.id AS id_5,
  t0.store_id AS store_id_6
FROM
  coreshop_configuration t0
WHERE
  t0.store_id IN (?)

SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (1);

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?)

[
  1773970420
  "website_config\x01tags\x01"
  "system\x01tags\x01"
  "config\x01tags\x01"
  "output\x01tags\x01"
  "asset_15304\x01tags\x01"
]

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970420 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config
tags
', 'system
tags
', 'config
tags
', 'output
tags
', 'asset_15304
tags
');

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1773970420
  "document_76\x01tags\x01"
  "asset_16823\x01tags\x01"
  "asset_16821\x01tags\x01"
  "asset_16825\x01tags\x01"
  "asset_16824\x01tags\x01"
  "asset_16820\x01tags\x01"
  "asset_20642\x01tags\x01"
  "asset_21858\x01tags\x01"
  "asset_20603\x01tags\x01"
  "asset_20600\x01tags\x01"
  "asset_20602\x01tags\x01"
  "asset_20601\x01tags\x01"
  "asset_20599\x01tags\x01"
  "asset_16826\x01tags\x01"
  "asset_20648\x01tags\x01"
]

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970420 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_76
tags
', 'asset_16823
tags
', 'asset_16821
tags
', 'asset_16825
tags
', 'asset_16824
tags
', 'asset_16820
tags
', 'asset_20642
tags
', 'asset_21858
tags
', 'asset_20603
tags
', 'asset_20600
tags
', 'asset_20602
tags
', 'asset_20601
tags
', 'asset_20599
tags
', 'asset_16826
tags
', 'asset_20648
tags
');

SELECT * FROM object_relations_3 WHERE src_id = ?

[
  459686
]

SELECT
  *
FROM
  object_relations_3
WHERE
  src_id = ?

SELECT * FROM object_relations_3 WHERE src_id = 459686;

SELECT customSettings FROM assets WHERE id = ?

[
  17123
]

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 17123;

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)

[
  1773970420
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970420 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

SELECT * FROM tmp_store WHERE id = ?

[
  "maintenance_mode"
]

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';