1
0.57 ms
SELECT t0 . id AS id_1 , t0 . doc_entry AS doc_entry_2 , t0 . template AS template_3 , t0 . notes AS notes_4 , t0 . validation_status AS validation_status_5 , t0 . created_by AS created_by_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . exercise_id AS exercise_id_10 , t0 . financial_state_template_id AS financial_state_template_id_11 FROM ofrp t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . doc_entry AS doc_entry_2 , t0 . template AS template_3 , t0 . notes AS notes_4 , t0 . validation_status AS validation_status_5 , t0 . created_by AS created_by_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . company_id AS company_id_9 , t0 . exercise_id AS exercise_id_10 , t0 . financial_state_template_id AS financial_state_template_id_11 FROM ofrp t0 WHERE t0 . id = '506' ;
Copy
2
0.36 ms
SELECT t0 . id AS id_1 , t0 . company_code AS company_code_2 , t0 . company_name AS company_name_3 , t0 . sector_of_activity AS sector_of_activity_4 , t0 . legal_form AS legal_form_5 , t0 . administration_method AS administration_method_6 , t0 . year_of_creation AS year_of_creation_7 , t0 . created_by AS created_by_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 FROM ocmp t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . company_code AS company_code_2 , t0 . company_name AS company_name_3 , t0 . sector_of_activity AS sector_of_activity_4 , t0 . legal_form AS legal_form_5 , t0 . administration_method AS administration_method_6 , t0 . year_of_creation AS year_of_creation_7 , t0 . created_by AS created_by_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 FROM ocmp t0 WHERE t0 . id = 104 ;
Copy
3
0.16 ms
SELECT t0 . id AS id_1 , t0 . exercise AS exercise_2 , t0 . name AS name_3 , t0 . start_date AS start_date_4 , t0 . end_date AS end_date_5 , t0 . created_by AS created_by_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 FROM ofyr t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . exercise AS exercise_2 , t0 . name AS name_3 , t0 . start_date AS start_date_4 , t0 . end_date AS end_date_5 , t0 . created_by AS created_by_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 FROM ofyr t0 WHERE t0 . id = 158 ;
Copy
4
0.11 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . created_by AS created_by_4 , t0 . type AS type_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 FROM ofrm t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . name AS name_3 , t0 . created_by AS created_by_4 , t0 . type AS type_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 FROM ofrm t0 WHERE t0 . id = 70 ;
Copy
5
0.17 ms
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . amount AS amount_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . financial_statement_id AS financial_statement_id_6 , t0 . financial_state_template_line_id AS financial_state_template_line_id_7 FROM frp1 t0 WHERE t0 . financial_statement_id = ?
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . amount AS amount_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . financial_statement_id AS financial_statement_id_6 , t0 . financial_state_template_line_id AS financial_state_template_line_id_7 FROM frp1 t0 WHERE t0 . financial_statement_id = 506 ;
Copy
6
0.15 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2155 ;
Copy
7
0.12 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2159 ;
Copy
8
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2160 ;
Copy
9
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2161 ;
Copy
10
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2162 ;
Copy
11
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2168 ;
Copy
12
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2172 ;
Copy
13
0.09 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2173 ;
Copy
14
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2174 ;
Copy
15
0.09 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2175 ;
Copy
16
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2176 ;
Copy
17
0.10 ms
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . code AS code_2 , t0 . reference AS reference_3 , t0 . label AS label_4 , t0 . type AS type_5 , t0 . totalization_reference AS totalization_reference_6 , t0 . totalization_sign AS totalization_sign_7 , t0 . created_by AS created_by_8 , t0 . financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0 . id = 2183 ;
Copy
18
0.11 ms
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . amount AS amount_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . financial_statement_id AS financial_statement_id_6 , t0 . financial_state_template_line_id AS financial_state_template_line_id_7 FROM frp1 t0 WHERE t0 . financial_statement_id = ?
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . amount AS amount_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . financial_statement_id AS financial_statement_id_6 , t0 . financial_state_template_line_id AS financial_state_template_line_id_7 FROM frp1 t0 WHERE t0 . financial_statement_id = 506 ;
Copy
19
0.20 ms
SELECT o0_ . id AS id_0 , o0_ . company_code AS company_code_1 , o0_ . company_name AS company_name_2 , o0_ . sector_of_activity AS sector_of_activity_3 , o0_ . legal_form AS legal_form_4 , o0_ . administration_method AS administration_method_5 , o0_ . year_of_creation AS year_of_creation_6 , o0_ . created_by AS created_by_7 , o0_ . created_at AS created_at_8 , o0_ . updated_at AS updated_at_9 FROM ocmp o0_
SELECT o0_ . id AS id_0 , o0_ . company_code AS company_code_1 , o0_ . company_name AS company_name_2 , o0_ . sector_of_activity AS sector_of_activity_3 , o0_ . legal_form AS legal_form_4 , o0_ . administration_method AS administration_method_5 , o0_ . year_of_creation AS year_of_creation_6 , o0_ . created_by AS created_by_7 , o0_ . created_at AS created_at_8 , o0_ . updated_at AS updated_at_9 FROM ocmp o0_ ;
Copy
20
0.15 ms
SELECT o0_ . id AS id_0 , o0_ . exercise AS exercise_1 , o0_ . name AS name_2 , o0_ . start_date AS start_date_3 , o0_ . end_date AS end_date_4 , o0_ . created_by AS created_by_5 , o0_ . created_at AS created_at_6 , o0_ . updated_at AS updated_at_7 FROM ofyr o0_
SELECT o0_ . id AS id_0 , o0_ . exercise AS exercise_1 , o0_ . name AS name_2 , o0_ . start_date AS start_date_3 , o0_ . end_date AS end_date_4 , o0_ . created_by AS created_by_5 , o0_ . created_at AS created_at_6 , o0_ . updated_at AS updated_at_7 FROM ofyr o0_ ;
Copy
21
0.13 ms
SELECT o0_ . id AS id_0 , o0_ . code AS code_1 , o0_ . name AS name_2 , o0_ . created_by AS created_by_3 , o0_ . type AS type_4 , o0_ . created_at AS created_at_5 , o0_ . updated_at AS updated_at_6 FROM ofrm o0_
SELECT o0_ . id AS id_0 , o0_ . code AS code_1 , o0_ . name AS name_2 , o0_ . created_by AS created_by_3 , o0_ . type AS type_4 , o0_ . created_at AS created_at_5 , o0_ . updated_at AS updated_at_6 FROM ofrm o0_ ;
Copy
22
0.13 ms
SELECT f0_ . id AS id_0 , f0_ . code AS code_1 , f0_ . reference AS reference_2 , f0_ . label AS label_3 , f0_ . type AS type_4 , f0_ . totalization_reference AS totalization_reference_5 , f0_ . totalization_sign AS totalization_sign_6 , f0_ . created_by AS created_by_7 , f0_ . financial_state_template_id AS financial_state_template_id_8 FROM frm1 f0_ WHERE f0_ . financial_state_template_id = ? AND (f0_ . type < > ? OR f0_ . type IS NULL ) ORDER BY f0_ . code ASC
Parameters :
[
70
"Total "
]
SELECT f0_ . id AS id_0 , f0_ . code AS code_1 , f0_ . reference AS reference_2 , f0_ . label AS label_3 , f0_ . type AS type_4 , f0_ . totalization_reference AS totalization_reference_5 , f0_ . totalization_sign AS totalization_sign_6 , f0_ . created_by AS created_by_7 , f0_ . financial_state_template_id AS financial_state_template_id_8 FROM frm1 f0_ WHERE f0_ . financial_state_template_id = 70 AND (f0_ . type < > 'Total' OR f0_ . type IS NULL ) ORDER BY f0_ . code ASC ;
Copy