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

SELECT
  *
FROM
  object_store_CrispCommodity
WHERE
  oo_id = ?

SELECT * FROM object_store_CrispCommodity WHERE oo_id = 406600;

SELECT
  objects.*,
  tree_locks.locked as o_locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.o_id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  o_id = ?

SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = 406600;

SELECT
  *
FROM
  object_relations_CrispCommodity
WHERE
  src_id = ?

SELECT * FROM object_relations_CrispCommodity WHERE src_id = 406600;

SELECT
  o_type,
  o_className,
  o_classId
FROM
  objects
WHERE
  o_id = ?

SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 406600;

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

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

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

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

SELECT o_id FROM objects WHERE o_path = '/' AND `o_key` = '';

SHOW COLUMNS
FROM
  versions

SHOW COLUMNS FROM versions;

INSERT INTO `objects` (
  `o_classId`, `o_className`, `o_published`,
  `o_id`, `o_parentId`, `o_type`, `o_key`,
  `o_path`, `o_index`, `o_creationDate`,
  `o_modificationDate`, `o_userOwner`,
  `o_userModification`, `o_childrenSortBy`,
  `o_childrenSortOrder`, `o_versionCount`
)
VALUES
  (
    :col0, :col1, :col2, :col3, :col4, :col5,
    :col6, :col7, :col8, :col9, :col10,
    :col11, :col12, :col13, :col14, :col15
  ) ON DUPLICATE KEY
UPDATE
  `o_classId` = :col0,
  `o_className` = :col1,
  `o_published` = :col2,
  `o_id` = :col3,
  `o_parentId` = :col4,
  `o_type` = :col5,
  `o_key` = :col6,
  `o_path` = :col7,
  `o_index` = :col8,
  `o_creationDate` = :col9,
  `o_modificationDate` = :col10,
  `o_userOwner` = :col11,
  `o_userModification` = :col12,
  `o_childrenSortBy` = :col13,
  `o_childrenSortOrder` = :col14,
  `o_versionCount` = :col15;

INSERT INTO `objects` (`o_classId`, `o_className`, `o_published`, `o_id`, `o_parentId`, `o_type`, `o_key`, `o_path`, `o_index`, `o_creationDate`, `o_modificationDate`, `o_userOwner`, `o_userModification`, `o_childrenSortBy`, `o_childrenSortOrder`, `o_versionCount`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13, :col14, :col15) ON DUPLICATE KEY UPDATE `o_classId` = :col0, `o_className` = :col1, `o_published` = :col2, `o_id` = :col3, `o_parentId` = :col4, `o_type` = :col5, `o_key` = :col6, `o_path` = :col7, `o_index` = :col8, `o_creationDate` = :col9, `o_modificationDate` = :col10, `o_userOwner` = :col11, `o_userModification` = :col12, `o_childrenSortBy` = :col13, `o_childrenSortOrder` = :col14, `o_versionCount` = :col15;;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/data_synch/commodity/get_commodity_info_list';

INSERT INTO `versions` (
  `id`, `cid`, `ctype`, `userId`, `note`,
  `date`, `public`, `serialized`, `stackTrace`,
  `versionCount`, `binaryFileHash`,
  `binaryFileId`, `autoSave`, `storageType`
)
VALUES
  (
    :col0, :col1, :col2, :col3, :col4, :col5,
    :col6, :col7, :col8, :col9, :col10,
    :col11, :col12, :col13
  ) ON DUPLICATE KEY
UPDATE
  `id` = :col0,
  `cid` = :col1,
  `ctype` = :col2,
  `userId` = :col3,
  `note` = :col4,
  `date` = :col5,
  `public` = :col6,
  `serialized` = :col7,
  `stackTrace` = :col8,
  `versionCount` = :col9,
  `binaryFileHash` = :col10,
  `binaryFileId` = :col11,
  `autoSave` = :col12,
  `storageType` = :col13;

INSERT INTO `versions` (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5, :col6, :col7, :col8, :col9, :col10, :col11, :col12, :col13) ON DUPLICATE KEY UPDATE `id` = :col0, `cid` = :col1, `ctype` = :col2, `userId` = :col3, `note` = :col4, `date` = :col5, `public` = :col6, `serialized` = :col7, `stackTrace` = :col8, `versionCount` = :col9, `binaryFileHash` = :col10, `binaryFileId` = :col11, `autoSave` = :col12, `storageType` = :col13;;

SELECT
  articleId,
  articleStatus
FROM
  object_CrispCommodity
WHERE
  articleId in (
    :article_id_0, :article_id_1, :article_id_2,
    :article_id_3, :article_id_4, :article_id_5,
    :article_id_6, :article_id_7, :article_id_8,
    :article_id_9
  )

SELECT articleId,articleStatus FROM object_CrispCommodity WHERE articleId in ('1340894','1340895','1340897','1340899','1340903','1340904','1340905','1340906','1340929','1341086');

SELECT
  object_CrispCommodity.o_id as o_id,
  object_CrispCommodity.o_type as o_type
FROM
  object_CrispCommodity
WHERE
  (
    (
      `articleId` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    )
    AND object_CrispCommodity.o_type IN ('object', 'folder')
  )
  AND object_CrispCommodity.o_published = 1
ORDER BY
  `articleId`

SELECT object_CrispCommodity.o_id as o_id, object_CrispCommodity.o_type as o_type FROM object_CrispCommodity WHERE ((`articleId` in ('1340894','1340895','1340897','1340899','1340903','1340904','1340905','1340906','1340929','1341086'))  AND  object_CrispCommodity.o_type IN ('object','folder')) AND object_CrispCommodity.o_published = 1 ORDER BY `articleId`   ;

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (NULL, NULL, 30, 1762135607) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

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 = '/data_synch/commodity/get_commodity_info_list' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/data_synch/commodity/get_commodity_info_list?app_id=26516&app_key=product_ro_2&app_token=temp_secret_136516&commodity_id_list[0]=1340894&commodity_id_list[1]=1340895&commodity_id_list[2]=1340897&commodity_id_list[3]=1340899&commodity_id_list[4]=1340903&commodity_id_list[5]=1340904&commodity_id_list[6]=1340905&commodity_id_list[7]=1340906&commodity_id_list[8]=1340929&commodity_id_list[9]=1341086&info_list[0]=article_id&info_list[10]=gross_weight&info_list[11]=weight_unit&info_list[12]=productline_id&info_list[13]=productline_desc&info_list[14]=product_bu&info_list[15]=article_status&info_list[1]=list_price&info_list[2]=list_price_unit&info_list[3]=import_flag&info_list[4]=uom_iso&info_list[5]=packing_quantity&info_list[6]=minimum_order_quantity&info_list[7]=strategy_group_sap&info_list[8]=article_description&info_list[9]=net_weight&nonce=46xht1jcvyij4xbh&time_stamp=1762135587&signature=ODhjZmNmMjgxNThlMDFiMGQ0NjcxYmFhMDg0MTA2YmI0ZWIzZjQ3MA==' AND `type` = 'path_query') OR
                (source = 'https://pdm.phoenixcontact.com.cn/data_synch/commodity/get_commodity_info_list?app_id=26516&app_key=product_ro_2&app_token=temp_secret_136516&commodity_id_list[0]=1340894&commodity_id_list[1]=1340895&commodity_id_list[2]=1340897&commodity_id_list[3]=1340899&commodity_id_list[4]=1340903&commodity_id_list[5]=1340904&commodity_id_list[6]=1340905&commodity_id_list[7]=1340906&commodity_id_list[8]=1340929&commodity_id_list[9]=1341086&info_list[0]=article_id&info_list[10]=gross_weight&info_list[11]=weight_unit&info_list[12]=productline_id&info_list[13]=productline_desc&info_list[14]=product_bu&info_list[15]=article_status&info_list[1]=list_price&info_list[2]=list_price_unit&info_list[3]=import_flag&info_list[4]=uom_iso&info_list[5]=packing_quantity&info_list[6]=minimum_order_quantity&info_list[7]=strategy_group_sap&info_list[8]=article_description&info_list[9]=net_weight&nonce=46xht1jcvyij4xbh&signature=ODhjZmNmMjgxNThlMDFiMGQ0NjcxYmFhMDg0MTA2YmI0ZWIzZjQ3MA==&time_stamp=1762135587' 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 = 'ApiRequestLog';

INSERT INTO objects (`o_key`, `o_path`)
VALUES
  (?, ?)

INSERT INTO objects (`o_key`, `o_path`) VALUES ('20251103100647_9745', '/ApiLog/26516/');

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:26:\\\"messenger.bus.pimcore-core\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:38:\\\"Pimcore\\\\Messenger\\\\SearchBackendMessage\\\":2:{s:7:\\\"\\0*\\0type\\\";s:6:\\\"object\\\";s:5:\\\"\\0*\\0id\\\";i:6167647;}}', '[]', 'pimcore_core', '2025-11-03 10:06:47', '2025-11-03 10:06:47');

INSERT INTO `object_query_ApiRequestLog` (
  `appId`, `appKey`, `url`, `params`,
  `result`, `oo_id`
)
VALUES
  (
    :col0, :col1, :col2, :col3, :col4, :col5
  ) ON DUPLICATE KEY
UPDATE
  `appId` = :col0,
  `appKey` = :col1,
  `url` = :col2,
  `params` = :col3,
  `result` = :col4,
  `oo_id` = :col5;

INSERT INTO `object_query_ApiRequestLog` (`appId`, `appKey`, `url`, `params`, `result`, `oo_id`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `appId` = :col0, `appKey` = :col1, `url` = :col2, `params` = :col3, `result` = :col4, `oo_id` = :col5;;

"COMMIT"

"COMMIT";

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT
  id,
  targetType,
  targetId
FROM
  dependencies
WHERE
  sourceType = ?
  AND sourceId = ?

SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 6167647;

SELECT
  id
FROM
  schedule_tasks
WHERE
  `cid` = ?
  AND `ctype` = ?

SELECT id FROM schedule_tasks WHERE `cid` = 6167647 AND `ctype` = 'object' ;

SELECT
  MAX(versionCount)
FROM
  versions
WHERE
  cid = ?
  AND ctype = 'object'

SELECT MAX(versionCount) FROM versions WHERE cid = 6167647 AND ctype = 'object';

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 0;

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

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

DELETE FROM
  cache_items
WHERE
  item_id IN (?)

DELETE FROM cache_items WHERE item_id IN ('object_6167647\0tags\0', 'object_properties\0tags\0');

INSERT INTO object_store_ApiRequestLog (
  `oo_id`, `appId`, `appKey`, `url`,
  `params`, `result`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_store_ApiRequestLog (`oo_id`, `appId`, `appKey`, `url`, `params`, `result`) VALUES (6167647, '26516', 'product_ro_2', '/data_synch/commodity/get_commodity_info_list?app_id=26516&app_key=product_ro_2&app_token=temp_secret_136516&commodity_id_list%5B0%5D=1340894&commodity_id_list%5B1%5D=1340895&commodity_id_list%5B2%5D=1340897&commodity_id_list%5B3%5D=1340899&commodity_id_list%5B4%5D=1340903&commodity_id_list%5B5%5D=1340904&commodity_id_list%5B6%5D=1340905&commodity_id_list%5B7%5D=1340906&commodity_id_list%5B8%5D=1340929&commodity_id_list%5B9%5D=1341086&info_list%5B0%5D=article_id&info_list%5B10%5D=gross_weight&info_list%5B11%5D=weight_unit&info_list%5B12%5D=productline_id&info_list%5B13%5D=productline_desc&info_list%5B14%5D=product_bu&info_list%5B15%5D=article_status&info_list%5B1%5D=list_price&info_list%5B2%5D=list_price_unit&info_list%5B3%5D=import_flag&info_list%5B4%5D=uom_iso&info_list%5B5%5D=packing_quantity&info_list%5B6%5D=minimum_order_quantity&info_list%5B7%5D=strategy_group_sap&info_list%5B8%5D=article_description&info_list%5B9%5D=net_weight&nonce=46xht1jcvyij4xbh&time_stamp=1762135587&signature=ODhjZmNmMjgxNThlMDFiMGQ0NjcxYmFhMDg0MTA2YmI0ZWIzZjQ3MA==', '[]', 'success');

SELECT
  name,
  type,
  data,
  cid,
  inheritable,
  cpath
FROM
  properties
WHERE
  (
    (
      cid IN (1, 1099612, 1099602)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'object'

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,1099612,1099602) AND inheritable = 1) OR cid = 6167647 ) AND ctype='object';

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
  o_versionCount
FROM
  objects
WHERE
  o_id = ? FOR
UPDATE

SELECT o_versionCount FROM objects WHERE o_id = 6167647 FOR UPDATE;

SELECT
  `src_id`
FROM
  `object_relations_ApiRequestLog`
WHERE
  src_id = '6167647'
  AND ownertype = "object"
LIMIT
  1

SELECT `src_id` FROM `object_relations_ApiRequestLog`
        WHERE src_id = '6167647' AND ownertype = "object" LIMIT 1;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

DELETE FROM tree_locks WHERE id = 6167647 AND type = 'object';

SELECT
  o_type,
  o_classId,
  o_className
FROM
  objects
WHERE
  o_id = ?

SELECT o_type,o_classId,o_className FROM objects WHERE o_id = 6167647;

SELECT
  CONCAT(o_path, `o_key`) as o_path
FROM
  objects
WHERE
  o_id = ?

SELECT CONCAT(o_path,`o_key`) as o_path FROM objects WHERE o_id = 1099612;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 0;

DELETE FROM
  properties
WHERE
  cid = ?
  AND ctype = ?

DELETE FROM properties WHERE cid = 6167647 AND ctype = 'object';

SELECT
  *
FROM
  object_query_ApiRequestLog
WHERE
  oo_id = ?

SELECT * FROM object_query_ApiRequestLog WHERE oo_id = 6167647;

DELETE FROM
  schedule_tasks
WHERE
  `cid` = '6167647'
  AND `ctype` = 'object'

DELETE FROM schedule_tasks WHERE `cid` = '6167647' AND `ctype` = 'object';

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 0;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 0;

"START TRANSACTION"

"START TRANSACTION";