Riforma Dipartimento Mercati

Le considerazioni della DASBI

Torna indietro

Debug information

Array
(
    [0] => Array
        (
            [0] => SELECT * FROM tl_page WHERE (id=0 OR alias='documenti') AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [1] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [2] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='1' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [3] => Array
        (
            [0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.id='1' OR l.fallback=1 ORDER BY l.id='1' DESC LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => l
                    [type] => ALL
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 2
                    [Extra] => Using where; Using filesort
                )

        )

    [4] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='1' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [5] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='3' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [6] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='5' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [7] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='6' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [8] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='7' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [9] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='8' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [10] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='9' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [11] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='10' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [12] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [13] => Array
        (
            [0] => SELECT id, protected, groups FROM tl_calendar WHERE id IN(1)
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_calendar
                    [type] => system
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 1
                    [Extra] => 
                )

        )

    [14] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='9' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [15] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id=(SELECT jumpTo FROM tl_calendar WHERE id='1') LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [16] => Array
        (
            [0] => SELECT *, (SELECT title FROM tl_calendar WHERE id='1') AS calendar, (SELECT name FROM tl_user WHERE id=author) author FROM tl_calendar_events WHERE pid='1' AND ((startTime>=1733007600 AND startTime<=1735685999) OR (endTime>=1733007600 AND endTime<=1735685999) OR (startTime<=1733007600 AND endTime>=1735685999) OR (recurring=1 AND (recurrences=0 OR repeatEnd>=1733007600) AND startTime<=1735685999)) AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 ORDER BY startTime
            [1] => 0 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_calendar_events
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 38
                    [Extra] => Using where; Using filesort
                )

        )

    [17] => Array
        (
            [0] => SELECT id FROM tl_article WHERE pid='7' AND inColumn='main' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_article
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => Using where; Using filesort
                )

        )

    [18] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='6' OR alias='6') AND pid='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_article
                    [type] => ref
                    [possible_keys] => PRIMARY,pid,alias
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => Using where
                )

        )

    [19] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='6' AND invisible='' ORDER BY sorting
            [1] => 2 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 2
                    [Extra] => Using where; Using filesort
                )

        )

    [20] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [21] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='13' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [22] => Array
        (
            [0] => SELECT id, protected, groups FROM tl_news_archive WHERE id IN(2)
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_news_archive
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [23] => Array
        (
            [0] => SELECT date FROM tl_news WHERE pid='2' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 ORDER BY date DESC
            [1] => 218 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_news
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 209
                    [Extra] => Using where; Using filesort
                )

        )

    [24] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [25] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='5' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [26] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='10' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [27] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='8' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [28] => Array
        (
            [0] => SELECT id, protected, groups FROM tl_news_archive WHERE id IN(1,2,3)
            [1] => 3 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_news_archive
                    [type] => ALL
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 3
                    [Extra] => Using where
                )

        )

    [29] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT title FROM tl_news_archive WHERE tl_news_archive.id=tl_news.pid) AS archive, (SELECT jumpTo FROM tl_news_archive WHERE tl_news_archive.id=tl_news.pid) AS parentJumpTo, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_news WHERE pid IN(1,2,3) AND (id=0 OR alias='riforma-dipartimento-mercati') AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_news
                    [type] => range
                    [possible_keys] => PRIMARY,pid,alias
                    [key] => pid
                    [key_len] => 4
                    [ref] => 
                    [rows] => 327
                    [Extra] => Using where
                )

        )

    [30] => Array
        (
            [0] => SELECT * FROM tl_news_archive WHERE id='2' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_news_archive
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [31] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='2' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [32] => Array
        (
            [0] => SELECT *, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2, (SELECT COUNT(*) FROM tl_style WHERE tl_style.selector='@font-face' AND tl_style.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (2, 4, 5) ORDER BY FIELD(id, 2, 4, 5)
            [1] => 3 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_style_sheet
                    [type] => ALL
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 4
                    [Extra] => Using where; Using filesort
                )

        )

    [33] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='18' OR alias='18' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [34] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='16' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [35] => Array
        (
            [0] => SELECT id,protected,groups FROM tl_linklist_archive WHERE id IN (1) AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_linklist_archive
                    [type] => system
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 1
                    [Extra] => 
                )

        )

    [36] => Array
        (
            [0] => SELECT title FROM tl_linklist_archive WHERE id='1'
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_linklist_archive
                    [type] => system
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 1
                    [Extra] => 
                )

        )

    [37] => Array
        (
            [0] => SELECT l.*,a.newwindow FROM tl_linklist l, tl_linklist_archive a WHERE l.pid='1' and a.id=l.pid AND (l.start='' OR l.start<1733447518) AND (l.stop='' OR l.stop>1733447518) AND l.published=1 ORDER BY l.sorting
            [1] => 8 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => a
                    [type] => system
                    [possible_keys] => PRIMARY
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 1
                    [Extra] => Using filesort
                )

        )

    [38] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='15' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [39] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='11' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [40] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='13' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1733447518) AND (stop='' OR stop>1733447518) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [type] => const
                    [possible_keys] => PRIMARY,type
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [Extra] => 
                )

        )

    [41] => Array
        (
            [0] => SELECT id, checksum FROM tl_search WHERE url='documenti/items/riforma-dipartimento-mercati.html' AND pid='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_search
                    [type] => ref
                    [possible_keys] => pid,url
                    [key] => url
                    [key_len] => 767
                    [ref] => const
                    [rows] => 1
                    [Extra] => Using where
                )

        )

)