GET https://mandataire-test.orbis-integral.com/feature/station/reporting/credit_report

Query Metrics

7 Database Queries
7 Different statements
7.12 ms Query time
0 Invalid entities
1613 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.54 ms
(35.65%)
1
SELECT n0_.id AS id_0, n0_.uuid AS uuid_1, n0_.message AS message_2, n0_.link_to AS link_to_3, n0_.status AS status_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.unread AS unread_7, n0_.permission AS permission_8, n0_.document_id AS document_id_9, n0_.order_group_id AS order_group_id_10, n0_.station_id AS station_id_11, n0_.owner_id AS owner_id_12, n0_.ticket_id AS ticket_id_13, n0_.user_id AS user_id_14, n0_.operation_id AS operation_id_15, n0_.bank_reconciliation_id AS bank_reconciliation_id_16, n0_.inventaire_id AS inventaire_id_17 FROM notification n0_ WHERE (n0_.owner_id IS NULL OR n0_.owner_id <> ?) AND (n0_.user_id IS NULL OR n0_.user_id = ?) AND n0_.permission IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND n0_.unread = 1
Parameters:
[
  2
  2
  "ROLE_STATION"
  "ROLE_MANAGER"
  "ROLE_PRODUCT"
  "ROLE_TIERS"
  "ROLE_CLUSTER"
  "ROLE_BANK"
  "ROLE_ACCOUNT"
  "ROLE_CREATE_ORDER"
  "ROLE_VIEW_ORDER"
  "ROLE_VALIDATE_ORDER"
  "ROLE_CREATE_ORDER_GROUP"
  "ROLE_VIEW_ORDER_GROUP"
  "ROLE_VALIDATE_ORDER_GROUP"
  "ROLE_CREATE_DELIVERY"
  "ROLE_VIEW_DELIVERY"
  "ROLE_VALIDATE_DELIVERY"
  "ROLE_CREATE_INVOICE"
  "ROLE_VIEW_INVOICE"
  "ROLE_VALIDATE_INVOICE"
  "ROLE_CREATE_PAY"
  "ROLE_VIEW_PAY"
  "ROLE_VALIDATE_PAY"
  "ROLE_CONFIRM_ORDER"
  "ROLE_CONFIRM_ORDER_GROUP"
  "ROLE_CONFIRM_DELIVERY"
  "ROLE_CREATE_IA"
  "ROLE_VIEW_IA"
  "ROLE_VALIDATE_IA"
  "ROLE_CASH"
  "ROLE_VALIDATE_ORDER_ACHAT"
  "ROLE_CREATE_DECAISSEMENT"
  "ROLE_VALIDATE_DECAISSEMENT"
  "ROLE_CREATE_RECONCILIATION"
  "ROLE_VALIDATE_RECONCILIATION"
  "ROLE_CREATE_ENCAISSEMENT"
  "ROLE_VALIDATE_ENCAISSEMENT"
  "ROLE_CREATE_INVOICE_SUPPLIER"
  "ROLE_VALIDATE_INVOICE_SUPPLIER"
  "ROLE_CREATE_CHECK_DEPOSIT"
  "ROLE_VALIDATE_CHECK_DEPOSIT"
  "ROLE_CREATE_TRANSFERT"
  "ROLE_VALIDATE_TRANSFERT"
  "ROLE_VIEW_FACTURE_MANAGER"
  "ROLE_CREATE_TRANSFER_STOCK"
  "ROLE_VIEW_TRANSFER_STOCK"
  "ROLE_VALIDATE_TRANSFER_STOCK"
  "ROLE_CREATE_BANK_EXPENSE"
  "ROLE_ADMIN"
]
2.16 ms
(30.39%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code_dgh AS code_dgh_2, s0_.telephone AS telephone_3, s0_.locality AS locality_4, s0_.address AS address_5, s0_.geo_localization AS geo_localization_6, s0_.email AS email_7, s0_.num_account AS num_account_8, s0_.is_test AS is_test_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.uuid AS uuid_12, s0_.cluster_id AS cluster_id_13, s0_.city_id AS city_id_14 FROM station s0_ WHERE s0_.is_test IS NULL
Parameters:
[]
0.77 ms
(10.85%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uuid AS uuid_7 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters:
[
  2
]
0.50 ms
(7.10%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone_number AS phone_number_6, t0.enabled AS enabled_7, t0.email AS email_8, t0.is_admin AS is_admin_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12, t0.cash_id AS cash_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.38 ms
(5.37%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uuid AS uuid_6 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = ?
Parameters:
[
  2
]
0.38 ms
(5.33%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uuid AS uuid_6 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = ?
Parameters:
[
  1
]
0.38 ms
(5.33%)
1
SELECT s0_.id AS id_0, s0_.raison_social AS raison_social_1, s0_.forme AS forme_2, s0_.activity AS activity_3, s0_.numero_cc AS numero_cc_4, s0_.siege AS siege_5, s0_.telephone AS telephone_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.uuid AS uuid_9 FROM societe s0_ ORDER BY s0_.id DESC LIMIT 1
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Feature\Notification 768
App\Entity\Comptabilite\Operation 751
App\Entity\Admin\Permission 47
App\Entity\Admin\Station 19
App\Entity\Feature\Document 17
App\Entity\Domain\City 4
App\Entity\User 3
App\Entity\Admin\Cluster 2
App\Entity\Admin\Role 1
App\Entity\Admin\Societe 1