Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

82 Database Queries

11 Different statements

22.53 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 = '3' 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 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 = '/home-apartments/apartments/dc/washington/pershing-house/contact' AND siteId = '0'
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 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 targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT object_39.o_id as o_id, `object_39`.`o_type` FROM `object_39` WHERE ((state = 'dc'  AND  object_39.o_type IN ('object','folder')) AND object_39.o_published = 1)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE (( object_29.o_type IN ('object','folder')) AND object_29.o_published = 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, 
          (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 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 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 o_id FROM objects WHERE o_path = :path AND `o_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 id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE (( object_29.o_type IN ('object','folder')) AND object_29.o_published = 1)
SELECT name FROM classes WHERE id = ?

#▲	Time	Info
1	0.49 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "site_domain_50d582f11c083e9cd19e921b85c424ae" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_domain_50d582f11c083e9cd19e921b85c424ae');
2	0.73 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 = '3' AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/apartments/dc/washington/pershing-house/contact" "sourcePathQuery" => "/apartments/dc/washington/pershing-house/contact" "sourceEntireUri" => "https://vm-apartments.grafik-stage.io/apartments/dc/washington/pershing-house/contact" "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 = '3' AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/apartments/dc/washington/pershing-house/contact' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/apartments/dc/washington/pershing-house/contact' AND `type` = 'path_query') OR (source = 'https://vm-apartments.grafik-stage.io/apartments/dc/washington/pershing-house/contact' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '3' AND priority = 99 ORDER BY `priority` DESC;
3	1.55 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('system_route_redirect');
4	0.50 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "contact" "path" => "/home-apartments/apartments/dc/washington/pershing-house/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/dc/washington/pershing-house/' AND `key` = 'contact';
5	0.31 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc/washington/pershing-house/contact"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc/washington/pershing-house/contact';
6	0.37 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: [`"/home-apartments/%" "/apartments/dc/washington/pershing-house/contact"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc/washington/pershing-house/contact';
7	0.26 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "contact" "path" => "/home-apartments/apartments/dc/washington/pershing-house/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/dc/washington/pershing-house/' AND `key` = 'contact';
8	0.24 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc/washington/pershing-house/contact"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc/washington/pershing-house/contact';
9	0.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: [`"/home-apartments/%" "/apartments/dc/washington/pershing-house/contact"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc/washington/pershing-house/contact';
10	0.22 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "pershing-house" "path" => "/home-apartments/apartments/dc/washington/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/dc/washington/' AND `key` = 'pershing-house';
11	0.21 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc/washington/pershing-house"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc/washington/pershing-house';
12	0.30 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: [`"/home-apartments/%" "/apartments/dc/washington/pershing-house"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc/washington/pershing-house';
13	0.20 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "washington" "path" => "/home-apartments/apartments/dc/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/dc/' AND `key` = 'washington';
14	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc/washington"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc/washington';
15	0.29 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: [`"/home-apartments/%" "/apartments/dc/washington"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc/washington';
16	0.20 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "dc" "path" => "/home-apartments/apartments/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/' AND `key` = 'dc';
17	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc';
18	0.29 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: [`"/home-apartments/%" "/apartments/dc"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc';
19	0.20 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "apartments" "path" => "/home-apartments/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/' AND `key` = 'apartments';
20	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments';
21	0.32 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: [`"/home-apartments/%" "/apartments"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments';
22	0.21 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "home-apartments" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/' AND `key` = 'home-apartments';
23	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: [`1774717263 [ "document_92" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_92');
24	0.22 ms	SELECT * FROM object_url_slugs WHERE slug = '/home-apartments/apartments/dc/washington/pershing-house/contact' AND siteId = '0' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/home-apartments/apartments/dc/washington/pershing-house/contact' AND siteId = '0' SELECT * FROM object_url_slugs WHERE slug = '/home-apartments/apartments/dc/washington/pershing-house/contact' AND siteId = '0';
25	0.29 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_2');
26	0.28 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_3');
27	0.23 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_id_4');
28	0.31 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "contact" "path" => "/home-apartments/apartments/dc/washington/pershing-house/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/dc/washington/pershing-house/' AND `key` = 'contact';
29	0.21 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc/washington/pershing-house/contact"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc/washington/pershing-house/contact';
30	0.24 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: [`"/home-apartments/%" "/apartments/dc/washington/pershing-house/contact"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc/washington/pershing-house/contact';
31	0.19 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "pershing-house" "path" => "/home-apartments/apartments/dc/washington/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/dc/washington/' AND `key` = 'pershing-house';
32	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc/washington/pershing-house"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc/washington/pershing-house';
33	0.22 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: [`"/home-apartments/%" "/apartments/dc/washington/pershing-house"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc/washington/pershing-house';
34	0.16 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "washington" "path" => "/home-apartments/apartments/dc/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/dc/' AND `key` = 'washington';
35	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc/washington"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc/washington';
36	0.21 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: [`"/home-apartments/%" "/apartments/dc/washington"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc/washington';
37	0.18 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "dc" "path" => "/home-apartments/apartments/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/apartments/' AND `key` = 'dc';
38	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments/dc"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments/dc';
39	0.26 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: [`"/home-apartments/%" "/apartments/dc"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments/dc';
40	0.16 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "apartments" "path" => "/home-apartments/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/home-apartments/' AND `key` = 'apartments';
41	0.15 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/home-apartments/apartments"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/home-apartments/apartments';
42	0.22 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: [`"/home-apartments/%" "/apartments"`] 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 '/home-apartments/%' AND documents_page.prettyUrl = '/apartments';
43	0.23 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "document_properties_92" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_92');
44	0.23 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;
45	0.23 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"39"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '39';
46	0.63 ms	SELECT object_39.o_id as o_id, `object_39`.`o_type` FROM `object_39` WHERE ((state = 'dc' AND object_39.o_type IN ('object','folder')) AND object_39.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT object_39.o_id as o_id, `object_39`.`o_type` FROM `object_39` WHERE ( ( state = 'dc' AND object_39.o_type IN ('object', 'folder') ) AND object_39.o_published = 1 ) SELECT object_39.o_id as o_id, `object_39`.`o_type` FROM `object_39` WHERE ((state = 'dc' AND object_39.o_type IN ('object','folder')) AND object_39.o_published = 1);
47	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: [`1774717263 [ "object_120582" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_120582');
48	0.92 ms	SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE (( object_29.o_type IN ('object','folder')) AND object_29.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE ( ( object_29.o_type IN ('object', 'folder') ) AND object_29.o_published = 1 ) SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE (( object_29.o_type IN ('object','folder')) AND object_29.o_published = 1);
49	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: [`1774717263 [ "object_68339" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68339');
50	0.28 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68340" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68340');
51	0.22 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68341" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68341');
52	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: [`1774717263 [ "object_68342" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68342');
53	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: [`1774717263 [ "object_68343" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68343');
54	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: [`1774717263 [ "object_68344" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68344');
55	0.19 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68345" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68345');
56	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: [`1774717263 [ "object_68346" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68346');
57	0.16 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68347" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68347');
58	0.23 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68348" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68348');
59	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: [`1774717263 [ "object_68349" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68349');
60	0.21 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68350" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68350');
61	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: [`1774717263 [ "object_68351" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68351');
62	0.16 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68352" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68352');
63	0.16 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68353" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68353');
64	0.16 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68354" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68354');
65	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: [`1774717263 [ "object_68355" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68355');
66	0.19 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68356" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68356');
67	0.19 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68357" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68357');
68	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: [`1774717263 [ "object_68358" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68358');
69	0.23 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68359" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68359');
70	0.19 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_68362" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68362');
71	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: [`1774717263 [ "object_68363" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_68363');
72	0.19 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_124766" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_124766');
73	0.21 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_125544" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_125544');
74	0.21 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_125944" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_125944');
75	0.23 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_132052" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_132052');
76	0.19 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "object_132114" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_132114');
77	0.42 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "pershing-house" "path" => "/YARDI/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = : path AND `o_key` = : key SELECT o_id FROM objects WHERE o_path = '/YARDI/' AND `o_key` = 'pershing-house';
78	0.38 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "website_config_en_site_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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('website_config_en_site_3');
79	0.29 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "document_properties_92" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_92');
80	0.24 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1774717263 [ "nav_4dcead12084935fa3b2e1523f1a04104" ]`] 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 > 1774717263 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('nav_4dcead12084935fa3b2e1523f1a04104');
81	0.72 ms	SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE (( object_29.o_type IN ('object','folder')) AND object_29.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE ( ( object_29.o_type IN ('object', 'folder') ) AND object_29.o_published = 1 ) SELECT object_29.o_id as o_id, `object_29`.`o_type` FROM `object_29` WHERE (( object_29.o_type IN ('object','folder')) AND object_29.o_published = 1);
82	0.25 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"29"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '29';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Symfony Profiler

https://vm-apartments.grafik-stage.io/apartments/dc/washington/pershing-house/contact

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://vm-apartments.grafik-stage.io/apartments/dc/washington/pershing-house/contact

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping