https://graphql.stage.flowy.sk/

Query Metrics

7 Database Queries
5 Different statements
17.18 ms Query time
27 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.76 ms
(0.00%)
1
SELECT t0_.id AS id_0, t0_.hash AS hash_1, t0_.customer_id AS customer_id_2, t0_.valid_to AS valid_to_3, t0_.created_at AS created_at_4, t0_.roles AS roles_5, t0_.user_id AS user_id_6, t0_.client_id AS client_id_7 FROM main.token_jwt t0_ WHERE t0_.hash = ? AND t0_.valid_to > ?
Parameters:
[
  "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJ1c2VyIjp7ImlkIjozLCJ1c2VybmFtZSI6InRlc3RmbGlnaHQxIiwibG9jYWxlIjoic2tfU0sifSwiY2xpZW50Ijp7ImlkIjoyLCJuYW1lIjoiVGVzdCBDb21wYW55IiwiY29kZSI6InRlc3QiLCJidXNpbmVzc0lEIjoiMTIzNDU2Nzg5IiwidmF0IjoiU0sxMjM0NTY3ODkiLCJ2YXRQYXllciI6ZmFsc2UsInRheElEIjoiMTIzNDU2Nzg5IiwiYWRkcmVzcyI6eyJjaXR5IjoiS29zaWNlIiwic3RyZWV0IjoiVmVuY292YSIsInN0cmVldF9udW1iZXIiOiIyIiwiemlwIjoiMDQwMDEiLCJjb3VudHJ5IjoiU2xvdmVuc2tvIiwicmVnaW9uIjpudWxsLCJsb25naXR1ZGUiOm51bGwsImxhdGl0dWRlIjpudWxsfX0sInZhbGlkVG8iOiIyMDI0LTA5LTIyIDAwOjAzOjA1IiwiY3JlYXRlZEF0Ijp7ImRhdGUiOiIyMDI0LTA5LTIxIDE2OjAzOjA1LjI3NTQxOSIsInRpbWV6b25lX3R5cGUiOjMsInRpbWV6b25lIjoiRXVyb3BlXC9CcmF0aXNsYXZhIn0sInN0b3JlcyI6W3siaWQiOjEsIm5hbWUiOiJUZXN0IFN0b3JlIn1dLCJzdG9yZUdyb3VwcyI6W119.ZmczXtdxZYEULJGWL0IVw2us4Mdi8OGTEKIw15zsYu5iCnuAFtgo52pzC6z5_PnftCn2dX1AdhsVPsi9nF3CB71udvA_hst8wSB1cPv76WD7XQcrXq5yByatDN3-CQBKcTQkG2-Ye4H3ZgYFmAOLhsCBV3kI8WIMyldJX3f1w9Kk02hTHikOgk-xULi3DIYBX8ZfVKjgUJJk6le1R0YBn7AsZSgxxm_Mki2QOcRYdz_QO3YCPGT3V0xLnLPEJPS-KSz6wOxQL36KWrgud-5U8iwozApEGfXgAj6so3bGnRDYRNn-JSJzoU_1VmNzVtfTUA-q6jFRT0EES2gZM_ryHdWZGfQgHVOn9CsYlqvz7DCRyzpZMVy34SXPfFEO3jy12bSIpOaTR75Ksl8KS7eOfrGt-3ZBlwFFmjZBOvKGVfULILIoisvT7B2uGzcYLl3yAx4jbinbra7BojRJ818IYvhRYjHJrYqUn6d2jTQNlWGcPScPxXPX30KbHlldgefqGtcORVBTpsbyOfi10-dTjlx6Fdk64YH8rUoLKIjMAYKYlyumt8ue1GqocAsp92OlF972p6aj9rj-rjfmoSONpmjwJ6FnS8saJx46Cy0r0evLK0m70bgbN9EB2kHyHu3Nk2cdrbXKtc1LWmoi6z4kd2K2ygvaiIh-T9i-oJVmPAg"
  "2024-09-21 16:48:04"
]
5.36 ms
(0.00%)
2
"COMMIT"
Parameters:
[]
3.50 ms
(0.00%)
1
SELECT
    json_build_object('id',"_1"."id",'type',"_1"."type",'code',"_1"."code",'points',"_1"."total_points",'updatedAt',"_1"."updated_at",'createdAt',"_1"."created_at",'deletedAt',"_1"."deleted_at") AS "row"
FROM
    "client_2"."customer" AS "_1"
GROUP BY
    "_1"."id"
ORDER BY
    "_1"."id" ASC
LIMIT 20000
Parameters:
[]
1.28 ms
(0.00%)
1
INSERT INTO graphql.request_logging (ip, created_at) VALUES (?, ?)
Parameters:
[
  1 => "88.212.16.151"
  2 => "2024-09-21 16:48:04"
]
0.27 ms
(0.00%)
2
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
GraphQL\Entity\RequestLogging No errors.
App\Entity\Central\Token\JWTToken No errors.
App\Entity\Central\User\User No errors.
App\Entity\Central\Company\AbstractCompany No errors.
App\Entity\Central\Client\Client No errors.
App\Entity\Central\Address\Address No errors.
App\Entity\Central\Supplier\Supplier No errors.
App\Entity\Client\User\UserData No errors.
App\Entity\AbstractTranslation No errors.
App\Entity\Central\Weather\Weather No errors.
App\Entity\Central\Receipt\Receipt No errors.
App\Entity\Central\Receipt\ReceiptMetro No errors.
App\Entity\Central\Receipt\ReceiptLabas No errors.
App\Entity\Central\Receipt\ReceiptGlobus No errors.
App\Entity\Central\Command\Command No errors.
App\Entity\Central\Logger\Logger No errors.
App\Entity\Central\Logger\LoggerApi No errors.
App\Entity\Central\Product\ProductImport No errors.
App\Entity\Central\Product\ProductPackage No errors.
App\Entity\Central\Product\ProductLocaleRestriction No errors.
App\Entity\Central\Storage\File No errors.
App\Entity\Central\Storage\Image No errors.
App\Entity\Central\Product\ProductImage No errors.
App\Entity\Central\Product\ProductSuggestion No errors.
App\Entity\Central\Product\ProductTranslation No errors.
App\Entity\Central\Product\ProductAttributeValueTranslation No errors.
App\Entity\Central\Product\ProductTax No errors.
App\Entity\Central\Product\ProductTag No errors.
App\Entity\Central\Product\ProductContainers No errors.
App\Entity\Central\Product\ProductAlert No errors.
App\Entity\Central\Product\ProductAttributeValue No errors.
App\Entity\Central\Product\Product
  • The field App\Entity\Central\Product\Product#storeStocks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\Store\StoreStock#product does not contain the required 'inversedBy="storeStocks"' attribute.
App\Entity\Central\Notification\Notification No errors.
App\Entity\Central\Config\Config No errors.
App\Entity\Central\Token\ApiToken No errors.
App\Entity\Central\Tax\Tax No errors.
App\Entity\Central\Attribute\Attribute No errors.
App\Entity\Central\Attribute\AttributeTranslation No errors.
App\Entity\Central\Attribute\AttributeValueTranslation No errors.
App\Entity\Central\Attribute\AttributeValue No errors.
App\Entity\Central\Company\Company No errors.
App\Entity\Central\Country\Country No errors.
App\Entity\Central\Supplier\SupplierProductPackage No errors.
App\Entity\Central\Supplier\SupplierProduct
  • The field App\Entity\Central\Supplier\SupplierProduct#supplierProductPackages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Central\Supplier\SupplierProductPackage#supplierProduct does not contain the required 'inversedBy="supplierProductPackages"' attribute.
App\Entity\Central\Recipes\Recipes No errors.
App\Entity\Central\Recipes\RecipesClient No errors.
App\Entity\Central\Recipes\RecipesItem No errors.
App\Entity\Central\Location\Location No errors.
App\Entity\Central\Brandbank\BrandbankXML No errors.
App\Entity\Central\Brandbank\Brandbank No errors.
App\Entity\Central\Label\Label No errors.
App\Entity\Central\Category\Category No errors.
App\Entity\Central\Category\CategoryImage No errors.
App\Entity\Central\Category\CategoryTranslation No errors.
App\Entity\Central\ArticleNumber\EuropeanArticleNumber No errors.
App\Entity\Central\Import\ImportReceiptGlobus No errors.
App\Entity\Central\Import\ImportReceiptLabas No errors.
App\Entity\Central\Import\ImportReceiptMetro No errors.
App\Entity\Central\City\City No errors.
App\Entity\Central\Holiday\Holiday No errors.
App\Entity\Central\Holiday\HolidayDay No errors.
App\Entity\Central\Cron\Cron No errors.
App\Entity\Central\MachineLearning\MachineLearning No errors.
App\Entity\Client\Address\Address No errors.
App\Entity\Client\Synchronization\Synchronization No errors.
App\Entity\Client\ImportProduct\ImportProductCSVItem
  • The association App\Entity\Client\ImportProduct\ImportProductCSVItem#importProductCSV refers to the inverse side field App\Entity\Client\ImportProduct\ImportProductCSV#importProductCSVItem which does not exist.
App\Entity\Client\ImportProduct\ImportProductCSV
  • The mappings App\Entity\Client\ImportProduct\ImportProductCSV#importProductCSVItems and App\Entity\Client\ImportProduct\ImportProductCSVItem#importProductCSV are inconsistent with each other.
App\Entity\Client\Product\ProductVariable No errors.
App\Entity\Client\Product\Product No errors.
App\Entity\Client\Customer\CustomerType No errors.
App\Entity\Client\Customer\CustomerToken No errors.
App\Entity\Client\Customer\CustomerPoint No errors.
App\Entity\Client\Customer\CustomerDiscount No errors.
App\Entity\Client\Customer\Customer No errors.
App\Entity\Client\Order\OrderItem No errors.
App\Entity\Client\Order\OrderProcessRecord
  • The association App\Entity\Client\Order\OrderProcessRecord#orderProcess refers to the inverse side field App\Entity\Client\Order\OrderProcess#items which does not exist.
App\Entity\Client\Order\Order No errors.
App\Entity\Client\Order\OrderProcess
  • The mappings App\Entity\Client\Order\OrderProcess#orderProcessRecords and App\Entity\Client\Order\OrderProcessRecord#orderProcess are inconsistent with each other.
App\Entity\Client\Order\OrderProductQuantityIncrease No errors.
App\Entity\Client\Attribute\AttributeMargin No errors.
App\Entity\Client\HistoricalDeviation\HistoricalDeviation No errors.
App\Entity\Client\HistoricalDeviation\HistoricalDeviationByDay No errors.
App\Entity\Client\Discount\DiscountCoupon No errors.
App\Entity\Client\Discount\DiscountType No errors.
App\Entity\Client\Discount\DiscountItem No errors.
App\Entity\Client\Discount\Discount No errors.
App\Entity\Client\Supplier\Supplier No errors.
App\Entity\Client\Supplier\SupplierOrder No errors.
App\Entity\Client\Supplier\SupplierOrderProduct No errors.
App\Entity\Client\PointOfSale\PointOfSale No errors.
App\Entity\Client\PointOfSale\PointOfSaleMove No errors.
App\Entity\Client\Prediction\Prediction No errors.
App\Entity\Client\Importer\ImporterProduct No errors.
App\Entity\Client\Label\Label No errors.
App\Entity\Client\Category\Category
  • The association App\Entity\Client\Category\Category#parentCategory refers to the inverse side field App\Entity\Client\Category\Category#children which does not exist.
  • The association App\Entity\Client\Category\Category#subCategory refers to the owning side field App\Entity\Client\Category\Category#parent which does not exist.
App\Entity\Client\Category\CategoryClientImage No errors.
App\Entity\Client\Category\CategoryTranslation No errors.
App\Entity\Client\Store\Store
  • The field App\Entity\Client\Store\Store#paymentMethods is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\Payment\PaymentMethod#stores does not contain the required 'inversedBy="paymentMethods"' attribute.
App\Entity\Client\Store\StoreStockGroup No errors.
App\Entity\Client\Store\StoreAlert No errors.
App\Entity\Client\Store\StoreHeaderRounding No errors.
App\Entity\Client\Store\StoreSettlement No errors.
App\Entity\Client\Store\StoreMove No errors.
App\Entity\Client\Store\StoreStockSellPrice No errors.
App\Entity\Client\Store\StoreStockUpdate No errors.
App\Entity\Client\Store\StoreSell No errors.
App\Entity\Client\Store\StoreStockPlace No errors.
App\Entity\Client\Store\StoreHeaderPayment No errors.
App\Entity\Client\Store\StoreCentral No errors.
App\Entity\Client\Store\StoreHeader No errors.
App\Entity\Client\Store\StoreMoveDiscount No errors.
App\Entity\Client\Store\StoreGroup No errors.
App\Entity\Client\Store\StoreStock
  • The field App\Entity\Client\Store\StoreStock#defaultStoreStockPlace is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\Store\StoreStockPlace# does not contain the required 'inversedBy' attribute.
  • If association App\Entity\Client\Store\StoreStock#defaultStoreStockPlace is many-to-one, then the inversed side App\Entity\Client\Store\StoreStockPlace#store has to be one-to-many.
App\Entity\Client\Store\StoreMoveBarcode No errors.
App\Entity\Client\Store\StoreInventory No errors.
App\Entity\Client\Permission\Permission No errors.
App\Entity\Client\Import\AbstractImport No errors.
App\Entity\Client\Import\ImportStore
  • The field App\Entity\Client\Import\ImportStore#changes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\Import\ImportStoreChange#import does not contain the required 'inversedBy="changes"' attribute.
App\Entity\Client\Import\AbstractImportChange No errors.
App\Entity\Client\Import\ImportStoreChange No errors.
App\Entity\Client\Import\ImportProductChange No errors.
App\Entity\Client\Import\ImportProduct
  • The field App\Entity\Client\Import\ImportProduct#changes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Client\Import\ImportProductChange#import does not contain the required 'inversedBy="changes"' attribute.
App\Entity\Client\Import\ImportPermission No errors.
App\Entity\Client\Sell\SellPriceProduct No errors.
App\Entity\Client\Sell\SellPrice No errors.
App\Entity\Client\Payment\PaymentMethodTranslation No errors.
App\Entity\Client\Payment\PaymentMethod No errors.
App\Entity\Client\PriceTag\PriceTag No errors.
Eshop\Entity\Customer\CustomerOrderPaymentMethod
  • The association Eshop\Entity\Customer\CustomerOrderPaymentMethod#order refers to the inverse side field Eshop\Entity\Customer\CustomerOrder#customerOrderPaymentMethods which does not exist.
Eshop\Entity\Customer\CustomerOrderAddress No errors.
Eshop\Entity\Customer\CustomerAddress No errors.
Eshop\Entity\Customer\CustomerOrderItem
  • The association Eshop\Entity\Customer\CustomerOrderItem#storeMove refers to the owning side field App\Entity\Client\Store\StoreMove#customerOrder which does not exist.
Eshop\Entity\Customer\CustomerOrder
  • The mappings Eshop\Entity\Customer\CustomerOrder#paymentMethods and Eshop\Entity\Customer\CustomerOrderPaymentMethod#order are inconsistent with each other.
  • The association Eshop\Entity\Customer\CustomerOrder#storeHeader refers to the owning side field App\Entity\Client\Store\StoreHeader#customerOrder which does not exist.
Eshop\Entity\Partner\Partner
  • The association Eshop\Entity\Partner\Partner#partnerFile refers to the owning side field Eshop\Entity\Partner\PartnerFile#partner which does not exist.
Eshop\Entity\Partner\PartnerFile No errors.
Eshop\Entity\Partner\PartnerImage No errors.
Eshop\Entity\Newsletter\NewsletterFile No errors.
Eshop\Entity\Newsletter\NewsletterImage No errors.
Eshop\Entity\Newsletter\Newsletter
  • The association Eshop\Entity\Newsletter\Newsletter#newsletterFile refers to the owning side field Eshop\Entity\Newsletter\NewsletterFile#newsletter which does not exist.
Eshop\Entity\Config\Config No errors.
Eshop\Entity\ProductCategory\ProductCategory No errors.
Eshop\Entity\Banner\BannerRedirect No errors.
Eshop\Entity\Banner\BannerNewsletterRedirect No errors.
Eshop\Entity\Banner\BannerUrlRedirect No errors.
Eshop\Entity\Banner\BannerProductRedirect No errors.
Eshop\Entity\Banner\Banner No errors.
Eshop\Entity\Banner\BannerProductsRedirect No errors.
Eshop\Entity\Banner\BannerArticleRedirect No errors.
Eshop\Entity\Banner\BannerImage No errors.
Eshop\Entity\Delivery\DeliveryMethodPlaceDatePrice No errors.
Eshop\Entity\Delivery\DeliveryMethodPlaceDateExclude
  • The association Eshop\Entity\Delivery\DeliveryMethodPlaceDateExclude#deliveryMethodPlaceDate refers to the inverse side field Eshop\Entity\Delivery\DeliveryMethodPlaceDate#deliveryMethodPlaceDates which does not exist.
Eshop\Entity\Delivery\DeliverySlot
  • The association Eshop\Entity\Delivery\DeliverySlot#deliveryMethod refers to the inverse side field Eshop\Entity\Delivery\DeliveryMethod#deliverySlots which does not exist.
  • The association Eshop\Entity\Delivery\DeliverySlot#deliveryMethodPlaceValue refers to the inverse side field Eshop\Entity\Delivery\DeliveryMethodPlaceValue#deliverySlots which does not exist.
Eshop\Entity\Delivery\DeliveryMethod No errors.
Eshop\Entity\Delivery\DeliveryMethodPlace
  • The mappings Eshop\Entity\Delivery\DeliveryMethodPlace#deliveryMethodPlaceDates and Eshop\Entity\Delivery\DeliveryMethodPlaceDate#deliveryMethodPlace are inconsistent with each other.
Eshop\Entity\Delivery\DeliveryMethodPlaceValue No errors.
Eshop\Entity\Delivery\DeliveryMethodPlaceDate
  • The association Eshop\Entity\Delivery\DeliveryMethodPlaceDate#deliveryMethodPlace refers to the inverse side field Eshop\Entity\Delivery\DeliveryMethodPlace#deliveryMethodPlaceSettings which does not exist.
  • The mappings Eshop\Entity\Delivery\DeliveryMethodPlaceDate#deliveryMethodPlaceDateExcludes and Eshop\Entity\Delivery\DeliveryMethodPlaceDateExclude#deliveryMethodPlaceDate are inconsistent with each other.
Eshop\Entity\Rating\RatingValue No errors.
Eshop\Entity\Rating\RatingType No errors.
Eshop\Entity\Rating\ServiceRating No errors.
Eshop\Entity\Article\Article
  • The field Eshop\Entity\Article\Article#redirect is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Eshop\Entity\Banner\BannerArticleRedirect#article does not contain the required 'inversedBy="redirect"' attribute.
Eshop\Entity\Article\ArticleProduct
  • The field Eshop\Entity\Article\ArticleProduct#redirect is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Eshop\Entity\Banner\BannerArticleRedirect#article does not contain the required 'inversedBy="redirect"' attribute.
Eshop\Entity\Article\ArticleRecipeAllergen
  • The association Eshop\Entity\Article\ArticleRecipeAllergen#articleRecipe refers to the inverse side field Eshop\Entity\Article\ArticleRecipe#$allergens which does not exist.
Eshop\Entity\Article\ArticleBlog
  • The field Eshop\Entity\Article\ArticleBlog#redirect is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Eshop\Entity\Banner\BannerArticleRedirect#article does not contain the required 'inversedBy="redirect"' attribute.
Eshop\Entity\Article\ArticleImage No errors.
Eshop\Entity\Article\ArticleCompetition
  • The field Eshop\Entity\Article\ArticleCompetition#redirect is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Eshop\Entity\Banner\BannerArticleRedirect#article does not contain the required 'inversedBy="redirect"' attribute.
Eshop\Entity\Article\ArticleProductProduct No errors.
Eshop\Entity\Article\ArticleRecipe
  • The field Eshop\Entity\Article\ArticleRecipe#redirect is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Eshop\Entity\Banner\BannerArticleRedirect#article does not contain the required 'inversedBy="redirect"' attribute.
  • The mappings Eshop\Entity\Article\ArticleRecipe#allergens and Eshop\Entity\Article\ArticleRecipeAllergen#articleRecipe are inconsistent with each other.
Eshop\Entity\Article\ArticleTag No errors.
Eshop\Entity\Article\ArticleRecipeProduct No errors.
Eshop\Entity\Article\ArticleCompetitionCondition No errors.
Eshop\Entity\Category\Category
  • The association Eshop\Entity\Category\Category#parentCategory refers to the inverse side field Eshop\Entity\Category\Category#children which does not exist.
Eshop\Entity\Category\CategoryTranslation No errors.
Eshop\Entity\DiscountCoupon\DiscountCoupon No errors.