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

Query Metrics

2 Database Queries
2 Different statements
1.82 ms Query time
3 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
1.22 ms
(66.94%)
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.60 ms
(33.06%)
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\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\Infrastructure\Transaction\QueueTransactionError No errors.
App\Domain\Category\Entity\Category 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\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.