Symfony Profiler

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

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

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 '/pimcore-graphql-webservices/' AND `key` = BINARY 'orchestrix-export';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

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

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

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

SELECT * FROM settings_store WHERE id = 'orchestrix-export' AND scope = 'pimcore_data_hub';

SELECT
  id,
  name
FROM
  classes

SELECT id, name FROM classes;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'Manufacturer';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '2';

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'Product';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '1';

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'Product';

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'Manufacturer';

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

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

SELECT
  COUNT(*)
FROM
  object_localized_1_en
  LEFT JOIN object_brick_query_ClothingCoat_1 `ClothingCoat` ON 1
  AND `ClothingCoat`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_ClothingCoat_1_en `ClothingCoat_localized` ON 1
  AND `ClothingCoat_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_ClothingHat_1 `ClothingHat` ON 1
  AND `ClothingHat`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_ClothingHat_1_en `ClothingHat_localized` ON 1
  AND `ClothingHat_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_ClothingShirt_1 `ClothingShirt` ON 1
  AND `ClothingShirt`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_ClothingShirt_1_en `ClothingShirt_localized` ON 1
  AND `ClothingShirt_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_Battery_1 `Battery` ON 1
  AND `Battery`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_Battery_1_en `Battery_localized` ON 1
  AND `Battery_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_CameraPhoto_1 `CameraPhoto` ON 1
  AND `CameraPhoto`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_CameraPhoto_1_en `CameraPhoto_localized` ON 1
  AND `CameraPhoto_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_Sports_1 `Sports` ON 1
  AND `Sports`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_Sports_1_en `Sports_localized` ON 1
  AND `Sports_localized`.ooo_id = `object_localized_1_en`.id
WHERE
  (
    (
      (
        SELECT
          `read`
        from
          `plugin_datahub_workspaces_object`
        WHERE
          `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
          AND LOCATE(
            CONCAT(
              `object_localized_1_en`.path, `object_localized_1_en`.key
            ),
            `plugin_datahub_workspaces_object`.cpath
          )= 1
        ORDER BY
          LENGTH(
            `plugin_datahub_workspaces_object`.cpath
          ) DESC
        LIMIT
          1
      ) = 1
      OR (
        SELECT
          `read`
        from
          `plugin_datahub_workspaces_object`
        WHERE
          `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
          AND LOCATE(
            `plugin_datahub_workspaces_object`.cpath,
            CONCAT(
              `object_localized_1_en`.path, `object_localized_1_en`.key
            )
          )= 1
        ORDER BY
          LENGTH(
            `plugin_datahub_workspaces_object`.cpath
          ) DESC
        LIMIT
          1
      ) = 1
    )
    AND (
      (
        `object_localized_1_en`.`modificationDate` > '1780708681'
      )
    )
    AND object_localized_1_en.type IN ('object', 'folder', 'variant')
  )
  AND object_localized_1_en.published = 1

SELECT COUNT(*) FROM object_localized_1_en LEFT JOIN object_brick_query_ClothingCoat_1 `ClothingCoat` ON 1
AND `ClothingCoat`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_ClothingCoat_1_en `ClothingCoat_localized` ON 1
AND `ClothingCoat_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_ClothingHat_1 `ClothingHat` ON 1
AND `ClothingHat`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_ClothingHat_1_en `ClothingHat_localized` ON 1
AND `ClothingHat_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_ClothingShirt_1 `ClothingShirt` ON 1
AND `ClothingShirt`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_ClothingShirt_1_en `ClothingShirt_localized` ON 1
AND `ClothingShirt_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_Battery_1 `Battery` ON 1
AND `Battery`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_Battery_1_en `Battery_localized` ON 1
AND `Battery_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_CameraPhoto_1 `CameraPhoto` ON 1
AND `CameraPhoto`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_CameraPhoto_1_en `CameraPhoto_localized` ON 1
AND `CameraPhoto_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_Sports_1 `Sports` ON 1
AND `Sports`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_Sports_1_en `Sports_localized` ON 1
AND `Sports_localized`.ooo_id = `object_localized_1_en`.id WHERE ( (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
                AND LOCATE(CONCAT(`object_localized_1_en`.path,`object_localized_1_en`.key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_1_en`.path,`object_localized_1_en`.key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            ) AND  ((`object_localized_1_en`.`modificationDate` > '1780708681') )  AND  object_localized_1_en.type IN ('object','folder','variant')) AND object_localized_1_en.published = 1;

SELECT
  object_localized_1_en.id as id,
  object_localized_1_en.type as `type`
FROM
  object_localized_1_en
  LEFT JOIN object_brick_query_ClothingCoat_1 `ClothingCoat` ON 1
  AND `ClothingCoat`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_ClothingCoat_1_en `ClothingCoat_localized` ON 1
  AND `ClothingCoat_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_ClothingHat_1 `ClothingHat` ON 1
  AND `ClothingHat`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_ClothingHat_1_en `ClothingHat_localized` ON 1
  AND `ClothingHat_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_ClothingShirt_1 `ClothingShirt` ON 1
  AND `ClothingShirt`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_ClothingShirt_1_en `ClothingShirt_localized` ON 1
  AND `ClothingShirt_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_Battery_1 `Battery` ON 1
  AND `Battery`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_Battery_1_en `Battery_localized` ON 1
  AND `Battery_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_CameraPhoto_1 `CameraPhoto` ON 1
  AND `CameraPhoto`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_CameraPhoto_1_en `CameraPhoto_localized` ON 1
  AND `CameraPhoto_localized`.ooo_id = `object_localized_1_en`.id
  LEFT JOIN object_brick_query_Sports_1 `Sports` ON 1
  AND `Sports`.id = `object_localized_1_en`.id
  LEFT JOIN object_brick_localized_query_Sports_1_en `Sports_localized` ON 1
  AND `Sports_localized`.ooo_id = `object_localized_1_en`.id
WHERE
  (
    (
      (
        SELECT
          `read`
        from
          `plugin_datahub_workspaces_object`
        WHERE
          `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
          AND LOCATE(
            CONCAT(
              `object_localized_1_en`.path, `object_localized_1_en`.key
            ),
            `plugin_datahub_workspaces_object`.cpath
          )= 1
        ORDER BY
          LENGTH(
            `plugin_datahub_workspaces_object`.cpath
          ) DESC
        LIMIT
          1
      ) = 1
      OR (
        SELECT
          `read`
        from
          `plugin_datahub_workspaces_object`
        WHERE
          `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
          AND LOCATE(
            `plugin_datahub_workspaces_object`.cpath,
            CONCAT(
              `object_localized_1_en`.path, `object_localized_1_en`.key
            )
          )= 1
        ORDER BY
          LENGTH(
            `plugin_datahub_workspaces_object`.cpath
          ) DESC
        LIMIT
          1
      ) = 1
    )
    AND (
      (
        `object_localized_1_en`.`modificationDate` > '1780708681'
      )
    )
    AND object_localized_1_en.type IN ('object', 'folder', 'variant')
  )
  AND object_localized_1_en.published = 1
LIMIT
  100

SELECT object_localized_1_en.id as id, object_localized_1_en.type as `type` FROM object_localized_1_en LEFT JOIN object_brick_query_ClothingCoat_1 `ClothingCoat` ON 1
AND `ClothingCoat`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_ClothingCoat_1_en `ClothingCoat_localized` ON 1
AND `ClothingCoat_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_ClothingHat_1 `ClothingHat` ON 1
AND `ClothingHat`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_ClothingHat_1_en `ClothingHat_localized` ON 1
AND `ClothingHat_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_ClothingShirt_1 `ClothingShirt` ON 1
AND `ClothingShirt`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_ClothingShirt_1_en `ClothingShirt_localized` ON 1
AND `ClothingShirt_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_Battery_1 `Battery` ON 1
AND `Battery`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_Battery_1_en `Battery_localized` ON 1
AND `Battery_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_CameraPhoto_1 `CameraPhoto` ON 1
AND `CameraPhoto`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_CameraPhoto_1_en `CameraPhoto_localized` ON 1
AND `CameraPhoto_localized`.ooo_id = `object_localized_1_en`.id LEFT JOIN object_brick_query_Sports_1 `Sports` ON 1
AND `Sports`.id = `object_localized_1_en`.id LEFT JOIN object_brick_localized_query_Sports_1_en `Sports_localized` ON 1
AND `Sports_localized`.ooo_id = `object_localized_1_en`.id WHERE ( (
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
                AND LOCATE(CONCAT(`object_localized_1_en`.path,`object_localized_1_en`.key),`plugin_datahub_workspaces_object`.cpath)=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            OR
            (
                SELECT `read` from `plugin_datahub_workspaces_object`
                WHERE `plugin_datahub_workspaces_object`.configuration = 'orchestrix-export'
                AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_1_en`.path,`object_localized_1_en`.key))=1
                ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC
                LIMIT 1
            )=1
            ) AND  ((`object_localized_1_en`.`modificationDate` > '1780708681') )  AND  object_localized_1_en.type IN ('object','folder','variant')) AND object_localized_1_en.published = 1 LIMIT 100;