Symfony Profiler

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/account/register' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/account/register?pmpro_level=2' AND `type` = 'path_query') OR
                (source = 'https://icantech.centricdxb.com/account/register?pmpro_level=2' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

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 '/account/' AND `key` = BINARY 'register';

SELECT
  object_pricingPlan.id as id,
  object_pricingPlan.type as `type`
FROM
  object_pricingPlan
WHERE
  (
    planId = ?
    AND object_pricingPlan.type IN ('object', 'variant', 'folder')
  )
  AND object_pricingPlan.published = 1

SELECT object_pricingPlan.id as id, object_pricingPlan.type as `type` FROM object_pricingPlan WHERE (planId = 2 AND  object_pricingPlan.type IN ('object','variant','folder')) AND object_pricingPlan.published = 1;

SELECT
  COUNT(*)
FROM
  object_CU
WHERE
  (
    (active = 1)
    AND (
      trim(email) like ?
    )
    AND object_CU.type IN ('object', 'variant', 'folder')
  )
  AND object_CU.published = 1

SELECT COUNT(*) FROM object_CU WHERE ((active = 1)  AND (trim(email) like 'mansoor+ttttt@centric.ae')  AND  object_CU.type IN ('object','variant','folder')) AND object_CU.published = 1;

SELECT
  object_CU.id as id,
  object_CU.type as `type`
FROM
  object_CU
WHERE
  (
    (active = 1)
    AND (
      trim(email) like ?
    )
    AND object_CU.type IN ('object', 'variant', 'folder')
  )
  AND object_CU.published = 1

SELECT object_CU.id as id, object_CU.type as `type` FROM object_CU WHERE ((active = 1)  AND (trim(email) like 'mansoor+ttttt@centric.ae')  AND  object_CU.type IN ('object','variant','folder')) AND object_CU.published = 1;

SELECT
  object_CU.id as id,
  object_CU.type as `type`
FROM
  object_CU
WHERE
  (
    email = ?
    AND object_CU.type IN ('object', 'variant', 'folder')
  )
  AND object_CU.published = 1

SELECT object_CU.id as id, object_CU.type as `type` FROM object_CU WHERE (email = 'mansoor+ttttt@centric.ae' AND  object_CU.type IN ('object','variant','folder')) AND object_CU.published = 1;

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

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

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

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

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 17;

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

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CU';

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 17;

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

SELECT id FROM objects WHERE `path` = BINARY '/customers/' AND `key` = BINARY 'mansoor+ttttt@centric.ae';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO objects (`key`, `path`)
VALUES
  (?, ?)

INSERT INTO objects (`key`, `path`) VALUES ('mansoor+ttttt@centric.ae', '/customers/');

SELECT
  *
FROM
  object_relations_CU
WHERE
  src_id = ?

SELECT * FROM object_relations_CU WHERE src_id = 1038;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 1038 FOR UPDATE;

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

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

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SELECT
  type,
  classId,
  className
FROM
  objects
WHERE
  id = ?

SELECT type,classId,className FROM objects WHERE id = 1038;

INSERT INTO objects (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `key`, `index`,
  `childrenSortBy`, `childrenSortOrder`,
  `classId`, `published`, `className`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES ('/customers/', 1038, 1772112665, 1772112665, 1, 0, 0, 17, 'object', 'mansoor+ttttt@centric.ae', 0, NULL, NULL, 'CU', 1, 'Customer');

UPDATE
  objects
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `key` = ?,
  `index` = ?,
  `childrenSortBy` = ?,
  `childrenSortOrder` = ?,
  `classId` = ?,
  `published` = ?,
  `className` = ?
WHERE
  `id` = ?

UPDATE objects SET `path` = '/customers/', `id` = 1038, `creationDate` = 1772112665, `modificationDate` = 1772112665, `versionCount` = 1, `userOwner` = 0, `userModification` = 0, `parentId` = 17, `type` = 'object', `key` = 'mansoor+ttttt@centric.ae', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'CU', `published` = 1, `className` = 'Customer' WHERE `id` = 1038;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

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

DELETE FROM
  object_metadata_CU
WHERE
  id = '1038'
  AND fieldname = 'manualSegments'
  AND position = '0'

DELETE FROM object_metadata_CU WHERE id = '1038' AND fieldname = 'manualSegments' AND position = '0';

DELETE FROM
  object_metadata_CU
WHERE
  id = '1038'
  AND fieldname = 'calculatedSegments'
  AND position = '0'

DELETE FROM object_metadata_CU WHERE id = '1038' AND fieldname = 'calculatedSegments' AND position = '0';

INSERT INTO object_store_CU (
  `oo_id`, `active`, `wpId`, `gender`,
  `firstname`, `lastname`, `company`,
  `organization`, `email`, `username`,
  `displayname`, `userNiceName`, `userUrl`,
  `street`, `zip`, `city`, `countryCode`,
  `phone`, `idEncoded`, `customerLanguage`,
  `profiling__consent`, `profiling__note`,
  `password`, `passwordRecoveryToken`,
  `passwordRecoveryTokenDate`, `stripeCustomerId`,
  `subscriptionStatus`, `billingFirstName`,
  `billingLastName`, `address1`, `address2`,
  `state`, `postalCode`, `country`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO object_store_CU (`oo_id`, `active`, `wpId`, `gender`, `firstname`, `lastname`, `company`, `organization`, `email`, `username`, `displayname`, `userNiceName`, `userUrl`, `street`, `zip`, `city`, `countryCode`, `phone`, `idEncoded`, `customerLanguage`, `profiling__consent`, `profiling__note`, `password`, `passwordRecoveryToken`, `passwordRecoveryTokenDate`, `stripeCustomerId`, `subscriptionStatus`, `billingFirstName`, `billingLastName`, `address1`, `address2`, `state`, `postalCode`, `country`) VALUES (1038, 0, NULL, NULL, 'Mansoor Ali', 'Babar', NULL, 'centric', 'mansoor+ttttt@centric.ae', NULL, NULL, NULL, NULL, NULL, NULL, 'doha', NULL, NULL, NULL, NULL, 0, NULL, '$2y$10$vZQ.FccQv0ClCsnG5g1xKeHgs8WtFLnDKWB0oo/f/dXbjm22egfIK', NULL, NULL, 'cus_U3B0OWZIQRu8ZJ', 'active', 'mansoor', 'ali', '2', '2', 'GA', '57000', 'US');

SELECT
  *
FROM
  object_query_CU
WHERE
  oo_id = ?

SELECT * FROM object_query_CU WHERE oo_id = 1038;

SHOW COLUMNS
FROM
  object_query_CU

SHOW COLUMNS FROM object_query_CU;

INSERT INTO object_query_CU (
  `active`, `wpId`, `gender`, `firstname`,
  `lastname`, `company`, `organization`,
  `email`, `username`, `displayname`,
  `userNiceName`, `userUrl`, `street`,
  `zip`, `city`, `countryCode`, `phone`,
  `idEncoded`, `customerLanguage`,
  `profiling`, `manualSegments`, `calculatedSegments`,
  `password`, `passwordRecoveryToken`,
  `passwordRecoveryTokenDate`, `stripeCustomerId`,
  `subscriptionStatus`, `billingFirstName`,
  `billingLastName`, `address1`, `address2`,
  `state`, `postalCode`, `country`,
  `oo_id`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO object_query_CU (`active`, `wpId`, `gender`, `firstname`, `lastname`, `company`, `organization`, `email`, `username`, `displayname`, `userNiceName`, `userUrl`, `street`, `zip`, `city`, `countryCode`, `phone`, `idEncoded`, `customerLanguage`, `profiling`, `manualSegments`, `calculatedSegments`, `password`, `passwordRecoveryToken`, `passwordRecoveryTokenDate`, `stripeCustomerId`, `subscriptionStatus`, `billingFirstName`, `billingLastName`, `address1`, `address2`, `state`, `postalCode`, `country`, `oo_id`) VALUES (0, NULL, NULL, 'Mansoor Ali', 'Babar', NULL, 'centric', 'mansoor+ttttt@centric.ae', NULL, NULL, NULL, NULL, NULL, NULL, 'doha', NULL, NULL, NULL, NULL, 0, NULL, NULL, '$2y$10$vZQ.FccQv0ClCsnG5g1xKeHgs8WtFLnDKWB0oo/f/dXbjm22egfIK', NULL, NULL, 'cus_U3B0OWZIQRu8ZJ', 'active', 'mansoor', 'ali', '2', '2', 'GA', '57000', 'US', 1038);

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

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

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

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

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 0;

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;

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 1;

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

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

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

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

SHOW COLUMNS
FROM
  versions

SHOW COLUMNS FROM versions;

INSERT INTO versions (
  `id`, `cid`, `ctype`, `userId`, `note`,
  `date`, `public`, `serialized`, `stackTrace`,
  `versionCount`, `binaryFileHash`,
  `binaryFileId`, `autoSave`, `storageType`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 1038, 'object', 0, '', 1772112665, 0, 1, '#0 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save()
#1 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion()
#2 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/Concrete.php(206): Pimcore\\Model\\DataObject\\Concrete->saveVersion()
#3 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(550): Pimcore\\Model\\DataObject\\Concrete->update()
#4 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/Concrete.php(637): Pimcore\\Model\\DataObject\\AbstractObject->save()
#5 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/src/Controller/AccountController.php(3134): Pimcore\\Model\\DataObject\\Concrete->save()
#6 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/src/Controller/AccountController.php(271): App\\Controller\\AccountController->upsertUserObject()
#7 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/http-kernel/HttpKernel.php(181): App\\Controller\\AccountController->registerAction()
#8 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#9 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#10 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#11 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#12 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/public/index.php(19): require_once(\'...\')
#13 {main}', 1, NULL, NULL, 0, 'fs');

"COMMIT"

"COMMIT";

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

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

INSERT IGNORE INTO plugin_cmf_segmentbuilder_changes_queue
SET
  customerId = ?

INSERT IGNORE INTO plugin_cmf_segmentbuilder_changes_queue SET customerId = 1038;

"START TRANSACTION"

"START TRANSACTION";

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:69:\\\"Pimcore\\\\Bundle\\\\SimpleBackendSearchBundle\\\\Message\\\\SearchBackendMessage\\\":2:{s:7:\\\"\\0*\\0type\\\";s:6:\\\"object\\\";s:5:\\\"\\0*\\0id\\\";i:1038;}}', '[]', 'pimcore_search_backend_message', '2026-02-26 13:31:05', '2026-02-26 13:31:05');

"COMMIT"

"COMMIT";

SELECT
  object_Subscription.id as id,
  object_Subscription.type as `type`
FROM
  object_Subscription
WHERE
  (
    stripeSubscriptionId = ?
    AND object_Subscription.type IN ('object', 'variant', 'folder')
  )
  AND object_Subscription.published = 1

SELECT object_Subscription.id as id, object_Subscription.type as `type` FROM object_Subscription WHERE (stripeSubscriptionId = 'sub_1T54egP9eIdsABACdrfUe7w6' AND  object_Subscription.type IN ('object','variant','folder')) AND object_Subscription.published = 1;

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

SELECT id FROM objects WHERE `path` = BINARY '/' AND `key` = BINARY 'stripe-subscriptions';

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

SELECT id FROM objects WHERE `path` = BINARY '/' AND `key` = BINARY 'stripe-subscriptions';

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 19;

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

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'Subscription';

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 19;

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

SELECT id FROM objects WHERE `path` = BINARY '/stripe-subscriptions/' AND `key` = BINARY 'sub_1T54egP9eIdsABACdrfUe7w6';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO objects (`key`, `path`)
VALUES
  (?, ?)

INSERT INTO objects (`key`, `path`) VALUES ('sub_1T54egP9eIdsABACdrfUe7w6', '/stripe-subscriptions/');

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 1039 FOR UPDATE;

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

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

SELECT
  type,
  classId,
  className
FROM
  objects
WHERE
  id = ?

SELECT type,classId,className FROM objects WHERE id = 1039;

INSERT INTO objects (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `key`, `index`,
  `childrenSortBy`, `childrenSortOrder`,
  `classId`, `published`, `className`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES ('/stripe-subscriptions/', 1039, 1772112665, 1772112665, 1, 0, 0, 19, 'object', 'sub_1T54egP9eIdsABACdrfUe7w6', 0, NULL, NULL, 'Subscription', 1, 'Subscription');

UPDATE
  objects
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `key` = ?,
  `index` = ?,
  `childrenSortBy` = ?,
  `childrenSortOrder` = ?,
  `classId` = ?,
  `published` = ?,
  `className` = ?
WHERE
  `id` = ?

UPDATE objects SET `path` = '/stripe-subscriptions/', `id` = 1039, `creationDate` = 1772112665, `modificationDate` = 1772112665, `versionCount` = 1, `userOwner` = 0, `userModification` = 0, `parentId` = 19, `type` = 'object', `key` = 'sub_1T54egP9eIdsABACdrfUe7w6', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'Subscription', `published` = 1, `className` = 'Subscription' WHERE `id` = 1039;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

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

SELECT
  *
FROM
  object_relations_Subscription
WHERE
  src_id = ?

SELECT * FROM object_relations_Subscription WHERE src_id = 1039;

INSERT INTO object_relations_Subscription (
  `dest_id`, `type`, `fieldname`, `src_id`,
  `ownertype`, `ownername`, `position`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_relations_Subscription (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (1038, 'object', 'member', 1039, 'object', '', '0');

INSERT INTO object_store_Subscription (
  `oo_id`, `wpId`, `stripeSubscriptionId`,
  `status`, `currentPeriodStart`,
  `currentPeriodEnd`, `createdTs`,
  `endedTs`, `nextPaymentDate`, `planName`,
  `planId`, `priceAmount`, `priceCurrency`,
  `priceInterval`, `gateway`, `gatewayEnvironment`,
  `cycleNumber`, `billingLimit`, `trialAmount`,
  `trialLimit`, `modified`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

INSERT INTO object_store_Subscription (`oo_id`, `wpId`, `stripeSubscriptionId`, `status`, `currentPeriodStart`, `currentPeriodEnd`, `createdTs`, `endedTs`, `nextPaymentDate`, `planName`, `planId`, `priceAmount`, `priceCurrency`, `priceInterval`, `gateway`, `gatewayEnvironment`, `cycleNumber`, `billingLimit`, `trialAmount`, `trialLimit`, `modified`) VALUES (1039, NULL, 'sub_1T54egP9eIdsABACdrfUe7w6', 'active', '0', '0', '1772112662', '0', NULL, NULL, '2', '20000', 'usd', 'month', 'stripe', 'test', NULL, NULL, NULL, NULL, NULL);

SELECT
  *
FROM
  object_query_Subscription
WHERE
  oo_id = ?

SELECT * FROM object_query_Subscription WHERE oo_id = 1039;

SHOW COLUMNS
FROM
  object_query_Subscription

SHOW COLUMNS FROM object_query_Subscription;

INSERT INTO object_query_Subscription (
  `wpId`, `stripeSubscriptionId`, `status`,
  `currentPeriodStart`, `currentPeriodEnd`,
  `createdTs`, `endedTs`, `nextPaymentDate`,
  `planName`, `planId`, `priceAmount`,
  `priceCurrency`, `priceInterval`,
  `gateway`, `gatewayEnvironment`,
  `cycleNumber`, `billingLimit`, `trialAmount`,
  `trialLimit`, `modified`, `member__id`,
  `member__type`, `oo_id`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_query_Subscription (`wpId`, `stripeSubscriptionId`, `status`, `currentPeriodStart`, `currentPeriodEnd`, `createdTs`, `endedTs`, `nextPaymentDate`, `planName`, `planId`, `priceAmount`, `priceCurrency`, `priceInterval`, `gateway`, `gatewayEnvironment`, `cycleNumber`, `billingLimit`, `trialAmount`, `trialLimit`, `modified`, `member__id`, `member__type`, `oo_id`) VALUES (NULL, 'sub_1T54egP9eIdsABACdrfUe7w6', 'active', '0', '0', '1772112662', '0', NULL, NULL, '2', '20000', 'usd', 'month', 'stripe', 'test', NULL, NULL, NULL, NULL, NULL, 1038, 'object', 1039);

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

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

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

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

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

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

INSERT INTO versions (
  `id`, `cid`, `ctype`, `userId`, `note`,
  `date`, `public`, `serialized`, `stackTrace`,
  `versionCount`, `binaryFileHash`,
  `binaryFileId`, `autoSave`, `storageType`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 1039, 'object', 0, '', 1772112665, 0, 1, '#0 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save()
#1 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion()
#2 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/Concrete.php(206): Pimcore\\Model\\DataObject\\Concrete->saveVersion()
#3 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(550): Pimcore\\Model\\DataObject\\Concrete->update()
#4 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/pimcore/pimcore/models/DataObject/Concrete.php(637): Pimcore\\Model\\DataObject\\AbstractObject->save()
#5 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/src/Controller/AccountController.php(3270): Pimcore\\Model\\DataObject\\Concrete->save()
#6 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/src/Controller/AccountController.php(285): App\\Controller\\AccountController->upsertSubscriptionFromStripeObject()
#7 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/http-kernel/HttpKernel.php(181): App\\Controller\\AccountController->registerAction()
#8 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#9 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#10 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#11 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#12 /var/www/vhosts/centric.ae/icantech.centricdxb.com/icantechai/public/index.php(19): require_once(\'...\')
#13 {main}', 1, NULL, NULL, 0, 'fs');

"COMMIT"

"COMMIT";

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

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

INSERT INTO dependencies (
  sourceid, sourcetype, targetid, targettype
)
VALUES
  (?, ?, ?, ?)

INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (1039, 'object', 1038, 'object');

"START TRANSACTION"

"START TRANSACTION";

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:69:\\\"Pimcore\\\\Bundle\\\\SimpleBackendSearchBundle\\\\Message\\\\SearchBackendMessage\\\":2:{s:7:\\\"\\0*\\0type\\\";s:6:\\\"object\\\";s:5:\\\"\\0*\\0id\\\";i:1039;}}', '[]', 'pimcore_search_backend_message', '2026-02-26 13:31:05', '2026-02-26 13:31:05');

"COMMIT"

"COMMIT";