Symfony Profiler

[
  "event" => "pimcore.system.configuration.get"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\AdminConfigListener::updateSystemConfiguration"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "UTF8MB4"
    "host" => "localhost"
    "port" => 3306
    "user" => "pimcoreuser"
    "password" => "<redacted>"
    "dbname" => "pimcore"
    "driverOptions" => [
      1002 => "SET sql_mode = '';"
    ]
    "serverVersion" => "8.0.36-0ubuntu0.20.04.1"
    "defaultTableOptions" => [
      "charset" => "UTF8MB4"
      "engine" => "InnoDB"
      "collate" => "utf8mb4_general_ci"
    ]
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "site_domain_43419afe57696b349fd61a20df5a68f3"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?, ?)"
  "params" => [
    1 => 1762276173
    2 => "system\x01tags\x01"
    3 => "site\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "site_domain_43419afe57696b349fd61a20df5a68f3"
]

[
  "sql" => "SELECT * FROM settings_store WHERE id = ? AND scope = ?"
  "params" => [
    1 => "system_settings"
    2 => "pimcore_system_settings"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM settings_store WHERE id = ? AND scope = ?"
  "params" => [
    1 => "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
    2 => "pimcore"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT * FROM redirects WHERE\n
                (\n
                    (source = ? AND (`type` = ? OR `type` = ?)) OR\n
                    (source = ? AND `type` = ?) OR\n
                    (source = ? AND `type` = ?)\n
                ) 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
    """
  "params" => [
    1 => "/manufacturer/product/lock-1735208863651"
    2 => "path"
    3 => "auto_create"
    4 => "/manufacturer/product/lock-1735208863651"
    5 => "path_query"
    6 => "https://arqonz.in/manufacturer/product/lock-1735208863651"
    7 => "entire_uri"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "system_route_redirect"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?, ?, ?)"
  "params" => [
    1 => 1762276173
    2 => "system\x01tags\x01"
    3 => "redirect\x01tags\x01"
    4 => "route\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "key" => "system_route_redirect"
]

[
  "sql" => "SELECT * FROM tmp_store WHERE id = ?"
  "params" => [
    1 => "maintenance_mode"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM settings_store WHERE id = ? AND scope = ?"
  "params" => [
    1 => "reports"
    2 => "pimcore"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "route" => "Manufacturer_product_single"
  "route_parameters" => [
    "_route" => "Manufacturer_product_single"
    "_controller" => "App\Controller\ContentController::ManufacturerProductDetails"
    "CustomerType" => "manufacturer"
    "url" => "lock-1735208863651"
  ]
  "request_uri" => "https://arqonz.in/manufacturer/product/lock-1735208863651"
  "method" => "GET"
]

[
  "path" => "/manufacturer/product/lock-1735208863651"
  "context" => "default"
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/manufacturer/product/"
    2 => "lock-1735208863651"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/manufacturer/product/lock-1735208863651"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/manufacturer/"
    2 => "product"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/manufacturer/product"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => "manufacturer"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/manufacturer"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => ""
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "document_1"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1762276173
    2 => "document_1\x01tags\x01"
    3 => "asset_337\x01tags\x01"
    4 => "asset_3\x01tags\x01"
    5 => "asset_319\x01tags\x01"
    6 => "asset_361\x01tags\x01"
    7 => "asset_320\x01tags\x01"
    8 => "asset_318\x01tags\x01"
    9 => "asset_321\x01tags\x01"
    10 => "asset_224\x01tags\x01"
    11 => "asset_35\x01tags\x01"
    12 => "asset_211\x01tags\x01"
    13 => "asset_90\x01tags\x01"
    14 => "asset_58\x01tags\x01"
    15 => "asset_180\x01tags\x01"
    16 => "asset_124\x01tags\x01"
    17 => "asset_164\x01tags\x01"
    18 => "asset_81\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
  ]
]

[
  "key" => "document_1"
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "document_properties_1"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?, ?)"
  "params" => [
    1 => 1762276173
    2 => "document_properties\x01tags\x01"
    3 => "document_1\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "document_properties_1"
]

[
  "firewall_name" => "demo_frontend"
  "authenticators" => 2
]

[
  "firewall_name" => "demo_frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "demo_frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "demo_frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "demo_frontend"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "editmode" => "false"
  "params" => [
    "param" => false
    "adminRequest" => false
    "user" => false
  ]
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\CustomAdminEntryPointCheckListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\RoutingListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\StaticPageGeneratorListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\SeoBundle\EventListener\RoutingListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\AdminSessionBagListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\EcommerceFrameworkBundle\EventListener\SessionBagListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\PersonalizationBundle\Targeting\EventListener\TargetingSessionBagListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\MaintenancePageListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\FullPageCacheListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\GoogleMarketingBundle\EventListener\Frontend\GoogleSearchConsoleVerificationListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\PimcoreContextListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\DocumentFallbackListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\CsrfProtectionListener::handleRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\PersonalizationBundle\Targeting\EventListener\TargetingListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Event\TwoFactorFormListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\UserPerspectiveListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\UsageStatisticsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\EcommerceFrameworkBundle\EventListener\Frontend\TrackingCodeFlashMessageListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "CustomerManagementFrameworkBundle\Event\Frontend\UrlActivityTracker::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\TranslationDebugListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\BlockStateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\EditmodeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\OutputTimestampListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "CustomerManagementFrameworkBundle\Event\Frontend\UrlActivityTracker::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\DocumentFallbackListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\ElementListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\PersonalizationBundle\Targeting\EventListener\Frontend\TargetingElementListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\Frontend\GlobalTemplateVariablesListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\EventedControllerListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\ResponseHeaderListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerTC8Se9s\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/Services/Manufacturers/Products/"
    2 => "lock-1735208863651"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_6376"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?, ?)"
  "params" => [
    1 => 1762276173
    2 => "object_6376\x01tags\x01"
    3 => "class_10\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "object_6376"
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "10"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "pimcore.dataobject.preUpdate"
  "listener" => "App\EventListener\ProRequirementListener::onPreUpdate"
]

[
  "event" => "pimcore.dataobject.preUpdate"
  "listener" => "CustomerManagementFrameworkBundle\Event\PimcoreObjectEventListener::onPreUpdate"
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1212"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1212\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "object_1212"
]

[
  "sql" => "SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?"
  "params" => [
    1 => 1212
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/Services/Manufacturers/Products/"
    2 => "lock-1735208863651"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/Services/Manufacturers/Products/"
    2 => "lock-1735208863651"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?"
  "params" => [
    1 => 6376
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_3354"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?, ?)"
  "params" => [
    1 => 1762276173
    2 => "object_3354\x01tags\x01"
    3 => "class_11\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "key" => "object_3354"
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "SupplierBid"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "22"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM object_relations_22 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'"
  "params" => [
    1 => 6376
    2 => "ProRequirementProduct"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM classes WHERE name = ?"
  "params" => [
    1 => "DbProductReview"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "26"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM object_relations_26 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'"
  "params" => [
    1 => 6376
    2 => "ProProduct"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT versionCount FROM objects WHERE id = ? FOR UPDATE"
  "params" => [
    1 => 6376
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'"
  "params" => [
    1 => 6376
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_properties_6376"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "\x00tags\x00object_properties_6376"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "object_properties_6376"
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1209"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1209\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "object_1209"
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1190"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1190\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "object_1190"
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "object_1\x01tags\x01"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "object_1"
]

[
  "sql" => """
    SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE\n
                         (\n
                             (cid IN (1,1212,1209,1190) AND inheritable = 1)\n
                             OR cid = ? ) AND ctype='object'
    """
  "params" => [
    1 => 6376
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?"
  "params" => [
    1 => "object"
    2 => 6376
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "system_resource_columns_objects"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "\x00tags\x00system_resource_columns_objects"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "system_resource_columns_objects"
]

[
  "sql" => "SHOW COLUMNS FROM objects"
]

[
  "sql" => "SELECT type,classId,className FROM objects WHERE id = ?"
  "params" => [
    1 => 6376
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "/Services/Manufacturers/Products/"
    2 => 6376
    3 => 1735208863
    4 => 1762276173
    5 => 53
    6 => 0
    7 => 0
    8 => 1212
    9 => "object"
    10 => "lock-1735208863651"
    11 => 0
    12 => null
    13 => null
    14 => 1
    15 => "10"
    16 => "ProProduct"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
  ]
]

[
  "sql" => "UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ?"
  "params" => [
    1 => "/Services/Manufacturers/Products/"
    2 => 6376
    3 => 1735208863
    4 => 1762276173
    5 => 53
    6 => 0
    7 => 0
    8 => 1212
    9 => "object"
    10 => "lock-1735208863651"
    11 => 0
    12 => null
    13 => null
    14 => 1
    15 => "10"
    16 => "ProProduct"
    17 => 6376
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
  ]
]

[
  "sql" => "DELETE FROM tree_locks WHERE id = ? AND type = ?"
  "params" => [
    1 => 6376
    2 => "object"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT `src_id` FROM `object_relations_10`\n
            WHERE (src_id = '6376' AND fieldname not in ('Professional','SupplierBid','ProductReviews') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1
    """
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "system_resource_columns_object_store_10"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "\x00tags\x00system_resource_columns_object_store_10"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "system_resource_columns_object_store_10"
]

[
  "sql" => "SHOW COLUMNS FROM object_store_10"
]

[
  "sql" => "INSERT INTO object_store_10 (`oo_id`, `ProductName`, `ProductDescription`, `ProductImage__images`, `ProductImage__hotspots`, `Specifications`, `ProductCategory`, `ParentCategory`, `SubSubCategory`, `SubCategory`, `ProductType`, `ProductBrand`, `Material`, `Price`, `Unit`, `Tags`, `InternationalBrand`, `PageViewsCount`, `ProductVideoPaths`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 6376
    2 => "Lock"
    3 => "706 Dead Lock 55mm Backset, 20mm Square Forend, SSS."
    4 => ""
    5 => "a:0:{}"
    6 => null
    7 => null
    8 => "Door Control"
    9 => null
    10 => "706 Dead Lock "
    11 => null
    12 => null
    13 => null
    14 => "2"
    15 => "Nos"
    16 => "Lock"
    17 => null
    18 => 51.0
    19 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
  ]
]

[
  "sql" => "UPDATE object_store_10 SET `oo_id` = ?, `ProductName` = ?, `ProductDescription` = ?, `ProductImage__images` = ?, `ProductImage__hotspots` = ?, `Specifications` = ?, `ProductCategory` = ?, `ParentCategory` = ?, `SubSubCategory` = ?, `SubCategory` = ?, `ProductType` = ?, `ProductBrand` = ?, `Material` = ?, `Price` = ?, `Unit` = ?, `Tags` = ?, `InternationalBrand` = ?, `PageViewsCount` = ?, `ProductVideoPaths` = ? WHERE `oo_id` = ?"
  "params" => [
    1 => 6376
    2 => "Lock"
    3 => "706 Dead Lock 55mm Backset, 20mm Square Forend, SSS."
    4 => ""
    5 => "a:0:{}"
    6 => null
    7 => null
    8 => "Door Control"
    9 => null
    10 => "706 Dead Lock "
    11 => null
    12 => null
    13 => null
    14 => "2"
    15 => "Nos"
    16 => "Lock"
    17 => null
    18 => 51.0
    19 => null
    20 => 6376
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
  ]
]

[
  "sql" => "SELECT * FROM object_query_10 WHERE oo_id = ?"
  "params" => [
    1 => 6376
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "system_resource_columns_object_query_10"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "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 (?)"
  "params" => [
    1 => 1762276173
    2 => "\x00tags\x00system_resource_columns_object_query_10"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "key" => "system_resource_columns_object_query_10"
]

[
  "sql" => "SHOW COLUMNS FROM object_query_10"
]

[
  "sql" => "INSERT INTO object_query_10 (`ProductName`, `ProductDescription`, `ProductImage__images`, `ProductImage__hotspots`, `Specifications`, `ProfessionalPath`, `ProductCategory`, `ParentCategory`, `SubSubCategory`, `SubCategory`, `ProductType`, `ProductBrand`, `Material`, `Price`, `Unit`, `Tags`, `ObjKey`, `InternationalBrand`, `PageViewsCount`, `ProductVideoPaths`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "Lock"
    2 => "706 Dead Lock 55mm Backset, 20mm Square Forend, SSS."
    3 => ""
    4 => "a:0:{}"
    5 => null
    6 => "/Services/Manufacturers/Profiles/Bharat-Industrial-Manufacturing-Co-1726637039"
    7 => null
    8 => "Door Control"
    9 => null
    10 => "706 Dead Lock "
    11 => null
    12 => null
    13 => null
    14 => "2"
    15 => "Nos"
    16 => "Lock"
    17 => "lock-1735208863651"
    18 => null
    19 => 51.0
    20 => null
    21 => 6376
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
  ]
]