Query Metrics
15
Database Queries
11
Different statements
3.52 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.40 ms |
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"
]
|
| 2 | 0.32 ms |
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
]
|
| 3 | 0.21 ms |
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
]
|
| 4 | 0.19 ms |
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
]
|
| 5 | 0.15 ms |
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
]
|
| 6 | 0.17 ms |
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
]
|
| 7 | 0.30 ms |
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
]
|
| 8 | 0.40 ms |
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
]
|
| 9 | 0.19 ms |
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" ] |
| 10 | 0.31 ms |
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
]
|
| 11 | 0.18 ms |
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 "hasRoundLinearMeter" ] |
| 12 | 0.14 ms |
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 "hasMinLinearMeter" ] |
| 13 | 0.14 ms |
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 "hasRoundLinearMeter" ] |
| 14 | 0.12 ms |
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 "hasMinLinearMeter" ] |
| 15 | 0.30 ms |
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
]
|
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 |
|
| 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. |