Gyémántfúrók fúrógéphez

Gyémántfúróink 2 minőségi kategóriában kaphatóak, a prémium minőségű Diatech és a barkács kategóriájú Maxon márkajelzés alatt.

További kategóriák

Maxon gyémántfúrók fúrógéphez

A PHP Error was encountered

Severity: Notice

Message: Undefined index: cms_webaruhaz_data

Filename: sysplugins/smarty_internal_templatebase.php(157) : eval()'d code

Line Number: 69

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: sysplugins/smarty_internal_templatebase.php(157) : eval()'d code

Line Number: 69

text-warning"> Maxon gyémántfúrók fúrógéphez

Adapterek fúrógéphez

A PHP Error was encountered

Severity: Notice

Message: Undefined index: cms_webaruhaz_data

Filename: sysplugins/smarty_internal_templatebase.php(157) : eval()'d code

Line Number: 69

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: sysplugins/smarty_internal_templatebase.php(157) : eval()'d code

Line Number: 69

text-warning"> Adapterek fúrógéphez

A PHP Error was encountered

Severity: Notice

Message: ob_get_clean(): failed to discard buffer of zlib output compression (1)

Filename: sysplugins/smarty_internal_templatebase.php

Line Number: 217

A PHP Error was encountered

Severity: Notice

Message: ob_get_clean(): failed to delete buffer of zlib output compression (1)

Filename: sysplugins/smarty_internal_templatebase.php

Line Number: 217

A PHP Error was encountered

Severity: Notice

Message: ob_get_clean(): failed to discard buffer of zlib output compression (1)

Filename: sysplugins/smarty_internal_templatebase.php

Line Number: 217

A PHP Error was encountered

Severity: Notice

Message: ob_get_clean(): failed to delete buffer of zlib output compression (1)

Filename: sysplugins/smarty_internal_templatebase.php

Line Number: 217

A PHP Error was encountered

Severity: Notice

Message: ob_get_clean(): failed to discard buffer of zlib output compression (1)

Filename: sysplugins/smarty_internal_templatebase.php

Line Number: 217

A PHP Error was encountered

Severity: Notice

Message: ob_get_clean(): failed to delete buffer of zlib output compression (1)

Filename: sysplugins/smarty_internal_templatebase.php

Line Number: 217

BENCHMARKS

Loading Time: Base Classes	0.0367
Controller Execution Time ( Dc Diatechweb2 / Index )	1.6317
Total Execution Time	1.6685

GET DATA

No GET data exists

MEMORY USAGE

46,148,280 bytes

POST DATA

No POST data exists

URI STRING

gyemantfurok/gyemantfurok-furogephez

CLASS/METHOD

dc_diatechweb2/index

DATABASE: diatech_szamladev QUERIES: 65 (Show)

0.0013	SELECT `beall_nev`, `beall_tipus`, `beall_ertek` FROM (`us_Beallitas`) WHERE `beall_aktiv` = '1'
0.0034	INSERT INTO `us_CISession` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('b175286b005c5a0a4813644c4071a29b', '216.73.216.172', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1773455873, '')
0.0045	SELECT `st_azon`, `st_nev`, `st_modnev`, `st_modositva` FROM (`us_SmartyTemplate`) ORDER BY `st_nev`
0.0013	SELECT `mod_kod` FROM (`us_Modul`) WHERE `mod_nev` IN ('query', 'installer', 'system', 'grid', 'torzsadat', 'partner', 'onlineszamla', 'szamla', 'koltsegszamla', 'raktar', 'rendeles', 'cmsadmin', 'diatechweb', 'diatechweb2', 'webaruhaz', 'webaruhaz2', 'szamlaraktarprg', 'htmleditor', 'tpleditor')
0.0039	UPDATE `us_CISession` SET `last_activity` = 1773455873, `user_data` = 'Pcw7CoAwEIThq8j2QsxTJ4eRRRcMaGGihYh391FYTfPNzzA4CzrQXiT3I29MsUCB3mkcaN0lH/3AwyRbWoRiQhOCsc61wb7G/2YWzh/8vk9TK21qZWvdVg8zCs5TvG4=' WHERE `session_id` = 'b175286b005c5a0a4813644c4071a29b'
0.0010	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'system' AND `ford_nyelvkod` = 0
0.0011	SELECT `mod_kod` FROM (`us_Modul`) WHERE `mod_nev` IN ('query', 'installer', 'system', 'grid', 'torzsadat', 'partner', 'onlineszamla', 'szamla', 'koltsegszamla', 'raktar', 'rendeles', 'cmsadmin', 'diatechweb', 'diatechweb2', 'webaruhaz', 'webaruhaz2', 'szamlaraktarprg', 'htmleditor', 'tpleditor')
0.0010	SELECT `mod_kod`, `mod_nev` FROM (`us_Modul`) ORDER BY `mod_sorrend` ASC, `mod_nev` ASC
0.0008	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'system' AND `ford_nyelvkod` = 0
0.0012	SELECT `mod_kod`, `mod_nev` FROM (`us_Modul`) ORDER BY `mod_sorrend` ASC, `mod_nev` ASC
0.0008	SELECT `mod_kod` FROM (`us_Modul`) WHERE `mod_nev` IN ('query', 'installer', 'system', 'grid', 'torzsadat', 'partner', 'onlineszamla', 'szamla', 'koltsegszamla', 'raktar', 'rendeles', 'cmsadmin', 'diatechweb', 'diatechweb2', 'webaruhaz', 'webaruhaz2', 'szamlaraktarprg', 'htmleditor', 'tpleditor')
0.0026	SELECT *, jog_nev as jog_fordnev FROM (`us_Jogosultsag`) WHERE `jog_aktiv` = '1'
0.0017	SELECT * FROM (`us_CsoportJogosultsag`) JOIN `us_Jogosultsag` ON `jog_azon`=`csopjog_jogazon` WHERE `jog_aktiv` = '1' AND `csopjog_aktiv` = '1' AND `jog_modnev` IN ('query', 'installer', 'system', 'grid', 'torzsadat', 'partner', 'onlineszamla', 'szamla', 'koltsegszamla', 'raktar', 'rendeles', 'cmsadmin', 'diatechweb', 'diatechweb2', 'webaruhaz', 'webaruhaz2', 'szamlaraktarprg', 'htmleditor', 'tpleditor') AND `csopjog_csopazon` = 0
0.0057	SELECT *, IF(ford_szoveg IS NULL, rm_nev, ford_szoveg) as rm_fordnev FROM (`us_RendszerMenu`) LEFT JOIN `us_Jogosultsag` ON `rm_hivatkozas`=`jog_hivatkozas` LEFT JOIN `us_Forditas` ON `ford_kulcs` = CONCAT(rm_hivatkozas, '__title') AND ford_nyelvkod = '' WHERE `rm_aktiv` = '1' AND `rm_modnev` IN ('query', 'installer', 'system', 'grid', 'torzsadat', 'partner', 'onlineszamla', 'szamla', 'koltsegszamla', 'raktar', 'rendeles', 'cmsadmin', 'diatechweb', 'diatechweb2', 'webaruhaz', 'webaruhaz2', 'szamlaraktarprg', 'htmleditor', 'tpleditor') AND `rm_csoport` = 'system' ORDER BY `rm_sorrend`
0.0012	SELECT * FROM (`us_RendszerParameter`) WHERE `rp_modnev` IN ('query', 'installer', 'system', 'grid', 'torzsadat', 'partner', 'onlineszamla', 'szamla', 'koltsegszamla', 'raktar', 'rendeles', 'cmsadmin', 'diatechweb', 'diatechweb2', 'webaruhaz', 'webaruhaz2', 'szamlaraktarprg', 'htmleditor', 'tpleditor') AND `rp_aktiv` = 1 AND `rp_nev` IS NULL AND `rp_tipus` = 'PHP' AND `rp_modnev` = 'grid' AND `rp_kategoria` = 'grid' AND `rp_parameter` = 'gridview' ORDER BY `rp_nev` LIMIT 1
0.0041	UPDATE `us_CISession` SET `last_activity` = 1773455873, `user_data` = 'PYzLCoMwEEV/pcxeiHkYO/mYMOhUhVhoHguR/nuTLLq6cO65l1DjnfCJUBJHv1ImcAkFQovRIHwKx8svtOycj5PBHThaq7Qxs9XNmf5OYIpd7Nv6KYVUg9CDnB9VUwLN1CuJsPKLSsg+0HtrrKK9gPv+AA==' WHERE `session_id` = 'b175286b005c5a0a4813644c4071a29b'
0.0009	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'torzsadat' AND `ford_nyelvkod` = 'hu'
0.0010	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'szamla' AND `ford_nyelvkod` = 'hu'
0.0010	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'cmsadmin' AND `ford_nyelvkod` = 'hu'
0.0009	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'system' AND `ford_nyelvkod` = 'hu'
0.0012	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'rendeles' AND `ford_nyelvkod` = 'hu'
0.0010	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'partner' AND `ford_nyelvkod` = 'hu'
0.0039	SELECT * FROM (`us_Webaruhaz`) JOIN `us_SzamlaKibocsato` ON `web_szkazon`=`szk_azon` JOIN `us_Deviza` ON `dev_kod`=`web_devkod` JOIN `us_Nyelv` ON `nyelv_kod`=`web_nyelvkod` JOIN `us_Orszag` ON `web_orszkod`=`orsz_kod` LEFT JOIN `us_FizetesiMod` ON `web_fmazon`=`fm_azon` LEFT JOIN `us_HaziPenztar` ON `web_hpazon`=`hp_azon` LEFT JOIN `us_KoltsegHely` ON `web_khazon`=`kh_azon` LEFT JOIN `us_Arlista` ON `web_arlazon`=`arl_azon` LEFT JOIN `us_Raktar` ON `web_rakazon`=`rak_azon` LEFT JOIN `us_SzallitasiMod` ON `web_szmazon`=`szm_azon` LEFT JOIN `us_RendelesiMod` ON `web_rmazon`=`rm_azon` LEFT JOIN `us_SzamlaKibocsatoCim` ON `web_szkcazon`=`szkc_azon` LEFT JOIN `us_KapcsolatTipus` ON `web_ktazon`=`kt_azon` LEFT JOIN `us_TermekSzolgaltatas` ON `web_tszazon`=`tsz_azon` LEFT JOIN `us_RendelesWebaruhazAllapot` ON `web_rwaazon`=`rwa_azon` LEFT JOIN `us_SzamlaTomb` ON `web_sztazon`=`szt_azon` WHERE `web_aktiv` = 1 AND `web_domain` LIKE '%www.szamla-dev.diatech.hu' ORDER BY `web_nev` ASC LIMIT 1
0.0009	SELECT DISTINCT tszo_tszazon FROM (`us_TermekSzolgaltatasOpcio`) WHERE `tszo_aktiv` = '1'
0.0012	SELECT *, CONCAT(mod_nev, ': ', mod_leiras) as mod_megnevezes, CONCAT('v', mod_verzio) as mod_verzioszam FROM (`us_Modul`) WHERE `mod_nev` IN ('query', 'installer', 'system', 'grid', 'torzsadat', 'partner', 'onlineszamla', 'szamla', 'koltsegszamla', 'raktar', 'rendeles', 'cmsadmin', 'diatechweb', 'diatechweb2', 'webaruhaz', 'webaruhaz2', 'szamlaraktarprg', 'htmleditor', 'tpleditor')
0.0039	UPDATE `us_CISession` SET `last_activity` = 1773455873, `user_data` = 'PYzNCsMgEAZfpXgv+LdqNg8jG2MbIUlpjIdQ+u5VDz0tzMy3hICfjAOykuPhZzqJjRk5snYEIHuXeFw+UFjimbbIxoTCWqUBnNWtMf9mjXT0sG/rT8mlunN9l+5WM8URTFcS2RwfVNbTr7Q/G6toKV0qZNvlc8w5vXaf5gZV1ZOwIJ2ZOIcAxEk7oYzWQXMrSA4TG78/' WHERE `session_id` = 'b175286b005c5a0a4813644c4071a29b'
0.0009	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'webaruhaz2' AND `ford_nyelvkod` = 'hu'
0.0012	SELECT *, CONCAT(nyelv_nev, ' (', nyelv_angolnev, ')') as nyelv_megnevezes, nyelv_kod as azon, CONCAT(nyelv_kod, ' - ', nyelv_nev) as nev FROM (`us_Nyelv`) WHERE `nyelv_aktiv` = '1' AND `nyelv_kiemelt` = '1' ORDER BY `nyelv_sorrend`
0.0038	SELECT * FROM (`us_TermekSzolgaltatasCsoport`) WHERE `tszcs_aktiv` = '1' AND `tszcs_tiltott` = '0' AND `tszcs_web` = '1' AND tszcs_web_seonev IS NOT NULL ORDER BY `tszcs_tszcsazon` ASC, `tszcs_web_sorrend` ASC, `tszcs_web_nev` ASC
0.0045	SELECT * FROM (`us_CmsFajlFeltoltes`) WHERE `cff_modnev` = 'szamla' AND `cff_csoport` = 'termekszolgaltatascsoport' AND `cff_hivatkozas` IN (169, 3, 159, 172, 188, 178, 195, 191, 118, 190, 189, 134, 246, 230, 229, 231, 232, 233, 196, 198, 200, 199, 204, 207, 211, 215, 224, 110, 114, 113, 239, 24, 133, 187, 135, 136, 137, 125, 126, 127, 20, 122, 123, 124, 141, 128, 129, 192, 163, 241, 243, 240, 242, 250, 249, 245, 234, 235, 236, 171, 148, 173, 29, 238, 103, 102, 18, 6, 45, 130, 115, 11, 117, 247, 167, 17, 5, 44, 170, 100, 146, 41, 194, 193, 116, 10, 138, 143, 16, 248, 166, 40, 174, 89, 145, 160, 168, 244, 201, 202, 203, 205, 206, 209, 208, 210, 212, 213, 214, 228, 216, 217, 218, 219, 220, 222, 223, 225, 226, 227) ORDER BY `cff_sorrend` ASC
0.0015	SELECT * FROM (`us_TermekSzolgaltatasCsoportTulajdonsag`) JOIN `us_TermekSzolgaltatasCsoport` ON `tszcs_azon`=`tszcst_tszcsazon` JOIN `us_Nyelv` ON `nyelv_kod`=`tszcst_nyelvkod` WHERE `tszcs_aktiv` = '1' AND `tszcs_web` = '1' AND `tszcs_tiltott` = '0' AND `tszcst_nyelvkod` = 'hu' ORDER BY `tszcst_csoport` ASC, `tszcst_seonev` ASC
0.0045	SELECT *, IF(cmh_azon IS NOT NULL, CONCAT(nyelv_nev, ' (', nyelv_angolnev, ')'), '-') as nyelv_megnevezes, IF(cmh_azon IS NOT NULL, CONCAT(mod_nev, ': ', mod_leiras), '-') as mod_megnevezes FROM (`us_CmsMenuPont_Nezet`) WHERE `cmp_aktiv` = '1' AND `cmp_bejelentkezes` = '0' AND `cmh_seonev` IN ('diatechweb2_topmenu', 'topmenu', 'diatechweb2_rightmenu', 'rightmenu', 'diatechweb2_leftmenu', 'leftmenu', 'diatechweb2_bottommenu', 'bottommenu') ORDER BY `cmp_sorrend` ASC, `cmp_nev` ASC
0.0021	SELECT *, IF(cmh_azon IS NOT NULL, CONCAT(nyelv_nev, ' (', nyelv_angolnev, ')'), '-') as nyelv_megnevezes, IF(cmh_azon IS NOT NULL, CONCAT(mod_nev, ': ', mod_leiras), '-') as mod_megnevezes FROM (`us_CmsMenuPont_Nezet`) WHERE `cmp_aktiv` = '1' AND `cmp_bejelentkezes` = '0' AND `cmp_cmhazon` IS NULL ORDER BY `cmp_sorrend` ASC, `cmp_nev` ASC
0.0014	SELECT * FROM (`us_RendszerParameter`) WHERE `rp_aktiv` = '1' AND `rp_nev` = 'telefon' AND `rp_modnev` = 'webaruhaz' AND `rp_kategoria` = 'template' AND `rp_parameter` = 'variable' ORDER BY `rp_nev` LIMIT 1
0.0014	SELECT * FROM (`us_RendszerParameter`) WHERE `rp_aktiv` = '1' AND `rp_nev` = 'contact_url' AND `rp_modnev` = 'webaruhaz' AND `rp_kategoria` = 'template' AND `rp_parameter` = 'variable' ORDER BY `rp_nev` LIMIT 1
0.0010	SELECT * FROM (`us_WebaruhazKupon`) JOIN `us_Deviza` ON `wk_devkod`=`dev_kod` WHERE `wk_aktiv` = '1' AND (wk_ervenyesseg_kezdete IS NULL OR wk_ervenyesseg_kezdete<NOW()) AND (wk_ervenyesseg_vege IS NULL OR wk_ervenyesseg_vege>NOW()) ORDER BY `wk_nev`
0.0008	SELECT *, CONCAT(orsz_nev, ' (', orsz_angolnev, ')') as orsz_megnevezes, orsz_kod as azon, CONCAT(orsz_nev, ' (', orsz_kod, ')') as nev FROM (`us_Orszag`) WHERE `orsz_aktiv` = '1' AND `orsz_kiemelt` = '1' AND `orsz_kod` = 'HU' ORDER BY `orsz_sorrend`
0.0024	SELECT *, CONCAT(orsz_nev, ' (', orsz_angolnev, ')') as orsz_megnevezes FROM (`us_Orszag`) ORDER BY `orsz_nev`
0.0029	SELECT us_Rendeles., us_Deviza., us_FizetesiMod., us_PartnerVerzio., us_SzallitasiMod., us_PartnerCim., us_Orszag., us_RendelesSzallitasiAr., COUNT(rtsz_razon) as tetelekszama, SUM(IF(r_storno_rsazon>0, -1, 1)rtsz_mennyiseg(rtsz_nettoegysegar(1-rtsz_kedvezmeny)-rtsz_tszbekernettoar)) as nettoarres, SUM(IF(r_storno_rsazon>0, -1, 1)rtsz_mennyisegrtsz_nettoegysegar) as listanettoertek, SUM(IF(r_storno_rsazon>0, -1, 1)rtsz_mennyisegrtsz_nettoegysegar(1+rtsz_afakulcs)) as listabruttoertek, SUM(IF(r_storno_rsazon>0, -1, 1)rtsz_mennyisegrtsz_nettoegysegar(1-rtsz_kedvezmeny)) as nettoertek, SUM(IF(r_storno_rsazon>0, -1, 1)rtsz_mennyisegrtsz_nettoegysegar(1-rtsz_kedvezmeny)(1+rtsz_afakulcs)) as bruttoertek, SUM(IF(rtsz_mennyiseg>=rtsz_tenymennyiseg, rtsz_mennyiseg-rtsz_tenymennyiseg, 0)) as rtsz_szallmennyiseg, SUM(rtsz_mennyiseg) as mennyiseg, SUM(rtsz_tenymennyiseg) as tenymennyiseg, SUM(tsz_sulyrtsz_mennyiseg) as suly, us_RendelesWebaruhazAllapot.* FROM (`us_Rendeles`) JOIN `us_FizetesiMod` ON `r_fmazon`=`fm_azon` JOIN `us_Deviza` ON `dev_kod`=`r_devkod` LEFT JOIN `us_RendelesTermekSzolgaltatas` ON `rtsz_razon`=`r_azon` LEFT JOIN `us_TermekSzolgaltatas` ON `rtsz_tszazon`=`tsz_azon` LEFT JOIN `us_PartnerVerzio` ON `r_pazon`=`p_azon` AND p_verzio=r_pverzio LEFT JOIN `us_PartnerCim` ON `pc_azon`=`r_pcazon` LEFT JOIN `us_SzallitasiMod` ON `r_szmazon`=`szm_azon` LEFT JOIN `us_RendelesSzallitasiAr` ON `r_rszaazon`=`rsza_azon` LEFT JOIN `us_Orszag` ON `p_orszkod`=`orsz_kod` LEFT JOIN `us_Raktar` ON `r_rakazon`=`rak_azon` LEFT JOIN `us_RendelesWebaruhazAllapot` ON `rwa_azon`=`r_rwaazon` WHERE `r_zarolva` = '0' AND `r_irany` = 'in' AND `r_sessionid` = 'b175286b005c5a0a4813644c4071a29b' GROUP BY `r_azon` ORDER BY `r_azon` DESC LIMIT 1
0.0011	SELECT * FROM (`us_DiatechAnyag`) WHERE `da_aktiv` = 1 ORDER BY `da_sorrend` ASC, `da_megnevezes` ASC
0.0011	SELECT tsz_azon, tsz_web_regiseonev, tsz_web_seonev, tszcs_web_seoutvonal, tsz_valtozott FROM (`us_TermekSzolgaltatas`) JOIN `us_TermekSzolgaltatasCsoport` ON `tsz_tszcsazon`=`tszcs_azon` WHERE `tsz_aktiv` = '1' AND `tszcs_aktiv` = '1' AND `tszcs_tiltott` = '0' AND `tsz_web` = '1' AND `tszcs_web` = '1' AND (tsz_web_kulso_raktarrol=0 OR tsz_web_kulso_keszleten=1 OR tsz_web_kulso_raktarrol=1 AND tsz_web_kulso_keszleten=0 AND tsz_web_hianykor_elrejt=0) AND `tsz_web_seonev` = 'gyemantfurok/gyemantfurok-furogephez' LIMIT 1
0.0099	SELECT tsz_azon, tsz_web_regiseonev, tsz_web_seonev, tszcs_web_seoutvonal, tsz_valtozott FROM (`us_TermekSzolgaltatas`) JOIN `us_TermekSzolgaltatasCsoport` ON `tsz_tszcsazon`=`tszcs_azon` WHERE `tsz_aktiv` = '1' AND `tszcs_aktiv` = '1' AND `tszcs_tiltott` = '0' AND `tsz_web` = '1' AND `tszcs_web` = '1' AND (tsz_web_kulso_raktarrol=0 OR tsz_web_kulso_keszleten=1 OR tsz_web_kulso_raktarrol=1 AND tsz_web_kulso_keszleten=0 AND tsz_web_hianykor_elrejt=0) AND `tsz_web_regiseonev` = 'gyemantfurok/gyemantfurok-furogephez' LIMIT 1
0.0063	SELECT * FROM (`us_DiatechVagasMinoseg`) JOIN `us_DiatechAnyag` ON `dvm_daazon`=`da_azon` JOIN `us_DiatechGep` ON `dvm_dgazon`=`dg_azon` WHERE `dvm_aktiv` = 1 AND `da_aktiv` = 1 AND `dg_aktiv` = 1 AND `dvm_tszcsazon` = '192' ORDER BY `dg_sorrend` ASC, `dg_nev` ASC, `da_sorrend` ASC, `da_nev` ASC
0.0083	SELECT us_TermekSzolgaltatas., us_TermekSzolgaltatasCsoport., us_AfaKulcs., us_Mertekegyseg., us_Deviza., us_SzallitasiMod., tsz_nettoar(1+ak_mertek) as tsz_bruttoar, tsz_web_reginettoar(1+ak_mertek) as tsz_web_regibruttoar, IF(tsz_bekernettoar>0, (tsz_nettoar-tsz_bekernettoar)/tsz_bekernettoar, 0) as tsz_haszonkulcs1, IF(tsz_bekernettoar>0 AND tsz_nettoar>0, (tsz_nettoar-tsz_bekernettoar)/tsz_nettoar, 0) as tsz_haszonkulcs2, IF(tsz_besorolas IS NULL, tszcs_besorolas, tsz_besorolas) as besorolas FROM (`us_TermekSzolgaltatas`) JOIN `us_TermekSzolgaltatasCsoport` ON `tsz_tszcsazon`=`tszcs_azon` JOIN `us_Deviza` ON `tsz_devkod`=`dev_kod` LEFT JOIN `us_Mertekegyseg` ON `me_azon`=`tsz_meazon` LEFT JOIN `us_AfaKulcs` ON `ak_azon`=IF(tsz_akazon IS NULL, tszcs_akazon, tsz_akazon) LEFT JOIN `us_SzallitasiMod` ON `tsz_web_szmazon`=`szm_azon` WHERE `tsz_aktiv` = '1' AND `tszcs_aktiv` = '1' AND `tszcs_tiltott` = '0' AND `tsz_web` = '1' AND `tszcs_web` = '1' AND (tsz_web_kulso_raktarrol=0 OR tsz_web_kulso_keszleten=1 OR tsz_web_kulso_raktarrol=1 AND tsz_web_kulso_keszleten=0 AND tsz_web_hianykor_elrejt=0) AND `tsz_tszcsazon` = '192' ORDER BY `tsz_web_sorrend` ASC, `tsz_web_nev` ASC, `tsz_nev` ASC
0.0039	SELECT us_TermekSzolgaltatas., us_TermekSzolgaltatasCsoport., us_AfaKulcs., us_Mertekegyseg., tsz_nettoar(1+ak_mertek) as tsz_bruttoar, tsz_web_reginettoar(1+ak_mertek) as tsz_web_regibruttoar, IF(tsz_bekernettoar>0, (tsz_nettoar-tsz_bekernettoar)/tsz_bekernettoar, 0) as tsz_haszonkulcs1, IF(tsz_bekernettoar>0 AND tsz_nettoar>0, (tsz_nettoar-tsz_bekernettoar)/tsz_nettoar, 0) as tsz_haszonkulcs2, IF(tsz_besorolas IS NULL, tszcs_besorolas, tsz_besorolas) as besorolas FROM (`us_TermekSzolgaltatasTermekSzolgaltatasCsoport`) JOIN `us_TermekSzolgaltatas` ON `tsztszcs_tszazon`=`tsz_azon` JOIN `us_TermekSzolgaltatasCsoport` ON `tsztszcs_tszcsazon`=`tszcs_azon` JOIN `us_AfaKulcs` ON `ak_azon`=`tszcs_akazon` LEFT JOIN `us_Mertekegyseg` ON `me_azon`=`tsz_meazon` WHERE `tsz_aktiv` = '1' AND `tszcs_aktiv` = '1' AND `tszcs_tiltott` = '0' AND `tsz_web` = '1' AND `tszcs_web` = '1' AND (tsz_web_kulso_raktarrol=0 OR tsz_web_kulso_keszleten=1 OR tsz_web_kulso_raktarrol=1 AND tsz_web_kulso_keszleten=0 AND tsz_web_hianykor_elrejt=0) AND `tsztszcs_tszcsazon` = '192' ORDER BY `tszcs_web_sorrend` ASC, `tszcs_web_nev` ASC, `tsz_web_sorrend` ASC, `tsz_web_nev` ASC, `tsz_nev` ASC
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/page.tpl'
0.0007	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/page.tpl'
0.0006	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/header.tpl'
0.0006	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/header.tpl'
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/website_schema.tpl'
0.0007	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/website_schema.tpl'
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/topmenu.tpl'
0.0013	SELECT `ford_kulcs`, `ford_szoveg` FROM (`us_Forditas`) WHERE `ford_modnev` = 'diatechweb2' AND `ford_nyelvkod` = 'hu'
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/navmenu.tpl'
0.0007	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/navmenu.tpl'
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/contents/cart_side.tpl'
0.0009	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/contents/productgroup.tpl'
0.0006	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/contents/productgroup.tpl'
0.0009	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/contents/productgroup_properties.tpl'
0.0012	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/contents/productgroup_items.tpl'
0.0010	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/contents/productgroup_items.tpl'
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/contents/products.tpl'
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/contents/products.tpl'
0.0009	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'diatechweb2/footer.tpl'
0.0008	SELECT * FROM (`us_SmartyTemplate`) WHERE `st_nev` = 'webaruhaz2/footer.tpl'

HTTP HEADERS (Show)

SESSION DATA (Show)

CONFIG VARIABLES (Show)

virtual_url
base_url	https://www.szamla-dev.diatech.hu/
index_page
uri_protocol	AUTO
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	US_
permitted_uri_chars	?=a-z 0-9~%.,:_\-
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	0
log_path
log_date_format	Y-m-d H:i:s
cache_path	/home/diatech/szamla-dev.diatech.hu/program/cache/
encryption_key	the2ceZacie6lus3
sess_cookie_name	UFO-SOFT_ci_session
sess_expiration	1209600
sess_expire_on_close
sess_encrypt_cookie	1
sess_use_database	1
sess_table_name	CISession
sess_match_ip	1
sess_match_useragent	1
sess_time_to_update	43200
cookie_prefix	US_
cookie_domain	www.szamla-dev.diatech.hu
cookie_path	/
cookie_secure
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
debug
default_domain	multiple_domain
default_lang	hu
cms_theme	diatechweb2
cms_adminurl	usadmin
cms_publicurl	public
url_langcode
ftp_enable
ftp_hostname	localhost
ftp_hostport	21
ftp_username
ftp_password
ftp_docsroot	/
ftp_passive
query_cachelifetime	600
smarty_debug
smarty_mysql_cachehandler
smarty_cachelifetime	600
smarty_caching	0
smarty_compile_check	1
smarty_resource_type	mysql
mailer_from	rendeles@diatech.hu
mailer_fromname	Diatech Kft.
mailer_altbody	Az üzenet megtekintéséhez HTML formátumot támogató kliens szükséges! / Your email client does not support HTML format!
mailer_smtp_method	mail
mailer_smtp_hostname	localhost
mailer_smtp_port	25
locale_autocreate
dateformats	Array ( [af] => d/m/Y [ar] => d/m/Y [az] => d.m.Y [bg] => d.m.Y [bs] => d.m.Y [ca] => d/m/Y [cs] => d.m.Y [da] => d-m-Y [de] => d.m.Y [el] => d/m/Y [en] => d/m/Y [eo] => d/m/Y [es] => d/m/Y [et] => d.m.Y [eu] => Y/m/d [fa] => Y/m/d [fi] => d.m.Y [fo] => d-m-Y [fr] => d/m/Y [ge] => d-m-Y [gl] => d.m.Y [he] => d/m/Y [hi] => d/m/Y [hr] => d.m.Y. [hu] => Y.m.d. [hy] => d.m.Y [id] => d/m/Y [is] => d/m/Y [it] => d/m/Y [ja] => Y/m/d [kk] => d.m.Y [km] => d-m-Y [ko] => Y-m-d [lb] => d.m.Y [lt] => Y-m-d [lv] => d-m-Y [mk] => d.m.Y [ml] => d/m/Y [ms] => d/m/Y [nl] => d-m-Y [no] => d.m.Y [pl] => d.m.Y [pt] => d/m/Y [rm] => d/m/Y [ro] => d.m.Y [ru] => d.m.Y [sk] => d.m.Y [sl] => d.m.Y [sq] => d.m.Y [sr] => d/m/Y [sv] => Y-m-d [ta] => d/m/Y [th] => d/m/Y [tj] => d.m.Y [tr] => d.m.Y [uk] => d/m/Y [vi] => d/m/Y [zh] => Y-m-d )
arfolyam_szamolas
automatikus_leltar	monthly
barion_testmode	1
bnr_arfolyam
bnr_arfolyam_deviza	EUR
cms_kep_vizjel
cms_kep_vizjel_eredeti_mentes
cms_kep_vizjel_szoveg	UFO-SOFT
cms_kep_vizjel_szoveg_attetszoseg	35
cms_kep_vizjel_szoveg_elforgatas	45
cms_kep_vizjel_szoveg_meret	26
cms_kep_vizjel_szoveg_szin	silver
cms_kep_vizjel_tengely_x	center
cms_kep_vizjel_tengely_y	middle
csv_debug	1
csv_delimiter	semicolon
csv_newline	#13#10
debug_locale
default_country	HU
default_currency	HUF
default_theme	silver
desktop_type	panel
elore_datumozas	0
email_tegezes
folyamatos_teljesites	2015-12-31
folyamatos_teljesites_lezaras
gls_csomagpont_automata	1
koltsegszamla_beszallitomodositas
koltsegszamla_fizetendoelteres	0
koltsegszamla_kifizetestorles
mailer_copy	rendeles@diatech.eu
mailer_smtp_auth
mailer_smtp_password
mailer_smtp_username
mnb_arfolyam
mnb_arfolyam_deviza	EUR
negativ_raktarkeszlet
partner_adoszamellenorzes	3
partner_jogiszemely	jogiszemely
pdf_copy	1
pdf_print
pdf_saveoutput
query_clearcache	2023-04-28 16:30:56
raktarmozgas_arelrejtes
registration_code	Ak5tpRTwQ8SB7FAfU/sxpAbAQjYEQv36l0B0QImWs+YP1UjAkBdXWVgL2Th2kiasf8JesYZk/D4DPzge3zlw/6BYVzDDCpITQ1C6p9s/UStPsM1ynYVQ6ztr7l3J76p4q8RydHa7CBBX0AdKGiuv2xbhRfrPPCZ/kOQBO3xlVOm/dh50ZLRTniOJ+SBJLc1xKxVi5hhdUIfJeRDJjqeNmv8kDlgl6V+PRzprlQje4H2o++XRTxFBvmvpgp+5f8SFs6pjcCg1SKu0068oNEEqg8ZYEDMG0Qpl+OPY8KN5Y2XZjghLau3HvtDmMLqlitRVOChBx4CAp9DOMJJzX0GY7CiJSeN9zrfamewCKMDQo/hwnghSC29x74C8OPpeLpMnikhP9AFIoOHLPodm85SO4sW68rwF03u6K7tGj9pdoeNcJDfv6Jo7mzh6fgifQJ+q1aB4++GNJWZpIi6dF7zz2uOhrnBq4jC0L8i+VNSpn2y+FWbaqdZRfS1U/v4ABEfX1+2aFoYDvIKkiMgSFfxXfb1yHTjl6L5Jz/F9PcZiRw7qszxjlBwYVgWKbeq50ZhYtvilOeTjLfLpIF4U8EDI8KdvKzfXePMPSNU9bHuQoJs1Z9Aeq/ifLVyFTkL6geE8T5x4K4PvsH8zCaookeAHmspmDm6OrgLzYM/Yb9zQdeKAW9zTGaPHnUv5vXa4c5ATHKlF9r5cG6CUObcZZRGqxq2suHxIV0GfvejKEWxrHya1CDEr1j6yiQr+xx2lVBj5UseAacbKldBJ5uOtVMYGmKdT/DsKLuhODbTOlIsTrRcLSEtJgAEMw3/bD7STw1JRxbOtTqhvT+x9Aon29UzBTeHWtNJXaqAfr0TL7Bpt4c4Yn5+Rr/hJDyW8rYzPlE6+IPVszRuXQv1KKrSJgFDXvV0ujiAZ6E4MbgRaRykMl02ZXkO+wreH71OwsSdM72lt8y439dTHedy2qUbdB7mS0AaXvZXYJ+2vCv3apc2lcX3J0Gd6GRBeJI7tRgAADEZD
registration_code_backup	zMDOuAKp2j5dSzRPD8NGIvjpcHTf/2yFQi5Td3IHZvPIBe38aOqYl8qS8IVgQuLFMYbtNLHsbXVlnZBxqjvx4qA9xzfZtvhZBtkIe8Ukvm4WNn43aCz9pHDu7cb5hLGVT0F97KroLc9n8zs85vwC3Uonw1vb9X0BlteFrxbJGnVtloSHpYx9UU09Sb0mOwDdNnSWBOWII5rY4LnJa/soryU/ZGmNLayknKjE2JEc0z8mHPwSUW9YOfbuyQvABCNS3GsqHRh41a6EUh9ZVjrWMwKCZyPmnmGinXxf7vJvNMhatk2SHo2CDH5FprynpGMArY4Y4qHMflt9la+kaKC/Xjhpy1zF+MKV9r4C8JNezk36A62mjPlalc8vSiP4xU80SBAz2wDm5IyIr1uv+4cONWMD8idemMoZPNnWDJQmr0+57eRBDV6bT/67beveWr2yDMIzOlR1LAENI3KvyzZLx83JKOOo/8rJENPXV0UJ8gKl1zszfQ+y+Re/nDodkhY/Y5x1r0ksNqpZrEZOfmZdG6IklpegeqExSN8x+S7ZW34pGHv67LAcSBTNPjAF98UJfHFm1UuEtztc+MdSmMtn26et3RUuMxEsg73BRt2MghBTT4vV+79q6qGvF9OPnZKN5J2V74bR6ANZOQTYXzrkVJ18X+7ybzTIgcqL/TxazEUnhkqOUjKaIA==
registration_name	Diatech Kft.
registration_name_backup	DEMO Kft.
rendeles_emag_apiurl	https://marketplace-api.emag.hu/api-3/
rendeles_emag_lekerdezve	0000-00-00 00:00:00
rendeles_emag_status	4
rendeles_emag_voucher
rendeles_lista_megjegyzes
rendeles_lista_weballapot
rendeles_megjegyzes
rendeles_mygls_apiurl	https://api.mygls.hu/
rendeles_pdf_szallitolevel_szolgaltatas
rendeles_pdf_termekcsoportositas	1
rendeles_szallitasimod_tiltas
rendeles_szallitolevel_osszevonas
rendeles_szallitolevel_sorszamozas	1
rendeles_szamlazzhu_eszamla
rendeles_unas_importalas	webshop
rendeles_unas_raktarkezeles	1
rendeles_unas_szamlasorszam	1
rendeles_utolagos_raktarkivet
rendeles_visszaigazolas_email
rendeles_wwa_sms
system_grid_color	color
system_upload_file	1
system_upload_file_count
szamla_adoszamellenorzes	1
szamla_adoszamellenorzes_hiba	1
szamla_afakulcs_szerkesztes
szamla_arfigyelmeztetes
szamla_arfolyamszamolas
szamla_automatikus_kiegyenlites	1
szamla_csakmainap
szamla_duplatetel_hiba
szamla_ertesites_kapcsolattarto	1
szamla_importalas	v2
szamla_kosar_arszerkesztes	1
szamla_mertekegyseg	1
szamla_nav_zaraskorkuld	1
szamla_navxml
szamla_pdf_backup	1
szamla_pdf_copy	1
szamla_pdf_devizaszamla_afaertek
szamla_pdf_garancialapkuld
szamla_pdf_print
szamla_pdf_tetellistaar
szamla_pdf_tetelrendezes	index
szamla_rendelestetelszerkesztes
szamla_sagaexport_cont	707.1
szamla_sagaexport_facturatvaincasare	Nu
szamla_sql_trigger
szamla_sql_trigger_csv	on
szamla_szallitas_kapcsolattarto
szamla_termekszolgaltatas_arlistamasolas	1
szamla_termekszolgaltatas_atnevezheto
szamla_termekvalasztas	tsz_autocomplete
szamla_vevovalasztas	contains
szamla_vevovalasztaslista	autocomplete_vevo
szamla_webaruhaz_urlparameter