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

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 292;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 292;

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

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

DELETE FROM
  tmp_store
WHERE
  id = ?

DELETE FROM tmp_store WHERE id = 'thumb_218__7706710bcf4969ee1986d39e03349e44';

INSERT INTO tmp_store (
  `id`, `data`, `tag`, `date`, `expiryDate`,
  `serialized`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO tmp_store (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES ('thumb_218__7706710bcf4969ee1986d39e03349e44', 'O:42:\"Pimcore\\Model\\Asset\\Image\\Thumbnail\\Config\":16:{s:8:\"\0*\0items\";a:2:{i:0;a:2:{s:6:\"method\";s:11:\"cropPercent\";s:9:\"arguments\";a:4:{s:5:\"width\";i:20;s:6:\"height\";d:32.05128205128205;s:1:\"y\";d:58.65384615384615;s:1:\"x\";d:44.4;}}i:1;a:2:{s:6:\"method\";s:12:\"scaleByWidth\";s:9:\"arguments\";a:2:{s:5:\"width\";i:700;s:11:\"forceResize\";b:0;}}}s:9:\"\0*\0medias\";a:0:{}s:7:\"\0*\0name\";s:52:\"product_detail_auto_c0807fedc24159e28c4332c7c94f1aef\";s:14:\"\0*\0description\";s:0:\"\";s:8:\"\0*\0group\";s:10:\"E-Commerce\";s:9:\"\0*\0format\";s:6:\"SOURCE\";s:10:\"\0*\0quality\";i:85;s:17:\"\0*\0highResolution\";d:2;s:16:\"\0*\0preserveColor\";b:0;s:19:\"\0*\0preserveMetaData\";b:0;s:15:\"\0*\0rasterizeSVG\";b:0;s:15:\"\0*\0downloadable\";b:0;s:19:\"\0*\0modificationDate\";i:1643107963;s:15:\"\0*\0creationDate\";i:1565167920;s:17:\"\0*\0filenameSuffix\";N;s:20:\"\0*\0preserveAnimation\";b:0;}', 'thumbnail_deferred', 1746638235, 1747243035, 1);

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '306'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '306';

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746638234 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_75
tags
', 'class_CAR
tags
', 'asset_60
tags
', 'asset_61
tags
');

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

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

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

SELECT object_localized_CAR_en.id AS id, object_localized_CAR_en.type AS `type` FROM object_localized_CAR_en WHERE ( object_localized_CAR_en.type IN ('object','variant','folder')) AND object_localized_CAR_en.published = 1;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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

SELECT id FROM documents WHERE `path` = BINARY '/en/shop/Products/Spare-Parts/' AND `key` = BINARY 'Austin-Healey-3000-Mk-II-Rims~p410';

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746638234 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_26
tags
', 'class_CAR
tags
', 'asset_22
tags
', 'asset_23
tags
', 'asset_24
tags
');

SELECT
  SQL_CALC_FOUND_ROWS a.id,
  priceSystemName
FROM
  shop_productindex a
WHERE
  active = 1
  AND virtualProductActive = 1
  AND inProductList = 1
  AND `type` = 'variant'
  AND (
    id IN (
      9,
      10,
      11,
      12,
      13,
      14,
      15,
      16,
      17,
      19,
      20,
      21,
      22,
      23,
      24,
      25,
      26,
      29,
      30,
      31,
      32,
      33,
      34,
      37,
      38,
      41,
      43,
      44,
      47,
      48,
      51,
      52,
      53,
      54,
      55,
      57,
      58,
      61,
      62,
      63,
      64,
      66,
      67,
      68,
      69,
      70,
      73,
      74,
      75,
      76,
      77,
      78,
      81,
      82,
      85,
      86,
      87,
      88,
      89,
      90,
      91,
      92,
      95,
      97,
      98,
      101,
      102,
      103,
      104,
      105,
      108,
      109,
      110,
      111,
      112,
      113,
      114,
      115,
      116,
      117,
      118,
      119,
      120,
      123,
      124,
      125,
      126,
      129,
      130,
      131,
      132,
      133,
      136,
      138,
      139,
      140,
      141,
      142,
      143,
      144,
      147,
      148,
      149,
      150,
      151,
      152,
      155,
      156,
      157,
      160,
      161,
      162,
      165,
      166,
      169,
      170,
      172,
      173,
      174,
      175,
      178,
      180,
      183,
      184,
      187,
      188,
      189,
      190,
      191,
      192,
      193,
      194,
      195,
      196,
      197,
      198,
      199,
      200,
      201,
      202,
      203,
      204,
      205,
      208,
      209,
      210,
      211,
      212,
      215,
      216,
      217,
      218,
      219,
      220,
      221,
      222,
      223,
      224,
      225,
      226,
      227,
      228,
      229,
      230,
      231,
      232,
      233,
      235,
      236,
      238,
      242,
      243,
      244,
      245,
      246,
      247,
      248,
      249,
      250,
      251,
      252,
      253,
      254,
      256,
      257,
      258,
      259,
      260,
      261,
      262,
      263,
      264,
      265,
      266,
      267,
      268,
      269,
      270,
      271,
      272,
      273,
      274,
      275,
      276,
      277,
      278,
      279,
      280,
      281,
      282,
      283,
      284,
      285,
      286,
      287,
      288,
      289,
      290,
      291,
      292,
      293,
      294,
      295,
      296,
      297,
      298,
      299,
      302,
      303,
      304,
      305,
      306,
      307,
      308,
      309,
      310,
      311,
      312,
      313,
      314,
      316,
      317,
      318,
      319,
      320,
      321,
      322,
      323,
      324,
      325,
      326,
      327,
      328,
      329,
      330,
      331,
      332,
      333,
      334,
      335,
      336,
      337,
      338,
      339,
      340,
      341,
      342,
      343,
      344,
      345,
      346,
      347,
      348,
      349,
      350,
      351,
      352,
      353,
      357,
      358,
      359,
      360,
      1094
    )
  )

SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (id IN (9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,29,30,31,32,33,34,37,38,41,43,44,47,48,51,52,53,54,55,57,58,61,62,63,64,66,67,68,69,70,73,74,75,76,77,78,81,82,85,86,87,88,89,90,91,92,95,97,98,101,102,103,104,105,108,109,110,111,112,113,114,115,116,117,118,119,120,123,124,125,126,129,130,131,132,133,136,138,139,140,141,142,143,144,147,148,149,150,151,152,155,156,157,160,161,162,165,166,169,170,172,173,174,175,178,180,183,184,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,208,209,210,211,212,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,235,236,238,242,243,244,245,246,247,248,249,250,251,252,253,254,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,302,303,304,305,306,307,308,309,310,311,312,313,314,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,357,358,359,360,1094)) ;

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '116'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '116';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products/Spare-Parts/Austin-Healey-3000-Mk-II-Rims~p410';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '149'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '149';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'AP';

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746638234 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19
tags
', 'class_CAR
tags
', 'asset_14
tags
', 'asset_15
tags
', 'asset_16
tags
', 'asset_17
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 = '/en/shop/Products/Spare-Parts/Austin-Healey-3000-Mk-II-Rims~p410' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/shop/Products/Spare-Parts/Austin-Healey-3000-Mk-II-Rims~p410' AND `type` = 'path_query') OR
                (source = 'http://159.203.89.10/en/shop/Products/Spare-Parts/Austin-Healey-3000-Mk-II-Rims~p410' 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
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '277'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '277';

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

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746638235 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('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
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '30'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '30';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '334'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '334';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '321'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '321';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '285'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '285';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '287'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '287';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '276'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '276';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '78'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '78';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '338'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '338';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '278'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '278';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '266'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '266';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '274'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '274';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '339'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '339';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '265'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '265';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '125'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '125';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '279'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '279';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '120'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '120';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '90'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '90';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '195'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '195';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '131'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '131';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '143'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '143';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '75'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '75';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '126'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '126';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '119'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '119';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '328'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '328';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '38'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '38';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '200'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '200';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '342'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '342';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '74'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '74';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '97'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '97';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '152'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '152';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '196'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '196';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '118'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '118';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '133'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '133';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '115'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '115';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '273'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '273';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '360'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '360';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '294'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '294';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '14'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '14';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '280'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '280';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '329'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '329';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '341'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '341';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '347'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '347';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '337'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '337';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '104'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '104';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '269'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '269';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '308'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '308';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '297'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '297';

SELECT
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '283'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '283';

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 = 'defaultTaxClass'
                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
  *
FROM
  object_url_slugs
WHERE
  fieldname = 'urlSlug'
  AND ownertype = 'object'
  AND objectId = '124'

SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '124';