Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

6.84 ms Query time

1 Invalid entities

Queries

Group similar statements

polymorph connection

#▲	Time	Info
1	5.87 ms	SELECT e0_.ID_COMMANDE AS ID_COMMANDE_0, e0_.ID_TERMINAL AS ID_TERMINAL_1, e0_.ID_TRANSACTION AS ID_TRANSACTION_2, e0_.FORMATENTETETICKETTRANSAC AS FORMATENTETETICKETTRANSAC_3, e0_.DATELOCALEDELATRANSAC AS DATELOCALEDELATRANSAC_4, e0_.HEURELOCALEDELATRANSAC AS HEURELOCALEDELATRANSAC_5, e0_.ENSEIGNEACCEPT AS ENSEIGNEACCEPT_6, e0_.TYPEDETRANSAC AS TYPEDETRANSAC_7, e0_.NUMCONTRATOUIDACCEPT AS NUMCONTRATOUIDACCEPT_8, e0_.NUMSIRET AS NUMSIRET_9, e0_.TYPEACTIVITECOMMERCIALE AS TYPEACTIVITECOMMERCIALE_10, e0_.TYPEDEPAIEMENT AS TYPEDEPAIEMENT_11, e0_.TYPEDESITE AS TYPEDESITE_12, e0_.NUMCOMPTEPRIMAIREUNPORTEUR AS NUMCOMPTEPRIMAIREUNPORTEUR_13, e0_.TYPEAPPLICATIFDUSYSACCEPT AS TYPEAPPLICATIFDUSYSACCEPT_14, e0_.DATEDEFINDEVALIDUNEAPPCARTE AS DATEDEFINDEVALIDUNEAPPCARTE_15, e0_.CODESERVICE AS CODESERVICE_16, e0_.CRYPTOGRAMME AS CRYPTOGRAMME_17, e0_.CODENUMERIQUEDELADEV AS CODENUMERIQUEDELADEV_18, e0_.NUMLOGIQUEDUSYSACCEPT AS NUMLOGIQUEDUSYSACCEPT_19, e0_.NUMDETRANSACGENPARLESYSCCEPT AS NUMDETRANSACGENPARLESYSCCEPT_20, e0_.NUMDEREMISE AS NUMDEREMISE_21, e0_.MODEDELECTUREDUNUMEROPORTEUR AS MODEDELECTUREDUNUMEROPORTEUR_22, e0_.NUMAUTORISATIONUNETRANSAC AS NUMAUTORISATIONUNETRANSAC_23, e0_.CODEFORCAGE AS CODEFORCAGE_24, e0_.MONTANTDELATRANSAC AS MONTANTDELATRANSAC_25, e0_.CODEALPHADELADEV AS CODEALPHADELADEV_26, e0_.PARTIEFRACDELADEV AS PARTIEFRACDELADEV_27, e0_.MONTANTUNETRANSACENCONTREVAL AS MONTANTUNETRANSACENCONTREVAL_28, e0_.CODEALPHADELADEVENCONTREVAL AS CODEALPHADELADEVENCONTREVAL_29, e0_.PARTIEFRACDELADEVENCONTREVAL AS PARTIEFRACDELADEVENCONTREVAL_30, e0_.MONTANTESTIME AS MONTANTESTIME_31, e0_.FORMATPIEDDETICKETTRANSAC AS FORMATPIEDDETICKETTRANSAC_32, e0_.AID AS AID_33, e0_.LABELL AS LABELL_34, e0_.ID_TRANSACTION AS ID_TRANSACTION_35, e0_.ID_COMMANDE AS ID_COMMANDE_36, e0_.ID_TERMINAL AS ID_TERMINAL_37 FROM enregistrement_ok e0_ WHERE e0_.ID_COMMANDE = ? AND e0_.ID_TERMINAL = ? AND e0_.ID_TRANSACTION = ? Parameters: [`"9854" "45" "9825"`] View formatted query View runnable query Explain query SELECT e0_.ID_COMMANDE AS ID_COMMANDE_0, e0_.ID_TERMINAL AS ID_TERMINAL_1, e0_.ID_TRANSACTION AS ID_TRANSACTION_2, e0_.FORMATENTETETICKETTRANSAC AS FORMATENTETETICKETTRANSAC_3, e0_.DATELOCALEDELATRANSAC AS DATELOCALEDELATRANSAC_4, e0_.HEURELOCALEDELATRANSAC AS HEURELOCALEDELATRANSAC_5, e0_.ENSEIGNEACCEPT AS ENSEIGNEACCEPT_6, e0_.TYPEDETRANSAC AS TYPEDETRANSAC_7, e0_.NUMCONTRATOUIDACCEPT AS NUMCONTRATOUIDACCEPT_8, e0_.NUMSIRET AS NUMSIRET_9, e0_.TYPEACTIVITECOMMERCIALE AS TYPEACTIVITECOMMERCIALE_10, e0_.TYPEDEPAIEMENT AS TYPEDEPAIEMENT_11, e0_.TYPEDESITE AS TYPEDESITE_12, e0_.NUMCOMPTEPRIMAIREUNPORTEUR AS NUMCOMPTEPRIMAIREUNPORTEUR_13, e0_.TYPEAPPLICATIFDUSYSACCEPT AS TYPEAPPLICATIFDUSYSACCEPT_14, e0_.DATEDEFINDEVALIDUNEAPPCARTE AS DATEDEFINDEVALIDUNEAPPCARTE_15, e0_.CODESERVICE AS CODESERVICE_16, e0_.CRYPTOGRAMME AS CRYPTOGRAMME_17, e0_.CODENUMERIQUEDELADEV AS CODENUMERIQUEDELADEV_18, e0_.NUMLOGIQUEDUSYSACCEPT AS NUMLOGIQUEDUSYSACCEPT_19, e0_.NUMDETRANSACGENPARLESYSCCEPT AS NUMDETRANSACGENPARLESYSCCEPT_20, e0_.NUMDEREMISE AS NUMDEREMISE_21, e0_.MODEDELECTUREDUNUMEROPORTEUR AS MODEDELECTUREDUNUMEROPORTEUR_22, e0_.NUMAUTORISATIONUNETRANSAC AS NUMAUTORISATIONUNETRANSAC_23, e0_.CODEFORCAGE AS CODEFORCAGE_24, e0_.MONTANTDELATRANSAC AS MONTANTDELATRANSAC_25, e0_.CODEALPHADELADEV AS CODEALPHADELADEV_26, e0_.PARTIEFRACDELADEV AS PARTIEFRACDELADEV_27, e0_.MONTANTUNETRANSACENCONTREVAL AS MONTANTUNETRANSACENCONTREVAL_28, e0_.CODEALPHADELADEVENCONTREVAL AS CODEALPHADELADEVENCONTREVAL_29, e0_.PARTIEFRACDELADEVENCONTREVAL AS PARTIEFRACDELADEVENCONTREVAL_30, e0_.MONTANTESTIME AS MONTANTESTIME_31, e0_.FORMATPIEDDETICKETTRANSAC AS FORMATPIEDDETICKETTRANSAC_32, e0_.AID AS AID_33, e0_.LABELL AS LABELL_34, e0_.ID_TRANSACTION AS ID_TRANSACTION_35, e0_.ID_COMMANDE AS ID_COMMANDE_36, e0_.ID_TERMINAL AS ID_TERMINAL_37 FROM enregistrement_ok e0_ WHERE e0_.ID_COMMANDE = ? AND e0_.ID_TERMINAL = ? AND e0_.ID_TRANSACTION = ? SELECT e0_.ID_COMMANDE AS ID_COMMANDE_0, e0_.ID_TERMINAL AS ID_TERMINAL_1, e0_.ID_TRANSACTION AS ID_TRANSACTION_2, e0_.FORMATENTETETICKETTRANSAC AS FORMATENTETETICKETTRANSAC_3, e0_.DATELOCALEDELATRANSAC AS DATELOCALEDELATRANSAC_4, e0_.HEURELOCALEDELATRANSAC AS HEURELOCALEDELATRANSAC_5, e0_.ENSEIGNEACCEPT AS ENSEIGNEACCEPT_6, e0_.TYPEDETRANSAC AS TYPEDETRANSAC_7, e0_.NUMCONTRATOUIDACCEPT AS NUMCONTRATOUIDACCEPT_8, e0_.NUMSIRET AS NUMSIRET_9, e0_.TYPEACTIVITECOMMERCIALE AS TYPEACTIVITECOMMERCIALE_10, e0_.TYPEDEPAIEMENT AS TYPEDEPAIEMENT_11, e0_.TYPEDESITE AS TYPEDESITE_12, e0_.NUMCOMPTEPRIMAIREUNPORTEUR AS NUMCOMPTEPRIMAIREUNPORTEUR_13, e0_.TYPEAPPLICATIFDUSYSACCEPT AS TYPEAPPLICATIFDUSYSACCEPT_14, e0_.DATEDEFINDEVALIDUNEAPPCARTE AS DATEDEFINDEVALIDUNEAPPCARTE_15, e0_.CODESERVICE AS CODESERVICE_16, e0_.CRYPTOGRAMME AS CRYPTOGRAMME_17, e0_.CODENUMERIQUEDELADEV AS CODENUMERIQUEDELADEV_18, e0_.NUMLOGIQUEDUSYSACCEPT AS NUMLOGIQUEDUSYSACCEPT_19, e0_.NUMDETRANSACGENPARLESYSCCEPT AS NUMDETRANSACGENPARLESYSCCEPT_20, e0_.NUMDEREMISE AS NUMDEREMISE_21, e0_.MODEDELECTUREDUNUMEROPORTEUR AS MODEDELECTUREDUNUMEROPORTEUR_22, e0_.NUMAUTORISATIONUNETRANSAC AS NUMAUTORISATIONUNETRANSAC_23, e0_.CODEFORCAGE AS CODEFORCAGE_24, e0_.MONTANTDELATRANSAC AS MONTANTDELATRANSAC_25, e0_.CODEALPHADELADEV AS CODEALPHADELADEV_26, e0_.PARTIEFRACDELADEV AS PARTIEFRACDELADEV_27, e0_.MONTANTUNETRANSACENCONTREVAL AS MONTANTUNETRANSACENCONTREVAL_28, e0_.CODEALPHADELADEVENCONTREVAL AS CODEALPHADELADEVENCONTREVAL_29, e0_.PARTIEFRACDELADEVENCONTREVAL AS PARTIEFRACDELADEVENCONTREVAL_30, e0_.MONTANTESTIME AS MONTANTESTIME_31, e0_.FORMATPIEDDETICKETTRANSAC AS FORMATPIEDDETICKETTRANSAC_32, e0_.AID AS AID_33, e0_.LABELL AS LABELL_34, e0_.ID_TRANSACTION AS ID_TRANSACTION_35, e0_.ID_COMMANDE AS ID_COMMANDE_36, e0_.ID_TERMINAL AS ID_TERMINAL_37 FROM enregistrement_ok e0_ WHERE e0_.ID_COMMANDE = '9854' AND e0_.ID_TERMINAL = '45' AND e0_.ID_TRANSACTION = '9825';
2	0.98 ms	INSERT INTO enregistrement_ok(ID_COMMANDE,ID_TERMINAL, ID_TRANSACTION, FORMATENTETETICKETTRANSAC, DATELOCALEDELATRANSAC, HEURELOCALEDELATRANSAC, ENSEIGNEACCEPT, TYPEDETRANSAC, NUMCONTRATOUIDACCEPT, NUMSIRET, TYPEACTIVITECOMMERCIALE, TYPEDEPAIEMENT, TYPEDESITE, NUMCOMPTEPRIMAIREUNPORTEUR, TYPEAPPLICATIFDUSYSACCEPT,DATEDEFINDEVALIDUNEAPPCARTE, CODESERVICE, CRYPTOGRAMME, CODENUMERIQUEDELADEV, NUMLOGIQUEDUSYSACCEPT, NUMDETRANSACGENPARLESYSCCEPT, NUMDEREMISE, MODEDELECTUREDUNUMEROPORTEUR, NUMAUTORISATIONUNETRANSAC, CODEFORCAGE, MONTANTDELATRANSAC, CODEALPHADELADEV, PARTIEFRACDELADEV, MONTANTUNETRANSACENCONTREVAL, CODEALPHADELADEVENCONTREVAL, PARTIEFRACDELADEVENCONTREVAL, MONTANTESTIME, FORMATPIEDDETICKETTRANSAC, AID, LABELL) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?) Parameters: [1 => "9854" 2 => "45" 3 => "9825" 4 => "CREDIT AGRICOLE CENTRE LOIRE" 5 => "190425" 6 => "184058" 7 => "CAMPING-CARS 85JARD SUR MER" 8 => "01" 9 => "2346977" 10 => "21850114600011" 11 => "7523" 12 => "46" 13 => "" 14 => "############7949" 15 => "2046" 16 => "261231" 17 => "" 18 => "A3C40FB284A4B7E7" 19 => "978" 20 => "001" 21 => "000003" 22 => "000117" 23 => "C" 24 => "952485" 25 => "@" 26 => "00001132" 27 => "EUR" 28 => "2" 29 => "00007425" 30 => "FRF" 31 => "8" 32 => "00001132" 33 => "MERCI AU REVOIR 25092353" 34 => "A0000000041010" 35 => "MASTERC DEBIT"] View formatted query View runnable query Explain query INSERT INTO enregistrement_ok( ID_COMMANDE, ID_TERMINAL, ID_TRANSACTION, FORMATENTETETICKETTRANSAC, DATELOCALEDELATRANSAC, HEURELOCALEDELATRANSAC, ENSEIGNEACCEPT, TYPEDETRANSAC, NUMCONTRATOUIDACCEPT, NUMSIRET, TYPEACTIVITECOMMERCIALE, TYPEDEPAIEMENT, TYPEDESITE, NUMCOMPTEPRIMAIREUNPORTEUR, TYPEAPPLICATIFDUSYSACCEPT, DATEDEFINDEVALIDUNEAPPCARTE, CODESERVICE, CRYPTOGRAMME, CODENUMERIQUEDELADEV, NUMLOGIQUEDUSYSACCEPT, NUMDETRANSACGENPARLESYSCCEPT, NUMDEREMISE, MODEDELECTUREDUNUMEROPORTEUR, NUMAUTORISATIONUNETRANSAC, CODEFORCAGE, MONTANTDELATRANSAC, CODEALPHADELADEV, PARTIEFRACDELADEV, MONTANTUNETRANSACENCONTREVAL, CODEALPHADELADEVENCONTREVAL, PARTIEFRACDELADEVENCONTREVAL, MONTANTESTIME, FORMATPIEDDETICKETTRANSAC, AID, LABELL ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO enregistrement_ok(ID_COMMANDE,ID_TERMINAL, ID_TRANSACTION, FORMATENTETETICKETTRANSAC, DATELOCALEDELATRANSAC, HEURELOCALEDELATRANSAC, ENSEIGNEACCEPT, TYPEDETRANSAC, NUMCONTRATOUIDACCEPT, NUMSIRET, TYPEACTIVITECOMMERCIALE, TYPEDEPAIEMENT, TYPEDESITE, NUMCOMPTEPRIMAIREUNPORTEUR, TYPEAPPLICATIFDUSYSACCEPT,DATEDEFINDEVALIDUNEAPPCARTE, CODESERVICE, CRYPTOGRAMME, CODENUMERIQUEDELADEV, NUMLOGIQUEDUSYSACCEPT, NUMDETRANSACGENPARLESYSCCEPT, NUMDEREMISE, MODEDELECTUREDUNUMEROPORTEUR, NUMAUTORISATIONUNETRANSAC, CODEFORCAGE, MONTANTDELATRANSAC, CODEALPHADELADEV, PARTIEFRACDELADEV, MONTANTUNETRANSACENCONTREVAL, CODEALPHADELADEVENCONTREVAL, PARTIEFRACDELADEVENCONTREVAL, MONTANTESTIME, FORMATPIEDDETICKETTRANSAC, AID, LABELL) VALUES ('9854', '45', '9825', 'CREDIT AGRICOLE CENTRE LOIRE', '190425', '184058', 'CAMPING-CARS 85JARD SUR MER', '01', '2346977', '21850114600011', '7523', '46', '', '############7949','2046', '261231', '', 'A3C40FB284A4B7E7', '978', '001', '000003', '000117' , 'C', '952485', '@', '00001132', 'EUR', '2','00007425', 'FRF', '8', '00001132', 'MERCI AU REVOIR 25092353', 'A0000000041010', 'MASTERC DEBIT');

#▲

Time

Info

5.87 ms

SELECT e0_.ID_COMMANDE AS ID_COMMANDE_0, e0_.ID_TERMINAL AS ID_TERMINAL_1, e0_.ID_TRANSACTION AS ID_TRANSACTION_2, e0_.FORMATENTETETICKETTRANSAC AS FORMATENTETETICKETTRANSAC_3, e0_.DATELOCALEDELATRANSAC AS DATELOCALEDELATRANSAC_4, e0_.HEURELOCALEDELATRANSAC AS HEURELOCALEDELATRANSAC_5, e0_.ENSEIGNEACCEPT AS ENSEIGNEACCEPT_6, e0_.TYPEDETRANSAC AS TYPEDETRANSAC_7, e0_.NUMCONTRATOUIDACCEPT AS NUMCONTRATOUIDACCEPT_8, e0_.NUMSIRET AS NUMSIRET_9, e0_.TYPEACTIVITECOMMERCIALE AS TYPEACTIVITECOMMERCIALE_10, e0_.TYPEDEPAIEMENT AS TYPEDEPAIEMENT_11, e0_.TYPEDESITE AS TYPEDESITE_12, e0_.NUMCOMPTEPRIMAIREUNPORTEUR AS NUMCOMPTEPRIMAIREUNPORTEUR_13, e0_.TYPEAPPLICATIFDUSYSACCEPT AS TYPEAPPLICATIFDUSYSACCEPT_14, e0_.DATEDEFINDEVALIDUNEAPPCARTE AS DATEDEFINDEVALIDUNEAPPCARTE_15, e0_.CODESERVICE AS CODESERVICE_16, e0_.CRYPTOGRAMME AS CRYPTOGRAMME_17, e0_.CODENUMERIQUEDELADEV AS CODENUMERIQUEDELADEV_18, e0_.NUMLOGIQUEDUSYSACCEPT AS NUMLOGIQUEDUSYSACCEPT_19, e0_.NUMDETRANSACGENPARLESYSCCEPT AS NUMDETRANSACGENPARLESYSCCEPT_20, e0_.NUMDEREMISE AS NUMDEREMISE_21, e0_.MODEDELECTUREDUNUMEROPORTEUR AS MODEDELECTUREDUNUMEROPORTEUR_22, e0_.NUMAUTORISATIONUNETRANSAC AS NUMAUTORISATIONUNETRANSAC_23, e0_.CODEFORCAGE AS CODEFORCAGE_24, e0_.MONTANTDELATRANSAC AS MONTANTDELATRANSAC_25, e0_.CODEALPHADELADEV AS CODEALPHADELADEV_26, e0_.PARTIEFRACDELADEV AS PARTIEFRACDELADEV_27, e0_.MONTANTUNETRANSACENCONTREVAL AS MONTANTUNETRANSACENCONTREVAL_28, e0_.CODEALPHADELADEVENCONTREVAL AS CODEALPHADELADEVENCONTREVAL_29, e0_.PARTIEFRACDELADEVENCONTREVAL AS PARTIEFRACDELADEVENCONTREVAL_30, e0_.MONTANTESTIME AS MONTANTESTIME_31, e0_.FORMATPIEDDETICKETTRANSAC AS FORMATPIEDDETICKETTRANSAC_32, e0_.AID AS AID_33, e0_.LABELL AS LABELL_34, e0_.ID_TRANSACTION AS ID_TRANSACTION_35, e0_.ID_COMMANDE AS ID_COMMANDE_36, e0_.ID_TERMINAL AS ID_TERMINAL_37 FROM enregistrement_ok e0_ WHERE e0_.ID_COMMANDE = ? AND e0_.ID_TERMINAL = ? AND e0_.ID_TRANSACTION = ?

Parameters:

[
  "9854"
  "45"
  "9825"
]

View formatted query View runnable query Explain query

SELECT
  e0_.ID_COMMANDE AS ID_COMMANDE_0,
  e0_.ID_TERMINAL AS ID_TERMINAL_1,
  e0_.ID_TRANSACTION AS ID_TRANSACTION_2,
  e0_.FORMATENTETETICKETTRANSAC AS FORMATENTETETICKETTRANSAC_3,
  e0_.DATELOCALEDELATRANSAC AS DATELOCALEDELATRANSAC_4,
  e0_.HEURELOCALEDELATRANSAC AS HEURELOCALEDELATRANSAC_5,
  e0_.ENSEIGNEACCEPT AS ENSEIGNEACCEPT_6,
  e0_.TYPEDETRANSAC AS TYPEDETRANSAC_7,
  e0_.NUMCONTRATOUIDACCEPT AS NUMCONTRATOUIDACCEPT_8,
  e0_.NUMSIRET AS NUMSIRET_9,
  e0_.TYPEACTIVITECOMMERCIALE AS TYPEACTIVITECOMMERCIALE_10,
  e0_.TYPEDEPAIEMENT AS TYPEDEPAIEMENT_11,
  e0_.TYPEDESITE AS TYPEDESITE_12,
  e0_.NUMCOMPTEPRIMAIREUNPORTEUR AS NUMCOMPTEPRIMAIREUNPORTEUR_13,
  e0_.TYPEAPPLICATIFDUSYSACCEPT AS TYPEAPPLICATIFDUSYSACCEPT_14,
  e0_.DATEDEFINDEVALIDUNEAPPCARTE AS DATEDEFINDEVALIDUNEAPPCARTE_15,
  e0_.CODESERVICE AS CODESERVICE_16,
  e0_.CRYPTOGRAMME AS CRYPTOGRAMME_17,
  e0_.CODENUMERIQUEDELADEV AS CODENUMERIQUEDELADEV_18,
  e0_.NUMLOGIQUEDUSYSACCEPT AS NUMLOGIQUEDUSYSACCEPT_19,
  e0_.NUMDETRANSACGENPARLESYSCCEPT AS NUMDETRANSACGENPARLESYSCCEPT_20,
  e0_.NUMDEREMISE AS NUMDEREMISE_21,
  e0_.MODEDELECTUREDUNUMEROPORTEUR AS MODEDELECTUREDUNUMEROPORTEUR_22,
  e0_.NUMAUTORISATIONUNETRANSAC AS NUMAUTORISATIONUNETRANSAC_23,
  e0_.CODEFORCAGE AS CODEFORCAGE_24,
  e0_.MONTANTDELATRANSAC AS MONTANTDELATRANSAC_25,
  e0_.CODEALPHADELADEV AS CODEALPHADELADEV_26,
  e0_.PARTIEFRACDELADEV AS PARTIEFRACDELADEV_27,
  e0_.MONTANTUNETRANSACENCONTREVAL AS MONTANTUNETRANSACENCONTREVAL_28,
  e0_.CODEALPHADELADEVENCONTREVAL AS CODEALPHADELADEVENCONTREVAL_29,
  e0_.PARTIEFRACDELADEVENCONTREVAL AS PARTIEFRACDELADEVENCONTREVAL_30,
  e0_.MONTANTESTIME AS MONTANTESTIME_31,
  e0_.FORMATPIEDDETICKETTRANSAC AS FORMATPIEDDETICKETTRANSAC_32,
  e0_.AID AS AID_33,
  e0_.LABELL AS LABELL_34,
  e0_.ID_TRANSACTION AS ID_TRANSACTION_35,
  e0_.ID_COMMANDE AS ID_COMMANDE_36,
  e0_.ID_TERMINAL AS ID_TERMINAL_37
FROM
  enregistrement_ok e0_
WHERE
  e0_.ID_COMMANDE = ?
  AND e0_.ID_TERMINAL = ?
  AND e0_.ID_TRANSACTION = ?

SELECT e0_.ID_COMMANDE AS ID_COMMANDE_0, e0_.ID_TERMINAL AS ID_TERMINAL_1, e0_.ID_TRANSACTION AS ID_TRANSACTION_2, e0_.FORMATENTETETICKETTRANSAC AS FORMATENTETETICKETTRANSAC_3, e0_.DATELOCALEDELATRANSAC AS DATELOCALEDELATRANSAC_4, e0_.HEURELOCALEDELATRANSAC AS HEURELOCALEDELATRANSAC_5, e0_.ENSEIGNEACCEPT AS ENSEIGNEACCEPT_6, e0_.TYPEDETRANSAC AS TYPEDETRANSAC_7, e0_.NUMCONTRATOUIDACCEPT AS NUMCONTRATOUIDACCEPT_8, e0_.NUMSIRET AS NUMSIRET_9, e0_.TYPEACTIVITECOMMERCIALE AS TYPEACTIVITECOMMERCIALE_10, e0_.TYPEDEPAIEMENT AS TYPEDEPAIEMENT_11, e0_.TYPEDESITE AS TYPEDESITE_12, e0_.NUMCOMPTEPRIMAIREUNPORTEUR AS NUMCOMPTEPRIMAIREUNPORTEUR_13, e0_.TYPEAPPLICATIFDUSYSACCEPT AS TYPEAPPLICATIFDUSYSACCEPT_14, e0_.DATEDEFINDEVALIDUNEAPPCARTE AS DATEDEFINDEVALIDUNEAPPCARTE_15, e0_.CODESERVICE AS CODESERVICE_16, e0_.CRYPTOGRAMME AS CRYPTOGRAMME_17, e0_.CODENUMERIQUEDELADEV AS CODENUMERIQUEDELADEV_18, e0_.NUMLOGIQUEDUSYSACCEPT AS NUMLOGIQUEDUSYSACCEPT_19, e0_.NUMDETRANSACGENPARLESYSCCEPT AS NUMDETRANSACGENPARLESYSCCEPT_20, e0_.NUMDEREMISE AS NUMDEREMISE_21, e0_.MODEDELECTUREDUNUMEROPORTEUR AS MODEDELECTUREDUNUMEROPORTEUR_22, e0_.NUMAUTORISATIONUNETRANSAC AS NUMAUTORISATIONUNETRANSAC_23, e0_.CODEFORCAGE AS CODEFORCAGE_24, e0_.MONTANTDELATRANSAC AS MONTANTDELATRANSAC_25, e0_.CODEALPHADELADEV AS CODEALPHADELADEV_26, e0_.PARTIEFRACDELADEV AS PARTIEFRACDELADEV_27, e0_.MONTANTUNETRANSACENCONTREVAL AS MONTANTUNETRANSACENCONTREVAL_28, e0_.CODEALPHADELADEVENCONTREVAL AS CODEALPHADELADEVENCONTREVAL_29, e0_.PARTIEFRACDELADEVENCONTREVAL AS PARTIEFRACDELADEVENCONTREVAL_30, e0_.MONTANTESTIME AS MONTANTESTIME_31, e0_.FORMATPIEDDETICKETTRANSAC AS FORMATPIEDDETICKETTRANSAC_32, e0_.AID AS AID_33, e0_.LABELL AS LABELL_34, e0_.ID_TRANSACTION AS ID_TRANSACTION_35, e0_.ID_COMMANDE AS ID_COMMANDE_36, e0_.ID_TERMINAL AS ID_TERMINAL_37 FROM enregistrement_ok e0_ WHERE e0_.ID_COMMANDE = '9854' AND e0_.ID_TERMINAL = '45' AND e0_.ID_TRANSACTION = '9825';

0.98 ms

INSERT INTO enregistrement_ok(ID_COMMANDE,ID_TERMINAL, ID_TRANSACTION, FORMATENTETETICKETTRANSAC, DATELOCALEDELATRANSAC, HEURELOCALEDELATRANSAC, ENSEIGNEACCEPT, TYPEDETRANSAC, NUMCONTRATOUIDACCEPT, NUMSIRET, TYPEACTIVITECOMMERCIALE, TYPEDEPAIEMENT, TYPEDESITE, NUMCOMPTEPRIMAIREUNPORTEUR, TYPEAPPLICATIFDUSYSACCEPT,DATEDEFINDEVALIDUNEAPPCARTE, CODESERVICE, CRYPTOGRAMME, CODENUMERIQUEDELADEV, NUMLOGIQUEDUSYSACCEPT, NUMDETRANSACGENPARLESYSCCEPT, NUMDEREMISE, MODEDELECTUREDUNUMEROPORTEUR, NUMAUTORISATIONUNETRANSAC, CODEFORCAGE, MONTANTDELATRANSAC, CODEALPHADELADEV, PARTIEFRACDELADEV, MONTANTUNETRANSACENCONTREVAL, CODEALPHADELADEVENCONTREVAL, PARTIEFRACDELADEVENCONTREVAL, MONTANTESTIME, FORMATPIEDDETICKETTRANSAC, AID, LABELL)
										 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  1 => "9854"
  2 => "45"
  3 => "9825"
  4 => "CREDIT AGRICOLE          CENTRE LOIRE"
  5 => "190425"
  6 => "184058"
  7 => "CAMPING-CARS                            85JARD SUR MER"
  8 => "01"
  9 => "2346977"
  10 => "21850114600011"
  11 => "7523"
  12 => "46"
  13 => ""
  14 => "############7949"
  15 => "2046"
  16 => "261231"
  17 => ""
  18 => "A3C40FB284A4B7E7"
  19 => "978"
  20 => "001"
  21 => "000003"
  22 => "000117"
  23 => "C"
  24 => "952485"
  25 => "@"
  26 => "00001132"
  27 => "EUR"
  28 => "2"
  29 => "00007425"
  30 => "FRF"
  31 => "8"
  32 => "00001132"
  33 => "MERCI AU REVOIR          25092353"
  34 => "A0000000041010"
  35 => "MASTERC DEBIT"
]

View formatted query View runnable query Explain query

INSERT INTO enregistrement_ok(
  ID_COMMANDE, ID_TERMINAL, ID_TRANSACTION,
  FORMATENTETETICKETTRANSAC, DATELOCALEDELATRANSAC,
  HEURELOCALEDELATRANSAC, ENSEIGNEACCEPT,
  TYPEDETRANSAC, NUMCONTRATOUIDACCEPT,
  NUMSIRET, TYPEACTIVITECOMMERCIALE,
  TYPEDEPAIEMENT, TYPEDESITE, NUMCOMPTEPRIMAIREUNPORTEUR,
  TYPEAPPLICATIFDUSYSACCEPT, DATEDEFINDEVALIDUNEAPPCARTE,
  CODESERVICE, CRYPTOGRAMME, CODENUMERIQUEDELADEV,
  NUMLOGIQUEDUSYSACCEPT, NUMDETRANSACGENPARLESYSCCEPT,
  NUMDEREMISE, MODEDELECTUREDUNUMEROPORTEUR,
  NUMAUTORISATIONUNETRANSAC, CODEFORCAGE,
  MONTANTDELATRANSAC, CODEALPHADELADEV,
  PARTIEFRACDELADEV, MONTANTUNETRANSACENCONTREVAL,
  CODEALPHADELADEVENCONTREVAL, PARTIEFRACDELADEVENCONTREVAL,
  MONTANTESTIME, FORMATPIEDDETICKETTRANSAC,
  AID, LABELL
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO enregistrement_ok(ID_COMMANDE,ID_TERMINAL, ID_TRANSACTION, FORMATENTETETICKETTRANSAC, DATELOCALEDELATRANSAC, HEURELOCALEDELATRANSAC, ENSEIGNEACCEPT, TYPEDETRANSAC, NUMCONTRATOUIDACCEPT, NUMSIRET, TYPEACTIVITECOMMERCIALE, TYPEDEPAIEMENT, TYPEDESITE, NUMCOMPTEPRIMAIREUNPORTEUR, TYPEAPPLICATIFDUSYSACCEPT,DATEDEFINDEVALIDUNEAPPCARTE, CODESERVICE, CRYPTOGRAMME, CODENUMERIQUEDELADEV, NUMLOGIQUEDUSYSACCEPT, NUMDETRANSACGENPARLESYSCCEPT, NUMDEREMISE, MODEDELECTUREDUNUMEROPORTEUR, NUMAUTORISATIONUNETRANSAC, CODEFORCAGE, MONTANTDELATRANSAC, CODEALPHADELADEV, PARTIEFRACDELADEV, MONTANTUNETRANSACENCONTREVAL, CODEALPHADELADEVENCONTREVAL, PARTIEFRACDELADEVENCONTREVAL, MONTANTESTIME, FORMATPIEDDETICKETTRANSAC, AID, LABELL)
										 VALUES ('9854', '45', '9825', 'CREDIT AGRICOLE          CENTRE LOIRE', '190425', '184058', 'CAMPING-CARS                            85JARD SUR MER', '01', '2346977', '21850114600011', '7523', '46', '', '############7949','2046', '261231', '', 'A3C40FB284A4B7E7', '978', '001', '000003', '000117' , 'C', '952485', '@', '00001132', 'EUR', '2','00007425', 'FRF', '8', '00001132', 'MERCI AU REVOIR          25092353', 'A0000000041010', 'MASTERC DEBIT');

bddg connection

No database queries were performed.

isipay connection

No database queries were performed.

Database Connections

Name	Service
polymorph	doctrine.dbal.polymorph_connection
bddg	doctrine.dbal.bddg_connection
isipay	doctrine.dbal.isipay_connection

Entity Managers

Name	Service
polymorph	doctrine.orm.polymorph_entity_manager
bddg	doctrine.orm.bddg_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

polymorph entity manager

Class	Mapping errors
App\Entity\BDPolymorph\EnregistrementOk	No errors.
App\Entity\BDPolymorph\Enregistrement	The referenced column name 'ID_TRANSACTION' has to be a primary key column on the target entity class 'App\Entity\BDPolymorph\TransactionCb'. The join columns of the association 'transactionCb' have to match to ALL identifier columns of the target entity 'App\Entity\BDPolymorph\TransactionCb', however '' are missing.

bddg entity manager

No loaded entities.