Query Metrics
4
Database Queries
2
Different statements
2.91 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.70 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 | 1.01 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.53 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.67 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.has_personalization AS has_personalization_21, t0.updated_at_api AS updated_at_api_22, t0.created_at_api AS created_at_api_23, t24.id AS id_25, t24.erp_active_products AS erp_active_products_26, t24.pim_active_products AS pim_active_products_27, t24.website_active_products AS website_active_products_28, t24.erp_backorder_products AS erp_backorder_products_29, t24.website_backorder_products AS website_backorder_products_30, t24.website_id AS website_id_31 FROM website t0 LEFT JOIN website_statistics t24 ON t24.website_id = t0.id WHERE t0.trigramme = ? LIMIT 1
Parameters:
[
"RSP"
]
|
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\Product | No errors. |
| App\Entity\Api\Website | No errors. |
| App\Entity\Api\WebsiteStatistics | 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\Api\ProductImageHash | No errors. |
| App\Entity\App\ShippingMethod | No errors. |
| App\Entity\Api\FulfilmentStatus | No errors. |