22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1 / AtuttoCalcio- Radio L'Aquila 1 / News

22/05/2017

scritto da rjfusco.

22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1

La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria: Promozione girone A, Prima girone A, Prima girone C, Seconda girone A e Terza girone A nella nostra nuova rubrica radiofonica realizzata in collaborazione con Radio L'Aquila 1.

Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso

clicca per ascoltare — 26 gen 2018

clicca per ascoltare — 26 gen 2018

001

SET
NAMES 'utf8' COLLATE 'utf8_general_ci'

execution time: 0.050 ms (2.90%)
affected rows: 0
backtrace
to the top
close all

file	function	line
/var/www/clients/client1/web1/web/lib/zebra/Zebra_Database.php	query()	2773
/var/www/clients/client1/web1/web/config.php	set_charset()	32
/var/www/clients/client1/web1/web/index.php	require_once()	9

002

SELECT
*
FROM
ttc_menu
WHERE
published = 1 AND parent_id = 0
GROUP BY
page_name
ORDER BY
id, menu_name, page_order ;

execution time: 0.040 ms (2.43%)
returned rows: 12
explain
backtrace
to the top
close all

id	page_title	heading	menu_label	accesskey	css_selector	page_name	keywords	description	page_order	menu_name	published
1	Home	Home	Home	h	home	home	a tutto calcio, atuttocalcio, calcio, abruzzo, dilettanti, serie d, eccellenza, promozione, prima categoria, seconda categoria, terza categoria, statistiche, classifiche	A tutto calcio - Tutto il calcio a portata di click!	0	main	1
2	Serie d	Serie d	Serie d	d	serie-d	serie-d			1	main	1
3	Eccellenza	Eccellenza	Eccellenza	e	eccellenza	eccellenza			2	main	1
4	Promozione	Promozione	Promozione	p	promozione	promozione			3	main	1
5	Prima categoria	Prima categoria	Prima categoria	p	prima-categoria	prima-categoria			4	main	1
6	Seconda categoria	Seconda categoria	Seconda categoria	s	seconda-categoria	seconda-categoria			5	main	1
7	Terza categoria	Terza categoria	Terza categoria	t	terza-categoria	terza-categoria			6	main	1
8	Statistiche	Statistiche	Statistiche	g	statistiche	statistiche			7	main	1
9	Multimedia	Multimedia	Media	m	media	multimedia			8	main	1
11	Chi siamo	Chi siamo	Chi siamo	s	chi-siamo	chi-siamo			10	service	1
31	Contatti	Contatti	Contatti	c	contatti	contatti			11	service	1
32	Sondaggi	Sondaggi	Sondaggi	g	sondaggi	sondaggi			12	extra	1

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

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	43
/var/www/clients/client1/web1/web/inc/sections.inc.php	getSections()	4
/var/www/clients/client1/web1/web/index.php	require_once()	12

003

SELECT
DISTINCT categories_id
FROM
ttc_video
WHERE
published = 1

execution time: 0.030 ms (1.61%)
returned rows: 11
explain
backtrace
to the top
close all

categories_id
0
5
1
3
4
8
6
9
2
10
11

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_video	ALL					822	100.00	Using where; Using temporary

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1187
/var/www/clients/client1/web1/web/inc/localFunctions.php	getNotEmptyCategories()	1214
/var/www/clients/client1/web1/web/inc/sections.inc.php	getCategories()	10
/var/www/clients/client1/web1/web/index.php	require_once()	12

004

SELECT
c.*
FROM
ttc_categories AS c
WHERE
1 = 1
ORDER BY
c.sort ASC ;

execution time: 0.030 ms (1.70%)
returned rows: 12
explain
backtrace
to the top
close all

id	title	sort	published
1	Serie D	1	1
2	Eccellenza	2	1
3	Promozione	3	1
4	Prima Categoria	4	1
5	Seconda Categoria	5	1
6	Terza Categoria	6	1
10	Altre categorie e Trofei	7	1
11	AreaMundial	8	1
12	AtuttoCalcio- Radio L'Aquila 1	9	0
13	5^Memorial M.Pavone-A.Mariani	10	0
9	La Lavagna del Tecnico	11	0
8	Seconda Divisione B	12	0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL					12	100.00	Using filesort

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1223
/var/www/clients/client1/web1/web/inc/sections.inc.php	getCategories()	10
/var/www/clients/client1/web1/web/index.php	require_once()	12

005

SELECT
u.id, u.user, u.nome, u.cognome, u.stato
FROM
ttc_users AS u
WHERE
1 = 1
ORDER BY
u.user ASC ;

execution time: 0.040 ms (2.43%)
returned rows: 54
explain
backtrace
to the top
close all

id	user	nome	cognome	stato
50	aspinetocalcio@virgilio.it	Pineto	Pineto	ADMIN
66	s.anna.calcio1@gmail.com	Sant'Anna	Sant'Anna	ADMIN
59	aa	test squadra	test squadra	ADMIN
60	afas	altro test	altro test	ADMIN
53	asdalbaadriaticacalcio@gmail.com	Alba Adriatica	Alba Adriatica	ADMIN
54	asdalbaadriaticacalcio@gmail.com	Alba Adriatica	Alba Adriatica	ADMIN
67	asdcesaprobacalcio@alice.it	Cesaproba Calcio	Cesaproba Calcio	ADMIN
70	asdtagliacozzo@libero.it	Tagliacozzo	Tagliacozzo	ADMIN
81	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
80	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
79	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
82	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
83	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
84	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
75	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
77	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
78	atleticopreturo@libero.it	Atletico Preturo	Atletico Preturo	ADMIN
57	azlacastellina@tiscali.it	Miglianico	Miglianico	ADMIN
58	azlacastellina@tiscali.it	Miglianico	Miglianico	ADMIN
71	cdeluca10@alice.it	Pizzoli	Pizzoli	ADMIN

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	ALL					54	100.00	Using filesort

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1297
/var/www/clients/client1/web1/web/inc/sections.inc.php	getUsers()	13
/var/www/clients/client1/web1/web/index.php	require_once()	12

006

SELECT
*
FROM
ttc_menu
WHERE
page_name LIKE 'news'
LIMIT
1

execution time: 0.050 ms (2.69%)
returned rows: 1
explain
backtrace
to the top
close all

id	page_title	heading	menu_label	accesskey	css_selector	page_name	default_id	keywords	description	parent_id	page_order	menu_name	published
10	News	News	News	n	news	news	0			0	9	main	0

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

file	function	line
/var/www/clients/client1/web1/web/inc/page.inc.php	query()	21
/var/www/clients/client1/web1/web/inc/page.inc.php	getPage()	214
/var/www/clients/client1/web1/web/index.php	require_once()	18

007

SELECT
title, text, categories_id, img
FROM
ttc_news
WHERE
id = '14360'
LIMIT
1

execution time: 0.000 ms (5.85%)
returned rows: 1
explain
backtrace
to the top
close all

title

text

categories_id

img

22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1

Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso

1495463983-87-atc-rl1-ok.jpg

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

file	function	line
/var/www/clients/client1/web1/web/inc/page.inc.php	query()	287
/var/www/clients/client1/web1/web/index.php	require_once()	18

008

SELECT
a.*
FROM
ttc_banners AS a
LEFT JOIN
ttc_media_related AS b ON b.related_id = a.id
WHERE
a.position LIKE 'background' AND a.published = 1 AND a.date <= NOW() AND (a.date_to = 0 OR a.date_to >= NOW()) AND b.media_id = 14360 AND b.related_type = 'video'
ORDER BY
a.date DESC
LIMIT
0,1

execution time: 0.000 ms (11.03%)
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	b	ref	unique_relation	unique_relation	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.b.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	561
/var/www/clients/client1/web1/web/pages/index.php	loadBanner()	34
/var/www/clients/client1/web1/web/index.php	include()	29

009

execution time: 0.000 ms (10.52%)
returned rows: 1
explain
backtrace
to the top
close all

id	date	date_to	title	dida	link	file	color	published	is_default	position
18	2014-07-19 00:16:00	0000-00-00 00:00:00	m- stadium mondiale			stadium - Copia.jpg		1	1	background

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL					82	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	b	index		unique_relation	10		37	100.00	Using where; Using index; Using join buffer (flat, BNL join)

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	572
/var/www/clients/client1/web1/web/pages/index.php	loadBanner()	34
/var/www/clients/client1/web1/web/index.php	include()	29

010

SELECT
a.*
FROM
ttc_banners AS a
LEFT JOIN
ttc_media_related AS b ON b.related_id = a.id
WHERE
a.position LIKE 'banner720x90' AND a.published = 1 AND a.date <= NOW() AND (a.date_to = 0 OR a.date_to >= NOW()) AND b.media_id = 14360 AND b.related_type = 'video'
ORDER BY
a.date DESC
LIMIT
0,10

execution time: 0.000 ms (8.45%)
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	b	ref	unique_relation	unique_relation	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.b.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	561
/var/www/clients/client1/web1/web/snippets/header.php	loadBanner()	11
/var/www/clients/client1/web1/web/pages/index.php	include()	46
/var/www/clients/client1/web1/web/index.php	include()	29

011

SELECT
a.*
FROM
ttc_banners AS a
LEFT JOIN
ttc_media_related AS b ON b.related_id = a.id
WHERE
a.position LIKE 'banner720x90' AND a.published = 1 AND a.date <= NOW() AND (a.date_to = 0 OR a.date_to >= NOW())
ORDER BY
a.is_default DESC, a.date DESC
LIMIT
0,10

execution time: 0.000 ms (11.25%)
returned rows: 4
explain
backtrace
to the top
close all

id	date	date_to	title	link	file	published	is_default	position
101	2018-11-20 00:00:00	2019-07-02 08:00:00	Dott. Luigi Fantauzzi	http://www.implantologiadentalelaquila.it/	banner-fantauzzi.jpg	1	1	banner720x90
97	2018-11-14 11:00:00	2019-07-01 21:00:00	Jolly Graph	https://www.facebook.com/jollygraph/	jolly graph - Copia.jpg	1	1	banner720x90
95	2018-10-03 00:00:00	2019-07-01 08:00:00	Geo L'Aquila		web_Logo GEO LAQUILA.jpg	1	1	banner720x90
88	2018-09-22 00:00:00	2019-07-01 08:00:00	Coan Appalti		Coan 720.jpg	1	1	banner720x90

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL					82	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	b	index		unique_relation	10		37	100.00	Using where; Using index; Using join buffer (flat, BNL join)

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	572
/var/www/clients/client1/web1/web/snippets/header.php	loadBanner()	11
/var/www/clients/client1/web1/web/pages/index.php	include()	46
/var/www/clients/client1/web1/web/index.php	include()	29

012

SELECT
a.id, a.page_name, a.menu_label, a.accesskey, a.page_order, a.parent_id, a.default_id, b.page_name AS parent_name, c.page_name AS default_name
FROM
ttc_menu AS a
LEFT JOIN
ttc_menu AS b ON a.parent_id = b.id
LEFT JOIN
ttc_menu AS c ON a.default_id = c.id
WHERE
a.published = 1 AND a.menu_name = 'main'
ORDER BY
a.parent_id ASC, a.page_order ASC

execution time: 0.030 ms (1.80%)
returned rows: 9
explain
backtrace
to the top
close all

id	page_name	menu_label	accesskey	page_order
1	home	Home	h	0
2	serie-d	Serie d	d	1
3	eccellenza	Eccellenza	e	2
4	promozione	Promozione	p	3
5	prima-categoria	Prima categoria	p	4
6	seconda-categoria	Seconda categoria	s	5
7	terza-categoria	Terza categoria	t	6
8	statistiche	Statistiche	g	7
9	multimedia	Media	m	8

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL					13	100.00	Using where; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.a.parent_id	1	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.a.default_id	1	100.00	Using where

file	function	line
/var/www/clients/client1/web1/web/inc/nav-main.inc.php	query()	24
/var/www/clients/client1/web1/web/snippets/header.php	include()	13
/var/www/clients/client1/web1/web/pages/index.php	include()	46
/var/www/clients/client1/web1/web/index.php	include()	29

013

SELECT
*
FROM
ttc_news AS news
WHERE
news.published = 1 AND news.date <= '2019-02-22 14:09:41' AND news.id IN ('14360')

execution time: 0.000 ms (5.69%)
returned rows: 1
explain
backtrace
to the top
close all

users_id

date

categories_id

title

abstract

text

external

dida

img

codice

sticky

published

14360

2017-05-22 16:38:00

22 maggio, ATC commenta le gare domenicali su Radio L'Aquila 1

La redazione di atuttocalcio.tv commenta le gare del week-end, categoria per categoria.

Potete ascoltare i contenuti della rubrica "Atuttocalcio" cliccando sul player audio in basso

1495463983-87-atc-rl1-ok.jpg

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

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	913
/var/www/clients/client1/web1/web/pages/news.php	getNews()	7
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

014

SELECT
media.id, media.title, media.media, media.type
FROM
ttc_news_media AS news_media
LEFT JOIN
ttc_media AS media ON media.id = news_media.media_id
WHERE
media.type IN ('image','file','audio','Immagini','allegati') AND media.published = 1 AND news_media.news_id = 14360
ORDER BY
media.sort ASC

execution time: 0.030 ms (1.75%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	media	type
12531	clicca per ascoltare	1495553089-95-lunedai-22-05-2017.mp3	Audio

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	news_media	ALL					13255	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	media	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.news_media.media_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	964
/var/www/clients/client1/web1/web/pages/news.php	getNews()	7
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

015

SELECT
video.id, video.title, video.img, video.categories_id, video.date, video.updated_at, video.published_at, video.abstract, video.file
FROM
ttc_video AS video, ttc_media_related AS media
WHERE
media.related_id = video.id AND video.published = 1 AND media.media_id = 14360 AND media_type LIKE 'news' AND categories_id IN (1, 2, 3, 4, 5, 6, 10, 11, 12, 13, 9, 8, 0) AND related_type LIKE 'video'
ORDER BY
media.id ASC
LIMIT
0,10

execution time: 0.000 ms (8.74%)
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	media	ref	unique_relation	unique_relation	4	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	video	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.media.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	625
/var/www/clients/client1/web1/web/pages/news.php	getRelatedVideos()	8
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

016

SELECT
news.id, news.title, news.img, news.categories_id, news.date, news.abstract
FROM
ttc_news AS news, ttc_media_related AS media
WHERE
media.related_id = news.id AND news.published = 1 AND media.media_id = 14360 AND media_type LIKE 'news' AND news.categories_id IN (1, 2, 3, 4, 5, 6, 10, 11, 12, 13, 9, 8, 0) AND related_type LIKE 'news'
ORDER BY
media.id ASC
LIMIT
0,10

execution time: 0.000 ms (7.52%)
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	media	ref	unique_relation	unique_relation	4	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	news	eq_ref	PRIMARY	PRIMARY	4	c1_atuttocalcio_db.media.related_id	1	100.00	Using index condition; Using where

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	698
/var/www/clients/client1/web1/web/pages/news.php	getRelatedNews()	9
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

017

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

SELECT
*
FROM
ttc_seasons
WHERE
published = 1
ORDER BY
start_date DESC
LIMIT
0,1

execution time: 0.000 ms (6.22%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	start_date	end_date	published
7	2018/2019	2018-08-30	2019-08-31	1

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

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1361
/var/www/clients/client1/web1/web/inc/localFunctions.php	getSeasons()	1373
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getLastSeason()	13
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

018

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

SELECT
*
FROM
ttc_seasons
WHERE
published = 1
ORDER BY
start_date DESC
LIMIT
0,1

execution time: 0.030 ms (1.61%)
returned rows: 1
explain
backtrace
to the top
close all

id	title	start_date	end_date	published
7	2018/2019	2018-08-30	2019-08-31	1

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

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1361
/var/www/clients/client1/web1/web/inc/localFunctions.php	getSeasons()	1373
/var/www/clients/client1/web1/web/inc/localFunctions.php	getLastSeason()	1411
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getCompetitions()	19
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

019

SELECT
*
FROM
ttc_competitions
LEFT JOIN
ttc_competitions_meta on id = competitions_id
WHERE
published = 1 AND seasons_id = 7
ORDER BY
sort ASC

execution time: 0.030 ms (1.91%)
returned rows: 9
explain
backtrace
to the top
close all

id	title	division	sort	published	competitions_id	seasons_id	rounds_number	promosse	playoff	playout	retrocesse	phone
1	Serie D	F	0	1	1	7	38	1	4	4	2	334.9841685
2	Eccellenza		1	1	2	7	34	1	4	4	1	349.6608577
3	Promozione	A	2	1	3	7	34	1	4	4	1	349.4675111
4	Promozione	B	3	1	4	7	34	1	4	4	1	340.5386586
5	Prima Categoria	A	4	1	5	7	34	1	4	4	1	349.4675111
8	Seconda Categoria	A	6	1	8	7	30	1	0	0	0	349.6608577
16	Seconda Categoria	D	7	1	16	7	30	1	4	4	1
9	Terza Categoria	A	8	1	9	7	26	1	4	0	0
10	Terza Categoria	B	9	1	10	7	26	1	4	0	0	334.9841685

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ttc_competitions	ALL	PRIMARY				15	100.00	Using where; Using filesort
1	SIMPLE	ttc_competitions_meta	eq_ref	unique_competitions_id_seasons_id	unique_competitions_id_seasons_id	8	c1_atuttocalcio_db.ttc_competitions.id,const	1	100.00	Using index condition

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1423
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getCompetitions()	19
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

020

SELECT
title
FROM
ttc_categories
WHERE
id = 12

execution time: 0.030 ms (1.56%)
returned rows: 1
explain
backtrace
to the top
close all

title
AtuttoCalcio- Radio L'Aquila 1

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

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1898
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getRelatedCompetition()	24
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

001

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Aquila 1%' ORDER BY title ASC LIMIT 1' at line 3

SELECT
id
FROM
ttc_competitions
WHERE
title LIKE '%AtuttoCalcio- Radio L'Aquila 1%'
ORDER BY
title ASC
LIMIT
1

file	function	line
/var/www/clients/client1/web1/web/inc/localFunctions.php	query()	1907
/var/www/clients/client1/web1/web/sidebars/main-sidebar.php	getRelatedCompetition()	24
/var/www/clients/client1/web1/web/views/news-single.php	include()	101
/var/www/clients/client1/web1/web/pages/news.php	include()	45
/var/www/clients/client1/web1/web/pages/index.php	include()	52
/var/www/clients/client1/web1/web/index.php	include()	29

001	The "memcache" extension is available on you server - consider using memcache for caching query results. See the documentation for more information. to the top close all

001	$_POST array ( )

001	$_GET array ( 'section' => 'news', 'id' => '14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1', )

001	$_SESSION array ( 'lang' => 'it', )

001	$_FILES array ( )

001

$_SERVER

array (
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin',
'TEMP' => '/var/www/clients/client1/web1/tmp',
'TMPDIR' => '/var/www/clients/client1/web1/tmp',
'TMP' => '/var/www/clients/client1/web1/tmp',
'HOSTNAME' => '',
'USER' => 'web1',
'HOME' => '/var/www/clients/client1/web1',
'SCRIPT_NAME' => '/index.php',
'REQUEST_URI' => '/index.php?section=news&id=14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1',
'QUERY_STRING' => 'section=news&id=14360-22-maggio-atc-commenta-le-gare-domenicali-su-radio-l-aquila-1',
'REQUEST_METHOD' => 'GET',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'REMOTE_PORT' => '52128',
'SCRIPT_FILENAME' => '/var/www/clients/client1/web1/web/index.php',
'SERVER_ADMIN' => 'webmaster@atuttocalcio.tv',
'CONTEXT_DOCUMENT_ROOT' => '/var/www/clients/client1/web1/web',
'CONTEXT_PREFIX' => '',
'REQUEST_SCHEME' => 'http',
'DOCUMENT_ROOT' => '/var/www/clients/client1/web1/web',
'REMOTE_ADDR' => '52.91.176.251',
'SERVER_PORT' => '80',
'SERVER_ADDR' => '51.255.216.2',
'SERVER_NAME' => 'atuttocalcio.tv',
'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)',
'SERVER_SIGNATURE' => '<address>Apache/2.4.25 (Debian) Server at atuttocalcio.tv Port 80</address>
',
'HTTP_ACCEPT_ENCODING' => 'gzip',
'HTTP_CONNECTION' => 'Keep-Alive',
'HTTP_HOST' => 'atuttocalcio.tv',
'HTTP_IF_MODIFIED_SINCE' => 'Mon, 17 Dec 2018 06:06:53 UTC',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'proxy-nokeepalive' => '1',
'FCGI_ROLE' => 'RESPONDER',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => 1550840981.8949821,
'REQUEST_TIME' => 1550840981,
)

20! / 1