歡迎您來到本店!您可以
登入
或
成為會員
使用完整功能
首頁
商品備忘簿 (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
動作類玩具
最新消息
推薦賺獎金
首頁
»
二代電子發票
商品類別
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)
外部連結
YAHOO
PCHOME
GOOGLE
中華郵政
常見問與答
提問人
E-mail
問題
在此輸入提問...
發送
查看常見問題
暢銷商品
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
加入商品備忘
加入商品比較
二代電子發票
0 則評論
|
發表評論
分享
型 號:
二代電子發票
庫存狀況:
尚有庫存
NT0
購買數量:
加入商品備忘
加入商品比較
價格:
含稅價: NT0
商品介紹
商品評論 (0)
商品發問 (0)
發表評論
評論者:
評論內容:
注意:
不支援 HTML 語法
評價:
很差
非常好
請輸入驗證碼:
繼續
Design By
Kinew Co.,
Queries: 102, Total time: 42.698 ms [
By time
] [
By id
] [
By file
]
1
(0.218)
SELECT
*
FROM
oc_store
WHERE
REPLACE(`ssl`, 'www.', '') = 'https://cart.kinew.com/jouet/'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:49
2
(1.967)
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.384)
SELECT
*
FROM
`oc_language`
WHERE
status = '1'
/opt/lampp/htdocs_vsite/cart/jouet/index.php:140
4
(0.200)
SELECT
*
FROM
oc_currency
/opt/lampp/htdocs_vsite/cart/jouet/system/library/currency.php:13
5
(0.326)
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.396)
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
(2.342)
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 = '61'
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
8
(0.096)
SELECT
language_id
FROM
`oc_language`
WHERE
code = 'zh-TW'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/module/productquestion.php:47
9
(0.491)
SELECT
COUNT
(*)
AS
total
FROM
`oc_productquestion` pq
LEFT JOIN
`oc_productquestion_lang` pql
ON
(pq.question_id = pql.question_id)
WHERE
1 = 1
AND
pql.question_text != ''
AND
pql.answer_text != ''
AND
pql.language_id = 4
AND
pq.product_id = 61
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/module/productquestion.php:41
10
(0.252)
SELECT
*
FROM
oc_product_image
WHERE
product_id = '61'
ORDER BY
sort_order
ASC
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:435
11
(0.135)
SELECT
*
FROM
oc_product_discount
WHERE
product_id = '61'
AND
customer_group_id = '1'
AND
quantity > 1
AND
((date_start = '0000-00-00'
OR
date_start < NOW())
AND
(date_end = '0000-00-00'
OR
date_end > NOW()))
ORDER BY
quantity
ASC
, priority
ASC
, price
ASC
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:429
12
(1.557)
SELECT
*
FROM
oc_product_option po
LEFT JOIN
`oc_option` o
ON
(po.option_id = o.option_id)
LEFT JOIN
oc_option_description od
ON
(o.option_id = od.option_id)
WHERE
po.product_id = '61'
AND
od.language_id = '4'
ORDER BY
o.sort_order
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:376
13
(0.789)
SELECT
ag.attribute_group_id, agd.name
FROM
oc_product_attribute pa
LEFT JOIN
oc_attribute a
ON
(pa.attribute_id = a.attribute_id)
LEFT JOIN
oc_attribute_group ag
ON
(a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN
oc_attribute_group_description agd
ON
(ag.attribute_group_id = agd.attribute_group_id)
WHERE
pa.product_id = '61'
AND
agd.language_id = '4'
GROUP BY
ag.attribute_group_id
ORDER BY
ag.sort_order, agd.name
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:348
14
(0.411)
SELECT
*
FROM
oc_product_related pr
LEFT JOIN
oc_product p
ON
(pr.related_id = p.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pr.product_id = '61'
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:443
15
(0.675)
SELECT
`pd`.*
FROM
`oc_product_profile` `pp`
JOIN
`oc_profile_description` `pd`
ON
`pd`.`language_id` = 4
AND
`pd`.`profile_id` = `pp`.`profile_id`
JOIN
`oc_profile` `p`
ON
`p`.`profile_id` = `pd`.`profile_id`
WHERE
`product_id` = 61
AND
`status` = 1
AND
`customer_group_id` = 1
ORDER BY
`sort_order`
ASC
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:591
16
(0.119)
UPDATE
oc_product
SET
viewed = (viewed + 1)
WHERE
product_id = '61'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:4
17
(0.222)
SELECT
*
FROM
oc_product_to_layout
WHERE
product_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:453
18
(0.223)
SELECT
*
FROM
oc_layout_route
WHERE
'product/product' 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
19
(0.194)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
20
(1.348)
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
21
(0.375)
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
22
(0.929)
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
23
(0.264)
SELECT
COUNT
(DISTINCT p.product_id)
AS
total
FROM
oc_product_to_category p2c
LEFT JOIN
oc_product p
ON
(p2c.product_id = p.product_id)
LEFT JOIN
oc_product_description pd
ON
(p.product_id = pd.product_id)
LEFT JOIN
oc_product_to_store p2s
ON
(p.product_id = p2s.product_id)
WHERE
pd.language_id = '4'
AND
p.status = '1'
AND
p.date_available <= NOW()
AND
p2s.store_id = '0'
AND
p2c.category_id = '61'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
24
(1.020)
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
25
(0.351)
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
26
(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 = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
27
(0.248)
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
28
(0.225)
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
29
(1.015)
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
30
(0.260)
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
31
(0.252)
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
32
(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 = '42'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
33
(0.223)
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
34
(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 = '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
35
(0.812)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
36
(0.213)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
37
(0.215)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
38
(0.205)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'store'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:119
39
(0.212)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
40
(0.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
41
(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
42
(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
43
(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
44
(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
45
(0.337)
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
46
(0.081)
SELECT
*
FROM
oc_product_to_layout
WHERE
product_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:453
47
(0.117)
SELECT
*
FROM
oc_layout_route
WHERE
'product/product' 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
48
(0.117)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
49
(0.079)
SELECT
*
FROM
oc_product_to_layout
WHERE
product_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:453
50
(0.112)
SELECT
*
FROM
oc_layout_route
WHERE
'product/product' 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
51
(0.118)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
52
(0.079)
SELECT
*
FROM
oc_product_to_layout
WHERE
product_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:453
53
(0.111)
SELECT
*
FROM
oc_layout_route
WHERE
'product/product' 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
54
(0.117)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
55
(1.575)
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
56
(0.130)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
57
(0.079)
SELECT
*
FROM
oc_product_to_layout
WHERE
product_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:453
58
(0.116)
SELECT
*
FROM
oc_layout_route
WHERE
'product/product' 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
(1.064)
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
60
(0.256)
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
61
(0.960)
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
62
(0.242)
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
63
(1.016)
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
64
(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 = '62'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
65
(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 = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
66
(0.242)
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
67
(0.223)
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
68
(1.012)
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
69
(0.300)
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
70
(0.245)
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
71
(0.243)
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
72
(0.220)
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
73
(0.924)
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
74
(0.234)
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
75
(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
76
(0.213)
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
77
(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
78
(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
79
(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
80
(0.203)
SELECT
tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM
oc_tax_rule tr1
LEFT JOIN
oc_tax_rate tr2
ON
(tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN
oc_tax_rate_to_customer_group tr2cg
ON
(tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN
oc_zone_to_geo_zone z2gz
ON
(tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN
oc_geo_zone gz
ON
(tr2.geo_zone_id = gz.geo_zone_id)
WHERE
tr1.tax_class_id = '9'
AND
tr1.based = 'shipping'
AND
tr2cg.customer_group_id = '1'
AND
z2gz.country_id = '206'
AND
(z2gz.zone_id = '0'
OR
z2gz.zone_id = '3159')
ORDER BY
tr1.priority
ASC
/opt/lampp/htdocs_vsite/cart/jouet/system/library/tax.php:91
81
(0.197)
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
82
(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
83
(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
84
(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
85
(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
86
(0.707)
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
87
(1.165)
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
88
(0.987)
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
89
(1.030)
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
90
(0.279)
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
91
(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 = '63'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:579
92
(0.244)
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
93
(1.010)
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
94
(0.297)
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
95
(0.244)
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
96
(0.242)
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
97
(0.926)
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
98
(0.076)
SELECT
*
FROM
oc_product_to_layout
WHERE
product_id = '61'
AND
store_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/catalog/product.php:453
99
(0.118)
SELECT
*
FROM
oc_layout_route
WHERE
'product/product' 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
100
(0.111)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'module'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
101
(0.105)
SELECT
*
FROM
oc_extension
WHERE
`type` = 'total'
/opt/lampp/htdocs_vsite/cart/jouet/catalog/model/setting/extension.php:4
102
(0.305)
SELECT
SUM(amount)
AS
total
FROM
oc_customer_transaction
WHERE
customer_id = '0'
/opt/lampp/htdocs_vsite/cart/jouet/system/library/customer.php:157