Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

104 Database Queries

10 Different statements

124.97 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,:city__id1,:city__id2,:city__id3,:city__id4) 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
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat1 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat1 * PI() / 180) *
                    POWER(SIN((:gpsLon1 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius1
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat2 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat2 * PI() / 180) *
                    POWER(SIN((:gpsLon2 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius2
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat3 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat3 * PI() / 180) *
                    POWER(SIN((:gpsLon3 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius3
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat4 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat4 * PI() / 180) *
                    POWER(SIN((:gpsLon4 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius4
        )) 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 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 * 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 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 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 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,:city__id1,:city__id2,:city__id3,:city__id4) 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
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat1 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat1 * PI() / 180) *
                    POWER(SIN((:gpsLon1 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius1
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat2 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat2 * PI() / 180) *
                    POWER(SIN((:gpsLon2 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius2
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat3 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat3 * PI() / 180) *
                    POWER(SIN((:gpsLon3 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius3
        ) OR (
            6371 * 2 * ASIN(
                SQRT(
                    POWER(SIN((:gpsLat4 - coordinates__latitude) * PI() / 180 / 2), 2) +
                    COS(coordinates__latitude * PI() / 180) * COS(:gpsLat4 * PI() / 180) *
                    POWER(SIN((:gpsLon4 - coordinates__longitude) * PI() / 180 / 2), 2)
                )
            ) <= :gpsRadius4
        )) AND  object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1

#▲	Time	Info
1	0.89 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: [`1783000538 [ "\x00tags\x00output_6d5fdb557d1f6c508d6e22534ff147b9_desktop" "output_6d5fdb557d1f6c508d6e22534ff147b9_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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_6d5fdb557d1f6c508d6e22534ff147b9_desktop', 'output_6d5fdb557d1f6c508d6e22534ff147b9_desktop');
2	1.57 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: [`1783000538 [ "\x00tags\x00output_6d5fdb557d1f6c508d6e22534ff147b9" "output_6d5fdb557d1f6c508d6e22534ff147b9" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_6d5fdb557d1f6c508d6e22534ff147b9', 'output_6d5fdb557d1f6c508d6e22534ff147b9');
3	0.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: [`1783000538 [ "output\x00tags\x00" "output_6d5fdb557d1f6c508d6e22534ff147b9\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'output_6d5fdb557d1f6c508d6e22534ff147b9\0tags\0');
4	0.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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_8d1db1fa9cb5292f870898f126262070', 'site_domain_8d1db1fa9cb5292f870898f126262070');
5	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: [`1783000538 [ "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 > 1783000538 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	0.94 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=485,394,558,5779,388&positionIds=7632&gpsPoints[]=54.5164982,18.5402738&gpsPoints[]=54.3482907,18.6540233&gpsPoints[]=52.2319581,21.0067249&gpsPoints[]=53.9119982,19.9279895&gpsPoints[]=53.1219648,18.0002529&gpsRadius=50&offset=0" "sourceEntireUri" => "http://www.geminipolska.com.pl/api/job-offers?cityIds=485,394,558,5779,388&gpsPoints[0]=54.5164982,18.5402738&gpsPoints[1]=54.3482907,18.6540233&gpsPoints[2]=52.2319581,21.0067249&gpsPoints[3]=53.9119982,19.9279895&gpsPoints[4]=53.1219648,18.0002529&gpsRadius=50&offset=0&positionIds=7632" "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=485,394,558,5779,388&positionIds=7632&gpsPoints[]=54.5164982,18.5402738&gpsPoints[]=54.3482907,18.6540233&gpsPoints[]=52.2319581,21.0067249&gpsPoints[]=53.9119982,19.9279895&gpsPoints[]=53.1219648,18.0002529&gpsRadius=50&offset=0' AND `type` = 'path_query') OR (source = 'http://www.geminipolska.com.pl/api/job-offers?cityIds=485,394,558,5779,388&gpsPoints[0]=54.5164982,18.5402738&gpsPoints[1]=54.3482907,18.6540233&gpsPoints[2]=52.2319581,21.0067249&gpsPoints[3]=53.9119982,19.9279895&gpsPoints[4]=53.1219648,18.0002529&gpsRadius=50&offset=0&positionIds=7632' 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.71 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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
8	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: [`1783000538 [ "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 > 1783000538 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.70 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	0.79 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.79 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.72 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.85 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.74 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	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
16	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: [`1783000538 [ "document_1\x00tags\x00" "asset_431\x00tags\x00" "asset_528\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_592\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0', 'asset_431\0tags\0', 'asset_528\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_592\0tags\0', 'asset_136\0tags\0', 'asset_130\0tags\0', 'asset_120\0tags\0', 'asset_7\0tags\0');
17	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1', 'document_properties_1');
18	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: [`1783000538 [ "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 > 1783000538 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.78 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	2.22 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,:city__id1,:city__id2,:city__id3,:city__id4) 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 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat1 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat1 * PI() / 180) * POWER(SIN((:gpsLon1 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius1 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat2 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat2 * PI() / 180) * POWER(SIN((:gpsLon2 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius2 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat3 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat3 * PI() / 180) * POWER(SIN((:gpsLon3 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius3 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat4 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat4 * PI() / 180) * POWER(SIN((:gpsLon4 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius4 )) 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" => "7632" "city__id0" => "485" "city__id1" => "394" "city__id2" => "558" "city__id3" => "5779" "city__id4" => "388" "gpsLat0" => 54.5164982 "gpsLon0" => 18.5402738 "gpsRadius0" => 50 "gpsLat1" => 54.3482907 "gpsLon1" => 18.6540233 "gpsRadius1" => 50 "gpsLat2" => 52.2319581 "gpsLon2" => 21.0067249 "gpsRadius2" => 50 "gpsLat3" => 53.9119982 "gpsLon3" => 19.9279895 "gpsRadius3" => 50 "gpsLat4" => 53.1219648 "gpsLon4" => 18.0002529 "gpsRadius4" => 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, :city__id1, :city__id2, :city__id3, :city__id4 ) 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 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat1 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat1 * PI() / 180 ) * POWER( SIN( ( :gpsLon1 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius1 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat2 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat2 * PI() / 180 ) * POWER( SIN( ( :gpsLon2 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius2 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat3 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat3 * PI() / 180 ) * POWER( SIN( ( :gpsLon3 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius3 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat4 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat4 * PI() / 180 ) * POWER( SIN( ( :gpsLon4 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius4 ) ) 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 ('7632') AND (city__id IN ('485','394','558','5779','388') OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((54.5164982 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(54.5164982 * PI() / 180) * POWER(SIN((18.5402738 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 ) 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 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((52.2319581 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(52.2319581 * PI() / 180) * POWER(SIN((21.0067249 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((53.9119982 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(53.9119982 * PI() / 180) * POWER(SIN((19.9279895 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((53.1219648 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(53.1219648 * PI() / 180) * POWER(SIN((18.0002529 - 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	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: [`1783000538 [ "\x00tags\x00object_8532" "object_8532" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8532', 'object_8532');
22	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: [`1783000538 [ "object_8532\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8532\0tags\0', 'class_mobile_job_offer\0tags\0');
23	0.97 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: [`1783000538 [ "\x00tags\x00object_8508" "object_8508" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8508', 'object_8508');
24	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: [`1783000538 [ "object_8508\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8508\0tags\0', 'class_mobile_job_offer\0tags\0');
25	0.89 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: [`1783000538 [ "\x00tags\x00object_8496" "object_8496" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8496', 'object_8496');
26	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: [`1783000538 [ "object_8496\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8496\0tags\0', 'class_mobile_job_offer\0tags\0');
27	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: [`1783000538 [ "\x00tags\x00object_8450" "object_8450" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8450', 'object_8450');
28	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: [`1783000538 [ "object_8450\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8450\0tags\0', 'class_mobile_job_offer\0tags\0');
29	0.94 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: [`1783000538 [ "\x00tags\x00object_8400" "object_8400" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8400', 'object_8400');
30	0.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: [`1783000538 [ "object_8400\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8400\0tags\0', 'class_mobile_job_offer\0tags\0');
31	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: [`1783000538 [ "\x00tags\x00object_8382" "object_8382" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8382', 'object_8382');
32	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: [`1783000538 [ "object_8382\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8382\0tags\0', 'class_mobile_job_offer\0tags\0');
33	0.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: [`1783000538 [ "\x00tags\x00object_8358" "object_8358" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8358', 'object_8358');
34	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: [`1783000538 [ "object_8358\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8358\0tags\0', 'class_mobile_job_offer\0tags\0');
35	0.89 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: [`1783000538 [ "\x00tags\x00object_8314" "object_8314" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8314', 'object_8314');
36	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: [`1783000538 [ "object_8314\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8314\0tags\0', 'class_mobile_job_offer\0tags\0');
37	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: [`1783000538 [ "\x00tags\x00object_8163" "object_8163" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8163', 'object_8163');
38	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: [`1783000538 [ "object_8163\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8163\0tags\0', 'class_mobile_job_offer\0tags\0');
39	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: [`1783000538 [ "\x00tags\x00object_8115" "object_8115" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8115', 'object_8115');
40	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: [`1783000538 [ "object_8115\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8115\0tags\0', 'class_mobile_job_offer\0tags\0');
41	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: [`1783000538 [ "\x00tags\x00object_8101" "object_8101" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8101', 'object_8101');
42	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: [`1783000538 [ "object_8101\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8101\0tags\0', 'class_mobile_job_offer\0tags\0');
43	0.72 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';
44	1.01 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: [`1783000538 [ "\x00tags\x00object_8211" "object_8211" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_8211', 'object_8211');
45	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: [`1783000538 [ "object_8211\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8211\0tags\0', 'class_4\0tags\0');
46	14.71 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: [`1783000538 [ "\x00tags\x00object_7632" "object_7632" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7632', 'object_7632');
47	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: [`1783000538 [ "object_7632\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7632\0tags\0', 'class_position\0tags\0');
48	0.97 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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7635', 'object_7635');
49	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7635\0tags\0', 'class_contract_type\0tags\0');
50	1.87 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';
51	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_485', 'object_485');
52	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_485\0tags\0', 'class_3\0tags\0');
53	0.95 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8532 "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 = 8532 AND fieldname = 'workingDays' ORDER BY `index` ASC;
54	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: [`1783000538 [ "\x00tags\x00object_449" "object_449" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_449', 'object_449');
55	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: [`1783000538 [ "object_449\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_449\0tags\0', 'class_4\0tags\0');
56	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_394', 'object_394');
57	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_394\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: [`8508 "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 = 8508 AND fieldname = 'workingDays' ORDER BY `index` ASC;
59	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3834', 'object_3834');
60	0.97 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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3834\0tags\0', 'class_4\0tags\0');
61	0.89 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8496 "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 = 8496 AND fieldname = 'workingDays' ORDER BY `index` ASC;
62	0.89 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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_448', 'object_448');
63	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_448\0tags\0', 'class_4\0tags\0');
64	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_416', 'object_416');
65	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_416\0tags\0', 'class_3\0tags\0');
66	0.88 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8450 "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 = 8450 AND fieldname = 'workingDays' ORDER BY `index` ASC;
67	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: [`1783000538 [ "\x00tags\x00object_513" "object_513" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_513', 'object_513');
68	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: [`1783000538 [ "object_513\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_513\0tags\0', 'class_4\0tags\0');
69	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7637', 'object_7637');
70	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7637\0tags\0', 'class_contract_type\0tags\0');
71	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: [`1783000538 [ "\x00tags\x00object_512" "object_512" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_512', 'object_512');
72	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: [`1783000538 [ "object_512\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_512\0tags\0', 'class_3\0tags\0');
73	9.00 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8400 "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 = 8400 AND fieldname = 'workingDays' ORDER BY `index` ASC;
74	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_411', 'object_411');
75	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_411\0tags\0', 'class_4\0tags\0');
76	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: [`1783000538 [ "\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_410', 'object_410');
77	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: [`1783000538 [ "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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_410\0tags\0', 'class_3\0tags\0');
78	0.88 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8382 "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 = 8382 AND fieldname = 'workingDays' ORDER BY `index` ASC;
79	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: [`1783000538 [ "\x00tags\x00object_7392" "object_7392" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7392', 'object_7392');
80	0.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: [`1783000538 [ "object_7392\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7392\0tags\0', 'class_4\0tags\0');
81	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: [`1783000538 [ "\x00tags\x00object_408" "object_408" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_408', 'object_408');
82	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: [`1783000538 [ "object_408\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_408\0tags\0', 'class_3\0tags\0');
83	0.86 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8358 "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 = 8358 AND fieldname = 'workingDays' ORDER BY `index` ASC;
84	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: [`1783000538 [ "\x00tags\x00object_4577" "object_4577" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_4577', 'object_4577');
85	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: [`1783000538 [ "object_4577\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4577\0tags\0', 'class_4\0tags\0');
86	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: [`1783000538 [ "\x00tags\x00object_569" "object_569" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_569', 'object_569');
87	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: [`1783000538 [ "object_569\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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_569\0tags\0', 'class_3\0tags\0');
88	0.88 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8314 "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 = 8314 AND fieldname = 'workingDays' ORDER BY `index` ASC;
89	5.07 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: [`1783000538 [ "\x00tags\x00object_395" "object_395" ]`] 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 > 1783000538 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_395', 'object_395');
90	1.41 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: [`1783000539 [ "object_395\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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_395\0tags\0', 'class_4\0tags\0');
91	1.16 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: [`1783000539 [ "\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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7636', 'object_7636');
92	1.19 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: [`1783000539 [ "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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7636\0tags\0', 'class_contract_type\0tags\0');
93	1.30 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8163 "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 = 8163 AND fieldname = 'workingDays' ORDER BY `index` ASC;
94	1.07 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: [`1783000539 [ "\x00tags\x00object_502" "object_502" ]`] 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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_502', 'object_502');
95	1.19 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: [`1783000539 [ "object_502\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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_502\0tags\0', 'class_4\0tags\0');
96	1.10 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: [`1783000539 [ "\x00tags\x00object_388" "object_388" ]`] 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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_388', 'object_388');
97	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: [`1783000539 [ "object_388\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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_388\0tags\0', 'class_3\0tags\0');
98	0.99 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8115 "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 = 8115 AND fieldname = 'workingDays' ORDER BY `index` ASC;
99	1.19 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: [`1783000539 [ "\x00tags\x00object_542" "object_542" ]`] 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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_542', 'object_542');
100	1.53 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: [`1783000539 [ "object_542\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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_542\0tags\0', 'class_4\0tags\0');
101	1.04 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: [`1783000539 [ "\x00tags\x00object_541" "object_541" ]`] 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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_541', 'object_541');
102	1.60 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: [`1783000539 [ "object_541\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 > 1783000539 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_541\0tags\0', 'class_3\0tags\0');
103	1.34 ms	SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`8101 "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 = 8101 AND fieldname = 'workingDays' ORDER BY `index` ASC;
104	2.27 ms	SELECT COUNT() FROM object_mobile_job_offer WHERE (position__id IN (:position__id0) AND (city__id IN (:city__id0,:city__id1,:city__id2,:city__id3,:city__id4) 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 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat1 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat1 * PI() / 180) * POWER(SIN((:gpsLon1 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius1 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat2 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat2 * PI() / 180) * POWER(SIN((:gpsLon2 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius2 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat3 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat3 * PI() / 180) * POWER(SIN((:gpsLon3 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius3 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((:gpsLat4 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(:gpsLat4 * PI() / 180) * POWER(SIN((:gpsLon4 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= :gpsRadius4 )) AND object_mobile_job_offer.o_type IN ('object','folder')) AND object_mobile_job_offer.o_published = 1 Parameters: [`"position__id0" => "7632" "city__id0" => "485" "city__id1" => "394" "city__id2" => "558" "city__id3" => "5779" "city__id4" => "388" "gpsLat0" => 54.5164982 "gpsLon0" => 18.5402738 "gpsRadius0" => 50 "gpsLat1" => 54.3482907 "gpsLon1" => 18.6540233 "gpsRadius1" => 50 "gpsLat2" => 52.2319581 "gpsLon2" => 21.0067249 "gpsRadius2" => 50 "gpsLat3" => 53.9119982 "gpsLon3" => 19.9279895 "gpsRadius3" => 50 "gpsLat4" => 53.1219648 "gpsLon4" => 18.0002529 "gpsRadius4" => 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, :city__id1, :city__id2, :city__id3, :city__id4 ) 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 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat1 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat1 * PI() / 180 ) * POWER( SIN( ( :gpsLon1 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius1 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat2 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat2 * PI() / 180 ) * POWER( SIN( ( :gpsLon2 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius2 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat3 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat3 * PI() / 180 ) * POWER( SIN( ( :gpsLon3 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius3 ) OR ( 6371 * 2 * ASIN( SQRT( POWER( SIN( (:gpsLat4 - coordinates__latitude) * PI() / 180 / 2 ), 2 ) + COS( coordinates__latitude * PI() / 180 ) * COS( :gpsLat4 * PI() / 180 ) * POWER( SIN( ( :gpsLon4 - coordinates__longitude ) * PI() / 180 / 2 ), 2 ) ) ) <= :gpsRadius4 ) ) 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 ('7632') AND (city__id IN ('485','394','558','5779','388') OR ( 6371 2 * ASIN( SQRT( POWER(SIN((54.5164982 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(54.5164982 * PI() / 180) * POWER(SIN((18.5402738 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 ) 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 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((52.2319581 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(52.2319581 * PI() / 180) * POWER(SIN((21.0067249 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((53.9119982 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(53.9119982 * PI() / 180) * POWER(SIN((19.9279895 - coordinates__longitude) * PI() / 180 / 2), 2) ) ) <= 50 ) OR ( 6371 * 2 * ASIN( SQRT( POWER(SIN((53.1219648 - coordinates__latitude) * PI() / 180 / 2), 2) + COS(coordinates__latitude * PI() / 180) * COS(53.1219648 * PI() / 180) * POWER(SIN((18.0002529 - 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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache