æ¡è¿Žæ‚¨ä¾†åˆ°æœ¬åº—ï¼æ‚¨å¯ä»¥
登入
或
æˆç‚ºæœƒå“¡
使用完整功能
首é
商å“備忘簿 (0)
會員ä¸å¿ƒ
購物車
çµå¸³
購物車
0 ä»¶å•†å“ NT0
æ‚¨çš„è³¼ç‰©è»Šæ²’æœ‰åŠ å…¥ä»»ä½•å•†å“
Home
å¸ç¿’
動手åš
Nulla a odio
Amet luctus libero
Aenean placerat
Hendrerit libero
Luctus et eu
Cliquet lectus rutrum
Sed quam lore
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Curabitur tempus
Siam eget arcu
Ante erat sagittis rhoncus diam eget arcu
Ante erat sagittis rhoncus diam eget arcu tempor faucibus fringilla quam vulputate
éŠæˆ²å’Œæ‹¼åœ–
Nullam aliquet ant
Test2
Pellentesque mauris
Quisque eu augue
Item page
動作類玩具
最新消æ¯
推薦賺çŽé‡‘
首é
»
Amet luctus libero
»
Mice and Trackballs
»
test1
商å“類別
Aenean placerat (7)
Amet luctus libero (18)
Mice and Trackballs (6)
Praesent orci dui (2)
Quis euismod neque (1)
Cliquet lectus rutrum (3)
test 3 (0)
test4 (0)
test 5 (0)
Hendrerit libero (0)
暢銷商å“
Fermentum quis tinci
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT1,000
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Fringilla eleifend
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
特價
Risus viverra ullam
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
NT95
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Donec lacinia volu
下載PDF &nb...
NT120
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
test1
æ¤é¡žåˆ¥é‚„æ²’æœ‰åŠ å…¥ä»»ä½•å•†å“
繼續
Design By
Kinew Co.,
Queries: 103, Total time: 173.365 ms [
By time
] [
By id
] [
By file
]
1
(0.221)
SELECT
*
FROM
oc_store
WHERE
REPLACE(`ssl`, 'www.', '') = 'https://cart.kinew.com/jouet/'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:49
2
(2.078)
SELECT
*
FROM
oc_setting
WHERE
store_id = '0'
OR
store_id = '0'
ORDER BY
store_id
ASC
/opt/lampp/htdocs_vsite/cart/jouet/index.php:61
3
(0.402)
SELECT
*
FROM
`oc_language`
WHERE
status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:140
4
(0.197)
SELECT
*
FROM
oc_currency
/opt/lampp/htdocs_vsite/cart/jouet/system/library/currency.php:13
5
(0.325)
SELECT
*
FROM
oc_weight_class wc
LEFT JOIN
oc_weight_class_description wcd
ON
(wc.weight_class_id = wcd.weight_class_id)
WHERE
wcd.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/weight.php:9
6
(0.358)
SELECT
*
FROM
oc_length_class mc
LEFT JOIN
oc_length_class_description mcd
ON
(mc.length_class_id = mcd.length_class_id)
WHERE
mcd.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/length.php:9
7
(0.648)
SELECT
DISTINCT *
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.category_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:4
8
(0.143)
SELECT
DISTINCT *
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.category_id = '62'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:4
9
(0.132)
SELECT
DISTINCT *
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.category_id = '65'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:4
10
(0.682)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '65'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
11
(0.927)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '65'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
12
(0.784)
SELECT
p.product_id, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '65'
GROUP BY
p.product_id
ORDER BY
p.sort_order
ASC
, LCASE(pd.name)
ASC
LIMIT
0,6
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:222
13
(136.588)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '65'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
14
(0.264)
SELECT
*
FROM
oc_layout_route
WHERE
'product/category' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
15
(0.209)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
16
(0.783)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '0'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
17
(0.278)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '17'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
18
(0.594)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '17'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
19
(0.255)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '61'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
20
(0.651)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
21
(0.359)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '62'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
22
(0.261)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
23
(0.257)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '64'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
24
(0.236)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '34'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
25
(0.651)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '34'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
26
(0.267)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
27
(0.261)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '41'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
28
(0.263)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
29
(0.234)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '33'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
30
(0.562)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '33'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
31
(0.887)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
32
(0.219)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
33
(0.217)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
34
(0.208)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
35
(0.211)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
36
(0.241)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
37
(0.210)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
38
(0.205)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
39
(0.210)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
40
(0.204)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
41
(0.352)
SELECT
*
FROM
oc_banner_image bi
LEFT JOIN
oc_banner_image_description bid
ON
(bi.banner_image_id = bid.banner_image_id)
WHERE
bi.banner_id = '9'
AND
bid.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/banner.php:4
42
(0.084)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '65'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
43
(0.117)
SELECT
*
FROM
oc_layout_route
WHERE
'product/category' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
44
(0.117)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
45
(0.078)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '65'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
46
(0.112)
SELECT
*
FROM
oc_layout_route
WHERE
'product/category' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
47
(0.118)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
48
(0.076)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '65'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
49
(0.110)
SELECT
*
FROM
oc_layout_route
WHERE
'product/category' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
50
(0.116)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
51
(1.197)
SELECT
*
FROM
oc_information i
LEFT JOIN
oc_information_description id
ON
(i.information_id = id.information_id)
LEFT JOIN
oc_information_to_store i2s
ON
(i.information_id = i2s.information_id)
WHERE
id.language_id = '4'
AND
i2s.store_id = '0'
AND
i.status = '1'
ORDER BY
i.sort_order, LCASE(id.title)
ASC
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/information.php:10
52
(0.126)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
53
(0.076)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '65'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
54
(0.110)
SELECT
*
FROM
oc_layout_route
WHERE
'product/category' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
55
(0.726)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '0'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
56
(0.268)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '17'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
57
(0.578)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '17'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
58
(0.264)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '61'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
59
(0.652)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
60
(0.281)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '62'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
61
(0.284)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
62
(0.265)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '64'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
63
(0.240)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '34'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
64
(0.672)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '34'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
65
(0.270)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
66
(0.263)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '41'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
67
(0.265)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
68
(0.234)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '33'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
69
(0.562)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '33'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
70
(0.746)
SELECT
op.product_id,
COUNT
(*)
AS
total
FROM
oc_order_product op
LEFT JOIN
`oc_order` o
ON
(op.order_id = o.order_id)
LEFT JOIN
`oc_product` p
ON
(op.product_id = p.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
o.order_status_id > '0'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
GROUP BY
op.product_id
ORDER BY
total
DESC
LIMIT
4
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:333
71
(1.098)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '46'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
72
(0.488)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '52'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
73
(0.501)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '54'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
74
(0.515)
SELECT
DISTINCT *, pd.name
AS
name, p.image, m.name
AS
manufacturer, (
SELECT
price
FROM
oc_product_discount pd2
WHERE
pd2.product_id = p.product_id
AND
pd2.customer_group_id = '1'
AND
pd2.quantity = '1'
AND
((pd2.date_start = '0000-00-00'
OR
pd2.date_start < NOW())
AND
(pd2.date_end = '0000-00-00'
OR
pd2.date_end > NOW()))
ORDER BY
pd2.priority
ASC
, pd2.price
ASC
LIMIT
1)
AS
discount, (
SELECT
price
FROM
oc_product_special ps
WHERE
ps.product_id = p.product_id
AND
ps.customer_group_id = '1'
AND
((ps.date_start = '0000-00-00'
OR
ps.date_start < NOW())
AND
(ps.date_end = '0000-00-00'
OR
ps.date_end > NOW()))
ORDER BY
ps.priority
ASC
, ps.price
ASC
LIMIT
1)
AS
special, (
SELECT
points
FROM
oc_product_reward pr
WHERE
pr.product_id = p.product_id
AND
customer_group_id = '1')
AS
reward, (
SELECT
ss.name
FROM
oc_stock_status ss
WHERE
ss.stock_status_id = p.stock_status_id
AND
ss.language_id = '4')
AS
stock_status, (
SELECT
wcd.unit
FROM
oc_weight_class_description wcd
WHERE
p.weight_class_id = wcd.weight_class_id
AND
wcd.language_id = '4')
AS
weight_class, (
SELECT
lcd.unit
FROM
oc_length_class_description lcd
WHERE
p.length_class_id = lcd.length_class_id
AND
lcd.language_id = '4')
AS
length_class, (
SELECT
AVG(rating)
AS
total
FROM
oc_review r1
WHERE
r1.product_id = p.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating, (
SELECT
COUNT
(*)
AS
total
FROM
oc_review r2
WHERE
r2.product_id = p.product_id
AND
r2.status = '1'
GROUP BY
r2.product_id)
AS
reviews, p.sort_order
FROM
oc_product p
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
LEFT JOIN
oc_manufacturer m
ON
(p.manufacturer_id = m.manufacturer_id)
WHERE
p.product_id = '53'
AND
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:14
75
(0.237)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
76
(0.210)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
77
(0.207)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
78
(0.206)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
79
(0.207)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
80
(0.220)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
81
(0.203)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
82
(0.200)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
83
(0.206)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
84
(0.200)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
85
(0.133)
SELECT
*
FROM
oc_banner_image bi
LEFT JOIN
oc_banner_image_description bid
ON
(bi.banner_image_id = bid.banner_image_id)
WHERE
bi.banner_id = '9'
AND
bid.language_id = '4'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/banner.php:4
86
(0.154)
SELECT
*
FROM
oc_setting
WHERE
store_id = '0'
AND
`group` = 'pavmegamenubase_params'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/setting.php:6
87
(0.746)
SELECT
m.*, md.title,md.description
FROM
oc_megamenu m
LEFT JOIN
oc_megamenu_description md
ON
m.megamenu_id=md.megamenu_id
AND
language_id=4
WHERE
m.`published`=1
AND
store_id=0
ORDER BY
`position`
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/menu/megamenu.php:47
88
(0.773)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '0'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
89
(0.584)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '17'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
90
(0.663)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '61'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
91
(0.293)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '62'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
92
(0.265)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
93
(0.265)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '64'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
94
(0.642)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '34'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
95
(0.267)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
96
(0.257)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '41'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
97
(0.254)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_category_path cp
LEFT JOIN
oc_product_to_category p2c
ON
(cp.category_id = p2c.category_id)
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
cp.path_id = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
98
(0.563)
SELECT
*
FROM
oc_category c
LEFT JOIN
oc_category_description cd
ON
(c.category_id = cd.category_id)
LEFT JOIN
oc_category_to_store c2s
ON
(c.category_id = c2s.category_id)
WHERE
c.parent_id = '33'
AND
cd.language_id = '4'
AND
c2s.store_id = '0'
AND
c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:10
99
(0.076)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '65'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
100
(0.115)
SELECT
*
FROM
oc_layout_route
WHERE
'product/category' LIKE CONCAT(route, '%')
AND
store_id = '0'
ORDER BY
route
DESC
LIMIT
1
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/design/layout.php:4
101
(0.115)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
102
(0.117)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'total'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
103
(0.343)
SELECT
SUM(amount)
AS
total
FROM
oc_customer_transaction
WHERE
customer_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/customer.php:157
