Redirect 302 redirect from POST @user_security_login (3596ab)

GET https://agro.n46.net/en/account/

Query Metrics

16 Database Queries
12 Different statements
26.30 ms Query time
0 Invalid entities
6300 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
12.72 ms
(48.38%)
1
SELECT SUM(a0_.area * a1_.share) AS sclr_0 FROM ax_land a0_ INNER JOIN ax_share a1_ WHERE a1_.land_id = a0_.id AND a1_.farmer_id = ?
Parameters:
[
  "1012600019358"
]
4.42 ms
(16.81%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.org AS org_4, t0.street AS street_5, t0.city AS city_6, t0.district AS district_7, t0.postal_code AS postal_code_8, t0.country AS country_9, t0.phone_number AS phone_number_10, t0.email AS email_11, t0.bank_account AS bank_account_12, t0.bank_name AS bank_name_13, t0.ic_serial_number AS ic_serial_number_14, t0.authority AS authority_15, t0.ic_issue_date AS ic_issue_date_16, t0.ic_expiration_date AS ic_expiration_date_17, t0.birth_date AS birth_date_18, t0.number AS number_19, t0.signature_date AS signature_date_20, t0.start_date AS start_date_21, t0.termination_date AS termination_date_22, t0.payable_in AS payable_in_23, t0.kg_griu_ha AS kg_griu_ha_24, t0.kg_porumb_ha AS kg_porumb_ha_25, t0.kg_floarea_soarelui_ha AS kg_floarea_soarelui_ha_26, t0.bani_ha AS bani_ha_27, t0.procentul_in_bani AS procentul_in_bani_28, t0.clauze_speciale AS clauze_speciale_29, t0.registration_date AS registration_date_30, t0.registration_number AS registration_number_31, t0.notes AS notes_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.farmer_id AS farmer_id_35, t0.landowner_id AS landowner_id_36 FROM ax_contract t0 WHERE t0.farmer_id = ?
Parameters:
[
  "1012600019358"
]
2.20 ms
(8.37%)
1
SELECT t0.id AS id_1, t0.share AS share_2, t0.notes AS notes_3, t0.incomplete_information AS incomplete_information_4, t0.fake_landowner AS fake_landowner_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.land_id AS land_id_8, t0.landowner_id AS landowner_id_9, t0.farmer_id AS farmer_id_10 FROM ax_share t0 WHERE t0.farmer_id = ?
Parameters:
[
  "1012600019358"
]
1.61 ms
(6.11%)
5
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.org AS org_5, t0.street AS street_6, t0.city AS city_7, t0.postal_code AS postal_code_8, t0.country AS country_9, t0.phone_number AS phone_number_10, t0.tax_id AS tax_id_11, t0.bank_account AS bank_account_12, t0.bank_name AS bank_name_13, t0.color AS color_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.locality_id AS locality_id_17, t18.id AS id_19, t18.currency AS currency_20, t18.status AS status_21, t18.created_at AS created_at_22, t18.updated_at AS updated_at_23, t18.farmer_id AS farmer_id_24 FROM ax_farmer t0 LEFT JOIN ax_basket t18 ON t18.farmer_id = t0.id WHERE t0.id = ?
Parameters:
[
  "1012600019358"
]
1.32 ms
(5.04%)
1
SELECT SUM(a0_.area) AS sclr_0 FROM ax_field a0_ WHERE a0_.season_id = ?
Parameters:
[
  12
]
0.93 ms
(3.53%)
1
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.farmer_id AS farmer_id_6 FROM ax_user_farmer t0 WHERE t0.user_id = ?
Parameters:
[
  1
]
0.72 ms
(2.73%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.farmer_id AS farmer_id_7 FROM ax_season t0 WHERE t0.farmer_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "1012600019358"
]
0.66 ms
(2.50%)
1
SELECT t0.id AS id_1, t0.nin AS nin_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.job_title AS job_title_6, t0.status AS status_7, t0.hire_date AS hire_date_8, t0.termination_date AS termination_date_9, t0.street AS street_10, t0.city AS city_11, t0.district AS district_12, t0.postal_code AS postal_code_13, t0.country AS country_14, t0.phone_number AS phone_number_15, t0.birth_date AS birth_date_16, t0.notes AS notes_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.farmer_id AS farmer_id_20 FROM ax_employee t0 WHERE t0.farmer_id = ?
Parameters:
[
  "1012600019358"
]
0.52 ms
(1.99%)
1
SELECT COUNT(a0_.id) AS sclr_0 FROM ax_field a0_ WHERE a0_.season_id = ?
Parameters:
[
  12
]
0.51 ms
(1.93%)
1
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.ip_address AS ip_address_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.user_id AS user_id_5 FROM ax_user_activity_log a0_ WHERE a0_.user_id IN (?, ?, ?) ORDER BY a0_.id DESC LIMIT 5
Parameters:
[
  1
  6
  8
]
0.39 ms
(1.49%)
1
SELECT t0.id AS id_1, t0.email AS email_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.status AS status_7, t0.roles AS roles_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.farmer_id AS farmer_id_11, t0.language_id AS language_id_12 FROM ax_user t0 WHERE t0.farmer_id = ?
Parameters:
[
  "1012600019358"
]
0.30 ms
(1.14%)
1
SELECT t0.id AS id_1, t0.email AS email_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.status AS status_7, t0.roles AS roles_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.farmer_id AS farmer_id_11, t0.language_id AS language_id_12 FROM ax_user t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Share 2603
App\Entity\Land 2601
App\Entity\Contract 532
App\Entity\Landowner 532
App\Entity\Employee 10
App\Entity\Farmer 5
App\Entity\UserActivityLog 5
App\Entity\UserFarmer 5
App\Entity\User 3
App\Entity\Language 2
App\Entity\Season 1
App\Entity\Locality 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Farmer No errors.
App\Entity\Language No errors.
App\Entity\UserFarmer No errors.
App\Entity\Land No errors.
App\Entity\Share No errors.
App\Entity\Season No errors.
App\Entity\Field No errors.
App\Entity\Locality No errors.
App\Entity\Basket No errors.
App\Entity\Contract No errors.
App\Entity\Employee No errors.
App\Entity\UserActivityLog No errors.
App\Entity\Activity No errors.
App\Entity\Landowner No errors.
App\Entity\ContractPayment No errors.