GET https://ticket.olihost.com/fr/company/

Query Metrics

22 Database Queries
6 Different statements
1499.29 ms Query time
0 Invalid entities
32 Managed entities

Grouped Statements

Show all queries

Time Count Info
961.60 ms
(64.14%)
10
SELECT s0_.id AS id_0, s0_.token AS token_1, s0_.created_at AS created_at_2, s0_.answered_at AS answered_at_3, s0_.note AS note_4, s0_.note_commercial AS note_commercial_5, s0_.note_entered_at AS note_entered_at_6, s0_.ticket_id AS ticket_id_7 FROM survey_ticket s0_ INNER JOIN ticket t1_ ON s0_.ticket_id = t1_.id INNER JOIN customer c2_ ON t1_.customer_id = c2_.id WHERE c2_.id = ? AND (s0_.created_at BETWEEN ? AND ?)
Parameters:
[
  4
  "2026-02-07 00:00:00"
  "2026-05-07 23:59:59"
]
258.65 ms
(17.25%)
7
SELECT t0.id AS id_1, t0.street AS street_2, t0.postal_code AS postal_code_3, t0.city AS city_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.position_in_company AS position_in_company_7, t0.landline_phone AS landline_phone_8, t0.mobile_phone AS mobile_phone_9, t0.language AS language_10, t0.can_create_private_ticket AS can_create_private_ticket_11, t0.can_view_private_ticket AS can_view_private_ticket_12, t0.user_id AS user_id_13, t0.company_id AS company_id_14 FROM customer t0 WHERE t0.company_id = ?
Parameters:
[
  1
]
140.91 ms
(9.40%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.language AS language_4, t0.teamleader_id AS teamleader_id_5, t0.user_id AS user_id_6 FROM employee t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  81
]
102.37 ms
(6.83%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.street AS street_5, t0.postal_code AS postal_code_6, t0.city AS city_7, t0.comment AS comment_8, t0.information AS information_9, t0.phone AS phone_10, t0.pay AS pay_11, t0.website AS website_12, t0.url_confluence AS url_confluence_13, t0.active AS active_14, t0.accounting_code_olisys AS accounting_code_olisys_15, t0.accounting_code_olihost AS accounting_code_olihost_16, t0.cif AS cif_17, t0.teamleader_id AS teamleader_id_18, t0.vat_number AS vat_number_19, t0.national_identification_number AS national_identification_number_20, t0.referent_id AS referent_id_21, t0.structure_id AS structure_id_22 FROM company t0
Parameters:
[]
35.35 ms
(2.36%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM structure t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.41 ms
(0.03%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.verified AS verified_5, t0.valid AS valid_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.totp_secret AS totp_secret_9, t0.totp_enable AS totp_enable_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  81
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 11
App\Entity\Customer 10
App\Entity\Company 7
App\Entity\Employee 2
App\Entity\Structure 2

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\UserFilter No errors.
App\Entity\Employee No errors.
App\Entity\Customer No errors.
App\Entity\Command No errors.
App\Entity\InternalDemand No errors.
App\Entity\InternalAnswer No errors.
App\Entity\Ticket No errors.
App\Entity\Answer No errors.
App\Entity\Company No errors.
App\Entity\Structure No errors.
App\Entity\CompanyService No errors.
App\Entity\Supervisor No errors.
App\Entity\UserFilterCompany No errors.
App\Entity\MovementStock No errors.
App\Entity\InterventionReport No errors.
App\Entity\UserFilterCustomer No errors.
App\Entity\SurveyTicket No errors.
App\Entity\UserFilterState No errors.
App\Entity\UserFilterFile No errors.
App\Entity\UserFilterOwner No errors.
App\Entity\UserFilterService No errors.
App\Entity\InventoryProductLine No errors.
App\Entity\TechnicianFile No errors.
App\Entity\CommercialVisibility No errors.
App\Entity\StateCommand No errors.
App\Entity\CommandType No errors.
App\Entity\Supplier No errors.
App\Entity\InternalDeliveryAddress No errors.
App\Entity\CommandProduct No errors.
App\Entity\InternalState No errors.
App\Entity\InternalDemandJoinPart No errors.
App\Entity\InternalAnswerJoinPart No errors.
App\Entity\TicketType No errors.
App\Entity\Service No errors.
App\Entity\State No errors.
App\Entity\Priority No errors.
App\Entity\SubService No errors.
App\Entity\TicketJoinPart No errors.
App\Entity\AnswerJoinPart No errors.
App\Entity\ServiceFileStructure No errors.
App\Entity\MovementStockType No errors.
App\Entity\Product No errors.
App\Entity\StoragePlace No errors.
App\Entity\ProductSerialNumber No errors.
App\Entity\InterventionReportJoinPart No errors.
App\Entity\File No errors.
App\Entity\Inventory No errors.
App\Entity\Parameter No errors.
App\Entity\ServiceSubService No errors.
App\Entity\StoragePlaceProduct No errors.
App\Entity\Site No errors.
App\Entity\InventoryState No errors.
App\Entity\StockAlertEmail No errors.
App\Entity\Survey No errors.
App\Entity\SurveyQuestion No errors.
App\Entity\SurveyPossibleAnswer No errors.
App\Entity\SurveyQuestionSection No errors.
App\Entity\SurveyPossibleAnswerType No errors.