Symfony Profiler

SELECT
  oo_id,
  price_list_ids
FROM
  object_store_1
WHERE
  price_list_ids is not null

SELECT oo_id,price_list_ids  FROM object_store_1 WHERE price_list_ids  is not null;

SELECT
  sku,
  object_id,
  website,
  price,
  special_price,
  discount_percentage,
  price_currency
FROM
  ow_price
WHERE
  object_id = '85465'

SELECT sku, object_id, website, price, special_price, discount_percentage, price_currency FROM ow_price WHERE object_id = '85465';

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 > 1775036597 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('2ahgVgbeWz:\0tags\0app9a02622ac2c521153cdd73fc45458de147dd497a', '2ahgVgbeWz:app9a02622ac2c521153cdd73fc45458de147dd497a');

SELECT
  sku,
  object_id,
  supplier,
  website,
  purchase_price,
  purchase_price_currency
FROM
  ow_purchase_price
WHERE
  object_id = '85465'
order by
  supplier desc,
  website desc

SELECT sku, object_id, supplier, website, purchase_price, purchase_price_currency FROM ow_purchase_price WHERE object_id = '85465' order by supplier desc, website desc;

SELECT
  object_localized_4_en.o_id as o_id,
  object_localized_4_en.o_type as o_type
FROM
  object_localized_4_en
WHERE
  o_key LIKE ?
  AND object_localized_4_en.o_type IN ('object', 'folder')

SELECT object_localized_4_en.o_id as o_id, object_localized_4_en.o_type as o_type FROM object_localized_4_en WHERE o_key LIKE 'Color' AND  object_localized_4_en.o_type IN ('object','folder');

SELECT
  attrView.attribute_code as attr_id,
  attrView.attribute_name as attr_name,
  attrView.attribute_type as attribute_type,
  attrOptions.option_value as option_value,
  attrOptionLabels.option_label as option_label
FROM
  `object_collection_attributeOptions_4` as attrOptions
  LEFT JOIN `object_4` as attrView ON attrView.oo_id = attrOptions.o_id
  LEFT JOIN `object_query_8` as attrSet ON attrSet.oo_id = attrView.o_parentId
  LEFT JOIN `object_collection_attributeOptions_localized_4` as attrOptionLabels ON attrView.oo_id = attrOptionLabels.ooo_id
  AND attrOptions.index = attrOptionLabels.index
WHERE
  (
    attrSet.attribute_set_id = 'otroski_vozicki'
    OR attrSet.attribute_set_id = 'general'
  )
  AND attrOptionLabels.language = 'sl_SI'
ORDER BY
  attrView.o_parentId desc,
  attrView.o_index asc

SELECT attrView.attribute_code as attr_id, attrView.attribute_name as attr_name, attrView.attribute_type as attribute_type, attrOptions.option_value as option_value, attrOptionLabels.option_label as option_label 
                            FROM `object_collection_attributeOptions_4` as attrOptions
                            LEFT JOIN `object_4` as attrView ON attrView.oo_id = attrOptions.o_id
                            LEFT JOIN `object_query_8` as attrSet ON attrSet.oo_id = attrView.o_parentId
                            LEFT JOIN `object_collection_attributeOptions_localized_4` as attrOptionLabels ON attrView.oo_id = attrOptionLabels.ooo_id AND attrOptions.index = attrOptionLabels.index
                            WHERE (attrSet.attribute_set_id = 'otroski_vozicki' OR attrSet.attribute_set_id = 'general') AND attrOptionLabels.language = 'sl_SI'
                            ORDER BY attrView.o_parentId desc, attrView.o_index asc;

SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  o.o_className as subtype,
  o.o_published as published,
  concat(o.o_path, o.o_key) as path,
  r.index
FROM
  objects o,
  object_relations_1 r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND o.o_id = r.dest_id
  AND r.type = 'object'
UNION
SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  a.type as subtype,
  "null" as published,
  concat(a.path, a.filename) as path,
  r.index
FROM
  assets a,
  object_relations_1 r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND a.id = r.dest_id
  AND r.type = 'asset'
UNION
SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  d.type as subtype,
  d.published as published,
  concat(d.path, d.key) as path,
  r.index
FROM
  documents d,
  object_relations_1 r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND d.id = r.dest_id
  AND r.type = 'document'
ORDER BY
  `index` ASC

SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.o_className as subtype, o.o_published as published, concat(o.o_path ,o.o_key) as path , r.index
            FROM objects o, object_relations_1 r
            WHERE r.fieldname= 'brand'
            AND r.ownertype = 'object'
            AND r.src_id = 85465
            AND o.o_id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as path, r.index
            FROM assets a, object_relations_1 r
            WHERE r.fieldname= 'brand'
            AND r.ownertype = 'object'
            AND r.src_id = 85465
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as path, r.index
            FROM documents d, object_relations_1 r
            WHERE r.fieldname= 'brand'
            AND r.ownertype = 'object'
            AND r.src_id = 85465
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC;

SELECT
  object_8.o_id as o_id,
  object_8.o_type as o_type
FROM
  object_8
WHERE
  object_8.o_type IN ('object', 'folder')

SELECT object_8.o_id as o_id, object_8.o_type as o_type FROM object_8 WHERE  object_8.o_type IN ('object','folder');

SELECT
  COUNT(*)
FROM
  object_6
WHERE
  object_6.o_type IN ('object', 'folder')

SELECT COUNT(*) FROM object_6 WHERE  object_6.o_type IN ('object','folder');

SELECT
  object_6.o_id as o_id,
  object_6.o_type as o_type
FROM
  object_6
WHERE
  object_6.o_type IN ('object', 'folder')

SELECT object_6.o_id as o_id, object_6.o_type as o_type FROM object_6 WHERE  object_6.o_type IN ('object','folder');

SELECT
  object_localized_4_en.o_id as o_id,
  object_localized_4_en.o_type as o_type
FROM
  object_localized_4_en
WHERE
  use_for_configurable = 1
  AND scope = 'global'
  AND object_localized_4_en.o_type IN ('object', 'folder')

SELECT object_localized_4_en.o_id as o_id, object_localized_4_en.o_type as o_type FROM object_localized_4_en WHERE use_for_configurable = 1 AND scope = 'global' AND  object_localized_4_en.o_type IN ('object','folder');

SELECT
  `lView`,
  cid,
  cpath
FROM
  users_workspaces_object
WHERE
  cid IN (1, 85464, 85374, 26880, 6, 85465)
  AND userId IN (47, 35)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 35) DESC,
  `lView` DESC

SELECT `lView`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,85464,85374,26880,6,85465) AND userId IN (47,35) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 35) DESC, `lView` DESC;

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

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('2ahgVgbeWz:app9a02622ac2c521153cdd73fc45458de147dd497a', 0x00000002172B53796D666F6E795C436F6D706F6E656E745C526174654C696D697465725C506F6C6963795C57696E646F77140211295F6C6F67696E5F676C6F62616C5F70696D636F72655F61646D696E2D38392E3231322E39312E3139310C41DA733A2D43A59C1108000000010000012C060F, 300, 1775036597) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

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

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

SELECT
  *
FROM
  object_collection_productGallery_1
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_productGallery_1 WHERE o_id = 85465 AND fieldname = 'gallery' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_productDescription_1
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_productDescription_1 WHERE o_id = 85465 AND fieldname = 'descriptions' ORDER BY `index` ASC;

SELECT
  userId,
  `list`,
  `view`,
  `publish`,
  `delete`,
  `rename`,
  `create`,
  `settings`,
  `versions`,
  `properties`,
  `save`,
  `unpublish`,
  `lEdit`,
  `lView`,
  `layouts`
FROM
  users_workspaces_object
WHERE
  cid = 6
  AND userId IN (47, 35)
ORDER BY
  FIELD(userId, 35) DESC

SELECT userId,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object
             WHERE cid = 6 AND userId IN (47,35)
             ORDER BY FIELD(userId, 35) DESC
             ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '1';

SELECT
  `lEdit`,
  cid,
  cpath
FROM
  users_workspaces_object
WHERE
  cid IN (1, 85464, 85374, 26880, 6, 85465)
  AND userId IN (47, 35)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 35) DESC,
  `lEdit` DESC

SELECT `lEdit`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,85464,85374,26880,6,85465) AND userId IN (47,35) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 35) DESC, `lEdit` DESC;

DELETE FROM
  cache_items
WHERE
  item_id IN (?)

DELETE FROM cache_items WHERE item_id IN ('2ahgVgbeWz:app9a02622ac2c521153cdd73fc45458de147dd497a', '2ahgVgbeWz:\0tags\0app9a02622ac2c521153cdd73fc45458de147dd497a');

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 35;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 35;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 35;

SELECT
  id
FROM
  versions
WHERE
  cid = :cid
  AND ctype = :ctype
  AND (
    `date` > :mdate
    OR versionCount > :versionCount
  )
  AND (
    (
      autoSave = 1
      AND userId = :userId
    )
    OR autoSave = 0
  )
ORDER BY
  `versionCount` DESC
LIMIT
  1

SELECT id FROM versions WHERE cid = 85465 AND ctype = 'object' AND (`date` > 1775029699 OR versionCount > 1) AND ((autoSave = 1 AND userId = 35) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;

SELECT
  object_id,
  website,
  customer_group,
  qty,
  price
FROM
  ow_tier_price
WHERE
  object_id = '85465'

SELECT object_id, website, customer_group, qty, price FROM ow_tier_price WHERE object_id = '85465';

SELECT
  supplier,
  website,
  metakocka_pricelist_id
FROM
  ow_supplier_pricelist
order by
  supplier asc,
  website asc

SELECT supplier, website, metakocka_pricelist_id FROM ow_supplier_pricelist order by supplier asc, website asc;

SELECT
  *
FROM
  versions
WHERE
  id = ?

SELECT * FROM versions WHERE id = 3594177;

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

SELECT * FROM users WHERE `type` = 'user' AND `name` = 'karin';

SELECT
  `save`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 85464, 85374, 26880, 6, 85465)
  AND userId IN (47, 35)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 35) DESC,
  `save` DESC
LIMIT
  1

SELECT `save` FROM users_workspaces_object WHERE cid IN (1,85464,85374,26880,6,85465) AND userId IN (47,35) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 35) DESC, `save` DESC LIMIT 1;

SELECT
  tree_locks.id
FROM
  tree_locks
  INNER JOIN objects ON tree_locks.id = objects.o_id
WHERE
  objects.o_path LIKE ?
  AND tree_locks.type = 'object'
  AND tree_locks.locked IS NOT NULL
  AND tree_locks.locked != ''
LIMIT
  1

SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE '/Products/Bugaboo®/2026/bugaboo-zimska-vreca-thermolite-performance/bugaboo-zimska-vreca-thermolite-performance-forest-green/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  *
from
  ow_tax_rate;

SELECT * from ow_tax_rate;;

SELECT
  sku,
  warehouse,
  qty,
  `type`
FROM
  ow_inventory_stock
WHERE
  sku = 'BB100464001'
  and warehouse not in ('OW-Warehouse')

SELECT sku, warehouse, qty, `type` FROM ow_inventory_stock WHERE sku = 'BB100464001' and warehouse not in ('OW-Warehouse');

SELECT
  DISTINCT(attrView.attribute_code) as attr_id,
  attrView.attribute_name as attr_name
FROM
  `object_10` as attrView
  LEFT JOIN object_query_8 as attrSet ON attrSet.oo_id = attrView.o_parentId
WHERE
  attrSet.attribute_set_id = 'otroski_vozicki'
  OR attrSet.attribute_set_id = '0'
ORDER BY
  attrView.o_parentId desc,
  attrView.o_index asc

SELECT DISTINCT(attrView.attribute_code) as attr_id, attrView.attribute_name as attr_name FROM `object_10` as attrView
                LEFT JOIN object_query_8 as attrSet ON attrSet.oo_id = attrView.o_parentId
                WHERE attrSet.attribute_set_id = 'otroski_vozicki' OR attrSet.attribute_set_id = '0'
                ORDER BY attrView.o_parentId desc, attrView.o_index asc;

DELETE FROM
  tmp_store
WHERE
  id = ?

DELETE FROM tmp_store WHERE id = 'object_session_85465_a70f8f8854a460a6f3567ada6f280cfa';

SELECT
  id
FROM
  versions
WHERE
  cid = :cid
  AND ctype = :ctype
  AND autoSave = 0
ORDER BY
  `id` ASC

SELECT id FROM versions WHERE cid = 85465 AND ctype = 'object'  AND autoSave = 0 ORDER BY `id` ASC;

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

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,85464,85374,26880,6) AND inheritable = 1) OR cid = 85465 ) AND ctype='object';

SELECT
  `layouts`,
  cid,
  cpath
FROM
  users_workspaces_object
WHERE
  cid IN (1, 85464, 85374, 26880, 6, 85465)
  AND userId IN (47, 35)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 35) DESC,
  `layouts` DESC

SELECT `layouts`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,85464,85374,26880,6,85465) AND userId IN (47,35) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 35) DESC, `layouts` DESC;

INSERT INTO `edit_lock` (
  `id`, `cid`, `ctype`, `userId`, `sessionId`,
  `date`
)
VALUES
  (
    :col0, :col1, :col2, :col3, :col4, :col5
  ) ON DUPLICATE KEY
UPDATE
  `id` = :col0,
  `cid` = :col1,
  `ctype` = :col2,
  `userId` = :col3,
  `sessionId` = :col4,
  `date` = :col5;

INSERT INTO `edit_lock` (`id`, `cid`, `ctype`, `userId`, `sessionId`, `date`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `cid` = :col1, `ctype` = :col2, `userId` = :col3, `sessionId` = :col4, `date` = :col5;;

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

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

SELECT
  id
FROM
  tree_locks
WHERE
  id IN (1, 85464, 85374, 26880, 6)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,85464,85374,26880,6) AND type='object' AND locked = 'propagate' LIMIT 1;

SELECT
  id
FROM
  custom_layouts

SELECT id FROM custom_layouts;

SELECT
  o_classId
FROM
  objects
WHERE
  o_path LIKE ?
  AND o_type = 'object'
LIMIT
  1

SELECT o_classId FROM objects WHERE o_path LIKE '/Products/Bugaboo®/2026/bugaboo-zimska-vreca-thermolite-performance/bugaboo-zimska-vreca-thermolite-performance-forest-green/%' AND o_type = 'object' LIMIT 1;

SELECT
  userId,
  cid,
  `list`,
  `view`,
  `publish`,
  `delete`,
  `rename`,
  `create`,
  `settings`,
  `versions`,
  `properties`,
  `save`,
  `unpublish`,
  `lEdit`,
  `lView`,
  `layouts`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 85464, 85374, 26880, 6, 85465)
  AND userId IN (47, 35)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 35) DESC
LIMIT
  1

SELECT userId,cid,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object
            WHERE cid IN (1,85464,85374,26880,6,85465) AND userId IN (47,35)
            ORDER BY LENGTH(cpath) DESC, FIELD(userId, 35) DESC LIMIT 1
        ;

SELECT
  *
FROM
  edit_lock
WHERE
  cid = ?
  AND ctype = ?

SELECT * FROM edit_lock WHERE cid = 85465 AND ctype = 'object';

SELECT
  `view`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 85464, 85374, 26880, 6, 85465)
  AND userId IN (47, 35)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 35) DESC,
  `view` DESC
LIMIT
  1

SELECT `view` FROM users_workspaces_object WHERE cid IN (1,85464,85374,26880,6,85465) AND userId IN (47,35) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 35) DESC, `view` DESC LIMIT 1;