Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 530
• Events
• Routing
• Cache
• Translation 5
• Security
• Twig
• HTTP Client
• Doctrine
• PHPCR
• Debug
• Emails
• Serializer
• JMS Serializer 0
• Sulu
• Configuration

Query Metrics

SELECT 1 FROM phpcr_workspaces WHERE name = ?

[
  "default_live"
]

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT prefix, uri FROM phpcr_namespaces

[]

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC

[
  "/cmf/galosoftcz/custom-urls/routes/dev.galosoft.cz/cs/miners"
  "default_live"
]

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/galosoftcz/custom-urls/routes/dev.galosoft.cz/cs/miners'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.lang AS lang_3, t0.name AS name_4, t0.code AS code_5, t0.hashrate AS hashrate_6, t0.power AS power_7, t0.income_btc AS income_btc_8, t0.income_usd AS income_usd_9, t0.price AS price_10, t0.price_electricity AS price_electricity_11, t0.roi AS roi_12, t0.description AS description_13, t0.manufacturer AS manufacturer_14, t0.launch AS launch_15, t0.algorithm AS algorithm_16, t0.cooling AS cooling_17, t0.gallery AS gallery_18, t0.icons AS icons_19, t0.currencies AS currencies_20, t0.wtm_url AS wtm_url_21, t0.wtm_data AS wtm_data_22, t0.wtm_key AS wtm_key_23 FROM miners t0 WHERE t0.lang = ? ORDER BY t0.sort_order ASC

[
  "cs"
]

SELECT
  t0.id AS id_1,
  t0.sort_order AS sort_order_2,
  t0.lang AS lang_3,
  t0.name AS name_4,
  t0.code AS code_5,
  t0.hashrate AS hashrate_6,
  t0.power AS power_7,
  t0.income_btc AS income_btc_8,
  t0.income_usd AS income_usd_9,
  t0.price AS price_10,
  t0.price_electricity AS price_electricity_11,
  t0.roi AS roi_12,
  t0.description AS description_13,
  t0.manufacturer AS manufacturer_14,
  t0.launch AS launch_15,
  t0.algorithm AS algorithm_16,
  t0.cooling AS cooling_17,
  t0.gallery AS gallery_18,
  t0.icons AS icons_19,
  t0.currencies AS currencies_20,
  t0.wtm_url AS wtm_url_21,
  t0.wtm_data AS wtm_data_22,
  t0.wtm_key AS wtm_key_23
FROM
  miners t0
WHERE
  t0.lang = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.lang AS lang_3, t0.name AS name_4, t0.code AS code_5, t0.hashrate AS hashrate_6, t0.power AS power_7, t0.income_btc AS income_btc_8, t0.income_usd AS income_usd_9, t0.price AS price_10, t0.price_electricity AS price_electricity_11, t0.roi AS roi_12, t0.description AS description_13, t0.manufacturer AS manufacturer_14, t0.launch AS launch_15, t0.algorithm AS algorithm_16, t0.cooling AS cooling_17, t0.gallery AS gallery_18, t0.icons AS icons_19, t0.currencies AS currencies_20, t0.wtm_url AS wtm_url_21, t0.wtm_data AS wtm_data_22, t0.wtm_key AS wtm_key_23 FROM miners t0 WHERE t0.lang = 'cs' ORDER BY t0.sort_order ASC;

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC

[
  "dev.galosoft.cz/{localization}"
  "dev"
  "galosoftcz"
]

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'dev.galosoft.cz/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'galosoftcz' ORDER BY w0_.id ASC;