GET https://api-dev.oreca.com/api/pimcore_products/545PFF50211?force=1&isPimcore=1&websites.trigramme=EXS

Query Metrics

29 Database Queries
8 Different statements
11.39 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 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.37 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.37 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.61 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:
[
  "EXS"
]
5 0.47 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:
[
  "website"
]
6 0.58 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:
[
  "EXS"
]
7 0.60 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:
[
  "EXS"
]
8 0.46 ms
SELECT p0_.id AS id_0, p0_.code_article AS code_article_1, p0_.reference_parent AS reference_parent_2, p0_.invisible_ecommerce AS invisible_ecommerce_3, p0_.categorie_web AS categorie_web_4, p0_.univers AS univers_5, p0_.attribute_set AS attribute_set_6, p0_.super_attributes AS super_attributes_7, p0_.localizedfields AS localizedfields_8, p0_.affectation_desc_complem AS affectation_desc_complem_9, p0_.image_principale AS image_principale_10, p0_.images_secondaires AS images_secondaires_11, p0_.image_personnalisation AS image_personnalisation_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.children AS children_15, p0_.attributes AS attributes_16, p0_.type_de_produit AS type_de_produit_17, p0_.attribute_option_ids AS attribute_option_ids_18, p0_.main_img_hash AS main_img_hash_19, p0_.additional_img_hash AS additional_img_hash_20, p0_.stock_tag AS stock_tag_21, p0_.status AS status_22, p0_.updated_at_api AS updated_at_api_23 FROM pimcore_product p0_ WHERE p0_.code_article = ?
Parameters:
[
  "545PFF50211"
]
9 0.48 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.ref_parent AS ref_parent_3, t0.ref_fournisseur AS ref_fournisseur_4, t0.libelle AS libelle_5, t0.activites AS activites_6, t0.activites_label AS activites_label_7, t0.univers_famille AS univers_famille_8, t0.univers_famille_label AS univers_famille_label_9, t0.famille AS famille_10, t0.famille_label AS famille_label_11, t0.sous_famille1 AS sous_famille1_12, t0.sous_famille1_label AS sous_famille1_label_13, t0.sous_famille2 AS sous_famille2_14, t0.sous_famille2_label AS sous_famille2_label_15, t0.boutique AS boutique_16, t0.marque AS marque_17, t0.marque_label AS marque_label_18, t0.couleur AS couleur_19, t0.couleur_label AS couleur_label_20, t0.taille AS taille_21, t0.taille_label AS taille_label_22, t0.collection AS collection_23, t0.pvht AS pvht_24, t0.prix_achat AS prix_achat_25, t0.tva AS tva_26, t0.poids AS poids_27, t0.volume AS volume_28, t0.methode_appro AS methode_appro_29, t0.methode_appro_label AS methode_appro_label_30, t0.invisible_web AS invisible_web_31, t0.epuise_cegid AS epuise_cegid_32, t0.ean AS ean_33, t0.min_commande_vente AS min_commande_vente_34, t0.delai_appro AS delai_appro_35, t0.delai_appro_constate AS delai_appro_constate_36, t0.created_at AS created_at_37, t0.updated_at AS updated_at_38, t0.date_modif_stock AS date_modif_stock_39, t0.quantite AS quantite_40, t0.hors_gabarit AS hors_gabarit_41, t0.famille_logistique AS famille_logistique_42, t0.dpav AS dpav_43, t0.soumis3ds AS soumis3ds_44, t0.depot_principal AS depot_principal_45, t0.type_article AS type_article_46, t0.famille_tarif AS famille_tarif_47, t0.marketplace AS marketplace_48, t0.ferme_cegid AS ferme_cegid_49, t0.ferme_web AS ferme_web_50, t0.epuise_frn AS epuise_frn_51, t0.epuise_tmp AS epuise_tmp_52, t0.coefmarge AS coefmarge_53, t0.statut_cegid AS statut_cegid_54, t0.stock_fournisseur AS stock_fournisseur_55, t0.vendu_par_multiple AS vendu_par_multiple_56, t0.valeur_marge AS valeur_marge_57, t0.backorder_magento AS backorder_magento_58, t0.code_fournisseur AS code_fournisseur_59, t0.updated_at_api AS updated_at_api_60, t0.pimcore_product_id AS pimcore_product_id_61 FROM product t0 WHERE t0.pimcore_product_id = ?
Parameters:
[
  34020
]
10 0.55 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:
[
  "EXS"
]
11 0.32 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:
[
  "OSV3"
]
12 0.32 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 INNER JOIN pimcore_product_website ON t0.id = pimcore_product_website.website_id WHERE pimcore_product_website.pimcore_product_id = ?
Parameters:
[
  34020
]
13 0.36 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "509"
]
14 0.33 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2313"
]
15 0.27 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2315"
]
16 0.26 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2316"
]
17 0.24 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2317"
]
18 0.29 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2319"
]
19 0.29 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2328"
]
20 0.35 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2329"
]
21 0.35 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2330"
]
22 0.30 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2366"
]
23 0.31 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2367"
]
24 0.58 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "2368"
]
25 0.34 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "8591"
]
26 0.28 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "12620"
]
27 0.30 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 WHERE t0.k_type_id = ? LIMIT 1
Parameters:
[
  "28643"
]
28 0.43 ms
SELECT t0.id AS id_1, t0.fuel_type AS fuel_type_2, t0.description_of_type AS description_of_type_3, t0.drive AS drive_4, t0.k_type_id AS k_type_id_5, t0.year_from AS year_from_6, t0.year_till AS year_till_7, t0.stroke_capacity_ltr AS stroke_capacity_ltr_8, t0.valves AS valves_9, t0.horse_power_cv AS horse_power_cv_10, t0.model_id AS model_id_11 FROM engine t0 INNER JOIN pimcore_product_engine ON t0.id = pimcore_product_engine.engine_id WHERE pimcore_product_engine.pimcore_product_id = ?
Parameters:
[
  34020
]
29 0.53 ms
SELECT p0_.id AS id_0, p0_.code_article AS code_article_1, p0_.reference_parent AS reference_parent_2, p0_.invisible_ecommerce AS invisible_ecommerce_3, p0_.categorie_web AS categorie_web_4, p0_.univers AS univers_5, p0_.attribute_set AS attribute_set_6, p0_.super_attributes AS super_attributes_7, p0_.localizedfields AS localizedfields_8, p0_.affectation_desc_complem AS affectation_desc_complem_9, p0_.image_principale AS image_principale_10, p0_.images_secondaires AS images_secondaires_11, p0_.image_personnalisation AS image_personnalisation_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.children AS children_15, p0_.attributes AS attributes_16, p0_.type_de_produit AS type_de_produit_17, p0_.attribute_option_ids AS attribute_option_ids_18, p0_.main_img_hash AS main_img_hash_19, p0_.additional_img_hash AS additional_img_hash_20, p0_.stock_tag AS stock_tag_21, p0_.status AS status_22, p0_.updated_at_api AS updated_at_api_23 FROM pimcore_product p0_ WHERE p0_.code_article = ?
Parameters:
[
  "545PFF50211"
]

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.
App\Entity\App\User No errors.
App\Entity\Api\CustomerTierPrice No errors.
App\Entity\Api\TecDoc\Engine
  • The association App\Entity\Api\TecDoc\Engine#products refers to the owning side field App\Entity\Api\Product#engines which does not exist.
App\Entity\Api\TecDoc\Model No errors.
App\Entity\Api\TecDoc\Translations\EngineTranslation No errors.