Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

91 Database Queries

10 Different statements

138.77 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_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 IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT object_mobile_job_offer.o_id as o_id, object_mobile_job_offer.o_type as o_type FROM object_mobile_job_offer WHERE (position__id IN (:position__id0) AND (city__id IN (:city__id0) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat0 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat0 * PI() / 180) *
                    POWER(SIN((:gpsLon0 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius0
        )) AND  object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1 ORDER BY `publicationDate` DESC   LIMIT 21
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT COUNT(*) FROM object_mobile_job_offer WHERE (position__id IN (:position__id0) AND (city__id IN (:city__id0) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat0 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat0 * PI() / 180) *
                    POWER(SIN((:gpsLon0 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius0
        )) AND  object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1

#▲	Time	Info
1	0.96 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00output_3fd538078f32a4be36c03fa43923c672_desktop" "output_3fd538078f32a4be36c03fa43923c672_desktop" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_3fd538078f32a4be36c03fa43923c672_desktop', 'output_3fd538078f32a4be36c03fa43923c672_desktop');
2	1.00 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00output_3fd538078f32a4be36c03fa43923c672" "output_3fd538078f32a4be36c03fa43923c672" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_3fd538078f32a4be36c03fa43923c672', 'output_3fd538078f32a4be36c03fa43923c672');
3	1.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "output\x00tags\x00" "output_3fd538078f32a4be36c03fa43923c672\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'output_3fd538078f32a4be36c03fa43923c672\0tags\0');
4	1.45 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00site_domain_8d1db1fa9cb5292f870898f126262070" "site_domain_8d1db1fa9cb5292f870898f126262070" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_8d1db1fa9cb5292f870898f126262070', 'site_domain_8d1db1fa9cb5292f870898f126262070');
5	2.76 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_8d1db1fa9cb5292f870898f126262070\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_8d1db1fa9cb5292f870898f126262070\0tags\0');
6	1.13 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 IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/api/job-offers" "sourcePathQuery" => "/api/job-offers?cityIds=394&positionIds=7631&gpsPoints[]=54.3482907,18.6540233&gpsRadius=50&offset=0" "sourceEntireUri" => "http://www.geminipolska.com.pl/api/job-offers?cityIds=394&gpsPoints[0]=54.3482907,18.6540233&gpsRadius=50&offset=0&positionIds=7631" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/api/job-offers' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/api/job-offers?cityIds=394&positionIds=7631&gpsPoints[]=54.3482907,18.6540233&gpsRadius=50&offset=0' AND `type` = 'path_query') OR (source = 'http://www.geminipolska.com.pl/api/job-offers?cityIds=394&gpsPoints[0]=54.3482907,18.6540233&gpsRadius=50&offset=0&positionIds=7631' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
7	0.78 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
8	5.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'redirect\0tags\0', 'route\0tags\0', 'system_route_redirect\0tags\0');
9	0.86 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
10	1.29 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "job-offers" "path" => "/api/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/api/' AND `key` = BINARY 'job-offers';
11	0.77 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/api/job-offers"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/api/job-offers';
12	0.88 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "api" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'api';
13	0.72 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/api"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/api';
14	0.75 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY '';
15	0.82 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00document_1" "document_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
16	0.88 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "document_1\x00tags\x00" "asset_431\x00tags\x00" "asset_524\x00tags\x00" "asset_528\x00tags\x00" "asset_532\x00tags\x00" "asset_535\x00tags\x00" "asset_539\x00tags\x00" "asset_542\x00tags\x00" "asset_564\x00tags\x00" "asset_565\x00tags\x00" "asset_573\x00tags\x00" "asset_585\x00tags\x00" "asset_136\x00tags\x00" "asset_130\x00tags\x00" "asset_120\x00tags\x00" "asset_7\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0', 'asset_431\0tags\0', 'asset_524\0tags\0', 'asset_528\0tags\0', 'asset_532\0tags\0', 'asset_535\0tags\0', 'asset_539\0tags\0', 'asset_542\0tags\0', 'asset_564\0tags\0', 'asset_565\0tags\0', 'asset_573\0tags\0', 'asset_585\0tags\0', 'asset_136\0tags\0', 'asset_130\0tags\0', 'asset_120\0tags\0', 'asset_7\0tags\0');
17	3.14 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00document_properties_1" "document_properties_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1', 'document_properties_1');
18	0.90 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "document_properties\x00tags\x00" "document_1\x00tags\x00" "document_properties_1\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_1\0tags\0', 'document_properties_1\0tags\0');
19	0.80 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;
20	5.15 ms	SELECT object_mobile_job_offer.o_id as o_id, object_mobile_job_offer.o_type as o_type FROM object_mobile_job_offer WHERE (position__id IN (:position__id0) AND (city__id IN (:city__id0) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat0 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat0 * PI() / 180) * POWER(SIN((:gpsLon0 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius0 )) AND object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1 ORDER BY `publicationDate` DESC LIMIT 21 Parameters: [`"position__id0" => "7631" "city__id0" => "394" "gpsLat0" => 54.3482907 "gpsLon0" => 18.6540233 "gpsRadius0" => 50`] View formatted query View runnable query Explain query SELECT object_mobile_job_offer.o_id as o_id, object_mobile_job_offer.o_type as o_type FROM object_mobile_job_offer WHERE ( position__id IN (:position__id0) AND ( city__id IN (:city__id0) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat0 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat0 * PI() / 180 ) * POWER( SIN( ( :gpsLon0 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius0 ) ) AND object_mobile_job_offer.o_type IN ('object', 'folder') ) AND object_mobile_job_offer.o_published = 1 ORDER BY `publicationDate` DESC LIMIT 21 SELECT object_mobile_job_offer.o_id as o_id, object_mobile_job_offer.o_type as o_type FROM object_mobile_job_offer WHERE (position__id IN ('7631') AND (city__id IN ('394') OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((54.3482907 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(54.3482907 * PI() / 180) * POWER(SIN((18.6540233 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 )) AND object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1 ORDER BY `publicationDate` DESC LIMIT 21;
21	1.03 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8506" "object_8506" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8506', 'object_8506');
22	0.86 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8506\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8506\0tags\0', 'class_mobile_job_offer\0tags\0');
23	0.91 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8498" "object_8498" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8498', 'object_8498');
24	0.85 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8498\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8498\0tags\0', 'class_mobile_job_offer\0tags\0');
25	0.88 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8495" "object_8495" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8495', 'object_8495');
26	1.72 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8495\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8495\0tags\0', 'class_mobile_job_offer\0tags\0');
27	2.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8494" "object_8494" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8494', 'object_8494');
28	0.81 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8494\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8494\0tags\0', 'class_mobile_job_offer\0tags\0');
29	1.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8435" "object_8435" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8435', 'object_8435');
30	1.47 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8435\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8435\0tags\0', 'class_mobile_job_offer\0tags\0');
31	5.96 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8394" "object_8394" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8394', 'object_8394');
32	0.82 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8394\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8394\0tags\0', 'class_mobile_job_offer\0tags\0');
33	0.88 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8247" "object_8247" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8247', 'object_8247');
34	0.76 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8247\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8247\0tags\0', 'class_mobile_job_offer\0tags\0');
35	0.79 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8157" "object_8157" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8157', 'object_8157');
36	1.68 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8157\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8157\0tags\0', 'class_mobile_job_offer\0tags\0');
37	0.90 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8068" "object_8068" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8068', 'object_8068');
38	0.88 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8068\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8068\0tags\0', 'class_mobile_job_offer\0tags\0');
39	0.86 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_8070" "object_8070" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8070', 'object_8070');
40	1.67 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_8070\x00tags\x00" "class_mobile_job_offer\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8070\0tags\0', 'class_mobile_job_offer\0tags\0');
41	8.77 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"mobile_job_offer"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'mobile_job_offer';
42	1.00 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_5921" "object_5921" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_5921', 'object_5921');
43	0.92 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_5921\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5921\0tags\0', 'class_4\0tags\0');
44	0.93 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_7631" "object_7631" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7631', 'object_7631');
45	0.98 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_7631\x00tags\x00" "class_position\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7631\0tags\0', 'class_position\0tags\0');
46	0.87 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_7635" "object_7635" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7635', 'object_7635');
47	0.74 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_7635\x00tags\x00" "class_contract_type\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7635\0tags\0', 'class_contract_type\0tags\0');
48	1.37 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '4';
49	0.86 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_394" "object_394" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_394', 'object_394');
50	0.84 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_394\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_394\0tags\0', 'class_3\0tags\0');
51	0.84 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8506 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8506 AND fieldname = 'workingDays' ORDER BY `index` ASC;
52	6.98 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_448" "object_448" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_448', 'object_448');
53	1.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_448\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_448\0tags\0', 'class_4\0tags\0');
54	0.78 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_7636" "object_7636" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7636', 'object_7636');
55	0.83 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_7636\x00tags\x00" "class_contract_type\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7636\0tags\0', 'class_contract_type\0tags\0');
56	0.90 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_416" "object_416" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_416', 'object_416');
57	1.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_416\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_416\0tags\0', 'class_3\0tags\0');
58	0.88 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8498 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8498 AND fieldname = 'workingDays' ORDER BY `index` ASC;
59	0.90 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_3834" "object_3834" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3834', 'object_3834');
60	0.96 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_3834\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3834\0tags\0', 'class_4\0tags\0');
61	2.10 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8495 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8495 AND fieldname = 'workingDays' ORDER BY `index` ASC;
62	1.67 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_552" "object_552" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_552', 'object_552');
63	0.88 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_552\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_552\0tags\0', 'class_4\0tags\0');
64	0.83 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_485" "object_485" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_485', 'object_485');
65	3.80 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_485\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_485\0tags\0', 'class_3\0tags\0');
66	0.94 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8494 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8494 AND fieldname = 'workingDays' ORDER BY `index` ASC;
67	0.92 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_7598" "object_7598" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7598', 'object_7598');
68	1.14 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_7598\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7598\0tags\0', 'class_4\0tags\0');
69	0.86 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8435 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8435 AND fieldname = 'workingDays' ORDER BY `index` ASC;
70	1.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_6357" "object_6357" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6357', 'object_6357');
71	1.06 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_6357\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6357\0tags\0', 'class_4\0tags\0');
72	0.77 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_6356" "object_6356" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6356', 'object_6356');
73	1.05 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_6356\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6356\0tags\0', 'class_3\0tags\0');
74	10.01 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8394 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8394 AND fieldname = 'workingDays' ORDER BY `index` ASC;
75	0.95 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_7637" "object_7637" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7637', 'object_7637');
76	0.75 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_7637\x00tags\x00" "class_contract_type\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7637\0tags\0', 'class_contract_type\0tags\0');
77	0.85 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8247 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8247 AND fieldname = 'workingDays' ORDER BY `index` ASC;
78	0.88 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_403" "object_403" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_403', 'object_403');
79	0.90 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_403\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_403\0tags\0', 'class_4\0tags\0');
80	0.99 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_402" "object_402" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_402', 'object_402');
81	0.82 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_402\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_402\0tags\0', 'class_3\0tags\0');
82	0.78 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8157 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8157 AND fieldname = 'workingDays' ORDER BY `index` ASC;
83	0.81 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_411" "object_411" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_411', 'object_411');
84	0.79 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_411\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_411\0tags\0', 'class_4\0tags\0');
85	0.79 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_410" "object_410" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_410', 'object_410');
86	1.54 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_410\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_410\0tags\0', 'class_3\0tags\0');
87	0.86 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8068 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8068 AND fieldname = 'workingDays' ORDER BY `index` ASC;
88	0.83 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "\x00tags\x00object_7018" "object_7018" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7018', 'object_7018');
89	0.85 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1782489304 [ "object_7018\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1782489304 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7018\0tags\0', 'class_4\0tags\0');
90	5.48 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8070 "workingDays"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = 8070 AND fieldname = 'workingDays' ORDER BY `index` ASC;
91	1.39 ms	SELECT COUNT() FROM object_mobile_job_offer WHERE (position__id IN (:position__id0) AND (city__id IN (:city__id0) OR ( 6371 2 * ASIN( SQRT( POWER(SIN((:gpsLat0 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat0 * PI() / 180) * POWER(SIN((:gpsLon0 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius0 )) AND object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1 Parameters: [`"position__id0" => "7631" "city__id0" => "394" "gpsLat0" => 54.3482907 "gpsLon0" => 18.6540233 "gpsRadius0" => 50`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_mobile_job_offer WHERE ( position__id IN (:position__id0) AND ( city__id IN (:city__id0) OR ( 6371 2 * ASIN( SQRT( POWER( SIN( (:gpsLat0 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat0 * PI() / 180 ) * POWER( SIN( ( :gpsLon0 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius0 ) ) AND object_mobile_job_offer.o_type IN ('object', 'folder') ) AND object_mobile_job_offer.o_published = 1 SELECT COUNT() FROM object_mobile_job_offer WHERE (position__id IN ('7631') AND (city__id IN ('394') OR ( 6371 2 * ASIN( SQRT( POWER(SIN((54.3482907 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(54.3482907 * PI() / 180) * POWER(SIN((18.6540233 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 )) AND object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

http://www.geminipolska.com.pl/api/job-offers?cityIds=394&gpsPoints%5B0%5D=54.3482907%2C18.6540233&gpsRadius=50&offset=0&positionIds=7631

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache