GET https://prontopago.smartescrow.eu/api/rules/run

Response
200 OK
IP
74.234.245.156
Profiled on
Token
1a4b35

Query Metrics

6 Database Queries
4 Different statements
12.03 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
11.00 ms
(91.44%) 		2 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(4.79%) 		1 
SELECT i0_.invoice_type AS invoice_type_0, i0_.last_analysis_date AS last_analysis_date_1, i0_.advance_date AS advance_date_2, i0_.invoice_number AS invoice_number_3, i0_.broadcast_date AS broadcast_date_4, i0_.delivery_date AS delivery_date_5, i0_.expiration_date AS expiration_date_6, i0_.days_to_expiration AS days_to_expiration_7, i0_.payment_method AS payment_method_8, i0_.tax_base AS tax_base_9, i0_.tax AS tax_10, i0_.retentions AS retentions_11, i0_.total AS total_12, i0_.supplied_expense AS supplied_expense_13, i0_.attached_document AS attached_document_14, i0_.status AS status_15, i0_.discount AS discount_16, i0_.total_to_receive AS total_to_receive_17, i0_.provider_chooses_advance AS provider_chooses_advance_18, i0_.advance_allowed AS advance_allowed_19, i0_.contract_file AS contract_file_20, i0_.invoice_file AS invoice_file_21, i0_.rectified_document AS rectified_document_22, i0_.signed_contract AS signed_contract_23, i0_.concept AS concept_24, i0_.units AS units_25, i0_.price AS price_26, i0_.date_of_service_provision AS date_of_service_provision_27, i0_.created_at AS created_at_28, i0_.updated_at AS updated_at_29, i0_.id AS id_30, i0_.provider_id AS provider_id_31, i0_.client_id AS client_id_32, i0_.target_id AS target_id_33, i0_.advance_bank_account_id AS advance_bank_account_id_34 FROM invoice i0_ LEFT JOIN user u1_ ON i0_.client_id = u1_.id LEFT JOIN user u2_ ON i0_.provider_id = u2_.id WHERE i0_.status IN (?, ?, ?) AND i0_.expiration_date > ? AND u1_.is_account_active = ? AND u2_.is_account_active = ? AND u1_.is_soft_deleted = ? AND u2_.is_soft_deleted = ? ORDER BY i0_.expiration_date ASC, i0_.updated_at ASC, i0_.created_at ASC
Parameters: 
[
  1
  2
  3
  "2024-12-23 23:00:01"
  1
  1
  0
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(2.08%) 		1 
INSERT INTO cron_result (success, message, stats, created_at, updated_at, id) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  "Cron executed successfully"
  "{"analysis":{"PASS":[],"FAIL":[]},"processedUsers":[],"processedInvoices":[],"successfulProcessing":[],"failedProcessing":[]}"
  "2024-12-23 23:00:01"
  "2024-12-23 23:00:01"
  "d7b52a5c-61fe-438d-8e97-a7d64a125acd"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(1.69%) 		2 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\Invoice No errors.
App\Entity\User No errors.
App\Entity\Target No errors.
App\Entity\BankAccount No errors.
App\Entity\CronResult No errors.