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 > 1726788065 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_55e88bf1c3d8e6e781db83b3bb9f6990', 'site_domain_55e88bf1c3d8e6e781db83b3bb9f6990');

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 292;

SELECT
  object_localized_CAR_en.o_id as o_id,
  object_localized_CAR_en.o_type as o_type
FROM
  object_localized_CAR_en
WHERE
  (
    object_localized_CAR_en.o_type IN ('object', 'folder')
  )
  AND object_localized_CAR_en.o_published = 1

SELECT object_localized_CAR_en.o_id as o_id, object_localized_CAR_en.o_type as o_type FROM object_localized_CAR_en WHERE ( object_localized_CAR_en.o_type IN ('object','folder')) AND object_localized_CAR_en.o_published = 1;

SELECT
  SQL_CALC_FOUND_ROWS a.o_id,
  priceSystemName
FROM
  shop_productindex a
WHERE
  active = 1
  AND o_virtualProductActive = 1
  AND inProductList = 1
  AND o_type = 'variant'
  AND (
    o_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.o_id, priceSystemName FROM shop_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND o_type = 'variant' AND (o_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 = '70'

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

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

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

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

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

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

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

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

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

SELECT
  COUNT(*)
FROM
  object_2
WHERE
  (reference = ?)
  AND (group__id = ?)
  AND object_2.o_type IN ('object', 'folder')

SELECT COUNT(*) FROM object_2 WHERE (reference = 'Austin-Healey')  AND (group__id = 960)  AND  object_2.o_type IN ('object','folder');

SELECT
  object_2.o_id as o_id,
  object_2.o_type as o_type
FROM
  object_2
WHERE
  (reference = ?)
  AND (group__id = ?)
  AND object_2.o_type IN ('object', 'folder')

SELECT object_2.o_id as o_id, object_2.o_type as o_type FROM object_2 WHERE (reference = 'Austin-Healey')  AND (group__id = 960)  AND  object_2.o_type IN ('object','folder');

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'thumb_218__5d969ca3bb7e8ceacab3bcacee7c5619';

SELECT
  o_id
FROM
  objects
WHERE
  o_path = :path
  AND `o_key` = :key

SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/Interest-Target-Groups/' AND `o_key` = 'Sports-Cars-Fan';

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 = '12'

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

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/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 = 'https://pimdemo.musicalstore2005.com/en/shop/Products/Spare-Parts/Austin-Healey-3000-Mk-II-Rims~p410' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'AP';

SELECT
  *
FROM
  targeting_rules
WHERE
  id = ?

SELECT * FROM targeting_rules WHERE id = 1;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :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 = '410'

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = '350'

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

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

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

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

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

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

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

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

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

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

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

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 = '13'

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

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 = '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 = '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 = '98'

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

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

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

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

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

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

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

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

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

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

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

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 = '353'

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

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

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

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

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

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 = '205'

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

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 = '249'

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

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 = '299'

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

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

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

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

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

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 = '203'

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

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

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

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

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

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

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

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 = '189'

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

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 = '196'

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

SELECT
  *
FROM
  ecommerceframework_pricing_rule
WHERE
  id = '10'

SELECT * FROM ecommerceframework_pricing_rule WHERE id='10';

SELECT
  FOUND_ROWS()

SELECT FOUND_ROWS();

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

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

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

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

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

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
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 12;

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 = '282'

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

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

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

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 = '224'

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

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

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

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  reference = ?
  and (calculated = 1)
  AND object_1.o_type IN ('object', 'folder')

SELECT COUNT(*) FROM object_1 WHERE reference = 'Interest Manufacturer' and (calculated = 1) AND  object_1.o_type IN ('object','folder');

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';