HomePsyKarmy

Karmy

Sortuj według:
229.00z

  • «« Start
  • « Poprzednia
  • 1
  • Następna »
  • Koniec »»


Wyświetl #  
Wyniki 1 - 8 z 8

Informacje o wydajności

Application afterLoad: 0.002 seconds, 0.30 MB
Application afterInitialise: 0.029 seconds, 1.41 MB
Application afterRoute: 0.064 seconds, 2.03 MB
Application afterDispatch: 0.199 seconds, 3.42 MB
Application afterRender: 0,247 seconds, 3,91 MB

Zużycie pamięci

4138840

Zapytań do bazy danych: 190

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'i6bn7gou0od5r8m55u5sk9fkt5'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1566552033' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'i6bn7gou0od5r8m55u5sk9fkt5'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'i6bn7gou0od5r8m55u5sk9fkt5','1566553233','','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 m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  9. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 111)
      ORDER BY menuid DESC
      LIMIT 0, 1
  10. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  11. 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. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  13. 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`);
  14. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  15. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  16. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  17. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  18. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      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_category_xref`.`category_id`=18
     
      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'
  19. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='18'
  20. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='18'
  21. SELECT category_id, category_thumb_image, category_child_id,category_name
      FROM jos_vm_category,jos_vm_category_xref
      WHERE jos_vm_category_xref.category_parent_id='18'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      AND jos_vm_category.vendor_id='1'
      AND jos_vm_category.category_publish='Y'
      ORDER BY jos_vm_category.list_order, jos_vm_category.category_name ASC
  22. 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='18'
      AND jos_vm_category.category_id='18'
  23. 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='19'
      AND jos_vm_category.category_id='19'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_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_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_category_xref`.`category_id`=18
     
      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, 20
  26. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=19
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='19'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=19
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='19'
  31. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=19
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=19
  34. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='19'
  35. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=19
  36. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=19
      AND `file_is_image`=1
      AND `file_published`=1
  37. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=19
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  39. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=19
      AND `file_is_image`=0
      AND `file_published`=1
  40. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='19'
  41. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  42. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='19'
  43. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=19
  44. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18
  45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='18'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=18
  47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  48. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='18'
  49. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  50. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  51. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  52. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  53. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18'
  54. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  55. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  56. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=18
  57. 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
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=18
      AND `file_is_image`=1
      AND `file_published`=1
  59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=18
  60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=18
      AND `file_is_image`=0
      AND `file_published`=1
  62. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='18'
  63. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  64. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='18'
  65. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=24
  66. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='24'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  67. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  68. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  69. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='24'
  70. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  71. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  72. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  73. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  74. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='24'
  75. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  76. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  77. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=24
  78. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=24
      AND `file_is_image`=1
      AND `file_published`=1
  79. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  81. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=24
      AND `file_is_image`=0
      AND `file_published`=1
  82. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='24'
  83. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  84. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='24'
  85. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=22
  86. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='22'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  87. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  88. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  89. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='22'
  90. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  91. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  92. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  93. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  94. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='22'
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  97. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=22
  98. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=22
      AND `file_is_image`=1
      AND `file_published`=1
  99. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  100. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  101. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=22
      AND `file_is_image`=0
      AND `file_published`=1
  102. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='22'
  103. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  104. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='22'
  105. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
  106. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  108. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  109. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='23'
  110. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  112. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  113. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  114. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='23'
  115. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=23
  118. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_is_image`=1
      AND `file_published`=1
  119. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  120. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=23
      AND `file_is_image`=0
      AND `file_published`=1
  122. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='23'
  123. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  124. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='23'
  125. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=20
  126. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='20'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  127. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=20
  128. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  129. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='20'
  130. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  131. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  132. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  133. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  134. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='20'
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=20
  138. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=20
      AND `file_is_image`=1
      AND `file_published`=1
  139. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=20
  140. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  141. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=20
      AND `file_is_image`=0
      AND `file_published`=1
  142. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='20'
  143. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  144. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='20'
  145. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=21
  146. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='21'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=21
  148. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='21'
  150. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  151. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  152. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  153. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  154. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='21'
  155. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  156. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  157. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=21
  158. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=21
      AND `file_is_image`=1
      AND `file_published`=1
  159. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=21
  160. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  161. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=21
      AND `file_is_image`=0
      AND `file_published`=1
  162. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='21'
  163. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  164. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='21'
  165. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17
  166. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  167. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17
  168. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1566553233' OR start_date=0)
      AND (end_date>='1566516960' OR end_date=0)
      AND product_discount_id=discount_id
  169. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17'
  170. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  171. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  172. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17'
  175. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  176. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  177. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=17
  178. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=17
      AND `file_is_image`=1
      AND `file_published`=1
  179. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17
  180. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  181. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=17
      AND `file_is_image`=0
      AND `file_published`=1
  182. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='17'
  183. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  184. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='17'
  185. 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 = 111 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  186. SELECT *
      FROM jos_swmenufree_config
      WHERE id = 1
  187. SELECT jos_menu.*
                                   
      FROM jos_menu
                   
      WHERE jos_menu.menutype = 'sklep'
      AND published = '1'
                   
      ORDER BY parent, ordering
  188. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  189. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  190. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'

Zapytań w trybie zgodności: 4

  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

Wczytane pliki języka

Untranslated Strings Diagnostic

Brak

Untranslated Strings Designer

Brak