19 duplicated queries found.
Time | Duration | Type | Duplicated | Query |
---|---|---|---|---|
16:29:59.654 | 1.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db0_user` |
16:29:59.657 | 1.0 ms | SELECT | 1 | 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_user' AND kcu.table_name = 'db0_user' |
16:29:59.662 | 0.8 ms | SELECT | 3 | SELECT * FROM `db0_user` WHERE `id`=11 |
16:29:59.683 | 1.8 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_bollettario` |
16:29:59.687 | 1.2 ms | SELECT | 1 | 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' |
16:29:59.688 | 0.9 ms | SELECT | 3 | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='18751' |
16:29:59.690 | 1.2 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db0_ente` |
16:29:59.691 | 0.9 ms | SELECT | 1 | 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_ente' AND kcu.table_name = 'db0_ente' |
16:29:59.693 | 0.6 ms | SELECT | 1 | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
16:29:59.695 | 1.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_rateizzato` |
16:29:59.697 | 1.0 ms | SELECT | 1 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
16:29:59.698 | 0.7 ms | SELECT | 1 | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`='18751' |
16:29:59.703 | 0.9 ms | SELECT | 3 | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='18751' |
16:29:59.704 | 0.7 ms | SELECT | 3 | SELECT * FROM `db0_ente` WHERE `id_ente`=1
|
16:29:59.710 | 1.0 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_pagamento` WHERE (`id_ente_pagamento`=1) AND (`id_bollettario_pagamento`='18751') |
16:29:59.712 | 1.1 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_pagamento` |
16:29:59.713 | 1.1 ms | SELECT | 1 | 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_pagamento' AND kcu.table_name = 'db2_pagamento' |
16:29:59.727 | 0.8 ms | SELECT | 3 | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='18751' |
16:29:59.729 | 1.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
16:29:59.730 | 1.0 ms | SELECT | 1 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
16:29:59.732 | 0.8 ms | SELECT | 1 | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='18751' |
16:29:59.733 | 1.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_notifica` |
16:29:59.735 | 1.0 ms | SELECT | 1 | 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' |
16:29:59.737 | 0.8 ms | SELECT | 1 | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='18751' |
16:29:59.738 | 0.6 ms | SELECT | 3 | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
16:29:59.744 | 0.9 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='18751' |
16:29:59.745 | 1.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_docallegato` |
16:29:59.747 | 0.9 ms | SELECT | 1 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
16:29:59.750 | 1.0 ms | SELECT | 1 | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='18751' LIMIT 20 |
16:29:59.754 | 1.0 ms | SELECT | 2 | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=18751
|
16:29:59.755 | 0.8 ms | SELECT | 3 | SELECT * FROM `db0_ente` WHERE `id_ente`=1
|
16:29:59.757 | 1.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_infrazione`
|
16:29:59.759 | 1.0 ms | SELECT | 1 | 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'
|
16:29:59.761 | 0.8 ms | SELECT | 2 | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=18751) AND (`id_ente_infrazione`=1)
|
16:29:59.762 | 0.6 ms | SELECT | 1 | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=18751
|
16:29:59.765 | 1.0 ms | SELECT | 2 | SELECT * FROM `articoli_new` WHERE `id_articolo`='157'
|
16:29:59.766 | 1.9 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `articoli_new`
|
16:29:59.769 | 0.9 ms | SELECT | 1 | 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'
|
16:29:59.771 | 1.0 ms | SELECT | 2 | SELECT * FROM `istat2021` WHERE `id_articolo`=157
|
16:29:59.772 | 1.0 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `istat2021`
|
16:29:59.774 | 0.9 ms | SELECT | 1 | 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 = 'istat2021' AND kcu.table_name = 'istat2021'
|
16:29:59.776 | 0.9 ms | SELECT | 2 | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=18751) AND (`id_ente_infrazione`=1)
|
16:29:59.777 | 0.7 ms | SELECT | 3 | SELECT * FROM `db0_user` WHERE `id`=11 |
16:29:59.778 | 0.6 ms | SELECT | 3 | SELECT * FROM `db0_user` WHERE `id`=11 |
16:29:59.781 | 1.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db1_stradario`
|
16:29:59.783 | 0.9 ms | SELECT | 1 | 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_stradario' AND kcu.table_name = 'db1_stradario'
|
16:29:59.784 | 0.6 ms | SELECT | 1 | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=14546 |
16:29:59.786 | 1.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db0_comuni`
|
16:29:59.788 | 0.8 ms | SELECT | 1 | 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'
|
16:29:59.790 | 0.7 ms | SELECT | 1 | SELECT * FROM `db0_comuni` WHERE `id_comune`=72002 |
16:29:59.793 | 0.9 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=18751
|
16:29:59.794 | 1.1 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_sottoscritti`
|
16:29:59.796 | 1.1 ms | SELECT | 1 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti'
|
16:29:59.797 | 0.7 ms | SELECT | 1 | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=18751 ORDER BY `id_sottoscritti` DESC LIMIT 15
|
16:29:59.801 | 0.8 ms | SELECT | 1 | SELECT * FROM `db1_agente` WHERE `id_agente`=60
|
16:29:59.802 | 1.2 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db1_agente`
|
16:29:59.804 | 1.0 ms | SELECT | 1 | 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_agente' AND kcu.table_name = 'db1_agente'
|
16:29:59.806 | 0.7 ms | SELECT | 1 | SELECT * FROM `db1_agente` WHERE `id_agente`=55
|
16:29:59.808 | 0.8 ms | SELECT | 1 | SELECT * FROM `db1_agente` WHERE `id_agente`=38
|
16:29:59.812 | 0.9 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18751) AND (`tipo_proprietario`=0)
|
16:29:59.813 | 1.2 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_proprietario`
|
16:29:59.815 | 1.0 ms | SELECT | 1 | 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'
|
16:29:59.816 | 0.8 ms | SELECT | 1 | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18751) AND (`tipo_proprietario`=0) LIMIT 20
|
16:29:59.819 | 0.9 ms | SELECT | 2 | SELECT * FROM `db1_persona` WHERE `id_persona`=18307
|
16:29:59.820 | 1.5 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db1_persona`
|
16:29:59.823 | 1.0 ms | SELECT | 1 | 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'
|
16:29:59.827 | 0.9 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=18751
|
16:29:59.828 | 1.0 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_verbaleveicolo`
|
16:29:59.830 | 1.1 ms | SELECT | 1 | 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'
|
16:29:59.831 | 0.9 ms | SELECT | 1 | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=18751 LIMIT 20
|
16:29:59.835 | 0.9 ms | SELECT | 1 | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=15363
|
16:29:59.836 | 1.2 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db1_veicolo`
|
16:29:59.837 | 1.0 ms | SELECT | 1 | 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'
|
16:29:59.840 | 0.9 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18751) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20))
|
16:29:59.842 | 0.8 ms | SELECT | 1 | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18751) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20
|
16:29:59.844 | 0.7 ms | SELECT | 2 | SELECT * FROM `db1_persona` WHERE `id_persona`=18307
|
16:29:59.848 | 0.9 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=18751
|
16:29:59.849 | 1.1 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `db2_verbaleazienda`
|
16:29:59.850 | 1.0 ms | SELECT | 1 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda'
|
16:29:59.853 | 0.9 ms | SELECT | 2 | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=18751
|
16:29:59.855 | 0.7 ms | SELECT | 1 | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=18751
|
16:29:59.857 | 0.8 ms | SELECT | 1 | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=18751 ORDER BY `id_infrazione` DESC LIMIT 15
|
16:29:59.860 | 0.8 ms | SELECT | 2 | SELECT * FROM `articoli_new` WHERE `id_articolo`='157'
|
16:29:59.861 | 0.7 ms | SELECT | 1 | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=21330
|
16:29:59.863 | 0.8 ms | SELECT | 2 | SELECT * FROM `istat2021` WHERE `id_articolo`=157
|
16:29:59.865 | 0.7 ms | SELECT | 1 | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |