Symfony Profiler

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;

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;

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;

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

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 = 'signup' AND t0.enabled = 1 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 = ?
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;

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 = ?

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';

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;

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;

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;

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;

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 = ?

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';

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;

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;

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 = 125 AND t0.application_setings_id = 6 AND t0.enabled = 1 LIMIT 1;

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 = 125 AND te.enabled = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user (
  email, roles, code, PASSWORD, enabled,
  avatar, created_at, updated_at, activation_code,
  last_acces
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user (email, roles, code, PASSWORD, enabled, avatar, created_at, updated_at, activation_code, last_acces) VALUES ('gqhvfmpfox1xfii@yahoo.com', '[\"ROLE_CLIENT_USER\"]', 'user', '$2y$13$VO/Y.M12LdTHlcMCySlSme.CGWuvisxPrVs9pUdCtKG8NbXOGGn8e', 0, NULL, '2024-12-23 03:15:21', '2024-12-23 03:15:21', NULL, '2024-12-23 03:15:21');

"ROLLBACK"

"ROLLBACK";