Symfony Profiler

Query Metrics

61 Database Queries

40 Different statements

26.14 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
4.47 ms (17.10%)	11	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1765894942 "\x01tags\x01object_2531" "object_2531"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765894942 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_2531', 'object_2531');
3.68 ms (14.09%)	1	INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"/Products/Articles/" 2531 1689767736 1765894942 856 0 16 7 "object" "ADFIX4867" 2173 null null 1 "Articles" "productArticles"`] View formatted query View runnable query Explain query INSERT INTO objects ( `path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `published`, `classId`, `className`) VALUES ('/Products/Articles/', 2531, 1689767736, 1765894942, 856, 0, 16, 7, 'object', 'ADFIX4867', 2173, NULL, NULL, 1, 'Articles', 'productArticles');
1.46 ms (5.60%)	2	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 16`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 16;
1.39 ms (5.32%)	3	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 16;
1.11 ms (4.26%)	1	SHOW COLUMNS FROM object_query_Articles Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM object_query_Articles SHOW COLUMNS FROM object_query_Articles;
0.95 ms (3.62%)	1	SHOW COLUMNS FROM object_store_Articles Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM object_store_Articles SHOW COLUMNS FROM object_store_Articles;
0.93 ms (3.55%)	3	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 16;
0.78 ms (2.99%)	3	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 16;
0.76 ms (2.90%)	1	UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ? Parameters: [`"/Products/Articles/" 2531 1689767736 1765894942 856 0 16 7 "object" "ADFIX4867" 2173 null null 1 "Articles" "productArticles" 2531`] View formatted query View runnable query Explain query UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `published` = ?, `classId` = ?, `className` = ? WHERE `id` = ? UPDATE objects SET `path` = '/Products/Articles/', `id` = 2531, `creationDate` = 1689767736, `modificationDate` = 1765894942, `versionCount` = 856, `userOwner` = 0, `userModification` = 16, `parentId` = 7, `type` = 'object', `key` = 'ADFIX4867', `index` = 2173, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `published` = 1, `classId` = 'Articles', `className` = 'productArticles' WHERE `id` = 2531;
0.74 ms (2.83%)	3	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1765894942 "object_7\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765894942 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7tags');
0.73 ms (2.77%)	1	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 30 3 => 1765894942 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"µÇ\x03\x07À\x1E";i:1765894942;}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('system_cache_write_lock', 0x4F3A313A22A9223A313A7B733A363A22B5C70307C01E223B693A313736353839343934323B7D, 30, 1765894942) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
0.60 ms (2.29%)	2	SELECT id FROM objects WHERE `path` = ? AND `key` = ? Parameters: [`"/Products/Articles/" "ADFIX4867"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = ? AND `key` = ? SELECT id FROM objects WHERE `path` = '/Products/Articles/' AND `key` = 'ADFIX4867';
0.56 ms (2.15%)	1	INSERT INTO object_query_Articles (`sommeil`, `ean13`, `famille`, `refDago`, `refFournisseur`, `nomProduitLot`, `colisage`, `prixAchat`, `prixVente`, `prixTTC`, `prixWebDagoHT`, `prixFinalWebHT`, `catalogue1`, `catalogue2`, `catalogue3`, `catalogue4`, `stockReel`, `stockDisponible`, `stockSuivi`, `stockWebDago`, `nombrePceLotSage`, `conditionnement`, `poidsColisSage`, `uniteSage`, `poidsUniteKg`, `poidsColisKg`, `delaiLivraisonSage`, `visibleGrit`, `visibleDago`, `exportArcelor`, `exportAmazon`, `prixUnitArcelorTTC`, `prixUnitAmazonTTC`, `prixTotalAmazonTTC`, `prixUnitGritTTC`, `prixTotalGritTTC`, `offerCountryDestination`, `prixUnitArcelorHT`, `stockArcelorImp`, `stockArcelor`, `prixPackArcelorHT`, `baremeQtyArcelor`, `baremePrixArcelor`, `baremePourcentageArcelor`, `conditionnementArcelor`, `typeArticle`, `versionArticle`, `grain`, `alesage`, `perforation`, `Fixation`, `forme`, `couleur`, `diametre`, `densite`, `dureteShoreA`, `Epaisseur`, `liner`, `norme`, `porosite`, `puissance`, `revetement`, `support`, `taille`, `technologie`, `viscosite`, `vitesse`, `mandrin`, `longueurProduitMM`, `longueurRubanM`, `diametreNum`, `largeurNum`, `epaisseurMM`, `prixPack`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`-1 "21200862533" "ADFIX" "ADFIX4867" "7000002131" "" null 114.765 229.53 0.0 229.53 "229.53" "Adhésifs" "Attache refermable" "Fixation amovible" null 1.0 1.0 "2" "1" 1 null 0.0 "g" "0" "0" "" null null null null null null null null null null null null "1" "0" null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null 25.0 null "" 2531`] View formatted query View runnable query Explain query INSERT INTO object_query_Articles ( `sommeil`, `ean13`, `famille`, `refDago`, `refFournisseur`, `nomProduitLot`, `colisage`, `prixAchat`, `prixVente`, `prixTTC`, `prixWebDagoHT`, `prixFinalWebHT`, `catalogue1`, `catalogue2`, `catalogue3`, `catalogue4`, `stockReel`, `stockDisponible`, `stockSuivi`, `stockWebDago`, `nombrePceLotSage`, `conditionnement`, `poidsColisSage`, `uniteSage`, `poidsUniteKg`, `poidsColisKg`, `delaiLivraisonSage`, `visibleGrit`, `visibleDago`, `exportArcelor`, `exportAmazon`, `prixUnitArcelorTTC`, `prixUnitAmazonTTC`, `prixTotalAmazonTTC`, `prixUnitGritTTC`, `prixTotalGritTTC`, `offerCountryDestination`, `prixUnitArcelorHT`, `stockArcelorImp`, `stockArcelor`, `prixPackArcelorHT`, `baremeQtyArcelor`, `baremePrixArcelor`, `baremePourcentageArcelor`, `conditionnementArcelor`, `typeArticle`, `versionArticle`, `grain`, `alesage`, `perforation`, `Fixation`, `forme`, `couleur`, `diametre`, `densite`, `dureteShoreA`, `Epaisseur`, `liner`, `norme`, `porosite`, `puissance`, `revetement`, `support`, `taille`, `technologie`, `viscosite`, `vitesse`, `mandrin`, `longueurProduitMM`, `longueurRubanM`, `diametreNum`, `largeurNum`, `epaisseurMM`, `prixPack`, `oo_id` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO object_query_Articles (`sommeil`, `ean13`, `famille`, `refDago`, `refFournisseur`, `nomProduitLot`, `colisage`, `prixAchat`, `prixVente`, `prixTTC`, `prixWebDagoHT`, `prixFinalWebHT`, `catalogue1`, `catalogue2`, `catalogue3`, `catalogue4`, `stockReel`, `stockDisponible`, `stockSuivi`, `stockWebDago`, `nombrePceLotSage`, `conditionnement`, `poidsColisSage`, `uniteSage`, `poidsUniteKg`, `poidsColisKg`, `delaiLivraisonSage`, `visibleGrit`, `visibleDago`, `exportArcelor`, `exportAmazon`, `prixUnitArcelorTTC`, `prixUnitAmazonTTC`, `prixTotalAmazonTTC`, `prixUnitGritTTC`, `prixTotalGritTTC`, `offerCountryDestination`, `prixUnitArcelorHT`, `stockArcelorImp`, `stockArcelor`, `prixPackArcelorHT`, `baremeQtyArcelor`, `baremePrixArcelor`, `baremePourcentageArcelor`, `conditionnementArcelor`, `typeArticle`, `versionArticle`, `grain`, `alesage`, `perforation`, `Fixation`, `forme`, `couleur`, `diametre`, `densite`, `dureteShoreA`, `Epaisseur`, `liner`, `norme`, `porosite`, `puissance`, `revetement`, `support`, `taille`, `technologie`, `viscosite`, `vitesse`, `mandrin`, `longueurProduitMM`, `longueurRubanM`, `diametreNum`, `largeurNum`, `epaisseurMM`, `prixPack`, `oo_id`) VALUES (-1, '21200862533', 'ADFIX', 'ADFIX4867', '7000002131', '', NULL, 114.765, 229.53, 0, 229.53, '229.53', 'Adhésifs', 'Attache refermable', 'Fixation amovible', NULL, 1, 1, '2', '1', 1, NULL, 0, 'g', '0', '0', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 25, NULL, '', 2531);
0.51 ms (1.95%)	1	UPDATE object_query_Articles SET `sommeil` = ?, `ean13` = ?, `famille` = ?, `refDago` = ?, `refFournisseur` = ?, `nomProduitLot` = ?, `colisage` = ?, `prixAchat` = ?, `prixVente` = ?, `prixTTC` = ?, `prixWebDagoHT` = ?, `prixFinalWebHT` = ?, `catalogue1` = ?, `catalogue2` = ?, `catalogue3` = ?, `catalogue4` = ?, `stockReel` = ?, `stockDisponible` = ?, `stockSuivi` = ?, `stockWebDago` = ?, `nombrePceLotSage` = ?, `conditionnement` = ?, `poidsColisSage` = ?, `uniteSage` = ?, `poidsUniteKg` = ?, `poidsColisKg` = ?, `delaiLivraisonSage` = ?, `visibleGrit` = ?, `visibleDago` = ?, `exportArcelor` = ?, `exportAmazon` = ?, `prixUnitArcelorTTC` = ?, `prixUnitAmazonTTC` = ?, `prixTotalAmazonTTC` = ?, `prixUnitGritTTC` = ?, `prixTotalGritTTC` = ?, `offerCountryDestination` = ?, `prixUnitArcelorHT` = ?, `stockArcelorImp` = ?, `stockArcelor` = ?, `prixPackArcelorHT` = ?, `baremeQtyArcelor` = ?, `baremePrixArcelor` = ?, `baremePourcentageArcelor` = ?, `conditionnementArcelor` = ?, `typeArticle` = ?, `versionArticle` = ?, `grain` = ?, `alesage` = ?, `perforation` = ?, `Fixation` = ?, `forme` = ?, `couleur` = ?, `diametre` = ?, `densite` = ?, `dureteShoreA` = ?, `Epaisseur` = ?, `liner` = ?, `norme` = ?, `porosite` = ?, `puissance` = ?, `revetement` = ?, `support` = ?, `taille` = ?, `technologie` = ?, `viscosite` = ?, `vitesse` = ?, `mandrin` = ?, `longueurProduitMM` = ?, `longueurRubanM` = ?, `diametreNum` = ?, `largeurNum` = ?, `epaisseurMM` = ?, `prixPack` = ?, `oo_id` = ? WHERE `oo_id` = ? Parameters: [`-1 "21200862533" "ADFIX" "ADFIX4867" "7000002131" "" null 114.765 229.53 0.0 229.53 "229.53" "Adhésifs" "Attache refermable" "Fixation amovible" null 1.0 1.0 "2" "1" 1 null 0.0 "g" "0" "0" "" null null null null null null null null null null null null "1" "0" null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null 25.0 null "" 2531 2531`] View formatted query View runnable query Explain query UPDATE object_query_Articles SET `sommeil` = ?, `ean13` = ?, `famille` = ?, `refDago` = ?, `refFournisseur` = ?, `nomProduitLot` = ?, `colisage` = ?, `prixAchat` = ?, `prixVente` = ?, `prixTTC` = ?, `prixWebDagoHT` = ?, `prixFinalWebHT` = ?, `catalogue1` = ?, `catalogue2` = ?, `catalogue3` = ?, `catalogue4` = ?, `stockReel` = ?, `stockDisponible` = ?, `stockSuivi` = ?, `stockWebDago` = ?, `nombrePceLotSage` = ?, `conditionnement` = ?, `poidsColisSage` = ?, `uniteSage` = ?, `poidsUniteKg` = ?, `poidsColisKg` = ?, `delaiLivraisonSage` = ?, `visibleGrit` = ?, `visibleDago` = ?, `exportArcelor` = ?, `exportAmazon` = ?, `prixUnitArcelorTTC` = ?, `prixUnitAmazonTTC` = ?, `prixTotalAmazonTTC` = ?, `prixUnitGritTTC` = ?, `prixTotalGritTTC` = ?, `offerCountryDestination` = ?, `prixUnitArcelorHT` = ?, `stockArcelorImp` = ?, `stockArcelor` = ?, `prixPackArcelorHT` = ?, `baremeQtyArcelor` = ?, `baremePrixArcelor` = ?, `baremePourcentageArcelor` = ?, `conditionnementArcelor` = ?, `typeArticle` = ?, `versionArticle` = ?, `grain` = ?, `alesage` = ?, `perforation` = ?, `Fixation` = ?, `forme` = ?, `couleur` = ?, `diametre` = ?, `densite` = ?, `dureteShoreA` = ?, `Epaisseur` = ?, `liner` = ?, `norme` = ?, `porosite` = ?, `puissance` = ?, `revetement` = ?, `support` = ?, `taille` = ?, `technologie` = ?, `viscosite` = ?, `vitesse` = ?, `mandrin` = ?, `longueurProduitMM` = ?, `longueurRubanM` = ?, `diametreNum` = ?, `largeurNum` = ?, `epaisseurMM` = ?, `prixPack` = ?, `oo_id` = ? WHERE `oo_id` = ? UPDATE object_query_Articles SET `sommeil` = -1, `ean13` = '21200862533', `famille` = 'ADFIX', `refDago` = 'ADFIX4867', `refFournisseur` = '7000002131', `nomProduitLot` = '', `colisage` = NULL, `prixAchat` = 114.765, `prixVente` = 229.53, `prixTTC` = 0, `prixWebDagoHT` = 229.53, `prixFinalWebHT` = '229.53', `catalogue1` = 'Adhésifs', `catalogue2` = 'Attache refermable', `catalogue3` = 'Fixation amovible', `catalogue4` = NULL, `stockReel` = 1, `stockDisponible` = 1, `stockSuivi` = '2', `stockWebDago` = '1', `nombrePceLotSage` = 1, `conditionnement` = NULL, `poidsColisSage` = 0, `uniteSage` = 'g', `poidsUniteKg` = '0', `poidsColisKg` = '0', `delaiLivraisonSage` = '', `visibleGrit` = NULL, `visibleDago` = NULL, `exportArcelor` = NULL, `exportAmazon` = NULL, `prixUnitArcelorTTC` = NULL, `prixUnitAmazonTTC` = NULL, `prixTotalAmazonTTC` = NULL, `prixUnitGritTTC` = NULL, `prixTotalGritTTC` = NULL, `offerCountryDestination` = NULL, `prixUnitArcelorHT` = NULL, `stockArcelorImp` = NULL, `stockArcelor` = '1', `prixPackArcelorHT` = '0', `baremeQtyArcelor` = NULL, `baremePrixArcelor` = NULL, `baremePourcentageArcelor` = NULL, `conditionnementArcelor` = NULL, `typeArticle` = NULL, `versionArticle` = NULL, `grain` = NULL, `alesage` = NULL, `perforation` = NULL, `Fixation` = NULL, `forme` = NULL, `couleur` = NULL, `diametre` = NULL, `densite` = NULL, `dureteShoreA` = NULL, `Epaisseur` = NULL, `liner` = NULL, `norme` = NULL, `porosite` = NULL, `puissance` = NULL, `revetement` = NULL, `support` = NULL, `taille` = NULL, `technologie` = NULL, `viscosite` = NULL, `vitesse` = NULL, `mandrin` = NULL, `longueurProduitMM` = NULL, `longueurRubanM` = NULL, `diametreNum` = NULL, `largeurNum` = 25, `epaisseurMM` = NULL, `prixPack` = '', `oo_id` = 2531 WHERE `oo_id` = 2531;
0.49 ms (1.87%)	1	SHOW COLUMNS FROM objects Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM objects SHOW COLUMNS FROM objects;
0.48 ms (1.83%)	1	INSERT INTO object_store_Articles (`oo_id`, `sommeil`, `ean13`, `famille`, `refDago`, `refFournisseur`, `colisage`, `prixAchat`, `prixVente`, `prixTTC`, `prixWebDagoHT`, `catalogue1`, `catalogue2`, `catalogue3`, `catalogue4`, `stockReel`, `stockDisponible`, `stockSuivi`, `nombrePceLotSage`, `conditionnement`, `poidsColisSage`, `uniteSage`, `delaiLivraisonSage`, `visibleGrit`, `visibleDago`, `exportArcelor`, `exportAmazon`, `prixUnitArcelorTTC`, `prixUnitAmazonTTC`, `prixTotalAmazonTTC`, `prixUnitGritTTC`, `prixTotalGritTTC`, `offerCountryDestination`, `prixUnitArcelorHT`, `stockArcelorImp`, `baremeQtyArcelor`, `baremePrixArcelor`, `baremePourcentageArcelor`, `conditionnementArcelor`, `typeArticle`, `versionArticle`, `grain`, `alesage`, `perforation`, `Fixation`, `forme`, `couleur`, `diametre`, `densite`, `dureteShoreA`, `Epaisseur`, `liner`, `norme`, `porosite`, `puissance`, `revetement`, `support`, `taille`, `technologie`, `viscosite`, `vitesse`, `mandrin`, `longueurProduitMM`, `longueurRubanM`, `diametreNum`, `largeurNum`, `epaisseurMM`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`2531 -1 "21200862533" "ADFIX" "ADFIX4867" "7000002131" null 114.765 229.53 0.0 229.53 "Adhésifs" "Attache refermable" "Fixation amovible" null 1.0 1.0 "2" 1 null 0.0 "g" "" null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null 25.0 null`] View formatted query View runnable query Explain query INSERT INTO object_store_Articles ( `oo_id`, `sommeil`, `ean13`, `famille`, `refDago`, `refFournisseur`, `colisage`, `prixAchat`, `prixVente`, `prixTTC`, `prixWebDagoHT`, `catalogue1`, `catalogue2`, `catalogue3`, `catalogue4`, `stockReel`, `stockDisponible`, `stockSuivi`, `nombrePceLotSage`, `conditionnement`, `poidsColisSage`, `uniteSage`, `delaiLivraisonSage`, `visibleGrit`, `visibleDago`, `exportArcelor`, `exportAmazon`, `prixUnitArcelorTTC`, `prixUnitAmazonTTC`, `prixTotalAmazonTTC`, `prixUnitGritTTC`, `prixTotalGritTTC`, `offerCountryDestination`, `prixUnitArcelorHT`, `stockArcelorImp`, `baremeQtyArcelor`, `baremePrixArcelor`, `baremePourcentageArcelor`, `conditionnementArcelor`, `typeArticle`, `versionArticle`, `grain`, `alesage`, `perforation`, `Fixation`, `forme`, `couleur`, `diametre`, `densite`, `dureteShoreA`, `Epaisseur`, `liner`, `norme`, `porosite`, `puissance`, `revetement`, `support`, `taille`, `technologie`, `viscosite`, `vitesse`, `mandrin`, `longueurProduitMM`, `longueurRubanM`, `diametreNum`, `largeurNum`, `epaisseurMM` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO object_store_Articles (`oo_id`, `sommeil`, `ean13`, `famille`, `refDago`, `refFournisseur`, `colisage`, `prixAchat`, `prixVente`, `prixTTC`, `prixWebDagoHT`, `catalogue1`, `catalogue2`, `catalogue3`, `catalogue4`, `stockReel`, `stockDisponible`, `stockSuivi`, `nombrePceLotSage`, `conditionnement`, `poidsColisSage`, `uniteSage`, `delaiLivraisonSage`, `visibleGrit`, `visibleDago`, `exportArcelor`, `exportAmazon`, `prixUnitArcelorTTC`, `prixUnitAmazonTTC`, `prixTotalAmazonTTC`, `prixUnitGritTTC`, `prixTotalGritTTC`, `offerCountryDestination`, `prixUnitArcelorHT`, `stockArcelorImp`, `baremeQtyArcelor`, `baremePrixArcelor`, `baremePourcentageArcelor`, `conditionnementArcelor`, `typeArticle`, `versionArticle`, `grain`, `alesage`, `perforation`, `Fixation`, `forme`, `couleur`, `diametre`, `densite`, `dureteShoreA`, `Epaisseur`, `liner`, `norme`, `porosite`, `puissance`, `revetement`, `support`, `taille`, `technologie`, `viscosite`, `vitesse`, `mandrin`, `longueurProduitMM`, `longueurRubanM`, `diametreNum`, `largeurNum`, `epaisseurMM`) VALUES (2531, -1, '21200862533', 'ADFIX', 'ADFIX4867', '7000002131', NULL, 114.765, 229.53, 0, 229.53, 'Adhésifs', 'Attache refermable', 'Fixation amovible', NULL, 1, 1, '2', 1, NULL, 0, 'g', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 25, NULL);
0.46 ms (1.75%)	1	UPDATE object_store_Articles SET `oo_id` = ?, `sommeil` = ?, `ean13` = ?, `famille` = ?, `refDago` = ?, `refFournisseur` = ?, `colisage` = ?, `prixAchat` = ?, `prixVente` = ?, `prixTTC` = ?, `prixWebDagoHT` = ?, `catalogue1` = ?, `catalogue2` = ?, `catalogue3` = ?, `catalogue4` = ?, `stockReel` = ?, `stockDisponible` = ?, `stockSuivi` = ?, `nombrePceLotSage` = ?, `conditionnement` = ?, `poidsColisSage` = ?, `uniteSage` = ?, `delaiLivraisonSage` = ?, `visibleGrit` = ?, `visibleDago` = ?, `exportArcelor` = ?, `exportAmazon` = ?, `prixUnitArcelorTTC` = ?, `prixUnitAmazonTTC` = ?, `prixTotalAmazonTTC` = ?, `prixUnitGritTTC` = ?, `prixTotalGritTTC` = ?, `offerCountryDestination` = ?, `prixUnitArcelorHT` = ?, `stockArcelorImp` = ?, `baremeQtyArcelor` = ?, `baremePrixArcelor` = ?, `baremePourcentageArcelor` = ?, `conditionnementArcelor` = ?, `typeArticle` = ?, `versionArticle` = ?, `grain` = ?, `alesage` = ?, `perforation` = ?, `Fixation` = ?, `forme` = ?, `couleur` = ?, `diametre` = ?, `densite` = ?, `dureteShoreA` = ?, `Epaisseur` = ?, `liner` = ?, `norme` = ?, `porosite` = ?, `puissance` = ?, `revetement` = ?, `support` = ?, `taille` = ?, `technologie` = ?, `viscosite` = ?, `vitesse` = ?, `mandrin` = ?, `longueurProduitMM` = ?, `longueurRubanM` = ?, `diametreNum` = ?, `largeurNum` = ?, `epaisseurMM` = ? WHERE `oo_id` = ? Parameters: [`2531 -1 "21200862533" "ADFIX" "ADFIX4867" "7000002131" null 114.765 229.53 0.0 229.53 "Adhésifs" "Attache refermable" "Fixation amovible" null 1.0 1.0 "2" 1 null 0.0 "g" "" null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null null 25.0 null 2531`] View formatted query View runnable query Explain query UPDATE object_store_Articles SET `oo_id` = ?, `sommeil` = ?, `ean13` = ?, `famille` = ?, `refDago` = ?, `refFournisseur` = ?, `colisage` = ?, `prixAchat` = ?, `prixVente` = ?, `prixTTC` = ?, `prixWebDagoHT` = ?, `catalogue1` = ?, `catalogue2` = ?, `catalogue3` = ?, `catalogue4` = ?, `stockReel` = ?, `stockDisponible` = ?, `stockSuivi` = ?, `nombrePceLotSage` = ?, `conditionnement` = ?, `poidsColisSage` = ?, `uniteSage` = ?, `delaiLivraisonSage` = ?, `visibleGrit` = ?, `visibleDago` = ?, `exportArcelor` = ?, `exportAmazon` = ?, `prixUnitArcelorTTC` = ?, `prixUnitAmazonTTC` = ?, `prixTotalAmazonTTC` = ?, `prixUnitGritTTC` = ?, `prixTotalGritTTC` = ?, `offerCountryDestination` = ?, `prixUnitArcelorHT` = ?, `stockArcelorImp` = ?, `baremeQtyArcelor` = ?, `baremePrixArcelor` = ?, `baremePourcentageArcelor` = ?, `conditionnementArcelor` = ?, `typeArticle` = ?, `versionArticle` = ?, `grain` = ?, `alesage` = ?, `perforation` = ?, `Fixation` = ?, `forme` = ?, `couleur` = ?, `diametre` = ?, `densite` = ?, `dureteShoreA` = ?, `Epaisseur` = ?, `liner` = ?, `norme` = ?, `porosite` = ?, `puissance` = ?, `revetement` = ?, `support` = ?, `taille` = ?, `technologie` = ?, `viscosite` = ?, `vitesse` = ?, `mandrin` = ?, `longueurProduitMM` = ?, `longueurRubanM` = ?, `diametreNum` = ?, `largeurNum` = ?, `epaisseurMM` = ? WHERE `oo_id` = ? UPDATE object_store_Articles SET `oo_id` = 2531, `sommeil` = -1, `ean13` = '21200862533', `famille` = 'ADFIX', `refDago` = 'ADFIX4867', `refFournisseur` = '7000002131', `colisage` = NULL, `prixAchat` = 114.765, `prixVente` = 229.53, `prixTTC` = 0, `prixWebDagoHT` = 229.53, `catalogue1` = 'Adhésifs', `catalogue2` = 'Attache refermable', `catalogue3` = 'Fixation amovible', `catalogue4` = NULL, `stockReel` = 1, `stockDisponible` = 1, `stockSuivi` = '2', `nombrePceLotSage` = 1, `conditionnement` = NULL, `poidsColisSage` = 0, `uniteSage` = 'g', `delaiLivraisonSage` = '', `visibleGrit` = NULL, `visibleDago` = NULL, `exportArcelor` = NULL, `exportAmazon` = NULL, `prixUnitArcelorTTC` = NULL, `prixUnitAmazonTTC` = NULL, `prixTotalAmazonTTC` = NULL, `prixUnitGritTTC` = NULL, `prixTotalGritTTC` = NULL, `offerCountryDestination` = NULL, `prixUnitArcelorHT` = NULL, `stockArcelorImp` = NULL, `baremeQtyArcelor` = NULL, `baremePrixArcelor` = NULL, `baremePourcentageArcelor` = NULL, `conditionnementArcelor` = NULL, `typeArticle` = NULL, `versionArticle` = NULL, `grain` = NULL, `alesage` = NULL, `perforation` = NULL, `Fixation` = NULL, `forme` = NULL, `couleur` = NULL, `diametre` = NULL, `densite` = NULL, `dureteShoreA` = NULL, `Epaisseur` = NULL, `liner` = NULL, `norme` = NULL, `porosite` = NULL, `puissance` = NULL, `revetement` = NULL, `support` = NULL, `taille` = NULL, `technologie` = NULL, `viscosite` = NULL, `vitesse` = NULL, `mandrin` = NULL, `longueurProduitMM` = NULL, `longueurRubanM` = NULL, `diametreNum` = NULL, `largeurNum` = 25, `epaisseurMM` = NULL WHERE `oo_id` = 2531;
0.39 ms (1.51%)	1	SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 Parameters: [`"/Products/Articles/ADFIX4867/%"`] View formatted query View runnable query Explain query SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1 SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE '/Products/Articles/ADFIX4867/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;
0.39 ms (1.48%)	2	SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, `key`) as `path` FROM objects WHERE id = ? SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 7;
0.38 ms (1.45%)	1	SELECT userId,cid,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid IN (1,7,6,2531) AND userId IN (4,16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT userId, cid, `list`, `view`, `publish`, `delete`, `rename`, `create`, `settings`, `versions`, `properties`, `save`, `unpublish`, `lEdit`, `lView`, `layouts` FROM users_workspaces_object WHERE cid IN (1, 7, 6, 2531) AND userId IN (4, 16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC LIMIT 1 SELECT userId,cid,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid IN (1,7,6,2531) AND userId IN (4,16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC LIMIT 1 ;
0.35 ms (1.34%)	1	SELECT `src_id` FROM `object_relations_Articles` WHERE (src_id = '2531' AND fieldname not in ('modelAssoManuel','localizedfields') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT `src_id` FROM `object_relations_Articles` WHERE ( src_id = '2531' AND fieldname not in ( 'modelAssoManuel', 'localizedfields' ) AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection" ) LIMIT 1 SELECT `src_id` FROM `object_relations_Articles` WHERE (src_id = '2531' AND fieldname not in ('modelAssoManuel','localizedfields') AND ownertype = 'object' AND ownerType != "localizedfield" AND ownerType != "fieldcollection") LIMIT 1;
0.35 ms (1.32%)	1	SELECT * FROM object_query_Articles WHERE oo_id = ? Parameters: [`2531`] View formatted query View runnable query Explain query SELECT * FROM object_query_Articles WHERE oo_id = ? SELECT * FROM object_query_Articles WHERE oo_id = 2531;
0.33 ms (1.26%)	1	SELECT `publish` FROM users_workspaces_object WHERE cid IN (1,7,6,2531) AND userId IN (4,16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC, `publish` DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT `publish` FROM users_workspaces_object WHERE cid IN (1, 7, 6, 2531) AND userId IN (4, 16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC, `publish` DESC LIMIT 1 SELECT `publish` FROM users_workspaces_object WHERE cid IN (1,7,6,2531) AND userId IN (4,16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC, `publish` DESC LIMIT 1;
0.30 ms (1.16%)	1	SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ? Parameters: [`"object" 2531`] View formatted query View runnable query Explain query SELECT id, targetType, targetId FROM dependencies WHERE sourceType = ? AND sourceId = ? SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 2531;
0.30 ms (1.16%)	1	SELECT userId,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid = 6 AND userId IN (4,16) ORDER BY FIELD(userId, 16) DESC Parameters: [] View formatted query View runnable query Explain query SELECT userId, `list`, `view`, `publish`, `delete`, `rename`, `create`, `settings`, `versions`, `properties`, `save`, `unpublish`, `lEdit`, `lView`, `layouts` FROM users_workspaces_object WHERE cid = 6 AND userId IN (4, 16) ORDER BY FIELD(userId, 16) DESC SELECT userId,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object WHERE cid = 6 AND userId IN (4,16) ORDER BY FIELD(userId, 16) DESC ;
0.29 ms (1.12%)	1	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`2531 "object"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 2531 AND `ctype` = 'object' ;
0.28 ms (1.09%)	1	SELECT `lEdit`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,7,6,2531) AND userId IN (4,16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC, `lEdit` DESC Parameters: [] View formatted query View runnable query Explain query SELECT `lEdit`, cid, cpath FROM users_workspaces_object WHERE cid IN (1, 7, 6, 2531) AND userId IN (4, 16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC, `lEdit` DESC SELECT `lEdit`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,7,6,2531) AND userId IN (4,16) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 16) DESC, `lEdit` DESC;
0.27 ms (1.01%)	1	SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,7,6) AND inheritable = 1) OR cid = ? ) AND ctype='object' Parameters: [`2531`] View formatted query View runnable query Explain query SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( ( cid IN (1, 7, 6) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object' SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ((cid IN (1,7,6) AND inheritable = 1) OR cid = 2531 ) AND ctype='object';
0.26 ms (1.00%)	1	SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' Parameters: [`2531`] View formatted query View runnable query Explain query SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' SELECT MAX(versionCount) FROM versions WHERE cid = 2531 AND ctype = 'object';
0.26 ms (0.98%)	1	SELECT versionCount FROM objects WHERE id = ? FOR UPDATE Parameters: [`2531`] View formatted query View runnable query Explain query SELECT versionCount FROM objects WHERE id = ? FOR UPDATE SELECT versionCount FROM objects WHERE id = 2531 FOR UPDATE;
0.25 ms (0.97%)	1	SELECT * FROM users WHERE `id` = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `id` = ? SELECT * FROM users WHERE `id` = 4;
0.25 ms (0.95%)	1	SELECT name FROM classes WHERE id = ? Parameters: [`"Articles"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'Articles';
0.23 ms (0.88%)	1	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"object_2531\x01tags\x01" "object_properties\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('object_2531tags', 'object_propertiestags');
0.22 ms (0.86%)	1	SELECT id FROM tree_locks WHERE id IN (1,7,6) AND `type`='object' AND locked = 'propagate' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tree_locks WHERE id IN (1, 7, 6) AND `type` = 'object' AND locked = 'propagate' LIMIT 1 SELECT id FROM tree_locks WHERE id IN (1,7,6) AND `type`='object' AND locked = 'propagate' LIMIT 1;
0.20 ms (0.75%)	1	DELETE FROM tree_locks WHERE id = ? AND type = ? Parameters: [`2531 "object"`] View formatted query View runnable query Explain query DELETE FROM tree_locks WHERE id = ? AND type = ? DELETE FROM tree_locks WHERE id = 2531 AND type = 'object';
0.17 ms (0.65%)	1	DELETE FROM properties WHERE cid = ? AND ctype = ? Parameters: [`2531 "object"`] View formatted query View runnable query Explain query DELETE FROM properties WHERE cid = ? AND ctype = ? DELETE FROM properties WHERE cid = 2531 AND ctype = 'object';
0.17 ms (0.64%)	1	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
0.16 ms (0.63%)	1	DELETE FROM schedule_tasks WHERE `cid` = '2531' AND `ctype` = 'object' Parameters: [] View formatted query View runnable query Explain query DELETE FROM schedule_tasks WHERE `cid` = '2531' AND `ctype` = 'object' DELETE FROM schedule_tasks WHERE `cid` = '2531' AND `ctype` = 'object';
0.16 ms (0.59%)	1	SELECT type,classId,className FROM objects WHERE id = ? Parameters: [`2531`] View formatted query View runnable query Explain query SELECT type, classId, className FROM objects WHERE id = ? SELECT type,classId,className FROM objects WHERE id = 2531;
0.09 ms (0.34%)	1	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No mapped entities.

Symfony Profiler

POST https://pim.dagobertindustrie.devsequentiel.net/admin/object/grid-proxy?_dc=1765894940985&classId=Articles&folderId=7&xaction=update

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping