Panorama Panzio - Szoba kepek

« 7 / 0

total queries: 7 (0.0034942626953125 seconds) successful queries: 7 unsuccessful queries : 0 messages : 0 watch: 0 globals

unsuccessful queries: 0

1.

SELECT
SQL_CALC_FOUND_ROWS *
FROM
settings
LIMIT
1

execution time: 0.0002751350402832 seconds
returned rows: 1 «« show | explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	settings	system					1	100.00

function: dlookup()
file: /home/pzsnetc/public_html/panorama.zed.ro/zebracms/modules/kernel/api/api.kernel.php
line: 687

close all

2.

SELECT
SQL_CALC_FOUND_ROWS *
FROM
languages

execution time: 0.00018811225891113 seconds
returned rows: 1 «« show | explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	languages	system					1	100.00

function: query()
file: /home/pzsnetc/public_html/panorama.zed.ro/zebracms/modules/kernel/api/api.kernel.php
line: 563

close all

3.

SELECT
SQL_CALC_FOUND_ROWS menus.*, menus_language_hu.title
FROM
menus
INNER JOIN
menus_language_hu ON menus.id = menus_language_hu.id

execution time: 0.00024914741516113 seconds
returned rows: 6 «« show | explain

id	group	parent	lft	rgt	link_type	link	link_title	link_url	pos	title
38	0	0	0	0	article	1	Despre pensiune	despre_pensiune/	2	A panziorol
48	0	0	0	0	article	6	Pagina principala	pagina_principala/	1	Fooldal
50	0	0	0	0	article	8	Contact	contact/	3	Elerhetosegek
54	0	0	0	0	article	13	Baile Tusnad	baile_tusnad	5	Tusnadfurdo
53	0	0	0	0	article	12	Poze camere	poze_camere/	4	Szoba kepek
57	0	0	0	0	article	15	Poze exterior	poze_exterior/	6	Kepek kintrol

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	menus_language_hu	ALL	PRIMARY				6	100.00
1	SIMPLE	menus	eq_ref	PRIMARY	PRIMARY	4	pzsnetc_panoramazedro.menus_language_hu.id	1	100.00

function: query()
file: /home/pzsnetc/public_html/panorama.zed.ro/zebracms/modules/menus/api/api.menus.php
line: 1019

close all

4.

SELECT
SQL_CALC_FOUND_ROWS *
FROM
menus_groups

execution time: 0.00019001960754395 seconds
returned rows: 0 «« show | explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	menus_groups	system					0	0.00	const row not found

function: query()
file: /home/pzsnetc/public_html/panorama.zed.ro/zebracms/modules/menus/api/api.menus.php
line: 297

close all

5.

SELECT
SQL_CALC_FOUND_ROWS articles.*, users.name as author, articles_categories.lft, articles_language_hu.title, articles_language_hu.labels, articles_language_hu.content
FROM
articles
LEFT JOIN
users ON articles.owner = users.id
LEFT JOIN
articles_categories ON articles.category = articles_categories.id
INNER JOIN
articles_language_hu ON articles.id = articles_language_hu.id
WHERE
articles.url = 'poze_camere' AND category = '0'

execution time: 0.00085592269897461 seconds
returned rows: 1 «« show | explain

category

owner

url

cover_width

cover_height

cover_quality

enlarge_cover

max_file_size_cover

cover_name

cover_ext

img_thumb_width

img_thumb_height

img_thumb_quality

enlarge_thumb

img_resize

img_width

img_height

img_quality

enlarge_image

max_file_size

manual_url_assignment

images

enable_commenting

comments

enable_rating

rating

date

status

author

lft

title

labels

description

poze_camere

100

1000000

t2y1j8f17mdt

jpg

100

800

600

10000000

1545127020

published

Gabor Gyopar

Szoba kepek

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gallery_albums	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	users	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	gallery_categories	system	PRIMARY				1	100.00
1	SIMPLE	gallery_albums_language_hu	const	PRIMARY	PRIMARY	4	const	1	100.00

function: query()
file: /home/pzsnetc/public_html/panorama.zed.ro/zebracms/modules/gallery/api/api.gallery.php
line: 784

close all

7.

SELECT
SQL_CALC_FOUND_ROWS gallery_images.*, gallery_albums.owner as owner, gallery_images_language_hu.title, gallery_images_language_hu.labels, gallery_images_language_hu.description
FROM
gallery_images
INNER JOIN
gallery_albums ON gallery_images.album = gallery_albums.id
INNER JOIN
gallery_images_language_hu ON gallery_images.id = gallery_images_language_hu.id
WHERE
album = '18'

execution time: 0.00090503692626953 seconds
returned rows: 7 «« show | explain

id	album	image_name	image_ext	date	status	enable_commenting	comments	enable_rating	rating	owner	title	labels	description
178	18	5lb32809rp4v	jpg	1551251880	published	1	0	1	0	2	02 szoba
177	18	u0dh13hjyopd	jpg	1551251280	published	1	0	1	0	2	01 szoba
180	18	vw0t4158l5o5	jpg	1551252060	published	1	0	1	0	2	szoba
179	18	63rr73718d5k	jpg	1551251940	published	1	0	1	0	2	szoba
181	18	13x95xx782uq	jpg	1551252120	published	1	0	1	0	2	szoba
182	18	2w020o6i9ubo	jpg	1551252180	published	1	0	1	0	2	szoba
183	18	4p6qti65jph8	jpg	1551252300	published	1	0	1	0	2	szoba

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gallery_images	ref	PRIMARY,album	album	4	const	6	100.00
1	SIMPLE	gallery_images_language_hu	eq_ref	PRIMARY	PRIMARY	4	pzsnetc_panoramazedro.gallery_images.id	1	100.00
1	SIMPLE	gallery_albums	ALL	PRIMARY				3	100.00	Using where; Using join buffer (flat, BNL join)

function: query()
file: /home/pzsnetc/public_html/panorama.zed.ro/lib/common.php(43) : eval()'d code
line: 25

close all

messages: 0

watch: 0

$_COOKIE $_FILES $_GET $_POST $_SERVER $_SESSION

$_COOKIE

Array
(
)

$_FILES

Array
(
)

$_GET

Array
(
)

$_POST

Array
(
)

$_SERVER

$_SESSION

Array
(
)

website_name	website_domain	zcms_language	zcms_theme
PanorÃ¡ma PanziÃ³	panorama.panzio.ro	english	default

id	code	language
2	hu	Hungarian