Panorama Panzio - Szoba kepek

« 7 / 0

total queries: 7 (0.021355152130127 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.0002448558807373 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.00018215179443359 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.00023913383483887 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.0001671314239502 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.00065898895263672 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.0081679821014404 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

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] => gzip
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
    [HTTP_CONNECTION] => Keep-Alive
    [CONTENT_LENGTH] => 0
    [HTTP_HOST] => panorama.zed.ro
    [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [HTTP_IF_MODIFIED_SINCE] => Wed, 20 Feb 2019 11:14:29 MSK
    [REDIRECT_UNIQUE_ID] => XS7N8lxhR6fAe1e1o5XVKQAAA8E
    [REDIRECT_STATUS] => 200
    [UNIQUE_ID] => XS7N8lxhR6fAe1e1o5XVKQAAA8E
    [SERVER_SIGNATURE] => 
    [SERVER_SOFTWARE] => Apache
    [SERVER_NAME] => panorama.zed.ro
    [SERVER_ADDR] => 174.142.221.104
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 54.162.151.77
    [DOCUMENT_ROOT] => /home/pzsnetc/public_html/panorama.zed.ro
    [REQUEST_SCHEME] => http
    [CONTEXT_PREFIX] => 
    [CONTEXT_DOCUMENT_ROOT] => /home/pzsnetc/public_html/panorama.zed.ro
    [SERVER_ADMIN] => webmaster@panorama-zed-ro.pzsnet.com
    [SCRIPT_FILENAME] => /home/pzsnetc/public_html/panorama.zed.ro/index.php
    [REMOTE_PORT] => 34002
    [REDIRECT_URL] => /hu/poze_camere
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => 
    [REQUEST_URI] => /hu/poze_camere
    [SCRIPT_NAME] => /index.php
    [PHP_SELF] => /index.php
    [REQUEST_TIME] => 1563348466
    [argv] => Array
        (
        )

    [argc] => 0
)

$_SESSION

Array
(
)

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

id	code	language
2	hu	Hungarian