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 > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_01985c713f4dc7390fd18e93e560a220');

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 10274;

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126221 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 = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

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

SELECT id FROM documents WHERE `path` = BINARY '/it/products/' AND `key` = BINARY 'zehntner-zrm-6014-rl-qd';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'IDSP1';

SELECT
  *
FROM
  object_relations_9
WHERE
  src_id = ?

SELECT * FROM object_relations_9 WHERE src_id = 15166;

SELECT
  *
FROM
  object_metadata_IDSP1
WHERE
  object_metadata_IDSP1.id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND (
    `type` = 'object'
    or `type` = ''
  )

SELECT * FROM object_metadata_IDSP1 WHERE object_metadata_IDSP1.id = 250 AND dest_id = 11933 AND fieldname = 'assetsDocuments' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1  AND (`type` = 'object' or `type` = '');

SELECT
  object_localized_IDSP1_it.id as id,
  object_localized_IDSP1_it.type as `type`
FROM
  object_localized_IDSP1_it
WHERE
  (
    `seofriendlyurl` = 'zehntner-zrm-6014-rl-qd'
    AND object_localized_IDSP1_it.type IN ('variant', 'object')
  )
  AND object_localized_IDSP1_it.published = 1
LIMIT
  1

SELECT object_localized_IDSP1_it.id as id, object_localized_IDSP1_it.type as `type` FROM object_localized_IDSP1_it WHERE (`seofriendlyurl` = 'zehntner-zrm-6014-rl-qd'  AND  object_localized_IDSP1_it.type IN ('variant','object')) AND object_localized_IDSP1_it.published = 1 LIMIT 1;

SELECT
  *
FROM
  object_relations_IDSPAVS1
WHERE
  src_id = ?

SELECT * FROM object_relations_IDSPAVS1 WHERE src_id = 423;

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19722
tags
', 'class_AMZWK1
tags
', 'asset_11352
tags
', 'asset_11353
tags
', 'asset_11354
tags
', 'asset_11355
tags
', 'asset_11356
tags
', 'asset_11357
tags
', 'asset_11417
tags
', 'asset_11418
tags
', 'asset_11365
tags
', 'asset_11366
tags
');

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 = '/it/products/zehntner-zrm-6014-rl-qd' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/it/products/zehntner-zrm-6014-rl-qd' AND `type` = 'path_query') OR
                (source = 'https://ds1.screeningeagle.com/it/products/zehntner-zrm-6014-rl-qd' 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
  COUNT(*)
FROM
  objects
WHERE
  (
    (
      classId IN (
        'AMZWK1', 'IDSAVV1', 'IDSD1', 'IDSN1'
      )
      AND id IN (
        SELECT
          cId
        FROM
          tags_assignment
        WHERE
          ctype = 'object'
          AND tagid in (15, 58, 2)
      )
    )
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1

SELECT COUNT(*) FROM objects WHERE ((classId IN ('AMZWK1','IDSAVV1','IDSD1','IDSN1') AND id IN (
            SELECT cId FROM tags_assignment WHERE ctype = 'object' AND tagid in (15,58,2) ))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1;

SELECT
  id
FROM
  objects
WHERE
  published = 1
  AND id IN (1501, 27039, 27038);

SELECT id FROM objects WHERE published=1 AND id IN (1501,27039,27038);;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 10264;

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_250
tags
', 'class_IDSP1
tags
', 'asset_5760
tags
', 'asset_1837
tags
', 'asset_5758
tags
');

SELECT
  *
FROM
  object_metadata_IDSP1
WHERE
  id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND (
    `type` = 'object'
    or `type` = ''
  )

SELECT * FROM object_metadata_IDSP1 WHERE id = 250 AND dest_id = 3033 AND fieldname = 'faqs' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1  AND (`type` = 'object' or `type` = '');

SELECT
  *
FROM
  object_relations_AMZWK1
WHERE
  src_id = ?

SELECT * FROM object_relations_AMZWK1 WHERE src_id = 36170;

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config
tags
', 'system
tags
', 'config
tags
', 'output
tags
', 'object_16
tags
', 'object_1780
tags
', 'asset_10274
tags
', 'asset_10586
tags
', 'asset_96
tags
', 'asset_95
tags
', 'asset_3755
tags
', 'asset_3754
tags
', 'asset_12860
tags
', 'asset_3688
tags
', 'asset_3801
tags
', 'asset_3843
tags
', 'asset_3186
tags
', 'object_2683
tags
', 'object_2684
tags
', 'object_2681
tags
', 'object_2682
tags
', 'object_2920
tags
', 'object_22233
tags
');

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 1169;

SELECT
  *
FROM
  object_relations_IDSPAVA1
WHERE
  src_id = ?

SELECT * FROM object_relations_IDSPAVA1 WHERE src_id = 2263;

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
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 > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6993
tags
', 'class_AMZWK1
tags
', 'asset_7170
tags
', 'asset_7171
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 > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_36170
tags
', 'class_AMZWK1
tags
', 'asset_12705
tags
', 'asset_12746
tags
', 'asset_12744
tags
', 'asset_12745
tags
', 'asset_12751
tags
', 'asset_12752
tags
', 'asset_12747
tags
', 'asset_12750
tags
', 'asset_12748
tags
');

SELECT
  *
FROM
  object_metadata_IDSP1
WHERE
  object_metadata_IDSP1.id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND `type` = 'asset'

SELECT * FROM object_metadata_IDSP1 WHERE object_metadata_IDSP1.id = 250 AND dest_id = 5760 AND fieldname = 'assetsImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1  AND `type` = 'asset';

SELECT
  id
FROM
  assets
WHERE
  `path` = BINARY ?
  AND `filename` = BINARY ?

SELECT id FROM assets WHERE `path` = BINARY '/_default_upload_bucket/' AND `filename` = BINARY 'road-brochure-mockup-banner@2x.png';

SELECT
  id
FROM
  objects
WHERE
  id IN (3033, 3907, 12005)

SELECT id FROM objects WHERE id IN (3033,3907,12005);

SELECT
  object_localized_IDSP1_it.id as id,
  object_localized_IDSP1_it.type as `type`
FROM
  object_localized_IDSP1_it
WHERE
  (
    parentId = ?
    AND object_localized_IDSP1_it.type IN ('variant')
  )
  AND object_localized_IDSP1_it.published = 1

SELECT object_localized_IDSP1_it.id as id, object_localized_IDSP1_it.type as `type` FROM object_localized_IDSP1_it WHERE (parentId = 250 AND  object_localized_IDSP1_it.type IN ('variant')) AND object_localized_IDSP1_it.published = 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 > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1169
tags
', 'asset_12691
tags
', 'asset_12693
tags
', 'asset_12695
tags
', 'asset_12703
tags
', 'asset_12692
tags
', 'asset_12696
tags
', 'asset_12702
tags
', 'asset_12704
tags
', 'asset_12689
tags
', 'asset_12690
tags
', 'asset_12697
tags
', 'asset_12698
tags
', 'asset_12854
tags
', 'asset_12851
tags
', 'asset_12853
tags
', 'asset_12701
tags
', 'asset_12699
tags
', 'asset_12700
tags
');

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 ('e09704435f68855e00ad7900fcf2168544621a12d03aacb3b3c09ca6eedd0f51', 'mJEIugE3IZkp2UASEm9Lwn8E43df5YKN7R42WaIBy8I=', UNIX_TIMESTAMP() + 300);

SELECT
  *
FROM
  object_relations_IDSD1
WHERE
  src_id = ?

SELECT * FROM object_relations_IDSD1 WHERE src_id = 11933;

DELETE FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?

DELETE FROM lock_keys WHERE key_id = 'e09704435f68855e00ad7900fcf2168544621a12d03aacb3b3c09ca6eedd0f51' AND key_token = 'mJEIugE3IZkp2UASEm9Lwn8E43df5YKN7R42WaIBy8I=';

SELECT
  id
FROM
  objects
WHERE
  published = 1
  AND id IN (2263, 2262, 2260, 2261, 133);

SELECT id FROM objects WHERE published=1 AND id IN (2263,2262,2260,2261,133);;

SELECT
  id
FROM
  objects
WHERE
  published = 1
  AND id IN (11933, 1342, 12000, 18301);

SELECT id FROM objects WHERE published=1 AND id IN (11933,1342,12000,18301);;

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output
tags
', 'navigation
tags
', 'document_10676
tags
', 'document_10684
tags
', 'document_10692
tags
', 'document_10700
tags
', 'document_10708
tags
', 'document_10716
tags
', 'document_10668
tags
', 'document_10741
tags
', 'document_10749
tags
', 'document_10757
tags
', 'document_10767
tags
', 'document_12341
tags
', 'document_12478
tags
', 'document_10775
tags
', 'document_10783
tags
', 'document_10791
tags
', 'document_10733
tags
', 'document_11591
tags
', 'document_11592
tags
', 'document_10815
tags
', 'document_11593
tags
', 'document_10807
tags
', 'document_11594
tags
', 'document_11595
tags
', 'document_11583
tags
', 'document_11580
tags
', 'document_10948
tags
', 'document_10956
tags
', 'document_10964
tags
', 'document_10972
tags
', 'document_10831
tags
', 'document_10980
tags
', 'document_10988
tags
', 'document_10996
tags
', 'document_11004
tags
', 'document_10891
tags
', 'document_11012
tags
', 'document_11020
tags
', 'document_11028
tags
', 'document_11036
tags
', 'document_10899
tags
', 'document_11044
tags
', 'document_11052
tags
', 'document_11060
tags
', 'document_11068
tags
', 'document_11076
tags
', 'document_10907
tags
', 'document_11084
tags
', 'document_11092
tags
', 'document_11100
tags
', 'document_10915
tags
', 'document_11108
tags
', 'document_11116
tags
', 'document_10923
tags
', 'document_11124
tags
', 'document_11132
tags
', 'document_10931
tags
', 'document_11140
tags
', 'document_11148
tags
', 'document_11156
tags
', 'document_11241
tags
', 'document_10939
tags
', 'document_11766
tags
', 'document_7315
tags
', 'document_12093
tags
', 'document_12073
tags
', 'document_2960
tags
', 'document_12582
tags
', 'document_4553
tags
', 'document_12074
tags
', 'document_12046
tags
', 'document_12684
tags
', 'document_12075
tags
', 'document_1871
tags
', 'document_12089
tags
', 'document_12077
tags
', 'document_12079
tags
', 'document_12081
tags
', 'document_12083
tags
', 'document_12366
tags
', 'document_12713
tags
', 'document_12047
tags
', 'document_12531
tags
', 'document_12698
tags
', 'document_12103
tags
', 'document_12105
tags
', 'document_9945
tags
', 'document_12097
tags
', 'document_12099
tags
', 'document_12050
tags
', 'document_12064
tags
', 'document_12065
tags
', 'document_2084
tags
', 'document_12051
tags
', 'document_12107
tags
', 'document_12109
tags
', 'document_12543
tags
', 'document_12052
tags
', 'document_12053
tags
', 'document_7967
tags
', 'document_7991
tags
', 'document_12054
tags
', 'document_2228
tags
', 'document_2231
tags
', 'document_2232
tags
', 'document_2233
tags
', 'document_2234
tags
', 'document_2235
tags
', 'document_2237
tags
', 'document_2236
tags
', 'document_12048
tags
', 'document_12067
tags
', 'document_12066
tags
', 'document_12068
tags
', 'document_12055
tags
', 'document_12045
tags
', 'document_1777
tags
', 'document_2433
tags
', 'document_2139
tags
', 'document_2148
tags
', 'document_3005
tags
', 'document_9015
tags
', 'document_1308
tags
', 'document_12378
tags
', 'document_7300
tags
', 'document_1123
tags
', 'document_2823
tags
', 'document_2922
tags
', 'document_8049
tags
', 'document_8656
tags
', 'document_8858
tags
', 'document_1132
tags
', 'document_2814
tags
', 'document_1316
tags
', 'document_2931
tags
', 'document_1319
tags
', 'document_4523
tags
', 'document_7183
tags
', 'document_9645
tags
', 'document_9653
tags
', 'document_5241
tags
', 'document_7089
tags
', 'document_7890
tags
', 'document_7891
tags
', 'document_7889
tags
', 'document_9027
tags
', 'document_2996
tags
', 'document_1272
tags
', 'document_2093
tags
', 'document_9928
tags
', 'document_9971
tags
', 'document_12475
tags
', 'document_1285
tags
', 'document_1299
tags
', 'document_9895
tags
', 'document_9956
tags
', 'document_2120
tags
', 'document_2987
tags
', 'document_13255
tags
', 'document_11470
tags
', 'document_12623
tags
', 'document_13247
tags
');

SELECT
  *
FROM
  object_metadata_9
WHERE
  object_metadata_9.id = ?
  AND dest_id = ?
  AND fieldname = ?
  AND ownertype = ?
  AND ownername = ?
  and position = ?
  and `index` = ?
  AND `type` = 'asset'

SELECT * FROM object_metadata_9 WHERE object_metadata_9.id = 15166 AND dest_id = 10264 AND fieldname = 'MainImageOrVideo' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1  AND `type` = 'asset';

SELECT
  objects.id as id,
  objects.type as `type`
FROM
  objects
WHERE
  (
    (
      classId IN (
        'AMZWK1', 'IDSAVV1', 'IDSD1', 'IDSN1'
      )
      AND id IN (
        SELECT
          cId
        FROM
          tags_assignment
        WHERE
          ctype = 'object'
          AND tagid in (15, 58, 2)
      )
    )
    AND objects.type IN ('object', 'variant', 'folder')
  )
  AND objects.published = 1
ORDER BY
  `modificationDate` DESC
LIMIT
  9

SELECT objects.id as id, objects.type as `type` FROM objects WHERE ((classId IN ('AMZWK1','IDSAVV1','IDSD1','IDSN1') AND id IN (
            SELECT cId FROM tags_assignment WHERE ctype = 'object' AND tagid in (15,58,2) ))  AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `modificationDate` DESC   LIMIT 9;

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

SELECT 1 FROM lock_keys WHERE key_id = 'e09704435f68855e00ad7900fcf2168544621a12d03aacb3b3c09ca6eedd0f51' AND key_token = 'mJEIugE3IZkp2UASEm9Lwn8E43df5YKN7R42WaIBy8I=' AND key_expiration > UNIX_TIMESTAMP();

SELECT
  id
FROM
  objects
WHERE
  published = 1
  AND id IN (3033, 3907, 12005);

SELECT id FROM objects WHERE published=1 AND id IN (3033,3907,12005);;

SELECT
  id
FROM
  objects
WHERE
  id IN (11933, 1342, 12000, 18301)

SELECT id FROM objects WHERE id IN (11933,1342,12000,18301);

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126221 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6304
tags
', 'class_AMZWK1
tags
', 'asset_8543
tags
', 'asset_8541
tags
', 'asset_8542
tags
', 'asset_8544
tags
', 'asset_8555
tags
', 'asset_8556
tags
');

SELECT
  *
FROM
  object_collection_ProductMarketingText_IDSP1
WHERE
  id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_ProductMarketingText_IDSP1 WHERE id = 250 AND fieldname = 'moreTextsWeb' ORDER BY `index` ASC;

SELECT
  id
FROM
  targeting_rules
WHERE
  active = 1
ORDER BY
  `prio` ASC

SELECT id FROM targeting_rules WHERE active = 1  ORDER BY `prio` ASC;

SELECT
  id
FROM
  assets
WHERE
  id IN (10257)

SELECT id FROM assets WHERE id IN (10257);

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'MainLogo'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT
  id
FROM
  assets
WHERE
  id IN (10408, 12049)

SELECT id FROM assets WHERE id IN (10408,12049);

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_12478
tags
', 'asset_9866
tags
', 'asset_9993
tags
', 'asset_9868
tags
', 'asset_9865
tags
', 'asset_9991
tags
', 'asset_9992
tags
', 'asset_9989
tags
', 'asset_9990
tags
', 'asset_9870
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 > 1764126222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_9945
tags
', 'asset_9456
tags
', 'asset_9473
tags
', 'asset_9472
tags
', 'asset_9471
tags
', 'asset_9470
tags
', 'asset_9126
tags
', 'asset_9125
tags
', 'asset_9682
tags
', 'asset_9678
tags
', 'asset_9684
tags
', 'asset_9464
tags
', 'asset_9459
tags
', 'asset_9460
tags
', 'asset_9463
tags
', 'asset_9461
tags
', 'asset_9462
tags
');

SELECT
  id
FROM
  assets
WHERE
  id IN (10264)

SELECT id FROM assets WHERE id IN (10264);

SELECT
  id
FROM
  objects
WHERE
  id IN (1501, 27039, 27038)

SELECT id FROM objects WHERE id IN (1501,27039,27038);

SELECT
  *
FROM
  tags
WHERE
  id = ?

SELECT * FROM tags WHERE id = 2;

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764126222 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_9015
tags
', 'document_7948
tags
', 'asset_3066
tags
', 'asset_8952
tags
', 'asset_8947
tags
', 'asset_8951
tags
', 'asset_8948
tags
', 'asset_8949
tags
', 'asset_8950
tags
', 'asset_9063
tags
', 'asset_9057
tags
', 'asset_9060
tags
', 'asset_9061
tags
', 'asset_9062
tags
', 'asset_9059
tags
', 'asset_9058
tags
');

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 = 'mJEIugE3IZkp2UASEm9Lwn8E43df5YKN7R42WaIBy8I=' WHERE key_id = 'e09704435f68855e00ad7900fcf2168544621a12d03aacb3b3c09ca6eedd0f51' AND (key_token = 'mJEIugE3IZkp2UASEm9Lwn8E43df5YKN7R42WaIBy8I=' OR key_expiration <= UNIX_TIMESTAMP());

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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;

SELECT
  *
FROM
  object_relations_IDSP1
WHERE
  src_id = ?

SELECT * FROM object_relations_IDSP1 WHERE src_id = 250;

SELECT
  *
FROM
  targeting_rules
WHERE
  id = ?

SELECT * FROM targeting_rules WHERE id = 2;