Bienvenidos a Edinumen.es

Novedades

Perfíl de la información

Application afterLoad: 0.000 seconds, 0.33 MB
Application afterInitialise: 0.021 seconds, 2.09 MB
Application afterRoute: 0.028 seconds, 5.28 MB
Application afterDispatch: 0.121 seconds, 6.42 MB
Application afterRender: 0.401 seconds, 13.96 MB

Memoria usada

14677384

179 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'om7v2dq6bmv0bpqhk4prbustn3'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1586065550' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'om7v2dq6bmv0bpqhk4prbustn3'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'om7v2dq6bmv0bpqhk4prbustn3','1586067350','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  8. SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name
     
      FROM jos_comprofiler_plugin
     
      WHERE published = 1
      AND access IN (0)
      AND TYPE = 'user'
     
      ORDER BY ordering
  9. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 103)
      ORDER BY menuid DESC
      LIMIT 0, 1
  11. SELECT m.*
      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 = 103 OR mm.menuid = 0 )
      ORDER BY m.POSITION, m.ordering
  12. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  13. SELECT *
      FROM `jos_rsform_config`
  14. SELECT m1.id
      FROM jos_menu AS m1
      INNER JOIN jos_menu AS m2
      ON (m1.id = m2.parent
      AND m2.id = '103')
      WHERE m1.published = 1  
      AND m1.access = 0
      ORDER BY m1.ordering
  15. SELECT *
      FROM jos_menu AS m
      WHERE m.menutype='Botones' && m.parent = 0
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  16. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '57'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  17. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '61'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  18. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '62'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  19. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '63'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  20. SELECT *
      FROM jos_jcalpro2_config
  21. SELECT unix_timestamp( '2020-04-05 06:15:50');
  22. SELECT name
      FROM jos_jcalpro2_themes
      WHERE published= '1'
  23. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'registered'
  24. 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 > 4
      AND g1.lft <11
      GROUP BY g1.name
      ORDER BY g1.lft
  25. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  26. 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 > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  27. SELECT id, name
      FROM jos_core_acl_aro_groups;
  28. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  29. 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 > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  30. SELECT id, name
      FROM jos_core_acl_aro_groups;
  31. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  32. 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 > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  33. SELECT id, name
      FROM jos_core_acl_aro_groups;
  34. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  35. 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 > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  36. SELECT id, name
      FROM jos_core_acl_aro_groups;
  37. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  38. 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 > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  39. SELECT id, name
      FROM jos_core_acl_aro_groups;
  40. SELECT
                    cat_id, level
           
      FROM
                    jos_jcalpro2_categories
  41. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  42. 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 > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  43. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  44. 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 > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  45. SELECT id, name
      FROM jos_core_acl_aro_groups;
  46. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  47. 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 > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  48. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  49. 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 > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  50. SELECT id, name
      FROM jos_core_acl_aro_groups;
  51. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  52. 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 > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  53. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  54. 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 > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  55. SELECT id, name
      FROM jos_core_acl_aro_groups;
  56. SELECT
                    cal_id, level
           
      FROM
                    jos_jcalpro2_calendars
  57. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  58. 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 > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  59. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  60. 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 > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
  61. SELECT id, name
      FROM jos_core_acl_aro_groups;
  62. SELECT e.*, DATE_FORMAT( e.start_date, '%Y%m%d' ) AS DATE, c.cat_id, c.cat_name, c.color, c.description AS cat_desc
      FROM jos_jcalpro2_events AS e
      LEFT JOIN jos_jcalpro2_categories AS c
      ON e.cat=c.cat_id  
      LEFT JOIN jos_jcalpro2_calendars AS cal
      ON e.cal_id=cal.cal_id
      WHERE (    ( e.start_date <= '2020-04-01 00:00:00'
      AND e.end_date >= '2020-04-30 23:59:59'
      AND e.end_date != '2038-01-18 00:00:00'
      AND e.end_date != '0000-00-00 00:00:01'
      AND e.end_date != '9999-12-01 00:00:00')  OR ((e.start_date >= '2020-04-01 00:00:00'
      AND e.start_date < '2020-04-30 23:59:59')  
      AND (e.end_date = '2038-01-18 00:00:00' OR e.end_date = '0000-00-00 00:00:01' OR e.end_date = '9999-12-01 00:00:00'))   OR ( e.start_date > '2020-04-01 00:00:00'
      AND e.start_date <= '2020-04-30 23:59:59')  OR ( e.end_date > '2020-04-01 00:00:00'
      AND e.end_date <= '2020-04-30 23:59:59' ) )
      AND c.published = '1'
      AND e.published = '1'
      AND cal.published='1'
      AND approved = '1'
      AND e.cat IN (2)
      AND e.cal_id IN (1)
      AND (e.private IN ('0', '2') OR (e.owner_id = '0'
      AND e.private = '1'))
      ORDER BY start_date,title ASC
  63. SELECT e.*, DATE_FORMAT( e.session_up, '%Y%m%d' ) AS DATE, c.name AS cat_name
                           
      FROM jos_illbethere_sessions AS e
                           
      LEFT JOIN jos_illbethere_categories AS c
                           
      ON c.cat_id = e.cat_id
                           
      WHERE e.published = '1'
      ORDER BY e.session_up, e.title ASC
  64. SELECT m1.id
      FROM jos_menu AS m1
      INNER JOIN jos_menu AS m2
      ON (m1.id = m2.parent
      AND m2.id = '103')
      WHERE m1.published = 1  
      AND m1.access = 0
      ORDER BY m1.ordering
  65. SELECT *
      FROM jos_menu AS m
      WHERE m.menutype='Destacados' && m.parent = 0
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  66. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '120'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  67. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '121'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  68. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '122'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  69. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '123'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  70. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '87'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  71. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '92'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  72. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '98'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  73. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '90'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  74. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '99'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  75. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '89'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  76. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '64'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  77. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '94'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  78. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '95'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  79. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '96'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  80. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '97'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  81. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  82. 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'
  83. 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`);
  84. SELECT jos_vm_product.*, jos_vm_category.category_id  
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'

      GROUP BY jos_vm_product.product_id
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 0, 10
  85. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='678'
  86. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  87. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=678
  88. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=678
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  89. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='678'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  90. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=678
  91. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=678
  93. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=678
  94. 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`='678'
  95. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  96. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  97. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  98. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='677'
  99. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=677
  100. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=677
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  101. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='677'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  102. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=677
  103. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  104. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=677
  105. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=677
  106. 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`='677'
  107. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='675'
  108. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=675
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=675
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  110. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='675'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  111. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=675
  112. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=675
  114. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=675
  115. 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`='675'
  116. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='674'
  117. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=674
  118. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=674
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  119. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='674'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  120. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=674
  121. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  122. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=674
  123. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=674
  124. 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`='674'
  125. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='673'
  126. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=673
  127. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=673
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='673'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=673
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=673
  132. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=673
  133. 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`='673'
  134. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='672'
  135. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=672
  136. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=672
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='672'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=672
  139. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  140. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=672
  141. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=672
  142. 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`='672'
  143. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='671'
  144. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=671
  145. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=671
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  146. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='671'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=671
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=671
  150. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=671
  151. 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`='671'
  152. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='670'
  153. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=670
  154. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=670
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  155. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='670'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  156. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=670
  157. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  158. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=670
  159. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=670
  160. 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`='670'
  161. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='669'
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=669
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=669
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='669'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=669
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=669
  168. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=669
  169. 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`='669'
  170. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='668'
  171. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=668
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=668
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='668'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=668
  175. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1586067350' OR start_date=0)
      AND (end_date>='1586043360' OR end_date=0)
      AND product_discount_id=discount_id
  176. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=668
  177. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=668
  178. 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`='668'
  179. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`

4 legado de las queries identificadas

  1. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. 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
  3. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  4. 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

Archivos de idioma cargados

Sin traducir las cadenas de diagnóstico

Ninguno

Sin traducir las cadenas de diseñador

Ninguno