Boutique Essénienne - Sagesse pratique au quotidien

Informations

Utilisation de la mémoire

2364 requêtes achevées

1. DELETE
     FROM jos_session
     WHERE ( time < '1268347314' )
2. SELECT *
     FROM jos_session
     WHERE session_id = 'ab7c249b8db1a107655290db9d2c959f'
3. UPDATE `jos_session`
     SET `time`='1268349114',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
     WHERE session_id='ab7c249b8db1a107655290db9d2c959f'
4. SELECT *
     FROM jos_components
     WHERE parent = 0
5. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
6. SELECT name,player_id,ripper_id,postreplace
     FROM jos_avr_tags
7. SELECT name,player_id,ripper_id,postreplace
     FROM jos_avr_tags
8. SELECT count(*)
     FROM jos_menu_types
     WHERE `menutype`='magazin'
9. SELECT `id`,`title`,`published`
     FROM  jos_sections
     WHERE `published`<>-2
10. SELECT name,id,published,parent,link,home
      FROM `jos_menu`
      WHERE `menutype`='magazin'
      AND `published`<>-2
11. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='13'
      AND `published`<>-2
12. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='14'
      AND `published`<>-2
13. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='15'
      AND `published`<>-2
14. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='17'
      AND `published`<>-2
15. SELECT *
      FROM jos_migration_backlinks
      WHERE url LIKE 'Livres/Tous-les-livres%' OR sefurl LIKE 'Livres/Tous-les-livres%'
16. SELECT `id`,`link`
      FROM jos_menu 
      WHERE ((`name` LIKE '%Livres%')
      AND (`published` > 0))
17. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'Livres/Tous-les-livres'
      ORDER BY rank ASC
      LIMIT 1
18. UPDATE jos_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&limit=100&limitstart=0&page=shop.browse'
      AND `oldurl` = 'Livres/Tous-les-livres'
19. 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
20. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 0)
      ORDER BY menuid DESC
      LIMIT 0, 1
21. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
22. 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'
23. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
24. 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`);
25. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
26. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
27. 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` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`)
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=207
     
      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'
28. SELECT category_id, category_name
      FROM jos_vm_category
      WHERE category_id='207'
29. SELECT category_id, category_description
      FROM jos_vm_category
      WHERE category_id='207'
30. 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='207'
      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
31. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='207'
      AND jos_vm_category.category_id='207'
32. SELECT category_id, category_name,category_parent_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='189'
      AND jos_vm_category.category_id='189'
33. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=189%'
      AND published=1
34. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
35. 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
36. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=189&lang=fr&page=shop.browse'
37. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=207%'
      AND published=1
38. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
39. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&lang=fr&page=shop.browse'
40. SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
                                    `jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
                                    `product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE (`jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`)
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=207
     
      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`.`cdate` DESC
      LIMIT 0, 100
41. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=304202%'
      AND published=1
42. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=207%'
      AND published=1
43. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
44. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
45. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304202'
46. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=304202
47. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='304202'
      AND (start_date<='1268349115' OR start_date=0)
      AND (end_date>='1268264160' OR end_date=0)
      AND product_discount_id=discount_id
48. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=304202
49. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268349115' OR start_date=0)
      AND (end_date>='1268264160' OR end_date=0)
      AND product_discount_id=discount_id
50. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
51. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=304202
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
52. SELECT country
      FROM jos_vm_user_info
      WHERE user_info_id=''
53. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=304202
54. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=304202
55. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=304202
      AND `file_is_image`=1
      AND `file_published`=1
56. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=304202
57. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=304202
      AND `file_is_image`=0
      AND `file_published`=1
59. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='304202'
60. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
61. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='304202'
62. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=304202
63. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=304202
64. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=304133%'
      AND published=1
65. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=207%'
      AND published=1
66. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
67. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
68. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304133'
69. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=304133
70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='304133'
      AND (start_date<='1268349115' OR start_date=0)
      AND (end_date>='1268264160' OR end_date=0)
      AND product_discount_id=discount_id
71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=304133
72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268349115' OR start_date=0)
      AND (end_date>='1268264160' OR end_date=0)
      AND product_discount_id=discount_id
73. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='304133'
74. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=304133
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
75. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=304133
76. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=304133
77. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=304133
      AND `file_is_image`=1
      AND `file_published`=1
78. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=304133
79. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=304133
      AND `file_is_image`=0
      AND `file_published`=1
81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='304133'
82. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
83. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='304133'
84. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=304133
85. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=304133
86. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=304129%'
      AND published=1
87. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=207%'
      AND published=1
88. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
89. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
90. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=207&flypage=flypage.tpl&lang=fr&page=shop.product_details&product_id=304129'
91. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=304129
92. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='304129'
      AND (start_date<='1268349115' OR start_date=0)
      AND (end_date>='1268264160' OR end_date=0)
      AND product_discount_id=discount_id
93. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=304129
94. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268349115' OR start_date=0)
      AND (end_date>='1268264160' OR end_date=0)
      AND product_discount_id=discount_id
95. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='304129'
96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=304129
      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=304129
98. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=304129
99. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=304129
      AND `file_is_image`=1
      AND `file_published`=1
100. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=304129
101. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=1
       AND `file_published`=1
102. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=304129
       AND `file_is_image`=0
       AND `file_published`=1
103. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id='304129'
104. SELECT *
       FROM `jos_vm_product_files`
       WHERE `file_product_id`=0
       AND `file_is_image`=0
       AND `file_published`=1
105. SELECT votes, allvotes, rating
       FROM jos_vm_product_votes
       WHERE product_id='304129'
106. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=304129
107. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=304129