GET https://ccms.shady.ro/login

Query Metrics

14 Database Queries
5 Different statements
64.55 ms Query time
0 Invalid entities
13 Managed entities

Queries

Group similar statements

# Time Info
1 0.78 ms
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"
]
2 2.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.icon AS icon_4, t0.def_language AS def_language_5, t0.visible AS visible_6, t0.insert_date AS insert_date_7 FROM countries t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
  "US"
]
3 0.80 ms
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"
]
4 1.80 ms
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"
]
5 1.20 ms
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\Skimlinks"
]
6 0.62 ms
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"
]
7 0.38 ms
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\CJ"
]
8 1.40 ms
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:
[
  "cj_fetch_data"
]
9 48.47 ms
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\Awin"
]
10 0.49 ms
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:
[
  "awin_fetch_data"
]
11 2.22 ms
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:
[
  "app_login"
]
12 1.04 ms
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:
[
  "extension"
  "browsers"
]
13 1.15 ms
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:
[
  "home_title"
  "content"
]
14 1.34 ms
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:
[
  "home_description"
  "content"
]

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 2

Entities Mapping

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