Query Metrics
3
Database Queries
3
Different statements
11.40 ms
Query time
3
Invalid entities
0
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
5.70 ms (49.99%) |
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 ((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—Õtváyx¢í|R\x16pYÐ" b"\x01—Õtváyx¢í|R\x16pYÐ" ] |
|
4.94 ms (43.36%) |
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 ((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—Õtváyx¢í|R\x16pYÐ" b"\x01—Õtváyx¢í|R\x16pYÐ" ] |
|
0.76 ms (6.65%) |
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•ìj"Ívʵ\x18^/\x15”\x1A–" b"\x01•ìi½z\¾\x05X¼\x04\x13^h" b"\x01•ìj\x18;\x7FÜ¿JÑø²P5z" b"\x01•ìi¸y\t— ;\x1E\ðd" b"\x01•ìiòßy\x1C±¸ŽFBùKk" b"\x01•ìi»$s\x1E›Ý˰]‚Ó" b"\x01•ìi»Fq˜’ 6ltŒ-u" b"\x01•ìi»’~&èÚÁ÷%¼\x06" b"\x01•ìi½Y~×›Q¬¶Ó?†Ñ" b"\x01•ìi¼´}䜓2àE.\x10»" b"\x01•ìi¾\x03vÚ¬«ì_ ––>" b"\x01•ìiòÃz\ee1=òã," b"\x01•ìiò sÆ›\x1CÆÃ¦Ïq˜" b"\x01•ìiòŠvM¿<\t3ÙíP\x00" b"\x01•ìj"®s\e´æ§RlâÊS" b"\x01•ìi»msô–±^,d†DV" b"\x01•ìj"‹y¯ƒU\x04ÿö¥Q\f" b"\x01•ìi»±u!„GÄ%I\x7F\v‡" b"\x01•ìiòVy«šÈ«Þ\x12p\x1Cü" b"\x01•ìi»ÌyÁ±ñh3mê¶" ] |
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\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 |
|
| 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 |
|
| 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 |
|
| 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. |