Query Metrics

5 Database Queries
3 Different statements
1.76 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.array_value AS array_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.type AS type_8 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "etl_url"
]
2 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.array_value AS array_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.type AS type_8 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  ""
]
3 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.array_value AS array_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.type AS type_8 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "pimcore_url"
]
4 0.44 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.trigramme AS trigramme_3, t0.url AS url_4, t0.remote_folder AS remote_folder_5, t0.is_m2 AS is_m2_6, t0.is_active AS is_active_7, t0.is_aws AS is_aws_8, t0.is_apple_pay AS is_apple_pay_9, t0.is_pimcore AS is_pimcore_10, t0.max_variance AS max_variance_11, t0.is_order_import_enabled AS is_order_import_enabled_12, t0.is_image_import_enabled AS is_image_import_enabled_13, t0.is_promo_enable AS is_promo_enable_14, t0.mail AS mail_15, t0.is_prod AS is_prod_16, t0.force_image_import AS force_image_import_17, t0.aws_host AS aws_host_18, t0.aws_user_bdd AS aws_user_bdd_19, t0.aws_db_pass AS aws_db_pass_20, t0.updated_at_api AS updated_at_api_21, t22.id AS id_23, t22.erp_active_products AS erp_active_products_24, t22.pim_active_products AS pim_active_products_25, t22.website_active_products AS website_active_products_26, t22.erp_backorder_products AS erp_backorder_products_27, t22.website_backorder_products AS website_backorder_products_28, t22.website_id AS website_id_29 FROM website t0 LEFT JOIN website_statistics t22 ON t22.website_id = t0.id WHERE t0.trigramme = ? LIMIT 1
Parameters:
[
  "OSB"
]
5 0.48 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "dsi"
]

Database Connections

Name Service
local doctrine.dbal.local_connection

Entity Managers

Name Service
api doctrine.orm.api_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\App\Configuration No errors.
App\Entity\Api\Website No errors.
App\Entity\Api\WebsiteStatistics No errors.
App\Entity\Api\Product No errors.
App\Entity\Api\DeliveryStatus No errors.
App\Entity\Api\Store No errors.
App\Entity\Api\MagentoOrder No errors.
App\Entity\Api\MagentoAddress No errors.
App\Entity\Api\MagentoItem No errors.
App\Entity\Api\MagentoPayment No errors.
App\Entity\Api\PimcoreProduct
  • The field App\Entity\Api\PimcoreProduct#product is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Api\Product#pimcoreProduct does not contain the required 'inversedBy="product"' attribute.
App\Entity\Api\MagentoProductReport No errors.
App\Entity\App\DeliveryMethod No errors.
App\Entity\Api\ProductImageHash No errors.
App\Entity\App\User No errors.