Информация о профиле

Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.040 seconds, 4.28 MB
Application afterRoute: 0.125 seconds, 5.44 MB
Application afterDispatch: 2.098 seconds, 16.28 MB
Application afterRender: 3.453 seconds, 18.16 MB

Использование памяти

19167944

Зарегистрировано запросов: 192

  1. /libraries/joomla/DATABASE/TABLE.php:247
    /libraries/joomla/session/storage/DATABASE.php:70
    Execute time:0.000393 sec.
    SELECT *
      FROM jos_session
      WHERE session_id = 'b73e7797c76ba3ac6c5e9659c3c910be'
  2. /libraries/joomla/application/application.php:772
    /libraries/joomla/application/application.php:99
    Execute time:0.000238 sec.
    DELETE
      FROM jos_session
      WHERE ( time < '1414842939' )
  3. /libraries/joomla/DATABASE/TABLE.php:247
    /libraries/joomla/application/application.php:775
    Execute time:0.000102 sec.
    SELECT *
      FROM jos_session
      WHERE session_id = 'b73e7797c76ba3ac6c5e9659c3c910be'
  4. /libraries/joomla/DATABASE/TABLE/session.php:100
    /libraries/joomla/application/application.php:784
    Execute time:0.000311 sec.
    INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b73e7797c76ba3ac6c5e9659c3c910be','1414846539','','0','1','0' )
  5. /libraries/joomla/application/component/helper.php:203
    /libraries/joomla/application/component/helper.php:39
    Execute time:0.000116 sec.
    SELECT *
      FROM jos_components
      WHERE parent = 0
  6. /libraries/joomla/plugin/helper.php:197
    /libraries/joomla/plugin/helper.php:41
    Execute time:0.000122 sec.
    SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:35
    Execute time:0.000157 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  8. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:35
    Execute time:0.000428 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  9. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:40
    Execute time:0.000547 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=704%' OR params LIKE '%category_id=0%')
  10. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_perm.php:35
    Execute time:0.00016 sec.
    SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  11. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_shopper_group.php:341
    Execute time:0.00012 sec.
    SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  12. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_perm.php:70
    Execute time:9.8E-5 sec.
    SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  13. /administrator/components/com_virtuemart/classes/ps_perm.php:343
    /administrator/components/com_virtuemart/classes/ps_perm.php:306
    Execute time:6.5E-5 sec.
    SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  14. /administrator/components/com_virtuemart/classes/ps_perm.php:366
    /administrator/components/com_virtuemart/classes/ps_perm.php:306
    Execute time:6.9E-5 sec.
    SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  15. /administrator/components/com_virtuemart/classes/ps_perm.php:343
    /administrator/components/com_virtuemart/classes/ps_perm.php:310
    Execute time:0.000114 sec.
    SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  16. /administrator/components/com_virtuemart/classes/ps_perm.php:366
    /administrator/components/com_virtuemart/classes/ps_perm.php:310
    Execute time:6.9E-5 sec.
    SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  17. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_vendor.php:450
    Execute time:9.0E-5 sec.
    SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  18. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_module.php:261
    Execute time:0.000107 sec.
    SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  19. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_session.php:463
    Execute time:0.000218 sec.
    SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop.product_details.php:68
    Execute time:0.000689 sec.
    SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=704
      AND `product_publish`='Y'
  21. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop.product_details.php:97
    Execute time:0.00413 sec.
    SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='704'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 6
  22. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000132 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='8677655'
  23. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:9.9E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=651
  24. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:7.6E-5 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='651'
  25. /administrator/components/com_virtuemart/classes/ps_database.php:423
    /administrator/components/com_virtuemart/classes/ps_session.php:621
    Execute time:0.000109 sec.
    SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  26. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000111 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=651%' OR params LIKE '%category_id=60%')
  27. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000133 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  28. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000426 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  29. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000167 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  30. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000123 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=651
  31. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000409 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='651'
      AND (start_date<='1414846539' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  32. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.0001 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=651
  33. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:0.000254 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846539' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  34. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:0.000115 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='651'
  35. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_shopper_group.php:374
    Execute time:0.000116 sec.
    SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  36. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:7.5E-5 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=651
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  37. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000115 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=651
  38. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1496
    Execute time:0.000104 sec.
    SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  39. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:9.5E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=651
  40. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:6.6E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=651
  41. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000111 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='232324'
  42. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:7.8E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=611
  43. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000115 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='611'
  44. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:9.7E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=611%' OR params LIKE '%category_id=60%')
  45. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000161 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  46. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000406 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  47. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000173 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  48. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.00013 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=611
  49. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000536 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='611'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  50. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000105 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=611
  51. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:0.00028 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  52. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:7.2E-5 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='611'
  53. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:8.3E-5 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=611
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  54. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:7.4E-5 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=611
  55. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:6.7E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=611
  56. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:7.8E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=611
  57. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:8.1E-5 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='54565'
  58. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:6.5E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=613
  59. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:7.3E-5 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='613'
  60. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:7.6E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=613%' OR params LIKE '%category_id=60%')
  61. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000104 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  62. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.00043 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  63. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000177 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  64. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000124 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=613
  65. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000734 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='613'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  66. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000103 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=613
  67. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:9.9E-5 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  68. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:6.5E-5 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='613'
  69. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:0.000102 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=613
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  70. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:9.9E-5 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=613
  71. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:0.000104 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=613
  72. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:8.2E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=613
  73. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000107 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='98668'
  74. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:9.7E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=615
  75. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000103 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='615'
  76. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:9.9E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=615%' OR params LIKE '%category_id=60%')
  77. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000141 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  78. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000427 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  79. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00014 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  80. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000128 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=615
  81. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000404 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='615'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  82. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000784 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=615
  83. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:8.9E-5 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  84. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:0.000182 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='615'
  85. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:7.6E-5 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  86. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000102 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=615
  87. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:9.6E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=615
  88. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:6.9E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=615
  89. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000104 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='56767887'
  90. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:8.2E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=617
  91. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000105 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='617'
  92. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000109 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=617%' OR params LIKE '%category_id=60%')
  93. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.00012 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  94. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000462 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  95. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000149 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  96. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000128 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=617
  97. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000421 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='617'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  98. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.001177 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=617
  99. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:9.1E-5 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  100. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:7.3E-5 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='617'
  101. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:0.000106 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=617
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  102. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:7.6E-5 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=617
  103. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:7.9E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=617
  104. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:0.000122 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=617
  105. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop.product_details.php:132
    Execute time:0.00075 sec.
    SELECT cx.category_id, category_flypage
      FROM jos_vm_category c, jos_vm_product_category_xref cx
      WHERE product_id = '704'
      AND c.category_id=cx.category_id
      LIMIT 0,1
  106. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1277
    Execute time:0.000112 sec.
    SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='16'
      AND jos_vm_category.category_id='16'
  107. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1277
    Execute time:7.0E-5 sec.
    SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='37'
      AND jos_vm_category.category_id='37'
  108. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000106 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  109. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000137 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  110. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000484 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  111. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000145 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  112. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000117 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=16%')
  113. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000136 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  114. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000496 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  115. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000485 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=16%')
  116. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00011 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  117. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop_browse_queries.php:63
    Execute time:0.000123 sec.
    SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  118. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1312
    Execute time:0.001257 sec.
    SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 2000
  119. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000572 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='702'
  120. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000556 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=702%' OR params LIKE '%category_id=0%')
  121. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000136 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  122. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000398 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  123. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000165 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=65%')
  124. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000543 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='1254'
  125. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000335 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=1254%' OR params LIKE '%category_id=0%')
  126. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000155 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  127. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000483 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  128. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000185 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=19%')
  129. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:8.7E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  130. /includes/application.php:307
    /administrator/components/com_virtuemart/classes/htmlTools.class.php:766
    Execute time:0.000102 sec.
    SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 88)
      ORDER BY menuid DESC
      LIMIT 0, 1
  131. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1222
    Execute time:0.000347 sec.
    SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='16'
  132. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1251
    Execute time:0.000661 sec.
    SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='704'
  133. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1274
    Execute time:0.000146 sec.
    SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='704'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  134. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000128 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=704
  135. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000295 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='704'
      AND (start_date<='1414846541' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  136. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000128 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=704
  137. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:0.000258 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846541' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  138. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:0.000162 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='704'
  139. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:0.000102 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=704
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  140. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000107 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=704
  141. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000111 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=704
  142. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:667
    Execute time:7.7E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=704
      AND `file_is_image`=1
      AND `file_published`=1
  143. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:669
    Execute time:6.2E-5 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=704
  144. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:670
    Execute time:7.6E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  145. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:678
    Execute time:8.5E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=704
      AND `file_is_image`=0
      AND `file_published`=1
  146. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:680
    Execute time:9.8E-5 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='704'
  147. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:683
    Execute time:9.9E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  148. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:601
    Execute time:9.7E-5 sec.
    SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  149. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:611
    Execute time:6.9E-5 sec.
    SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  150. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1037
    Execute time:6.9E-5 sec.
    SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='704'
  151. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1037
    Execute time:7.0E-5 sec.
    SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='704'
  152. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_reviews.php:50
    Execute time:0.000103 sec.
    SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='704'
  153. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_reviews.php:104
    Execute time:0.000296 sec.
    SELECT COUNT(*) AS num_rows
      FROM jos_vm_product_reviews
                                                   
      WHERE product_id='704'
      AND published='Y'
  154. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_reviews.php:106
    Execute time:0.000426 sec.
    SELECT comment, time, userid, user_rating
      FROM jos_vm_product_reviews
                                           
      WHERE product_id='704'
      AND published='Y'
      ORDER BY `time` DESC 
      LIMIT 0, 5
  155. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1183
    Execute time:0.000276 sec.
    SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='704'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  156. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_type.php:515
    Execute time:0.000214 sec.
    SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='704'
  157. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000125 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=704
  158. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:724
    Execute time:0.000233 sec.
    SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='704'
  159. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:729
    Execute time:0.000333 sec.
    SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='704'
  160. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:813
    Execute time:0.000215 sec.
    SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='704'
  161. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:818
    Execute time:0.000417 sec.
    SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='704'
  162. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:264
    Execute time:0.00039 sec.
    SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='704'
      AND product_publish='Y'
  163. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/payment/ps_paypal_api.php:1369
    Execute time:0.000171 sec.
    SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  164. /plugins/system/tagmeta.php:131
    Execute time:0.002345 sec.
    SELECT *
      FROM jos_tagmeta
      WHERE ( (('/shop/sotovye-telefony/veon/veon-c8680' REGEXP BINARY uri)>0
      AND case_sensitive<>'0') OR (('/shop/sotovye-telefony/veon/veon-c8680' REGEXP uri)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  165. /libraries/joomla/application/module/helper.php:285
    /libraries/joomla/application/module/helper.php:88
    Execute time:0.000159 sec.
    SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 88 OR mm.menuid = 0 )
      ORDER BY position, ordering
  166. /modules/mod_whosonline/helper.php:32
    /modules/mod_whosonline/mod_whosonline.php:23
    Execute time:0.004153 sec.
    SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  167. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.002084 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  168. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000183 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  169. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000553 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  170. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00016 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  171. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000103 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  172. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000148 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  173. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000479 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  174. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000154 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  175. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:9.8E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=71%')
  176. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000147 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  177. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000432 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  178. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000165 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=71%')
  179. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000125 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=103%')
  180. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000146 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  181. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000459 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  182. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000195 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=103%')
  183. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000116 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=23%')
  184. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000139 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  185. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.001834 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  186. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000194 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=23%')
  187. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000132 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=65%')
  188. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000264 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  189. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000449 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  190. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00019 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=65%')
  191. /modules/mod_vtemmenu/helper.php:66
    /modules/mod_vtemmenu/mod_vtemmenu.php:10
    Execute time:0.000177 sec.
    SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='vtem-menu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  192. /modules/mod_vtemmenu/helper.php:272
    /modules/mod_vtemmenu/helper.php:74
    Execute time:0.000139 sec.
    SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Зарегистрировано запросов старых компонентов: 192

  1. /libraries/joomla/DATABASE/TABLE.php:247
    /libraries/joomla/session/storage/DATABASE.php:70
    Execute time:0.000393 sec.
    SELECT *
      FROM jos_session
      WHERE session_id = 'b73e7797c76ba3ac6c5e9659c3c910be'
  2. /libraries/joomla/application/application.php:772
    /libraries/joomla/application/application.php:99
    Execute time:0.000238 sec.
    DELETE
      FROM jos_session
      WHERE ( time < '1414842939' )
  3. /libraries/joomla/DATABASE/TABLE.php:247
    /libraries/joomla/application/application.php:775
    Execute time:0.000102 sec.
    SELECT *
      FROM jos_session
      WHERE session_id = 'b73e7797c76ba3ac6c5e9659c3c910be'
  4. /libraries/joomla/DATABASE/TABLE/session.php:100
    /libraries/joomla/application/application.php:784
    Execute time:0.000311 sec.
    INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b73e7797c76ba3ac6c5e9659c3c910be','1414846539','','0','1','0' )
  5. /libraries/joomla/application/component/helper.php:203
    /libraries/joomla/application/component/helper.php:39
    Execute time:0.000116 sec.
    SELECT *
      FROM jos_components
      WHERE parent = 0
  6. /libraries/joomla/plugin/helper.php:197
    /libraries/joomla/plugin/helper.php:41
    Execute time:0.000122 sec.
    SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:35
    Execute time:0.000157 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  8. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:35
    Execute time:0.000428 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  9. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:40
    Execute time:0.000547 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=704%' OR params LIKE '%category_id=0%')
  10. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_perm.php:35
    Execute time:0.00016 sec.
    SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  11. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_shopper_group.php:341
    Execute time:0.00012 sec.
    SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  12. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_perm.php:70
    Execute time:9.8E-5 sec.
    SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  13. /administrator/components/com_virtuemart/classes/ps_perm.php:343
    /administrator/components/com_virtuemart/classes/ps_perm.php:306
    Execute time:6.5E-5 sec.
    SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  14. /administrator/components/com_virtuemart/classes/ps_perm.php:366
    /administrator/components/com_virtuemart/classes/ps_perm.php:306
    Execute time:6.9E-5 sec.
    SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  15. /administrator/components/com_virtuemart/classes/ps_perm.php:343
    /administrator/components/com_virtuemart/classes/ps_perm.php:310
    Execute time:0.000114 sec.
    SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  16. /administrator/components/com_virtuemart/classes/ps_perm.php:366
    /administrator/components/com_virtuemart/classes/ps_perm.php:310
    Execute time:6.9E-5 sec.
    SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft
  17. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_vendor.php:450
    Execute time:9.0E-5 sec.
    SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  18. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_module.php:261
    Execute time:0.000107 sec.
    SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  19. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_session.php:463
    Execute time:0.000218 sec.
    SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop.product_details.php:68
    Execute time:0.000689 sec.
    SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=704
      AND `product_publish`='Y'
  21. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop.product_details.php:97
    Execute time:0.00413 sec.
    SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='704'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 6
  22. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000132 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='8677655'
  23. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:9.9E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=651
  24. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:7.6E-5 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='651'
  25. /administrator/components/com_virtuemart/classes/ps_database.php:423
    /administrator/components/com_virtuemart/classes/ps_session.php:621
    Execute time:0.000109 sec.
    SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  26. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000111 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=651%' OR params LIKE '%category_id=60%')
  27. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000133 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  28. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000426 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  29. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000167 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  30. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000123 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=651
  31. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000409 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='651'
      AND (start_date<='1414846539' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  32. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.0001 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=651
  33. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:0.000254 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846539' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  34. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:0.000115 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='651'
  35. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_shopper_group.php:374
    Execute time:0.000116 sec.
    SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  36. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:7.5E-5 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=651
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  37. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000115 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=651
  38. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1496
    Execute time:0.000104 sec.
    SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  39. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:9.5E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=651
  40. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:6.6E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=651
  41. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000111 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='232324'
  42. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:7.8E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=611
  43. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000115 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='611'
  44. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:9.7E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=611%' OR params LIKE '%category_id=60%')
  45. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000161 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  46. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000406 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  47. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000173 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  48. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.00013 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=611
  49. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000536 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='611'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  50. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000105 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=611
  51. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:0.00028 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  52. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:7.2E-5 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='611'
  53. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:8.3E-5 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=611
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  54. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:7.4E-5 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=611
  55. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:6.7E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=611
  56. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:7.8E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=611
  57. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:8.1E-5 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='54565'
  58. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:6.5E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=613
  59. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:7.3E-5 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='613'
  60. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:7.6E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=613%' OR params LIKE '%category_id=60%')
  61. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000104 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  62. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.00043 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  63. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000177 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  64. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000124 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=613
  65. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000734 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='613'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  66. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000103 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=613
  67. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:9.9E-5 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  68. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:6.5E-5 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='613'
  69. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:0.000102 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=613
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  70. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:9.9E-5 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=613
  71. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:0.000104 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=613
  72. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:8.2E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=613
  73. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000107 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='98668'
  74. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:9.7E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=615
  75. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000103 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='615'
  76. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:9.9E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=615%' OR params LIKE '%category_id=60%')
  77. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000141 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  78. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000427 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  79. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00014 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  80. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000128 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=615
  81. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000404 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='615'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  82. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000784 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=615
  83. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:8.9E-5 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  84. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:0.000182 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='615'
  85. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:7.6E-5 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=615
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  86. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000102 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=615
  87. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:9.6E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=615
  88. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:6.9E-5 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=615
  89. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2431
    Execute time:0.000104 sec.
    SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='56767887'
  90. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1187
    Execute time:8.2E-5 sec.
    SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=617
  91. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000105 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='617'
  92. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000109 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=617%' OR params LIKE '%category_id=60%')
  93. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.00012 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  94. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000462 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  95. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000149 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  96. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000128 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=617
  97. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000421 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='617'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  98. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.001177 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=617
  99. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:9.1E-5 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846540' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  100. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:7.3E-5 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='617'
  101. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:0.000106 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=617
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  102. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:7.6E-5 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=617
  103. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1062
    Execute time:7.9E-5 sec.
    SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=617
  104. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1067
    Execute time:0.000122 sec.
    SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=617
  105. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop.product_details.php:132
    Execute time:0.00075 sec.
    SELECT cx.category_id, category_flypage
      FROM jos_vm_category c, jos_vm_product_category_xref cx
      WHERE product_id = '704'
      AND c.category_id=cx.category_id
      LIMIT 0,1
  106. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1277
    Execute time:0.000112 sec.
    SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='16'
      AND jos_vm_category.category_id='16'
  107. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1277
    Execute time:7.0E-5 sec.
    SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='37'
      AND jos_vm_category.category_id='37'
  108. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000106 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  109. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000137 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  110. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000484 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  111. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000145 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  112. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000117 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=16%')
  113. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000136 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  114. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000496 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  115. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000485 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=16%')
  116. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00011 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  117. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/html/shop_browse_queries.php:63
    Execute time:0.000123 sec.
    SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  118. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1312
    Execute time:0.001257 sec.
    SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 2000
  119. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000572 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='702'
  120. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000556 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=702%' OR params LIKE '%category_id=0%')
  121. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000136 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  122. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000398 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  123. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000165 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=65%')
  124. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1156
    Execute time:0.000543 sec.
    SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='1254'
  125. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000335 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=1254%' OR params LIKE '%category_id=0%')
  126. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000155 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  127. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000483 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  128. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000185 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=19%')
  129. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:8.7E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  130. /includes/application.php:307
    /administrator/components/com_virtuemart/classes/htmlTools.class.php:766
    Execute time:0.000102 sec.
    SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 88)
      ORDER BY menuid DESC
      LIMIT 0, 1
  131. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_category.php:1222
    Execute time:0.000347 sec.
    SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='16'
  132. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1251
    Execute time:0.000661 sec.
    SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='704'
  133. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1274
    Execute time:0.000146 sec.
    SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='704'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  134. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000128 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=704
  135. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2366
    Execute time:0.000295 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='704'
      AND (start_date<='1414846541' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  136. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2379
    Execute time:0.000128 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=704
  137. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:2384
    Execute time:0.000258 sec.
    SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1414846541' OR start_date=0)
      AND (end_date>='1414798560' OR end_date=0)
      AND product_discount_id=discount_id
  138. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1227
    Execute time:0.000162 sec.
    SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='704'
  139. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1811
    Execute time:0.000102 sec.
    SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=704
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
  140. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000107 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=704
  141. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1618
    Execute time:0.000111 sec.
    SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=704
  142. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:667
    Execute time:7.7E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=704
      AND `file_is_image`=1
      AND `file_published`=1
  143. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:669
    Execute time:6.2E-5 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=704
  144. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:670
    Execute time:7.6E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  145. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:678
    Execute time:8.5E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=704
      AND `file_is_image`=0
      AND `file_published`=1
  146. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:680
    Execute time:9.8E-5 sec.
    SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='704'
  147. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:683
    Execute time:9.9E-5 sec.
    SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  148. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:601
    Execute time:9.7E-5 sec.
    SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  149. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_files.php:611
    Execute time:6.9E-5 sec.
    SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  150. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1037
    Execute time:6.9E-5 sec.
    SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='704'
  151. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1037
    Execute time:7.0E-5 sec.
    SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='704'
  152. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_reviews.php:50
    Execute time:0.000103 sec.
    SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='704'
  153. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_reviews.php:104
    Execute time:0.000296 sec.
    SELECT COUNT(*) AS num_rows
      FROM jos_vm_product_reviews
                                                   
      WHERE product_id='704'
      AND published='Y'
  154. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_reviews.php:106
    Execute time:0.000426 sec.
    SELECT comment, time, userid, user_rating
      FROM jos_vm_product_reviews
                                           
      WHERE product_id='704'
      AND published='Y'
      ORDER BY `time` DESC 
      LIMIT 0, 5
  155. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1183
    Execute time:0.000276 sec.
    SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='704'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  156. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_type.php:515
    Execute time:0.000214 sec.
    SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='704'
  157. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product.php:1096
    Execute time:0.000125 sec.
    SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=704
  158. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:724
    Execute time:0.000233 sec.
    SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='704'
  159. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:729
    Execute time:0.000333 sec.
    SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='704'
  160. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:813
    Execute time:0.000215 sec.
    SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='704'
  161. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:818
    Execute time:0.000417 sec.
    SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='704'
  162. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/ps_product_attribute.php:264
    Execute time:0.00039 sec.
    SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='704'
      AND product_publish='Y'
  163. /administrator/components/com_virtuemart/classes/ps_database.php:120
    /administrator/components/com_virtuemart/classes/payment/ps_paypal_api.php:1369
    Execute time:0.000171 sec.
    SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  164. /plugins/system/tagmeta.php:131
    Execute time:0.002345 sec.
    SELECT *
      FROM jos_tagmeta
      WHERE ( (('/shop/sotovye-telefony/veon/veon-c8680' REGEXP BINARY uri)>0
      AND case_sensitive<>'0') OR (('/shop/sotovye-telefony/veon/veon-c8680' REGEXP uri)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  165. /libraries/joomla/application/module/helper.php:285
    /libraries/joomla/application/module/helper.php:88
    Execute time:0.000159 sec.
    SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 88 OR mm.menuid = 0 )
      ORDER BY position, ordering
  166. /modules/mod_whosonline/helper.php:32
    /modules/mod_whosonline/mod_whosonline.php:23
    Execute time:0.004153 sec.
    SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
  167. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.002084 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  168. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000183 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  169. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000553 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  170. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00016 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=37%')
  171. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000103 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  172. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000148 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  173. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000479 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  174. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000154 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=60%')
  175. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:9.8E-5 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=71%')
  176. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000147 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  177. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000432 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  178. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000165 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=71%')
  179. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000125 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=103%')
  180. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000146 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  181. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000459 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  182. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000195 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=103%')
  183. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000116 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=23%')
  184. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000139 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  185. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.001834 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  186. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.000194 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=23%')
  187. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:57
    Execute time:0.000132 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=65%')
  188. /components/com_virtuemart/router.php:148
    /components/com_virtuemart/router.php:61
    Execute time:0.000264 sec.
    SELECT c.category_id, c.category_name, cref.category_parent_id
      FROM jos_vm_category AS c, jos_vm_category_xref AS cref
      WHERE c.category_id = cref.category_child_id
      ORDER BY c.category_id
  189. /components/com_virtuemart/router.php:167
    /components/com_virtuemart/router.php:61
    Execute time:0.000449 sec.
    SELECT p.product_id, p.product_name, p.product_sku, c.category_id
      FROM jos_vm_product AS p, jos_vm_product_category_xref AS c
      WHERE IF(p.product_parent_id > 0, p.product_parent_id, p.product_id) = c.product_id
      ORDER BY p.product_id
  190. /components/com_virtuemart/router.php:106
    /components/com_virtuemart/router.php:73
    Execute time:0.00019 sec.
    SELECT id, alias, link, params
           
      FROM jos_menu
           
      WHERE link LIKE '%index.php?option=com_virtuemart%'
      AND
            (params LIKE '%product_id=0%' OR params LIKE '%category_id=65%')
  191. /modules/mod_vtemmenu/helper.php:66
    /modules/mod_vtemmenu/mod_vtemmenu.php:10
    Execute time:0.000177 sec.
    SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='vtem-menu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
  192. /modules/mod_vtemmenu/helper.php:272
    /modules/mod_vtemmenu/helper.php:74
    Execute time:0.000139 sec.
    SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Языковые файлы загружены

Диагностика непереведённых строк

Нет

Дизайнер непереведённых строк

Нет