GET https://x.glomex.dev.gtsoftware.cz/api/v1/category

Query Metrics

23 Database Queries
2 Different statements
22.19 ms Query time
3 Invalid entities
100 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 6.63 ms
SELECT DISTINCT c0_.uuid AS uuid_0, c0_.name AS name_1, c0_.order_position AS order_position_2, c0_.parent_id AS parent_id_3 FROM category c0_ INNER JOIN category_product c1_ ON (c1_.category_id = c0_.uuid) INNER JOIN product p2_ ON c1_.product_id = p2_.uuid AND (c1_.product_id = p2_.uuid AND p2_.archived = 0) WHERE p2_.pricing_selling_price > 0 ORDER BY c0_.order_position ASC
Parameters:
[]
2 0.92 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAñp*·\”fIUË\r"
]
3 0.73 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrA³|¿›¬ýŸ˜¯ZÊ"
]
4 0.61 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrA·|\x01ƒ\x19M´þö]Õ"
]
5 0.52 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAÍt´¯ð\x0F¸èÂO»"
]
6 0.53 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAÉ}Å¢»,nBývc"
]
7 0.51 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAÅ~·‡\x17·ëò{]6"
]
8 0.53 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAüx\x03—ÏæhWCî"
]
9 0.68 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAäuÇ–­(’\x0FÌc–"
]
10 0.49 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAáq\r“\x06­ª*^€ø"
]
11 0.75 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrA£|ð¨\x1Fb/çòÌX"
]
12 0.54 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAŸqi¸g|\x1DÉp’v"
]
13 0.49 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrA¾~k¤\x0E¢ÝÓ]Û6"
]
14 0.63 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrA©t„‰\x15\x1D]7´þô"
]
15 0.53 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAÁw¿ \x1EŽOõ[¦5"
]
16 0.55 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAºq\x7FµY”›jD+e"
]
17 0.51 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrA°rô­\x12\x18¸&É7o"
]
18 0.53 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAÐyø¾µ\x1CÏ\x14\f¢3"
]
19 0.71 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAÞxg›F¢½ÒD¥œ"
]
20 0.62 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAØz‡µÁçg‘—͏"
]
21 0.45 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrA¦{ªŸK<ƒR´h"
]
22 0.37 ms
SELECT t0.uuid AS uuid_1, t0.name AS name_2, t0.order_position AS order_position_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01—ÕrAÒu\t©‡’·¢Ö,œ"
]
23 3.35 ms
SELECT DISTINCT c0_.uuid AS uuid_0, c0_.name AS name_1, c0_.order_position AS order_position_2, c0_.parent_id AS parent_id_3 FROM category c0_ INNER JOIN category_product c1_ ON (c1_.category_id = c0_.uuid) INNER JOIN product p2_ ON c1_.product_id = p2_.uuid AND (c1_.product_id = p2_.uuid AND p2_.archived = 0) WHERE p2_.pricing_selling_price > 0 ORDER BY c0_.order_position ASC
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
stock doctrine.dbal.stock_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Domain\Category\Entity\Category 100

Entities Mapping

Class Mapping errors
App\Domain\Tag\Entity\Tag No errors.
App\Domain\Tag\Entity\TagProduct No errors.
App\Domain\Product\Entity\NutritionFacts No errors.
App\Domain\Product\Entity\Pricing No errors.
App\Domain\Product\Entity\Measurements No errors.
App\Domain\Product\Entity\Identifiers No errors.
App\Domain\Product\Entity\Stock No errors.
App\Domain\Product\Entity\Product
  • The field App\Domain\Product\Entity\Product#tagProduct is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Tag\Entity\TagProduct#product does not contain the required 'inversedBy: "tagProduct"' attribute.
  • The field App\Domain\Product\Entity\Product#customerProducts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Customer\Entity\CustomerProduct#product does not contain the required 'inversedBy: "customerProducts"' attribute.
App\Domain\Product\Entity\Country No errors.
App\Domain\Product\Entity\VatRate No errors.
App\Domain\User\Entity\User No errors.
App\Infrastructure\Transaction\QueueTransaction No errors.
App\Domain\Category\Entity\CategoryProduct No errors.
App\Domain\Brand\Entity\Brand
  • The association App\Domain\Brand\Entity\Brand#products refers to the owning side field App\Domain\Product\Entity\Product#product which does not exist.
App\Domain\Listing\Entity\Supplier No errors.
App\Domain\Image\Entity\Image No errors.
App\Domain\Product\Entity\ProductImage No errors.
App\Domain\Customer\Entity\CustomerProduct No errors.
App\Domain\Category\Entity\Category No errors.
App\Infrastructure\Transaction\QueueTransactionError No errors.
App\Domain\Listing\Entity\SupplierUser No errors.
App\Domain\Customer\Entity\Customer No errors.
App\Domain\Customer\Entity\CustomerTransaction No errors.
App\Domain\Brand\Entity\BrandImage No errors.
App\Domain\Listing\Entity\ListingCardImage No errors.
App\Domain\Listing\Entity\ListingCard No errors.
App\Domain\Product\Entity\ProductTransaction
  • The association App\Domain\Product\Entity\ProductTransaction#product refers to the inverse side field App\Domain\Product\Entity\Product#transactions which does not exist.
App\Domain\Admin\Entity\PohodaSyncTransaction No errors.
App\Domain\Order\Entity\OrderTransaction No errors.
App\Domain\Order\Entity\Order No errors.
App\Infrastructure\Transaction\ErrorTransaction No errors.
App\Domain\Monitoring\Entity\MserverStatusTransaction No errors.
App\Domain\Account\Entity\Account No errors.