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

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 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
  *
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 = '6'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/fruit-juices/tomato-juice' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/fruit-juices/tomato-juice' AND `type` = 'path_query') OR
                (source = 'http://realfruitpower.daburuat.com/fruit-juices/tomato-juice' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' 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 > 1735266197 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 > 1735266197 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 '/RealFruit/fruit-juices/' AND `key` = BINARY 'tomato-juice';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/RealFruit/fruit-juices/tomato-juice';

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/RealFruit/%' AND documents_page.prettyUrl = '/fruit-juices/tomato-juice';

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

SELECT id FROM documents WHERE `path` = BINARY '/RealFruit/' AND `key` = BINARY 'fruit-juices';

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

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

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_205
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_205');

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

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

SELECT
  object_rf_fruitjuice.id as id,
  object_rf_fruitjuice.type as `type`
FROM
  object_rf_fruitjuice
WHERE
  (
    object_rf_fruitjuice.type IN ('object', 'variant', 'folder')
  )
  AND object_rf_fruitjuice.published = 1

SELECT object_rf_fruitjuice.id as id, object_rf_fruitjuice.type as `type` FROM object_rf_fruitjuice WHERE ( object_rf_fruitjuice.type IN ('object','variant','folder')) AND object_rf_fruitjuice.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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_99');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_99
tags
', 'class_rf_fruitjuice
tags
', 'asset_339
tags
', 'asset_155
tags
', 'asset_373
tags
', 'asset_340
tags
', 'asset_346
tags
', 'asset_737
tags
', 'asset_844
tags
', 'asset_856
tags
', 'asset_1082
tags
', 'asset_642
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_184');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_184
tags
', 'class_rf_fruitjuice
tags
', 'asset_365
tags
', 'asset_367
tags
', 'asset_795
tags
', 'asset_364
tags
', 'asset_799
tags
', 'asset_794
tags
', 'asset_852
tags
', 'asset_857
tags
', 'asset_1099
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_185');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_185
tags
', 'class_rf_fruitjuice
tags
', 'asset_375
tags
', 'asset_372
tags
', 'asset_374
tags
', 'asset_371
tags
', 'asset_801
tags
', 'asset_802
tags
', 'asset_380
tags
', 'asset_1076
tags
', 'asset_1107
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_186');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_186
tags
', 'class_rf_fruitjuice
tags
', 'asset_381
tags
', 'asset_382
tags
', 'asset_805
tags
', 'asset_384
tags
', 'asset_804
tags
', 'asset_807
tags
', 'asset_853
tags
', 'asset_858
tags
', 'asset_1108
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_187');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_187
tags
', 'class_rf_fruitjuice
tags
', 'asset_390
tags
', 'asset_388
tags
', 'asset_811
tags
', 'asset_394
tags
', 'asset_809
tags
', 'asset_812
tags
', 'asset_851
tags
', 'asset_1078
tags
', 'asset_1109
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_188');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_188
tags
', 'class_rf_fruitjuice
tags
', 'asset_395
tags
', 'asset_396
tags
', 'asset_398
tags
', 'asset_401
tags
', 'asset_403
tags
', 'asset_404
tags
', 'asset_845
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_189');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_189
tags
', 'class_rf_fruitjuice
tags
', 'asset_405
tags
', 'asset_406
tags
', 'asset_815
tags
', 'asset_407
tags
', 'asset_412
tags
', 'asset_413
tags
', 'asset_846
tags
', 'asset_1083
tags
', 'asset_1084
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_191');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_191
tags
', 'class_rf_fruitjuice
tags
', 'asset_414
tags
', 'asset_415
tags
', 'asset_424
tags
', 'asset_416
tags
', 'asset_420
tags
', 'asset_423
tags
', 'asset_847
tags
', 'asset_1085
tags
', 'asset_1086
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_240');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_240
tags
', 'class_rf_fruitjuice
tags
', 'asset_426
tags
', 'asset_427
tags
', 'asset_796
tags
', 'asset_428
tags
', 'asset_432
tags
', 'asset_433
tags
', 'asset_848
tags
', 'asset_1087
tags
', 'asset_1088
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_244');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_244
tags
', 'class_rf_fruitjuice
tags
', 'asset_435
tags
', 'asset_434
tags
', 'asset_441
tags
', 'asset_436
tags
', 'asset_440
tags
', 'asset_442
tags
', 'asset_855
tags
', 'asset_1090
tags
', 'asset_1089
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_246');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_246
tags
', 'class_rf_fruitjuice
tags
', 'asset_443
tags
', 'asset_444
tags
', 'asset_449
tags
', 'asset_450
tags
', 'asset_854
tags
', 'asset_1091
tags
', 'asset_1092
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_248');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_248
tags
', 'class_rf_fruitjuice
tags
', 'asset_451
tags
', 'asset_452
tags
', 'asset_839
tags
', 'asset_453
tags
', 'asset_457
tags
', 'asset_458
tags
', 'asset_850
tags
', 'asset_1095
tags
', 'asset_1094
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_249');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_249
tags
', 'class_rf_fruitjuice
tags
', 'asset_459
tags
', 'asset_460
tags
', 'asset_841
tags
', 'asset_461
tags
', 'asset_465
tags
', 'asset_466
tags
', 'asset_1134
tags
', 'asset_1136
tags
', 'asset_1137
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19066');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19066
tags
', 'class_rf_fruitjuice
tags
', 'asset_459
tags
', 'asset_460
tags
', 'asset_841
tags
', 'asset_461
tags
', 'asset_465
tags
', 'asset_466
tags
', 'asset_849
tags
', 'asset_1098
tags
', 'asset_1097
tags
');

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

SELECT id FROM objects WHERE `path` = BINARY '/RealFruitJuice/RealFruit/' AND `key` = BINARY 'tomato-juice';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'rf_fruitjuice';

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

SELECT * FROM object_collection_fruitJuice_rf_fruitjuice WHERE id = 244 AND fieldname = 'fruitJuiceOverview' ORDER BY `index` ASC;

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

SELECT id FROM documents WHERE `path` = BINARY '/RealFruit/snippet/' AND `key` = BINARY 'header';

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

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

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_120
tags
', 'asset_249
tags
', 'asset_335
tags
', 'asset_252
tags
', 'asset_251
tags
', 'asset_1429
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_120');

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

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

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

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

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_119
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_59');

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_59
tags
', 'asset_962
tags
', 'asset_336
tags
', 'asset_337
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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_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 > 1735266197 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1
tags
');

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 119, 59)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,119,59) AND inheritable = 1) OR cid = 120
                             ) AND ctype='document';

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 = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/_fragment?_path=_format=html&_locale=en&_controller=RealFruitBundle%5CController%5CDefaultController%3A%3AheaderAction' AND `type` = 'path_query') OR
                (source = 'http://realfruitpower.daburuat.com/_fragment?_path=_format=html&_locale=en&_controller=RealFruitBundle%5CController%5CDefaultController%3A%3AheaderAction' 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
  object_rf_fruitjuice.id as id,
  object_rf_fruitjuice.type as `type`
FROM
  object_rf_fruitjuice
WHERE
  (
    object_rf_fruitjuice.type IN ('object', 'variant', 'folder')
  )
  AND object_rf_fruitjuice.published = 1
ORDER BY
  `creationDate` ASC

SELECT object_rf_fruitjuice.id as id, object_rf_fruitjuice.type as `type` FROM object_rf_fruitjuice WHERE ( object_rf_fruitjuice.type IN ('object','variant','folder')) AND object_rf_fruitjuice.published = 1 ORDER BY `creationDate` ASC  ;

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 120;

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

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

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 335;