Joomla templates by a4joomla

Profile Information

Application 0.001 seconds (+0.001); 0.57 MB (+0.568) - afterLoad
Application 0.042 seconds (+0.041); 3.09 MB (+2.520) - afterInitialise
Application 0.050 seconds (+0.008); 3.80 MB (+0.710) - afterRoute
Application 0.132 seconds (+0.082); 10.19 MB (+6.395) - afterDispatch
Application 0.135 seconds (+0.003); 10.35 MB (+0.156) - beforeRenderModule mod_menu (Main Menu)
Application 0.143 seconds (+0.008); 10.48 MB (+0.135) - afterRenderModule mod_menu (Main Menu)
Application 0.143 seconds (+0.000); 10.48 MB (-0.008) - beforeRenderModule mod_virtuemart_cart (Carro de Compra)
Application 0.150 seconds (+0.006); 11.15 MB (+0.675) - afterRenderModule mod_virtuemart_cart (Carro de Compra)
Application 0.150 seconds (+0.000); 11.15 MB (-0.004) - beforeRenderModule mod_login (Login Form)
Application 0.152 seconds (+0.002); 11.18 MB (+0.031) - afterRenderModule mod_login (Login Form)
Application 0.152 seconds (+0.000); 11.18 MB (-0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.153 seconds (+0.001); 11.20 MB (+0.024) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.154 seconds (+0.001); 11.28 MB (+0.076) - afterRender

Memory Usage

11.32 MB (11,871,736 Bytes)

136 Queries Logged

  1. SELECT `data`
      FROM `j25_session`
      WHERE `session_id` = 'vtr6ufl3tbidccikoqm7shmhb1'
  2. SELECT `session_id`
      FROM `j25_session`
      WHERE `session_id` = 'vtr6ufl3tbidccikoqm7shmhb1'
      LIMIT 0, 1
  3. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
      VALUES ('vtr6ufl3tbidccikoqm7shmhb1', 0, 1490271850)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j25_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `j25_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM j25_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j25_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. SELECT m.id, m.menutype, m.title, m.alias, 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 j25_menu AS m
      LEFT JOIN j25_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
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j25_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_virtuemart'
  10. SELECT *
      FROM j25_languages
      WHERE published=1
      ORDER BY ordering ASC
  11. SELECT id, home, template, s.params
      FROM j25_template_styles as s
      LEFT JOIN j25_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
  12. SHOW TABLES LIKE "j25_virtuemart_configs"
  13. SELECT `config`
      FROM `j25_virtuemart_configs`
      WHERE `virtuemart_config_id` = "1";
  14. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_category_medias`
      WHERE `virtuemart_category_id` = "0"
      ORDER BY `ordering`
  15. SELECT `category_child_id`
      FROM `j25_virtuemart_category_categories`
      WHERE `category_parent_id` = 0
  16. SELECT a.rules
      FROM j25_assets AS a
      WHERE a.id = 1
  17. SELECT b.rules
      FROM j25_assets AS a
      LEFT JOIN j25_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
      ORDER BY b.lft
  18. SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
      FROM `j25_virtuemart_categories_en_gb` l JOIN `j25_virtuemart_categories` AS c using (`virtuemart_category_id`)
      LEFT JOIN `j25_virtuemart_category_categories` AS cx
      ON l.`virtuemart_category_id` = cx.`category_child_id`
      WHERE c.`published` = 1
      AND cx.`category_parent_id` = 0
      AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
      ORDER BY category_name ASC
      LIMIT 0, 20
  19. SELECT FOUND_ROWS()
  20. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_vmuser_shoppergroups`
      WHERE `virtuemart_user_id` = "0"
  21. SELECT *
      FROM `j25_virtuemart_shoppergroups`
      WHERE `default` = "2"
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
      AND `published`="1"
  22. SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
      FROM `j25_virtuemart_products` as p
      INNER JOIN `j25_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_shoppergroups` as ps
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_categories` as pc
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_categories_en_gb` as c
      ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
      WHERE ( p.`published`="1"
      AND `pc`.`virtuemart_category_id` > 0
      AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
      group by p.`virtuemart_product_id`
      ORDER BY `category_name` ASC
      LIMIT 0, 20
  23. SELECT FOUND_ROWS()
  24. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "5"
  25. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "5"
      ORDER BY `ordering`
  26. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "5"
  27. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "5"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  28. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 5
  29. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 5
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  30. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "5"
      and `virtuemart_category_id`= "2"
  31. SELECT `j25_virtuemart_categories`.* ,`j25_virtuemart_categories_en_gb`.*
      FROM `j25_virtuemart_categories`
      INNER JOIN `j25_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
      WHERE `j25_virtuemart_categories`.`virtuemart_category_id` = "2"
  32. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
      FROM `j25_virtuemart_vendors` AS v
      LEFT JOIN `j25_virtuemart_currencies` AS c
      ON virtuemart_currency_id = vendor_currency
      WHERE v.`virtuemart_vendor_id`="1"
  33. SELECT *
      FROM `j25_virtuemart_currencies`
      WHERE `virtuemart_currency_id`="47"
  34. SELECT `price_display`,`custom_price_display`
      FROM `j25_virtuemart_shoppergroups` AS `sg`
      WHERE `sg`.`default` = "2"
  35. SELECT *
      FROM `j25_virtuemart_shoppergroups`
      WHERE `default` = "2"
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
      AND `published`="1"
  36. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind` IN ('Marge','Tax','VatTax','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 <= "2017-03-23 12:24:10" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:24:10" ) OR `for_override` = "1" )
  37. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "6"
  38. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "6"
      ORDER BY `ordering`
  39. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "6"
  40. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "6"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  41. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 6
  42. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 6
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  43. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "6"
      and `virtuemart_category_id`= "2"
  44. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "7"
  45. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "7"
      ORDER BY `ordering`
  46. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "7"
  47. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "7"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  48. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 7
  49. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 7
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  50. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "7"
      and `virtuemart_category_id`= "2"
  51. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "15"
  52. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "15"
      ORDER BY `ordering`
  53. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "15"
  54. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "15"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  55. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 15
  56. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 15
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  57. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "15"
      and `virtuemart_category_id`= "2"
  58. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "3"
  59. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "3"
      ORDER BY `ordering`
  60. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "3"
  61. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "3"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  62. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 3
  63. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 3
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  64. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "3"
      and `virtuemart_category_id`= "1"
  65. SELECT `j25_virtuemart_categories`.* ,`j25_virtuemart_categories_en_gb`.*
      FROM `j25_virtuemart_categories`
      INNER JOIN `j25_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
      WHERE `j25_virtuemart_categories`.`virtuemart_category_id` = "1"
  66. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "4"
  67. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "4"
      ORDER BY `ordering`
  68. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "4"
  69. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "4"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  70. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 4
  71. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 4
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  72. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "4"
      and `virtuemart_category_id`= "1"
  73. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "1"
  74. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "1"
      ORDER BY `ordering`
  75. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "1"
  76. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "1"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  77. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 1
  78. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 1
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  79. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "1"
      and `virtuemart_category_id`= "1"
  80. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "8"
  81. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "8"
      ORDER BY `ordering`
  82. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "8"
  83. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "8"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  84. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 8
  85. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 8
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  86. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "8"
      and `virtuemart_category_id`= "3"
  87. SELECT `j25_virtuemart_categories`.* ,`j25_virtuemart_categories_en_gb`.*
      FROM `j25_virtuemart_categories`
      INNER JOIN `j25_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
      WHERE `j25_virtuemart_categories`.`virtuemart_category_id` = "3"
  88. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "12"
  89. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "12"
      ORDER BY `ordering`
  90. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "12"
  91. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "12"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  92. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 12
  93. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 12
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  94. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "12"
      and `virtuemart_category_id`= "4"
  95. SELECT `j25_virtuemart_categories`.* ,`j25_virtuemart_categories_en_gb`.*
      FROM `j25_virtuemart_categories`
      INNER JOIN `j25_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
      WHERE `j25_virtuemart_categories`.`virtuemart_category_id` = "4"
  96. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "9"
  97. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "9"
      ORDER BY `ordering`
  98. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "9"
  99. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "9"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  100. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 9
  101. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 9
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  102. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "9"
      and `virtuemart_category_id`= "5"
  103. SELECT `j25_virtuemart_categories`.* ,`j25_virtuemart_categories_en_gb`.*
      FROM `j25_virtuemart_categories`
      INNER JOIN `j25_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
      WHERE `j25_virtuemart_categories`.`virtuemart_category_id` = "5"
  104. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "10"
  105. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "10"
      ORDER BY `ordering`
  106. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "10"
  107. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "10"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  108. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 10
  109. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 10
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  110. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "10"
      and `virtuemart_category_id`= "5"
  111. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "11"
  112. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "11"
      ORDER BY `ordering`
  113. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "11"
  114. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "11"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  115. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 11
  116. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 11
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  117. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "11"
      and `virtuemart_category_id`= "5"
  118. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "13"
  119. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "13"
      ORDER BY `ordering`
  120. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "13"
  121. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "13"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  122. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 13
  123. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 13
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  124. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "13"
      and `virtuemart_category_id`= "5"
  125. SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id`
      FROM `j25_virtuemart_products`
      INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`)
      LEFT JOIN `j25_virtuemart_product_manufacturers`
      on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      LEFT JOIN `j25_virtuemart_product_customfields`
      on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
      WHERE `j25_virtuemart_products`.`virtuemart_product_id` = "14"
  126. SELECT `virtuemart_media_id`
      FROM `j25_virtuemart_product_medias`
      WHERE `virtuemart_product_id` = "14"
      ORDER BY `ordering`
  127. SELECT `virtuemart_shoppergroup_id`
      FROM `j25_virtuemart_product_shoppergroups`
      WHERE `virtuemart_product_id` = "14"
  128. SELECT *
      FROM `j25_virtuemart_product_prices`
      WHERE `virtuemart_product_id` = "14"
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2017-03-23 12:24:10" )
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2017-03-23 12:24:10" ) )
      AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
      AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
  129. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      WHERE pc.`virtuemart_product_id` = 14
  130. SELECT pc.`virtuemart_category_id`
      FROM `j25_virtuemart_product_categories` as pc
      LEFT JOIN `j25_virtuemart_categories` as c
      ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
      WHERE pc.`virtuemart_product_id` = 14
      AND `published`=1
      ORDER BY `c`.`ordering` ASC
  131. SELECT `ordering`,`id`
      FROM `j25_virtuemart_product_categories`
      WHERE `virtuemart_product_id` = "14"
      and `virtuemart_category_id`= "5"
  132. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM j25_modules AS m
      LEFT JOIN j25_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j25_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 <= '2017-03-23 12:24:10')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-03-23 12:24:10')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 144 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  133. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind`="DBTaxBill"
      AND `published`="1"
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-03-23 12:24:10" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:24:10" )
  134. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind`="TaxBill"
      AND `published`="1"
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-03-23 12:24:10" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:24:10" )
  135. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind`="DATaxBill"
      AND `published`="1"
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-03-23 12:24:10" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:24:10" )
  136. UPDATE `j25_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1490271850;s:18:\"session.timer.last\";i:1490271850;s:17:\"session.timer.now\";i:1490271850;s:24:\"session.client.forwarded\";s:14:\"54.157.226.227\";s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{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: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;s:1:\"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:13:\"session.token\";s:32:\"a3e0251e2bcc46463f69c521feb3fc40\";}__vm|a:4:{s:21:\"vmlastproductordering\";s:13:\"category_name\";s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";s:23:\"vmlastvisitedcategoryid\";i:0;s:19:\"vmlastvisitedmanuid\";i:-1;}', `time` = 1490271850
      WHERE `session_id` = 'vtr6ufl3tbidccikoqm7shmhb1'

34 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 14 × SELECT * FROM `j25_virtuemart_product_prices`
  2. 14 × SELECT pc.`virtuemart_category_id` FROM `j25_virtuemart_product_categories` as pc
  3. 14 × SELECT `virtuemart_shoppergroup_id` FROM `j25_virtuemart_product_shoppergroups`
  4. 14 × SELECT `virtuemart_media_id` FROM `j25_virtuemart_product_medias`
  5. 14 × SELECT `j25_virtuemart_products`.* ,`j25_virtuemart_products_en_gb`.* ,`j25_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`j25_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `j25_virtuemart_products` INNER JOIN `j25_virtuemart_products_en_gb` using (`virtuemart_product_id`) LEFT JOIN `j25_virtuemart_product_manufacturers` on `j25_virtuemart_product_manufacturers`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id` LEFT JOIN `j25_virtuemart_product_customfields` on `j25_virtuemart_product_customfields`.`virtuemart_product_id`=`j25_virtuemart_products`.`virtuemart_product_id`
  6. 14 × SELECT pc.`virtuemart_category_id` FROM `j25_virtuemart_product_categories` as pc LEFT JOIN `j25_virtuemart_categories` as c ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  7. 14 × SELECT `ordering`,`id` FROM `j25_virtuemart_product_categories`
  8. 5 × SELECT `j25_virtuemart_categories`.* ,`j25_virtuemart_categories_en_gb`.* FROM `j25_virtuemart_categories` INNER JOIN `j25_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
  9. 4 × SELECT * FROM j25_virtuemart_calcs
  10. 3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM j25_extensions
  11. 2 × SELECT * FROM `j25_virtuemart_shoppergroups`
  12. 2 × SELECT FOUND_ROWS(
  13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j25_modules AS m LEFT JOIN j25_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j25_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  14. 1 × SELECT `price_display`,`custom_price_display` FROM `j25_virtuemart_shoppergroups` AS `sg`
  15. 1 × SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `j25_virtuemart_products` as p INNER JOIN `j25_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `j25_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `j25_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `j25_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
  16. 1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code` FROM `j25_virtuemart_vendors` AS v LEFT JOIN `j25_virtuemart_currencies` AS c ON virtuemart_currency_id = vendor_currency
  17. 1 × SELECT * FROM `j25_virtuemart_currencies`
  18. 1 × SELECT `virtuemart_shoppergroup_id` FROM `j25_virtuemart_vmuser_shoppergroups`
  19. 1 × SELECT m.id, m.menutype, m.title, m.alias, 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 j25_menu AS m LEFT JOIN j25_extensions AS e ON m.component_id = e.extension_id
  20. 1 × SELECT * FROM j25_languages
  21. 1 × SELECT folder AS type, element AS name, params FROM j25_extensions
  22. 1 × SELECT id, rules FROM `j25_viewlevels
  23. 1 × SELECT `session_id` FROM `j25_session`
  24. 1 × SELECT id, home, template, s.params FROM j25_template_styles as s LEFT JOIN j25_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  25. 1 × SELECT `config` FROM `j25_virtuemart_configs`
  26. 1 × SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  27. 1 × SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `j25_virtuemart_categories_en_gb` l JOIN `j25_virtuemart_categories` AS c using (`virtuemart_category_id`) LEFT JOIN `j25_virtuemart_category_categories` AS cx ON l.`virtuemart_category_id` = cx.`category_child_id`
  28. 1 × SELECT a.rules FROM j25_assets AS a
  29. 1 × SELECT `category_child_id` FROM `j25_virtuemart_category_categories`
  30. 1 × SELECT `virtuemart_media_id` FROM `j25_virtuemart_category_medias`
  31. 1 × SELECT `data` FROM `j25_session`
OTHER Tables:
  1. 1 × UPDATE `j25_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1490271850;s:18:\"session.timer.last\";i:1490271850;s:17:\"session.timer.now\";i:1490271850;s:24:\"session.client.forwarded\";s:14:\"54.157.226.227\";s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{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: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;s:1:\"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:13:\"session.token\";s:32:\"a3e0251e2bcc46463f69c521feb3fc40\";}__vm|a:4:{s:21:\"vmlastproductordering\";s:13:\"category_name\";s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";s:23:\"vmlastvisitedcategoryid\";i:0;s:19:\"vmlastvisitedmanuid\";i:-1;}', `time` = 1490271850
  2. 1 × SHOW TABLES LIKE "j25_virtuemart_configs
  3. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`) VALUES ('vtr6ufl3tbidccikoqm7shmhb1', 0, 1490271850