æ¡è¿Žæ‚¨ä¾†åˆ°æœ¬åº—ï¼æ‚¨å¯ä»¥
登入
或
æˆç‚ºæœƒå“¡
使用完整功能
首é
商å“備忘簿 (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
商å“類別
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
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Cras porta massa at
下載PDF &nb...
NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Amet luctus libero
Mice and Trackballs (6)
Praesent orci dui (2)
Quis euismod neque (1)
排列方å¼
圖文
圖片
排åºæ–¹å¼
é è¨
å稱 A - Z
å稱 Z - A
åƒ¹æ ¼ä½Ž > 高
åƒ¹æ ¼é«˜ > 低
評價高 > 低
評價低 > 高
型號 A - Z
型號 Z - A
顯示數é‡
6
25
50
75
100
商å“比較清單 (0)
1
2
>
>|
第1 ~ 6ç† (å…±9ç†)
Cras porta massa at
下載PDF &nb...
NT100
å«ç¨…價 NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Donec lacinia volu
下載PDF &nb...
NT120
å«ç¨…價 NT120
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Fermentum quis tinci
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT1,000
å«ç¨…價 NT1,000
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Fringilla eleifend
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
å«ç¨…價 NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
特價
Lacinia sapien
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT120
NT98
å«ç¨…價 NT98
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
Metus placerat
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
å«ç¨…價 NT100
åŠ å…¥å•†å“備忘
åŠ å…¥å•†å“比較
排列方å¼
圖文
/
圖片
商å“比較清單 (0)
1
2
>
>|
第1 ~ 6ç† (å…±9ç†)
Design By
Kinew Co.,
Queries: 119, Total time: 47.733 ms [
By time
] [
By id
] [
By file
]
1
(0.327)
SELECT
*
FROM
oc_store
WHERE
REPLACE(`ssl`, 'www.', '') = 'https://cart.kinew.com/jouet/'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:49
2
(2.031)
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.406)
SELECT
*
FROM
`oc_language`
WHERE
status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:140
4
(0.221)
SELECT
*
FROM
oc_currency
/opt/lampp/htdocs_vsite/cart/jouet/system/library/currency.php:13
5
(0.378)
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.414)
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.773)
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
(1.291)
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
9
(1.045)
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
10
(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 = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
11
(0.258)
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
12
(0.239)
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
13
(1.213)
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 = '61'
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
14
(0.970)
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 = '55'
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
15
(0.502)
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
16
(0.468)
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
17
(0.469)
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
18
(0.509)
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 = '57'
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
19
(0.472)
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 = '56'
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
20
(0.879)
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
21
(0.216)
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
22
(0.218)
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
23
(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 = '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
24
(0.214)
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
25
(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 = '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
26
(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
27
(0.202)
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
28
(0.236)
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
29
(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
30
(0.202)
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
31
(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
32
(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
33
(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
34
(0.192)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
35
(0.243)
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
36
(0.223)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
37
(1.140)
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
38
(0.262)
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
39
(0.959)
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
40
(0.257)
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
41
(1.032)
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
42
(0.277)
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
43
(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
44
(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 = '64'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
45
(0.239)
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
46
(1.027)
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
47
(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 = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
48
(0.255)
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
49
(0.258)
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
50
(0.230)
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
51
(0.932)
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
52
(0.227)
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
53
(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
54
(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
55
(0.199)
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
56
(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 = '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
57
(0.198)
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
58
(0.198)
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
59
(0.199)
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
60
(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
61
(0.201)
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
62
(0.439)
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
63
(0.077)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
64
(0.113)
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
65
(0.111)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
66
(0.075)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
67
(0.109)
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
68
(0.113)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
69
(0.074)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
70
(0.108)
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
71
(0.120)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
72
(1.649)
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
73
(0.128)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
74
(0.074)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
75
(0.114)
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
76
(1.070)
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
77
(0.289)
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
78
(0.943)
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
79
(0.251)
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
80
(1.029)
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
81
(0.275)
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
82
(0.258)
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
83
(0.255)
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
84
(0.235)
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
85
(1.034)
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
86
(0.269)
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
87
(0.258)
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
88
(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
89
(0.228)
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
90
(0.936)
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
91
(0.228)
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
92
(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
93
(0.218)
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
94
(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
95
(0.209)
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
96
(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
97
(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 = '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
98
(0.202)
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
99
(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 = '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
100
(0.202)
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
101
(0.130)
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
102
(0.147)
SELECT
*
FROM
oc_setting
WHERE
store_id = '0'
AND
`group` = 'pavmegamenubase_params'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/setting.php:6
103
(0.749)
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
104
(1.214)
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
105
(0.965)
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
106
(1.034)
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
107
(0.288)
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
108
(0.258)
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
109
(0.251)
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
110
(1.061)
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
111
(0.264)
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
112
(0.256)
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
113
(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
114
(0.982)
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
115
(0.076)
SELECT
*
FROM
oc_category_to_layout
WHERE
category_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/category.php:56
116
(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
117
(0.116)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
118
(0.109)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'total'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
119
(0.264)
SELECT
SUM(amount)
AS
total
FROM
oc_customer_transaction
WHERE
customer_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/customer.php:157
