GET https://spineway.asb-digital.fr/api/public/products/6

Response
200 OK
IP
51.83.76.209
Profiled on
Token
313827

Query Metrics

9 Database Queries
5 Different statements
3.13 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.65 ms 
SELECT t0.published AS published_1, t0.available_on_pwa AS available_on_pwa_2, t0.id AS id_3, t0.position AS position_4, t0.category_id AS category_id_5, t0.homepage_id AS homepage_id_6, t0.translation_en_id AS translation_en_id_7, t0.translation_fr_id AS translation_fr_id_8, t0.translation_us_id AS translation_us_id_9, t0.translation_es_id AS translation_es_id_10, t0.translation_de_id AS translation_de_id_11, t0.translation_pt_id AS translation_pt_id_12 FROM product_global t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.55 ms 
SELECT t0.id AS id_1, t0.disable AS disable_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.info_text AS info_text_6, t0.features_text AS features_text_7, t0.features_pdf_name AS features_pdf_name_8, t0.features_pdf_size AS features_pdf_size_9, t0.features_pdf_updated_at AS features_pdf_updated_at_10, t0.features_pdf_title AS features_pdf_title_11, t0.products_range_text AS products_range_text_12, t0.products_range_pdf_name AS products_range_pdf_name_13, t0.products_range_pdf_size AS products_range_pdf_size_14, t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15, t0.products_range_pdf_title AS products_range_pdf_title_16, t0.regulatory_notices_text AS regulatory_notices_text_17, t0.contact_email AS contact_email_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t22.published AS published_23, t22.available_on_pwa AS available_on_pwa_24, t22.id AS id_25, t22.position AS position_26, t22.category_id AS category_id_27, t22.homepage_id AS homepage_id_28, t22.translation_en_id AS translation_en_id_29, t22.translation_fr_id AS translation_fr_id_30, t22.translation_us_id AS translation_us_id_31, t22.translation_es_id AS translation_es_id_32, t22.translation_de_id AS translation_de_id_33, t22.translation_pt_id AS translation_pt_id_34, t35.published AS published_36, t35.available_on_pwa AS available_on_pwa_37, t35.id AS id_38, t35.position AS position_39, t35.category_id AS category_id_40, t35.homepage_id AS homepage_id_41, t35.translation_en_id AS translation_en_id_42, t35.translation_fr_id AS translation_fr_id_43, t35.translation_us_id AS translation_us_id_44, t35.translation_es_id AS translation_es_id_45, t35.translation_de_id AS translation_de_id_46, t35.translation_pt_id AS translation_pt_id_47, t48.published AS published_49, t48.available_on_pwa AS available_on_pwa_50, t48.id AS id_51, t48.position AS position_52, t48.category_id AS category_id_53, t48.homepage_id AS homepage_id_54, t48.translation_en_id AS translation_en_id_55, t48.translation_fr_id AS translation_fr_id_56, t48.translation_us_id AS translation_us_id_57, t48.translation_es_id AS translation_es_id_58, t48.translation_de_id AS translation_de_id_59, t48.translation_pt_id AS translation_pt_id_60, t61.published AS published_62, t61.available_on_pwa AS available_on_pwa_63, t61.id AS id_64, t61.position AS position_65, t61.category_id AS category_id_66, t61.homepage_id AS homepage_id_67, t61.translation_en_id AS translation_en_id_68, t61.translation_fr_id AS translation_fr_id_69, t61.translation_us_id AS translation_us_id_70, t61.translation_es_id AS translation_es_id_71, t61.translation_de_id AS translation_de_id_72, t61.translation_pt_id AS translation_pt_id_73, t74.published AS published_75, t74.available_on_pwa AS available_on_pwa_76, t74.id AS id_77, t74.position AS position_78, t74.category_id AS category_id_79, t74.homepage_id AS homepage_id_80, t74.translation_en_id AS translation_en_id_81, t74.translation_fr_id AS translation_fr_id_82, t74.translation_us_id AS translation_us_id_83, t74.translation_es_id AS translation_es_id_84, t74.translation_de_id AS translation_de_id_85, t74.translation_pt_id AS translation_pt_id_86, t87.published AS published_88, t87.available_on_pwa AS available_on_pwa_89, t87.id AS id_90, t87.position AS position_91, t87.category_id AS category_id_92, t87.homepage_id AS homepage_id_93, t87.translation_en_id AS translation_en_id_94, t87.translation_fr_id AS translation_fr_id_95, t87.translation_us_id AS translation_us_id_96, t87.translation_es_id AS translation_es_id_97, t87.translation_de_id AS translation_de_id_98, t87.translation_pt_id AS translation_pt_id_99 FROM product t0 LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.24 ms 
SELECT t0.id AS id_1, t0.picture_name AS picture_name_2, t0.picture_size AS picture_size_3, t0.picture_updated_at AS picture_updated_at_4, t0.picture_alt AS picture_alt_5, t0.video_link AS video_link_6, t0.mp4_name AS mp4_name_7, t0.mp4_size AS mp4_size_8, t0.mp4_updated_at AS mp4_updated_at_9, t0.position AS position_10, t0.product_id AS product_id_11 FROM pwaproduct_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.42 ms 
SELECT t0.id AS id_1, t0.disable AS disable_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.info_text AS info_text_6, t0.features_text AS features_text_7, t0.features_pdf_name AS features_pdf_name_8, t0.features_pdf_size AS features_pdf_size_9, t0.features_pdf_updated_at AS features_pdf_updated_at_10, t0.features_pdf_title AS features_pdf_title_11, t0.products_range_text AS products_range_text_12, t0.products_range_pdf_name AS products_range_pdf_name_13, t0.products_range_pdf_size AS products_range_pdf_size_14, t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15, t0.products_range_pdf_title AS products_range_pdf_title_16, t0.regulatory_notices_text AS regulatory_notices_text_17, t0.contact_email AS contact_email_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t22.published AS published_23, t22.available_on_pwa AS available_on_pwa_24, t22.id AS id_25, t22.position AS position_26, t22.category_id AS category_id_27, t22.homepage_id AS homepage_id_28, t22.translation_en_id AS translation_en_id_29, t22.translation_fr_id AS translation_fr_id_30, t22.translation_us_id AS translation_us_id_31, t22.translation_es_id AS translation_es_id_32, t22.translation_de_id AS translation_de_id_33, t22.translation_pt_id AS translation_pt_id_34, t35.published AS published_36, t35.available_on_pwa AS available_on_pwa_37, t35.id AS id_38, t35.position AS position_39, t35.category_id AS category_id_40, t35.homepage_id AS homepage_id_41, t35.translation_en_id AS translation_en_id_42, t35.translation_fr_id AS translation_fr_id_43, t35.translation_us_id AS translation_us_id_44, t35.translation_es_id AS translation_es_id_45, t35.translation_de_id AS translation_de_id_46, t35.translation_pt_id AS translation_pt_id_47, t48.published AS published_49, t48.available_on_pwa AS available_on_pwa_50, t48.id AS id_51, t48.position AS position_52, t48.category_id AS category_id_53, t48.homepage_id AS homepage_id_54, t48.translation_en_id AS translation_en_id_55, t48.translation_fr_id AS translation_fr_id_56, t48.translation_us_id AS translation_us_id_57, t48.translation_es_id AS translation_es_id_58, t48.translation_de_id AS translation_de_id_59, t48.translation_pt_id AS translation_pt_id_60, t61.published AS published_62, t61.available_on_pwa AS available_on_pwa_63, t61.id AS id_64, t61.position AS position_65, t61.category_id AS category_id_66, t61.homepage_id AS homepage_id_67, t61.translation_en_id AS translation_en_id_68, t61.translation_fr_id AS translation_fr_id_69, t61.translation_us_id AS translation_us_id_70, t61.translation_es_id AS translation_es_id_71, t61.translation_de_id AS translation_de_id_72, t61.translation_pt_id AS translation_pt_id_73, t74.published AS published_75, t74.available_on_pwa AS available_on_pwa_76, t74.id AS id_77, t74.position AS position_78, t74.category_id AS category_id_79, t74.homepage_id AS homepage_id_80, t74.translation_en_id AS translation_en_id_81, t74.translation_fr_id AS translation_fr_id_82, t74.translation_us_id AS translation_us_id_83, t74.translation_es_id AS translation_es_id_84, t74.translation_de_id AS translation_de_id_85, t74.translation_pt_id AS translation_pt_id_86, t87.published AS published_88, t87.available_on_pwa AS available_on_pwa_89, t87.id AS id_90, t87.position AS position_91, t87.category_id AS category_id_92, t87.homepage_id AS homepage_id_93, t87.translation_en_id AS translation_en_id_94, t87.translation_fr_id AS translation_fr_id_95, t87.translation_us_id AS translation_us_id_96, t87.translation_es_id AS translation_es_id_97, t87.translation_de_id AS translation_de_id_98, t87.translation_pt_id AS translation_pt_id_99 FROM product t0 LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.24 ms 
SELECT t0.id AS id_1, t0.picture_name AS picture_name_2, t0.picture_size AS picture_size_3, t0.picture_updated_at AS picture_updated_at_4, t0.picture_alt AS picture_alt_5, t0.video_link AS video_link_6, t0.mp4_name AS mp4_name_7, t0.mp4_size AS mp4_size_8, t0.mp4_updated_at AS mp4_updated_at_9, t0.position AS position_10, t0.product_id AS product_id_11 FROM pwaproduct_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.40 ms 
SELECT t0.id AS id_1, t0.disable AS disable_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.info_text AS info_text_6, t0.features_text AS features_text_7, t0.features_pdf_name AS features_pdf_name_8, t0.features_pdf_size AS features_pdf_size_9, t0.features_pdf_updated_at AS features_pdf_updated_at_10, t0.features_pdf_title AS features_pdf_title_11, t0.products_range_text AS products_range_text_12, t0.products_range_pdf_name AS products_range_pdf_name_13, t0.products_range_pdf_size AS products_range_pdf_size_14, t0.products_range_pdf_updated_at AS products_range_pdf_updated_at_15, t0.products_range_pdf_title AS products_range_pdf_title_16, t0.regulatory_notices_text AS regulatory_notices_text_17, t0.contact_email AS contact_email_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t22.published AS published_23, t22.available_on_pwa AS available_on_pwa_24, t22.id AS id_25, t22.position AS position_26, t22.category_id AS category_id_27, t22.homepage_id AS homepage_id_28, t22.translation_en_id AS translation_en_id_29, t22.translation_fr_id AS translation_fr_id_30, t22.translation_us_id AS translation_us_id_31, t22.translation_es_id AS translation_es_id_32, t22.translation_de_id AS translation_de_id_33, t22.translation_pt_id AS translation_pt_id_34, t35.published AS published_36, t35.available_on_pwa AS available_on_pwa_37, t35.id AS id_38, t35.position AS position_39, t35.category_id AS category_id_40, t35.homepage_id AS homepage_id_41, t35.translation_en_id AS translation_en_id_42, t35.translation_fr_id AS translation_fr_id_43, t35.translation_us_id AS translation_us_id_44, t35.translation_es_id AS translation_es_id_45, t35.translation_de_id AS translation_de_id_46, t35.translation_pt_id AS translation_pt_id_47, t48.published AS published_49, t48.available_on_pwa AS available_on_pwa_50, t48.id AS id_51, t48.position AS position_52, t48.category_id AS category_id_53, t48.homepage_id AS homepage_id_54, t48.translation_en_id AS translation_en_id_55, t48.translation_fr_id AS translation_fr_id_56, t48.translation_us_id AS translation_us_id_57, t48.translation_es_id AS translation_es_id_58, t48.translation_de_id AS translation_de_id_59, t48.translation_pt_id AS translation_pt_id_60, t61.published AS published_62, t61.available_on_pwa AS available_on_pwa_63, t61.id AS id_64, t61.position AS position_65, t61.category_id AS category_id_66, t61.homepage_id AS homepage_id_67, t61.translation_en_id AS translation_en_id_68, t61.translation_fr_id AS translation_fr_id_69, t61.translation_us_id AS translation_us_id_70, t61.translation_es_id AS translation_es_id_71, t61.translation_de_id AS translation_de_id_72, t61.translation_pt_id AS translation_pt_id_73, t74.published AS published_75, t74.available_on_pwa AS available_on_pwa_76, t74.id AS id_77, t74.position AS position_78, t74.category_id AS category_id_79, t74.homepage_id AS homepage_id_80, t74.translation_en_id AS translation_en_id_81, t74.translation_fr_id AS translation_fr_id_82, t74.translation_us_id AS translation_us_id_83, t74.translation_es_id AS translation_es_id_84, t74.translation_de_id AS translation_de_id_85, t74.translation_pt_id AS translation_pt_id_86, t87.published AS published_88, t87.available_on_pwa AS available_on_pwa_89, t87.id AS id_90, t87.position AS position_91, t87.category_id AS category_id_92, t87.homepage_id AS homepage_id_93, t87.translation_en_id AS translation_en_id_94, t87.translation_fr_id AS translation_fr_id_95, t87.translation_us_id AS translation_us_id_96, t87.translation_es_id AS translation_es_id_97, t87.translation_de_id AS translation_de_id_98, t87.translation_pt_id AS translation_pt_id_99 FROM product t0 LEFT JOIN product_global t22 ON t22.translation_en_id = t0.id LEFT JOIN product_global t35 ON t35.translation_fr_id = t0.id LEFT JOIN product_global t48 ON t48.translation_us_id = t0.id LEFT JOIN product_global t61 ON t61.translation_es_id = t0.id LEFT JOIN product_global t74 ON t74.translation_de_id = t0.id LEFT JOIN product_global t87 ON t87.translation_pt_id = t0.id WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.24 ms 
SELECT t0.id AS id_1, t0.picture_name AS picture_name_2, t0.picture_size AS picture_size_3, t0.picture_updated_at AS picture_updated_at_4, t0.picture_alt AS picture_alt_5, t0.video_link AS video_link_6, t0.mp4_name AS mp4_name_7, t0.mp4_size AS mp4_size_8, t0.mp4_updated_at AS mp4_updated_at_9, t0.position AS position_10, t0.product_id AS product_id_11 FROM pwaproduct_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.19 ms 
SELECT s0_.id AS id_0, s0_.page_name AS page_name_1, s0_.route AS route_2, s0_.h1_enabled AS h1_enabled_3, s0_.translation_en_id AS translation_en_id_4, s0_.translation_fr_id AS translation_fr_id_5, s0_.translation_us_id AS translation_us_id_6, s0_.translation_es_id AS translation_es_id_7, s0_.translation_de_id AS translation_de_id_8, s0_.translation_pt_id AS translation_pt_id_9 FROM seopage_global s0_ WHERE s0_.route = ?
Parameters: 
[
  "_api_/public/products/{id}_get"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.21 ms 
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Product\ProductGlobal
  • The field App\Entity\Product\ProductGlobal#contact is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contact#product does not contain the required 'inversedBy="contact"' attribute.
App\Entity\Product\ProductCategoryGlobal No errors.
App\Entity\HomepageGlobal No errors.
App\Entity\Product\Product
  • The field App\Entity\Product\Product#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute.
  • The field App\Entity\Product\Product#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
  • The field App\Entity\Product\Product#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute.
  • The field App\Entity\Product\Product#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute.
  • The field App\Entity\Product\Product#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute.
  • The field App\Entity\Product\Product#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Product\ProductGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
App\Entity\Contact No errors.
App\Entity\PWA\ProductDocumentationGlobal No errors.
App\Entity\IFU\IFUDocument No errors.
App\Entity\Product\ProductMedia No errors.
App\Entity\PWA\Product3DView No errors.
App\Entity\PWA\ProductMP4Media No errors.
App\Entity\PWA\PWAProductMedia No errors.
App\Entity\SEOPageGlobal No errors.
App\Entity\SEOPage
  • The field App\Entity\SEOPage#translatedEn is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationEn does not contain the required 'inversedBy="translatedEn"' attribute.
  • The field App\Entity\SEOPage#translatedFr is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationFr does not contain the required 'inversedBy="translatedFr"' attribute.
  • The field App\Entity\SEOPage#translatedUs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationUs does not contain the required 'inversedBy="translatedUs"' attribute.
  • The field App\Entity\SEOPage#translatedEs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationEs does not contain the required 'inversedBy="translatedEs"' attribute.
  • The field App\Entity\SEOPage#translatedDe is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationDe does not contain the required 'inversedBy="translatedDe"' attribute.
  • The field App\Entity\SEOPage#translatedPt is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SEOPageGlobal#translationPt does not contain the required 'inversedBy="translatedPt"' attribute.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings No errors.
App\Entity\SiteSettings No errors.