Shopware Profiler

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 
  name, 
  version, 
  active, 
  installation_date AS installed 
FROM 
  s_core_plugins

[]

SELECT 
  s0_.id AS id_0, 
  s0_.main_id AS main_id_1, 
  s0_.category_id AS category_id_2, 
  s0_.name AS name_3, 
  s0_.title AS title_4, 
  s0_.position AS position_5, 
  s0_.host AS host_6, 
  s0_.base_path AS base_path_7, 
  s0_.base_url AS base_url_8, 
  s0_.hosts AS hosts_9, 
  s0_.secure AS secure_10, 
  s0_.template_id AS template_id_11, 
  s0_.`default` AS default_12, 
  s0_.active AS active_13, 
  s0_.customer_scope AS customer_scope_14, 
  s0_.main_id AS main_id_15, 
  s0_.template_id AS template_id_16, 
  s0_.document_template_id AS document_template_id_17, 
  s0_.category_id AS category_id_18, 
  s0_.locale_id AS locale_id_19, 
  s0_.currency_id AS currency_id_20, 
  s0_.customer_group_id AS customer_group_id_21, 
  s0_.fallback_id AS fallback_id_22 
FROM 
  s_core_shops s0_ 
WHERE 
  s0_.`default` = 1

[]

SELECT 
  t0.id AS id_1, 
  t0.shopID AS shopID_2, 
  t0.shopID AS shopID_3 
FROM 
  s_core_shops_attributes t0 
WHERE 
  t0.shopID = ?

array:1 [
  0 => 1
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0 
WHERE 
  t0.name = ? 
  AND t0.capability_enable = ? 
LIMIT 
  1

array:2 [
  0 => "BogxSeoVariants"
  1 => 1
]

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"
]

SELECT 
  `locale`.`locale` 
FROM 
  `s_core_shops` AS `shop` 
  LEFT JOIN `s_core_locales` AS `locale` ON `locale`.`id` = `shop`.`locale_id` 
WHERE 
  `shop`.`default` = 1

[]

SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'backend/plugin_manager/exceptions'
  ) 
  AND (shopID = '1') 
  AND (localeID = '1')

[]