1
0.30 ms
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 = ?
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 = 1 ;
Copy
2
12.72 ms
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 "
]
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 = '1012600019358' ;
Copy
3
0.72 ms
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 "
]
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 = '1012600019358' ORDER BY t0 . id DESC LIMIT 1 ;
Copy
4
0.52 ms
SELECT COUNT (a0_ . id ) AS sclr_0 FROM ax_field a0_ WHERE a0_ . season_id = ?
SELECT COUNT (a0_ . id ) AS sclr_0 FROM ax_field a0_ WHERE a0_ . season_id = 12 ;
Copy
5
1.32 ms
SELECT SUM (a0_ . area ) AS sclr_0 FROM ax_field a0_ WHERE a0_ . season_id = ?
SELECT SUM (a0_ . area ) AS sclr_0 FROM ax_field a0_ WHERE a0_ . season_id = 12 ;
Copy
6
0.60 ms
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 "
]
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 = '1012600019358' ;
Copy
7
0.39 ms
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 "
]
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 = '1012600019358' ;
Copy
8
0.51 ms
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
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 (1 , 6 , 8 ) ORDER BY a0_ . id DESC LIMIT 5 ;
Copy
9
0.66 ms
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 "
]
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 = '1012600019358' ;
Copy
10
4.42 ms
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 "
]
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 = '1012600019358' ;
Copy
11
2.20 ms
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 "
]
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 = '1012600019358' ;
Copy
12
0.93 ms
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 = ?
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 = 1 ;
Copy
13
0.27 ms
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 :
[
"1003605010219 "
]
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 = '1003605010219' ;
Copy
14
0.25 ms
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 :
[
"1011600035322 "
]
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 = '1011600035322' ;
Copy
15
0.24 ms
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 :
[
"1012600009139 "
]
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 = '1012600009139' ;
Copy
16
0.24 ms
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 :
[
"1015600042744 "
]
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 = '1015600042744' ;
Copy