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 = '/admin/object-helper/batch' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/admin/object-helper/batch' AND `type` = 'path_query') OR
                (source = 'https://internal-np.com/admin/object-helper/batch' 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
  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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 5;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 5;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 5;

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_38480');

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_38480
tags
', 'class_1
tags
');

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

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

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

SELECT
  *
FROM
  object_store_1
WHERE
  oo_id = ?

SELECT * FROM object_store_1 WHERE oo_id = 38480;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '1';

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

SELECT * FROM settings_store WHERE id = 'ProductFamily' AND scope = 'pimcore_select_options';

SELECT
  c.id AS id,
  c.name AS name
FROM
  object_3 c

SELECT 
                c.id AS id,
                c.name AS name
            FROM 
                object_3 c;

SELECT
  c.id AS id,
  c.name AS name
FROM
  object_3 c

SELECT 
                c.id AS id,
                c.name AS name
            FROM 
                object_3 c;

SELECT
  *
FROM
  object_brick_store_MaterialsandComposition_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_MaterialsandComposition_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_PerformanceandSpecifications_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_PerformanceandSpecifications_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_AdditionalSpecifications_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_AdditionalSpecifications_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_DesignandFeatures_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_DesignandFeatures_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_DimensionsandSize_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_DimensionsandSize_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_EnvironmentalandOperatingConditions_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_EnvironmentalandOperatingConditions_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_FilterAttributes_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_FilterAttributes_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_MaintenanceandAccessories_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_MaintenanceandAccessories_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  c.id AS id,
  c.name AS name
FROM
  object_3 c

SELECT 
                c.id AS id,
                c.name AS name
            FROM 
                object_3 c;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 38480;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'Product';

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_4163');

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

SELECT
  assets.*,
  tree_locks.locked
FROM
  assets
  LEFT JOIN tree_locks ON assets.id = tree_locks.id
  AND tree_locks.type = 'asset'
WHERE
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 4163;

SELECT
  assets.*,
  tree_locks.locked
FROM
  assets
  LEFT JOIN tree_locks ON assets.id = tree_locks.id
  AND tree_locks.type = 'asset'
WHERE
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 4163;

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_44');

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_44
tags
', 'class_3
tags
');

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

SELECT id FROM objects WHERE `path` = BINARY '/Products/' AND `key` = BINARY 'Hydraulic Nozzles';

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

SELECT id FROM objects WHERE `path` = BINARY '/Products/' AND `key` = BINARY 'Hydraulic Nozzles';

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_43016');

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 > 1747944679 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_43016
tags
');

SELECT
  *
FROM
  shopify_product_sync
WHERE
  productId = ?

SELECT * FROM shopify_product_sync WHERE productId = 38480;

INSERT INTO shopify_product_sync (productId, STATUS)
VALUES
  (?, ?) ON DUPLICATE KEY
UPDATE
  STATUS = ?

INSERT INTO shopify_product_sync (productId, STATUS) VALUES (38480, 'pending')
                ON DUPLICATE KEY UPDATE STATUS = 'pending';

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  productFamily = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE productFamily = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-899' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-900' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-901' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-902' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-903' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-904' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-905' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-906' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-907' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-908' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-909' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-910' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-911' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-912' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-913' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-914' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-915' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-916' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-917' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-918' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-919' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-920' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-921' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-922' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-923' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-924' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-925' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-926' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-927' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-928' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-929' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-930' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-931' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-932' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-933' AND  object_1.type IN ('object','variant','folder');

SELECT
  COUNT(*)
FROM
  object_1
WHERE
  autoSku = ?
  AND object_1.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_1 WHERE autoSku = 'PROJET 3X SERIES - MODULAR UNIT ASSEMBLIES-934' AND  object_1.type IN ('object','variant','folder');

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

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

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

SELECT
  *
FROM
  object_store_1
WHERE
  oo_id = ?

SELECT * FROM object_store_1 WHERE oo_id = 38480;

SELECT
  c.id AS id,
  c.name AS name
FROM
  object_3 c

SELECT 
                c.id AS id,
                c.name AS name
            FROM 
                object_3 c;

SELECT
  *
FROM
  object_brick_store_MaterialsandComposition_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_MaterialsandComposition_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_PerformanceandSpecifications_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_PerformanceandSpecifications_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_AdditionalSpecifications_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_AdditionalSpecifications_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_DesignandFeatures_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_DesignandFeatures_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_DimensionsandSize_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_DimensionsandSize_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_EnvironmentalandOperatingConditions_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_EnvironmentalandOperatingConditions_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_FilterAttributes_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_FilterAttributes_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  *
FROM
  object_brick_store_MaintenanceandAccessories_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_MaintenanceandAccessories_1 WHERE id = 38480 AND fieldname = 'attributes';

SELECT
  c.id AS id,
  c.name AS name
FROM
  object_3 c

SELECT 
                c.id AS id,
                c.name AS name
            FROM 
                object_3 c;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 38480;

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

SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = 43016;

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

SELECT id FROM objects WHERE `path` = BINARY '/Products/Hydraulic Nozzles/' AND `key` = BINARY 'NP3U-9504-316';

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

SELECT id FROM objects WHERE `path` = BINARY '/Products/Hydraulic Nozzles/' AND `key` = BINARY 'NP3U-9504-316';

"START TRANSACTION"

"START TRANSACTION";

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

SELECT CONCAT(`path`,`key`) AS `path` FROM objects WHERE id = 38480;

SELECT
  c.id AS id,
  c.name AS name
FROM
  object_3 c

SELECT 
                c.id AS id,
                c.name AS name
            FROM 
                object_3 c;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '2';

SELECT
  object_2.id AS id,
  object_2.type AS `type`
FROM
  object_2
WHERE
  `Name` = 'SprayPattern'
  AND object_2.type IN ('variant', 'object')
LIMIT
  1

SELECT object_2.id AS id, object_2.type AS `type` FROM object_2 WHERE `Name` = 'SprayPattern'  AND  object_2.type IN ('variant','object') LIMIT 1;

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 > 1747944680 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_16');

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 > 1747944680 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_16
tags
', 'class_2
tags
');