Requêtes de base de données
51 requêtes exécutées

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM aroma_menu AS m
      LEFT JOIN aroma_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    SELECT *
      FROM aroma_hikashop_config
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM aroma_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_hikashop'
    SELECT id, home, template, s.params
      FROM aroma_template_styles as s
      LEFT JOIN aroma_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    SELECT a.*, b.product_category_id, b.category_id, b.ordering
      FROM aroma_hikashop_product AS a
      LEFT JOIN aroma_hikashop_product_category AS b
      ON a.product_id = b.product_id
      WHERE a.product_id=6
      LIMIT 1
    SELECT joomlatablename,tablepkID
      FROM `aroma_falang_tableinfo`
    SELECT *
      FROM aroma_languages
      ORDER BY ordering
    SHOW FULL COLUMNS
      FROM `aroma_languages`
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM aroma_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_falang'
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM aroma_falang_content AS falang_content
      WHERE falang_content.language_id=2
      AND falang_content.published=1
      AND falang_content.reference_id IN(6)
      AND falang_content.reference_table='hikashop_product'
    UPDATE `aroma_hikashop_product`
      SET `product_hit`='272',`product_last_seen_date`='1352100320'
      WHERE `product_id`='6'
    SELECT b.*
      FROM aroma_hikashop_product_related AS a
      LEFT JOIN aroma_hikashop_product AS b
      ON a.product_related_id = b.product_id
      WHERE a.product_id =6
      AND a.product_related_type='options'
      AND b.product_published=1
      ORDER BY a.product_related_ordering ASC, a.product_related_id ASC
    SELECT *
      FROM aroma_hikashop_product
      WHERE product_parent_id IN (6)
    SELECT a.*,b.*
      FROM aroma_hikashop_variant AS a
      LEFT JOIN aroma_hikashop_characteristic AS b
      ON a.variant_characteristic_id=b.characteristic_id
      WHERE a.variant_product_id IN (6)
      ORDER BY a.ordering ASC,b.characteristic_id ASC
    SELECT *
      FROM aroma_hikashop_file
      WHERE file_ref_id IN (6)
      AND file_type IN ('product','file')
      ORDER BY file_ordering ASC, file_id ASC
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM aroma_falang_content AS falang_content
      WHERE falang_content.language_id=2
      AND falang_content.published=1
      AND falang_content.reference_id IN(65)
      AND falang_content.reference_table='hikashop_file'
    SELECT currency_id
      FROM aroma_hikashop_currency
      WHERE currency_published=1 OR currency_id = 1
    SELECT *
      FROM aroma_hikashop_price
      WHERE price_currency_id IN (1)
      AND price_product_id IN (6)
      ORDER BY price_value DESC
    SELECT *
      FROM aroma_hikashop_currency
      WHERE currency_id IN (1)
    SELECT b.*,c.*
      FROM aroma_hikashop_category AS a
      LEFT JOIN aroma_hikashop_taxation AS b
      ON a.category_namekey=b.category_namekey
      LEFT JOIN aroma_hikashop_tax AS c
      ON b.tax_namekey=c.tax_namekey
      WHERE a.category_id = 21
      AND b.taxation_published=1
      AND taxation_type = ''
    SELECT *
      FROM aroma_hikashop_zone
      WHERE zone_id = 195
    SELECT *
      FROM aroma_hikashop_discount
      WHERE discount_type='discount'
      AND discount_published=1
      AND ( discount_quota>discount_used_times OR discount_quota=0 )
      AND discount_start < 1352100320
      AND ( discount_end > 1352100320 OR discount_end = 0 )
      AND ( discount_product_id IN (6) OR discount_product_id=0 )
      AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
    SELECT category_id
      FROM aroma_hikashop_product_category
      WHERE product_id=6
      ORDER BY ordering ASC
    SELECT DISTINCT b.*
      FROM aroma_hikashop_category AS a
      LEFT JOIN aroma_hikashop_category AS b
      ON a.category_left >= b.category_left
      WHERE b.category_right >= a.category_right
      AND a.category_id IN (13)
      ORDER BY b.category_left
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM aroma_falang_content AS falang_content
      WHERE falang_content.language_id=2
      AND falang_content.published=1
      AND falang_content.reference_id IN(1,2,13)
      AND falang_content.reference_table='hikashop_category'
    SELECT *
      FROM aroma_hikashop_field as a
      WHERE a.`field_published` = 1
      AND a.`field_frontcomp` = 1
      AND a.field_table='product'
      AND ((field_with_sub_categories=0
      AND (field_categories="all" OR field_categories LIKE '%,13,%'))OR (field_with_sub_categories=1
      AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,13,%')))
      ORDER BY a.`field_ordering` ASC
    SELECT DISTINCT b.*
      FROM aroma_hikashop_category AS a
      LEFT JOIN aroma_hikashop_category AS b
      ON a.category_left >= b.category_left
      WHERE b.category_right >= a.category_right
      AND a.category_id IN (13)
      ORDER BY b.category_left
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM aroma_falang_content AS falang_content
      WHERE falang_content.language_id=2
      AND falang_content.published=1
      AND falang_content.reference_id IN(1,2,13)
      AND falang_content.reference_table='hikashop_category'
    SELECT a.*
      FROM aroma_hikashop_badge AS a
      WHERE a.badge_start <= 1352100320
      AND ( a.badge_end >= 1352100320 OR a.badge_end =0 )
      AND a.badge_published=1
      AND badge_discount_id=0
      AND ((badge_category_childs = 0
      AND (badge_category_id = 0 OR badge_category_id = 13))OR (badge_category_childs = 1
      AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 13)))
      ORDER BY a.badge_ordering ASC,a.badge_id ASC
    SELECT b.*
      FROM aroma_hikashop_product_category AS a
      LEFT JOIN aroma_hikashop_category AS b
      ON a.category_id = b.category_id
      WHERE a.product_id = 6
      ORDER BY a.ordering ASC
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM aroma_falang_content AS falang_content
      WHERE falang_content.language_id=2
      AND falang_content.published=1
      AND falang_content.reference_id IN(13)
      AND falang_content.reference_table='hikashop_category'
    SELECT *
      FROM aroma_extensions
      WHERE folder='content'
      AND element='hikashopsocial'
      AND type='plugin'
    SELECT product_average_score, product_total_vote
      FROM aroma_hikashop_product
      WHERE product_id = 6
    SELECT count(vote_id)
      FROM `aroma_hikashop_vote`
      WHERE vote_ref_id = 6
      AND vote_type = 'product'
    SELECT product_average_score, product_total_vote
      FROM aroma_hikashop_product
      WHERE product_id = 6
    SELECT *
      FROM aroma_jcomments_settings
      WHERE lang = 'fr-FR'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM aroma_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
    SELECT *
      FROM `aroma_jcomments_objects`
      WHERE `object_id` = '6'
      AND `object_group` = 'com_hikashop'
      AND `lang` = 'fr-FR'
    SELECT count(*)
      FROM aroma_jcomments AS c
      WHERE c.object_id = 6
      AND c.object_group = 'com_hikashop'
      AND c.published = 1
      AND c.lang = 'fr-FR'
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM aroma_modules AS m
      LEFT JOIN aroma_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN aroma_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-11-05 07:25:20')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-11-05 07:25:20')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 204 OR mm.menuid <= 0)
      AND m.language IN ('fr-FR','*')
      ORDER BY m.position, m.ordering
    SELECT s.*, sn.name AS socnet, sn.url AS socneturl, sg.name AS groupname
      FROM aroma_stalker AS s
      LEFT JOIN aroma_stalker_socnets AS sn
      ON sn.id = s.socnetid
      LEFT JOIN aroma_stalker_groups AS sg
      ON sg.id = s.groupid
      WHERE s.published = 1
      ORDER BY ordering
    SELECT a.*
      FROM aroma_hikashop_cart AS a
      WHERE (a.cart_id = 198)
      AND a.cart_type = 'cart'
      ORDER BY a.cart_modified DESC
      LIMIT 1
    SELECT b.*,c.*
      FROM aroma_hikashop_cart_product AS b
      LEFT JOIN aroma_hikashop_product AS c
      ON b.product_id=c.product_id
      WHERE b.cart_id = 198
      AND b.product_id > 0
      ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM aroma_falang_content AS falang_content
      WHERE falang_content.language_id=2
      AND falang_content.published=1
      AND falang_content.reference_id IN(6)
      AND falang_content.reference_table='hikashop_product'
    SELECT *
      FROM aroma_hikashop_price
      WHERE price_currency_id IN (1)
      AND price_product_id IN (6)
      ORDER BY price_value DESC
    SELECT *
      FROM aroma_hikashop_discount
      WHERE discount_type='discount'
      AND discount_published=1
      AND ( discount_quota>discount_used_times OR discount_quota=0 )
      AND discount_start < 1352100320
      AND ( discount_end > 1352100320 OR discount_end = 0 )
      AND ( discount_product_id IN (6) OR discount_product_id=0 )
      AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
    SELECT *
      FROM aroma_modules
      WHERE published=1
      ORDER BY id ;
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM aroma_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM aroma_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
    SELECT m2.language, m2.id
      FROM aroma_menu as m
      INNER JOIN aroma_associations as a
      ON a.id=m.id
      AND a.context='com_menus.item'
      INNER JOIN aroma_associations as a2
      ON a.key=a2.key
      INNER JOIN aroma_menu as m2
      ON a2.id=m2.id
      WHERE m.id=204
    UPDATE `aroma_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1352100206;s:18:\"session.timer.last\";i:1352100319;s:17:\"session.timer.now\";i:1352100320;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":7:{s:7:\"zone_id\";s:3:\"195\";s:12:\"ssl_redirect\";i:0;s:7:\"cart_id\";i:198;s:15:\"shipping_method\";i:0;s:11:\"shipping_id\";i:0;s:13:\"shipping_data\";i:0;s:8:\"cart_new\";s:1:\"0\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4e86d3c578f268dca144be80274fa7cd\";}hikashop_viewed_products|a:1:{i:6;i:6;}' , `time` = '1352100320'
      WHERE `session_id` = 'mlp2j69c8todaebuarqog0bmm4'

38 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :

    6 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
      FROM aroma_falang_content AS falang_content
    5 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM aroma_extensions
    2 × SELECT *
      FROM aroma_hikashop_price
    2 × SELECT DISTINCT b.*
      FROM aroma_hikashop_category AS a
      LEFT JOIN aroma_hikashop_category AS b
      ON a.category_left >= b.category_left
    2 × SELECT product_average_score, product_total_vote
      FROM aroma_hikashop_product
    2 × SELECT *
      FROM aroma_hikashop_discount
    1 × SELECT *
      FROM aroma_jcomments_settings
    1 × SELECT *
      FROM `aroma_jcomments_objects`
    1 × SELECT count(vote_id)
      FROM `aroma_hikashop_vote`
    1 × SELECT *
      FROM aroma_hikashop_confi
    1 × SELECT b.*
      FROM aroma_hikashop_product_category AS a
      LEFT JOIN aroma_hikashop_category AS b
      ON a.category_id = b.category_id
    1 × SELECT *
      FROM aroma_extensions
    1 × SELECT count(*)
      FROM aroma_jcomments AS c
    1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM aroma_modules AS m
      LEFT JOIN aroma_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN aroma_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
    1 × SELECT *
      FROM aroma_modules
    1 × SELECT m2.language, m2.id
      FROM aroma_menu as m
      INNER JOIN aroma_associations as a
      ON a.id=m.id
      AND a.context='com_menus.item'
      INNER JOIN aroma_associations as a2
      ON a.key=a2.key
      INNER JOIN aroma_menu as m2
      ON a2.id=m2.id
    1 × SELECT b.*,c.*
      FROM aroma_hikashop_cart_product AS b
      LEFT JOIN aroma_hikashop_product AS c
      ON b.product_id=c.product_id
    1 × SELECT a.*
      FROM aroma_hikashop_cart AS a
    1 × SELECT s.*, sn.name AS socnet, sn.url AS socneturl, sg.name AS groupname
      FROM aroma_stalker AS s
      LEFT JOIN aroma_stalker_socnets AS sn
      ON sn.id = s.socnetid
      LEFT JOIN aroma_stalker_groups AS sg
      ON sg.id = s.groupid
    1 × SELECT a.*
      FROM aroma_hikashop_badge AS a
    1 × SELECT *
      FROM aroma_hikashop_field as a
    1 × SELECT *
      FROM aroma_hikashop_file
    1 × SELECT currency_id
      FROM aroma_hikashop_currency
    1 × SELECT a.*,b.*
      FROM aroma_hikashop_variant AS a
      LEFT JOIN aroma_hikashop_characteristic AS b
      ON a.variant_characteristic_id=b.characteristic_id
    1 × SELECT *
      FROM aroma_hikashop_product
    1 × SELECT joomlatablename,tablepkID
      FROM `aroma_falang_tableinfo
    1 × SELECT b.*
      FROM aroma_hikashop_product_related AS a
      LEFT JOIN aroma_hikashop_product AS b
      ON a.product_related_id = b.product_id
    1 × SELECT a.*, b.product_category_id, b.category_id, b.ordering
      FROM aroma_hikashop_product AS a
      LEFT JOIN aroma_hikashop_product_category AS b
      ON a.product_id = b.product_id
    1 × SELECT *
      FROM aroma_hikashop_currency
    1 × SELECT category_id
      FROM aroma_hikashop_product_category
    1 × SELECT id, home, template, s.params
      FROM aroma_template_styles as s
      LEFT JOIN aroma_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
    1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM aroma_menu AS m
      LEFT JOIN aroma_extensions AS e
      ON m.component_id = e.extension_id
    1 × SELECT *
      FROM aroma_hikashop_zone
    1 × SELECT b.*,c.*
      FROM aroma_hikashop_category AS a
      LEFT JOIN aroma_hikashop_taxation AS b
      ON a.category_namekey=b.category_namekey
      LEFT JOIN aroma_hikashop_tax AS c
      ON b.tax_namekey=c.tax_namekey
    1 × SELECT *
      FROM aroma_languages

Autres tables :

    1 × UPDATE `aroma_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1352100206;s:18:\"session.timer.last\";i:1352100319;s:17:\"session.timer.now\";i:1352100320;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":7:{s:7:\"zone_id\";s:3:\"195\";s:12:\"ssl_redirect\";i:0;s:7:\"cart_id\";i:198;s:15:\"shipping_method\";i:0;s:11:\"shipping_id\";i:0;s:13:\"shipping_data\";i:0;s:8:\"cart_new\";s:1:\"0\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4e86d3c578f268dca144be80274fa7cd\";}hikashop_viewed_products|a:1:{i:6;i:6;}' , `time` = '1352100320'
    1 × UPDATE `aroma_hikashop_product`
      SET `product_hit`='272',`product_last_seen_date`='1352100320'
    1 × SHOW FULL COLUMNS
      FROM `aroma_languages