1 |
0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t8.id AS id_9, t8.name AS name_10, t8.code AS code_11, t8.surname AS surname_12, t8.birthday AS birthday_13, t8.mobile_phone AS mobile_phone_14, t8.fixed_phone AS fixed_phone_15, t8.created_at AS created_at_16, t8.updated_at AS updated_at_17, t8.last_acces AS last_acces_18, t8.enabled AS enabled_19, t8.email AS email_20, t8.client_id AS client_id_21 FROM client t0 LEFT JOIN client_profile t8 ON t8.client_id = t0.id WHERE t0.active = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t8.id AS id_9, t8.name AS name_10, t8.code AS code_11, t8.surname AS surname_12, t8.birthday AS birthday_13, t8.mobile_phone AS mobile_phone_14, t8.fixed_phone AS fixed_phone_15, t8.created_at AS created_at_16, t8.updated_at AS updated_at_17, t8.last_acces AS last_acces_18, t8.enabled AS enabled_19, t8.email AS email_20, t8.client_id AS client_id_21 FROM client t0 LEFT JOIN client_profile t8 ON t8.client_id = t0.id WHERE t0.active = 1 LIMIT 1;
|
2 |
0.33 ms |
SELECT t0.id AS id_1, t0.public_name AS public_name_2, t0.code AS code_3, t0.web_domain AS web_domain_4, t0.standart_transport_value AS standart_transport_value_5, t0.subsidized_transport_value AS subsidized_transport_value_6, t0.subsidized_transport_discount AS subsidized_transport_discount_7, t0.limit_subsidized_transport AS limit_subsidized_transport_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.dev_mode AS dev_mode_11, t0.default_language_id AS default_language_id_12, t0.client_id AS client_id_13, t0.application_type_id AS application_type_id_14 FROM app_settings t0 WHERE t0.client_id = ?
SELECT t0.id AS id_1, t0.public_name AS public_name_2, t0.code AS code_3, t0.web_domain AS web_domain_4, t0.standart_transport_value AS standart_transport_value_5, t0.subsidized_transport_value AS subsidized_transport_value_6, t0.subsidized_transport_discount AS subsidized_transport_discount_7, t0.limit_subsidized_transport AS limit_subsidized_transport_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.dev_mode AS dev_mode_11, t0.default_language_id AS default_language_id_12, t0.client_id AS client_id_13, t0.application_type_id AS application_type_id_14 FROM app_settings t0 WHERE t0.client_id = 6;
|
3 |
0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 WHERE t0.id = 16;
|
4 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.features AS features_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.route_name AS route_name_8, t0.regionalized_route AS regionalized_route_9, t0.code AS code_10, t0.icon_library AS icon_library_11, t0.icon_class AS icon_class_12, t0.enabled AS enabled_13 FROM app_module t0 WHERE t0.code = ? AND t0.enabled = ? LIMIT 1
Parameters: [
"login"
1
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.features AS features_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.route_name AS route_name_8, t0.regionalized_route AS regionalized_route_9, t0.code AS code_10, t0.icon_library AS icon_library_11, t0.icon_class AS icon_class_12, t0.enabled AS enabled_13 FROM app_module t0 WHERE t0.code = 'login' AND t0.enabled = 1 LIMIT 1;
|
5 |
0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 WHERE t0.iso_code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 WHERE t0.iso_code = 'ca' LIMIT 1;
|
6 |
0.24 ms |
SELECT te.id AS id, te.enabled AS enabled, te.code AS code, te.name AS name, te.description AS description, te.location AS location, te.created_at AS created_at, te.updated_at AS updated_at, te.menu_order AS menu_order FROM app_menu te JOIN app_menu_app_settings t ON t.app_menu_id = te.id WHERE t.app_settings_id = ? AND te.enabled = ? AND te.code = ?
Parameters: [
6
1
"root_menu_web"
]
SELECT te.id AS id, te.enabled AS enabled, te.code AS code, te.name AS name, te.description AS description, te.location AS location, te.created_at AS created_at, te.updated_at AS updated_at, te.menu_order AS menu_order FROM app_menu te JOIN app_menu_app_settings t ON t.app_menu_id = te.id WHERE t.app_settings_id = 6 AND te.enabled = 1 AND te.code = 'root_menu_web';
|
7 |
0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.code AS code_5 FROM app_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.code AS code_5 FROM app_type t0 WHERE t0.id = 6;
|
8 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.features AS features_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.route_name AS route_name_8, t0.regionalized_route AS regionalized_route_9, t0.code AS code_10, t0.icon_library AS icon_library_11, t0.icon_class AS icon_class_12, t0.enabled AS enabled_13 FROM app_module t0 INNER JOIN app_type_app_module ON t0.id = app_type_app_module.app_module_id WHERE app_type_app_module.app_type_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.features AS features_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.route_name AS route_name_8, t0.regionalized_route AS regionalized_route_9, t0.code AS code_10, t0.icon_library AS icon_library_11, t0.icon_class AS icon_class_12, t0.enabled AS enabled_13 FROM app_module t0 INNER JOIN app_type_app_module ON t0.id = app_type_app_module.app_module_id WHERE app_type_app_module.app_type_id = 6;
|
9 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.features AS features_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.route_name AS route_name_8, t0.regionalized_route AS regionalized_route_9, t0.code AS code_10, t0.icon_library AS icon_library_11, t0.icon_class AS icon_class_12, t0.enabled AS enabled_13 FROM app_module t0 INNER JOIN app_menu_app_module ON t0.id = app_menu_app_module.app_module_id WHERE app_menu_app_module.app_menu_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.features AS features_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.route_name AS route_name_8, t0.regionalized_route AS regionalized_route_9, t0.code AS code_10, t0.icon_library AS icon_library_11, t0.icon_class AS icon_class_12, t0.enabled AS enabled_13 FROM app_module t0 INNER JOIN app_menu_app_module ON t0.id = app_menu_app_module.app_module_id WHERE app_menu_app_module.app_menu_id = 26;
|
10 |
0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 WHERE t0.iso_code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 WHERE t0.iso_code = 'ca' LIMIT 1;
|
11 |
0.23 ms |
SELECT te.id AS id, te.enabled AS enabled, te.code AS code, te.name AS name, te.description AS description, te.location AS location, te.created_at AS created_at, te.updated_at AS updated_at, te.menu_order AS menu_order FROM app_menu te JOIN app_menu_app_settings t ON t.app_menu_id = te.id WHERE t.app_settings_id = ? AND te.enabled = ? AND te.code = ?
Parameters: [
6
1
"guest_user_session_menu_web"
]
SELECT te.id AS id, te.enabled AS enabled, te.code AS code, te.name AS name, te.description AS description, te.location AS location, te.created_at AS created_at, te.updated_at AS updated_at, te.menu_order AS menu_order FROM app_menu te JOIN app_menu_app_settings t ON t.app_menu_id = te.id WHERE t.app_settings_id = 6 AND te.enabled = 1 AND te.code = 'guest_user_session_menu_web';
|
12 |
0.32 ms |
SELECT te.id AS id, te.name AS name, te.description AS description, te.features AS features, te.path AS path, te.created_at AS created_at, te.updated_at AS updated_at, te.route_name AS route_name, te.regionalized_route AS regionalized_route, te.code AS code, te.icon_library AS icon_library, te.icon_class AS icon_class, te.enabled AS enabled FROM app_module te JOIN app_menu_app_module t ON t.app_module_id = te.id WHERE t.app_menu_id = ? AND te.enabled = ?
SELECT te.id AS id, te.name AS name, te.description AS description, te.features AS features, te.path AS path, te.created_at AS created_at, te.updated_at AS updated_at, te.route_name AS route_name, te.regionalized_route AS regionalized_route, te.code AS code, te.icon_library AS icon_library, te.icon_class AS icon_class, te.enabled AS enabled FROM app_module te JOIN app_menu_app_module t ON t.app_module_id = te.id WHERE t.app_menu_id = 30 AND te.enabled = 1;
|
13 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 INNER JOIN app_settings_language ON t0.id = app_settings_language.language_id WHERE app_settings_language.app_settings_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7 FROM language t0 INNER JOIN app_settings_language ON t0.id = app_settings_language.language_id WHERE app_settings_language.app_settings_id = 6;
|
14 |
0.21 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.indexed AS indexed_9, t0.module_id AS module_id_10, t0.application_setings_id AS application_setings_id_11 FROM seo_module t0 WHERE t0.module_id = ? AND t0.application_setings_id = ? AND t0.enabled = ? LIMIT 1
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.indexed AS indexed_9, t0.module_id AS module_id_10, t0.application_setings_id AS application_setings_id_11 FROM seo_module t0 WHERE t0.module_id = 126 AND t0.application_setings_id = 6 AND t0.enabled = 1 LIMIT 1;
|
15 |
0.20 ms |
SELECT te.id AS id, te.code AS code, te.name AS name, te.position AS position, te.order_to_load AS order_to_load, te.description AS description, te.global AS GLOBAL, te.template AS template, te.updated_at AS updated_at, te.created_at AS created_at, te.enabled AS enabled, te.component_type_id AS component_type_id, te.picture_id AS picture_id FROM web_component te JOIN web_component_app_module t ON t.web_component_id = te.id WHERE t.app_module_id = ? AND te.enabled = ?
SELECT te.id AS id, te.code AS code, te.name AS name, te.position AS position, te.order_to_load AS order_to_load, te.description AS description, te.global AS GLOBAL, te.template AS template, te.updated_at AS updated_at, te.created_at AS created_at, te.enabled AS enabled, te.component_type_id AS component_type_id, te.picture_id AS picture_id FROM web_component te JOIN web_component_app_module t ON t.web_component_id = te.id WHERE t.app_module_id = 126 AND te.enabled = 1;
|