Pomoc

Blue Flower

1.Obsługa cennika

2.Obsługa listy pokoi

3.Konfiguracja grafiku

4.Obsługa rezerwacji

4a. Dodawanie nowej rezerwacji
    - Podaj imię i nazwisko, email(opcjonalne) i numer telefonu osoby składającej rezerwację, datę przyjazdu i datę wyjazdu, liczbę dorosłych, liczbę dzieci oraz liczbę zwierząt domowych
    - Z rozwijanego menu wybierz wysokości opłaty za pobyt dorosłego
    - Jeśli podana liczba dzieci jest większa niż 0, z rozwijanego menu wybierz typ ceny za pobyt. Dla każdego dziecka oddzielnie!
    - Jeśli podana liczba zwierząt domowych jest większa niż 0, z rozwijanego menu wybierz typ ceny za pobyt. Dla każdego zwierzęcia oddzielnie!
    - Jeśli klientowi przysługuje rabat, wybierz wysokość z rozwijanego menu. Jeśli rabat nie przysługuje klientowi, pozostaw 0
    - Łączna opłata za dobę zostanie uzupełniona automatycznie, na podstawie cennika
    - Całkowita opłata za pobyt zostanie uzpełniona automatycznie, na podstawie cennika
    - Wysokość przedpłaty zostanie uzupełniona automatycznie, na podstawie cennika
    - Pole dodatkowe informacje, jest opcjonalne. Jeśli nie ma potrzeby podawania dodatkowych informacji, proszę pozostawić to pole puste

4b.Edycja rezerwacji

4c.Usuwanie rezerwacji

5.Obsługa księgi meldunkowej

5a.Dodawanie nowego wpisu

5b.Edycja wpisów

5c.Usuwanie wpisów

6.Obsługa rachunków

6a.Wystawianie nowego rachunku

6b.Edycja rachunków

6c.Usuwanie rachunków z listy

7.Obsługa czarnej listy gości

Konsola diagnostyczna Joomla!

17 zapytań zarejestrowanych 22.2 ms

Czas zapytania: 1.13 ms
```
SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = '07fqd0c8tvmcu0k8ej3k3iuvd4'
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT `data` FROM `jos_session` WHERE `session_id` = '07fqd0c8tvmcu0k8ej3k3iuvd4'
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:652
JROOT/libraries/joomla/session/session.php:589
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:52
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 0.86 ms Po ostatnim zapytaniu: 6.66 ms
```
SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = '07fqd0c8tvmcu0k8ej3k3iuvd4' 
  LIMIT 0, 1
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT `session_id` FROM `jos_session` WHERE `session_id` = '07fqd0c8tvmcu0k8ej3k3iuvd4' LIMIT 0, 1
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:52
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 2.56 ms Po ostatnim zapytaniu: 0.15 ms
```
INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('07fqd0c8tvmcu0k8ej3k3iuvd4', 0, '1714171484')
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('07fqd0c8tvmcu0k8ej3k3iuvd4', 0, '1714171484')
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:52
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 0.35 ms Po ostatnim zapytaniu: 7.50 ms
```
SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:466
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 0.31 ms Po ostatnim zapytaniu: 0.55 ms
```
SELECT id, rules

  FROM `jos_viewlevels`
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT id, rules FROM `jos_viewlevels`
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:466
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 2.41 ms Po ostatnim zapytaniu: 24.29 ms
```
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 0.39 ms Po ostatnim zapytaniu: 13.56 ms
```
SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.rules FROM jos_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:397
JROOT/plugins/system/sourcerer/helper.php:73
JROOT/plugins/system/sourcerer/sourcerer.php:95
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 0.37 ms Po ostatnim zapytaniu: 1.14 ms
```
SELECT b.rules

  FROM jos_assets AS a

  LEFT JOIN jos_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE (a.id = 1)

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:406
JROOT/plugins/system/sourcerer/helper.php:73
JROOT/plugins/system/sourcerer/sourcerer.php:95
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 2.26 ms Po ostatnim zapytaniu: 1.62 ms
```
UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"2db2589919c27881a5cbf96e0517468f\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"2db2589919c27881a5cbf96e0517468f\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:29
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 0.30 ms Po ostatnim zapytaniu: 14.90 ms
```
SELECT b.rules

  FROM jos_assets AS a

  LEFT JOIN jos_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:406
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 2.95 ms Po ostatnim zapytaniu: 0.76 ms
```
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  on c.id = a.catid

  LEFT JOIN jos_users AS u 
  on u.id = a.created_by

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 25 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 22:44:44') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 22:44:44') 
  AND (a.state = 1 OR a.state =2)
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 25 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 22:44:44') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 22:44:44') AND (a.state = 1 OR a.state =2)
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/components/com_content/models/article.php:159
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 0.29 ms Po ostatnim zapytaniu: 2.66 ms
```
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=2 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=2 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/components/com_content/views/article/view.html.php:71
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 1.14 ms Po ostatnim zapytaniu: 1.69 ms
```
SELECT `m`.`tag_id`,`t`.*

  FROM `jos_contentitem_tag_map` AS m 

  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 25 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS m INNER JOIN `jos_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 25 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 2.03 ms Po ostatnim zapytaniu: 4.34 ms
```
SHOW FULL COLUMNS 
  FROM `jos_content`
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `jos_content`
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 1.01 ms Po ostatnim zapytaniu: 3.39 ms
```
SELECT *

  FROM jos_content

  WHERE `id` = '25'
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_content WHERE `id` = '25'
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 2.03 ms Po ostatnim zapytaniu: 0.26 ms
```
UPDATE jos_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '25'
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE jos_content SET `hits` = (`hits` + 1) WHERE `id` = '25'
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_content/models/article.php:266
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]
Czas zapytania: 1.82 ms Po ostatnim zapytaniu: 12.14 ms
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jos_modules AS m

  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-26 22:44:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 22:44:44') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 130 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering
```
Objaśnienie
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-26 22:44:44') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 22:44:44') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 130 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
Profile
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
Stos wywołania
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/templates/protostar/index.php:49
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:55
[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

16 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

2 × SELECT b.rules 
  FROM jos_assets AS a 
  LEFT JOIN jos_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jos_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM jos_categories as c 
  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM jos_content
```

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jos_contentitem_tag_map` AS m  
  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT a.rules 
  FROM jos_assets AS a

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT b.id 
  FROM jos_usergroups AS a 
  LEFT JOIN jos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `data` 
  FROM `jos_session`

INNE tabele:

1 × UPDATE jos_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `jos_content

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"2db2589919c27881a5cbf96e0517468f\"}'

1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('07fqd0c8tvmcu0k8ej3k3iuvd4', 0, '1714171484'

Pomoc

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

17 zapytań zarejestrowanych 22.2 ms

16 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

INNE tabele: