歡迎您來到本店！您可以
登入
或
成為會員
使用完整功能
首頁
商品備忘簿 (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
動作類玩具
最新消息
推薦賺獎金
首頁
»
特賣商品
特賣商品
排列方式
圖文
圖片
排序方式
預設
名稱 A - Z
名稱 Z - A
價格低 > 高
價格高 > 低
評價高 > 低
評價低 > 高
型號 A - Z
型號 Z - A
顯示數量
6
25
50
75
100
商品比較清單 (0)
第1 ~ 5筆 (共5筆)
特價
Lacinia sapien
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT120
NT98
含稅價 NT98
加入商品備忘
加入商品比較
特價
Posuere non euis
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT120
NT98
含稅價 NT98
加入商品備忘
加入商品比較
特價
Proin vitae odio libero
Nam ultricies sagittis turpis quis auctor. Fusce urna est, a...
NT100
NT90
含稅價 NT90
加入商品備忘
加入商品比較
特價
Risus viverra ullam
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
NT95
含稅價 NT95
加入商品備忘
加入商品比較
特價
Sceleris tempus posue
Curabitur tempus velit in leo fermentum quis tincidunt lorem...
NT100
NT95
含稅價 NT95
加入商品備忘
加入商品比較
排列方式
圖文
/
圖片
商品比較清單 (0)
第1 ~ 5筆 (共5筆)
Design By
Kinew Co.,
Queries: 63, Total time: 112.242 ms [
By time
] [
By id
] [
By file
]
1
(11.010)
SELECT
*
FROM
oc_store
WHERE
REPLACE(`ssl`, 'www.', '') = 'https://cart.kinew.com/jouet/'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:49
2
(18.260)
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
(1.138)
SELECT
*
FROM
`oc_language`
WHERE
status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:140
4
(0.907)
SELECT
*
FROM
oc_currency
/opt/lampp/htdocs_vsite/cart/jouet/system/library/currency.php:13
5
(12.171)
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
(8.735)
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
(22.914)
SELECT
COUNT
(DISTINCT ps.product_id)
AS
total
FROM
oc_product_special ps
LEFT JOIN
oc_product p
ON
(ps.product_id = p.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
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()))
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:612
8
(2.710)
SELECT
DISTINCT ps.product_id, (
SELECT
AVG(rating)
FROM
oc_review r1
WHERE
r1.product_id = ps.product_id
AND
r1.status = '1'
GROUP BY
r1.product_id)
AS
rating
FROM
oc_product_special ps
LEFT JOIN
oc_product p
ON
(ps.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
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
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()))
GROUP BY
ps.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:278
9
(3.680)
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
10
(0.555)
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 = '58'
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
11
(0.810)
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 = '42'
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
12
(0.524)
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
13
(0.517)
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 = '51'
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
14
(3.036)
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
15
(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 = '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
16
(0.225)
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
17
(0.256)
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
18
(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
19
(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 = '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
20
(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
21
(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
22
(0.250)
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.226)
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.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 = '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.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 = '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.222)
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.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 = '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.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
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.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
31
(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
32
(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 = '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.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
34
(1.309)
SELECT
*
FROM
oc_layout_route
WHERE
'product/special' 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
35
(1.061)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
36
(0.127)
SELECT
*
FROM
oc_layout_route
WHERE
'product/special' 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
37
(0.127)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
38
(0.119)
SELECT
*
FROM
oc_layout_route
WHERE
'product/special' 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
39
(0.131)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
40
(0.111)
SELECT
*
FROM
oc_layout_route
WHERE
'product/special' 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
41
(0.122)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
42
(3.862)
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
43
(0.132)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
44
(0.113)
SELECT
*
FROM
oc_layout_route
WHERE
'product/special' 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
45
(0.150)
SELECT
*
FROM
oc_setting
WHERE
store_id = '0'
AND
`group` = 'pavmegamenubase_params'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/setting.php:6
46
(1.726)
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
47
(4.213)
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
48
(0.889)
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
49
(0.923)
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
50
(1.548)
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
51
(0.292)
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
52
(0.296)
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
53
(0.899)
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
54
(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 = '40'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
55
(0.253)
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
56
(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 = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
57
(0.778)
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
58
(0.119)
SELECT
*
FROM
oc_layout_route
WHERE
'product/special' 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
59
(0.118)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
60
(0.133)
SELECT
*
FROM
oc_language
ORDER BY
sort_order, name
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/localisation/language.php:15
61
(0.119)
SELECT
*
FROM
oc_currency
ORDER BY
title
ASC
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/localisation/currency.php:15
62
(0.110)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'total'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
63
(0.857)
SELECT
SUM(amount)
AS
total
FROM
oc_customer_transaction
WHERE
customer_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/customer.php:157
