آره تو قسمت مدیریت
اگه منظورت تو قسمت مدیریت / عیب یابی سیستم ؟ فعالش کردم موقعه ای که از مدیریت میری تو ایجاد ماژل یه صفحه سفید باز میاد جلوت ارور نمیده اما موقه ای که سایت رو میارم بالا یه قسمتی زیرش اضافه شده که حاوی این متن است
Joomla! Debug Console
Session
__default
session.client.browser ⇒ Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36
user
com_rsfirewall.geoip ⇒
js_id_currency_orig ⇒ 1
js_id_currency ⇒ 1
js_history_sel_lang ⇒ en-GB
jshop_checked_language
jshop_end_page_buy_product ⇒ /index.php/en/
jshop_end_page_list_product ⇒ /index.php/en/
Profile Information
Application 0.000 seconds (+0.000); 0.74 MB (+0.741) - afterLoad
Application 0.034 seconds (+0.033); 3.59 MB (+2.847) - afterInitialise
Application 0.044 seconds (+0.010); 4.69 MB (+1.101) - afterRoute
Application 0.151 seconds (+0.107); 9.03 MB (+4.340) - afterDispatch
Application 0.158 seconds (+0.007); 9.53 MB (+0.499) - beforeRenderModule mod_custom (Site Map)
Application 0.160 seconds (+0.002); 9.59 MB (+0.064) - afterRenderModule mod_custom (Site Map)
Application 0.160 seconds (+0.000); 9.59 MB (-0.004) - beforeRenderModule mod_custom (Copyright)
Application 0.160 seconds (+0.000); 9.59 MB (+0.005) - afterRenderModule mod_custom (Copyright)
Application 0.161 seconds (+0.000); 9.59 MB (-0.003) - beforeRenderModule mod_je_lightbox (Special Images)
Application 1.645 seconds (+1.485); 9.62 MB (+0.026) - afterRenderModule mod_je_lightbox (Special Images)
Application 1.646 seconds (+0.000); 9.62 MB (+0.001) - beforeRenderModule mod_globalnews (Articles)
Application 1.659 seconds (+0.014); 10.49 MB (+0.875) - afterRenderModule mod_globalnews (Articles)
Application 1.659 seconds (+0.000); 10.41 MB (-0.086) - beforeRenderModule mod_globalnews (Beauty News)
Application 1.663 seconds (+0.003); 10.46 MB (+0.055) - afterRenderModule mod_globalnews (Beauty News)
Application 1.663 seconds (+0.000); 10.42 MB (-0.045) - beforeRenderModule mod_custom (Contracting companies)
Application 1.663 seconds (+0.000); 10.42 MB (+0.005) - afterRenderModule mod_custom (Contracting companies)
Application 1.663 seconds (+0.000); 10.44 MB (+0.023) - beforeRenderModule mod_news_pro_gk4 (Slide articles)
Application 1.679 seconds (+0.015); 12.22 MB (+1.772) - afterRenderModule mod_news_pro_gk4 (Slide articles)
Application 1.679 seconds (+0.000); 12.10 MB (-0.112) - beforeRenderModule mod_slideshowck (اسلاید)
Application 1.681 seconds (+0.002); 12.18 MB (+0.076) - afterRenderModule mod_slideshowck (اسلاید)
Application 1.681 seconds (+0.000); 12.16 MB (-0.017) - beforeRenderModule mod_languages (lang)
Application 1.685 seconds (+0.004); 12.38 MB (+0.217) - afterRenderModule mod_languages (lang)
Application 1.685 seconds (+0.000); 12.38 MB (-0.004) - beforeRenderModule mod_social_slider (JJ Social Slider )
Application 1.687 seconds (+0.001); 12.41 MB (+0.035) - afterRenderModule mod_social_slider (JJ Social Slider )
Application 1.687 seconds (+0.000); 12.41 MB (-0.005) - beforeRenderModule mod_menu (homepagemenu)
Application 1.695 seconds (+0.008); 12.51 MB (+0.105) - afterRenderModule mod_menu (homepagemenu)
Application 1.702 seconds (+0.007); 12.89 MB (+0.376) - afterRender
Memory Usage
12.92 MB (13,547,560 Bytes)
Database Queries
66 Queries Logged
SELECT `data`
FROM `lol72_session`
WHERE `session_id` = '706827df55837d1b24f41168ef83df36'
SELECT folder AS type, element AS name, params
FROM lol72_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT *
FROM lol72_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT COUNT(*)
FROM `lol72_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
SELECT `path`
FROM lol72_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
SELECT `file`
FROM lol72_rsfirewall_hashes
WHERE `type`='protect'
SELECT *
FROM lol72_rsfirewall_configuration
SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
WHERE `type` = 'component'
AND `element` = 'com_widgetkit'
SELECT time
FROM lol72_vvisit_counter USE INDEX(time)
ORDER BY time DESC
LIMIT 1;
SELECT template
FROM lol72_template_styles
WHERE home = 1
AND client_id = 0
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM lol72_menu AS m
LEFT JOIN lol72_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SHOW FULL COLUMNS
FROM `lol72_rsfirewall_logs`
SELECT *
FROM lol72_rsfirewall_hashes
WHERE (`type`='2.5.18' OR `type`='protect')
AND `flag`!='C'
SELECT *
FROM lol72_rsfirewall_snapshots
WHERE `type`='protect'
SELECT `ip`,`reason`
FROM lol72_rsfirewall_lists
WHERE (`ip`='192.211.55.90' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`,`reason`
FROM lol72_rsfirewall_lists
WHERE (`ip`='192.211.55.90' OR `ip` LIKE '%*%')
AND `type`='0'
AND `published`='1'
SELECT *
FROM lol72_rsfirewall_exceptions
WHERE `published`='1'
SELECT p.folder AS type, p.element AS name
FROM lol72_mj_plugins AS mj
LEFT JOIN lol72_extensions AS p
ON p.extension_id=mj.id
WHERE mj.markup='desktop'
SELECT m.id, m.position
FROM lol72_mj_modules AS mj
LEFT JOIN lol72_modules AS m
ON m.id=mj.id
WHERE mj.markup='desktop'
SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
WHERE `type` = 'component'
AND `element` = 'com_jshopping'
SELECT id, home, template, s.params
FROM lol72_template_styles as s
LEFT JOIN lol72_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
SHOW FULL COLUMNS
FROM `lol72_jshopping_config`
SELECT *
FROM lol72_jshopping_config
WHERE `id` = '1'
SHOW FULL COLUMNS
FROM `lol72_jshopping_currencies`
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `lol72_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_ordering
select *
from lol72_jshopping_languages
SHOW FULL COLUMNS
FROM `lol72_jshopping_products`
SHOW FULL COLUMNS
FROM `lol72_jshopping_config_seo`
SELECT id, alias, `title_en-GB` as title, `keyword_en-GB` as keyword, `description_en-GB` as description
FROM `lol72_jshopping_config_seo`
where alias='all-products'
SHOW FULL COLUMNS
FROM `lol72_jshopping_vendors`
SELECT id
FROM lol72_jshopping_vendors
WHERE `main`=1
SELECT *
FROM lol72_jshopping_vendors
WHERE `id` = '1'
SHOW FULL COLUMNS
FROM `lol72_jshopping_taxes`
SELECT tax_id, tax_name, tax_value
FROM `lol72_jshopping_taxes`
SELECT COUNT(distinct prod.product_id)
FROM `lol72_jshopping_products` as prod
LEFT JOIN `lol72_jshopping_products_to_categories` AS pr_cat USING (product_id)
LEFT JOIN `lol72_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE prod.product_publish = '1'
AND cat.category_publish='1'
AND prod.access IN (1,1)
AND cat.access IN (1,1)
SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.product_thumb_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 `lol72_jshopping_products` AS prod
LEFT JOIN `lol72_jshopping_products_to_categories` AS pr_cat USING (product_id)
LEFT JOIN `lol72_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE prod.product_publish = '1'
AND cat.category_publish='1'
AND prod.access IN (1,1)
AND cat.access IN (1,1)
GROUP BY prod.product_id
ORDER BY prod.hits DESC
LIMIT 0, 9
SHOW FULL COLUMNS
FROM `lol72_jshopping_users`
select id,link
from lol72_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='en-GB')
and access IN (1,1)
select product_id as id, `alias_en-GB` as alias
from lol72_jshopping_products
where `alias_en-GB`!=''
select category_id as id, `alias_en-GB` as alias
from lol72_jshopping_categories
where `alias_en-GB`!=''
SHOW FULL COLUMNS
FROM `lol72_jshopping_products_reviews`
SELECT params
FROM lol72_extensions AS e
WHERE e.element='com_widgetkit'
SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
select *
from lol72_session
where client_id=0
select *
from lol72_jvcounter_logs
INSERT INTO lol72_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl)
VALUES('706827df55837d1b24f41168ef83df36','0','192.211.55.90','1393055257','1393055257','1','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36','','')
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lol72_modules AS m
LEFT JOIN lol72_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lol72_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-02-22 07:47:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-02-22 07:47:40')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 610 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM lol72_categories AS c
WHERE c.published = 1
AND c.extension = "com_content"
AND c.access IN (1,1)
AND c.id IN (82)
ORDER BY c.id ASC
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lol72_categories as c
LEFT JOIN lol72_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lol72_categories AS cat JOIN lol72_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=82
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM lol72_usergroups AS a
LEFT JOIN lol72_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `lol72_viewlevels`
SELECT a.rules
FROM lol72_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM lol72_assets AS a
LEFT JOIN lol72_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM lol72_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM lol72_content AS a
LEFT JOIN lol72_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN lol72_categories AS c
ON c.id = a.catid
LEFT JOIN lol72_users AS ua
ON ua.id = a.created_by
LEFT JOIN lol72_users AS uam
ON uam.id = a.modified_by
LEFT JOIN lol72_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lol72_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lol72_categories AS cat JOIN lol72_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 82
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-02-22 07:47:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-02-22 07:47:40')
ORDER BY a.title ASC
LIMIT 0, 4
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM lol72_categories AS c
WHERE c.published = 1
AND c.extension = "com_content"
AND c.access IN (1,1)
AND c.id IN (83)
ORDER BY c.id ASC
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lol72_categories as c
LEFT JOIN lol72_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lol72_categories AS cat JOIN lol72_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=83
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM lol72_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM lol72_content AS a
LEFT JOIN lol72_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN lol72_categories AS c
ON c.id = a.catid
LEFT JOIN lol72_users AS ua
ON ua.id = a.created_by
LEFT JOIN lol72_users AS uam
ON uam.id = a.modified_by
LEFT JOIN lol72_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lol72_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lol72_categories AS cat JOIN lol72_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 83
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-02-22 07:47:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-02-22 07:47:40')
ORDER BY a.title ASC
LIMIT 0, 4
SELECT DISTINCT c.id AS CID
FROM lol72_categories AS c
LEFT JOIN lol72_content AS content
ON c.id = content.catid
WHERE ( c.id = 82 )
AND c.extension = 'com_content'
AND c.published = 1
SELECT content.id AS IID, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage
FROM lol72_content AS content
WHERE content.state = 1
AND content.access IN (1,1)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2014-02-22 07:47:41' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2014-02-22 07:47:41' )
AND ( content.catid = 82 )
AND content.language in ('en-GB','*')
ORDER BY content.created DESC
LIMIT 0,10;
SELECT content.id AS IID, content.access AS access, categories.title AS cat, users.email AS author_email, users.name AS author, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as ID,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as CID
FROM lol72_content AS content
LEFT JOIN lol72_categories AS categories
ON categories.id = content.catid
LEFT JOIN lol72_users AS users
ON users.id = content.created_by
LEFT JOIN lol72_content_rating AS content_rating
ON content_rating.content_id = content.id
WHERE content.id = 102 OR content.id = 101 OR content.id = 92 OR content.id = 91 OR content.id = 89 OR content.id = 88 OR content.id = 87
ORDER BY content.created DESC
SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
WHERE `type` = 'component'
AND `element` = 'com_phocafont'
SELECT a.*
FROM lol72_phocafont_font AS a
WHERE a.published = 1
AND a.defaultfont = 1
UPDATE `lol72_session`
SET `data` = '__default|a:15:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1393055257;s:18:\"session.timer.last\";i:1393055257;s:17:\"session.timer.now\";i:1393055260;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:208:\"ZY9bDoJADEX30hUA8UHufPqvSzCVqTCBETIdNYawdxmRxMSvJue26bmMHKNiB7LycJWQYZRf4jm094GMIgOlkeegINyd1+SC7Iu1CiK3p7OxIeMWXKy4EVc38Zc7z7Vc++A5KpnjTMv5n/MSX4MsYAsaOLBPRhnGSbEBsbeWzClta7SHjlUJRfKdw+VWsU9ltI39x/2/yDRNbw==\";s:6:\"markup\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:19:\"js_id_currency_orig\";s:1:\"1\";s:14:\"js_id_currency\";s:1:\"1\";s:19:\"js_history_sel_lang\";s:5:\"en-GB\";s:15:\"js_prev_user_id\";i:0;s:22:\"jshop_checked_language\";a:2:{i:0;s:5:\"en-GB\";i:1;s:5:\"fa-IR\";}s:26:\"jshop_end_page_buy_product\";s:14:\"/index.php/en/\";s:27:\"jshop_end_page_list_product\";s:14:\"/index.php/en/\";}' , `time` = '1393055261'
WHERE `session_id` = '706827df55837d1b24f41168ef83df36'
56 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
7 × SELECT extension_id AS id, element AS "option", params, enabled
FROM lol72_extensions
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM lol72_categories AS c
2 × SELECT `ip`,`reason`
FROM lol72_rsfirewall_lists
2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM lol72_contact_details AS contact
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lol72_categories as c
LEFT JOIN lol72_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lol72_categories AS cat JOIN lol72_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT params
FROM lol72_extensions AS e
1 × select *
from lol72_session
1 × select *
from lol72_jvcounter_log
1 × select category_id as id, `alias_en-GB` as alias
from lol72_jshopping_categories
1 × select product_id as id, `alias_en-GB` as alias
from lol72_jshopping_products
1 × SELECT COUNT(distinct prod.product_id)
FROM `lol72_jshopping_products` as prod
LEFT JOIN `lol72_jshopping_products_to_categories` AS pr_cat USING (product_id)
LEFT JOIN `lol72_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.product_thumb_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 `lol72_jshopping_products` AS prod
LEFT JOIN `lol72_jshopping_products_to_categories` AS pr_cat USING (product_id)
LEFT JOIN `lol72_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
1 × select id,link
from lol72_menu
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lol72_modules AS m
LEFT JOIN lol72_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lol72_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.*
FROM lol72_phocafont_font AS a
1 × SELECT a.rules
FROM lol72_assets AS a
1 × SELECT b.rules
FROM lol72_assets AS a
LEFT JOIN lol72_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT content.id AS IID, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage
FROM lol72_content AS content
1 × SELECT id, rules
FROM `lol72_viewlevels
1 × SELECT b.id
FROM lol72_usergroups AS a
LEFT JOIN lol72_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT content.id AS IID, content.access AS access, categories.title AS cat, users.email AS author_email, users.name AS author, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as ID,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as CID
FROM lol72_content AS content
LEFT JOIN lol72_categories AS categories
ON categories.id = content.catid
LEFT JOIN lol72_users AS users
ON users.id = content.created_by
LEFT JOIN lol72_content_rating AS content_rating
ON content_rating.content_id = content.id
1 × SELECT tax_id, tax_name, tax_value
FROM `lol72_jshopping_taxes
1 × SELECT DISTINCT c.id AS CID
FROM lol72_categories AS c
LEFT JOIN lol72_content AS content
ON c.id = content.catid
1 × SELECT id
FROM lol72_jshopping_vendors
1 × SELECT *
FROM lol72_rsfirewall_configuratio
1 × SELECT time
FROM lol72_vvisit_counter USE INDEX(time)
1 × SELECT template
FROM lol72_template_styles
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM lol72_menu AS m
LEFT JOIN lol72_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `file`
FROM lol72_rsfirewall_hashes
1 × SELECT `path`
FROM lol72_rsfirewall_ignored
1 × SELECT folder AS type, element AS name, params
FROM lol72_extensions
1 × SELECT *
FROM lol72_languages
1 × SELECT COUNT(*)
FROM `lol72_menu`
1 × SELECT *
FROM lol72_rsfirewall_hashes
1 × SELECT *
FROM lol72_rsfirewall_snapshots
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `lol72_jshopping_currencies`
1 × select *
from lol72_jshopping_language
1 × SELECT id, alias, `title_en-GB` as title, `keyword_en-GB` as keyword, `description_en-GB` as description
FROM `lol72_jshopping_config_seo`
1 × SELECT `data`
FROM `lol72_session`
1 × SELECT *
FROM lol72_jshopping_config
1 × SELECT id, home, template, s.params
FROM lol72_template_styles as s
LEFT JOIN lol72_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM lol72_rsfirewall_exceptions
1 × SELECT p.folder AS type, p.element AS name
FROM lol72_mj_plugins AS mj
LEFT JOIN lol72_extensions AS p
ON p.extension_id=mj.id
1 × SELECT m.id, m.position
FROM lol72_mj_modules AS mj
LEFT JOIN lol72_modules AS m
ON m.id=mj.id
1 × SELECT *
FROM lol72_jshopping_vendors
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_users
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_products_reviews
1 × INSERT INTO lol72_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl)
VALUES('706827df55837d1b24f41168ef83df36','0','192.211.55.90','1393055257','1393055257','1','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36','',''
1 × UPDATE `lol72_session`
SET `data` = '__default|a:15:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1393055257;s:18:\"session.timer.last\";i:1393055257;s:17:\"session.timer.now\";i:1393055260;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.117 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:208:\"ZY9bDoJADEX30hUA8UHufPqvSzCVqTCBETIdNYawdxmRxMSvJue26bmMHKNiB7LycJWQYZRf4jm094GMIgOlkeegINyd1+SC7Iu1CiK3p7OxIeMWXKy4EVc38Zc7z7Vc++A5KpnjTMv5n/MSX4MsYAsaOLBPRhnGSbEBsbeWzClta7SHjlUJRfKdw+VWsU9ltI39x/2/yDRNbw==\";s:6:\"markup\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:19:\"js_id_currency_orig\";s:1:\"1\";s:14:\"js_id_currency\";s:1:\"1\";s:19:\"js_history_sel_lang\";s:5:\"en-GB\";s:15:\"js_prev_user_id\";i:0;s:22:\"jshop_checked_language\";a:2:{i:0;s:5:\"en-GB\";i:1;s:5:\"fa-IR\";}s:26:\"jshop_end_page_buy_product\";s:14:\"/index.php/en/\";s:27:\"jshop_end_page_list_product\";s:14:\"/index.php/en/\";}' , `time` = '1393055261'
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_taxes
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_vendors
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_config
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_currencies
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_products
1 × SHOW FULL COLUMNS
FROM `lol72_jshopping_config_seo
1 × SHOW FULL COLUMNS
FROM `lol72_rsfirewall_logs
