Shopware Profiler

SELECT 
  ce.name, 
  COALESCE(
    currentShop.value, parentShop.value, 
    fallbackShop.value, ce.value
  ) as value 
FROM 
  s_core_plugins p 
  INNER JOIN s_core_config_forms cf ON cf.plugin_id = p.id 
  INNER JOIN s_core_config_elements ce ON ce.form_id = cf.id 
  LEFT JOIN s_core_config_values currentShop ON currentShop.element_id = ce.id 
  AND currentShop.shop_id = : currentShopId 
  LEFT JOIN s_core_config_values parentShop ON parentShop.element_id = ce.id 
  AND parentShop.shop_id = : parentShopId 
  LEFT JOIN s_core_config_values fallbackShop ON fallbackShop.element_id = ce.id 
  AND fallbackShop.shop_id = : fallbackShopId 
WHERE 
  p.name =: pluginName

array:4 [
  "fallbackShopId" => 1
  "parentShopId" => 1
  "currentShopId" => null
  "pluginName" => "InputFilter"
]

SELECT 
  t0.id AS id_1, 
  t0.locale AS locale_2, 
  t0.language AS language_3, 
  t0.territory AS territory_4 
FROM 
  s_core_locales t0 
WHERE 
  t0.locale = ? 
LIMIT 
  1

array:1 [
  0 => "en_GB"
]

SELECT 
  ce.name, 
  COALESCE(
    currentShop.value, parentShop.value, 
    fallbackShop.value, ce.value
  ) as value 
FROM 
  s_core_plugins p 
  INNER JOIN s_core_config_forms cf ON cf.plugin_id = p.id 
  INNER JOIN s_core_config_elements ce ON ce.form_id = cf.id 
  LEFT JOIN s_core_config_values currentShop ON currentShop.element_id = ce.id 
  AND currentShop.shop_id = : currentShopId 
  LEFT JOIN s_core_config_values parentShop ON parentShop.element_id = ce.id 
  AND parentShop.shop_id = : parentShopId 
  LEFT JOIN s_core_config_values fallbackShop ON fallbackShop.element_id = ce.id 
  AND fallbackShop.shop_id = : fallbackShopId 
WHERE 
  p.name =: pluginName

array:4 [
  "fallbackShopId" => 1
  "parentShopId" => 1
  "currentShopId" => null
  "pluginName" => "PasswordEncoder"
]

SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = ? 
WHERE 
  ce.type = 0 
ORDER BY 
  name, 
  position

array:1 [
  1 => "Core"
]

SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = ? 
WHERE 
  ce.type = 0 
ORDER BY 
  name, 
  position

array:1 [
  1 => "Frontend"
]

SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = ? 
WHERE 
  ce.type = 0 
ORDER BY 
  name, 
  position

array:1 [
  1 => "Backend"
]