Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

28 Database Queries

7 Different statements

15.90 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.name AS name_1, t0.code AS code_2, t0.id AS id_3 FROM configuration_type t0 WHERE t0.code = ? LIMIT 1
"START TRANSACTION"
INSERT INTO configuration (notify_level, id, created_at, updated_at, prospect_id, type_id) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_parent (id) VALUES (?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_parent (id) VALUES (?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_parent (id) VALUES (?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_parent (id) VALUES (?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO configuration_item_value (id, value) VALUES (?, ?)
"COMMIT"

#▲	Time	Info
1	0.93 ms	SELECT t0.name AS name_1, t0.code AS code_2, t0.id AS id_3 FROM configuration_type t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"MOBILIER"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.code AS code_2, t0.id AS id_3 FROM configuration_type t0 WHERE t0.code = ? LIMIT 1 SELECT t0.name AS name_1, t0.code AS code_2, t0.id AS id_3 FROM configuration_type t0 WHERE t0.code = 'MOBILIER' LIMIT 1;
2	0.91 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.78 ms	INSERT INTO configuration (notify_level, id, created_at, updated_at, prospect_id, type_id) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`0 b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" "2025-04-04 23:09:13" null null b"\x1EÓÉ$\x19ég©»0Ú\x03│Jý\x1F"`] View formatted query View runnable query Explain query INSERT INTO configuration ( notify_level, id, created_at, updated_at, prospect_id, type_id ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO configuration (notify_level, id, created_at, updated_at, prospect_id, type_id) VALUES (0, 0x1F011990F5EE620498D4A93443946B53, '2025-04-04 23:09:13', NULL, NULL, 0x1EE09024198267B8AF30E903B34AEC1F);
4	0.63 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"products" b"\x1F\x01\x19É§l¼ä\x18®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "parent"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('products', 0x1F011990F5F06CAC8418A93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'parent');
5	0.44 ms	INSERT INTO configuration_item_parent (id) VALUES (?) Parameters: [`b"\x1F\x01\x19É§l¼ä\x18®4CökS"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_parent (id) VALUES (?) INSERT INTO configuration_item_parent (id) VALUES (0x1F011990F5F06CAC8418A93443946B53);
6	0.44 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"transport" b"\x1F\x01\x19É§mªæ·®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "parent"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('transport', 0x1F011990F5F06DA691FAA93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'parent');
7	0.49 ms	INSERT INTO configuration_item_parent (id) VALUES (?) Parameters: [`b"\x1F\x01\x19É§mªæ·®4CökS"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_parent (id) VALUES (?) INSERT INTO configuration_item_parent (id) VALUES (0x1F011990F5F06DA691FAA93443946B53);
8	0.53 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"project_discovery" b"\x1F\x01\x19É§mÔàÜ®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "parent"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('project_discovery', 0x1F011990F5F06DE2859AA93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'parent');
9	0.39 ms	INSERT INTO configuration_item_parent (id) VALUES (?) Parameters: [`b"\x1F\x01\x19É§mÔàÜ®4CökS"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_parent (id) VALUES (?) INSERT INTO configuration_item_parent (id) VALUES (0x1F011990F5F06DE2859AA93443946B53);
10	0.49 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"configurator_1" b"\x1F\x01\x19É§n\x14î└®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "parent"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('configurator_1', 0x1F011990F5F06E148CC0A93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'parent');
11	0.33 ms	INSERT INTO configuration_item_parent (id) VALUES (?) Parameters: [`b"\x1F\x01\x19É§n\x14î└®4CökS"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_parent (id) VALUES (?) INSERT INTO configuration_item_parent (id) VALUES (0x1F011990F5F06E148CC0A93443946B53);
12	0.46 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"time" b"\x1F\x01\x19É§h░░\t®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('time', 0x1F011990F5F068B0B009A93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'value');
13	0.45 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§h░░\t®4CökS" "{"value":0}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F068B0B009A93443946B53, '{\"value\":0}');
14	0.50 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"step" b"\x1F\x01\x19É§iFƒ@®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('step', 0x1F011990F5F069469F40A93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'value');
15	0.48 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§iFƒ@®4CökS" "{"value":1}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F069469F40A93443946B53, '{\"value\":1}');
16	0.49 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"complete" b"\x1F\x01\x19É§iî»;®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('complete', 0x1F011990F5F0698CAF3BA93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'value');
17	0.48 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§iî»;®4CökS" "{"value":0}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F0698CAF3BA93443946B53, '{\"value\":0}');
18	0.46 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"chrono_number" b"\x1F\x01\x19É§i¥ë£®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('chrono_number', 0x1F011990F5F069BE899CA93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'value');
19	0.40 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§i¥ë£®4CökS" "{"value":""}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F069BE899CA93443946B53, '{\"value\":\"\"}');
20	0.45 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"grc" b"\x1F\x01\x19É§i╝ß®4CökS" "2025-04-04 23:09:13" null b"\x1F\x01\x19É§¯b\x04ÿÈ®4CökS" null "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('grc', 0x1F011990F5F069F0BCE1A93443946B53, '2025-04-04 23:09:13', NULL, 0x1F011990F5EE620498D4A93443946B53, NULL, 'value');
21	0.41 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§i╝ß®4CökS" "{"value":""}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F069F0BCE1A93443946B53, '{\"value\":\"\"}');
22	0.50 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"identifiers" b"\x1F\x01\x19É§m\x06ªs®4CökS" "2025-04-04 23:09:13" null null b"\x1F\x01\x19É§l¼ä\x18®4CökS" "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('identifiers', 0x1F011990F5F06D06A673A93443946B53, '2025-04-04 23:09:13', NULL, NULL, 0x1F011990F5F06CAC8418A93443946B53, 'value');
23	0.40 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§m\x06ªs®4CökS" "{"value":""}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F06D06A673A93443946B53, '{\"value\":\"\"}');
24	0.51 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"names" b"\x1F\x01\x19É§m8░ø®4CökS" "2025-04-04 23:09:13" null null b"\x1F\x01\x19É§l¼ä\x18®4CökS" "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('names', 0x1F011990F5F06D38B09BA93443946B53, '2025-04-04 23:09:13', NULL, NULL, 0x1F011990F5F06CAC8418A93443946B53, 'value');
25	0.37 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§m8░ø®4CökS" "{"value":""}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F06D38B09BA93443946B53, '{\"value\":\"\"}');
26	0.47 ms	INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"configurations" b"\x1F\x01\x19É§mj¥D®4CökS" "2025-04-04 23:09:13" null null b"\x1F\x01\x19É§l¼ä\x18®4CökS" "value"`] View formatted query View runnable query Explain query INSERT INTO configuration_item ( name, id, created_at, updated_at, configuration_id, parent_id, discr ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO configuration_item (name, id, created_at, updated_at, configuration_id, parent_id, discr) VALUES ('configurations', 0x1F011990F5F06D6ABE44A93443946B53, '2025-04-04 23:09:13', NULL, NULL, 0x1F011990F5F06CAC8418A93443946B53, 'value');
27	0.49 ms	INSERT INTO configuration_item_value (id, value) VALUES (?, ?) Parameters: [`b"\x1F\x01\x19É§mj¥D®4CökS" "{"value":""}"`] View formatted query View runnable query Explain query INSERT INTO configuration_item_value (id, value) VALUES (?, ?) INSERT INTO configuration_item_value (id, value) VALUES (0x1F011990F5F06D6ABE44A93443946B53, '{\"value\":\"\"}');
28	2.20 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

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.

Entities Mapping

Class	Mapping errors
App\Entity\ConfigurationType	No errors.
App\Entity\Question	No errors.
App\Entity\Configuration	No errors.
App\Entity\ConfigurationItem	No errors.
App\Entity\ConfigurationItemValue	No errors.
App\Entity\ConfigurationItemParent	No errors.
App\Entity\Prospect	No errors.
App\Entity\ActivityArea	No errors.

Symfony Profiler

http://afimes-crm.wdib.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping