Symfony Profiler

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

Query Metrics

SELECT DATABASE()

[]

SELECT
  DATABASE()

SELECT DATABASE();

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

[
  "service_gc2"
]

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'service_gc2'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT COUNT(s0_.id) AS sclr_0 FROM system_module_config_global s0_ WHERE s0_.id > ? AND s0_.bundlekey = ? AND s0_.name = ?

[
  0
  "badiu.system.packge"
  "badiu.system.packge.version"
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  system_module_config_global s0_
WHERE
  s0_.id > ?
  AND s0_.bundlekey = ?
  AND s0_.name = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM system_module_config_global s0_ WHERE s0_.id > 0 AND s0_.bundlekey = 'badiu.system.packge' AND s0_.name = 'badiu.system.packge.version';

SELECT s0_.id AS id_0, s0_.entity AS entity_1, s0_.firstname AS firstname_2, s0_.lastname AS lastname_3, s0_.alternatename AS alternatename_4, s0_.enablealternatename AS enablealternatename_5, s0_.email AS email_6, s0_.auth AS auth_7, s0_.username AS username_8, s0_.idnumber AS idnumber_9, s0_.shortname AS shortname_10, s0_.doctype AS doctype_11, s0_.docnumber AS docnumber_12, s0_.ukey AS ukey_13, s0_.idnumber AS idnumber_14, s0_.dconfig AS dconfig_15, s0_.param AS param_16, s0_.marker AS marker_17, s0_.lang AS lang_18, s0_.passwordstatus AS passwordstatus_19 FROM system_user s0_ WHERE s0_.id > ? AND s0_.entity = ? AND s0_.shortname = ?

[
  0
  1
  "guest"
]

SELECT
  s0_.id AS id_0,
  s0_.entity AS entity_1,
  s0_.firstname AS firstname_2,
  s0_.lastname AS lastname_3,
  s0_.alternatename AS alternatename_4,
  s0_.enablealternatename AS enablealternatename_5,
  s0_.email AS email_6,
  s0_.auth AS auth_7,
  s0_.username AS username_8,
  s0_.idnumber AS idnumber_9,
  s0_.shortname AS shortname_10,
  s0_.doctype AS doctype_11,
  s0_.docnumber AS docnumber_12,
  s0_.ukey AS ukey_13,
  s0_.idnumber AS idnumber_14,
  s0_.dconfig AS dconfig_15,
  s0_.param AS param_16,
  s0_.marker AS marker_17,
  s0_.lang AS lang_18,
  s0_.passwordstatus AS passwordstatus_19
FROM
  system_user s0_
WHERE
  s0_.id > ?
  AND s0_.entity = ?
  AND s0_.shortname = ?

SELECT s0_.id AS id_0, s0_.entity AS entity_1, s0_.firstname AS firstname_2, s0_.lastname AS lastname_3, s0_.alternatename AS alternatename_4, s0_.enablealternatename AS enablealternatename_5, s0_.email AS email_6, s0_.auth AS auth_7, s0_.username AS username_8, s0_.idnumber AS idnumber_9, s0_.shortname AS shortname_10, s0_.doctype AS doctype_11, s0_.docnumber AS docnumber_12, s0_.ukey AS ukey_13, s0_.idnumber AS idnumber_14, s0_.dconfig AS dconfig_15, s0_.param AS param_16, s0_.marker AS marker_17, s0_.lang AS lang_18, s0_.passwordstatus AS passwordstatus_19 FROM system_user s0_ WHERE s0_.id > 0 AND s0_.entity = 1 AND s0_.shortname = 'guest';

SELECT s0_.pemissionkey AS pemissionkey_0 FROM system_access_role_permission s0_ INNER JOIN system_access_role_user s1_ ON (s0_.roleid = s1_.roleid) WHERE s0_.entity = ? AND s1_.userid = ?

[
  1
  "2"
]

SELECT
  s0_.pemissionkey AS pemissionkey_0
FROM
  system_access_role_permission s0_
  INNER JOIN system_access_role_user s1_ ON (s0_.roleid = s1_.roleid)
WHERE
  s0_.entity = ?
  AND s1_.userid = ?

SELECT s0_.pemissionkey AS pemissionkey_0 FROM system_access_role_permission s0_ INNER JOIN system_access_role_user s1_ ON (s0_.roleid = s1_.roleid) WHERE s0_.entity = 1 AND s1_.userid = '2';

SELECT s0_.shortname AS shortname_0 FROM system_access_role_user s1_ INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id WHERE s1_.entity = ? AND s1_.userid = ?

[
  1
  "2"
]

SELECT
  s0_.shortname AS shortname_0
FROM
  system_access_role_user s1_
  INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id
WHERE
  s1_.entity = ?
  AND s1_.userid = ?

SELECT s0_.shortname AS shortname_0 FROM system_access_role_user s1_ INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id WHERE s1_.entity = 1 AND s1_.userid = '2';

SELECT s0_.shortname AS shortname_0, s0_.defaultroute AS defaultroute_1 FROM system_access_role_user s1_ INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id WHERE s1_.entity = ? AND s1_.userid = ?

[
  1
  "2"
]

SELECT
  s0_.shortname AS shortname_0,
  s0_.defaultroute AS defaultroute_1
FROM
  system_access_role_user s1_
  INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id
WHERE
  s1_.entity = ?
  AND s1_.userid = ?

SELECT s0_.shortname AS shortname_0, s0_.defaultroute AS defaultroute_1 FROM system_access_role_user s1_ INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id WHERE s1_.entity = 1 AND s1_.userid = '2';

SELECT s0_.id AS id_0, s0_.modulekey AS modulekey_1, s0_.moduleinstance AS moduleinstance_2 FROM system_access_user_record s0_ WHERE s0_.entity = ? AND s0_.userid = ?

[
  1
  "2"
]

SELECT
  s0_.id AS id_0,
  s0_.modulekey AS modulekey_1,
  s0_.moduleinstance AS moduleinstance_2
FROM
  system_access_user_record s0_
WHERE
  s0_.entity = ?
  AND s0_.userid = ?

SELECT s0_.id AS id_0, s0_.modulekey AS modulekey_1, s0_.moduleinstance AS moduleinstance_2 FROM system_access_user_record s0_ WHERE s0_.entity = 1 AND s0_.userid = '2';