https://extranet.ffcb.fr/my-space/orders/993/download-invoice

Query Metrics

23 Database Queries
9 Different statements
10.33 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.91 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:
[
  "993"
]
2 0.61 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"
]
3 0.35 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"
]
4 0.40 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"
]
5 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:
[
  "sale.invoice.notice"
]
6 0.32 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"
]
7 0.35 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"
]
8 0.35 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"
]
9 0.34 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"
]
10 0.35 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"
]
11 0.35 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"
]
12 0.35 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"
]
13 0.40 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"
]
14 0.36 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:
[
  4
]
15 0.79 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:
[
  1968
]
16 0.62 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:
[
  993
]
17 0.45 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
]
18 0.43 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
]
19 0.41 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
]
20 0.34 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
]
21 0.34 ms
SELECT DATABASE()
Parameters:
[]
22 0.98 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "ffcbovrintranet"
]
23 0.18 ms
SELECT DATABASE()
Parameters:
[]

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\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\Contact No errors.
App\Entity\Region No errors.
App\Entity\Commission 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.
App\Entity\UserQuestion No errors.
App\Entity\UserCart No errors.
App\Entity\SyndicatUser No errors.
App\Entity\LogConnection No errors.
App\Entity\ParamCotisationType No errors.
App\Entity\ParamCotisationSlice No errors.
App\Entity\SyndicatContact No errors.
App\Entity\CommissionContact No errors.
App\Entity\Repere No errors.
App\Entity\ContactConseilAdministration No errors.
App\Entity\Activity No errors.
App\Entity\FormTemplate No errors.
App\Entity\FormUserQuestion No errors.
App\Entity\UserResponse No errors.
App\Entity\UserCartLine No errors.
App\Entity\ParamCotisationSliceParam No errors.
App\Entity\Roles No errors.
App\Entity\CommissionRole No errors.
App\Entity\ConseilAdministration No errors.
App\Entity\FormTemplateQuestion No errors.
App\Entity\FormTemplateDiffusion No errors.
App\Entity\FormFieldType No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Document No errors.
App\Entity\SmsSender No errors.
App\Entity\Event No errors.
App\Entity\EntityLog No errors.
App\Entity\FirmLinkReason No errors.
App\Entity\Faq No errors.
App\Entity\MessageSended No errors.
App\Entity\SmsApiParams No errors.
App\Entity\MessageTemplate No errors.
App\Entity\LinkedFirm No errors.
App\Entity\CotisationMigration No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
Vich\UploaderBundle\Entity\File No errors.