Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1

[
  "App\Controller\Plugins\Integrations\Impact"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.controller AS controller_4,
  t0.config AS config_5,
  t0.active AS active_6,
  t0.insert_date AS insert_date_7,
  t0.channel_id AS channel_id_8
FROM
  integrations t0
WHERE
  t0.controller = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = 'App\\Controller\\Plugins\\Integrations\\Impact' LIMIT 1;

SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1

[
  "impact_fetch_data"
]

SELECT
  t0.id AS id_1,
  t0.label_id AS label_id_2,
  t0.integration AS integration_3,
  t0.config AS config_4,
  t0.last_execution AS last_execution_5,
  t0.every_minutes AS every_minutes_6,
  t0.next_execution AS next_execution_7
FROM
  cron t0
WHERE
  t0.label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = 'impact_fetch_data' LIMIT 1;

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = ? AND t0.category_id = ? LIMIT 1

[
  "pref"
  "settings"
]

SELECT
  t0.id AS id_1,
  t0.name_id AS name_id_2,
  t0.category_id AS category_id_3,
  t0.name AS name_4,
  t0.value AS value_5
FROM
  options t0
WHERE
  t0.name_id = ?
  AND t0.category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = 'pref' AND t0.category_id = 'settings' LIMIT 1;

SELECT
                cou.id,
                c.id AS channelId,
                COALESCE(ec.url, ec_s.url) AS url, 
                c.params,
                s.id AS storeId
            FROM coupons cou
            INNER JOIN stores s 
                ON s.id = cou.store_id
            INNER JOIN store_channels ec_s
                ON ec_s.store = s.id AND ec_s.channel = s.channel
			INNER JOIN channels c
				ON c.id = s.channel
            LEFT JOIN coupon_channels ec
                ON ec.coupon = cou.id AND ec.channel = s.channel
            WHERE cou.id = ?

[
  0
]

SELECT
  cou.id,
  c.id AS channelId,
  COALESCE(ec.url, ec_s.url) AS url,
  c.params,
  s.id AS storeId
FROM
  coupons cou
  INNER JOIN stores s ON s.id = cou.store_id
  INNER JOIN store_channels ec_s ON ec_s.store = s.id
  AND ec_s.channel = s.channel
  INNER JOIN channels c ON c.id = s.channel
  LEFT JOIN coupon_channels ec ON ec.coupon = cou.id
  AND ec.channel = s.channel
WHERE
  cou.id = ?

SELECT
                cou.id,
                c.id AS channelId,
                COALESCE(ec.url, ec_s.url) AS url, 
                c.params,
                s.id AS storeId
            FROM coupons cou
            INNER JOIN stores s 
                ON s.id = cou.store_id
            INNER JOIN store_channels ec_s
                ON ec_s.store = s.id AND ec_s.channel = s.channel
			INNER JOIN channels c
				ON c.id = s.channel
            LEFT JOIN coupon_channels ec
                ON ec.coupon = cou.id AND ec.channel = s.channel
            WHERE cou.id = 0;

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = ? LIMIT 1

[
  "go_link"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.route AS route_3,
  t0.icon AS icon_4,
  t0.parent AS parent_5,
  t0.menu_position AS menu_position_6,
  t0.popup_open AS popup_open_7,
  t0.mandatory AS mandatory_8,
  t0.menu_default AS menu_default_9
FROM
  modules t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = 'go_link' LIMIT 1;