Bienvenidos a Edinumen.es

Novedades

Perfíl de la información

Application afterLoad: 0.001 seconds, 0.33 MB
Application afterInitialise: 0.023 seconds, 2.09 MB
Application afterRoute: 0.031 seconds, 5.28 MB
Application afterDispatch: 0.180 seconds, 6.71 MB
Application afterRender: 0.355 seconds, 14.21 MB

Memoria usada

14945224

186 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'dn130ad1lf7u7u37h8fta7vvs6'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1606686195' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'dn130ad1lf7u7u37h8fta7vvs6'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'dn130ad1lf7u7u37h8fta7vvs6','1606687995','','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 a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.SECTION
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 3
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-29 22:13:15' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-29 22:13:15' )   )    OR  ( a.state = -1 )  )
  13. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='3'
  14. SELECT id
      FROM jos_plugins
      WHERE element = 'legacy'
      AND published = 0
  15. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  16. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  17. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  18. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  19. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  20. SELECT *
      FROM `jos_rsform_config`
  21. 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
  22. 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
  23. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '57'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  24. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '61'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  25. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '62'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  26. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '63'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  27. SELECT *
      FROM jos_jcalpro2_config
  28. SELECT unix_timestamp( '2020-11-29 22:13:15');
  29. SELECT name
      FROM jos_jcalpro2_themes
      WHERE published= '1'
  30. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'registered'
  31. 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
  32. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  33. 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
  34. SELECT id, name
      FROM jos_core_acl_aro_groups;
  35. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  36. 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
  37. SELECT id, name
      FROM jos_core_acl_aro_groups;
  38. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  39. 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
  40. SELECT id, name
      FROM jos_core_acl_aro_groups;
  41. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  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 > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
  43. SELECT id, name
      FROM jos_core_acl_aro_groups;
  44. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
  45. 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
  46. SELECT id, name
      FROM jos_core_acl_aro_groups;
  47. SELECT
                    cat_id, level
           
      FROM
                    jos_jcalpro2_categories
  48. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  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 > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  50. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  51. 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
  52. SELECT id, name
      FROM jos_core_acl_aro_groups;
  53. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  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 > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
  55. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  56. 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
  57. SELECT id, name
      FROM jos_core_acl_aro_groups;
  58. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  59. 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
  60. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  61. 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
  62. SELECT id, name
      FROM jos_core_acl_aro_groups;
  63. SELECT
                    cal_id, level
           
      FROM
                    jos_jcalpro2_calendars
  64. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
  65. 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
  66. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
  67. 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
  68. SELECT id, name
      FROM jos_core_acl_aro_groups;
  69. 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-12-01 01:00:00'
      AND e.end_date >= '2021-01-01 00: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-12-01 01:00:00'
      AND e.start_date < '2021-01-01 00: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-12-01 01:00:00'
      AND e.start_date <= '2021-01-01 00:59:59')  OR ( e.end_date > '2020-12-01 01:00:00'
      AND e.end_date <= '2021-01-01 00: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
  70. 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
  71. 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
  72. 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
  73. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '120'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  74. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '121'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  75. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '122'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  76. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '123'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  77. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '87'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  78. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '92'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  79. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '98'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  80. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '90'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  81. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '99'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  82. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '89'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  83. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '64'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  84. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '94'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  85. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '95'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  86. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '96'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  87. SELECT *
      FROM jos_menu AS m
      WHERE m.parent = '97'
      AND m.published = 1  
      AND m.access = 0
      ORDER BY m.ordering
  88. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  89. 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'
  90. 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`);
  91. 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
  92. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='678'
  93. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  94. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=678
  95. 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
  96. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='678'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  97. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=678
  98. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  99. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=678
  100. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=678
  101. 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'
  102. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  103. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  104. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  105. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='677'
  106. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=677
  107. 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
  108. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='677'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=677
  110. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  111. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=677
  112. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=677
  113. 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'
  114. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='675'
  115. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=675
  116. 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
  117. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='675'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=675
  119. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  120. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=675
  121. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=675
  122. 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'
  123. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='674'
  124. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=674
  125. 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
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='674'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=674
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=674
  130. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=674
  131. 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'
  132. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='673'
  133. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=673
  134. 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
  135. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='673'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  136. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=673
  137. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  138. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=673
  139. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=673
  140. 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'
  141. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='672'
  142. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=672
  143. 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
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='672'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=672
  146. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=672
  148. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=672
  149. 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'
  150. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='671'
  151. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=671
  152. 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
  153. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='671'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  154. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=671
  155. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  156. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=671
  157. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=671
  158. 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'
  159. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='670'
  160. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=670
  161. 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
  162. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='670'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  163. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=670
  164. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  165. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=670
  166. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=670
  167. 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'
  168. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='669'
  169. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=669
  170. 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
  171. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='669'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  172. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=669
  173. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  174. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=669
  175. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=669
  176. 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'
  177. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='668'
  178. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=668
  179. 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
  180. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='668'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  181. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=668
  182. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606687996' OR start_date=0)
      AND (end_date>='1606606560' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=668
  184. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=668
  185. 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'
  186. 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