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

SELECT
  *
FROM
  object_collection_Texts_localized_product
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_Texts_localized_product WHERE ooo_id = 6926 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Text' AND `index` = 0;

SELECT
  *
FROM
  object_collection_TextAndMedia_localized_webArticle
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_TextAndMedia_localized_webArticle WHERE ooo_id = 13250 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 1;

SELECT
  *
FROM
  object_collection_Texts_product
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Texts_product WHERE o_id = 6926 AND fieldname = 'Text' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_sdsWithLang_product
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_sdsWithLang_product WHERE o_id = 6926 AND fieldname = 'sdsWithLangs' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_pdsWithLang_product
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_pdsWithLang_product WHERE o_id = 6926 AND fieldname = 'pdsWithLangs' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_articlesBlock_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_articlesBlock_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_HTML_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_HTML_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_staticArticlesBlock_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_staticArticlesBlock_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_TextAndMedia_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_TextAndMedia_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_HeaderCarousel_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_HeaderCarousel_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_Header_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Header_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_Header_localized_webArticle
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_Header_localized_webArticle WHERE ooo_id = 13250 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 0;

SELECT
  *
FROM
  object_collection_Divider_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Divider_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_staticArticlesBlock_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_staticArticlesBlock_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_AnchorMenu_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_AnchorMenu_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_History_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_History_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_ProductPreview_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_ProductPreview_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_vacancyBlock_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_vacancyBlock_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_CategoryList_webArticle
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_CategoryList_webArticle WHERE o_id = 13250 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_TextAndMedia_localized_webPage
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_TextAndMedia_localized_webPage WHERE ooo_id = 13248 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 0;

SELECT
  *
FROM
  object_collection_PartnerSocialMedia_Partner
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_PartnerSocialMedia_Partner WHERE o_id = 13390 AND fieldname = 'SocialMedia' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_WhereToBuyHeader_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_WhereToBuyHeader_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_AnchorMenu_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_AnchorMenu_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_HTML_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_HTML_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_HeaderCarousel_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_HeaderCarousel_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_CategoryList_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_CategoryList_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_History_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_History_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_Divider_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Divider_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_Header_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Header_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  translations_admin
LIMIT
  1;

SELECT * FROM translations_admin LIMIT 1;;

SELECT
  *
FROM
  object_collection_ProductPreview_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_ProductPreview_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_TextAndMedia_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_TextAndMedia_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

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

SELECT * FROM object_metadata_webPage WHERE o_id = 13684 AND dest_id = 13683 AND fieldname = 'Events' AND ownertype = 'fieldcollection' AND ownername = 'Blocks' and position = '6' and `index` = 1  AND (type = 'object' or type = '');

SELECT
  *
FROM
  object_collection_articlesBlock_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_articlesBlock_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_vacancyBlock_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_vacancyBlock_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_staticArticlesBlock_localized_webPage
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_staticArticlesBlock_localized_webPage WHERE ooo_id = 13248 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 11;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'approvals';

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 13648 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

SELECT
  *
FROM
  object_collection_partnersMap_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_partnersMap_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_webFormField_localized_webForm
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_webFormField_localized_webForm WHERE ooo_id = 13851 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Fields' AND `index` = 0;

SELECT
  *
FROM
  object_collection_webForm_webPage
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_webForm_webPage WHERE o_id = 13248 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_Header_localized_webPage
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_Header_localized_webPage WHERE ooo_id = 13248 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 14;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'webPage';

SELECT
  *
FROM
  object_collection_articlesBlock_localized_webPage
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_articlesBlock_localized_webPage WHERE ooo_id = 13248 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 2;

SELECT
  *
FROM
  object_collection_staticArticlesBlock_localized_webArticle
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_staticArticlesBlock_localized_webArticle WHERE ooo_id = 14465 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 2;

SELECT
  *
FROM
  object_collection_HTML_localized_webPage
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_HTML_localized_webPage WHERE ooo_id = 13248 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 16;

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

SELECT id FROM documents WHERE path = BINARY '/pimcore-graphql-webservices/' AND `key` = BINARY 'webPages';

SELECT
  *
FROM
  object_collection_webFormField_webForm
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_webFormField_webForm WHERE o_id = 13851 AND fieldname = 'Fields' ORDER BY `index` ASC;

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 = '/pimcore-graphql-webservices/webPages' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/pimcore-graphql-webservices/webPages?apikey=0c2d01a7dd81e1f63bf3d3fed66e4029' AND `type` = 'path_query') OR
                (source = 'http://bizol-pim.com/pimcore-graphql-webservices/webPages?apikey=0c2d01a7dd81e1f63bf3d3fed66e4029' 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
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices/webPages';

SELECT
  *
FROM
  object_collection_CategoryList_localized_webPage
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_CategoryList_localized_webPage WHERE ooo_id = 13248 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 12;

SELECT
  *
FROM
  object_collection_HeaderCarousel_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_HeaderCarousel_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  COUNT(*)
FROM
  object_localized_category_en
WHERE
  (
    object_localized_category_en.o_type IN ('object', 'folder', 'variant')
  )
  AND object_localized_category_en.o_published = 1

SELECT COUNT(*) FROM object_localized_category_en WHERE ( object_localized_category_en.o_type IN ('object','folder','variant')) AND object_localized_category_en.o_published = 1;

SELECT
  *
FROM
  object_collection_AnchorMenu_localized_webPage
WHERE
  ooo_id = ?
  AND language IN (
    'en', 'de', 'es', 'ru', 'pl', 'uk', 'ar',
    'sl', 'hr', 'el', 'cs', 'sk', 'az',
    'uz'
  )
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_AnchorMenu_localized_webPage WHERE ooo_id = 13248 AND language IN ('en','de','es','ru','pl','uk','ar','sl','hr','el','cs','sk','az','uz') AND `fieldname` = 'Blocks' AND `index` = 1;

SELECT
  *
FROM
  object_collection_staticArticlesBlock_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_staticArticlesBlock_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_AnchorMenu_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_AnchorMenu_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  COUNT(*)
FROM
  object_localized_product_en
WHERE
  (
    object_localized_product_en.o_type IN ('object', 'folder', 'variant')
  )
  AND object_localized_product_en.o_published = 1

SELECT COUNT(*) FROM object_localized_product_en WHERE ( object_localized_product_en.o_type IN ('object','folder','variant')) AND object_localized_product_en.o_published = 1;

SELECT
  *
FROM
  object_collection_vacancyBlock_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_vacancyBlock_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_Divider_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Divider_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_CategoryList_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_CategoryList_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_History_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_History_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  id,
  name
FROM
  classes

SELECT id, name FROM classes;

SELECT
  *
FROM
  object_collection_webForm_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_webForm_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_articlesBlock_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_articlesBlock_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

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

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

SELECT
  *
FROM
  object_collection_WhereToBuyHeader_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_WhereToBuyHeader_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_ProductPreview_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_ProductPreview_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_TextAndMedia_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_TextAndMedia_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

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

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

SELECT
  *
FROM
  object_collection_Header_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_Header_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

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

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

SELECT
  COUNT(*)
FROM
  object_approvals
WHERE
  (
    object_approvals.o_type IN ('object', 'folder', 'variant')
  )
  AND object_approvals.o_published = 1

SELECT COUNT(*) FROM object_approvals WHERE ( object_approvals.o_type IN ('object','folder','variant')) AND object_approvals.o_published = 1;

SELECT
  *
FROM
  object_collection_HTML_extraFooter
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_HTML_extraFooter WHERE o_id = 13841 AND fieldname = 'Blocks' ORDER BY `index` ASC;

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

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

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

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

SELECT
  COUNT(*)
FROM
  object_webSettings
WHERE
  (
    object_webSettings.o_type IN ('object', 'folder', 'variant')
  )
  AND object_webSettings.o_published = 1

SELECT COUNT(*) FROM object_webSettings WHERE ( object_webSettings.o_type IN ('object','folder','variant')) AND object_webSettings.o_published = 1;

SELECT
  o_id
FROM
  objects
WHERE
  o_published = 1
  AND o_id IN (
    13683, 13685, 13687, 13690, 14497, 14498,
    14499, 14501, 14502, 14503, 14504,
    14505, 14506, 14508, 14509, 14510,
    14512, 14511, 14513, 14514, 14515,
    14516, 14517, 14518, 14519, 14520,
    14522, 14523, 14524, 14679
  );

SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (13683,13685,13687,13690,14497,14498,14499,14501,14502,14503,14504,14505,14506,14508,14509,14510,14512,14511,14513,14514,14515,14516,14517,14518,14519,14520,14522,14523,14524,14679);;

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

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

SELECT
  o_id
FROM
  objects
WHERE
  o_id IN (
    13683, 13685, 13687, 13690, 14497, 14498,
    14499, 14501, 14502, 14503, 14504,
    14505, 14506, 14508, 14509, 14510,
    14512, 14511, 14513, 14514, 14515,
    14516, 14517, 14518, 14519, 14520,
    14522, 14523, 14524, 14679
  )

SELECT o_id FROM objects WHERE o_id IN (13683,13685,13687,13690,14497,14498,14499,14501,14502,14503,14504,14505,14506,14508,14509,14510,14512,14511,14513,14514,14515,14516,14517,14518,14519,14520,14522,14523,14524,14679);

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

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

SELECT
  COUNT(*)
FROM
  object_localized_Country_en
WHERE
  (
    object_localized_Country_en.o_type IN ('object', 'folder', 'variant')
  )
  AND object_localized_Country_en.o_published = 1