Query Metrics
5
Database Queries
3
Different statements
1.76 ms
Query time
1
Invalid entities
Queries
#▲ | 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 |
|
App\Entity\Api\MagentoProductReport | No errors. |
App\Entity\App\DeliveryMethod | No errors. |
App\Entity\Api\ProductImageHash | No errors. |
App\Entity\App\User | No errors. |