Query Metrics

11 Database Queries
6 Different statements
25.94 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.28 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.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:
[
  ""
]
3 0.27 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.40 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.id = ?
Parameters:
[
  19
]
5 0.56 ms
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:
[]
6 1.47 ms
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:
[
  96861
  96860
  96859
  96858
  96857
  96856
  96855
  96854
  96853
  96852
  96851
  96850
  96849
  96848
  96847
  96846
  96845
  96844
  96843
  96842
]
7 21.16 ms
SELECT count(m0_.id) AS sclr_0 FROM magento_product_report m0_
Parameters:
[]
8 0.35 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, 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:
[
  16828
]
9 0.40 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, 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
]
10 0.45 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, 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:
[
  16821
]
11 0.33 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, 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:
[
  16825
]

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
  • 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\App\DeliveryMethod No errors.
App\Entity\Api\ProductImageHash No errors.