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"
]
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
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 <> 2) AND (n0_.user_id IS NULL OR n0_.user_id = 2) AND n0_.permission IN ('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') AND n0_.unread = 1;
|
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
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;
|