| 1 |
0.33 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_id = ? AND t0.active = ? LIMIT 1
Parameters: [
"API-GMFA-001-V2"
1
]
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_id = 'API-GMFA-001-V2' AND t0.active = 1 LIMIT 1;
|
| 2 |
0.23 ms |
SELECT t0.id AS id_1, t0.param_name AS param_name_2, t0.param_type AS param_type_3, t0.param_value AS param_value_4, t0.is_required AS is_required_5, t0.param_description AS param_description_6, t0.param_location AS param_location_7, t0.endpoint_id AS endpoint_id_8 FROM endpoint_params t0 WHERE t0.endpoint_id = ?
SELECT t0.id AS id_1, t0.param_name AS param_name_2, t0.param_type AS param_type_3, t0.param_value AS param_value_4, t0.is_required AS is_required_5, t0.param_description AS param_description_6, t0.param_location AS param_location_7, t0.endpoint_id AS endpoint_id_8 FROM endpoint_params t0 WHERE t0.endpoint_id = 137;
|
| 3 |
0.19 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.sort_order AS sort_order_3 FROM endpoint_group t0 ORDER BY t0.sort_order ASC, t0.id ASC
SELECT t0.id AS id_1, t0.label AS label_2, t0.sort_order AS sort_order_3 FROM endpoint_group t0 ORDER BY t0.sort_order ASC, t0.id ASC;
|
| 4 |
0.22 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_id = ? AND t0.active = ? LIMIT 1
Parameters: [
"API-GMFA-001-V2"
1
]
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_id = 'API-GMFA-001-V2' AND t0.active = 1 LIMIT 1;
|
| 5 |
0.26 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 1 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 6 |
0.23 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 2 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 7 |
0.26 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 3 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 8 |
0.25 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 4 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 9 |
0.27 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 5 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 10 |
0.31 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 6 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 11 |
0.24 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 7 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 12 |
0.28 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 8 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 13 |
0.25 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 9 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 14 |
0.23 ms |
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC
SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 10 ORDER BY t0.sort_order ASC, t0.endpoint_name ASC;
|
| 15 |
0.17 ms |
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.endpoint_id AS endpoint_id_4 FROM endpoint_comments t0 WHERE t0.endpoint_id = ?
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.endpoint_id AS endpoint_id_4 FROM endpoint_comments t0 WHERE t0.endpoint_id = 137;
|