Adóreform Könyvelő és Adótanácsadó KFT.

Adóreform Könyvelő és Adótanácsadó KFT

Adóreform Könyvelő és Adótanácsadó KFT

Adóreform Könyvelő és Adótanácsadó KFT

Adóreform Könyvelő és Adótanácsadó KFT

Adóreform Könyvelő és Adótanácsadó KFT

Kezdőlap Rólunk

Bemutatkozás

Irodánk 1988 óta működik. Tevékenységünk az adótörvényekkel együtt fejlődött, vonzáskörzetünkben az egyik legismertebb könyvelő iroda vagyunk. Tevékenységünket 2330. Dunaharaszti, Fő út 250. szám alatti saját tulajdonú irodaépületében végezzük.

Ügyfeleink részére a számvitel területén teljes körű szolgáltatást vállalunk. Megbízásuk alapján készítjük a könyvvezetést, bérszámfejtést, statisztikákat, időszaki jelentéseket, adóbevallásokat. A könyvvizsgáló kamaránál bejegyzett tagunk a könyvvizsgálati szolgáltatást végez.

Társaságunk alapító tagja a Magyar Adótanácsadók Országos Egyesületének, tagja a Számviteli Szakemberek Országos Egyesülete Pest Megyei szervezetének. Nagy hangsúlyt fektetünk folyamatos szakmai továbbfejlődésünkre, ezért tanfolyamokon, konferenciákon továbbképzéseken veszünk részt. Alkalmazottaink száma 2015.-ban 12 fő. Munkatársaink között tudhatunk két könyvvizsgálót, több közgazdászt, adótanácsadókat, mérlegképes könyvelőket és munkaügyi-társadalombiztosítási ügyintézőket.

Jogi és pályázatíró hátteret építettünk ki, és ami a legfontosabb egy ügyfél tekintetében 15 millió Ft keretig teljes körű felelősség-biztosítással rendelkezünk.

Célkitűzéseink

magas szakmai színvonal
állandó felkészültség
gyorsaság
igényes környezet
baráti hangvétel, tiszteletteljes kommunikáció
a teendők közérthető megbeszélése a szakzsargon mellőzésével
személyre szabott tájékoztatás a várható helyzetekről, változásokról
az adminisztratív teendők teljeskörű elvégzése
ügyfeleink folyamatos informálása

Filozófiánk

Ügyfélkapcsolatunk alappillérei : a kölcsönös tisztelet, a bizalom, és a szoros együttműködés.

Erősségünk abban áll, hogy fő stratégiai céljaink a szakszerűség , a megbízhatóság és pontosság érdekében vállalkozásunkat építve 27 éve folyamatosan e fejlődési irányba haladva dolgozunk. Társaságunk kollektívájában és az alapítástól változatlan vezetés biztosítéka a megbízható, magas szakmai színvonalú munkának és a korrekt együttműködésnek.

Partner vállalkozások

Dr Rohonczi Anita ügyvéd
Telefonszám: 36 20 917 7017
E-mail cím:Ez az e-mail cím a spamrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát.

Sándor Józsefné
kamarai tag könyvvizsgáló
E-mail cím: Ez az e-mail cím a spamrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát.
Telefonszám: 30/530-77-70

Lubik Magdolna Eszter
kamarai tag könyvvizsgáló
E-mail cím: Ez az e-mail cím a spamrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát.
Telefonszám: 30/929-32-69

Joomla! hibakereső konzol

21 naplózott lekérdezés 40.5 ms

Query Time: 0.27 ms Query memory: 0.012 MB Memory before query: 2.681 MB Rows returned: 0
```
SELECT `session_id`

  FROM `p9vnz_session`

  WHERE `session_id` = 'qea6m5c5t6alakiq669asqrdi7' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `p9vnz_session` WHERE `session_id` = 'qea6m5c5t6alakiq669asqrdi7' LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.73 ms After last query: 0.14 ms Query memory: 0.009 MB Memory before query: 2.694 MB
```
INSERT INTO `p9vnz_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('qea6m5c5t6alakiq669asqrdi7', 0, '1726004944')
```
Explain
EXPLAIN not possible on query: INSERT INTO `p9vnz_session` (`session_id`, `client_id`, `time`) VALUES ('qea6m5c5t6alakiq669asqrdi7', 0, '1726004944')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.48 ms After last query: 4.70 ms Query memory: 0.017 MB Memory before query: 3.062 MB Rows returned: 32
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM p9vnz_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM p9vnz_extensions WHERE `type` = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.42 ms After last query: 1.76 ms Query memory: 0.014 MB Memory before query: 3.204 MB Rows returned: 2
```
SELECT b.id

  FROM p9vnz_usergroups AS a

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

  WHERE a.id = 9
```
Explain
EXPLAIN not possible on query: SELECT b.id FROM p9vnz_usergroups AS a LEFT JOIN p9vnz_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.91 ms After last query: 0.65 ms Query memory: 0.013 MB Memory before query: 3.260 MB Rows returned: 4
```
SELECT id, rules

  FROM `p9vnz_viewlevels`
```
Explain
EXPLAIN not possible on query: SELECT id, rules FROM `p9vnz_viewlevels`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.68 ms After last query: 0.19 ms Query memory: 0.013 MB Memory before query: 3.278 MB Rows returned: 52
```
SELECT folder AS type, element AS name, params

  FROM p9vnz_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering
```
Explain
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM p9vnz_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.70 ms After last query: 8.47 ms Query memory: 0.016 MB Memory before query: 3.507 MB Rows returned: 1
```
SELECT *

  FROM p9vnz_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN not possible on query: SELECT * FROM p9vnz_languages WHERE published=1 ORDER BY ordering ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/plugins/system/languagefilter/languagefilter.php:62
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.59 ms After last query: 1.43 ms Query memory: 0.013 MB Memory before query: 3.554 MB Rows returned: 2
```
SELECT a.element AS element

  FROM p9vnz_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM p9vnz_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:73
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.29 ms After last query: 21.91 ms Query memory: 0.030 MB Memory before query: 4.564 MB Rows returned: 7
```
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 p9vnz_menu AS m

  LEFT JOIN p9vnz_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
```
Explain
EXPLAIN not possible on query: 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 p9vnz_menu AS m LEFT JOIN p9vnz_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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/plugins/system/languagefilter/languagefilter.php:100
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:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.69 ms After last query: 8.32 ms Query memory: 0.024 MB Memory before query: 5.183 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM p9vnz_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM p9vnz_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/cachecleaner/cachecleaner.php:39
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.26 ms After last query: 2.25 ms Query memory: 0.017 MB Memory before query: 5.291 MB
```
UPDATE `p9vnz_extensions`

  SET `params` = '{\"mediaversion\":\"d42f04c322935791f6cee37a9abb1ff9\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `p9vnz_extensions` SET `params` = '{\"mediaversion\":\"d42f04c322935791f6cee37a9abb1ff9\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/cachecleaner/cachecleaner.php:39
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.81 ms After last query: 8.06 ms Query memory: 0.010 MB Memory before query: 5.684 MB Rows returned: 3
```
SELECT id, home, template, s.params

  FROM p9vnz_template_styles as s

  LEFT JOIN p9vnz_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT id, home, template, s.params FROM p9vnz_template_styles as s LEFT JOIN p9vnz_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/application/site.php:165
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.77 ms After last query: 10.23 ms Query memory: 0.024 MB Memory before query: 6.455 MB Rows returned: 1
```
SELECT a.rules

  FROM p9vnz_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
EXPLAIN not possible on query: SELECT a.rules FROM p9vnz_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
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/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.01 ms After last query: 1.08 ms Query memory: 0.025 MB Memory before query: 6.513 MB Rows returned: 2
```
SELECT b.rules

  FROM p9vnz_assets AS a

  LEFT JOIN p9vnz_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
```
Explain
EXPLAIN not possible on query: SELECT b.rules FROM p9vnz_assets AS a LEFT JOIN p9vnz_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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
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/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 6.46 ms After last query: 0.69 ms Query memory: 0.051 MB Memory before query: 6.559 MB Rows returned: 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 p9vnz_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM p9vnz_categories AS cat JOIN p9vnz_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.language in ('hu-HU','*') 
  AND a.id = 4 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-10 21:49:04') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-10 21:49:04') 
  AND (a.state = 1 OR a.state =2)
```
Explain
EXPLAIN not possible on query: 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 p9vnz_content AS a LEFT JOIN p9vnz_categories AS c on c.id = a.catid LEFT JOIN p9vnz_users AS u on u.id = a.created_by LEFT JOIN p9vnz_categories as parent ON parent.id = c.parent_id LEFT JOIN p9vnz_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM p9vnz_categories AS cat JOIN p9vnz_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.language in ('hu-HU','*') AND a.id = 4 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-10 21:49:04') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-10 21:49:04') AND (a.state = 1 OR a.state =2)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.99 ms After last query: 8.59 ms Query memory: 0.027 MB Memory before query: 6.815 MB Rows returned: 2
```
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 p9vnz_categories as c

  LEFT JOIN p9vnz_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 p9vnz_categories AS cat JOIN p9vnz_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
```
Explain
EXPLAIN not possible on query: 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 p9vnz_categories as c LEFT JOIN p9vnz_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 p9vnz_categories AS cat JOIN p9vnz_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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 4.42 ms After last query: 5.23 ms Query memory: 0.024 MB Memory before query: 7.157 MB Rows returned: 0
```
SELECT `m`.`tag_id`,`t`.*

  FROM `p9vnz_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 4 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)
```
Explain
EXPLAIN not possible on query: SELECT `m`.`tag_id`,`t`.* FROM `p9vnz_contentitem_tag_map` AS m INNER JOIN `p9vnz_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 4 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.38 ms After last query: 8.43 ms Query memory: 0.027 MB Memory before query: 7.638 MB Rows returned: 30
```
SHOW FULL COLUMNS 
  FROM `p9vnz_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `p9vnz_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.67 ms After last query: 3.49 ms Query memory: 0.026 MB Memory before query: 7.829 MB Rows returned: 1
```
SELECT *

  FROM p9vnz_content

  WHERE `id` = '4'
```
Explain
EXPLAIN not possible on query: SELECT * FROM p9vnz_content WHERE `id` = '4'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.12 ms After last query: 0.24 ms Query memory: 0.016 MB Memory before query: 7.868 MB
```
UPDATE p9vnz_content

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

  WHERE `id` = '4'
```
Explain
EXPLAIN not possible on query: UPDATE p9vnz_content SET `hits` = (`hits` + 1) WHERE `id` = '4'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/legacy/controller/legacy.php:690
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.89 ms After last query: 20.38 ms Query memory: 0.021 MB Memory before query: 8.448 MB Rows returned: 7
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM p9vnz_modules AS m

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

  LEFT JOIN p9vnz_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-09-10 21:49:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-10 21:49:04') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 106 OR mm.menuid <= 0) 
  AND m.language IN ('hu-HU','*')

  ORDER BY m.position, m.ordering
```
Explain
EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM p9vnz_modules AS m LEFT JOIN p9vnz_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN p9vnz_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-09-10 21:49:04') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-10 21:49:04') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 106 OR mm.menuid <= 0) AND m.language IN ('hu-HU','*') ORDER BY m.position, m.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
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/ajt004_j30/functions.php:3
JROOT/templates/ajt004_j30/index.php:18
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:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

20 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM p9vnz_extensions

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 p9vnz_content AS a 
  LEFT JOIN p9vnz_categories AS c 
  on c.id = a.catid 
  LEFT JOIN p9vnz_users AS u 
  on u.id = a.created_by 
  LEFT JOIN p9vnz_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN p9vnz_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM p9vnz_categories AS cat JOIN p9vnz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT b.rules 
  FROM p9vnz_assets AS a 
  LEFT JOIN p9vnz_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.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 p9vnz_categories as c 
  LEFT JOIN p9vnz_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 p9vnz_categories AS cat JOIN p9vnz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM p9vnz_content
```

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

1 × SELECT a.rules 
  FROM p9vnz_assets AS a

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

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 p9vnz_menu AS m 
  LEFT JOIN p9vnz_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, rules 
  FROM `p9vnz_viewlevels

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

1 × SELECT folder AS type, element AS name, params 
  FROM p9vnz_extensions

```
1 × SELECT * 
  FROM p9vnz_languages
```

1 × SELECT `session_id` 
  FROM `p9vnz_session`

1 × SELECT a.element AS element 
  FROM p9vnz_extensions AS a

1 × SELECT id, home, template, s.params 
  FROM p9vnz_template_styles as s 
  LEFT JOIN p9vnz_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

EGYÉB táblák:

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

1 × SHOW FULL COLUMNS 
  FROM `p9vnz_content

1 × UPDATE `p9vnz_extensions` 
  SET `params` = '{\"mediaversion\":\"d42f04c322935791f6cee37a9abb1ff9\"}'

1 × INSERT INTO `p9vnz_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('qea6m5c5t6alakiq669asqrdi7', 0, '1726004944'

Hívjon minket! 0624470301

Célkitűzéseink

Filozófiánk

Partner vállalkozások

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Time

Memory

Memóriahasználat

Adatbázis lekérdezések

21 naplózott lekérdezés 40.5 ms

20 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

EGYÉB táblák: