Joomla! Debug Console

93 Queries Logged

1. SELECT `data`
  FROM `jar_session`
  WHERE `session_id` = '9b6a271810601767375a9925f9e232c9'
2. DELETE
  FROM `jar_session`
  WHERE `time` < '1337571051'
3. SELECT folder AS type, element AS name, params
  FROM jar_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
4. SELECT *
  FROM jar_languages
  WHERE published=1
  ORDER BY ordering ASC
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jar_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
6. 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 jar_menu AS m
  LEFT JOIN jar_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
7. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jar_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
8. SELECT id, home, template, s.params
  FROM jar_template_styles as s
  LEFT JOIN jar_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
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jar_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
10. SELECT b.id
  FROM jar_usergroups AS a
  LEFT JOIN jar_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
11. SELECT a.rules
  FROM jar_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
12. SELECT b.rules
  FROM jar_assets AS a
  LEFT JOIN jar_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
13. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, 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,contact.id 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 jar_content AS a
  LEFT JOIN jar_categories AS c
  ON c.id = a.catid
  LEFT JOIN jar_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jar_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM jar_contact_details AS contact
  WHERE contact.published = 1
  GROUP BY contact.user_id, contact.language) AS contact
  ON contact.user_id = a.created_by
  LEFT JOIN jar_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN jar_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM jar_categories AS cat JOIN jar_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
  INNER JOIN jar_content_frontpage AS fp
  ON fp.content_id = a.id
  WHERE a.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-21 03:45:52')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-21 03:45:52')
  AND a.language in ('en-GB','*')
  AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
  GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  ORDER BY c.lft, fp.ordering, a.created DESC
  LIMIT 0, 4
14. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, 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,contact.id 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 jar_content AS a
  LEFT JOIN jar_categories AS c
  ON c.id = a.catid
  LEFT JOIN jar_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jar_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM jar_contact_details AS contact
  WHERE contact.published = 1
  GROUP BY contact.user_id, contact.language) AS contact
  ON contact.user_id = a.created_by
  LEFT JOIN jar_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN jar_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM jar_categories AS cat JOIN jar_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
  INNER JOIN jar_content_frontpage AS fp
  ON fp.content_id = a.id
  WHERE a.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-21 03:45:52')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-21 03:45:52')
  AND a.language in ('en-GB','*')
  AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
  GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  ORDER BY c.lft, fp.ordering, a.created DESC
15. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jar_modules AS m
  LEFT JOIN jar_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jar_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 <= '2012-05-21 03:45:52')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-21 03:45:52')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 101 OR mm.menuid <= 0)
  AND m.language IN ('en-GB','*')
  ORDER BY m.position, m.ordering
16. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jar_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_finder'
17. SELECT name
  FROM `jar_extensions`
  WHERE `type` = 'plugin'
  AND `folder` = 'finder'
  AND `enabled` = 1
18. SELECT `title`
  FROM `jar_finder_taxonomy`
  WHERE `parent_id` = 1
  AND `state` = 1
  AND `access` IN (1,1)
19. SELECT t.*, count(c.id) AS children
  FROM `jar_finder_taxonomy` AS t
  INNER JOIN `jar_finder_taxonomy` AS c
  ON c.parent_id = t.id
  WHERE `t`.`parent_id` = 1
  AND `t`.`state` = 1
  AND `t`.`access` IN (1,1)
  AND `c`.`state` = 1
  AND `t`.`access` IN (1,1)
  GROUP BY `t`.`id`
  ORDER BY t.ordering, t.title
20. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jar_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_djimageslider'
21. SELECT a.*
  FROM jar_djimageslider AS a
  WHERE a.catid = 10
  AND a.published = 1
  ORDER BY RAND()
  LIMIT 0, 20
22. SELECT `link`
  FROM `jar_menu`
  WHERE `published`=1
  AND `id`='101'
23. SELECT a.*
  FROM jar_djimageslider AS a
  WHERE a.catid = 9
  AND a.published = 1
  ORDER BY a.ordering ASC
  LIMIT 0, 20
24. SELECT *
  FROM jar_youtubegallery
  WHERE id=1
  LIMIT 1
25. SELECT *
  FROM jar_youtubegallery
  WHERE id=1
  LIMIT 1
26. SELECT id, allowupdates
  FROM jar_youtubegallery_videos
  WHERE `videosource`="youtube"
  AND `videoid`="UzZYDsXfGeg"
  AND `galleryid`=1
  LIMIT 1
27. SELECT id, allowupdates
  FROM jar_youtubegallery_videos
  WHERE `videosource`="youtube"
  AND `videoid`="UzZYDsXfGeg"
  AND `galleryid`=1
  LIMIT 1
28. UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="UzZYDsXfGeg", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=UzZYDsXfGeg", `isvideo`="1"
  WHERE id=1
29. UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="UzZYDsXfGeg", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=UzZYDsXfGeg", `isvideo`="1"
  WHERE id=1
30. SELECT id, allowupdates
  FROM jar_youtubegallery_videos
  WHERE `videosource`="youtube"
  AND `videoid`="ivX-gXz9mrk"
  AND `galleryid`=1
  LIMIT 1
31. SELECT id, allowupdates
  FROM jar_youtubegallery_videos
  WHERE `videosource`="youtube"
  AND `videoid`="ivX-gXz9mrk"
  AND `galleryid`=1
  LIMIT 1
32. UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="ivX-gXz9mrk", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=ivX-gXz9mrk", `isvideo`="1"
  WHERE id=3
33. UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="ivX-gXz9mrk", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=ivX-gXz9mrk", `isvideo`="1"
  WHERE id=3
34. SELECT id, allowupdates
  FROM jar_youtubegallery_videos
  WHERE `videosource`="youtube"
  AND `videoid`="JK-pQ20qS70"
  AND `galleryid`=1
  LIMIT 1
35. SELECT id, allowupdates
  FROM jar_youtubegallery_videos
  WHERE `videosource`="youtube"
  AND `videoid`="JK-pQ20qS70"
  AND `galleryid`=1
  LIMIT 1
36. UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="JK-pQ20qS70", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=JK-pQ20qS70&", `isvideo`="1"
  WHERE id=5
37. UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="JK-pQ20qS70", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=JK-pQ20qS70&", `isvideo`="1"
  WHERE id=5
38. DELETE
  FROM jar_youtubegallery_videos
  WHERE galleryid=1
  AND allowupdates
  AND id!=1
  AND id!=3
  AND id!=5
39. UPDATE jar_youtubegallery
  SET `lastplaylistupdate`="2012-05-20 23:45:54"
  WHERE `id`="1"
40. SELECT *
  FROM jar_youtubegallery_videos
  WHERE `galleryid`="1"
  AND `isvideo`
41. SELECT *
  FROM jar_youtubegallery_videos
  WHERE `galleryid`="1"
  AND `isvideo`
  LIMIT 0, 20
42. SELECT *
  FROM jar_youtubegallery_videos
  WHERE `galleryid`="1"
  AND `isvideo`
  LIMIT 0, 20
43. SHOW TABLES LIKE "%virtuemart_configs%"
44. SELECT `config`
  FROM `jar_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
45. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `jar_virtuemart_permgroups`
  ORDER BY `group_level`
46. SELECT DISTINCT jar_virtuemart_products.virtuemart_product_id
  FROM jar_virtuemart_products,jar_virtuemart_product_categories
  WHERE jar_virtuemart_products.published="1"
  AND jar_virtuemart_products.product_special="1"
  ORDER BY RAND()
  LIMIT 4
47. SHOW FULL COLUMNS
  FROM `jar_virtuemart_products`
48. SELECT `jar_virtuemart_products_es_es`.* ,`jar_virtuemart_products`.* ,`jar_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jar_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jar_virtuemart_products_es_es` JOIN jar_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jar_virtuemart_product_manufacturers`
  on `jar_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  LEFT JOIN `jar_virtuemart_product_customfields`
  on `jar_virtuemart_product_customfields`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  WHERE jar_virtuemart_products_es_es.`virtuemart_product_id` = "48"
49. SELECT `virtuemart_media_id`
  FROM `jar_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "48"
  ORDER BY `ordering`
50. SELECT `virtuemart_shoppergroup_id`
  FROM `jar_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "48"
51. SHOW FULL COLUMNS
  FROM `jar_virtuemart_product_prices`
52. SELECT `jar_virtuemart_product_prices`.*
  FROM `jar_virtuemart_product_prices`
  WHERE jar_virtuemart_product_prices.`virtuemart_product_id` = "48"
53. SELECT `virtuemart_category_id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "48"
54. SELECT `ordering`,`id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "48"
  and `virtuemart_category_id`= "6"
55. SHOW FULL COLUMNS
  FROM `jar_virtuemart_categories`
56. SELECT `jar_virtuemart_categories_es_es`.* ,`jar_virtuemart_categories`.*
  FROM `jar_virtuemart_categories_es_es` JOIN jar_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jar_virtuemart_categories_es_es.`virtuemart_category_id` = "6"
57. SELECT `vendor_currency`
  FROM `jar_virtuemart_vendors`
  WHERE `virtuemart_vendor_id`="1"
58. SELECT `price_display`,`custom_price_display`
  FROM `jar_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
59. SELECT *
  FROM `jar_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="144"
60. SELECT *
  FROM jar_virtuemart_calcs
  WHERE `calc_kind` IN ('Marge','Tax','DBTax','DATax' )
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2012-05-21 03:45:52" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2012-05-21 03:45:52" )
61. SELECT `virtuemart_shoppergroup_id`
  FROM `jar_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
62. SELECT *
  FROM `jar_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND `virtuemart_vendor_id` = "1"
63. SELECT `virtuemart_userinfo_id`
  FROM `jar_virtuemart_userinfos`
  WHERE `virtuemart_user_id` = "0"
64. SELECT `jar_virtuemart_products_es_es`.* ,`jar_virtuemart_products`.* ,`jar_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jar_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jar_virtuemart_products_es_es` JOIN jar_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jar_virtuemart_product_manufacturers`
  on `jar_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  LEFT JOIN `jar_virtuemart_product_customfields`
  on `jar_virtuemart_product_customfields`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  WHERE jar_virtuemart_products_es_es.`virtuemart_product_id` = "46"
65. SELECT `virtuemart_media_id`
  FROM `jar_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "46"
  ORDER BY `ordering`
66. SELECT `virtuemart_shoppergroup_id`
  FROM `jar_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "46"
67. SELECT `jar_virtuemart_product_prices`.*
  FROM `jar_virtuemart_product_prices`
  WHERE jar_virtuemart_product_prices.`virtuemart_product_id` = "46"
68. SELECT `virtuemart_category_id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "46"
69. SELECT `ordering`,`id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "46"
  and `virtuemart_category_id`= "6"
70. SELECT `jar_virtuemart_categories_es_es`.* ,`jar_virtuemart_categories`.*
  FROM `jar_virtuemart_categories_es_es` JOIN jar_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jar_virtuemart_categories_es_es.`virtuemart_category_id` = "6"
71. SELECT `jar_virtuemart_products_es_es`.* ,`jar_virtuemart_products`.* ,`jar_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jar_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jar_virtuemart_products_es_es` JOIN jar_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jar_virtuemart_product_manufacturers`
  on `jar_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  LEFT JOIN `jar_virtuemart_product_customfields`
  on `jar_virtuemart_product_customfields`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  WHERE jar_virtuemart_products_es_es.`virtuemart_product_id` = "51"
72. SELECT `virtuemart_media_id`
  FROM `jar_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "51"
  ORDER BY `ordering`
73. SELECT `virtuemart_shoppergroup_id`
  FROM `jar_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "51"
74. SELECT `jar_virtuemart_product_prices`.*
  FROM `jar_virtuemart_product_prices`
  WHERE jar_virtuemart_product_prices.`virtuemart_product_id` = "51"
75. SELECT `virtuemart_category_id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "51"
76. SELECT `ordering`,`id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "51"
  and `virtuemart_category_id`= "6"
77. SELECT `jar_virtuemart_categories_es_es`.* ,`jar_virtuemart_categories`.*
  FROM `jar_virtuemart_categories_es_es` JOIN jar_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jar_virtuemart_categories_es_es.`virtuemart_category_id` = "6"
78. SELECT `jar_virtuemart_products_es_es`.* ,`jar_virtuemart_products`.* ,`jar_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jar_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jar_virtuemart_products_es_es` JOIN jar_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jar_virtuemart_product_manufacturers`
  on `jar_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  LEFT JOIN `jar_virtuemart_product_customfields`
  on `jar_virtuemart_product_customfields`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  WHERE jar_virtuemart_products_es_es.`virtuemart_product_id` = "1"
79. SELECT `virtuemart_media_id`
  FROM `jar_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1"
  ORDER BY `ordering`
80. SELECT `virtuemart_shoppergroup_id`
  FROM `jar_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1"
81. SELECT `jar_virtuemart_product_prices`.*
  FROM `jar_virtuemart_product_prices`
  WHERE jar_virtuemart_product_prices.`virtuemart_product_id` = "1"
82. SELECT `virtuemart_category_id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1"
83. SELECT `ordering`,`id`
  FROM `jar_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1"
  and `virtuemart_category_id`= "6"
84. SELECT `jar_virtuemart_categories_es_es`.* ,`jar_virtuemart_categories`.*
  FROM `jar_virtuemart_categories_es_es` JOIN jar_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jar_virtuemart_categories_es_es.`virtuemart_category_id` = "6"
85. SHOW FULL COLUMNS
  FROM `jar_virtuemart_medias`
86. SELECT `jar_virtuemart_medias`.*
  FROM `jar_virtuemart_medias`
  WHERE jar_virtuemart_medias.`virtuemart_media_id` = "38"
87. SELECT `jar_virtuemart_medias`.*
  FROM `jar_virtuemart_medias`
  WHERE jar_virtuemart_medias.`virtuemart_media_id` = "37"
88. SELECT `jar_virtuemart_medias`.*
  FROM `jar_virtuemart_medias`
  WHERE jar_virtuemart_medias.`virtuemart_media_id` = "39"
89. SELECT `jar_virtuemart_medias`.*
  FROM `jar_virtuemart_medias`
  WHERE jar_virtuemart_medias.`virtuemart_media_id` = "36"
90. SELECT *
  FROM jar_banners
  WHERE '2012-05-21 03:45:52' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
91. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jar_banners as a
  LEFT JOIN jar_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.language in ('en-GB','*')
  ORDER BY a.sticky DESC,a.ordering
92. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jar_banners as a
  LEFT JOIN jar_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.language in ('en-GB','*')
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
93. UPDATE `jar_session`
  SET `data` = 'B_G9IM1lUCJlEIM3xEe9YHFCL2GkY-B8xDtpbc8xYTD_INlJUnYkDPqlD5ScSR2lJn3HXjhloD62A9aEzcFeDvBm1tIZXbxLhO1TlMXQEG-aQbRf5onee5a6VOOIH7b3YxLtbNqZKTr_Gq47TlYtonFs1-KPX1oOnxKqA0V6BAl1DTpUvG9RNKl8nwxWybkr2T919rDnvEbR1NjiC0wjQosXps7K_6s_99kL1Z7XDojFPGqHx7rq21mJe9riTIBi2vzJytLzPcuWnySMzQqaW8HJ3Av9NAXd7nZoPotz_99UclAHNF1XgYYLuQYKksIAaamLKhSUe5M4WQ4s9TqAD6i2mMs8vQgWFjxe0xLlyi5u8q4WBscLWk7QqyDyjF65q2UKiiAcagy-n851jA0y22WEqE92OMDcdPTXB5WW0YGX_bdORoLXeWwgQzFJYExv2tl5WjNFCmT0E5sdOCBrpFO6nBZE4ZDvcUw9IPYN4dFctvTEqm26rfEHW4rPyoPyYeI2crpjfTKNtRX4irIIdDLnh4jwLf57JVqDsjTJ1xFSmZ06N-dlHRHosW-py09RbL83P3tIEwS1vmVW6p6H3cOpadxFKLiFv5KrQKcfvF51xGHRJzFr1-w3ir8LLQRdgyeR3j42N5PQtNuV5qizRSQ7Zx4gR9xI5FddHXl4nv7rJZWVGFRZmLHwEW_rTmWPbZ4Lf3wcVsLLNtpVt06b24fzyV3NPeqN2k4mSjhkfdx3W-nclHBqWPvWr9X7Vkvy2MMNFUIThYRHaxFo8XLI9BPcp4lWgnzBpXD35ScR9Uq-LDFMigatulK7QM0Fuu7wkgOsJenlGJ-HVz98cA_lGDAKy7f7Wsh97Qmse-fKoocV1bK7JOqPa_yZEReocikWPHMSQcEL_ILjtSsw5lSEvS4W1W5GrZ68z9W82_ueKxNijrUexr9VGO5aFz5ZONuL_b7FDDL8yn37W-KwBaKB8D9hmeFAbZzhS4-4PIFagrStSmu7mpOzhb7ONyA_whao1ButTWY7AjDNRc6xW3ah3-E76xMDWt0i55SmpwohHdQpQZkA3mfXi3rSYqYS-zSm2vXKNL0qVDTeMUCpOl0VWso60MtBbEdkB_xeki7iLC_iSoB7eXe-l5JK0umRR-V8GwabawDBotP7skLienJbwAYoWpxT98Vi9wQW995RVgNgEc7T0SlPxV82R0XRNKfZz_O7rfKO6xIXrM3McRxCHA8PTWiU1CSrc6zfCaSgKun7Jaa14DdVF4oKUdQ0Gn4ki1ESti8w5_ZpcHlmSGBQ_PbP3iNCHjRA5EcJgonhywHZFEmhH6Sq7si8ZMA5L-ecf9imMp4mdX3JvKQCr8Ik0EwctyxMMITCUyu93T9WSBBwm4gLYurJ3NgTmYj6zmuSNdyen_V5leoq9_qMz-Y2bPeRYKhV0_zGv3nsIjw8qoPDGYKVFjzvBabIfrD64gKUVeKDbZ_fcSaDvORdBMp3P6WwuR7hrYTgWMiRIuIqwmPv_zTSMm9w4xgOlrUHcQBvcD66Cx8yupvBpvaWofJNuA1p2rIHHfmzg2xrpxlnTPFR0K5KNiDIl1HqWd4qUFKmQ8R82yIj907jvp8K_pK82-jFAdRK5qLsC5X8bl76p4dLzHLtKaVFsDdFAfRmz8K_hyTpwYat5MzPWaNYJc47ugliQDuA4s8qob6fsLMiLqIa-f83w9FjO5CkrubrYqcP7pFVKZcKHe97ilL5CGna8EjlLBqlQiiwbU3jB3zGp8qlkPrTU9iyAQFMVsQaDXrdB7T-DU-HnjEUys1OtHx7XBMVaAia3jrMzFEl8HGYVNX5JApeej1lztRyvZEI30WKQ-ceIBOGjT4lJ0fkwc3ebW3MU8Xum0yvcLp8hiMM3Yr_WVvgq13uNlGaRnIHkIuxGCKbE3x-F4oyv7w-rPbARHGT4nzhBAfzCz1E1qlvAOnO2HgnWMpllQLkpTSQMiIVullVt-cpVZUWHg1vteeQljmLO3W22TQZbb2tLuFzuyHOYWMoHlD6yZ6qsVU6-TZI' , `time` = '1337571958'
  WHERE `session_id` = '9b6a271810601767375a9925f9e232c9'

51 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 6 × SELECT id, allowupdates
  FROM jar_youtubegallery_videos
2. 5 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM jar_extensions
3. 4 × SELECT `ordering`,`id`
  FROM `jar_virtuemart_product_categories`
4. 4 × SELECT `virtuemart_media_id`
  FROM `jar_virtuemart_product_medias`
5. 4 × SELECT `jar_virtuemart_categories_es_es`.* ,`jar_virtuemart_categories`.*
  FROM `jar_virtuemart_categories_es_es` JOIN jar_virtuemart_categories using (`virtuemart_category_id`)
6. 4 × SELECT `jar_virtuemart_product_prices`.*
  FROM `jar_virtuemart_product_prices`
7. 4 × SELECT `virtuemart_category_id`
  FROM `jar_virtuemart_product_categories`
8. 4 × SELECT `jar_virtuemart_products_es_es`.* ,`jar_virtuemart_products`.* ,`jar_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jar_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jar_virtuemart_products_es_es` JOIN jar_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jar_virtuemart_product_manufacturers`
  on `jar_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
  LEFT JOIN `jar_virtuemart_product_customfields`
  on `jar_virtuemart_product_customfields`.`virtuemart_product_id`=`jar_virtuemart_products_es_es`.`virtuemart_product_id`
9. 4 × SELECT `virtuemart_shoppergroup_id`
  FROM `jar_virtuemart_product_shoppergroups`
10. 4 × SELECT `jar_virtuemart_medias`.*
  FROM `jar_virtuemart_medias`
11. 3 × SELECT *
  FROM jar_youtubegallery_videos
12. 2 × SELECT a.*
  FROM jar_djimageslider AS a
13. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jar_banners as a
  LEFT JOIN jar_banner_clients AS cl
  ON cl.id = a.cid
14. 2 × SELECT *
  FROM jar_youtubegallery
15. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, 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,contact.id 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 jar_content AS a
  LEFT JOIN jar_categories AS c
  ON c.id = a.catid
  LEFT JOIN jar_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jar_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM jar_contact_details AS contact
16. 1 × SELECT `price_display`,`custom_price_display`
  FROM `jar_virtuemart_shoppergroups` AS `sg`
17. 1 × SELECT `virtuemart_userinfo_id`
  FROM `jar_virtuemart_userinfos`
18. 1 × SELECT *
  FROM jar_banners
19. 1 × SELECT *
  FROM `jar_virtuemart_shoppergroups`
20. 1 × SELECT `virtuemart_shoppergroup_id`
  FROM `jar_virtuemart_vmuser_shoppergroups`
21. 1 × SELECT *
  FROM `jar_virtuemart_currencies`
22. 1 × SELECT *
  FROM jar_virtuemart_calcs
23. 1 × SELECT `vendor_currency`
  FROM `jar_virtuemart_vendors`
24. 1 × SELECT `config`
  FROM `jar_virtuemart_configs`
25. 1 × SELECT b.id
  FROM jar_usergroups AS a
  LEFT JOIN jar_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
26. 1 × SELECT a.rules
  FROM jar_assets AS a
27. 1 × SELECT id, home, template, s.params
  FROM jar_template_styles as s
  LEFT JOIN jar_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
28. 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 jar_menu AS m
  LEFT JOIN jar_extensions AS e
  ON m.component_id = e.extension_id
29. 1 × SELECT folder AS type, element AS name, params
  FROM jar_extensions
30. 1 × SELECT *
  FROM jar_languages
31. 1 × SELECT b.rules
  FROM jar_assets AS a
  LEFT JOIN jar_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
32. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jar_modules AS m
  LEFT JOIN jar_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jar_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
33. 1 × SELECT `data`
  FROM `jar_session`
34. 1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `jar_virtuemart_permgroups`
35. 1 × SELECT `link`
  FROM `jar_menu`
36. 1 × SELECT t.*, count(c.id) AS children
  FROM `jar_finder_taxonomy` AS t
  INNER JOIN `jar_finder_taxonomy` AS c
  ON c.parent_id = t.id
37. 1 × SELECT name
  FROM `jar_extensions`
38. 1 × SELECT `title`
  FROM `jar_finder_taxonomy`
39. 1 × SELECT DISTINCT jar_virtuemart_products.virtuemart_product_id
  FROM jar_virtuemart_products,jar_virtuemart_product_categories

OTHER Tables:

1. 2 × UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="ivX-gXz9mrk", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=ivX-gXz9mrk", `isvideo`="1"
2. 2 × UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="JK-pQ20qS70", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=JK-pQ20qS70&", `isvideo`="1"
3. 2 × UPDATE jar_youtubegallery_videos
  SET `galleryid`="1", `parentid`="0", `videosource`="youtube", `videoid`="UzZYDsXfGeg", `custom_imageurl`="", `custom_title`="", `custom_description`="", `specialparams`="", `link`="http://www.youtube.com/watch?v=UzZYDsXfGeg", `isvideo`="1"
4. 1 × SHOW FULL COLUMNS
  FROM `jar_virtuemart_categories
5. 1 × SHOW FULL COLUMNS
  FROM `jar_virtuemart_medias
6. 1 × UPDATE `jar_session`
  SET `data` = 'B_G9IM1lUCJlEIM3xEe9YHFCL2GkY-B8xDtpbc8xYTD_INlJUnYkDPqlD5ScSR2lJn3HXjhloD62A9aEzcFeDvBm1tIZXbxLhO1TlMXQEG-aQbRf5onee5a6VOOIH7b3YxLtbNqZKTr_Gq47TlYtonFs1-KPX1oOnxKqA0V6BAl1DTpUvG9RNKl8nwxWybkr2T919rDnvEbR1NjiC0wjQosXps7K_6s_99kL1Z7XDojFPGqHx7rq21mJe9riTIBi2vzJytLzPcuWnySMzQqaW8HJ3Av9NAXd7nZoPotz_99UclAHNF1XgYYLuQYKksIAaamLKhSUe5M4WQ4s9TqAD6i2mMs8vQgWFjxe0xLlyi5u8q4WBscLWk7QqyDyjF65q2UKiiAcagy-n851jA0y22WEqE92OMDcdPTXB5WW0YGX_bdORoLXeWwgQzFJYExv2tl5WjNFCmT0E5sdOCBrpFO6nBZE4ZDvcUw9IPYN4dFctvTEqm26rfEHW4rPyoPyYeI2crpjfTKNtRX4irIIdDLnh4jwLf57JVqDsjTJ1xFSmZ06N-dlHRHosW-py09RbL83P3tIEwS1vmVW6p6H3cOpadxFKLiFv5KrQKcfvF51xGHRJzFr1-w3ir8LLQRdgyeR3j42N5PQtNuV5qizRSQ7Zx4gR9xI5FddHXl4nv7rJZWVGFRZmLHwEW_rTmWPbZ4Lf3wcVsLLNtpVt06b24fzyV3NPeqN2k4mSjhkfdx3W-nclHBqWPvWr9X7Vkvy2MMNFUIThYRHaxFo8XLI9BPcp4lWgnzBpXD35ScR9Uq-LDFMigatulK7QM0Fuu7wkgOsJenlGJ-HVz98cA_lGDAKy7f7Wsh97Qmse-fKoocV1bK7JOqPa_yZEReocikWPHMSQcEL_ILjtSsw5lSEvS4W1W5GrZ68z9W82_ueKxNijrUexr9VGO5aFz5ZONuL_b7FDDL8yn37W-KwBaKB8D9hmeFAbZzhS4-4PIFagrStSmu7mpOzhb7ONyA_whao1ButTWY7AjDNRc6xW3ah3-E76xMDWt0i55SmpwohHdQpQZkA3mfXi3rSYqYS-zSm2vXKNL0qVDTeMUCpOl0VWso60MtBbEdkB_xeki7iLC_iSoB7eXe-l5JK0umRR-V8GwabawDBotP7skLienJbwAYoWpxT98Vi9wQW995RVgNgEc7T0SlPxV82R0XRNKfZz_O7rfKO6xIXrM3McRxCHA8PTWiU1CSrc6zfCaSgKun7Jaa14DdVF4oKUdQ0Gn4ki1ESti8w5_ZpcHlmSGBQ_PbP3iNCHjRA5EcJgonhywHZFEmhH6Sq7si8ZMA5L-ecf9imMp4mdX3JvKQCr8Ik0EwctyxMMITCUyu93T9WSBBwm4gLYurJ3NgTmYj6zmuSNdyen_V5leoq9_qMz-Y2bPeRYKhV0_zGv3nsIjw8qoPDGYKVFjzvBabIfrD64gKUVeKDbZ_fcSaDvORdBMp3P6WwuR7hrYTgWMiRIuIqwmPv_zTSMm9w4xgOlrUHcQBvcD66Cx8yupvBpvaWofJNuA1p2rIHHfmzg2xrpxlnTPFR0K5KNiDIl1HqWd4qUFKmQ8R82yIj907jvp8K_pK82-jFAdRK5qLsC5X8bl76p4dLzHLtKaVFsDdFAfRmz8K_hyTpwYat5MzPWaNYJc47ugliQDuA4s8qob6fsLMiLqIa-f83w9FjO5CkrubrYqcP7pFVKZcKHe97ilL5CGna8EjlLBqlQiiwbU3jB3zGp8qlkPrTU9iyAQFMVsQaDXrdB7T-DU-HnjEUys1OtHx7XBMVaAia3jrMzFEl8HGYVNX5JApeej1lztRyvZEI30WKQ-ceIBOGjT4lJ0fkwc3ebW3MU8Xum0yvcLp8hiMM3Yr_WVvgq13uNlGaRnIHkIuxGCKbE3x-F4oyv7w-rPbARHGT4nzhBAfzCz1E1qlvAOnO2HgnWMpllQLkpTSQMiIVullVt-cpVZUWHg1vteeQljmLO3W22TQZbb2tLuFzuyHOYWMoHlD6yZ6qsVU6-TZI' , `time` = '1337571958'
7. 1 × SHOW FULL COLUMNS
  FROM `jar_virtuemart_product_prices
8. 1 × UPDATE jar_youtubegallery
  SET `lastplaylistupdate`="2012-05-20 23:45:54"
9. 1 × DELETE
  FROM jar_youtubegallery_videos
10. 1 × DELETE
  FROM `jar_session`
11. 1 × SHOW TABLES LIKE "%virtuemart_configs%
12. 1 × SHOW FULL COLUMNS
  FROM `jar_virtuemart_products