Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

6 Database Queries

3 Different statements

3.78 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.contenu_html AS contenu_html_2, f0_.image AS image_3, f0_.fichier_pdf AS fichier_pdf_4, f0_.fichier_html AS fichier_html_5, f0_.is_actif AS is_actif_6, f0_.lft AS lft_7, f0_.lvl AS lvl_8, f0_.rgt AS rgt_9, f0_.date_modification AS date_modification_10, f0_.icone AS icone_11, f0_.is_stock_visible_fo AS is_stock_visible_fo_12, f0_.icone_rose AS icone_rose_13, f0_.parent_id AS parent_id_14, f0_.famille_erp_id AS famille_erp_id_15 FROM famille_article f0_ WHERE f0_.id IN (?) ORDER BY f0_.id ASC LIMIT 1000
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ?
SELECT count(f0_.id) AS sclr_0 FROM famille_article f0_ WHERE f0_.id IN (?)

#▲	Time	Info
1	1.94 ms	SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.contenu_html AS contenu_html_2, f0_.image AS image_3, f0_.fichier_pdf AS fichier_pdf_4, f0_.fichier_html AS fichier_html_5, f0_.is_actif AS is_actif_6, f0_.lft AS lft_7, f0_.lvl AS lvl_8, f0_.rgt AS rgt_9, f0_.date_modification AS date_modification_10, f0_.icone AS icone_11, f0_.is_stock_visible_fo AS is_stock_visible_fo_12, f0_.icone_rose AS icone_rose_13, f0_.parent_id AS parent_id_14, f0_.famille_erp_id AS famille_erp_id_15 FROM famille_article f0_ WHERE f0_.id IN (?) ORDER BY f0_.id ASC LIMIT 1000 Parameters: [[ "1" "2" "4" "1012" "12" "7" "84" "1026" "82" "86" "78" "1038" "79" "77" "67" "68" "827" "66" "69" "71" "70" "63" "64" "62" "65" "89" "87" "85" "81" "83" "831" "88" "1029" "76" "74" "75" "80" "60" "61" "1024" "1040" "1042" "1044" "1046" "101" "106" "103" "135" "141" "129" "130" "133" "128" "887" "137" "140" "139" "132" "131" "138" "142" "134" "117" "111" "108" "110" "112" "113" "107" "114" "115" "116" "687" "688" "686" "684" "679" "683" "682" "680" "681" "578" "575" "601" "599" "600" "598" "603" "602" "613" "1088" "1087" "38" "37" "35" "44" "39" "42" "34" "917" "33" "48" "45" "980" "1017" "973" "43" "36" "1019" "41" "1054" "195" "191" "196" "190" "193" "194" "192" "1053" "184" "183" "182" "186" "185" "180" "175" "169" "174" "176" "173" "1097" "170" "249" "248" "247" "1064" "246" "243" "955" "211" "216" "210" "958" "219" "953" "957" "1056" "217" "214" "213" "218" "956" "1062" "212" "954" "240" "239" "241" "242" "238" "510" "509" "511" "508" "1050" "1051" "1052" "484" "547" "546" "985" "550" "1100" "1101" "1102" "1103" "1104" "1105" "1106" "1107" "1108" "1109" "1110" "1111" "1112" "1089" "421" "422" "420" "423" "424" "404" "407" "1071" "408" "405" "406" "393" "387" "391" "392" "389" "388" "402" "401" "400" "399" "397" "396" "395" "394" "872" "336" "338" "339" "335" "333" "334" "337" "315" "313" "314" "309" "310" "312" "835" "311" "317" "321" "320" "319" "318" "322" "324" "323" "325" "326" "327" "328" "331" "329" "330" "332" "374" "372" "373" "371" "347" "346" "341" "855" "852" "344" "345" "343" "340" "342" "351" "350" "349" "354" "356" "353" "355" "348" "352" "360" "359" "357" "358" "1070" "362" "363" "368" "367" "365" "364" "369" "366" "23" "41" "3" "535" "536" "537" "220" "221" "961" "225" "539" "540" "541" "222" "223" "756" "754" "755" "759" "758" "760" "752" "753" "751" "750" "762" "883" "748" "746" "749" "747" "745" "881" "882" "707" "705" "706" "708" "736" "737" "729" "730" "731" "732" "1089" "742" "744" "741" "146" "743" "738" "739" "713" "711" "710" "709" "712" "122" "700" "704" "701" "699" "703" "702" "421" "422" "420" "423" "424" "718" "719" "722" "724" "727" "721" "723" "728" "726" "714" "715" "717" "716" "151" "154" "152" "27" "162" "26" "159" "160" "153" "156" "30" "163" "164" "165" "1181" ]] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.contenu_html AS contenu_html_2, f0_.image AS image_3, f0_.fichier_pdf AS fichier_pdf_4, f0_.fichier_html AS fichier_html_5, f0_.is_actif AS is_actif_6, f0_.lft AS lft_7, f0_.lvl AS lvl_8, f0_.rgt AS rgt_9, f0_.date_modification AS date_modification_10, f0_.icone AS icone_11, f0_.is_stock_visible_fo AS is_stock_visible_fo_12, f0_.icone_rose AS icone_rose_13, f0_.parent_id AS parent_id_14, f0_.famille_erp_id AS famille_erp_id_15 FROM famille_article f0_ WHERE f0_.id IN (?) ORDER BY f0_.id ASC LIMIT 1000 SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.contenu_html AS contenu_html_2, f0_.image AS image_3, f0_.fichier_pdf AS fichier_pdf_4, f0_.fichier_html AS fichier_html_5, f0_.is_actif AS is_actif_6, f0_.lft AS lft_7, f0_.lvl AS lvl_8, f0_.rgt AS rgt_9, f0_.date_modification AS date_modification_10, f0_.icone AS icone_11, f0_.is_stock_visible_fo AS is_stock_visible_fo_12, f0_.icone_rose AS icone_rose_13, f0_.parent_id AS parent_id_14, f0_.famille_erp_id AS famille_erp_id_15 FROM famille_article f0_ WHERE f0_.id IN ('1', '2', '4', '1012', '12', '7', '84', '1026', '82', '86', '78', '1038', '79', '77', '67', '68', '827', '66', '69', '71', '70', '63', '64', '62', '65', '89', '87', '85', '81', '83', '831', '88', '1029', '76', '74', '75', '80', '60', '61', '1024', '1040', '1042', '1044', '1046', '101', '106', '103', '135', '141', '129', '130', '133', '128', '887', '137', '140', '139', '132', '131', '138', '142', '134', '117', '111', '108', '110', '112', '113', '107', '114', '115', '116', '687', '688', '686', '684', '679', '683', '682', '680', '681', '578', '575', '601', '599', '600', '598', '603', '602', '613', '1088', '1087', '38', '37', '35', '44', '39', '42', '34', '917', '33', '48', '45', '980', '1017', '973', '43', '36', '1019', '41', '1054', '195', '191', '196', '190', '193', '194', '192', '1053', '184', '183', '182', '186', '185', '180', '175', '169', '174', '176', '173', '1097', '170', '249', '248', '247', '1064', '246', '243', '955', '211', '216', '210', '958', '219', '953', '957', '1056', '217', '214', '213', '218', '956', '1062', '212', '954', '240', '239', '241', '242', '238', '510', '509', '511', '508', '1050', '1051', '1052', '484', '547', '546', '985', '550', '1100', '1101', '1102', '1103', '1104', '1105', '1106', '1107', '1108', '1109', '1110', '1111', '1112', '1089', '421', '422', '420', '423', '424', '404', '407', '1071', '408', '405', '406', '393', '387', '391', '392', '389', '388', '402', '401', '400', '399', '397', '396', '395', '394', '872', '336', '338', '339', '335', '333', '334', '337', '315', '313', '314', '309', '310', '312', '835', '311', '317', '321', '320', '319', '318', '322', '324', '323', '325', '326', '327', '328', '331', '329', '330', '332', '374', '372', '373', '371', '347', '346', '341', '855', '852', '344', '345', '343', '340', '342', '351', '350', '349', '354', '356', '353', '355', '348', '352', '360', '359', '357', '358', '1070', '362', '363', '368', '367', '365', '364', '369', '366', '23', '41', '3', '535', '536', '537', '220', '221', '961', '225', '539', '540', '541', '222', '223', '756', '754', '755', '759', '758', '760', '752', '753', '751', '750', '762', '883', '748', '746', '749', '747', '745', '881', '882', '707', '705', '706', '708', '736', '737', '729', '730', '731', '732', '1089', '742', '744', '741', '146', '743', '738', '739', '713', '711', '710', '709', '712', '122', '700', '704', '701', '699', '703', '702', '421', '422', '420', '423', '424', '718', '719', '722', '724', '727', '721', '723', '728', '726', '714', '715', '717', '716', '151', '154', '152', '27', '162', '26', '159', '160', '153', '156', '30', '163', '164', '165', '1181') ORDER BY f0_.id ASC LIMIT 1000;
2	0.23 ms	SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = 5;
3	0.16 ms	SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = 2;
4	0.15 ms	SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = 6;
5	0.14 ms	SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = 3;
6	1.17 ms	SELECT count(f0_.id) AS sclr_0 FROM famille_article f0_ WHERE f0_.id IN (?) Parameters: [[ "1" "2" "4" "1012" "12" "7" "84" "1026" "82" "86" "78" "1038" "79" "77" "67" "68" "827" "66" "69" "71" "70" "63" "64" "62" "65" "89" "87" "85" "81" "83" "831" "88" "1029" "76" "74" "75" "80" "60" "61" "1024" "1040" "1042" "1044" "1046" "101" "106" "103" "135" "141" "129" "130" "133" "128" "887" "137" "140" "139" "132" "131" "138" "142" "134" "117" "111" "108" "110" "112" "113" "107" "114" "115" "116" "687" "688" "686" "684" "679" "683" "682" "680" "681" "578" "575" "601" "599" "600" "598" "603" "602" "613" "1088" "1087" "38" "37" "35" "44" "39" "42" "34" "917" "33" "48" "45" "980" "1017" "973" "43" "36" "1019" "41" "1054" "195" "191" "196" "190" "193" "194" "192" "1053" "184" "183" "182" "186" "185" "180" "175" "169" "174" "176" "173" "1097" "170" "249" "248" "247" "1064" "246" "243" "955" "211" "216" "210" "958" "219" "953" "957" "1056" "217" "214" "213" "218" "956" "1062" "212" "954" "240" "239" "241" "242" "238" "510" "509" "511" "508" "1050" "1051" "1052" "484" "547" "546" "985" "550" "1100" "1101" "1102" "1103" "1104" "1105" "1106" "1107" "1108" "1109" "1110" "1111" "1112" "1089" "421" "422" "420" "423" "424" "404" "407" "1071" "408" "405" "406" "393" "387" "391" "392" "389" "388" "402" "401" "400" "399" "397" "396" "395" "394" "872" "336" "338" "339" "335" "333" "334" "337" "315" "313" "314" "309" "310" "312" "835" "311" "317" "321" "320" "319" "318" "322" "324" "323" "325" "326" "327" "328" "331" "329" "330" "332" "374" "372" "373" "371" "347" "346" "341" "855" "852" "344" "345" "343" "340" "342" "351" "350" "349" "354" "356" "353" "355" "348" "352" "360" "359" "357" "358" "1070" "362" "363" "368" "367" "365" "364" "369" "366" "23" "41" "3" "535" "536" "537" "220" "221" "961" "225" "539" "540" "541" "222" "223" "756" "754" "755" "759" "758" "760" "752" "753" "751" "750" "762" "883" "748" "746" "749" "747" "745" "881" "882" "707" "705" "706" "708" "736" "737" "729" "730" "731" "732" "1089" "742" "744" "741" "146" "743" "738" "739" "713" "711" "710" "709" "712" "122" "700" "704" "701" "699" "703" "702" "421" "422" "420" "423" "424" "718" "719" "722" "724" "727" "721" "723" "728" "726" "714" "715" "717" "716" "151" "154" "152" "27" "162" "26" "159" "160" "153" "156" "30" "163" "164" "165" "1181" ]] View formatted query View runnable query Explain query SELECT count(f0_.id) AS sclr_0 FROM famille_article f0_ WHERE f0_.id IN (?) SELECT count(f0_.id) AS sclr_0 FROM famille_article f0_ WHERE f0_.id IN ('1', '2', '4', '1012', '12', '7', '84', '1026', '82', '86', '78', '1038', '79', '77', '67', '68', '827', '66', '69', '71', '70', '63', '64', '62', '65', '89', '87', '85', '81', '83', '831', '88', '1029', '76', '74', '75', '80', '60', '61', '1024', '1040', '1042', '1044', '1046', '101', '106', '103', '135', '141', '129', '130', '133', '128', '887', '137', '140', '139', '132', '131', '138', '142', '134', '117', '111', '108', '110', '112', '113', '107', '114', '115', '116', '687', '688', '686', '684', '679', '683', '682', '680', '681', '578', '575', '601', '599', '600', '598', '603', '602', '613', '1088', '1087', '38', '37', '35', '44', '39', '42', '34', '917', '33', '48', '45', '980', '1017', '973', '43', '36', '1019', '41', '1054', '195', '191', '196', '190', '193', '194', '192', '1053', '184', '183', '182', '186', '185', '180', '175', '169', '174', '176', '173', '1097', '170', '249', '248', '247', '1064', '246', '243', '955', '211', '216', '210', '958', '219', '953', '957', '1056', '217', '214', '213', '218', '956', '1062', '212', '954', '240', '239', '241', '242', '238', '510', '509', '511', '508', '1050', '1051', '1052', '484', '547', '546', '985', '550', '1100', '1101', '1102', '1103', '1104', '1105', '1106', '1107', '1108', '1109', '1110', '1111', '1112', '1089', '421', '422', '420', '423', '424', '404', '407', '1071', '408', '405', '406', '393', '387', '391', '392', '389', '388', '402', '401', '400', '399', '397', '396', '395', '394', '872', '336', '338', '339', '335', '333', '334', '337', '315', '313', '314', '309', '310', '312', '835', '311', '317', '321', '320', '319', '318', '322', '324', '323', '325', '326', '327', '328', '331', '329', '330', '332', '374', '372', '373', '371', '347', '346', '341', '855', '852', '344', '345', '343', '340', '342', '351', '350', '349', '354', '356', '353', '355', '348', '352', '360', '359', '357', '358', '1070', '362', '363', '368', '367', '365', '364', '369', '366', '23', '41', '3', '535', '536', '537', '220', '221', '961', '225', '539', '540', '541', '222', '223', '756', '754', '755', '759', '758', '760', '752', '753', '751', '750', '762', '883', '748', '746', '749', '747', '745', '881', '882', '707', '705', '706', '708', '736', '737', '729', '730', '731', '732', '1089', '742', '744', '741', '146', '743', '738', '739', '713', '711', '710', '709', '712', '122', '700', '704', '701', '699', '703', '702', '421', '422', '420', '423', '424', '718', '719', '722', '724', '727', '721', '723', '728', '726', '714', '715', '717', '716', '151', '154', '152', '27', '162', '26', '159', '160', '153', '156', '30', '163', '164', '165', '1181');

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\Famille	No errors.
App\Entity\FamilleErp	No errors.
App\Entity\Produit	No errors.
App\Entity\ClientCatalogueExclu	No errors.
App\Entity\ClientRemiseFamille	No errors.
App\Entity\FamilleEvenement	No errors.
App\Entity\DevisDemandeAchat	No errors.
App\Entity\Actualite	No errors.
App\Entity\ClientEvenement	No errors.
App\Entity\Evenement	No errors.
App\Entity\ClientProfilEvenement	No errors.
App\Entity\Fournisseur	No errors.
App\Entity\OffresProchilab	No errors.
App\Entity\Client	No errors.
App\Entity\ProduitLot	No errors.
App\Entity\TauxTva	No errors.
App\Entity\ClientAdresse	No errors.
App\Entity\ConfigurationGenerale	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\EvenementProduit	No errors.
App\Entity\CategorisationArticleValeur	No errors.
App\Entity\Ticket	No errors.
App\Entity\ContenuSpecifique	No errors.

Symfony Profiler

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping