Symfony Profiler

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

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

"COMMIT"

"COMMIT";

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');

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

DELETE FROM schedule_tasks WHERE `cid` = 1038 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, 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');

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;

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');

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

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

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

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

INSERT IGNORE INTO plugin_cmf_segmentbuilder_changes_queue
SET
  customerId = ?

INSERT IGNORE INTO plugin_cmf_segmentbuilder_changes_queue SET customerId = 1038;

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

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

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
  id,
  targetType,
  targetId
FROM
  dependencies
WHERE
  sourceType = ?
  AND sourceId = ?

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

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

SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (stripeInvoiceId = 'in_1T54egP9eIdsABAC5VzezSRc' AND  object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1;

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
  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;

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;

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

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

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

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

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

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

SELECT
  object_Subscription.id as id,
  object_Subscription.type as `type`
FROM
  object_Subscription
WHERE
  (
    member__id = ?
    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 (member__id = 1038 AND  object_Subscription.type IN ('object','variant','folder')) AND object_Subscription.published = 1;

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

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

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
  tree_locks
WHERE
  id = ?
  AND type = ?

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

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;

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);

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_relations_PaymentOrder (
  `dest_id`, `type`, `fieldname`, `src_id`,
  `ownertype`, `ownername`, `position`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CU';

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 1038 FOR UPDATE;

INSERT INTO object_store_PaymentOrder (
  `oo_id`, `wpOrderId`, `stripeInvoiceId`,
  `stripeCustomerId`, `stripePaymentIntentId`,
  `stripeChargeId`, `paymentMethodId`,
  `cardBrand`, `cardLast4`, `cardExpMonth`,
  `cardExpYear`, `cardNumber`, `status`,
  `currency`, `amountTotal`, `subtotal`,
  `tax`, `invoiceNumber`, `createdTs`,
  `hostedInvoiceUrl`, `receiptUrl`,
  `periodStart`, `periodEnd`, `planName`,
  `planId`, `gatewayEnvironment`,
  `subscriptionTransactionId`, `sessionId`,
  `paypalToken`, `checkoutId`, `paymentType`,
  `billingFirstName`, `billingLastName`,
  `billingStreet`, `billingStreet2`,
  `billingCity`, `billingState`, `billingZip`,
  `billingCountry`, `billingPhone`,
  `affiliateId`, `affiliateSubid`,
  `notes`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_store_PaymentOrder (`oo_id`, `wpOrderId`, `stripeInvoiceId`, `stripeCustomerId`, `stripePaymentIntentId`, `stripeChargeId`, `paymentMethodId`, `cardBrand`, `cardLast4`, `cardExpMonth`, `cardExpYear`, `cardNumber`, `status`, `currency`, `amountTotal`, `subtotal`, `tax`, `invoiceNumber`, `createdTs`, `hostedInvoiceUrl`, `receiptUrl`, `periodStart`, `periodEnd`, `planName`, `planId`, `gatewayEnvironment`, `subscriptionTransactionId`, `sessionId`, `paypalToken`, `checkoutId`, `paymentType`, `billingFirstName`, `billingLastName`, `billingStreet`, `billingStreet2`, `billingCity`, `billingState`, `billingZip`, `billingCountry`, `billingPhone`, `affiliateId`, `affiliateSubid`, `notes`) VALUES (1040, NULL, 'in_1T54egP9eIdsABAC5VzezSRc', 'cus_U3B0OWZIQRu8ZJ', NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, 'paid', 'usd', '20000', NULL, NULL, 'BVPNBYLU-0001', '1772112662', 'https://invoice.stripe.com/i/acct_1Qs4IBP9eIdsABAC/test_YWNjdF8xUXM0SUJQOWVJZHNBQkFDLF9VM0IwS1VpUGkxbmozUE54b3FpcVZaRVdxNld0V0VDLDE2MjY1MzQ2NQ0200NRyVV7Zt?s=ap', NULL, '1772112662', '1774531862', '1 × Pro Plan (at $200.00 / month)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

SELECT object_PaymentOrder.id as id, object_PaymentOrder.type as `type` FROM object_PaymentOrder WHERE (member__id = 1038 AND  object_PaymentOrder.type IN ('object','variant','folder')) AND object_PaymentOrder.published = 1;

SELECT
  *
FROM
  object_relations_CU
WHERE
  src_id = ?

SELECT * FROM object_relations_CU WHERE src_id = 1038;

SELECT
  *
FROM
  object_relations_Subscription
WHERE
  src_id = ?

SELECT * FROM object_relations_Subscription WHERE src_id = 1039;

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

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

INSERT INTO object_store_UserAppLog (
  `oo_id`, `email`, `status`, `message`,
  `success`, `createdTs`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_store_UserAppLog (`oo_id`, `email`, `status`, `message`, `success`, `createdTs`) VALUES (1041, 'mansoor+ttttt@centric.ae', 'error', 'Server error: `POST https://www.icanhiot.com/identity-dev/api/v1/membership/users/new` resulted in a `500 Internal Server Error` response:
{\"title\":\"Server error\",\"status\":500}
', 0, '1772112667');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 0;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 0;

SELECT
  *
FROM
  object_query_UserAppLog
WHERE
  oo_id = ?

SELECT * FROM object_query_UserAppLog WHERE oo_id = 1041;

SHOW COLUMNS
FROM
  object_query_PaymentOrder

SHOW COLUMNS FROM object_query_PaymentOrder;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 0;

SELECT
  *
FROM
  object_relations_PaymentOrder
WHERE
  src_id = ?

SELECT * FROM object_relations_PaymentOrder WHERE src_id = 1040;

SHOW COLUMNS
FROM
  object_store_CU

SHOW COLUMNS FROM object_store_CU;

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';

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;

SHOW COLUMNS
FROM
  object_query_Subscription

SHOW COLUMNS FROM object_query_Subscription;

SELECT
  *
FROM
  object_query_CU
WHERE
  oo_id = ?

SELECT * FROM object_query_CU WHERE oo_id = 1038;

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

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

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
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

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

SELECT
  *
FROM
  object_relations_UserAppLog
WHERE
  src_id = ?

SELECT * FROM object_relations_UserAppLog WHERE src_id = 1041;

SHOW COLUMNS
FROM
  object_query_CU

SHOW COLUMNS FROM object_query_CU;

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

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

SHOW COLUMNS
FROM
  object_query_UserAppLog

SHOW COLUMNS FROM object_query_UserAppLog;

SHOW COLUMNS
FROM
  versions

SHOW COLUMNS FROM versions;

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

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;

INSERT INTO object_query_PaymentOrder (
  `wpOrderId`, `stripeInvoiceId`, `stripeCustomerId`,
  `stripePaymentIntentId`, `stripeChargeId`,
  `paymentMethodId`, `cardBrand`,
  `cardLast4`, `cardExpMonth`, `cardExpYear`,
  `cardNumber`, `status`, `currency`,
  `amountTotal`, `subtotal`, `tax`,
  `invoiceNumber`, `createdTs`, `hostedInvoiceUrl`,
  `receiptUrl`, `periodStart`, `periodEnd`,
  `planName`, `planId`, `gatewayEnvironment`,
  `subscriptionTransactionId`, `sessionId`,
  `paypalToken`, `checkoutId`, `paymentType`,
  `billingFirstName`, `billingLastName`,
  `billingStreet`, `billingStreet2`,
  `billingCity`, `billingState`, `billingZip`,
  `billingCountry`, `billingPhone`,
  `affiliateId`, `affiliateSubid`,
  `notes`, `member__id`, `member__type`,
  `oo_id`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_query_PaymentOrder (`wpOrderId`, `stripeInvoiceId`, `stripeCustomerId`, `stripePaymentIntentId`, `stripeChargeId`, `paymentMethodId`, `cardBrand`, `cardLast4`, `cardExpMonth`, `cardExpYear`, `cardNumber`, `status`, `currency`, `amountTotal`, `subtotal`, `tax`, `invoiceNumber`, `createdTs`, `hostedInvoiceUrl`, `receiptUrl`, `periodStart`, `periodEnd`, `planName`, `planId`, `gatewayEnvironment`, `subscriptionTransactionId`, `sessionId`, `paypalToken`, `checkoutId`, `paymentType`, `billingFirstName`, `billingLastName`, `billingStreet`, `billingStreet2`, `billingCity`, `billingState`, `billingZip`, `billingCountry`, `billingPhone`, `affiliateId`, `affiliateSubid`, `notes`, `member__id`, `member__type`, `oo_id`) VALUES (NULL, 'in_1T54egP9eIdsABAC5VzezSRc', 'cus_U3B0OWZIQRu8ZJ', NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, 'paid', 'usd', '20000', NULL, NULL, 'BVPNBYLU-0001', '1772112662', 'https://invoice.stripe.com/i/acct_1Qs4IBP9eIdsABAC/test_YWNjdF8xUXM0SUJQOWVJZHNBQkFDLF9VM0IwS1VpUGkxbmozUE54b3FpcVZaRVdxNld0V0VDLDE2MjY1MzQ2NQ0200NRyVV7Zt?s=ap', NULL, '1772112662', '1774531862', '1 × Pro Plan (at $200.00 / month)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1038, 'object', 1040);

SELECT
  *
FROM
  object_query_PaymentOrder
WHERE
  oo_id = ?

SELECT * FROM object_query_PaymentOrder WHERE oo_id = 1040;

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';

UPDATE
  object_query_CU
SET
  `active` = ?,
  `wpId` = ?,
  `gender` = ?,
  `firstname` = ?,
  `lastname` = ?,
  `company` = ?,
  `organization` = ?,
  `email` = ?,
  `username` = ?,
  `displayname` = ?,
  `userNiceName` = ?,
  `userUrl` = ?,
  `street` = ?,
  `zip` = ?,
  `city` = ?,
  `countryCode` = ?,
  `phone` = ?,
  `idEncoded` = ?,
  `customerLanguage` = ?,
  `profiling` = ?,
  `password` = ?,
  `passwordRecoveryToken` = ?,
  `passwordRecoveryTokenDate` = ?,
  `stripeCustomerId` = ?,
  `subscriptionStatus` = ?,
  `billingFirstName` = ?,
  `billingLastName` = ?,
  `address1` = ?,
  `address2` = ?,
  `state` = ?,
  `postalCode` = ?,
  `country` = ?,
  `oo_id` = ?
WHERE
  `oo_id` = ?