Query Metrics
11
Database Queries
6
Different statements
27.50 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
21.39 ms (77.80%) |
1 |
SELECT count(m0_.id) AS sclr_0 FROM magento_product_report m0_
Parameters:
[] |
2.01 ms (7.32%) |
4 |
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, t18.id AS id_19, t18.erp_active_products AS erp_active_products_20, t18.pim_active_products AS pim_active_products_21, t18.website_active_products AS website_active_products_22, t18.erp_backorder_products AS erp_backorder_products_23, t18.website_backorder_products AS website_backorder_products_24, t18.website_id AS website_id_25 FROM website t0 LEFT JOIN website_statistics t18 ON t18.website_id = t0.id WHERE t0.id = ?
Parameters:
[
16830
]
|
1.72 ms (6.26%) |
1 |
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.is_image_updated AS is_image_updated_2, m0_.sku AS sku_3, m0_.translated_languages AS translated_languages_4, m0_.created_at AS created_at_5, m0_.final_data AS final_data_6, m0_.execution_time AS execution_time_7, m0_.erp_data AS erp_data_8, m0_.pimcore_data AS pimcore_data_9, m0_.log_message AS log_message_10, m0_.email AS email_11, m0_.enrichisseur AS enrichisseur_12, m0_.business_unit_manager AS business_unit_manager_13, m0_.website_id AS website_id_14 FROM magento_product_report m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.id DESC
Parameters:
[ 96862 96861 96860 96859 96858 96857 96856 96855 96854 96853 96852 96851 96850 96849 96848 96847 96846 96845 96844 96843 ] |
1.05 ms (3.82%) |
3 |
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"
]
|
0.80 ms (2.92%) |
1 |
SELECT DISTINCT m0_.id AS id_0, m0_.id AS id_1 FROM magento_product_report m0_ ORDER BY m0_.id DESC LIMIT 20
Parameters:
[] |
0.52 ms (1.88%) |
1 |
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.id = ?
Parameters:
[
19
]
|
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\App\User | No errors. |
App\Entity\Api\MagentoProductReport | 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\App\DeliveryMethod | No errors. |
App\Entity\Api\ProductImageHash | No errors. |