JoomShopping Download & Support
| Joomla! Version | 4.4.9 |
| PHP Version | 8.1.32 |
| Identity | guest |
| Response | 200 |
| Template | tp_hotel |
| Database |
|
| 1 x afterRenderComponent com_jshopping (755.29KB) (39%) | 70.85ms |
| 1 x afterRender (4.36MB) (30.18%) | 54.84ms |
| 1 x afterInitialise (1.01MB) (22.4%) | 40.69ms |
| 1 x afterRoute (1.06MB) (6.96%) | 12.65ms |
| 1 x afterLoad (538.86KB) (0.85%) | 1.55ms |
| 1 x beforeRenderComponent com_jshopping (24.52KB) (0.38%) | 695μs |
| 1 x afterDispatch (2.28KB) (0.07%) | 123μs |
SELECT @@SESSION.sql_mode;130μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `qrm4w_session`
WHERE `session_id` = ?196μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `qrm4w_session`
WHERE `session_id` = :session_id LIMIT 1199μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `qrm4w_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)22.66ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qrm4w_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1453μs2.36KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `qrm4w_viewlevels`260μs976B/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` = :guest223μs1.64KBParams/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`896μs4.3KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT id,template FROM qrm4w_template_styles WHERE client_id=0 AND home=1271μs2.14KB/administrator/components/com_widgetkit/widgetkit.php:28Copyset @@sql_mode = ''104μ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`1.53ms101.55KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `template`,`id`,`title`,`params`,`home` FROM `qrm4w_template_styles` WHERE `id`='14'183μs1.06KB/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` = 1462μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT *
FROM `qrm4w_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC235μs2.23KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `key`,`value`
FROM `qrm4w_jshopping_configs`
WHERE `config_id`='1'373μs4.88KB/components/com_jshopping/Table/ConfigTable.php:24CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_currencies`403μs2.02KB/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_ordering268μs3.56KB/components/com_jshopping/Table/CurrencyTable.php:25Copyselect * from qrm4w_jshopping_languages220μs1.08KB/components/com_jshopping/Helper/Helper.php:296CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_products`535μs2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `qrm4w_jshopping_products`
WHERE `product_id` = '43'426μs23.94KB/libraries/src/Table/Table.php:755CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_categories`554μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `qrm4w_jshopping_categories`
WHERE `category_id` = '8'361μs4.25KB/libraries/src/Table/Table.php:755CopySELECT * FROM `qrm4w_jshopping_products_to_categories` WHERE product_id=43205μs976B/components/com_jshopping/Table/ProductTable.php:290CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_attr`430μs2.08KB/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_ordering437μs1.95KB/components/com_jshopping/Table/AttributTable.php:29CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_users`461μs2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_taxes`366μs1.94KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT tax_id, tax_name, tax_value FROM `qrm4w_jshopping_taxes`178μs1.09KB/components/com_jshopping/Table/TaxTable.php:22CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_products_prices`365μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT * FROM `qrm4w_jshopping_products_prices` WHERE product_id = '43' ORDER BY product_quantity_start DESC364μs1.08KB/components/com_jshopping/Table/ProductpriceTable.php:22CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_unit`337μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT id, `name_de-DE` as name, qty FROM `qrm4w_jshopping_unit` ORDER BY id163μs1.02KB/components/com_jshopping/Table/UnitTable.php:23CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_products_reviews`650μs13.05KB/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)448μs1.13KB/components/com_jshopping/Lib/ShopItemMenu.php:142Copyselect category_id as id, `alias_de-DE` as alias from qrm4w_jshopping_categories where `alias_de-DE`!=''103μs1KB/components/com_jshopping/Lib/JSFactory.php:221CopyUPDATE `qrm4w_jshopping_products`
SET `hits` = (`hits` + 1)
WHERE `product_id` = '43'44.5ms48B/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=43 ORDER BY sort, I.ordering452μs1.14KB/components/com_jshopping/Table/ProductTable.php:381CopySELECT video_name, video_id, video_preview, video_code FROM `qrm4w_jshopping_products_videos` WHERE product_id=43210μs1008B/components/com_jshopping/Table/ProductTable.php:410CopySELECT * FROM `qrm4w_jshopping_products_files` WHERE product_id=43 and demo!='' order by `ordering`262μs1.17KB/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=43 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.id1.09ms3.98KB/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.77ms2.13KBParams/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` = 1310μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `qrm4w_session`
WHERE `session_id` = ?248μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `qrm4w_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?104ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy