POST https://x.glomex.dev.gtsoftware.cz/api/v1/product

Query Metrics

3 Database Queries
3 Different statements
11.21 ms Query time
3 Invalid entities
3 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 6.12 ms
SELECT p0_.uuid AS sclr_0, i1_.medium_url AS sclr_1, p0_.name AS sclr_2, COALESCE(p0_.identifiers_order_code) AS sclr_3, p0_.identifiers_product_ean AS sclr_4, 0 AS sclr_5, p0_.stock_available AS sclr_6, c2_.name AS sclr_7, c2_.uuid AS sclr_8, p0_.measurements_quantity_per_carton AS sclr_9, p0_.min_order_quantity AS sclr_10, i3_.medium_url AS sclr_11 FROM product p0_ LEFT JOIN brand b4_ ON p0_.brand_id = b4_.uuid LEFT JOIN image i3_ ON b4_.logo_id = i3_.uuid AND i3_.discr IN ('product', 'brand', 'listingCard') LEFT JOIN category_product c5_ ON p0_.uuid = c5_.product_id LEFT JOIN category c2_ ON c5_.category_id = c2_.uuid LEFT JOIN category c6_ ON c2_.parent_id = c6_.uuid LEFT JOIN image i1_ ON (i1_.product_id = p0_.uuid AND i1_.position = 0) AND i1_.discr IN ('product') WHERE p0_.archived = 0 AND p0_.published = 1 AND (p0_.pricing_selling_price) > 0 AND ((c2_.uuid = ? OR c6_.uuid = ?)) AND p0_.published = 1 ORDER BY CASE WHEN c2_.uuid IS NULL THEN 1 ELSE 0 END ASC, CASE WHEN c6_.uuid IS NULL THEN c2_.order_position ELSE c6_.order_position END ASC, CASE WHEN c6_.uuid IS NULL THEN -1 ELSE c2_.order_position END ASC, c5_.position ASC, p0_.name ASC LIMIT 20
Parameters:
[
  b"\x01—ÕrAÐyø¾µ\x1CÏ\x14\f¢3"
  b"\x01—ÕrAÐyø¾µ\x1CÏ\x14\f¢3"
]
2 0.84 ms
SELECT t0_.uuid AS uuid_0, t1_.uuid AS uuid_1, t1_.name AS name_2, t1_.retail AS retail_3, t1_.registered AS registered_4, t1_.public AS public_5, t1_.archived AS archived_6, t1_.news AS news_7, t1_.top_seller AS top_seller_8, t1_.action AS action_9, t1_.color AS color_10, t0_.tag_id AS tag_id_11, t0_.product_id AS product_id_12 FROM tag_product t0_ LEFT JOIN tag t1_ ON t0_.tag_id = t1_.uuid WHERE t1_.archived = 0 AND t0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t1_.public = 1
Parameters:
[
  b"\x01•ìiÄ9~]\x10P\x13Žà!¢"
  b"\x01•ìj\x18f\x7Fj‹©æ\x00jø\x11Á"
  b"\x01•ìiºŠpµµ†´ë~Öí\e"
  b"\x01•ìiá\x02pã’ŸÐ\r¸­ßÄ"
  b"""
    \x01•ìiº£v!—)k?\n
    µê¦
    """
  b"\x01•ìj\x11Eq¨\x1Eïâ(¼|,"
  b"\x01•ìiá"w\x08j£€à!,È"
  b"\x01•ìiòø{\‰\eánÿ\x15c&"
  b"\x01•ìió\etωR0\x08/Ø¡¬"
  b"\x01•ìiº»pz”ÑõfŽZåÄ"
  b"\x01•ìiÅQ|­¬\x00Ž˜\v^Þ…"
  b"\x01•ìj\x16,p\x06·\x12L<“Sa"
  b"\x01•ìiÊ¿}ã—ÒˆÃ]9\x16§"
  b"\x01•ìj$¼q¢µÇGØÎQÓ"
  b"\x01•ìj\x16\x00~\x13‡‡ä#±Ö\x1A"
  b"\x01•ìj,\x7F|ð‘Ê <ö„\x0Er"
  b"\x01•ìj\x04qv·€\x18Ù\f)¢}s"
  b"\x01•ìj\x04Ny²–L „ò<*"
  b"\x01•ìiêYt¯‚äõÆ\x11\x01¶ "
  b"\x01•ìiÇòyÈ».¤çr€2\x0F"
]
3 4.25 ms
SELECT COUNT(p0_.uuid) AS sclr_0 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.uuid LEFT JOIN image i2_ ON b1_.logo_id = i2_.uuid AND i2_.discr IN ('product', 'brand', 'listingCard') LEFT JOIN category_product c3_ ON p0_.uuid = c3_.product_id LEFT JOIN category c4_ ON c3_.category_id = c4_.uuid LEFT JOIN category c5_ ON c4_.parent_id = c5_.uuid LEFT JOIN image i6_ ON (i6_.product_id = p0_.uuid AND i6_.position = 0) AND i6_.discr IN ('product') WHERE p0_.archived = 0 AND p0_.published = 1 AND (p0_.pricing_selling_price) > 0 AND ((c4_.uuid = ? OR c5_.uuid = ?)) AND p0_.published = 1 ORDER BY CASE WHEN c4_.uuid IS NULL THEN 1 ELSE 0 END ASC, CASE WHEN c5_.uuid IS NULL THEN c4_.order_position ELSE c5_.order_position END ASC, CASE WHEN c5_.uuid IS NULL THEN -1 ELSE c4_.order_position END ASC, c3_.position ASC, p0_.name ASC
Parameters:
[
  b"\x01—ÕrAÐyø¾µ\x1CÏ\x14\f¢3"
  b"\x01—ÕrAÐyø¾µ\x1CÏ\x14\f¢3"
]

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\Tag\Entity\TagProduct 1
App\Domain\Product\Entity\Product 1
App\Domain\Tag\Entity\Tag 1

Entities Mapping

Class Mapping errors
App\Domain\Category\Entity\Category No errors.
App\Domain\Category\Entity\CategoryProduct 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\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\Tag\Entity\TagProduct No errors.
App\Domain\Customer\Entity\CustomerProduct No errors.
App\Infrastructure\Transaction\QueueTransactionError No errors.
App\Domain\Listing\Entity\SupplierUser No errors.
App\Domain\Tag\Entity\Tag 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.