POST https://api-dev.oreca.com/api/magento-products

Query Metrics

5 Database Queries
2 Different statements
1.53 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.25 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.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:
[
  ""
]
3 0.24 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.28 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.trigramme = ? LIMIT 1
Parameters:
[
  "MOT"
]
5 0.49 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.trigramme = ? LIMIT 1
Parameters:
[
  "FCE"
]

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.