1
1.50 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . is_enabled AS is_enabled_5 FROM `user` t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . is_enabled AS is_enabled_5 FROM `user` t0 WHERE t0 . id = 1 ;
Copy
2
0.73 ms
SELECT count (DISTINCT c0_ . id ) AS sclr_0 FROM client c0_
SELECT count (DISTINCT c0_ . id ) AS sclr_0 FROM client c0_ ;
Copy
3
0.55 ms
SELECT DISTINCT c0_ . id AS id_0 , c0_ . id AS id_1 FROM client c0_ ORDER BY c0_ . id ASC LIMIT 10
SELECT DISTINCT c0_ . id AS id_0 , c0_ . id AS id_1 FROM client c0_ ORDER BY c0_ . id ASC LIMIT 10 ;
Copy
4
0.68 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . ip AS ip_2 , c0_ . internal_ip AS internal_ip_3 , c0_ . private_key AS private_key_4 , c0_ . dev AS dev_5 , c0_ . asn AS asn_6 , c0_ . openvpn24_compatible AS openvpn24_compatible_7 , c0_ . certificate_fingerprint AS certificate_fingerprint_8 , c0_ . loopback_ip AS loopback_ip_9 , c0_ . server_group_id AS server_group_id_10 FROM client c0_ WHERE c0_ . id IN (? ) ORDER BY c0_ . id ASC
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . ip AS ip_2 , c0_ . internal_ip AS internal_ip_3 , c0_ . private_key AS private_key_4 , c0_ . dev AS dev_5 , c0_ . asn AS asn_6 , c0_ . openvpn24_compatible AS openvpn24_compatible_7 , c0_ . certificate_fingerprint AS certificate_fingerprint_8 , c0_ . loopback_ip AS loopback_ip_9 , c0_ . server_group_id AS server_group_id_10 FROM client c0_ WHERE c0_ . id IN (10 ) ORDER BY c0_ . id ASC ;
Copy
5
1.03 ms
SELECT t0 . id AS id_1 , t0 . port AS port_2 , t0 . client_ip AS client_ip_3 , t0 . server_ip AS server_ip_4 , t0 . client_id AS client_id_5 , t6 . id AS id_7 , t6 . name AS name_8 , t6 . ip AS ip_9 , t6 . internal_ip AS internal_ip_10 , t6 . private_key AS private_key_11 , t6 . dev AS dev_12 , t6 . asn AS asn_13 , t6 . openvpn24_compatible AS openvpn24_compatible_14 , t6 . certificate_fingerprint AS certificate_fingerprint_15 , t6 . loopback_ip AS loopback_ip_16 , t6 . server_group_id AS server_group_id_17 , t0 . server_id AS server_id_18 , t19 . id AS id_20 , t19 . name AS name_21 , t19 . asn AS asn_22 , t19 . server_ip AS server_ip_23 , t19 . certificate_fingerprint AS certificate_fingerprint_24 , t19 . tunnel_networks AS tunnel_networks_25 , t19 . server_group_id AS server_group_id_26 FROM client_server t0 INNER JOIN client t6 ON t0 . client_id = t6 . id INNER JOIN server t19 ON t0 . server_id = t19 . id WHERE t0 . client_id IN (? )
SELECT t0 . id AS id_1 , t0 . port AS port_2 , t0 . client_ip AS client_ip_3 , t0 . server_ip AS server_ip_4 , t0 . client_id AS client_id_5 , t6 . id AS id_7 , t6 . name AS name_8 , t6 . ip AS ip_9 , t6 . internal_ip AS internal_ip_10 , t6 . private_key AS private_key_11 , t6 . dev AS dev_12 , t6 . asn AS asn_13 , t6 . openvpn24_compatible AS openvpn24_compatible_14 , t6 . certificate_fingerprint AS certificate_fingerprint_15 , t6 . loopback_ip AS loopback_ip_16 , t6 . server_group_id AS server_group_id_17 , t0 . server_id AS server_id_18 , t19 . id AS id_20 , t19 . name AS name_21 , t19 . asn AS asn_22 , t19 . server_ip AS server_ip_23 , t19 . certificate_fingerprint AS certificate_fingerprint_24 , t19 . tunnel_networks AS tunnel_networks_25 , t19 . server_group_id AS server_group_id_26 FROM client_server t0 INNER JOIN client t6 ON t0 . client_id = t6 . id INNER JOIN server t19 ON t0 . server_id = t19 . id WHERE t0 . client_id IN (10 );
Copy
6
0.70 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_default AS is_default_3 , t0 . ip_control_token AS ip_control_token_4 , t0 . loopback_networks AS loopback_networks_5 FROM server_group t0 WHERE t0 . id IN (? )
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . is_default AS is_default_3 , t0 . ip_control_token AS ip_control_token_4 , t0 . loopback_networks AS loopback_networks_5 FROM server_group t0 WHERE t0 . id IN (1 );
Copy
7
1.01 ms
SELECT t0 . id AS id_1 , t0 . port AS port_2 , t0 . client_ip AS client_ip_3 , t0 . server_ip AS server_ip_4 , t0 . client_id AS client_id_5 , t6 . id AS id_7 , t6 . name AS name_8 , t6 . ip AS ip_9 , t6 . internal_ip AS internal_ip_10 , t6 . private_key AS private_key_11 , t6 . dev AS dev_12 , t6 . asn AS asn_13 , t6 . openvpn24_compatible AS openvpn24_compatible_14 , t6 . certificate_fingerprint AS certificate_fingerprint_15 , t6 . loopback_ip AS loopback_ip_16 , t6 . server_group_id AS server_group_id_17 , t0 . server_id AS server_id_18 , t19 . id AS id_20 , t19 . name AS name_21 , t19 . asn AS asn_22 , t19 . server_ip AS server_ip_23 , t19 . certificate_fingerprint AS certificate_fingerprint_24 , t19 . tunnel_networks AS tunnel_networks_25 , t19 . server_group_id AS server_group_id_26 FROM client_server t0 INNER JOIN client t6 ON t0 . client_id = t6 . id INNER JOIN server t19 ON t0 . server_id = t19 . id WHERE t0 . server_id IN (? , ? , ? , ? )
SELECT t0 . id AS id_1 , t0 . port AS port_2 , t0 . client_ip AS client_ip_3 , t0 . server_ip AS server_ip_4 , t0 . client_id AS client_id_5 , t6 . id AS id_7 , t6 . name AS name_8 , t6 . ip AS ip_9 , t6 . internal_ip AS internal_ip_10 , t6 . private_key AS private_key_11 , t6 . dev AS dev_12 , t6 . asn AS asn_13 , t6 . openvpn24_compatible AS openvpn24_compatible_14 , t6 . certificate_fingerprint AS certificate_fingerprint_15 , t6 . loopback_ip AS loopback_ip_16 , t6 . server_group_id AS server_group_id_17 , t0 . server_id AS server_id_18 , t19 . id AS id_20 , t19 . name AS name_21 , t19 . asn AS asn_22 , t19 . server_ip AS server_ip_23 , t19 . certificate_fingerprint AS certificate_fingerprint_24 , t19 . tunnel_networks AS tunnel_networks_25 , t19 . server_group_id AS server_group_id_26 FROM client_server t0 INNER JOIN client t6 ON t0 . client_id = t6 . id INNER JOIN server t19 ON t0 . server_id = t19 . id WHERE t0 . server_id IN (1 , 2 , 3 , 4 );
Copy
8
0.75 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . asn AS asn_3 , t0 . server_ip AS server_ip_4 , t0 . certificate_fingerprint AS certificate_fingerprint_5 , t0 . tunnel_networks AS tunnel_networks_6 , t0 . server_group_id AS server_group_id_7 , t8 . id AS id_9 , t8 . name AS name_10 , t8 . is_default AS is_default_11 , t8 . ip_control_token AS ip_control_token_12 , t8 . loopback_networks AS loopback_networks_13 FROM server t0 LEFT JOIN server_group t8 ON t0 . server_group_id = t8 . id WHERE t0 . server_group_id IN (? )
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . asn AS asn_3 , t0 . server_ip AS server_ip_4 , t0 . certificate_fingerprint AS certificate_fingerprint_5 , t0 . tunnel_networks AS tunnel_networks_6 , t0 . server_group_id AS server_group_id_7 , t8 . id AS id_9 , t8 . name AS name_10 , t8 . is_default AS is_default_11 , t8 . ip_control_token AS ip_control_token_12 , t8 . loopback_networks AS loopback_networks_13 FROM server t0 LEFT JOIN server_group t8 ON t0 . server_group_id = t8 . id WHERE t0 . server_group_id IN (1 );
Copy