Catalogo | NACSHUA

001

SET 
    NAMES "utf8" COLLATE "utf8_general_ci"

duration: 0.00043 seconds (1.61%)
affected rows: 0
backtrace
to the top
close all

File	Function	Line
/home/nacshua/public_html/vendor/stefangabos/zebra_database/Zebra_Database.php	query()	3746
/home/nacshua/public_html/functions.php	set_charset()	41
/home/nacshua/public_html/index.php	include()	2

002

WARNING: The first few results returned by this query are the same as returned by 2 other queries!

SELECT 
    id 
FROM 
    cat1 
WHERE 
    slug_it = 'kids'

duration: 0.00012 seconds (0.46%)
returned rows: 1
explain
backtrace
to the top
close all

id
3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	ALL					4	100.00	Using where

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	50
/home/nacshua/public_html/views/catalogo.php	getId()	20
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

003

SELECT 
    *, 
    categoria_it AS categoria, 
    titolo_it as titolo, 
    testo_it as testo 
FROM 
    cat1 
WHERE 
    id = '3'

duration: 0.00013 seconds (0.49%)
returned rows: 1
explain
backtrace
to the top
close all

id	categoria_it	categoria_en	ordine	titolo_it	testo_it	titolo_en	testo_en	note	background	slug_it	slug_en	categoria	titolo	testo
3	Kids	Kids	30							kids	kids	Kids

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	28
/home/nacshua/public_html/views/catalogo.php	getCat()	21
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

004

SELECT 
    id 
FROM 
    cat2 
WHERE 
    slug_it = ''

duration: 0.00013 seconds (0.50%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat2	ALL					4	100.00	Using where

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	50
/home/nacshua/public_html/views/catalogo.php	getId()	23
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

005

SELECT 
    *, 
    categoria_it AS categoria, 
    titolo_it as titolo, 
    testo_it as testo 
FROM 
    cat2 
WHERE 
    id = '0'

duration: 0.00013 seconds (0.49%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE									Impossible WHERE noticed after reading const tables

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	28
/home/nacshua/public_html/views/catalogo.php	getCat()	24
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

006

WARNING: The first few results returned by this query are the same as returned by 2 other queries!

SELECT 
    id 
FROM 
    cat1 
WHERE 
    slug_it = 'kids'

duration: 0.00015 seconds (0.56%)
returned rows: 1
explain
backtrace
to the top
close all

id
3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	ALL					4	100.00	Using where

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	50
/home/nacshua/public_html/functions_prodotti.php	getId()	57
/home/nacshua/public_html/views/catalogo.php	getProdotti()	44
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

007

SELECT 
    id, 
    cat1_id 
FROM 
    prodotti 
WHERE 
    cat1_id = '3' 
    AND active = '1' 
ORDER BY 
    id 
LIMIT 
    0, 8

duration: 0.00247 seconds (9.20%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prodotti	index		PRIMARY	4		8	3700.00	Using where

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	68
/home/nacshua/public_html/views/catalogo.php	getProdotti()	44
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

008

WARNING: The first few results returned by this query are the same as returned by 2 other queries!

SELECT 
    id 
FROM 
    cat1 
WHERE 
    slug_it = 'kids'

duration: 0.00014 seconds (0.51%)
returned rows: 1
explain
backtrace
to the top
close all

id
3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	ALL					4	100.00	Using where

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	50
/home/nacshua/public_html/functions_prodotti.php	getId()	57
/home/nacshua/public_html/views/catalogo.php	getProdotti()	50
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

009

SELECT 
    id, 
    cat1_id 
FROM 
    prodotti 
WHERE 
    cat1_id = '3' 
    AND active = '1' 
ORDER BY 
    id

duration: 0.00052 seconds (1.95%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prodotti	ALL					296	100.00	Using where; Using filesort

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	69
/home/nacshua/public_html/views/catalogo.php	getProdotti()	50
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

010

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = ''

duration: 0.00014 seconds (0.54%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE									Impossible WHERE noticed after reading const tables

File	Function	Line
/home/nacshua/public_html/index.php	query()	145
/home/nacshua/public_html/views/catalogo.php	url()	73
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

011

WARNING: The first few results returned by this query are the same as returned by 4 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '3'

duration: 0.00012 seconds (0.44%)
returned rows: 1
explain
backtrace
to the top
close all

slug
kids

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	145
/home/nacshua/public_html/views/catalogo.php	url()	75
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

012

SELECT 
    DISTINCT cat1.id, 
    categoria_it as genere 
FROM 
    prodotti P, 
    cat1 
WHERE 
    P.cat1_id = cat1.id 
    AND P.active = '1' 
ORDER BY 
    cat1.ordine

duration: 0.00076 seconds (2.82%)
returned rows: 2
explain
backtrace
to the top
close all

id	genere
1	Uomo
2	Donna

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	P	ALL					296	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	cat1	ALL	PRIMARY				4	75.00	Using where; Using join buffer (Block Nested Loop)

File	Function	Line
/home/nacshua/public_html/views/template_nav_search.php	query()	10
/home/nacshua/public_html/views/catalogo.php	include()	152
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

013

SELECT 
    DISTINCT stagione_it as stagione 
FROM 
    prodotti 
WHERE 
    active = '1' 
    AND stagione_it != '' 
ORDER BY 
    stagione_it

duration: 0.00073 seconds (2.71%)
returned rows: 2
explain
backtrace
to the top
close all

stagione
CONTINUATIVO
PRIMAVERA/ESTATE 2022

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prodotti	ALL					296	100.00	Using where; Using temporary; Using filesort

File	Function	Line
/home/nacshua/public_html/views/template_nav_search.php	query()	25
/home/nacshua/public_html/views/catalogo.php	include()	152
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

014

SELECT 
    DISTINCT materiale_it as materiale 
FROM 
    prodotti 
WHERE 
    active = '1' 
    AND materiale_it != '' 
ORDER BY 
    materiale_it

duration: 0.00073 seconds (2.72%)
returned rows: 3
explain
backtrace
to the top
close all

materiale
JERSEY
JERSEY MAKO'
TELA

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	prodotti	ALL					296	100.00	Using where; Using temporary; Using filesort

File	Function	Line
/home/nacshua/public_html/views/template_nav_search.php	query()	39
/home/nacshua/public_html/views/catalogo.php	include()	152
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

015

select 
    distinct C.id, 
    L.colori, 
    C.colore_it as colore, 
    C.rgb 
from 
    (
        select 
            colori.id, 
            SUBSTRING_INDEX(
                SUBSTRING_INDEX(prodotti.colori, ',', colori.id), 
                ',', 
                -1
            ) colori 
        FROM 
            colori 
            Inner Join prodotti ON CHAR_LENGTH(prodotti.colori) - CHAR_LENGTH(
                REPLACE(prodotti.colori, ',', '')
            )>= colori.id - 1 
        order by 
            colori
    ) L, 
    colori C 
WHERE 
    L.colori = C.id 
    AND C.colore_it != '' 
ORDER BY 
    C.ordine

duration: 0.00719 seconds (26.82%)
returned rows: 28
explain
backtrace
to the top
close all

id	colori	colore	rgb
3	3	Rosa	#ffc0cb
13	13	Panna	#f1eed5
20	20	ROYAL
30	30	Avion
14	14	Geranio	#fd4f48
23	23	Grigio Chiaro
4	4	Giallo	#f7d917
15	15	Ciclamino	#e447ab
24	24	Verde
5	5	Grigio	#d2d2d2
16	16	Zaffiro	#1d1e33
25	25	Bordeaux
6	6	Jeans	#5dadec
1	1	Bianco	#fff
17	17	Malva	#993366
26	26	Beige
7	7	Rosso	#f80000
10	10	Fuxia	#f400A1
18	18	Bluette	#2761ca
27	27	Tortora

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	ALL					5624	100.00	Using where; Using temporary; Using filesort
1	PRIMARY	C	eq_ref	PRIMARY	PRIMARY	4	L.colori	1	100.00	Using where
2	DERIVED	colori	index		PRIMARY	4		19	100.00	Using index; Using temporary; Using filesort
2	DERIVED	prodotti	ALL					296	100.00	Using where; Using join buffer (Block Nested Loop)

File	Function	Line
/home/nacshua/public_html/views/template_nav_search.php	query()	66
/home/nacshua/public_html/views/catalogo.php	include()	152
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

016

SELECT 
    DISTINCT PA.var2_it as taglia 
FROM 
    prodotti P, 
    prodotti_articoli PA 
WHERE 
    PA.var2_it != '' 
    AND P.id = PA.prodotto_id 
    AND P.active = '1' 
ORDER BY 
    PA.ordine

duration: 0.00446 seconds (16.63%)
returned rows: 5
explain
backtrace
to the top
close all

taglia
M
S
L
XL
XXL

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	PA	ALL					2474	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	P	eq_ref	PRIMARY	PRIMARY	4	nacshua_1.PA.prodotto_id	1	100.00	Using where; Distinct

File	Function	Line
/home/nacshua/public_html/views/template_nav_search.php	query()	96
/home/nacshua/public_html/views/catalogo.php	include()	152
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

017

WARNING: The first few results returned by this query are the same as returned by 4 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '3'

duration: 0.00012 seconds (0.46%)
returned rows: 1
explain
backtrace
to the top
close all

slug
kids

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	145
/home/nacshua/public_html/views/catalogo.php	url()	216
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

018

SELECT 
    DISTINCT C.id, 
    C.categoria_it AS categoria 
FROM 
    prodotti P, 
    cat1 C 
WHERE 
    P.cat1_id = C.id 
ORDER BY 
    C.ordine

duration: 0.00014 seconds (0.54%)
returned rows: 4
explain
backtrace
to the top
close all

id	categoria
1	Uomo
2	Donna
3	Kids
7	Lingerie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	P	ALL					296	100.00	Using temporary; Using filesort
1	SIMPLE	C	ALL	PRIMARY				4	75.00	Using where; Using join buffer (Block Nested Loop)

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	6
/home/nacshua/public_html/views/footer.php	getTreeCategories()	125
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

019

SELECT 
    DISTINCT C2.id, 
    C2.categoria_it AS categoria 
FROM 
    prodotti P, 
    cat2 C2 
WHERE 
    P.cat2_id = C2.id 
    AND P.cat1_id = '1' 
ORDER BY 
    C2.ordine

duration: 0.00011 seconds (0.43%)
returned rows: 1
explain
backtrace
to the top
close all

id	categoria
4	Pantofole

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	P	ALL					296	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	C2	ALL	PRIMARY				4	75.00	Using where; Using join buffer (Block Nested Loop)

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	9
/home/nacshua/public_html/views/footer.php	getTreeCategories()	125
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

020

SELECT 
    DISTINCT C2.id, 
    C2.categoria_it AS categoria 
FROM 
    prodotti P, 
    cat2 C2 
WHERE 
    P.cat2_id = C2.id 
    AND P.cat1_id = '2' 
ORDER BY 
    C2.ordine

duration: 0.00013 seconds (0.48%)
returned rows: 1
explain
backtrace
to the top
close all

id	categoria
1	Pantofole

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	P	ALL					296	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	C2	ALL	PRIMARY				4	75.00	Using where; Using join buffer (Block Nested Loop)

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	9
/home/nacshua/public_html/views/footer.php	getTreeCategories()	125
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

021

SELECT 
    DISTINCT C2.id, 
    C2.categoria_it AS categoria 
FROM 
    prodotti P, 
    cat2 C2 
WHERE 
    P.cat2_id = C2.id 
    AND P.cat1_id = '3' 
ORDER BY 
    C2.ordine

duration: 0.00012 seconds (0.44%)
returned rows: 2
explain
backtrace
to the top
close all

id	categoria
3	Bambina
2	Bambino

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	P	ALL					296	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	C2	ALL	PRIMARY				4	75.00	Using where; Using join buffer (Block Nested Loop)

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	9
/home/nacshua/public_html/views/footer.php	getTreeCategories()	125
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

022

SELECT 
    DISTINCT C2.id, 
    C2.categoria_it AS categoria 
FROM 
    prodotti P, 
    cat2 C2 
WHERE 
    P.cat2_id = C2.id 
    AND P.cat1_id = '7' 
ORDER BY 
    C2.ordine

duration: 0.00013 seconds (0.49%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	P	ALL					296	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	C2	ALL	PRIMARY				4	75.00	Using where; Using join buffer (Block Nested Loop)

File	Function	Line
/home/nacshua/public_html/functions_prodotti.php	query()	9
/home/nacshua/public_html/views/footer.php	getTreeCategories()	125
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

023

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '1'

duration: 0.00011 seconds (0.43%)
returned rows: 1
explain
backtrace
to the top
close all

slug
uomo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	145
/home/nacshua/public_html/views/footer.php	url()	130
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

024

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '1'

duration: 0.00011 seconds (0.43%)
returned rows: 1
explain
backtrace
to the top
close all

slug
uomo

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	150
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

025

SELECT 
    slug_it as slug 
FROM 
    cat2 
WHERE 
    id = '4'

duration: 0.00012 seconds (0.46%)
returned rows: 1
explain
backtrace
to the top
close all

slug
pantofole-1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat2	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	153
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

026

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '2'

duration: 0.00011 seconds (0.42%)
returned rows: 1
explain
backtrace
to the top
close all

slug
donna

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	145
/home/nacshua/public_html/views/footer.php	url()	130
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

027

WARNING: The first few results returned by this query are the same as returned by 1 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '2'

duration: 0.00013 seconds (0.48%)
returned rows: 1
explain
backtrace
to the top
close all

slug
donna

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	150
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

028

SELECT 
    slug_it as slug 
FROM 
    cat2 
WHERE 
    id = '1'

duration: 0.00011 seconds (0.42%)
returned rows: 1
explain
backtrace
to the top
close all

slug
pantofole

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat2	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	153
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

029

WARNING: The first few results returned by this query are the same as returned by 4 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '3'

duration: 0.00011 seconds (0.41%)
returned rows: 1
explain
backtrace
to the top
close all

slug
kids

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	145
/home/nacshua/public_html/views/footer.php	url()	130
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

030

WARNING: The first few results returned by this query are the same as returned by 4 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '3'

duration: 0.00011 seconds (0.42%)
returned rows: 1
explain
backtrace
to the top
close all

slug
kids

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	150
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

031

SELECT 
    slug_it as slug 
FROM 
    cat2 
WHERE 
    id = '3'

duration: 0.00013 seconds (0.50%)
returned rows: 1
explain
backtrace
to the top
close all

slug
bambina

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat2	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	153
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

032

WARNING: The first few results returned by this query are the same as returned by 4 other queries!

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '3'

duration: 0.00011 seconds (0.42%)
returned rows: 1
explain
backtrace
to the top
close all

slug
kids

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	150
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

033

SELECT 
    slug_it as slug 
FROM 
    cat2 
WHERE 
    id = '2'

duration: 0.00012 seconds (0.43%)
returned rows: 1
explain
backtrace
to the top
close all

slug
bambino

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat2	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	153
/home/nacshua/public_html/views/footer.php	url()	135
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

034

SELECT 
    slug_it as slug 
FROM 
    cat1 
WHERE 
    id = '7'

duration: 0.00012 seconds (0.44%)
returned rows: 1
explain
backtrace
to the top
close all

slug
lingerie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat1	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nacshua/public_html/index.php	query()	145
/home/nacshua/public_html/views/footer.php	url()	130
/home/nacshua/public_html/views/catalogo.php	include()	254
/home/nacshua/public_html/index.php	require()	134
/home/nacshua/public_html/index.php	loadPage()	104

001	$_REQUEST array ( )

001	$_POST array ( )

001	$_GET array ( 'lang' => 'it', 'slug' => 'kids', 'slug2' => '', )

001

$_SESSION

array (
  'cart' => 'O:4:"Cart":14:{s:2:"id";s:13:"ce3806b48b7fd";s:13:"spedizione_id";i:2;s:18:"spedizione_sede_id";N;s:12:"pagamento_id";i:1;s:17:"spedizione_region";s:5:"italy";s:11:"coupon_code";N;s:14:"totaleProdotti";N;s:8:"numItems";i:0;s:5:"items";a:0:{}s:12:"importoPromo";i:0;s:17:"importoSpedizione";s:4:"6.00";s:30:"importoSupplementoContrassegno";b:0;s:6:"totale";d:6;s:13:"promoCiabatte";i:0;}',
  'NACSHUA_lang' => 'it',
  'lang' => 'it',
)

001	$_FILES array ( )

001

$_SERVER

array (
  'PATH' => '/usr/local/bin:/usr/bin:/bin',
  'TEMP' => '/tmp',
  'TMP' => '/tmp',
  'TMPDIR' => '/tmp',
  'PWD' => '/',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_CONNECTION' => 'Keep-Alive',
  'CONTENT_LENGTH' => '0',
  'HTTP_HOST' => 'www.nacshuasrl.it',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'HTTP_IF_MODIFIED_SINCE' => 'Sat, 04 Dec 2021 22:08:50 GMT',
  'HTTP_X_FORWARDED_PROTO' => 'https',
  'REDIRECT_UNIQUE_ID' => 'YoIAzUaDxB1AoKJaJRLXXAAAADc',
  'REDIRECT_SCRIPT_URL' => '/it/catalogo/kids',
  'REDIRECT_SCRIPT_URI' => 'https://www.nacshuasrl.it/it/catalogo/kids',
  'REDIRECT_PROTO' => 'https',
  'REDIRECT_HTTPS' => 'on',
  'REDIRECT_SSL_TLS_SNI' => 'www.nacshuasrl.it',
  'REDIRECT_STATUS' => '200',
  'UNIQUE_ID' => 'YoIAzUaDxB1AoKJaJRLXXAAAADc',
  'HTTPS' => 'on',
  'SCRIPT_URL' => '/it/catalogo/kids',
  'SCRIPT_URI' => 'https://www.nacshuasrl.it/it/catalogo/kids',
  'PROTO' => 'https',
  'SSL_TLS_SNI' => 'www.nacshuasrl.it',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_NAME' => 'www.nacshuasrl.it',
  'SERVER_ADDR' => '81.88.52.7',
  'SERVER_PORT' => '443',
  'REMOTE_ADDR' => '35.172.111.71',
  'DOCUMENT_ROOT' => '/home/nacshua/public_html',
  'REQUEST_SCHEME' => 'https',
  'CONTEXT_PREFIX' => '',
  'CONTEXT_DOCUMENT_ROOT' => '/home/nacshua/public_html',
  'SERVER_ADMIN' => 'webmaster@nacshuasrl.it',
  'SCRIPT_FILENAME' => '/home/nacshua/public_html/index.php',
  'REMOTE_PORT' => '43302',
  'REDIRECT_URL' => '/it/catalogo/kids',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'REQUEST_METHOD' => 'GET',
  'QUERY_STRING' => '',
  'REQUEST_URI' => '/it/catalogo/kids',
  'SCRIPT_NAME' => '/index.php',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1652687053.30855,
  'REQUEST_TIME' => 1652687053,
)

WWW.NACSHUA.IT

CONTATTI

INFO

ACCOUNT