Query Metrics
7
Database Queries
5
Different statements
11.42 ms
Query time
27
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.56 ms (0.00%) |
2 |
"COMMIT"
Parameters:
[] |
2.08 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:37:05" ] |
1.92 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.58 ms (0.00%) |
1 |
INSERT INTO graphql.request_logging (ip, created_at) VALUES (?, ?)
Parameters:
[ 1 => "88.212.16.151" 2 => "2024-09-21 12:37:05" ] |
0.28 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. |