Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

5 Database Queries

2 Different statements

1.76 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.33 ms (75.64%)	4	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 (?) Parameters: [`1732418429 [ "\x00tags\x00asset_189" "asset_189" ]`] View formatted query View runnable query Explain query 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 > 1732418429 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_189', 'asset_189');
0.43 ms (24.36%)	1	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC Parameters: ["sourcePath" => "/_profiler/SELECTFROMredirectsWHERE((source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND(`type`='path'OR`type`='auto_create'))OR(source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='path_query')OR(source='http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='entire_uri'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;" "sourcePathQuery" => "/_profiler/SELECTFROMredirectsWHERE((source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND(`type`='path'OR`type`='auto_create'))OR(source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='path_query')OR(source='http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='entire_uri'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;" "sourceEntireUri" => "http://pimcore-demo.profildoors.de/_profiler/SELECTFROMredirectsWHERE((source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND(`type`='path'OR`type`='auto_create'))OR(source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='path_query')OR(source='http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='entire_uri'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"] View formatted query View runnable query Explain query SELECT FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_profiler/SELECTFROMredirectsWHERE((source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND(`type`=\'path\'OR`type`=\'auto_create\'))OR(source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'path_query\')OR(source=\'http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'entire_uri\'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_profiler/SELECTFROMredirectsWHERE((source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND(`type`=\'path\'OR`type`=\'auto_create\'))OR(source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'path_query\')OR(source=\'http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'entire_uri\'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;' AND `type` = 'path_query') OR (source = 'http://pimcore-demo.profildoors.de/_profiler/SELECT*FROMredirectsWHERE((source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND(`type`=\'path\'OR`type`=\'auto_create\'))OR(source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'path_query\')OR(source=\'http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'entire_uri\'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC;

Time▼

Count

Info

1.33 ms
(75.64%)

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 (?)

Parameters:

[
  1732418429
  [
    "\x00tags\x00asset_189"
    "asset_189"
  ]
]

View formatted query View runnable query Explain query

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 > 1732418429 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_189', 'asset_189');

0.43 ms
(24.36%)

SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC

Parameters:

[
  "sourcePath" => "/_profiler/SELECT*FROMredirectsWHERE((source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND(`type`='path'OR`type`='auto_create'))OR(source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='path_query')OR(source='http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='entire_uri'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;"
  "sourcePathQuery" => "/_profiler/SELECT*FROMredirectsWHERE((source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND(`type`='path'OR`type`='auto_create'))OR(source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='path_query')OR(source='http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='entire_uri'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;"
  "sourceEntireUri" => "http://pimcore-demo.profildoors.de/_profiler/SELECT*FROMredirectsWHERE((source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND(`type`='path'OR`type`='auto_create'))OR(source='/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='path_query')OR(source='http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp'AND`type`='entire_uri'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/_profiler/SELECT*FROMredirectsWHERE((source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND(`type`=\'path\'OR`type`=\'auto_create\'))OR(source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'path_query\')OR(source=\'http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'entire_uri\'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/_profiler/SELECT*FROMredirectsWHERE((source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND(`type`=\'path\'OR`type`=\'auto_create\'))OR(source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'path_query\')OR(source=\'http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'entire_uri\'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;' AND `type` = 'path_query') OR
                (source = 'http://pimcore-demo.profildoors.de/_profiler/SELECT*FROMredirectsWHERE((source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND(`type`=\'path\'OR`type`=\'auto_create\'))OR(source=\'/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'path_query\')OR(source=\'http:/pimcore-demo.profildoors.de/CarImages/vw/189/image-thumb__189__product_detail_auto_1cd809d5acc14d1301b3953813f2150f/1966_Volkswagen_T1_2.0_Front.webp\'AND`type`=\'entire_uri\'))ANDactive=1ANDregexISNULLAND(expiry>UNIX_TIMESTAMP()ORexpiryISNULL)ANDsourceSiteISNULLANDpriority=99ORDERBY`priority`DESC;' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache