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

Query Metrics

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

Queries

Group similar statements

default connection

#▲ Time Info
1 0.91 ms
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:
[]
2 0.69 ms
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\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.