686036a7d08c7: GET https://www.sanzioni.cloud/index.php/ruolo/ruolo/test?idbollettario=13670 at 2025-06-28 06:38:31 pm by 114.119.141.40
Performance Profiling
Total processing time: 1,281 ms; Peak memory: 3.038 MB. Show Profiling Timeline
Total 94 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 18:38:32.294 | 66.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario` IN (1, 2, 3, 4, 20)) AND (`id_bollettario_proprietario`='13670') |
| 18:38:32.063 | 54.1 ms | yii\db\Command::execute | DELETE FROM `n5` |
| 18:38:32.866 | 47.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n3` |
| 18:38:31.930 | 45.2 ms | yii\db\Command::execute | DELETE FROM `n0` |
| 18:38:32.960 | 43.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n5` |
| 18:38:32.211 | 40.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='13670' |
| 18:38:32.463 | 36.2 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=11366 |
| 18:38:32.762 | 32.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n2` |
| 18:38:32.922 | 29.8 ms | yii\db\Command::execute | INSERT INTO `n3` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `CodiceFiscale`, `CodIndirizzo`, `Indirizzo`, `Civico`, `Lettera`, `Km`, `Cap`, `Belfiore`, `Localita`, `CodIndirizzoRec`, `IndirizzoRec`, `CivicoRec`, `LetteraRec`, `KmRec`, `CapRec`, `BelfioreRec`, `LocalitaRec`, `NaturaGiur`, `CognomeDenominazione`, `Nome`, `Sesso`, `DataNascita`, `BelfioreNasc`, `Filler`) VALUES ('N3', '072072', '01', '1 ', 'MNANNT71B55C983C', '000000', 'VIA TRANI 65 ', '00000', ' ', '000000', '70033', 'C983', 'Corato ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'MAINO ', 'ANTONIETTA ', 'F', '15021971', 'C983', ' ') |
| 18:38:32.681 | 28.8 ms | yii\db\Command::execute | INSERT INTO `ruolo_sanzioni` (`Progressivo`, `Cronologico`, `NrVerbale`, `TipoVerbale`, `Cognome`, `Nome`, `TipoTrasgr`, `Indirizzo`, `Citta`, `Belfiore`, `Prov`, `Cap`, `DataNascita`, `CodiceFiscale`, `DataVerbale`, `Targa`, `TipoNotifica`, `Articolo`, `Sanzione`, `SpeseNotifica`, `SpeseStampa`, `DataNotifica`, `NrNotifica`, `SpeseNotMessi`, `Maggiorazione`, `Totale`, `ProgrMinuta`) VALUES (2, '3194/2018', '1602525/2018', 'D', 'MAINO', 'ANTONIETTA', 'P', 'VIA TRANI 65', 'Corato', 'C983', 'BA', '70033', '1971-02-15', 'MNANNT71B55C983C', '2018-04-18', 'BA390ML', '', 'Art. 80 c. 14', 680, 6.8, 8, '2018-04-23 11:55:49', '76745125852-0', NULL, 476, 0, 1) |
| 18:38:32.646 | 28.0 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=4025 |
| 18:38:32.534 | 28.0 ms | yii\db\Command::query | SELECT * FROM `istat2018` WHERE `id_articolo`=157 |
| 18:38:33.010 | 25.2 ms | yii\db\Command::execute | INSERT INTO `n5` (`TipoRecord`, `Comune`, `ProgrMinuta`, `TotRecord`, `TotN2`, `TotN3`, `TotN4`, `TotTributo`) VALUES ('N5', '072072', '01', '0000006', '0000001', '0000001', '0000002', '000000000768400') |
| 18:38:33.052 | 25.0 ms | yii\db\Command::execute | INSERT INTO `n9` (`TipoRecord`, `CodEnte`, `TotRecord`, `TotN1`, `TotN2`, `TotN3`, `TotN4`, `TotN5`) VALUES ('N9', '12144', '0000007', '0000001', '0000001', '0000001', '0000002', '0000001') |
| 18:38:32.433 | 24.3 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='13670' |
| 18:38:32.002 | 23.3 ms | yii\db\Command::execute | DELETE FROM `n2` |
| 18:38:32.388 | 23.2 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`='13670' |
| 18:38:32.714 | 20.5 ms | yii\db\Command::execute | INSERT INTO `n0` (`TipoRecord`, `CodEnte`, `DataInvio`) VALUES ('N0', '12144', '20250628') |
| 18:38:32.739 | 20.3 ms | yii\db\Command::execute | INSERT INTO `n1` (`TipoRecord`, `Comune`, `ProgrMinuta`, `TipoRuolo`, `NrRuolo`, `NrRate`, `TipoRuolo2`, `CodSede`, `TipoCompenso`) VALUES ('N1', '072072', '01', '1', '0000', '01', '1', '0000', '0') |
| 18:38:32.122 | 19.8 ms | yii\db\Command::execute | DELETE FROM `n9` |
| 18:38:32.801 | 18.0 ms | yii\db\Command::execute | INSERT INTO `n2` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `CodiceFiscale`, `NrContribuente`, `CodIndirizzo`, `Indirizzo`, `Civico`, `Lettera`, `Km`, `Cap`, `Belfiore`, `Localita`, `CodIndirizzoRec`, `IndirizzoRec`, `CivicoRec`, `LetteraRec`, `KmRec`, `CapRec`, `BelfioreRec`, `LocalitaRec`, `NaturaGiur`, `CognomeDenominazione`, `Nome`, `Sesso`, `DataNascita`, `BelfioreNasc`, `Filler`, `TipoDebitore`, `Filler2`) VALUES ('N2', '072072', '01', '1 ', 'VNTVCN64P22C983N', '0000000000', '000000', 'VIA MONTEBELLO 7 ', '00000', ' ', '000000', '76011', 'A883', 'Bisceglie ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'VENTURA ', 'VINCENZO ', 'M', '22091964', 'C983', ' ', 'N', ' ') |
| 18:38:31.983 | 17.2 ms | yii\db\Command::execute | DELETE FROM `n1` |
| 18:38:31.891 | 17.1 ms | yii\db\Command::execute | DELETE FROM `ruolo_sanzioni` |
| 18:38:32.827 | 16.6 ms | yii\db\Command::execute | INSERT INTO `n4` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `Anno`, `CodEntrata`, `Imponibile`, `Tributo`, `NrSemestri`, `DataInteressi`, `CodReparto`, `InfoTributo`, `InfoRuolo`, `Filler`, `Indicatore`, `Categoria`) VALUES ('N4', '072072', '01', '1 ', '2018', '5449', '0000000000000', '0000000068000', '00', '00000000', ' ', 'VER.1602525/2018 18/04/2018 NOT.IL 23/04/2018 TG. BA390ML Art. 80 c. 14 ', 'SVE1602525/201818042018BA390ML ', ' ', ' ', ' ') |
| 18:38:32.627 | 15.8 ms | yii\db\Command::execute | INSERT INTO `ruolo_sanzioni` (`Progressivo`, `TipoVerbale`, `TipoTrasgr`, `TipoNotifica`, `Cronologico`, `NrVerbale`, `DataVerbale`, `Cognome`, `Nome`, `Indirizzo`, `Citta`, `Belfiore`, `Prov`, `Cap`, `DataNascita`, `CodiceFiscale`, `Articolo`, `Sanzione`, `Targa`, `Maggiorazione`, `Totale`, `ProgrMinuta`, `DataNotifica`, `NrNotifica`, `SpeseNotMessi`) VALUES (1, 'D', 'T', '', '3194/2018', '1602525/2018', '2018-04-18', 'VENTURA', 'VINCENZO', 'VIA MONTEBELLO 7', 'Bisceglie', 'A883', 'BT', '76011', '1964-09-22', 'VNTVCN64P22C983N', 'Art. 80 c. 14', 680, 'BA390ML', 7004, 0, 1, '2018-04-23 11:55:49', '76745125852-0', 0) |
| 18:38:32.027 | 15.3 ms | yii\db\Command::execute | DELETE FROM `n3` |
| 18:38:32.366 | 15.0 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`='13670' |
| 18:38:32.582 | 15.0 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=4116 |
| 18:38:32.044 | 14.5 ms | yii\db\Command::execute | DELETE FROM `n4` |
| 18:38:32.846 | 13.6 ms | yii\db\Command::execute | INSERT INTO `n4` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `Anno`, `CodEntrata`, `Imponibile`, `Tributo`, `NrSemestri`, `DataInteressi`, `CodReparto`, `InfoTributo`, `InfoRuolo`, `Filler`, `Indicatore`, `Categoria`) VALUES ('N4', '072072', '01', '1 ', '2018', '5450', '0000000000000', '0000000700400', '00', '00000000', ' ', 'VER.1602525/2018 18/04/2018 NOT.IL 23/04/2018 TG. BA390ML Art. 80 c. 14 ', 'SVE1602525/201818042018BA390ML ', ' ', ' ', ' ') |
| 18:38:31.886 | 4.4 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
| 18:38:32.172 | 3.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
| 18:38:32.819 | 2.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n4` |
| 18:38:32.822 | 2.5 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n4' AND kcu.table_name = 'n4' |
| 18:38:33.044 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n9` |
| 18:38:32.915 | 2.4 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n3' AND kcu.table_name = 'n3' |
| 18:38:32.796 | 2.1 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n2' AND kcu.table_name = 'n2' |
| 18:38:32.428 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
| 18:38:32.528 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
| 18:38:32.207 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
| 18:38:32.863 | 1.9 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` WHERE (`NrVerbale`='1602525/2018') AND (`TipoTrasgr`='T') |
| 18:38:32.385 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
| 18:38:32.499 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
| 18:38:33.049 | 1.6 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n9' AND kcu.table_name = 'n9' |
| 18:38:33.005 | 1.6 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n5' AND kcu.table_name = 'n5' |
| 18:38:32.526 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='157' |
| 18:38:32.459 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `ruolo_sanzioni` |
| 18:38:32.187 | 1.5 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_bollettario' AND kcu.table_name = 'db2_bollettario' |
| 18:38:32.860 | 1.4 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 18:38:33.086 | 1.4 ms | yii\db\Command::query | SELECT * FROM `n3` WHERE `CodPartita`='1 ' |
| 18:38:32.360 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
| 18:38:33.081 | 1.4 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 18:38:32.711 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n0` |
| 18:38:32.387 | 1.3 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
| 18:38:32.362 | 1.3 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_proprietario' AND kcu.table_name = 'db2_proprietario' |
| 18:38:33.037 | 1.3 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 18:38:32.953 | 1.3 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 18:38:32.736 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n1` |
| 18:38:32.597 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
| 18:38:32.522 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
| 18:38:33.084 | 1.2 ms | yii\db\Command::query | SELECT * FROM `n9` |
| 18:38:33.039 | 1.2 ms | yii\db\Command::query | SELECT * FROM `n3` |
| 18:38:32.958 | 1.2 ms | yii\db\Command::query | SELECT * FROM `n4` |
| 18:38:33.082 | 1.2 ms | yii\db\Command::query | SELECT * FROM `n5` |
| 18:38:32.502 | 1.2 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db1_persona' AND kcu.table_name = 'db1_persona' |
| 18:38:32.562 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2018` |
| 18:38:32.521 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=110003 |
| 18:38:32.955 | 1.2 ms | yii\db\Command::query | SELECT * FROM `n3` |
| 18:38:32.599 | 1.1 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db1_veicolo' AND kcu.table_name = 'db1_veicolo' |
| 18:38:32.209 | 1.1 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_infrazione' AND kcu.table_name = 'db2_infrazione' |
| 18:38:32.204 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='13670' |
| 18:38:32.461 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ruolo_sanzioni' AND kcu.table_name = 'ruolo_sanzioni' |
| 18:38:33.042 | 1.0 ms | yii\db\Command::query | SELECT * FROM `n4` |
| 18:38:32.431 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_notifica' AND kcu.table_name = 'db2_notifica' |
| 18:38:33.079 | 1.0 ms | yii\db\Command::query | SELECT * FROM `n1` |
| 18:38:32.524 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_comuni' AND kcu.table_name = 'db0_comuni' |
| 18:38:32.381 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario`=0) AND (`id_bollettario_proprietario`='13670') |
| 18:38:32.531 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'articoli_new' AND kcu.table_name = 'articoli_new' |
| 18:38:32.712 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n0' AND kcu.table_name = 'n0' |
| 18:38:32.564 | 0.9 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'istat2018' AND kcu.table_name = 'istat2018' |
| 18:38:32.737 | 0.9 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n1' AND kcu.table_name = 'n1' |
| 18:38:33.088 | 0.9 ms | yii\db\Command::query | SELECT * FROM `n4` WHERE `CodPartita`='1 ' |
| 18:38:32.675 | 0.8 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` WHERE (`CodiceFiscale`='MNANNT71B55C983C') AND (`Nome`='ANTONIETTA') AND (`Cronologico`='3194/2018') |
| 18:38:32.645 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario`=2) AND (`id_bollettario_proprietario`='13670') |
| 18:38:32.760 | 0.8 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` |
| 18:38:33.078 | 0.7 ms | yii\db\Command::query | SELECT * FROM `n0` |
| 18:38:32.626 | 0.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `ruolo_sanzioni` WHERE `ruolo_sanzioni`.`Progressivo`=1) |
| 18:38:32.458 | 0.7 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` |
| 18:38:32.677 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72020 |
| 18:38:32.676 | 0.6 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` |
| 18:38:32.680 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `ruolo_sanzioni` WHERE `ruolo_sanzioni`.`Progressivo`=2) |
| 18:38:32.710 | 0.5 ms | yii\db\Command::execute | DELETE FROM `n0` |
| 18:38:32.735 | 0.5 ms | yii\db\Command::execute | DELETE FROM `n1` |
| 18:38:32.761 | 0.5 ms | yii\db\Command::query | SELECT * FROM `n2` |