JoomShopping Download & Support
| Joomla! Version | 4.4.9 |
| PHP Version | 8.2.28 |
| Identity | guest |
| Response | 200 |
| Template | tp_hotel |
| Database |
|
| 1 x afterRender (3.23MB) (43.77%) | 47.89ms |
| 1 x afterRenderComponent com_jshopping (705.32KB) (36.1%) | 39.50ms |
| 1 x afterInitialise (947.19KB) (10.41%) | 11.39ms |
| 1 x afterRoute (1.04MB) (8.17%) | 8.94ms |
| 1 x afterLoad (457.61KB) (0.64%) | 698μs |
| 1 x beforeRenderComponent com_jshopping (23.77KB) (0.57%) | 626μs |
| 1 x afterDispatch (2.28KB) (0.11%) | 118μs |
SELECT @@SESSION.sql_mode;87μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `qrm4w_session`
WHERE `session_id` = ?170μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `qrm4w_session`
WHERE `session_id` = :session_id LIMIT 1168μs1.31KBParams/libraries/src/Session/MetadataManager.php:187CopyUPDATE `qrm4w_session`
SET `guest` = :guest
, `time` = :time
, `userid` = :user_id
, `username` = :username
, `client_id` = :client_id
WHERE `session_id` = :session_id196μs992BParams/libraries/src/Session/MetadataManager.php:316CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qrm4w_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1282μs1.69KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `qrm4w_viewlevels`136μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `qrm4w_usergroups` AS `a`
LEFT JOIN `qrm4w_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest232μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `qrm4w_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`503μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT id,template FROM qrm4w_template_styles WHERE client_id=0 AND home=1193μs1.2KB/administrator/components/com_widgetkit/widgetkit.php:28Copyset @@sql_mode = ''102μs0B/components/com_jshopping/Helper/Helper.php:1576CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `qrm4w_menu` AS `m`
LEFT JOIN `qrm4w_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`790μs116.55KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `template`,`id`,`title`,`params`,`home` FROM `qrm4w_template_styles` WHERE `id`='14'136μs768B/libraries/astroid/framework/library/astroid/Template.php:218CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `qrm4w_template_styles` AS `s`
LEFT JOIN `qrm4w_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` = 1259μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT *
FROM `qrm4w_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC189μs1.61KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `key`,`value`
FROM `qrm4w_jshopping_configs`
WHERE `config_id`='1'342μs4.56KB/components/com_jshopping/Table/ConfigTable.php:24CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_currencies`448μs1.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `qrm4w_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering278μs2KB/components/com_jshopping/Table/CurrencyTable.php:25CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_products`539μs2.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `qrm4w_jshopping_products`
WHERE `product_id` = '133'270μs21.44KB/libraries/src/Table/Table.php:755CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_categories`395μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `qrm4w_jshopping_categories`
WHERE `category_id` = '5'182μs3KB/libraries/src/Table/Table.php:755CopySELECT * FROM `qrm4w_jshopping_products_to_categories` WHERE product_id=133148μs656B/components/com_jshopping/Table/ProductTable.php:290CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_attr`390μs1.45KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT A.attr_id, A.`name_de-DE` as name, A.`description_de-DE` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_de-DE` as groupname, G.id as group_id
FROM `qrm4w_jshopping_attr` as A left Join `qrm4w_jshopping_attr_groups` as G on A.`group`=G.id
ORDER BY G.ordering, A.attr_ordering415μs1.33KB/components/com_jshopping/Table/AttributTable.php:29CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_users`467μs2.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_taxes`355μs1.31KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT tax_id, tax_name, tax_value FROM `qrm4w_jshopping_taxes`147μs800B/components/com_jshopping/Table/TaxTable.php:22CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_products_prices`367μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT * FROM `qrm4w_jshopping_products_prices` WHERE product_id = '133' ORDER BY product_quantity_start DESC190μs784B/components/com_jshopping/Table/ProductpriceTable.php:22CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_unit`381μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT id, `name_de-DE` as name, qty FROM `qrm4w_jshopping_unit` ORDER BY id153μs720B/components/com_jshopping/Table/UnitTable.php:23CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_products_reviews`395μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copyselect id,link from qrm4w_menu
where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0
and (language='*' or language='de-DE') and access IN (1,5)339μs3.38KB/components/com_jshopping/Lib/ShopItemMenu.php:142Copyselect category_id as id, `alias_de-DE` as alias from qrm4w_jshopping_categories where `alias_de-DE`!=''141μs736B/components/com_jshopping/Lib/JSFactory.php:221CopyUPDATE `qrm4w_jshopping_products`
SET `hits` = (`hits` + 1)
WHERE `product_id` = '133'18.89ms48B/libraries/src/Table/Table.php:1325CopySELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `qrm4w_jshopping_products_images` as I
left Join `qrm4w_jshopping_products` as P on P.product_id=I.product_id
WHERE I.product_id=133 ORDER BY sort, I.ordering272μs880B/components/com_jshopping/Table/ProductTable.php:381CopySELECT video_name, video_id, video_preview, video_code FROM `qrm4w_jshopping_products_videos` WHERE product_id=133118μs688B/components/com_jshopping/Table/ProductTable.php:410CopySELECT * FROM `qrm4w_jshopping_products_files` WHERE product_id=133 and demo!='' order by `ordering`132μs880B/components/com_jshopping/Table/ProductTable.php:440CopySELECT prod.product_id, pr_cat.category_id, prod.main_category_id, prod.`name_de-DE` as name, prod.`short_description_de-DE` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `qrm4w_jshopping_products_relations` AS relation
INNER JOIN `qrm4w_jshopping_products` AS prod ON relation.product_related_id = prod.product_id
LEFT JOIN `qrm4w_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = relation.product_related_id
LEFT JOIN `qrm4w_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
WHERE relation.product_id=133 AND cat.category_publish=1 AND prod.product_publish=1 AND prod.access IN (1,5) AND cat.access IN (1,5)
group by prod.product_id ORDER BY relation.id600μs2.73KB/components/com_jshopping/Model/Productlist/RelatedModel.php:42CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `qrm4w_modules` AS `m`
LEFT JOIN `qrm4w_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `qrm4w_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`1.04ms1.81KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count
FROM `qrm4w_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1221μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `qrm4w_session`
WHERE `session_id` = ?194μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `qrm4w_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?3.7ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy