Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

105 Database Queries

24 Different statements

163.19 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
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 = '4' AND priority = 99 ORDER BY `priority` DESC
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND (siteId = 4 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND (siteId = 4 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND (channels LIKE '%#/Develey/Struktur/Kanäle/wienerrezeptkultur.at#%') AND (articleNumber='999161') ORDER BY sorting desc,a.o_id desc
SELECT FOUND_ROWS()
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND  objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (type = 'object' or type = '')
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (type = 'object' or type = '')
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (type = 'object' or type = '')
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (type = 'object' or type = '')
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (type = 'object' or type = '')
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (type = 'object' or type = '')
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND (type = 'object' or type = '')
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = 'DE' AND changedDateTime >= :startDate
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
"START TRANSACTION"
INSERT INTO
    cache (id, data, expire, mtime) VALUES (:id, :data, :expire, :mtime)
    ON DUPLICATE KEY UPDATE data = VALUES(data), expire = VALUES(expire), mtime = VALUES(mtime)
DELETE FROM cache_tags WHERE id = ? AND tag NOT IN (?)
INSERT INTO cache_tags (id, tag) VALUES (?, ?) ON DUPLICATE KEY UPDATE tag = VALUES(tag)
"COMMIT"
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM documents_elements WHERE documentId = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)

#▲	Time	Info
1	6.49 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_domain_3d30d482088fdef157324a9e20530534" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_domain_3d30d482088fdef157324a9e20530534');
2	2.12 ms	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 = '4' AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/de/shop/999161/zwetschken-balsam-essig" "sourcePathQuery" => "/de/shop/999161/zwetschken-balsam-essig" "sourceEntireUri" => "https://mautner-specialitaeten.develey.blackbit.io/de/shop/999161/zwetschken-balsam-essig" "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 = '4' AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/de/shop/999161/zwetschken-balsam-essig' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/shop/999161/zwetschken-balsam-essig' AND `type` = 'path_query') OR (source = 'https://mautner-specialitaeten.develey.blackbit.io/de/shop/999161/zwetschken-balsam-essig' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '4' AND priority = 99 ORDER BY `priority` DESC;
3	0.13 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "system_route_redirect" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('system_route_redirect');
4	13.07 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "zwetschken-balsam-essig" "path" => "/Mautners-Specialitaeten/de/shop/999161/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/shop/999161/' AND `key` = 'zwetschken-balsam-essig';
5	0.23 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig';
6	0.20 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop/999161/zwetschken-balsam-essig';
7	0.06 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "zwetschken-balsam-essig" "path" => "/Mautners-Specialitaeten/de/shop/999161/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/shop/999161/' AND `key` = 'zwetschken-balsam-essig';
8	0.04 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig';
9	0.09 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop/999161/zwetschken-balsam-essig';
10	0.13 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "999161" "path" => "/Mautners-Specialitaeten/de/shop/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/shop/' AND `key` = '999161';
11	0.29 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop/999161"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop/999161';
12	2.20 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop/999161"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop/999161';
13	0.52 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "shop" "path" => "/Mautners-Specialitaeten/de/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/' AND `key` = 'shop';
14	0.05 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop';
15	0.04 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop';
16	0.04 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "de" "path" => "/Mautners-Specialitaeten/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/' AND `key` = 'de';
17	0.05 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "document_81" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_81');
18	0.23 ms	SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND (siteId = 4 OR siteId = 0) ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND ( siteId = 4 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND (siteId = 4 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
19	1.09 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_3" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_3');
20	0.25 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_4" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_4');
21	0.20 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_5" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_5');
22	0.70 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_13" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_13');
23	0.32 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_6" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_6');
24	2.95 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "zwetschken-balsam-essig" "path" => "/Mautners-Specialitaeten/de/shop/999161/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/shop/999161/' AND `key` = 'zwetschken-balsam-essig';
25	1.48 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig';
26	0.06 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop/999161/zwetschken-balsam-essig';
27	0.05 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "999161" "path" => "/Mautners-Specialitaeten/de/shop/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/shop/' AND `key` = '999161';
28	0.04 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop/999161"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop/999161';
29	0.03 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop/999161"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop/999161';
30	0.04 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "shop" "path" => "/Mautners-Specialitaeten/de/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/' AND `key` = 'shop';
31	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop';
32	1.31 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop';
33	0.31 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "document_properties_81" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_81');
34	1.44 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "zwetschken-balsam-essig" "path" => "/Mautners-Specialitaeten/de/shop/999161/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/shop/999161/' AND `key` = 'zwetschken-balsam-essig';
35	0.23 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/Mautners-Specialitaeten/de/shop/999161/zwetschken-balsam-essig';
36	3.58 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/Mautners-Specialitaeten/%" "/de/shop/999161/zwetschken-balsam-essig"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/Mautners-Specialitaeten/%' AND documents_page.prettyUrl = '/de/shop/999161/zwetschken-balsam-essig';
37	1.28 ms	SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND (siteId = 4 OR siteId = 0) ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND ( siteId = 4 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/shop/999161/zwetschken-balsam-essig' AND (siteId = 4 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
38	0.06 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
39	3.77 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_1961" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_1961');
40	6.61 ms	SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites ORDER BY ( SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC ;
41	0.13 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_1');
42	0.05 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_12" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_12');
43	0.12 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_11" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_11');
44	0.04 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_10" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_10');
45	0.04 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_9" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_9');
46	0.26 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_8" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_8');
47	0.14 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_7" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_7');
48	0.05 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "site_id_2" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_2');
49	0.13 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "document_properties_78" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_78');
50	4.54 ms	SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND (channels LIKE '%#/Develey/Struktur/Kanäle/wienerrezeptkultur.at#%') AND (articleNumber='999161') ORDER BY sorting desc,a.o_id desc Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND ( channels LIKE '%#/Develey/Struktur/Kanäle/wienerrezeptkultur.at#%' ) AND (articleNumber = '999161') ORDER BY sorting desc, a.o_id desc SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND (channels LIKE '%#/Develey/Struktur/Kanäle/wienerrezeptkultur.at#%') AND (articleNumber='999161') ORDER BY sorting desc,a.o_id desc ;
51	5.48 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
52	0.18 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_2115" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_2115');
53	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"11"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '11';
54	1.78 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_2112" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_2112');
55	0.09 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_2106" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_2106');
56	0.05 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_1959" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_1959');
57	0.04 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_129" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_129');
58	0.04 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_1');
59	3.98 ms	SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC Parameters: [`2115`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ( ( o_parentId = ? AND objects.o_type IN ('variant') ) AND objects.o_published = 1 ) ORDER BY `o_key` ASC SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = 2115 AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC;
60	6.37 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "product_price_history_2115_all_30" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('product_price_history_2115_all_30');
61	0.06 ms	SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845) Parameters: [] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_id IN ( 149533, 149594, 149848, 149654, 149839, 149852, 149845 ) SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845);
62	0.41 ms	SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '') Parameters: [`2115 "149533" "prices" "object" "" "0" 1`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND ( type = 'object' or type = '' ) SELECT * FROM object_metadata_11 WHERE o_id = 2115 AND dest_id = '149533' AND fieldname = 'prices' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1 AND (type = 'object' or type = '');
63	0.75 ms	SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '') Parameters: [`2115 "149594" "prices" "object" "" "0" 2`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND ( type = 'object' or type = '' ) SELECT * FROM object_metadata_11 WHERE o_id = 2115 AND dest_id = '149594' AND fieldname = 'prices' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 2 AND (type = 'object' or type = '');
64	2.16 ms	SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '') Parameters: [`2115 "149848" "prices" "object" "" "0" 3`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND ( type = 'object' or type = '' ) SELECT * FROM object_metadata_11 WHERE o_id = 2115 AND dest_id = '149848' AND fieldname = 'prices' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 3 AND (type = 'object' or type = '');
65	0.27 ms	SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '') Parameters: [`2115 "149654" "prices" "object" "" "0" 4`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND ( type = 'object' or type = '' ) SELECT * FROM object_metadata_11 WHERE o_id = 2115 AND dest_id = '149654' AND fieldname = 'prices' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 4 AND (type = 'object' or type = '');
66	5.93 ms	SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '') Parameters: [`2115 "149839" "prices" "object" "" "0" 5`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND ( type = 'object' or type = '' ) SELECT * FROM object_metadata_11 WHERE o_id = 2115 AND dest_id = '149839' AND fieldname = 'prices' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 5 AND (type = 'object' or type = '');
67	0.35 ms	SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '') Parameters: [`2115 "149852" "prices" "object" "" "0" 6`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND ( type = 'object' or type = '' ) SELECT * FROM object_metadata_11 WHERE o_id = 2115 AND dest_id = '149852' AND fieldname = 'prices' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 6 AND (type = 'object' or type = '');
68	0.45 ms	SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '') Parameters: [`2115 "149845" "prices" "object" "" "0" 7`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND ( type = 'object' or type = '' ) SELECT * FROM object_metadata_11 WHERE o_id = 2115 AND dest_id = '149845' AND fieldname = 'prices' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 7 AND (type = 'object' or type = '');
69	5.96 ms	SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845); Parameters: [] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_published = 1 AND o_id IN ( 149533, 149594, 149848, 149654, 149839, 149852, 149845 ); SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);;
70	0.53 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_149533" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_149533');
71	2.19 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":countryCode" => "AT" ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = : countryCode AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate;
72	0.60 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "AT"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
73	3.69 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_149594" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_149594');
74	0.43 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":countryCode" => "ES" ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = : countryCode AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate;
75	3.01 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "ES"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
76	1.06 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_149848" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_149848');
77	1.56 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":countryCode" => "FR" ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = : countryCode AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate;
78	1.41 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "FR"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
79	0.60 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_149654" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_149654');
80	0.38 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":countryCode" => "IT" ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = : countryCode AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate;
81	5.15 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "IT"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
82	3.01 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_149839" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_149839');
83	0.53 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":countryCode" => "LU" ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = : countryCode AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate;
84	0.56 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "LU"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
85	0.17 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_149852" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_149852');
86	2.13 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":countryCode" => "SE" ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = : countryCode AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate;
87	0.47 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "SE"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
88	5.42 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "object_149845" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_149845');
89	2.50 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":countryCode" => "MT" ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = : countryCode AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate;
90	0.72 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "MT"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
91	0.29 ms	SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = 'DE' AND changedDateTime >= :startDate Parameters: [`":id" => 2115 ":startDate" => Carbon\Carbon {#3251 __toString(): "2026-03-05 00:00:00" }`] View formatted query View runnable query SELECT MIN(price) FROM object_22 WHERE product__id = : id AND countryCode = 'DE' AND changedDateTime >= : startDate SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = 'DE' AND changedDateTime >= :startDate;
92	1.68 ms	SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2 Parameters: [`":id" => 2115 ":countryCode" => "DE"`] View formatted query View runnable query Explain query SELECT price FROM object_22 WHERE product__id = : id AND countryCode = : countryCode ORDER BY changedDateTime DESC LIMIT 2 SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2;
93	5.34 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
94	1.95 ms	INSERT INTO cache (id, data, expire, mtime) VALUES (:id, :data, :expire, :mtime) ON DUPLICATE KEY UPDATE data = VALUES(data), expire = VALUES(expire), mtime = VALUES(mtime) Parameters: [`"id" => "product_price_history_2115_all_30" "data" => "s:134:"a:8:{s:2:"DE";d:6.37;s:2:"AT";d:6.55;s:2:"ES";d:6.55;s:2:"FR";d:6.28;s:2:"IT";d:6.55;s:2:"LU";d:6.13;s:2:"SE";d:6.67;s:2:"MT";d:7.02;}";" "expire" => 1775356839 "mtime" => 1775270439`] View formatted query View runnable query Explain query INSERT INTO cache (id, data, expire, mtime) VALUES (: id, : data, : expire, : mtime) ON DUPLICATE KEY UPDATE data = VALUES (data), expire = VALUES (expire), mtime = VALUES (mtime) INSERT INTO cache (id, data, expire, mtime) VALUES ('product_price_history_2115_all_30', 's:134:\"a:8:{s:2:\"DE\";d:6.37;s:2:\"AT\";d:6.55;s:2:\"ES\";d:6.55;s:2:\"FR\";d:6.28;s:2:\"IT\";d:6.55;s:2:\"LU\";d:6.13;s:2:\"SE\";d:6.67;s:2:\"MT\";d:7.02;}\";', 1775356839, 1775270439) ON DUPLICATE KEY UPDATE data = VALUES(data), expire = VALUES(expire), mtime = VALUES(mtime);
95	0.20 ms	DELETE FROM cache_tags WHERE id = ? AND tag NOT IN (?) Parameters: [`"product_price_history_2115_all_30" [ "22_getMinimumPrice" ]`] View formatted query View runnable query Explain query DELETE FROM cache_tags WHERE id = ? AND tag NOT IN (?) DELETE FROM cache_tags WHERE id = 'product_price_history_2115_all_30' AND tag NOT IN ('22_getMinimumPrice');
96	1.01 ms	INSERT INTO cache_tags (id, tag) VALUES (?, ?) ON DUPLICATE KEY UPDATE tag = VALUES(tag) Parameters: [`"product_price_history_2115_all_30" "22_getMinimumPrice"`] View formatted query View runnable query Explain query INSERT INTO cache_tags (id, tag) VALUES (?, ?) ON DUPLICATE KEY UPDATE tag = VALUES (tag) INSERT INTO cache_tags (id, tag) VALUES ('product_price_history_2115_all_30', '22_getMinimumPrice') ON DUPLICATE KEY UPDATE tag = VALUES(tag);
97	4.21 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
98	1.64 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "translation_data_messages_de" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('translation_data_messages_de');
99	1.74 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "footer" "path" => "/Mautners-Specialitaeten/de/includes/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/Mautners-Specialitaeten/de/includes/' AND `key` = 'footer';
100	8.07 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "document_83" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_83');
101	0.31 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "document_properties_83" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_83');
102	5.47 ms	SELECT * FROM documents_elements WHERE documentId = ? Parameters: [`83`] View formatted query View runnable query Explain query SELECT * FROM documents_elements WHERE documentId = ? SELECT * FROM documents_elements WHERE documentId = 83;
103	2.87 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "asset_375" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('asset_375');
104	0.09 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "document_85" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_85');
105	0.44 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1775270439 [ "document_155" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1775270439 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_155');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Symfony Profiler

https://mautner-specialitaeten.develey.blackbit.io/_fragment?_path=_locale%3Dde%26_format%3Dhtml%26_controller%3DDeveley%255CMautnerSpezialitaetenBundle%255CController%255CContentController%253AdefaultAction

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://mautner-specialitaeten.develey.blackbit.io/_fragment?_path=_locale%3Dde%26_format%3Dhtml%26_controller%3DDeveley%255CMautnerSpezialitaetenBundle%255CController%255CContentController%253AdefaultAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping