Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.location AS location_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.pin AS pin_5, t0.ipv4 AS ipv4_6, t0.mqtt_url AS mqtt_url_7, t0.last_instance_ping AS last_instance_ping_8, t0.last_broker_ping AS last_broker_ping_9, t0.fetch_data AS fetch_data_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.disabled_at AS disabled_at_13, t0.adyen_forwarder_secret AS adyen_forwarder_secret_14, t0.adyen_merchant_id AS adyen_merchant_id_15, t0.adyen_management_api_key AS adyen_management_api_key_16, t0.adyen_environment AS adyen_environment_17, t0.adyen_checkout_api_key AS adyen_checkout_api_key_18, t0.adyen_checkout_api_url AS adyen_checkout_api_url_19, t0.adyen_terminal_api_key AS adyen_terminal_api_key_20, t0.customer_id AS customer_id_21 FROM data_pilot_instance t0 WHERE t0.disabled_at IS NULL

[]

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.url AS url_3,
  t0.created_at AS created_at_4,
  t0.pin AS pin_5,
  t0.ipv4 AS ipv4_6,
  t0.mqtt_url AS mqtt_url_7,
  t0.last_instance_ping AS last_instance_ping_8,
  t0.last_broker_ping AS last_broker_ping_9,
  t0.fetch_data AS fetch_data_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.disabled_at AS disabled_at_13,
  t0.adyen_forwarder_secret AS adyen_forwarder_secret_14,
  t0.adyen_merchant_id AS adyen_merchant_id_15,
  t0.adyen_management_api_key AS adyen_management_api_key_16,
  t0.adyen_environment AS adyen_environment_17,
  t0.adyen_checkout_api_key AS adyen_checkout_api_key_18,
  t0.adyen_checkout_api_url AS adyen_checkout_api_url_19,
  t0.adyen_terminal_api_key AS adyen_terminal_api_key_20,
  t0.customer_id AS customer_id_21
FROM
  data_pilot_instance t0
WHERE
  t0.disabled_at IS NULL

SELECT t0.id AS id_1, t0.location AS location_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.pin AS pin_5, t0.ipv4 AS ipv4_6, t0.mqtt_url AS mqtt_url_7, t0.last_instance_ping AS last_instance_ping_8, t0.last_broker_ping AS last_broker_ping_9, t0.fetch_data AS fetch_data_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.disabled_at AS disabled_at_13, t0.adyen_forwarder_secret AS adyen_forwarder_secret_14, t0.adyen_merchant_id AS adyen_merchant_id_15, t0.adyen_management_api_key AS adyen_management_api_key_16, t0.adyen_environment AS adyen_environment_17, t0.adyen_checkout_api_key AS adyen_checkout_api_key_18, t0.adyen_checkout_api_url AS adyen_checkout_api_url_19, t0.adyen_terminal_api_key AS adyen_terminal_api_key_20, t0.customer_id AS customer_id_21 FROM data_pilot_instance t0 WHERE t0.disabled_at IS NULL;

SELECT c0_.id AS id_0, c0_.username AS username_1, c0_.password AS password_2, c0_.firstname AS firstname_3, c0_.lastname AS lastname_4, c0_.role AS role_5, c0_.is_active AS is_active_6, c0_.all_instances AS all_instances_7, c0_.password_changed_at AS password_changed_at_8, c0_.last_login_at AS last_login_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.last_login_instance_id AS last_login_instance_id_12 FROM central_user c0_ WHERE c0_.all_instances = 1 OR EXISTS (SELECT 1 FROM central_user_data_pilot_instance c1_ WHERE c1_.central_user_id = c0_.id AND c1_.data_pilot_instance_id IN (?)) ORDER BY c0_.username ASC

[
  1
]

SELECT
  c0_.id AS id_0,
  c0_.username AS username_1,
  c0_.password AS password_2,
  c0_.firstname AS firstname_3,
  c0_.lastname AS lastname_4,
  c0_.role AS role_5,
  c0_.is_active AS is_active_6,
  c0_.all_instances AS all_instances_7,
  c0_.password_changed_at AS password_changed_at_8,
  c0_.last_login_at AS last_login_at_9,
  c0_.created_at AS created_at_10,
  c0_.updated_at AS updated_at_11,
  c0_.last_login_instance_id AS last_login_instance_id_12
FROM
  central_user c0_
WHERE
  c0_.all_instances = 1
  OR EXISTS (
    SELECT
      1
    FROM
      central_user_data_pilot_instance c1_
    WHERE
      c1_.central_user_id = c0_.id
      AND c1_.data_pilot_instance_id IN (?)
  )
ORDER BY
  c0_.username ASC

SELECT c0_.id AS id_0, c0_.username AS username_1, c0_.password AS password_2, c0_.firstname AS firstname_3, c0_.lastname AS lastname_4, c0_.role AS role_5, c0_.is_active AS is_active_6, c0_.all_instances AS all_instances_7, c0_.password_changed_at AS password_changed_at_8, c0_.last_login_at AS last_login_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.last_login_instance_id AS last_login_instance_id_12 FROM central_user c0_ WHERE c0_.all_instances = 1 OR EXISTS (SELECT 1 FROM central_user_data_pilot_instance c1_ WHERE c1_.central_user_id = c0_.id AND c1_.data_pilot_instance_id IN (1)) ORDER BY c0_.username ASC;