Query Metrics
8
Database Queries
6
Different statements
21.38 ms
Query time
27
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.21 ms (0.00%) |
2 |
"COMMIT"
Parameters:
[] |
7.38 ms (0.00%) |
1 |
SELECT json_build_object('id',"_1"."id",'id',"_1"."id",'maximumUses',"_1"."maximum_uses",'alreadyUsed',"_1"."already_used",'userConfirmable',"_1"."trigger_user_confirmable",'validFrom',"_1"."valid_from",'validTo',"_1"."valid_to",'deletedAt',"_1"."deleted_at",'title',"_1"."title",'triggerApplyToAllCustomers',"_1"."trigger_apply_to_all_customers",'deletedAt',"_1"."deleted_at",'items', COALESCE((SELECT json_agg(json_build_object('id',"_2"."id",'id',"_2"."id",'productID',"_2"."product_id",'amount',"_2"."amount",'type',"_2"."type",'excludeTags', COALESCE((SELECT json_agg(json_build_object('id',"_3"."id",'id',"_3"."id",'code',"_3"."code",'name',"_3"."name")) FROM "main"."product_tag" AS "_3" INNER JOIN "client_2"."discount_item__product_tag__exclude" "dipte" ON "dipte"."discount_item_id" = "_2"."id" AND "dipte"."product_tag_id" = "_3"."id"), '[]'::json))) FROM "client_2"."discount_item" AS "_2" WHERE "_1"."id" = "_2"."discount_id"), '[]'::json),'triggerCoupons', COALESCE((SELECT json_agg(json_build_object('id',"_4"."id",'id',"_4"."id",'code',"_4"."code")) FROM "client_2"."discount_coupon" AS "_4" WHERE "_1"."id" = "_4"."discount_id"), '[]'::json),'store', (SELECT json_build_object() FROM "client_2"."store" AS "_6" WHERE "_6"."id" IN (1) AND _1 . store_id = _6 . id),'triggerProducts', COALESCE((SELECT json_agg(json_build_object('id',"_7"."id",'updatedAt',"_7"."updated_at",'createdAt',"_7"."created_at",'deletedAt',"_7"."deleted_at")) FROM "main"."product" AS "_7" INNER JOIN "client_2"."discount__product" "dp" ON "dp"."discount_id" = "_1"."id" AND "dp"."product_id" = "_7"."id"), '[]'::json),'triggerCustomerTypes', COALESCE((SELECT json_agg(json_build_object('id',"_8"."id",'type',"_8"."type",'deletedAt',"_8"."deleted_at")) FROM "client_2"."customer_type" AS "_8" INNER JOIN "client_2"."discount__customer_type" "dct" ON "dct"."discount_id" = "_1"."id" AND "dct"."customer_type_id" = "_8"."id"), '[]'::json)) AS "row" FROM "client_2"."discount" AS "_1" WHERE ("_1"."store_id" IN (SELECT "_5"."id" FROM "client_2"."store" AS "_5" WHERE "_5"."id" IN (1)) OR "_1"."store_id" IS NULL) AND "_1"."deleted_at" IS NULL AND CASE WHEN "_1"."maximum_uses" IS NOT NULL THEN "_1"."already_used" < "_1"."maximum_uses" ELSE TRUE END AND (('2024-09-21 12:58:04' BETWEEN "_1"."valid_from" AND "_1"."valid_to") OR ("_1"."valid_to" IS NULL)) GROUP BY "_1"."id" ORDER BY "_1"."id" ASC LIMIT 10000
Parameters:
[] |
2.34 ms (0.00%) |
1 |
INSERT INTO graphql.request_logging (ip, created_at) VALUES (?, ?)
Parameters:
[ 1 => "88.212.16.151" 2 => "2024-09-21 12:58:04" ] |
1.64 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.eyJ1c2VyIjp7ImlkIjozLCJ1c2VybmFtZSI6InRlc3RmbGlnaHQxIiwibG9jYWxlIjoic2tfU0sifSwiY2xpZW50Ijp7ImlkIjoyLCJuYW1lIjoiVGVzdCBDb21wYW55IiwiY29kZSI6InRlc3QiLCJidXNpbmVzc0lEIjoiMTIzNDU2Nzg5IiwidmF0IjoiU0sxMjM0NTY3ODkiLCJ2YXRQYXllciI6ZmFsc2UsInRheElEIjoiMTIzNDU2Nzg5IiwiYWRkcmVzcyI6eyJjaXR5IjoiS29zaWNlIiwic3RyZWV0IjoiVmVuY292YSIsInN0cmVldF9udW1iZXIiOiIyIiwiemlwIjoiMDQwMDEiLCJjb3VudHJ5IjoiU2xvdmVuc2tvIiwicmVnaW9uIjpudWxsLCJsb25naXR1ZGUiOm51bGwsImxhdGl0dWRlIjpudWxsfX0sInZhbGlkVG8iOiIyMDI0LTA5LTIxIDE2OjAyOjA4IiwiY3JlYXRlZEF0Ijp7ImRhdGUiOiIyMDI0LTA5LTIxIDA4OjAyOjA4LjA4NTIwNyIsInRpbWV6b25lX3R5cGUiOjMsInRpbWV6b25lIjoiRXVyb3BlXC9CcmF0aXNsYXZhIn0sInN0b3JlcyI6W3siaWQiOjEsIm5hbWUiOiJUZXN0IFN0b3JlIn1dLCJzdG9yZUdyb3VwcyI6W119.yhO8YSr6ez5NfBwhsp7PVe_WbPWU5GqIIjTsGr3Sgg_dttEnr6aom3qgDnNNq7ASImcHHX211OUevcgDP3yjzcrrfGOl_9KuCsE1r5fyTB_6uZePYv6jxT_Hl-2oMQrb9O6jClcgOkAbKgS3eUD-D3iMQYvcIex69kGHTgCiSBlgzO5j2rxlNXgpAQd1Bts3vNzGDDrULFscY61bUILceKCKdfbW2Njmm9KOxy3lSPamHTOoPlflmf8SZzNTTCZwUGDHVjZBknP0U21makVLwcScP4lNXC1sVG3F94Zxr6bD5xctExjnINuBY5PvWepOKwk7gny_vrO56RoOlynzJySSyL_P7SkIMg5an-GD5vF7Y7OAxrMNviOLCtt-nC8SZYdNt020K4nP-JDfwYfL845D2Ha3e_qCKZv4ey6F_7sTHlqh8PccxwggUs8DqgIR3ucV8Lsj8GjgCL5pUnpg2PtsgdJcI38keZbsW-s5YNaG3i3QVlA4B30NES5uzQx3VGe3G9sVeGqWfZVRRMHFeMXV5kV42JsCB2QkuT1ncxzN8Wohvr8nlzsmjXOzNuSCMHLFNsL45zFcXhFz5dXH3sylRnbq_6UCz1KUOCR5A0b3pxi3SNk-liH4W5hPN9BlUlpmpaNhtyLT25cp2OBkKY4L-Ywb7q9tCOT_CTJ1ZsI" "2024-09-21 12:58:04" ] |
1.64 ms (0.00%) |
1 |
SELECT t0.business_id AS business_id_1, t0.tax_id AS tax_id_2, t0.vat AS vat_3, t0.country_code AS country_code_4, t0.name AS name_5, t0.active AS active_6, t0.id AS id_7, t0.db_password AS db_password_8, t0.vat_payer AS vat_payer_9, t0.machine_learning AS machine_learning_10, t0.flags AS flags_11, t0.phone_number AS phone_number_12, t0.created_at AS created_at_13, t0.code AS code_14, t0.configuration AS configuration_15, t0.updated_at AS updated_at_16, t0.address_id AS address_id_17, t0.created_by_id AS created_by_id_18, t0.supplier_id AS supplier_id_19, t0.updated_by_id AS updated_by_id_20 FROM main.client t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.17 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 |
|
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 |
|
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 |
|
App\Entity\Client\ImportProduct\ImportProductCSV |
|
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 |
|
App\Entity\Client\Order\Order | No errors. |
App\Entity\Client\Order\OrderProcess |
|
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 |
|
App\Entity\Client\Category\CategoryClientImage | No errors. |
App\Entity\Client\Category\CategoryTranslation | No errors. |
App\Entity\Client\Store\Store |
|
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 |
|
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 |
|
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 |
|
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 |
|
Eshop\Entity\Customer\CustomerOrderAddress | No errors. |
Eshop\Entity\Customer\CustomerAddress | No errors. |
Eshop\Entity\Customer\CustomerOrderItem |
|
Eshop\Entity\Customer\CustomerOrder |
|
Eshop\Entity\Partner\Partner |
|
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 |
|
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 |
|
Eshop\Entity\Delivery\DeliverySlot |
|
Eshop\Entity\Delivery\DeliveryMethod | No errors. |
Eshop\Entity\Delivery\DeliveryMethodPlace |
|
Eshop\Entity\Delivery\DeliveryMethodPlaceValue | No errors. |
Eshop\Entity\Delivery\DeliveryMethodPlaceDate |
|
Eshop\Entity\Rating\RatingValue | No errors. |
Eshop\Entity\Rating\RatingType | No errors. |
Eshop\Entity\Rating\ServiceRating | No errors. |
Eshop\Entity\Article\Article |
|
Eshop\Entity\Article\ArticleProduct |
|
Eshop\Entity\Article\ArticleRecipeAllergen |
|
Eshop\Entity\Article\ArticleBlog |
|
Eshop\Entity\Article\ArticleImage | No errors. |
Eshop\Entity\Article\ArticleCompetition |
|
Eshop\Entity\Article\ArticleProductProduct | No errors. |
Eshop\Entity\Article\ArticleRecipe |
|
Eshop\Entity\Article\ArticleTag | No errors. |
Eshop\Entity\Article\ArticleRecipeProduct | No errors. |
Eshop\Entity\Article\ArticleCompetitionCondition | No errors. |
Eshop\Entity\Category\Category |
|
Eshop\Entity\Category\CategoryTranslation | No errors. |
Eshop\Entity\DiscountCoupon\DiscountCoupon | No errors. |