Query Metrics
21
Database Queries
8
Different statements
7.98 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.65 ms |
SELECT t0.status AS status_1, t0.id AS id_2, t0.email AS email_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.password AS password_6, t0.last_name AS last_name_7, t0.type AS type_8, t0.change_password AS change_password_9, t0.contact_id AS contact_id_10, t0.region_id AS region_id_11, t0.commission_id AS commission_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
175
]
|
2 | 1.16 ms |
SELECT t0.status AS status_1, t0.id AS id_2, t0.number AS number_3, t0.order_date AS order_date_4, t0.type AS type_5, t0.total_amount AS total_amount_6, t0.billing_address AS billing_address_7, t0.delivery_address AS delivery_address_8, t0.shipping_number AS shipping_number_9, t0.invoice_number AS invoice_number_10, t0.invoice_date AS invoice_date_11, t0.bank_request AS bank_request_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.firm_id AS firm_id_15, t16.id AS id_17, t16.number AS number_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.parent_order_id AS parent_order_id_21, t22.status AS status_23, t22.id AS id_24, t22.annee_cotisation AS annee_cotisation_25, t22.montant_cotisation AS montant_cotisation_26, t22.commentaire AS commentaire_27, t22.date_paiement AS date_paiement_28, t22.revenue AS revenue_29, t22.year AS year_30, t22.revenue_date AS revenue_date_31, t22.option_import_export AS option_import_export_32, t22.option_mapa AS option_mapa_33, t22.price_ht AS price_ht_34, t22.price_vat AS price_vat_35, t22.price_ttc AS price_ttc_36, t22.internal_licence AS internal_licence_37, t22.community_licence AS community_licence_38, t22.price_department_part AS price_department_part_39, t22.price_national_part AS price_national_part_40, t22.price_national_part_calculated AS price_national_part_calculated_41, t22.price_option_import_export AS price_option_import_export_42, t22.price_option_mapa AS price_option_mapa_43, t22.document AS document_44, t22.original_document_name AS original_document_name_45, t22.proof_of_payment AS proof_of_payment_46, t22.original_proof_of_payment_name AS original_proof_of_payment_name_47, t22.young_member_year_number AS young_member_year_number_48, t22.created_at AS created_at_49, t22.updated_at AS updated_at_50, t22.cotisation_statut_id AS cotisation_statut_id_51, t22.entreprise_id AS entreprise_id_52, t22.type_offre_id AS type_offre_id_53, t22.cotisation_type_id AS cotisation_type_id_54, t22.associeted_order_id AS associeted_order_id_55, t0.payment_type_id AS payment_type_id_56, t0.user_id AS user_id_57 FROM `order` t0 LEFT JOIN invoice t16 ON t16.parent_order_id = t0.id LEFT JOIN cotisation t22 ON t22.associeted_order_id = t0.id WHERE t0.id = ?
Parameters:
[
"808"
]
|
3 | 0.49 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"sale.bank.bank"
]
|
4 | 0.28 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"sale.bank.iban"
]
|
5 | 0.30 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"sale.bank.bic"
]
|
6 | 0.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"sale.invoice.notice"
]
|
7 | 0.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.address"
]
|
8 | 0.28 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.zipcode"
]
|
9 | 0.26 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.city"
]
|
10 | 0.30 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.phone"
]
|
11 | 0.28 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.email"
]
|
12 | 0.33 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.siret"
]
|
13 | 0.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.ape"
]
|
14 | 0.28 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.subtype AS subtype_3, t0.title AS title_4, t0.value AS value_5, t0.valuetype AS valuetype_6, t0.is_requiered AS is_requiered_7, t0.tag AS tag_8, t0.help AS help_9, t0.param_order AS param_order_10, t0.granted AS granted_11, t0.is_accessible_to_template AS is_accessible_to_template_12, t0.is_accessible_to_parameter AS is_accessible_to_parameter_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM parameter t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"info.ffcb_info.tva_intracom"
]
|
15 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.is_enabled AS is_enabled_4, t0.hide_in_member AS hide_in_member_5, t0.description AS description_6, t0.cotisation_order AS cotisation_order_7, t0.max_amount AS max_amount_8 FROM param_cotisation t0 WHERE t0.id = ?
Parameters:
[
5
]
|
16 | 0.62 ms |
SELECT t0.status AS status_1, t0.id AS id_2, t0.raison_social AS raison_social_3, t0.adresse AS adresse_4, t0.tel1 AS tel1_5, t0.tel2 AS tel2_6, t0.fax AS fax_7, t0.email AS email_8, t0.code_siren AS code_siren_9, t0.code_ape AS code_ape_10, t0.num_tva_intracom AS num_tva_intracom_11, t0.ancien_identifiant AS ancien_identifiant_12, t0.identifiant_compta AS identifiant_compta_13, t0.num_ede_negoce AS num_ede_negoce_14, t0.num_ede_centre AS num_ede_centre_15, t0.num_ede_elevage AS num_ede_elevage_16, t0.nombre_employes AS nombre_employes_17, t0.autre_specialite AS autre_specialite_18, t0.volume_animaux AS volume_animaux_19, t0.souhaite_adherer AS souhaite_adherer_20, t0.figurer_annuaire_adherents AS figurer_annuaire_adherents_21, t0.figurer_annuaire_internet AS figurer_annuaire_internet_22, t0.figurer_au_nom_de AS figurer_au_nom_de_23, t0.statut_paiement AS statut_paiement_24, t0.raison_non_adhesion AS raison_non_adhesion_25, t0.date_cessation AS date_cessation_26, t0.chiffre_dernier_total AS chiffre_dernier_total_27, t0.commentaires AS commentaires_28, t0.is_transporter AS is_transporter_29, t0.transport_pour_autrui AS transport_pour_autrui_30, t0.lien_url AS lien_url_31, t0.ville AS ville_32, t0.code_postal AS code_postal_33, t0.adresse2 AS adresse2_34, t0.nombre_veaux AS nombre_veaux_35, t0.nombre_maigres AS nombre_maigres_36, t0.nombre_elev_prod AS nombre_elev_prod_37, t0.nombre_boucherie AS nombre_boucherie_38, t0.nombre_ovins AS nombre_ovins_39, t0.nombre_porcins AS nombre_porcins_40, t0.nombre_equins AS nombre_equins_41, t0.nombre_caprins AS nombre_caprins_42, t0.autre_activite AS autre_activite_43, t0.code_adherent AS code_adherent_44, t0.is_quali_negoce AS is_quali_negoce_45, t0.quali_negoce_certification_date AS quali_negoce_certification_date_46, t0.quali_negoce_contact_name AS quali_negoce_contact_name_47, t0.raison_non_adhesion_autre AS raison_non_adhesion_autre_48, t0.total_count_species AS total_count_species_49, t0.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_50, t0.is_member AS is_member_51, t0.groupe_entreprise_id AS groupe_entreprise_id_52, t0.departement_id AS departement_id_53, t0.syndicat_id AS syndicat_id_54, t0.transporteur_id AS transporteur_id_55, t0.contact_responsable_id AS contact_responsable_id_56, t0.home_region_id AS home_region_id_57, t0.commission_id AS commission_id_58, t0.quali_negoce_contact_id AS quali_negoce_contact_id_59, t0.firm_type_id AS firm_type_id_60 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
1689
]
|
17 | 0.46 ms |
SELECT t0.id AS id_1, t0.unit_price AS unit_price_2, t0.total_price AS total_price_3, t0.quantity AS quantity_4, t0.vat AS vat_5, t0.parent_order_id AS parent_order_id_6, t0.product_id AS product_id_7 FROM order_line t0 WHERE t0.parent_order_id = ?
Parameters:
[
808
]
|
18 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.price_member AS price_member_5, t0.price_not_member AS price_not_member_6, t0.display_on_shop AS display_on_shop_7, t0.is_shippable AS is_shippable_8, t0.code AS code_9, t0.type AS type_10, t0.tag AS tag_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.vat_id AS vat_id_14 FROM product t0 WHERE t0.id = ?
Parameters:
[
1
]
|
19 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.price_member AS price_member_5, t0.price_not_member AS price_not_member_6, t0.display_on_shop AS display_on_shop_7, t0.is_shippable AS is_shippable_8, t0.code AS code_9, t0.type AS type_10, t0.tag AS tag_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.vat_id AS vat_id_14 FROM product t0 WHERE t0.id = ?
Parameters:
[
2
]
|
20 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.price_member AS price_member_5, t0.price_not_member AS price_not_member_6, t0.display_on_shop AS display_on_shop_7, t0.is_shippable AS is_shippable_8, t0.code AS code_9, t0.type AS type_10, t0.tag AS tag_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.vat_id AS vat_id_14 FROM product t0 WHERE t0.id = ?
Parameters:
[
3
]
|
21 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_enabled AS is_enabled_3, t0.icon AS icon_4, t0.help_target AS help_target_5, t0.help AS help_6 FROM payment_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\EntityStatus | No errors. |
App\Entity\User | No errors. |
App\Entity\Contact | No errors. |
App\Entity\Region | No errors. |
App\Entity\Commission | No errors. |
App\Entity\UserQuestion | No errors. |
App\Entity\UserCart | No errors. |
App\Entity\SyndicatUser | No errors. |
App\Entity\LogConnection | No errors. |
App\Entity\Order | No errors. |
App\Entity\Entreprise | No errors. |
App\Entity\Invoice | No errors. |
App\Entity\Cotisation | No errors. |
App\Entity\CotisationStatut | No errors. |
App\Entity\TypeOffre | No errors. |
App\Entity\ParamCotisation | No errors. |
App\Entity\PaymentType | No errors. |
App\Entity\OrderLine | No errors. |
App\Entity\BankResponse | No errors. |
App\Entity\Parameter | No errors. |
App\Entity\ParamCotisationParameter | No errors. |
App\Entity\ParamCotisationParamSlice | No errors. |
App\Entity\GroupeEntreprise | No errors. |
App\Entity\Departement | No errors. |
App\Entity\Syndicat | No errors. |
App\Entity\EntrepriseTransporteur | No errors. |
App\Entity\FirmType | No errors. |
App\Entity\Etablissement | No errors. |
App\Entity\CommissionEntreprise | No errors. |
App\Entity\EntrepriseActivity | No errors. |
App\Entity\FirmQualiNegoceDocument | No errors. |
App\Entity\CotisationNotification | No errors. |
App\Entity\FormUser | No errors. |
App\Entity\FirmContactQualiNegoce | No errors. |
App\Entity\Product | No errors. |
App\Entity\Vat | No errors. |