https://preprod.sur-mesure.nielsendesign.fr/client-order/3356/print

Query Metrics

15 Database Queries
11 Different statements
3.52 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.78 ms
(22.14%)
5
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.project_id AS project_id_4 FROM setting t0 WHERE t0.project_id = ? AND t0.setting_key = ? LIMIT 1
Parameters:
[
  51
  "extraTicketInfo"
]
0.40 ms
(11.32%)
1
SELECT t0.id AS id_1, t0.price AS price_2, t0.created AS created_3, t0.save_link AS save_link_4, t0.reference AS reference_5, t0.client_reference AS client_reference_6, t0.seller_name AS seller_name_7, t0.ref_to_send AS ref_to_send_8, t0.comment AS comment_9, t0.received_by_shop_at AS received_by_shop_at_10, t0.client_contacted_at AS client_contacted_at_11, t0.product_delivered_to_client_at AS product_delivered_to_client_at_12, t0.status AS status_13, t0.price_net_ref_to_send AS price_net_ref_to_send_14, t0.order_token AS order_token_15, t0.is_archived AS is_archived_16, t0.archived_at AS archived_at_17, t0.project_id AS project_id_18, t0.internaute_id AS internaute_id_19 FROM client_order t0 WHERE t0.id = ?
Parameters:
[
  "3356"
]
0.40 ms
(11.24%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.url AS url_3, t0.name AS name_4, t0.token AS token_5, t0.magasin_id AS magasin_id_6, t7.id AS id_8, t7.wording AS wording_9, t7.has_comment AS has_comment_10, t7.has_tiny_url_comment AS has_tiny_url_comment_11, t7.has_info_popup AS has_info_popup_12, t7.has_dpi AS has_dpi_13, t7.default_baguette AS default_baguette_14, t7.default_big_baguette AS default_big_baguette_15, t7.default_caisse_americaine AS default_caisse_americaine_16, t7.print_price AS print_price_17, t7.has_pro_enabled_by_default AS has_pro_enabled_by_default_18, t7.has_validate_after_load_save AS has_validate_after_load_save_19, t7.has_client_info AS has_client_info_20, t7.has_send_mail AS has_send_mail_21, t7.logo_path AS logo_path_22, t7.main_color AS main_color_23, t7.has_tunnel_passepartout AS has_tunnel_passepartout_24, t7.has_tunnel_caisse_americaine AS has_tunnel_caisse_americaine_25, t7.has_continue_with_example AS has_continue_with_example_26, t7.has_send_email_to_client AS has_send_email_to_client_27, t7.has_seller_name AS has_seller_name_28, t7.has_upload_image AS has_upload_image_29, t7.send_order_to AS send_order_to_30, t7.data_produit_path AS data_produit_path_31, t7.default_comment AS default_comment_32, t7.client_order_mandatory_fields AS client_order_mandatory_fields_33, t7.able_select_product_variant AS able_select_product_variant_34, t7.able_to_print AS able_to_print_35, t7.has_automatic_send_to_nielsen AS has_automatic_send_to_nielsen_36, t7.has_new_design AS has_new_design_37, t7.has_loyalty_card AS has_loyalty_card_38, t7.show_order_button AS show_order_button_39, t7.can_edit_nielsen_order_reference AS can_edit_nielsen_order_reference_40, t7.able_to_edit_client_order AS able_to_edit_client_order_41, t7.able_to_resend_nielsen_order AS able_to_resend_nielsen_order_42, t7.project_id AS project_id_43 FROM project t0 LEFT JOIN project_settings t7 ON t7.project_id = t0.id WHERE t0.id = ?
Parameters:
[
  51
]
0.32 ms
(9.19%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.img_url AS img_url_4, t0.ref_to_send AS ref_to_send_5, t0.name AS name_6, t0.largeur AS largeur_7, t0.hauteur AS hauteur_8, t0.verre AS verre_9, t0.reference_client AS reference_client_10, t0.largeur_exterieur AS largeur_exterieur_11, t0.hauteur_exterieur AS hauteur_exterieur_12, t0.client_order_id AS client_order_id_13, t0.discriminator FROM order_product t0 WHERE t0.client_order_id = ? AND t0.discriminator IN ('cadre')
Parameters:
[
  3356
]
0.31 ms
(8.74%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.img_url AS img_url_4, t0.ref_to_send AS ref_to_send_5, t0.client_order_id AS client_order_id_6, t0.discriminator, t0.name AS name_7, t0.largeur AS largeur_8, t0.hauteur AS hauteur_9, t0.verre AS verre_10, t0.reference_client AS reference_client_11, t0.largeur_exterieur AS largeur_exterieur_12, t0.hauteur_exterieur AS hauteur_exterieur_13, t0.name AS name_14, t0.largeur_exterieur AS largeur_exterieur_15, t0.hauteur_exterieur AS hauteur_exterieur_16, t0.largeur_interieur AS largeur_interieur_17, t0.hauteur_interieur AS hauteur_interieur_18, t0.marge_haut AS marge_haut_19, t0.marge_bas AS marge_bas_20, t0.marge_gauche AS marge_gauche_21, t0.marge_droit AS marge_droit_22, t0.reference_client AS reference_client_23, t0.recouvrement AS recouvrement_24, t0.name AS name_25, t0.largeur AS largeur_26, t0.hauteur AS hauteur_27, t0.espacement AS espacement_28, t0.reference_client AS reference_client_29, t0.largeur AS largeur_30, t0.hauteur AS hauteur_31, t0.collage AS collage_32, t0.image_url AS image_url_33, t0.paper AS paper_34, t0.image_id AS image_id_35, t0.name AS name_36 FROM order_product t0 WHERE t0.client_order_id = ? AND t0.discriminator IN ('cadre', 'passe-partout', 'caisse-americaine', 'sujet', 'partial')
Parameters:
[
  3356
]
0.30 ms
(8.61%)
1
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.project_id AS project_id_4 FROM setting t0 WHERE t0.project_id = ?
Parameters:
[
  51
]
0.30 ms
(8.48%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.comment AS comment_5, t0.app_config AS app_config_6, t0.project_id AS project_id_7, t0.client_order_id AS client_order_id_8 FROM tiny_url t0 WHERE t0.client_order_id = ?
Parameters:
[
  3356
]
0.21 ms
(5.89%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.img_url AS img_url_4, t0.ref_to_send AS ref_to_send_5, t0.name AS name_6, t0.largeur_exterieur AS largeur_exterieur_7, t0.hauteur_exterieur AS hauteur_exterieur_8, t0.largeur_interieur AS largeur_interieur_9, t0.hauteur_interieur AS hauteur_interieur_10, t0.marge_haut AS marge_haut_11, t0.marge_bas AS marge_bas_12, t0.marge_gauche AS marge_gauche_13, t0.marge_droit AS marge_droit_14, t0.reference_client AS reference_client_15, t0.recouvrement AS recouvrement_16, t0.client_order_id AS client_order_id_17, t0.discriminator FROM order_product t0 WHERE t0.client_order_id = ? AND t0.discriminator IN ('passe-partout')
Parameters:
[
  3356
]
0.19 ms
(5.26%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.img_url AS img_url_4, t0.ref_to_send AS ref_to_send_5, t0.name AS name_6, t0.largeur AS largeur_7, t0.hauteur AS hauteur_8, t0.espacement AS espacement_9, t0.reference_client AS reference_client_10, t0.client_order_id AS client_order_id_11, t0.discriminator FROM order_product t0 WHERE t0.client_order_id = ? AND t0.discriminator IN ('caisse-americaine')
Parameters:
[
  3356
]
0.17 ms
(4.84%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.img_url AS img_url_4, t0.ref_to_send AS ref_to_send_5, t0.largeur AS largeur_6, t0.hauteur AS hauteur_7, t0.collage AS collage_8, t0.image_url AS image_url_9, t0.paper AS paper_10, t0.client_order_id AS client_order_id_11, t0.image_id AS image_id_12, t0.discriminator FROM order_product t0 WHERE t0.client_order_id = ? AND t0.discriminator IN ('sujet')
Parameters:
[
  3356
]
0.15 ms
(4.29%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.img_url AS img_url_4, t0.ref_to_send AS ref_to_send_5, t0.name AS name_6, t0.client_order_id AS client_order_id_7, t0.discriminator FROM order_product t0 WHERE t0.client_order_id = ? AND t0.discriminator IN ('partial')
Parameters:
[
  3356
]

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\ClientOrder
  • The mappings App\Entity\ClientOrder#cadre and App\Entity\Cadre#clientOrder are inconsistent with each other.
  • The mappings App\Entity\ClientOrder#passePartout and App\Entity\PassePartout#clientOrder are inconsistent with each other.
  • The mappings App\Entity\ClientOrder#caisseAmericaine and App\Entity\CaisseAmericaine#clientOrder are inconsistent with each other.
  • The mappings App\Entity\ClientOrder#partial and App\Entity\Partial#clientOrder are inconsistent with each other.
  • The mappings App\Entity\ClientOrder#sujet and App\Entity\Sujet#clientOrder are inconsistent with each other.
App\Entity\Project No errors.
App\Entity\OrderProduct No errors.
App\Entity\Cadre No errors.
App\Entity\PassePartout No errors.
App\Entity\CaisseAmericaine No errors.
App\Entity\Partial No errors.
App\Entity\Sujet No errors.
App\Entity\Internaute No errors.
App\Entity\Image No errors.
App\Entity\NielsenOrder No errors.
App\Entity\Mail No errors.
App\Entity\TinyUrl No errors.
App\Entity\Setting No errors.
App\Entity\Magasin No errors.
App\Entity\ProjectSettings No errors.