JoomShopping Download & Support
Joomla! Version | 4.4.9 |
PHP Version | 8.1.32 |
Identity | guest |
Response | 200 |
Template | tp_hotel |
Database |
|
1 x afterRender (4.36MB) (47.24%) | 70.53ms |
1 x afterInitialise (1.01MB) (22.84%) | 34.10ms |
1 x afterRenderComponent com_jshopping (730.28KB) (19.54%) | 29.17ms |
1 x afterRoute (1.06MB) (7.85%) | 11.72ms |
1 x afterLoad (538.86KB) (1.7%) | 2.54ms |
1 x beforeRenderComponent com_jshopping (24.52KB) (0.49%) | 733μs |
1 x afterDispatch (2.28KB) (0.14%) | 204μs |
SELECT @@SESSION.sql_mode;
135μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `qrm4w_session`
WHERE `session_id` = ?
234μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `qrm4w_session`
WHERE `session_id` = :session_id LIMIT 1
153μ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)
15.61ms944BParams/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` = 1
314μs2.36KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `qrm4w_viewlevels`
176μ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` = :guest
195μ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`
512μs4.3KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT id,template FROM qrm4w_template_styles WHERE client_id=0 AND home=1
231μs2.14KB/administrator/components/com_widgetkit/widgetkit.php:28Copyset @@sql_mode = ''
41μ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`
938μs101.55KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `template`,`id`,`title`,`params`,`home` FROM `qrm4w_template_styles` WHERE `id`='14'
149μ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` = 1
345μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT *
FROM `qrm4w_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
235μs2.23KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `key`,`value`
FROM `qrm4w_jshopping_configs`
WHERE `config_id`='1'
382μs4.88KB/components/com_jshopping/Table/ConfigTable.php:24CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_currencies`
506μ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_ordering
266μs3.56KB/components/com_jshopping/Table/CurrencyTable.php:25Copyselect * from qrm4w_jshopping_languages
182μs1.08KB/components/com_jshopping/Helper/Helper.php:296CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_products`
683μs2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `qrm4w_jshopping_products`
WHERE `product_id` = '125'
353μs23.94KB/libraries/src/Table/Table.php:755CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_categories`
536μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `qrm4w_jshopping_categories`
WHERE `category_id` = '5'
248μs4.25KB/libraries/src/Table/Table.php:755CopySELECT * FROM `qrm4w_jshopping_products_to_categories` WHERE product_id=125
207μs976B/components/com_jshopping/Table/ProductTable.php:290CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_attr`
408μ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_ordering
433μs1.95KB/components/com_jshopping/Table/AttributTable.php:29CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_users`
588μs2.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_taxes`
371μ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_reviews`
473μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySHOW FULL COLUMNS FROM `qrm4w_jshopping_product_labels`
388μs1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT id, image, `name_de-DE` as name FROM `qrm4w_jshopping_product_labels` ORDER BY name
199μs1.06KB/components/com_jshopping/Table/ProductlabelTable.php:23Copyselect 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)
386μ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`!=''
168μs12KB/components/com_jshopping/Lib/JSFactory.php:221CopyUPDATE `qrm4w_jshopping_products`
SET `hits` = (`hits` + 1)
WHERE `product_id` = '125'
3.84ms48B/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=125 ORDER BY sort, I.ordering
326μs1.19KB/components/com_jshopping/Table/ProductTable.php:381CopySELECT video_name, video_id, video_preview, video_code FROM `qrm4w_jshopping_products_videos` WHERE product_id=125
216μs1008B/components/com_jshopping/Table/ProductTable.php:410CopySELECT * FROM `qrm4w_jshopping_products_files` WHERE product_id=125 and demo!='' order by `ordering`
240μ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=125 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.id
801μs3.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.31ms2.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` = 1
241μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `qrm4w_session`
WHERE `session_id` = ?
3.49ms1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `qrm4w_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
28.89ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy