Symfony Profiler

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_e9db6b779bbf6547aaec98e3a9cb2a0f');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/en/More-Stuff/Developers-Corner/Thumbnails' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/More-Stuff/Developers-Corner/Thumbnails' AND `type` = 'path_query') OR
                (source = 'https://magento.xerbdev.online/en/More-Stuff/Developers-Corner/Thumbnails' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) 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 > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/en/More-Stuff/Developers-Corner/' AND `key` = BINARY 'Thumbnails';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_39');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_39
tags
', 'asset_345
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0sites_path_mapping');

SELECT
  id
FROM
  sites
ORDER BY
  (
    SELECT
      LENGTH(`path`)
    FROM
      documents
    WHERE
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC ;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_39');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525491 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties
tags
', 'document_39
tags
');

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/More-Stuff/Developers-Corner/Thumbnails'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/More-Stuff/Developers-Corner/Thumbnails' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_3');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_3
tags
', 'document_1
tags
', 'asset_337
tags
', 'asset_3
tags
', 'asset_319
tags
', 'asset_361
tags
', 'asset_320
tags
', 'asset_318
tags
', 'asset_321
tags
', 'asset_224
tags
', 'asset_35
tags
', 'asset_211
tags
', 'asset_90
tags
', 'asset_58
tags
', 'asset_180
tags
', 'asset_124
tags
', 'asset_164
tags
', 'asset_81
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_33f722f5a981de05404856ca38cd1340');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output
tags
', 'navigation
tags
', 'document_74
tags
', 'document_97
tags
', 'document_45
tags
', 'document_99
tags
', 'document_100
tags
', 'document_101
tags
', 'document_102
tags
', 'document_103
tags
', 'document_104
tags
', 'document_123
tags
', 'document_46
tags
', 'document_65
tags
', 'document_200
tags
', 'document_54
tags
', 'document_55
tags
', 'document_56
tags
', 'document_57
tags
', 'document_53
tags
', 'document_48
tags
', 'document_52
tags
', 'document_112
tags
', 'document_49
tags
', 'document_113
tags
', 'document_39
tags
', 'document_121
tags
', 'document_50
tags
', 'document_38
tags
', 'document_51
tags
', 'document_118
tags
', 'document_115
tags
', 'document_199
tags
', 'document_58
tags
', 'document_95
tags
', 'document_110
tags
', 'document_193
tags
', 'document_194
tags
', 'document_195
tags
', 'document_94
tags
', 'document_88
tags
', 'document_47
tags
', 'document_12
tags
', 'document_11
tags
', 'document_30
tags
', 'document_10
tags
', 'document_59
tags
', 'document_108
tags
', 'document_198
tags
');

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translator
tags
', 'translator_website
tags
', 'translate
tags
');

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 39;

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId IN(?, ?)
UNION
SELECT
  sourceId AS id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId IN(39, 39) UNION SELECT sourceId AS id,"source" FROM documents_translations WHERE id = 39;

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'en';

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'de';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136
tags
', 'asset_337
tags
', 'asset_3
tags
', 'asset_319
tags
', 'asset_361
tags
', 'asset_320
tags
', 'asset_318
tags
', 'asset_321
tags
', 'asset_224
tags
', 'asset_35
tags
', 'asset_211
tags
', 'asset_90
tags
', 'asset_58
tags
', 'asset_180
tags
', 'asset_124
tags
', 'asset_164
tags
', 'asset_81
tags
');

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'fr';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/fr';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_d74f487a3074b19f20c1eac992827746');

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 39;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_341');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_341
tags
');

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 341;

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'exampleCover' AND scope = 'pimcore_image_thumbnails';

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 341;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp');

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'exampleContain' AND scope = 'pimcore_image_thumbnails';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'exampleFrame' AND scope = 'pimcore_image_thumbnails';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'exampleRotate' AND scope = 'pimcore_image_thumbnails';

INSERT INTO lock_keys (
  key_id, key_token, key_expiration
)
VALUES
  (
    ?,
    ?,
    UNIX_TIMESTAMP() + 300
  )

INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('de89ee91f2c05bf02bf460cab210e452c69709492ca5ad12590d5c3e279aec33', 'x3c/+CPy2a9C7YNA/Dwki7jgXRc64p/G8jieDsRaGrM=', UNIX_TIMESTAMP() + 300);

UPDATE
  lock_keys
SET
  key_expiration = UNIX_TIMESTAMP() + ?,
  key_token = ?
WHERE
  key_id = ?
  AND (
    key_token = ?
    OR key_expiration <= UNIX_TIMESTAMP()
  )

UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + 300, key_token = 'x3c/+CPy2a9C7YNA/Dwki7jgXRc64p/G8jieDsRaGrM=' WHERE key_id = 'de89ee91f2c05bf02bf460cab210e452c69709492ca5ad12590d5c3e279aec33' AND (key_token = 'x3c/+CPy2a9C7YNA/Dwki7jgXRc64p/G8jieDsRaGrM=' OR key_expiration <= UNIX_TIMESTAMP());

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP()

SELECT 1 FROM lock_keys WHERE key_id = 'de89ee91f2c05bf02bf460cab210e452c69709492ca5ad12590d5c3e279aec33' AND key_token = 'x3c/+CPy2a9C7YNA/Dwki7jgXRc64p/G8jieDsRaGrM=' AND key_expiration > UNIX_TIMESTAMP();

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_assets_image_thumbnail_cache');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727525492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'resource
tags
');

INSERT INTO assets_image_thumbnail_cache (
  `cid`, `name`, `filename`, `modificationDate`,
  `filesize`, `width`, `height`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (341, 'exampleRotate', 'Chevy parking.b75d6ce4.jpg', 1727525492, 116120, 291, 209);

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:26:\\\"messenger.bus.pimcore-core\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:38:\\\"Pimcore\\\\Messenger\\\\OptimizeImageMessage\\\":1:{s:7:\\\"\\0*\\0path\\\";s:93:\\\"/Sample Content/Example Images/341/image-thumb__341__exampleRotate/Chevy parking.b75d6ce4.jpg\\\";}}', '[]', 'pimcore_image_optimize', '2024-09-28 12:11:32', '2024-09-28 12:11:32');

"COMMIT"

"COMMIT";

DELETE FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?

DELETE FROM lock_keys WHERE key_id = 'de89ee91f2c05bf02bf460cab210e452c69709492ca5ad12590d5c3e279aec33' AND key_token = 'x3c/+CPy2a9C7YNA/Dwki7jgXRc64p/G8jieDsRaGrM=';

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP()

SELECT 1 FROM lock_keys WHERE key_id = 'de89ee91f2c05bf02bf460cab210e452c69709492ca5ad12590d5c3e279aec33' AND key_token = 'x3c/+CPy2a9C7YNA/Dwki7jgXRc64p/G8jieDsRaGrM=' AND key_expiration > UNIX_TIMESTAMP();

INSERT INTO assets_image_thumbnail_cache (
  `cid`, `name`, `filename`, `modificationDate`,
  `filesize`, `width`, `height`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (341, 'exampleRotate', 'Chevy parking.b75d6ce4.jpg', 1727525492, 116120, 291, 209);

UPDATE
  assets_image_thumbnail_cache
SET
  `cid` = ?,
  `name` = ?,
  `filename` = ?,
  `modificationDate` = ?,
  `filesize` = ?,
  `width` = ?,
  `height` = ?
WHERE
  `cid` = ?
  AND `name` = ?
  AND `filename` = ?

UPDATE assets_image_thumbnail_cache SET `cid` = 341, `name` = 'exampleRotate', `filename` = 'Chevy parking.b75d6ce4.jpg', `modificationDate` = 1727525492, `filesize` = 116120, `width` = 291, `height` = 209 WHERE `cid` = 341 AND `name` = 'exampleRotate' AND `filename` = 'Chevy parking.b75d6ce4.jpg';

INSERT INTO lock_keys (
  key_id, key_token, key_expiration
)
VALUES
  (
    ?,
    ?,
    UNIX_TIMESTAMP() + 300
  )

INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('8cf7d609b8c790600756aa1904616aed0d47a226c69c239e23d5a69e65225d7f', 'WmA5s2c+c/kMuNxP0H97nxFaSZcwsJljADnZXsbW01s=', UNIX_TIMESTAMP() + 300);

UPDATE
  lock_keys
SET
  key_expiration = UNIX_TIMESTAMP() + ?,
  key_token = ?
WHERE
  key_id = ?
  AND (
    key_token = ?
    OR key_expiration <= UNIX_TIMESTAMP()
  )

UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + 300, key_token = 'WmA5s2c+c/kMuNxP0H97nxFaSZcwsJljADnZXsbW01s=' WHERE key_id = '8cf7d609b8c790600756aa1904616aed0d47a226c69c239e23d5a69e65225d7f' AND (key_token = 'WmA5s2c+c/kMuNxP0H97nxFaSZcwsJljADnZXsbW01s=' OR key_expiration <= UNIX_TIMESTAMP());

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP()

SELECT 1 FROM lock_keys WHERE key_id = '8cf7d609b8c790600756aa1904616aed0d47a226c69c239e23d5a69e65225d7f' AND key_token = 'WmA5s2c+c/kMuNxP0H97nxFaSZcwsJljADnZXsbW01s=' AND key_expiration > UNIX_TIMESTAMP();

INSERT INTO assets_image_thumbnail_cache (
  `cid`, `name`, `filename`, `modificationDate`,
  `filesize`, `width`, `height`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (341, 'exampleRotate', 'Chevy parking.21457bd7.avif', 1727525493, 22157, 291, 209);

DELETE FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?

DELETE FROM lock_keys WHERE key_id = '8cf7d609b8c790600756aa1904616aed0d47a226c69c239e23d5a69e65225d7f' AND key_token = 'WmA5s2c+c/kMuNxP0H97nxFaSZcwsJljADnZXsbW01s=';

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP()

SELECT 1 FROM lock_keys WHERE key_id = '8cf7d609b8c790600756aa1904616aed0d47a226c69c239e23d5a69e65225d7f' AND key_token = 'WmA5s2c+c/kMuNxP0H97nxFaSZcwsJljADnZXsbW01s=' AND key_expiration > UNIX_TIMESTAMP();

INSERT INTO assets_image_thumbnail_cache (
  `cid`, `name`, `filename`, `modificationDate`,
  `filesize`, `width`, `height`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (341, 'exampleRotate', 'Chevy parking.21457bd7.avif', 1727525493, 22157, 291, 209);

UPDATE
  assets_image_thumbnail_cache
SET
  `cid` = ?,
  `name` = ?,
  `filename` = ?,
  `modificationDate` = ?,
  `filesize` = ?,
  `width` = ?,
  `height` = ?
WHERE
  `cid` = ?
  AND `name` = ?
  AND `filename` = ?

UPDATE assets_image_thumbnail_cache SET `cid` = 341, `name` = 'exampleRotate', `filename` = 'Chevy parking.21457bd7.avif', `modificationDate` = 1727525493, `filesize` = 22157, `width` = 291, `height` = 209 WHERE `cid` = 341 AND `name` = 'exampleRotate' AND `filename` = 'Chevy parking.21457bd7.avif';

INSERT INTO lock_keys (
  key_id, key_token, key_expiration
)
VALUES
  (
    ?,
    ?,
    UNIX_TIMESTAMP() + 300
  )

INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('79e0073dce2f2d5e051a2815d1f5ac99545d23ca12ae1aa5173bb0cf8288f026', 'j9WXqHXLXXP2RzFwK3Yqgc4hufTeoqWkaYMngu+4COw=', UNIX_TIMESTAMP() + 300);

UPDATE
  lock_keys
SET
  key_expiration = UNIX_TIMESTAMP() + ?,
  key_token = ?
WHERE
  key_id = ?
  AND (
    key_token = ?
    OR key_expiration <= UNIX_TIMESTAMP()
  )

UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + 300, key_token = 'j9WXqHXLXXP2RzFwK3Yqgc4hufTeoqWkaYMngu+4COw=' WHERE key_id = '79e0073dce2f2d5e051a2815d1f5ac99545d23ca12ae1aa5173bb0cf8288f026' AND (key_token = 'j9WXqHXLXXP2RzFwK3Yqgc4hufTeoqWkaYMngu+4COw=' OR key_expiration <= UNIX_TIMESTAMP());

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP()

SELECT 1 FROM lock_keys WHERE key_id = '79e0073dce2f2d5e051a2815d1f5ac99545d23ca12ae1aa5173bb0cf8288f026' AND key_token = 'j9WXqHXLXXP2RzFwK3Yqgc4hufTeoqWkaYMngu+4COw=' AND key_expiration > UNIX_TIMESTAMP();

INSERT INTO assets_image_thumbnail_cache (
  `cid`, `name`, `filename`, `modificationDate`,
  `filesize`, `width`, `height`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (341, 'exampleRotate', 'Chevy parking.b75d6ce4.webp', 1727525493, 22658, 291, 209);

DELETE FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?

DELETE FROM lock_keys WHERE key_id = '79e0073dce2f2d5e051a2815d1f5ac99545d23ca12ae1aa5173bb0cf8288f026' AND key_token = 'j9WXqHXLXXP2RzFwK3Yqgc4hufTeoqWkaYMngu+4COw=';

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP()

SELECT 1 FROM lock_keys WHERE key_id = '79e0073dce2f2d5e051a2815d1f5ac99545d23ca12ae1aa5173bb0cf8288f026' AND key_token = 'j9WXqHXLXXP2RzFwK3Yqgc4hufTeoqWkaYMngu+4COw=' AND key_expiration > UNIX_TIMESTAMP();

INSERT INTO assets_image_thumbnail_cache (
  `cid`, `name`, `filename`, `modificationDate`,
  `filesize`, `width`, `height`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (341, 'exampleRotate', 'Chevy parking.b75d6ce4.webp', 1727525493, 22658, 291, 209);

UPDATE
  assets_image_thumbnail_cache
SET
  `cid` = ?,
  `name` = ?,
  `filename` = ?,
  `modificationDate` = ?,
  `filesize` = ?,
  `width` = ?,
  `height` = ?
WHERE
  `cid` = ?
  AND `name` = ?
  AND `filename` = ?