http://firplast.clients.greentic.net/company/1129

Query Metrics

7 Database Queries
7 Different statements
3.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.tva AS tva_4, t0.email AS email_5, t0.code_client AS code_client_6, t0.price_type AS price_type_7, t0.discount_rate AS discount_rate_8, t0.grouping AS grouping_9, t0.grouping_comment AS grouping_comment_10, t0.shipping_cost_tax_excluded AS shipping_cost_tax_excluded_11, t0.free_shipping_tax_excluded AS free_shipping_tax_excluded_12, t0.note AS note_13, t0.date_add AS date_add_14, t0.date_update AS date_update_15, t0.known_as AS known_as_16, t0.exception_price AS exception_price_17, t0.departure AS departure_18, t0.locked AS locked_19, t0.billing_frequency AS billing_frequency_20, t21.id AS id_22, t21.name AS name_23, t21.street AS street_24, t21.city AS city_25, t21.postcode AS postcode_26, t21.country AS country_27, t21.phone AS phone_28, t21.fax AS fax_29, t21.billing_email AS billing_email_30, t21.send_invoice_mail AS send_invoice_mail_31, t21.payment_method AS payment_method_32, t21.bank_name AS bank_name_33, t21.bank_code AS bank_code_34, t21.bank_counter AS bank_counter_35, t21.account_number AS account_number_36, t21.account_key AS account_key_37, t21.code_bic AS code_bic_38, t21.code_iban AS code_iban_39, t21.cgv AS cgv_40, t21.chorus AS chorus_41, t21.chorus_service AS chorus_service_42, t21.chorus_order AS chorus_order_43, t21.chorus_mentions AS chorus_mentions_44, t21.company_id AS company_id_45, t0.status_id AS status_id_46, t0.owner_id AS owner_id_47, t0.commercial_id AS commercial_id_48, t0.job_id AS job_id_49 FROM company t0 LEFT JOIN billing_address t21 ON t21.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  "1129"
]
2 0.49 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7, t0.date_add AS date_add_8, t0.date_update AS date_update_9, t0.code AS code_10, t0.api_token AS api_token_11, t0.code_business AS code_business_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  70
]
3 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.function AS function_4, t0.phone AS phone_5, t0.email AS email_6, t0.date_add AS date_add_7, t0.date_update AS date_update_8, t0.company_id AS company_id_9 FROM contact t0 WHERE t0.company_id = ?
Parameters:
[
  1129
]
4 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.city AS city_4, t0.postcode AS postcode_5, t0.country AS country_6, t0.phone AS phone_7, t0.fax AS fax_8, t0.delivery_email AS delivery_email_9, t0.contact_delivery_note AS contact_delivery_note_10, t0.delivery_schedules AS delivery_schedules_11, t0.closing_days AS closing_days_12, t0.truck_constraint AS truck_constraint_13, t0.need_tailgate AS need_tailgate_14, t0.pallet_max_height AS pallet_max_height_15, t0.need_appointment_booking AS need_appointment_booking_16, t0.is_delivery_note_calculated AS is_delivery_note_calculated_17, t0.specific_access AS specific_access_18, t0.company_id AS company_id_19 FROM delivery_address t0 WHERE t0.company_id = ?
Parameters:
[
  1129
]
5 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.tva AS tva_4, t0.email AS email_5, t0.code_client AS code_client_6, t0.price_type AS price_type_7, t0.discount_rate AS discount_rate_8, t0.grouping AS grouping_9, t0.grouping_comment AS grouping_comment_10, t0.shipping_cost_tax_excluded AS shipping_cost_tax_excluded_11, t0.free_shipping_tax_excluded AS free_shipping_tax_excluded_12, t0.note AS note_13, t0.date_add AS date_add_14, t0.date_update AS date_update_15, t0.known_as AS known_as_16, t0.exception_price AS exception_price_17, t0.departure AS departure_18, t0.locked AS locked_19, t0.billing_frequency AS billing_frequency_20, t21.id AS id_22, t21.name AS name_23, t21.street AS street_24, t21.city AS city_25, t21.postcode AS postcode_26, t21.country AS country_27, t21.phone AS phone_28, t21.fax AS fax_29, t21.billing_email AS billing_email_30, t21.send_invoice_mail AS send_invoice_mail_31, t21.payment_method AS payment_method_32, t21.bank_name AS bank_name_33, t21.bank_code AS bank_code_34, t21.bank_counter AS bank_counter_35, t21.account_number AS account_number_36, t21.account_key AS account_key_37, t21.code_bic AS code_bic_38, t21.code_iban AS code_iban_39, t21.cgv AS cgv_40, t21.chorus AS chorus_41, t21.chorus_service AS chorus_service_42, t21.chorus_order AS chorus_order_43, t21.chorus_mentions AS chorus_mentions_44, t21.company_id AS company_id_45, t0.status_id AS status_id_46, t0.owner_id AS owner_id_47, t0.commercial_id AS commercial_id_48, t0.job_id AS job_id_49 FROM company t0 LEFT JOIN billing_address t21 ON t21.company_id = t0.id WHERE t0.owner_id = ?
Parameters:
[
  70
]
6 0.42 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM job t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM status t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\Company No errors.
App\Entity\BillingAddress No errors.
App\Entity\Status No errors.
App\Entity\User No errors.
App\Entity\Job No errors.
App\Entity\Contact No errors.
App\Entity\DeliveryAddress No errors.