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

Query Metrics

3 Database Queries
3 Different statements
25.50 ms Query time
3 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
16.25 ms
(63.75%)
1
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 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 OFFSET 540
Parameters:
[]
8.43 ms
(33.04%)
1
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 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:
[]
0.82 ms
(3.21%)
1
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é\x00v\x13Œ(œÑ^J>\t"
  b"\x01•ìiö¼xn¤,–\x0E†þܸ"
  b"\x01•ìjXa}¶\x08WqS).L"
  b"\x01•ìiàèp4¶\vq\x0E¸\x00O"
  b"\x01•ìiüÂr\x07¹\f¨SËêCm"
  b"\x01•ìjB}r’|¢\x04a\x1Eqœ"
  b"\x01•ìjB°x•”‡Ó\x08\x0ETìø"
  b"\x01•ìiðrsªù\ÎÀWw‚"
  b"\x01•ìiðzp…^ý³¢ÑF"
  b"\x01•ìi»pϐ:ÕV³›—"
  b"""
    \x01•ìj-`s´ªkÄÝ"Y\n
    \x1E
    """
  b"\x01•ìj*êtͤ\f ytko\x07"
  b"\x01•ìj*Èy\x18¢Ê\x13A\vVRè"
  b"\x01•ìj*©r\x06¦\x01\f\n\x00#¡ç"
  b"\x01•ìj\x10xxì³`<¸@§8"
  b"\x01•ìj$]u\x16šB(œ—¶´ó"
  b"\x01•ìiÝtu\x03“ó¨Tm÷KX"
  b"\x01•ìiÝ‘{À¡>\x11„üœ¸%"
  b"\x01•ìiݱz£ªZ¬¿;Þ\x02\"
  b"\x01•ìiÝÉzs›ñ{ß´[%\x04"
]

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

Entities Mapping

Class Mapping 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\Image\Entity\Image No errors.
App\Domain\Product\Entity\ProductImage No errors.
App\Domain\Brand\Entity\BrandImage No errors.
App\Domain\Listing\Entity\ListingCardImage 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\Listing\Entity\ListingCard No errors.
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\Listing\Entity\Supplier No errors.
App\Domain\Tag\Entity\TagProduct No errors.
App\Domain\Customer\Entity\CustomerProduct No errors.
App\Domain\Tag\Entity\Tag No errors.
App\Infrastructure\Transaction\QueueTransactionError No errors.
App\Domain\Category\Entity\Category 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\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.