685f3b5059325: GET https://www.sanzioni.cloud/index.php/ruolo/ruolo/test?idbollettario=7163 at 2025-06-28 12:46:08 am by 114.119.156.44
Performance Profiling
Total processing time: 2,221 ms; Peak memory: 3.038 MB. Show Profiling Timeline
Total 94 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 00:46:08.968 | 90.7 ms | yii\db\Command::execute | DELETE FROM `n4` |
| 00:46:08.666 | 66.8 ms | yii\db\Command::execute | DELETE FROM `n0` |
| 00:46:08.578 | 63.1 ms | yii\db\Command::execute | DELETE FROM `ruolo_sanzioni` |
| 00:46:08.861 | 58.1 ms | yii\db\Command::execute | DELETE FROM `n3` |
| 00:46:09.071 | 55.0 ms | yii\db\Command::execute | DELETE FROM `n5` |
| 00:46:09.582 | 50.0 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=2066 |
| 00:46:08.755 | 45.0 ms | yii\db\Command::execute | DELETE FROM `n1` |
| 00:46:09.496 | 41.3 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='7163' |
| 00:46:08.818 | 40.0 ms | yii\db\Command::execute | DELETE FROM `n2` |
| 00:46:10.264 | 40.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n3` |
| 00:46:09.431 | 39.6 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`='7163' |
| 00:46:10.463 | 39.5 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') |
| 00:46:09.762 | 38.8 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=2275 |
| 00:46:09.719 | 37.5 ms | yii\db\Command::query | SELECT * FROM `istat2018` WHERE `id_articolo`=1178 |
| 00:46:09.940 | 36.9 ms | yii\db\Command::execute | INSERT INTO `n0` (`TipoRecord`, `CodEnte`, `DataInvio`) VALUES ('N0', '12144', '20250628') |
| 00:46:10.142 | 35.8 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', '0000000169800', '00', '00000000', ' ', 'VER.1605031/2018 04/11/2018 NOT.IL 04/11/2018 TG. CM852BA Art. 193 comma 2 ', 'SVE1605031/201804112018CM852BA ', ' ', ' ', ' ') |
| 00:46:09.343 | 35.1 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario` IN (1, 2, 3, 4, 20)) AND (`id_bollettario_proprietario`='7163') |
| 00:46:10.364 | 31.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n5` |
| 00:46:09.855 | 29.6 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, 'I', 'T', '', '2996/2018', '1605031/2018', '2018-11-04', 'GASSI', 'FRANCESCO', 'VIA VENEZIA 9', 'Noicattaro', 'F923', 'BA', '70016', '1971-09-01', 'GSSFNC71P01B716X', 'Art. 193 comma 2', 1698, 'CM852BA', 17489.4, 0, 1, '2018-11-04 09:10:36', 'NO', 0) |
| 00:46:09.383 | 29.5 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`='7163' |
| 00:46:09.274 | 29.3 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='7163' |
| 00:46:09.311 | 28.2 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='7163' |
| 00:46:10.208 | 27.7 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', '0000001748940', '00', '00000000', ' ', 'VER.1605031/2018 04/11/2018 NOT.IL 04/11/2018 TG. CM852BA Art. 193 comma 2 ', 'SVE1605031/201804112018CM852BA ', ' ', ' ', ' ') |
| 00:46:10.083 | 27.3 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 ', 'GSSFNC71P01B716X', '0000000000', '000000', 'VIA VENEZIA 9 ', '00000', ' ', '000000', '70016', 'F923', 'Noicattaro ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'GASSI ', 'FRANCESCO ', 'M', '01091971', 'B716', ' ', 'N', ' ') |
| 00:46:10.402 | 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', '000000001918740') |
| 00:46:09.137 | 23.1 ms | yii\db\Command::execute | DELETE FROM `n9` |
| 00:46:09.473 | 21.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
| 00:46:09.242 | 20.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
| 00:46:09.983 | 18.5 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') |
| 00:46:09.672 | 18.3 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1178' |
| 00:46:10.060 | 17.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n2` |
| 00:46:09.651 | 15.4 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72032 |
| 00:46:10.312 | 15.0 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 ', 'MSTSMN68T68H501Z', '000000', 'VIA VENEZIA 9 ', '00000', ' ', '000000', '70016', 'F923', 'Noicattaro ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'MASTROVITI ', 'SIMONA ', 'F', '28121968', 'H501', ' ') |
| 00:46:09.895 | 14.3 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, '2996/2018', '1605031/2018', 'I', 'MASTROVITI', 'SIMONA ', 'P', 'VIA VENEZIA 9', 'Noicattaro', 'F923', 'BA', '70016', '1968-12-28', 'MSTSMN68T68H501Z', '2018-11-04', 'CM852BA', '', 'Art. 193 comma 2', 1698, 0, 0, '2018-12-24 10:20:52', '787690198778', NULL, 849, 0, 1) |
| 00:46:09.415 | 13.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
| 00:46:08.546 | 5.0 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
| 00:46:09.305 | 3.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
| 00:46:10.456 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n9` |
| 00:46:10.306 | 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 = 'n3' AND kcu.table_name = 'n3' |
| 00:46:10.131 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n4` |
| 00:46:09.691 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
| 00:46:09.978 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n1` |
| 00:46:09.556 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `ruolo_sanzioni` |
| 00:46:10.448 | 1.7 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 00:46:10.397 | 1.7 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' |
| 00:46:09.632 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
| 00:46:10.460 | 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 = 'n9' AND kcu.table_name = 'n9' |
| 00:46:10.450 | 1.5 ms | yii\db\Command::query | SELECT * FROM `n3` |
| 00:46:09.265 | 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' |
| 00:46:10.453 | 1.5 ms | yii\db\Command::query | SELECT * FROM `n4` |
| 00:46:10.236 | 1.4 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 00:46:10.240 | 1.4 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` WHERE (`NrVerbale`='1605031/2018') AND (`TipoTrasgr`='T') |
| 00:46:10.135 | 1.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 = 'n4' AND kcu.table_name = 'n4' |
| 00:46:09.667 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
| 00:46:09.378 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
| 00:46:09.801 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
| 00:46:09.495 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
| 00:46:09.635 | 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' |
| 00:46:09.756 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2018` |
| 00:46:09.887 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=2067 |
| 00:46:09.559 | 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 = 'ruolo_sanzioni' AND kcu.table_name = 'ruolo_sanzioni' |
| 00:46:10.079 | 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 = 'n2' AND kcu.table_name = 'n2' |
| 00:46:10.534 | 1.1 ms | yii\db\Command::query | SELECT * FROM `n3` WHERE `CodPartita`='1 ' |
| 00:46:10.511 | 1.1 ms | yii\db\Command::query | SELECT * FROM `n9` |
| 00:46:09.936 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `n0` |
| 00:46:09.310 | 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' |
| 00:46:10.328 | 1.1 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 00:46:09.380 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
| 00:46:10.536 | 1.1 ms | yii\db\Command::query | SELECT * FROM `n4` WHERE `CodPartita`='1 ' |
| 00:46:09.429 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
| 00:46:10.360 | 1.1 ms | yii\db\Command::query | SELECT * FROM `n3` |
| 00:46:09.803 | 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' |
| 00:46:09.980 | 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 = 'n1' AND kcu.table_name = 'n1' |
| 00:46:09.669 | 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' |
| 00:46:09.758 | 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 = 'istat2018' AND kcu.table_name = 'istat2018' |
| 00:46:10.509 | 1.0 ms | yii\db\Command::query | SELECT * FROM `n5` |
| 00:46:10.362 | 0.9 ms | yii\db\Command::query | SELECT * FROM `n4` |
| 00:46:09.555 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` |
| 00:46:09.886 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario`=2) AND (`id_bollettario_proprietario`='7163') |
| 00:46:10.506 | 0.9 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 00:46:09.694 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
| 00:46:09.413 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario`=0) AND (`id_bollettario_proprietario`='7163') |
| 00:46:09.938 | 0.8 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' |
| 00:46:09.889 | 0.8 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` WHERE (`CodiceFiscale`='MSTSMN68T68H501Z') AND (`Nome`='SIMONA ') AND (`Cronologico`='2996/2018') |
| 00:46:10.041 | 0.8 ms | yii\db\Command::query | SELECT * FROM `n2` |
| 00:46:10.002 | 0.8 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` |
| 00:46:09.892 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72032 |
| 00:46:10.504 | 0.7 ms | yii\db\Command::query | SELECT * FROM `n0` |
| 00:46:10.505 | 0.7 ms | yii\db\Command::query | SELECT * FROM `n1` |
| 00:46:09.890 | 0.7 ms | yii\db\Command::query | SELECT * FROM `ruolo_sanzioni` |
| 00:46:09.977 | 0.6 ms | yii\db\Command::execute | DELETE FROM `n1` |
| 00:46:09.854 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `ruolo_sanzioni` WHERE `ruolo_sanzioni`.`Progressivo`=1) |
| 00:46:09.894 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `ruolo_sanzioni` WHERE `ruolo_sanzioni`.`Progressivo`=2) |
| 00:46:09.936 | 0.5 ms | yii\db\Command::execute | DELETE FROM `n0` |