GET https://www.couponscode.com/go/c/5

Query Metrics

14 Database Queries
8 Different statements
9.36 ms Query time
0 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time Count Info
7.59 ms
(81.03%)
1
"COMMIT"
Parameters:
[]
0.48 ms
(5.07%)
4
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
Parameters:
[
  "App\Controller\Plugins\Integrations\Impact"
]
0.43 ms
(4.57%)
4
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
Parameters:
[
  "impact_fetch_data"
]
0.31 ms
(3.29%)
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
Parameters:
[
  "pref"
  "settings"
]
0.27 ms
(2.92%)
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 = ?
Parameters:
[
  5
]
0.14 ms
(1.45%)
1
INSERT INTO clicks (entity_type, entity_id, ip_addr, user, channel, cashback, source, insert_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  5
  "216.73.216.114"
  null
  32
  0
  null
  "2026-04-17 12:17:48"
]
0.10 ms
(1.12%)
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 = ? LIMIT 1
Parameters:
[
  "go_link"
]
0.05 ms
(0.54%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Integrations 4
App\Entity\Channels 4
App\Entity\Cron 3
App\Entity\Options 1
App\Entity\Clicks 1

Entities Mapping

Class Mapping errors
App\Entity\Options No errors.
App\Entity\Integrations No errors.
App\Entity\Channels No errors.
App\Entity\Cron No errors.
App\Entity\Modules No errors.
App\Entity\Clicks No errors.