Hlavní informace
Svítidla
23W
14,4W
9W
4,5W
Array
(
[0] => Array
(
[virtuemart_category_id] => 2
[virtuemart_vendor_id] => 1
[category_name] => Produkty
[slug] => produkty
[category_description] =>
[category_template] => 0
[category_layout] => 0
[category_product_layout] => 0
[products_per_row] => 6
[ordering] => 0
[shared] => 0
[limit_list_step] => 10
[limit_list_initial] => 0
[metadesc] =>
[customtitle] => Produkty
[metakey] => Produkty
[metarobot] =>
[metaauthor] =>
[published] => 1
[ VmTable _lhash] => dc6c518f524ef85cffd646e9e4e44df5
[ * _tbl] => #__virtuemart_categories
[ * _tbl_lang] => #__virtuemart_categories_cs_cz
[ * _tbl_key] => virtuemart_category_id
[ * _tbl_keys] => Array
(
[0] => virtuemart_category_id
)
[ * _pkey] => virtuemart_category_id
[ * _pkeyForm] => cid
[ * _obkeys] => Array
(
[category_name] => 1
[slug] => 1
)
[ * _unique] => 1
[ * _unique_name] => Array
(
[slug] => 1
)
[ * _orderingKey] => ordering
[ * _slugAutoName] => category_name
[ * _slugName] => slug
[ * _db] => JDatabaseDriverMysqli Object
(
[name] => mysqli
[serverType] => mysql
[connection:protected] => mysqli Object
(
[affected_rows] => 1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 1
[host_info] => 127.0.0.1 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.6.33
[server_version] => 50633
[stat] => Uptime: 54189479 Threads: 8 Questions: 130213797982 Slow queries: 85766 Opens: 672402485 Flush tables: 1 Open tables: 1000 Queries per second avg: 2402.935
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 284376204
[warning_count] => 0
)
[nameQuote:protected] => `
[nullDate:protected] => 0000-00-00 00:00:00
[_database:JDatabaseDriver:private] => alumiacz1
[count:protected] => 289
[cursor:protected] =>
[debug:protected] =>
[limit:protected] => 1000
[log:protected] => Array
(
)
[timings:protected] => Array
(
)
[callStacks:protected] => Array
(
)
[offset:protected] => 0
[options:protected] => Array
(
[driver] => mysqli
[host] => 127.0.0.1
[user] => alumia.cz.1
[password] => hUhatej45*akJel
[database] => alumiacz1
[prefix] => ej30_
[select] => 1
[port] => 3306
[socket] =>
)
[sql:protected] => SELECT p.`virtuemart_product_id` FROM `#__virtuemart_products` as p
LEFT JOIN `#__virtuemart_product_customfields` as cfp on `p`.virtuemart_product_id = `cfp`.virtuemart_product_id and `cfp`.virtuemart_custom_id = 28
LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `#__virtuemart_product_customfields` as cfl ON p.`virtuemart_product_id` = cfl.`virtuemart_product_id` AND cfl.`virtuemart_custom_id` = 14
WHERE ( `pc`.`virtuemart_category_id` = 88 AND `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" AND cfl.`customfield_value` = "1" )
group by p.`virtuemart_product_id`
ORDER BY cast(`cfp`.`customfield_value` as unsigned) ASC
[tablePrefix:protected] => ej30_
[utf:protected] => 1
[utf8mb4:protected] => 1
[errorNum:protected] => 0
[errorMsg:protected] =>
[transactionDepth:protected] => 0
[disconnectHandlers:protected] => Array
(
)
)
[ * _rules] =>
[ * _trackAssets] =>
[ * _locked] =>
[ * _loggable] => 1
[_xParams] => 0
[_varsToPushParam] => Array
(
)
[_translatable] => 1
[ * _translatableFields] => Array
(
[0] => category_name
[1] => category_description
[2] => metadesc
[3] => metakey
[4] => customtitle
[slug] => slug
)
[_cryptedFields] =>
[ * _langTag] => cs_cz
[_ltmp] =>
[_loaded] =>
[ * _updateNulls] =>
[_tablePreFix] => c.
[_autoincrement] => 1
[_observers] => JObserverUpdater Object
(
[observers:protected] => Array
(
)
[doCallObservers:protected] => 1
)
[created_on] => 2016-04-13 12:17:27
[created_by] => 0
[modified_on] => 2020-07-05 09:34:29
[modified_by] => 0
[id] => 68840581
)
[1] => Array
(
[virtuemart_category_id] => 27
[virtuemart_vendor_id] => 1
[category_name] => LED pásky
[slug] => led-pasky
[category_description] =>
[category_template] => 0
[category_layout] => 0
[category_product_layout] => 0
[products_per_row] => 6
[ordering] => 0
[shared] => 0
[limit_list_step] => 10
[limit_list_initial] => 0
[metadesc] =>
[customtitle] => LED pásky
[metakey] => LED pásky
[metarobot] =>
[metaauthor] =>
[published] => 1
[ VmTable _lhash] => 226724392b246c0164b503f4fa9da68e
[ * _tbl] => #__virtuemart_categories
[ * _tbl_lang] => #__virtuemart_categories_cs_cz
[ * _tbl_key] => virtuemart_category_id
[ * _tbl_keys] => Array
(
[0] => virtuemart_category_id
)
[ * _pkey] => virtuemart_category_id
[ * _pkeyForm] => cid
[ * _obkeys] => Array
(
[category_name] => 1
[slug] => 1
)
[ * _unique] => 1
[ * _unique_name] => Array
(
[slug] => 1
)
[ * _orderingKey] => ordering
[ * _slugAutoName] => category_name
[ * _slugName] => slug
[ * _db] => JDatabaseDriverMysqli Object
(
[name] => mysqli
[serverType] => mysql
[connection:protected] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 1
[host_info] => 127.0.0.1 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.6.33
[server_version] => 50633
[stat] => Uptime: 54189479 Threads: 8 Questions: 130213797988 Slow queries: 85766 Opens: 672402485 Flush tables: 1 Open tables: 1000 Queries per second avg: 2402.935
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 284376204
[warning_count] => 0
)
[nameQuote:protected] => `
[nullDate:protected] => 0000-00-00 00:00:00
[_database:JDatabaseDriver:private] => alumiacz1
[count:protected] => 289
[cursor:protected] =>
[debug:protected] =>
[limit:protected] => 1000
[log:protected] => Array
(
)
[timings:protected] => Array
(
)
[callStacks:protected] => Array
(
)
[offset:protected] => 0
[options:protected] => Array
(
[driver] => mysqli
[host] => 127.0.0.1
[user] => alumia.cz.1
[password] => hUhatej45*akJel
[database] => alumiacz1
[prefix] => ej30_
[select] => 1
[port] => 3306
[socket] =>
)
[sql:protected] => SELECT p.`virtuemart_product_id` FROM `#__virtuemart_products` as p
LEFT JOIN `#__virtuemart_product_customfields` as cfp on `p`.virtuemart_product_id = `cfp`.virtuemart_product_id and `cfp`.virtuemart_custom_id = 28
LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `#__virtuemart_product_customfields` as cfl ON p.`virtuemart_product_id` = cfl.`virtuemart_product_id` AND cfl.`virtuemart_custom_id` = 14
WHERE ( `pc`.`virtuemart_category_id` = 88 AND `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" AND cfl.`customfield_value` = "1" )
group by p.`virtuemart_product_id`
ORDER BY cast(`cfp`.`customfield_value` as unsigned) ASC
[tablePrefix:protected] => ej30_
[utf:protected] => 1
[utf8mb4:protected] => 1
[errorNum:protected] => 0
[errorMsg:protected] =>
[transactionDepth:protected] => 0
[disconnectHandlers:protected] => Array
(
)
)
[ * _rules] =>
[ * _trackAssets] =>
[ * _locked] =>
[ * _loggable] => 1
[_xParams] => 0
[_varsToPushParam] => Array
(
)
[_translatable] => 1
[ * _translatableFields] => Array
(
[0] => category_name
[1] => category_description
[2] => metadesc
[3] => metakey
[4] => customtitle
[slug] => slug
)
[_cryptedFields] =>
[ * _langTag] => cs_cz
[_ltmp] =>
[_loaded] =>
[ * _updateNulls] =>
[_tablePreFix] => c.
[_autoincrement] => 1
[_observers] => JObserverUpdater Object
(
[observers:protected] => Array
(
)
[doCallObservers:protected] => 1
)
[created_on] => 2016-07-29 12:43:26
[created_by] => 0
[modified_on] => 2020-07-05 09:34:30
[modified_by] => 0
[id] => 68840582
)
[2] => Array
(
[virtuemart_category_id] => 88
[virtuemart_vendor_id] => 1
[category_name] => 4,5W
[slug] => 4-5w
[category_description] =>
[category_template] => 0
[category_layout] => 0
[category_product_layout] => 0
[products_per_row] => 6
[ordering] => 0
[shared] => 0
[limit_list_step] => 10
[limit_list_initial] => 0
[metadesc] =>
[customtitle] => 4,5W
[metakey] => 4,5W
[metarobot] =>
[metaauthor] =>
[published] => 1
[ VmTable _lhash] => 77ea7439e5614a15dda0a8a5de419c66
[ * _tbl] => #__virtuemart_categories
[ * _tbl_lang] => #__virtuemart_categories_cs_cz
[ * _tbl_key] => virtuemart_category_id
[ * _tbl_keys] => Array
(
[0] => virtuemart_category_id
)
[ * _pkey] => virtuemart_category_id
[ * _pkeyForm] => cid
[ * _obkeys] => Array
(
[category_name] => 1
[slug] => 1
)
[ * _unique] => 1
[ * _unique_name] => Array
(
[slug] => 1
)
[ * _orderingKey] => ordering
[ * _slugAutoName] => category_name
[ * _slugName] => slug
[ * _db] => JDatabaseDriverMysqli Object
(
[name] => mysqli
[serverType] => mysql
[connection:protected] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 1
[host_info] => 127.0.0.1 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.6.33
[server_version] => 50633
[stat] => Uptime: 54189479 Threads: 8 Questions: 130213797990 Slow queries: 85766 Opens: 672402485 Flush tables: 1 Open tables: 1000 Queries per second avg: 2402.935
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 284376204
[warning_count] => 0
)
[nameQuote:protected] => `
[nullDate:protected] => 0000-00-00 00:00:00
[_database:JDatabaseDriver:private] => alumiacz1
[count:protected] => 289
[cursor:protected] =>
[debug:protected] =>
[limit:protected] => 1000
[log:protected] => Array
(
)
[timings:protected] => Array
(
)
[callStacks:protected] => Array
(
)
[offset:protected] => 0
[options:protected] => Array
(
[driver] => mysqli
[host] => 127.0.0.1
[user] => alumia.cz.1
[password] => hUhatej45*akJel
[database] => alumiacz1
[prefix] => ej30_
[select] => 1
[port] => 3306
[socket] =>
)
[sql:protected] => SELECT p.`virtuemart_product_id` FROM `#__virtuemart_products` as p
LEFT JOIN `#__virtuemart_product_customfields` as cfp on `p`.virtuemart_product_id = `cfp`.virtuemart_product_id and `cfp`.virtuemart_custom_id = 28
LEFT JOIN `#__virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `#__virtuemart_product_customfields` as cfl ON p.`virtuemart_product_id` = cfl.`virtuemart_product_id` AND cfl.`virtuemart_custom_id` = 14
WHERE ( `pc`.`virtuemart_category_id` = 88 AND `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" AND cfl.`customfield_value` = "1" )
group by p.`virtuemart_product_id`
ORDER BY cast(`cfp`.`customfield_value` as unsigned) ASC
[tablePrefix:protected] => ej30_
[utf:protected] => 1
[utf8mb4:protected] => 1
[errorNum:protected] => 0
[errorMsg:protected] =>
[transactionDepth:protected] => 0
[disconnectHandlers:protected] => Array
(
)
)
[ * _rules] =>
[ * _trackAssets] =>
[ * _locked] =>
[ * _loggable] => 1
[_xParams] => 0
[_varsToPushParam] => Array
(
)
[_translatable] => 1
[ * _translatableFields] => Array
(
[0] => category_name
[1] => category_description
[2] => metadesc
[3] => metakey
[4] => customtitle
[slug] => slug
)
[_cryptedFields] =>
[ * _langTag] => cs_cz
[_ltmp] =>
[_loaded] => 1
[ * _updateNulls] =>
[_tablePreFix] => c.
[_autoincrement] => 1
[_observers] => JObserverUpdater Object
(
[observers:protected] => Array
(
)
[doCallObservers:protected] => 1
)
[created_on] => 2020-06-22 07:33:42
[created_by] => 0
[modified_on] => 2020-07-05 09:34:30
[modified_by] => 0
[id] => 68840583
)
)
Základní cena:
Základní cena pro tuto variantu:
Modifikátor variant cen
Prodejní cena
Cena bez DPH:
Sleva:
Hodnota DPH
Cena / m: