Query Metrics
2
Database Queries
2
Different statements
1.34 ms
Query time
3
Invalid entities
10
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.91 ms (67.80%) |
1 |
SELECT b0_.uuid AS uuid_0, b0_.name AS name_1, b0_.description AS description_2, b0_.type AS type_3, b0_.archived AS archived_4, i1_.uuid AS uuid_5, i1_.original_url AS original_url_6, i1_.medium_url AS medium_url_7, i1_.small_url AS small_url_8, i1_.pdf_url AS pdf_url_9, i1_.width AS width_10, i1_.height AS height_11, i1_.size AS size_12, i1_.mime AS mime_13, i1_.position AS position_14, i1_.role AS role_15, i2_.uuid AS uuid_16, i2_.original_url AS original_url_17, i2_.medium_url AS medium_url_18, i2_.small_url AS small_url_19, i2_.pdf_url AS pdf_url_20, i2_.width AS width_21, i2_.height AS height_22, i2_.size AS size_23, i2_.mime AS mime_24, i2_.position AS position_25, i2_.role AS role_26, b0_.cover_id AS cover_id_27, b0_.logo_id AS logo_id_28, i1_.discr AS discr_29, i1_.product_id AS product_id_30, i1_.listing_card_id AS listing_card_id_31, i2_.discr AS discr_32, i2_.product_id AS product_id_33, i2_.listing_card_id AS listing_card_id_34 FROM brand b0_ LEFT JOIN image i1_ ON b0_.cover_id = i1_.uuid AND i1_.discr IN ('product', 'brand', 'listingCard') LEFT JOIN image i2_ ON b0_.logo_id = i2_.uuid AND i2_.discr IN ('product', 'brand', 'listingCard') WHERE b0_.archived = 0
Parameters:
[] |
|
0.43 ms (32.20%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT uuid_0 FROM (SELECT b0_.uuid AS uuid_0, b0_.name AS name_1, b0_.description AS description_2, b0_.type AS type_3, b0_.archived AS archived_4, i1_.uuid AS uuid_5, i1_.original_url AS original_url_6, i1_.medium_url AS medium_url_7, i1_.small_url AS small_url_8, i1_.pdf_url AS pdf_url_9, i1_.width AS width_10, i1_.height AS height_11, i1_.size AS size_12, i1_.mime AS mime_13, i1_.position AS position_14, i1_.role AS role_15, i2_.uuid AS uuid_16, i2_.original_url AS original_url_17, i2_.medium_url AS medium_url_18, i2_.small_url AS small_url_19, i2_.pdf_url AS pdf_url_20, i2_.width AS width_21, i2_.height AS height_22, i2_.size AS size_23, i2_.mime AS mime_24, i2_.position AS position_25, i2_.role AS role_26, i1_.discr AS discr_27, i2_.discr AS discr_28 FROM brand b0_ LEFT JOIN image i1_ ON b0_.cover_id = i1_.uuid AND i1_.discr IN ('product', 'brand', 'listingCard') LEFT JOIN image i2_ ON b0_.logo_id = i2_.uuid AND i2_.discr IN ('product', 'brand', 'listingCard') WHERE b0_.archived = 0) dctrn_result) dctrn_table
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\Image\Entity\Image | 6 |
| App\Domain\Brand\Entity\Brand | 4 |
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 |
|
| 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 |
|
| 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 |
|
| 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. |