Symfony Profiler

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = ?
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='trendfairs-ticketshop.cloud.novodev.de' OR tl_page.dns=''));

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?
  OR tl_page.alias = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='index' OR tl_page.alias='/';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`id` = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=1 LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`id` = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=39 LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = ?
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='trendfairs-ticketshop.cloud.novodev.de' OR tl_page.dns=''));

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?
  OR tl_page.alias = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='index' OR tl_page.alias='/';

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  tl_layout.*
FROM
  tl_layout
WHERE
  tl_layout.`id` = ?
LIMIT
  0, 1

SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=2 LIMIT 0,1;

SELECT
  *
FROM
  tl_theme
WHERE
  tl_theme.`id` = ?
LIMIT
  0, 1

SELECT * FROM tl_theme WHERE tl_theme.`id`=2 LIMIT 0,1;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(16, 0, 15)
ORDER BY
  FIND_IN_SET(`tl_module`.`id`, '16,0,15')

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(16,0,15) ORDER BY FIND_IN_SET(`tl_module`.`id`, '16,0,15');

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pid = ?
  AND tl_article.inColumn = ?
  AND tl_article.published = '1'
  AND (
    tl_article.start = ''
    OR tl_article.start <= '1765255860'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1765255860'
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid=28 AND tl_article.inColumn='main' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1765255860') AND (tl_article.stop='' OR tl_article.stop>'1765255860') ORDER BY tl_article.sorting;

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND (
    tl_content.ptable = ?
    OR tl_content.ptable = ''
  )
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1765255860'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1765255860'
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

SELECT tl_content.* FROM tl_content WHERE tl_content.pid=26 AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1765255860') AND (tl_content.stop='' OR tl_content.stop>'1765255860') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.`id` = ?
LIMIT
  0, 1

SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=12 LIMIT 0,1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'trendfairs_ticketshop'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  *
FROM
  tl_iso_attribute
WHERE
  tl_iso_attribute.type != ''
  AND tl_iso_attribute.field_name != ''

SELECT * FROM tl_iso_attribute WHERE tl_iso_attribute.type!='' AND tl_iso_attribute.field_name!='';

SELECT
  *
FROM
  tl_iso_attribute
WHERE
  tl_iso_attribute.type != ''
  AND tl_iso_attribute.field_name != ''

SELECT * FROM tl_iso_attribute WHERE tl_iso_attribute.type!='' AND tl_iso_attribute.field_name!='';

SELECT
  *
FROM
  tl_iso_label
WHERE
  tl_iso_label.`language` = ?

SELECT * FROM tl_iso_label WHERE tl_iso_label.`language`='de';

SELECT
  tl_iso_config.*
FROM
  tl_iso_config
WHERE
  (
    tl_iso_config.id =(
      SELECT
        iso_config
      FROM
        tl_page
      WHERE
        id = ?
    )
    OR tl_iso_config.fallback = '1'
  )
ORDER BY
  fallback

SELECT tl_iso_config.* FROM tl_iso_config WHERE (tl_iso_config.id=(SELECT iso_config FROM tl_page WHERE id=27) OR tl_iso_config.fallback='1') ORDER BY fallback;

SELECT
  COUNT(*) AS total
FROM
  tl_iso_product
WHERE
  language != ''

SELECT COUNT(*) AS total FROM tl_iso_product WHERE language!='';

SELECT
  COUNT(*) AS total
FROM
  tl_iso_producttype
WHERE
  variants = '1'

SELECT COUNT(*) AS total FROM tl_iso_producttype WHERE variants='1';

SELECT
  tl_iso_product.*,
  'de' AS language,
  IFNULL(
    translation.name, tl_iso_product.name
  ) AS name,
  IFNULL(
    translation.teaser, tl_iso_product.teaser
  ) AS teaser,
  IFNULL(
    translation.description, tl_iso_product.description
  ) AS description,
  IFNULL(
    translation.meta_title, tl_iso_product.meta_title
  ) AS meta_title,
  IFNULL(
    translation.meta_description, tl_iso_product.meta_description
  ) AS meta_description,
  IFNULL(
    translation.meta_keywords, tl_iso_product.meta_keywords
  ) AS meta_keywords,
  IFNULL(
    translation.images, tl_iso_product.images
  ) AS images,
  IFNULL(
    translation.ticketnote, tl_iso_product.ticketnote
  ) AS ticketnote,
  tl_iso_product.images AS images_fallback,
  GROUP_CONCAT(c.page_id) AS product_categories,
  c.sorting
FROM
  tl_iso_product
  LEFT OUTER JOIN tl_iso_product translation ON tl_iso_product.id = translation.pid
  AND translation.language = 'de'
  LEFT OUTER JOIN tl_iso_product_category c ON tl_iso_product.id = c.pid
WHERE
  tl_iso_product.language = ''
  AND tl_iso_product.published = '1'
  AND (
    tl_iso_product.start = ''
    OR tl_iso_product.start < '1765255860'
  )
  AND (
    tl_iso_product.stop = ''
    OR tl_iso_product.stop > '1765255920'
  )
  AND tl_iso_product.pid = 0
  AND c.page_id = 28
GROUP BY
  tl_iso_product.id,
  translation.id,
  c.id
ORDER BY
  c.sorting

SELECT tl_iso_product.*, 'de' AS language, IFNULL(translation.name, tl_iso_product.name) AS name, IFNULL(translation.teaser, tl_iso_product.teaser) AS teaser, IFNULL(translation.description, tl_iso_product.description) AS description, IFNULL(translation.meta_title, tl_iso_product.meta_title) AS meta_title, IFNULL(translation.meta_description, tl_iso_product.meta_description) AS meta_description, IFNULL(translation.meta_keywords, tl_iso_product.meta_keywords) AS meta_keywords, IFNULL(translation.images, tl_iso_product.images) AS images, IFNULL(translation.ticketnote, tl_iso_product.ticketnote) AS ticketnote, tl_iso_product.images AS images_fallback, GROUP_CONCAT(c.page_id) AS product_categories, c.sorting FROM tl_iso_product LEFT OUTER JOIN tl_iso_product translation ON tl_iso_product.id=translation.pid AND translation.language='de' LEFT OUTER JOIN tl_iso_product_category c ON tl_iso_product.id=c.pid WHERE tl_iso_product.language='' AND tl_iso_product.published='1' AND (tl_iso_product.start='' OR tl_iso_product.start<'1765255860') AND (tl_iso_product.stop='' OR tl_iso_product.stop>'1765255920') AND tl_iso_product.pid=0 AND c.page_id=28 GROUP BY tl_iso_product.id, translation.id, c.id ORDER BY c.sorting;

SELECT
  *
FROM
  tl_iso_producttype
WHERE
  tl_iso_producttype.`id` = ?
LIMIT
  0, 1

SELECT * FROM tl_iso_producttype WHERE tl_iso_producttype.`id`=1 LIMIT 0,1;

SELECT
  c.pid,
  GROUP_CONCAT(c.page_id) AS page_ids
FROM
  tl_iso_product_category c
  JOIN tl_page p ON c.page_id = p.id
WHERE
  p.type != 'error_403'
  AND p.type != 'error_404'
  AND p.published = '1'
  AND (
    p.start = ''
    OR p.start < '1765255860'
  )
  AND (
    p.stop = ''
    OR p.stop > '1765255920'
  )
GROUP BY
  c.pid

SELECT c.pid, GROUP_CONCAT(c.page_id) AS page_ids FROM tl_iso_product_category c JOIN tl_page p ON c.page_id=p.id WHERE p.type!='error_403' AND p.type!='error_404' AND p.published='1' AND (p.start='' OR p.start<'1765255860') AND (p.stop='' OR p.stop>'1765255920') GROUP BY c.pid;

SELECT
  tl_iso_product_price.*,
  GROUP_CONCAT(tl_iso_product_pricetier.min) AS tier_keys,
  GROUP_CONCAT(tl_iso_product_pricetier.price) AS tier_values
FROM
  tl_iso_product_price
  LEFT JOIN tl_iso_product_pricetier ON tl_iso_product_pricetier.pid = tl_iso_product_price.id
WHERE
  tl_iso_product_price.config_id = 0
  AND tl_iso_product_price.member_group = 0
  AND tl_iso_product_price.start = ''
  AND tl_iso_product_price.stop = ''
GROUP BY
  tl_iso_product_price.id

SELECT tl_iso_product_price.*, GROUP_CONCAT(tl_iso_product_pricetier.min) AS tier_keys, GROUP_CONCAT(tl_iso_product_pricetier.price) AS tier_values FROM tl_iso_product_price LEFT JOIN tl_iso_product_pricetier ON tl_iso_product_pricetier.pid = tl_iso_product_price.id WHERE tl_iso_product_price.config_id=0 AND tl_iso_product_price.member_group=0 AND tl_iso_product_price.start='' AND tl_iso_product_price.stop='' GROUP BY tl_iso_product_price.id;

SELECT
  *
FROM
  tl_iso_gallery
WHERE
  tl_iso_gallery.`id` = ?
LIMIT
  0, 1

SELECT * FROM tl_iso_gallery WHERE tl_iso_gallery.`id`=1 LIMIT 0,1;

SELECT
  a.field_name
FROM
  tl_iso_attribute a
  JOIN tl_iso_attribute_option o ON a.id = o.pid
WHERE
  a.optionsSource = 'table'
  AND o.ptable = 'tl_iso_attribute'
  AND o.published = '1'
  AND o.price != ''
UNION
SELECT
  a.field_name
FROM
  tl_iso_attribute a
  JOIN tl_iso_attribute_option o ON a.field_name = o.field_name
WHERE
  a.optionsSource = 'product'
  AND o.ptable = 'tl_iso_product'
  AND o.published = '1'
  AND o.price != ''

SELECT a.field_name
                FROM tl_iso_attribute a
                JOIN tl_iso_attribute_option o ON a.id=o.pid
                WHERE
                  a.optionsSource='table'
                  AND o.ptable='tl_iso_attribute'
                  AND o.published='1'
                  AND o.price!=''

                UNION

                SELECT a.field_name
                FROM tl_iso_attribute a
                JOIN tl_iso_attribute_option o ON a.field_name=o.field_name
                WHERE
                  a.optionsSource='product'
                  AND o.ptable='tl_iso_product'
                  AND o.published='1'
                  AND o.price!='';

SELECT
  attributeName,
  attributeCondition
FROM
  tl_iso_rule
WHERE
  enabled = '1'
  AND productRestrictions = 'attribute'
  AND attributeName != ''
GROUP BY
  attributeName,
  attributeCondition

SELECT attributeName, attributeCondition FROM tl_iso_rule WHERE enabled='1' AND productRestrictions='attribute' AND attributeName!='' GROUP BY attributeName, attributeCondition;

SELECT
  *
FROM
  tl_iso_rule r
WHERE
  type = 'product'
  AND enabled = '1'
  AND (
    startDate = ''
    OR startDate <= UNIX_TIMESTAMP('2025-12-09 05:51:14')
  )
  AND (
    endDate = ''
    OR endDate >= UNIX_TIMESTAMP('2025-12-09 05:51:14')
  )
  AND (
    startTime = ''
    OR startTime <= UNIX_TIMESTAMP('1970-01-01 05:51:14')
  )
  AND (
    endTime = ''
    OR endTime >= UNIX_TIMESTAMP('1970-01-01 05:51:14')
  )
  AND (
    limitPerConfig = 0
    OR limitPerConfig >(
      SELECT
        COUNT(*)
      FROM
        tl_iso_rule_usage
      WHERE
        pid = r.id
        AND config_id = 2
        AND order_id NOT IN (
          SELECT
            id
          FROM
            tl_iso_product_collection
          WHERE
            type = 'order'
            AND source_collection_id = 0
        )
    )
  )
  AND (
    configRestrictions = ''
    OR (
      configRestrictions = '1'
      AND configCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'configs'
          AND object_id = 2
      )> 0
    )
    OR (
      configRestrictions = '1'
      AND configCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'configs'
          AND object_id = 2
      )= 0
    )
  )
  AND (
    memberRestrictions = 'none'
    OR (
      memberRestrictions = 'guests'
      AND memberCondition = '1'
    )
  )
  AND (
    productRestrictions = 'none'
    OR (
      productRestrictions = 'producttypes'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'producttypes'
          AND object_id IN (0, 1)
      )> 0
    )
    OR (
      productRestrictions = 'producttypes'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'producttypes'
          AND object_id IN (0, 1)
      )= 0
    )
    OR (
      productRestrictions = 'products'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'products'
          AND object_id IN (0, 10)
      )> 0
    )
    OR (
      productRestrictions = 'products'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'products'
          AND object_id IN (0, 10)
      )= 0
    )
    OR (
      productRestrictions = 'variants'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'variants'
          AND object_id IN (0, 10)
      )> 0
    )
    OR (
      productRestrictions = 'variants'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'variants'
          AND object_id IN (0, 10)
      )= 0
    )
    OR (
      productRestrictions = 'pages'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'pages'
          AND object_id IN (
            SELECT
              page_id
            FROM
              tl_iso_product_category
            WHERE
              pid IN (0, 10)
          )
      )> 0
    )
    OR (
      productRestrictions = 'pages'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'pages'
          AND object_id IN (
            SELECT
              page_id
            FROM
              tl_iso_product_category
            WHERE
              pid IN (0, 10)
          )
      )= 0
    )
  )

SELECT * FROM tl_iso_rule r WHERE type='product' AND enabled='1' AND (startDate='' OR startDate <= UNIX_TIMESTAMP('2025-12-09 05:51:14')) AND (endDate='' OR endDate >= UNIX_TIMESTAMP('2025-12-09 05:51:14')) AND (startTime='' OR startTime <= UNIX_TIMESTAMP('1970-01-01 05:51:14')) AND (endTime='' OR endTime >= UNIX_TIMESTAMP('1970-01-01 05:51:14')) AND (limitPerConfig=0 OR limitPerConfig>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND config_id=2 AND order_id NOT IN (SELECT id FROM tl_iso_product_collection WHERE type='order' AND source_collection_id=0))) AND (configRestrictions=''
                            OR (configRestrictions='1' AND configCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=2)>0)
                            OR (configRestrictions='1' AND configCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=2)=0)) AND (memberRestrictions='none' OR (memberRestrictions='guests' AND memberCondition='1')) AND (productRestrictions='none' OR (productRestrictions='producttypes' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (0,1))>0) OR (productRestrictions='producttypes' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (0,1))=0) OR (productRestrictions='products' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (0,10))>0) OR (productRestrictions='products' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (0,10))=0) OR (productRestrictions='variants' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (0,10))>0) OR (productRestrictions='variants' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (0,10))=0) OR (productRestrictions='pages' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_category WHERE pid IN (0,10)))>0) OR (productRestrictions='pages' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_category WHERE pid IN (0,10)))=0));

SELECT
  *
FROM
  tl_iso_address
WHERE
  pid = ?
  AND ptable = ?
  AND isDefaultBilling = ?
LIMIT
  0, 1

SELECT * FROM tl_iso_address WHERE pid=NULL AND ptable='tl_iso_product_collection' AND isDefaultBilling='1' LIMIT 0,1;

SELECT
  tl_iso_tax_class.*,
  j1.`id` AS includes__id,
  j1.`tstamp` AS includes__tstamp,
  j1.`name` AS includes__name,
  j1.`label` AS includes__label,
  j1.`address` AS includes__address,
  j1.`countries` AS includes__countries,
  j1.`subdivisions` AS includes__subdivisions,
  j1.`postalCodes` AS includes__postalCodes,
  j1.`rate` AS includes__rate,
  j1.`amount` AS includes__amount,
  j1.`config` AS includes__config,
  j1.`exemptOnValidVAT` AS includes__exemptOnValidVAT,
  j1.`stop` AS includes__stop,
  j1.`guests` AS includes__guests,
  j1.`protected` AS includes__protected,
  j1.`groups` AS includes__groups
FROM
  tl_iso_tax_class
  LEFT JOIN tl_iso_tax_rate j1 ON tl_iso_tax_class.`includes` = j1.id
WHERE
  tl_iso_tax_class.`id` = ?
LIMIT
  0, 1

SELECT tl_iso_tax_class.*, j1.`id` AS includes__id, j1.`tstamp` AS includes__tstamp, j1.`name` AS includes__name, j1.`label` AS includes__label, j1.`address` AS includes__address, j1.`countries` AS includes__countries, j1.`subdivisions` AS includes__subdivisions, j1.`postalCodes` AS includes__postalCodes, j1.`rate` AS includes__rate, j1.`amount` AS includes__amount, j1.`config` AS includes__config, j1.`exemptOnValidVAT` AS includes__exemptOnValidVAT, j1.`stop` AS includes__stop, j1.`guests` AS includes__guests, j1.`protected` AS includes__protected, j1.`groups` AS includes__groups FROM tl_iso_tax_class LEFT JOIN tl_iso_tax_rate j1 ON tl_iso_tax_class.`includes`=j1.id WHERE tl_iso_tax_class.`id`=1 LIMIT 0,1;

SELECT
  tl_iso_tax_rate.*
FROM
  tl_iso_tax_rate
WHERE
  tl_iso_tax_rate.`id` IN('1', '2', '4')
ORDER BY
  FIND_IN_SET(tl_iso_tax_rate.`id`, '1,2,4')

SELECT tl_iso_tax_rate.* FROM tl_iso_tax_rate WHERE tl_iso_tax_rate.`id` IN('1','2','4') ORDER BY FIND_IN_SET(tl_iso_tax_rate.`id`, '1,2,4');

SELECT
  tl_iso_tax_rate.*
FROM
  tl_iso_tax_rate
WHERE
  tl_iso_tax_rate.`id` IN('1', '2', '4')
ORDER BY
  FIND_IN_SET(tl_iso_tax_rate.`id`, '1,2,4')

SELECT tl_iso_tax_rate.* FROM tl_iso_tax_rate WHERE tl_iso_tax_rate.`id` IN('1','2','4') ORDER BY FIND_IN_SET(tl_iso_tax_rate.`id`, '1,2,4');

SELECT
  attributeName,
  attributeCondition
FROM
  tl_iso_rule
WHERE
  enabled = '1'
  AND productRestrictions = 'attribute'
  AND attributeName != ''
GROUP BY
  attributeName,
  attributeCondition

SELECT attributeName, attributeCondition FROM tl_iso_rule WHERE enabled='1' AND productRestrictions='attribute' AND attributeName!='' GROUP BY attributeName, attributeCondition;

SELECT
  *
FROM
  tl_iso_rule r
WHERE
  type = 'product'
  AND enabled = '1'
  AND (
    startDate = ''
    OR startDate <= UNIX_TIMESTAMP('2025-12-09 05:51:14')
  )
  AND (
    endDate = ''
    OR endDate >= UNIX_TIMESTAMP('2025-12-09 05:51:14')
  )
  AND (
    startTime = ''
    OR startTime <= UNIX_TIMESTAMP('1970-01-01 05:51:14')
  )
  AND (
    endTime = ''
    OR endTime >= UNIX_TIMESTAMP('1970-01-01 05:51:14')
  )
  AND (
    limitPerConfig = 0
    OR limitPerConfig >(
      SELECT
        COUNT(*)
      FROM
        tl_iso_rule_usage
      WHERE
        pid = r.id
        AND config_id = 2
        AND order_id NOT IN (
          SELECT
            id
          FROM
            tl_iso_product_collection
          WHERE
            type = 'order'
            AND source_collection_id = 0
        )
    )
  )
  AND (
    configRestrictions = ''
    OR (
      configRestrictions = '1'
      AND configCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'configs'
          AND object_id = 2
      )> 0
    )
    OR (
      configRestrictions = '1'
      AND configCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'configs'
          AND object_id = 2
      )= 0
    )
  )
  AND (
    memberRestrictions = 'none'
    OR (
      memberRestrictions = 'guests'
      AND memberCondition = '1'
    )
  )
  AND (
    productRestrictions = 'none'
    OR (
      productRestrictions = 'producttypes'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'producttypes'
          AND object_id IN (0, 1)
      )> 0
    )
    OR (
      productRestrictions = 'producttypes'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'producttypes'
          AND object_id IN (0, 1)
      )= 0
    )
    OR (
      productRestrictions = 'products'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'products'
          AND object_id IN (0, 10)
      )> 0
    )
    OR (
      productRestrictions = 'products'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'products'
          AND object_id IN (0, 10)
      )= 0
    )
    OR (
      productRestrictions = 'variants'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'variants'
          AND object_id IN (0, 10)
      )> 0
    )
    OR (
      productRestrictions = 'variants'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'variants'
          AND object_id IN (0, 10)
      )= 0
    )
    OR (
      productRestrictions = 'pages'
      AND productCondition = '1'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'pages'
          AND object_id IN (
            SELECT
              page_id
            FROM
              tl_iso_product_category
            WHERE
              pid IN (0, 10)
          )
      )> 0
    )
    OR (
      productRestrictions = 'pages'
      AND productCondition = '0'
      AND (
        SELECT
          COUNT(*)
        FROM
          tl_iso_rule_restriction
        WHERE
          pid = r.id
          AND type = 'pages'
          AND object_id IN (
            SELECT
              page_id
            FROM
              tl_iso_product_category
            WHERE
              pid IN (0, 10)
          )
      )= 0
    )
  )

SELECT * FROM tl_iso_rule r WHERE type='product' AND enabled='1' AND (startDate='' OR startDate <= UNIX_TIMESTAMP('2025-12-09 05:51:14')) AND (endDate='' OR endDate >= UNIX_TIMESTAMP('2025-12-09 05:51:14')) AND (startTime='' OR startTime <= UNIX_TIMESTAMP('1970-01-01 05:51:14')) AND (endTime='' OR endTime >= UNIX_TIMESTAMP('1970-01-01 05:51:14')) AND (limitPerConfig=0 OR limitPerConfig>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND config_id=2 AND order_id NOT IN (SELECT id FROM tl_iso_product_collection WHERE type='order' AND source_collection_id=0))) AND (configRestrictions=''
                            OR (configRestrictions='1' AND configCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=2)>0)
                            OR (configRestrictions='1' AND configCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=2)=0)) AND (memberRestrictions='none' OR (memberRestrictions='guests' AND memberCondition='1')) AND (productRestrictions='none' OR (productRestrictions='producttypes' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (0,1))>0) OR (productRestrictions='producttypes' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (0,1))=0) OR (productRestrictions='products' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (0,10))>0) OR (productRestrictions='products' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (0,10))=0) OR (productRestrictions='variants' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (0,10))>0) OR (productRestrictions='variants' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (0,10))=0) OR (productRestrictions='pages' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_category WHERE pid IN (0,10)))>0) OR (productRestrictions='pages' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM tl_iso_product_category WHERE pid IN (0,10)))=0));

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '8556c9b690f611edaad30242ac1b0013'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '8556c9b690f611edaad30242ac1b0013'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('8556c9b690f611edaad30242ac1b0013')) ORDER BY tl_files.uuid!=UNHEX('8556c9b690f611edaad30242ac1b0013');

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '8556c9b690f611edaad30242ac1b0013'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '8556c9b690f611edaad30242ac1b0013'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('8556c9b690f611edaad30242ac1b0013')) ORDER BY tl_files.uuid!=UNHEX('8556c9b690f611edaad30242ac1b0013');

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '6a4c248390f611edaad30242ac1b0013'
    ),
    UNHEX(
      '11a2ab16fe3411ee94c3960000fcfc10'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '6a4c248390f611edaad30242ac1b0013'
  ),
  tl_files.uuid != UNHEX(
    '11a2ab16fe3411ee94c3960000fcfc10'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('6a4c248390f611edaad30242ac1b0013'),UNHEX('11a2ab16fe3411ee94c3960000fcfc10')) ORDER BY tl_files.uuid!=UNHEX('6a4c248390f611edaad30242ac1b0013'), tl_files.uuid!=UNHEX('11a2ab16fe3411ee94c3960000fcfc10');

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '6a4c248390f611edaad30242ac1b0013'
    ),
    UNHEX(
      '11a2ab16fe3411ee94c3960000fcfc10'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '6a4c248390f611edaad30242ac1b0013'
  ),
  tl_files.uuid != UNHEX(
    '11a2ab16fe3411ee94c3960000fcfc10'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('6a4c248390f611edaad30242ac1b0013'),UNHEX('11a2ab16fe3411ee94c3960000fcfc10')) ORDER BY tl_files.uuid!=UNHEX('6a4c248390f611edaad30242ac1b0013'), tl_files.uuid!=UNHEX('11a2ab16fe3411ee94c3960000fcfc10');

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  BINARY tl_article.alias = ?
LIMIT
  0, 1

SELECT tl_article.* FROM tl_article WHERE BINARY tl_article.alias='siex-header-de' LIMIT 0,1;

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND (
    tl_content.ptable = ?
    OR tl_content.ptable = ''
  )
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1765255860'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1765255860'
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

SELECT tl_content.* FROM tl_content WHERE tl_content.pid=35 AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1765255860') AND (tl_content.stop='' OR tl_content.stop>'1765255860') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid = UNHEX(?)
LIMIT
  0, 1

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('9e8d1649fe3c11ee94c3960000fcfc10') LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id='31' LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id='62' LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id='74' LIMIT 0,1;

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  BINARY tl_article.alias = ?
LIMIT
  0, 1