Affiliate Program

Queries: 82, Total time: 66.200 ms [By time] [By id] [By file]

1 (0.216)

SELECT `data`
FROM `oc_session`
WHERE session_id = '3ca792f6f02eebe9d48c8c109a' AND expire > 1732625403

/home/secretnamaatest/public_html/system/library/session/db.php:21

2 (0.066)

SELECT *
FROM oc_extension
WHERE `type` = 'openbay'

/home/secretnamaatest/public_html/system/library/openbay.php:61

3 (0.064)

SELECT *
FROM oc_extension
WHERE `type` = 'openbay'

/home/secretnamaatest/public_html/system/library/openbay.php:61

4 (0.103)

SELECT `data`
FROM `oc_session`
WHERE session_id = '332be576f3d01debf92f1333e4' AND expire > 1732625403

/home/secretnamaatest/public_html/system/library/session/db.php:21

5 (1.043)

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://baladnashop.com/'

/home/secretnamaatest/public_html/catalog/controller/startup/startup.php:6

6 (0.645)

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

/home/secretnamaatest/public_html/catalog/controller/startup/startup.php:25

7 (0.059)

SELECT *
FROM oc_customer_group
WHERE customer_group_id = '1'

/home/secretnamaatest/public_html/system/library/cart/customer.php:76

8 (0.057)

SELECT *
FROM oc_currency

/home/secretnamaatest/storage/modification/system/library/cart/currency.php:10

9 (0.091)

SELECT tr.tax_rate_id, tr.name AS name, tr.rate, tr.type, gz.name AS geo_zone, tr.date_added, tr.date_modified
FROM oc_tax_rate tr
LEFT JOIN oc_geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id)
ORDER BY tr.name ASC

/home/secretnamaatest/public_html/system/library/cart/tax.php:272

10 (0.056)

SELECT tr1.tax_class_id, 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.based = 'store' AND tr2cg.customer_group_id = '6' AND z2gz.country_id = '81' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1263')
ORDER BY tr1.priority ASC

/home/secretnamaatest/public_html/system/library/cart/tax.php:101

11 (0.056)

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 = '1'

/home/secretnamaatest/public_html/system/library/cart/weight.php:10

12 (0.057)

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 = '1'

/home/secretnamaatest/public_html/system/library/cart/length.php:10

13 (57.146)

DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

/home/secretnamaatest/public_html/system/library/cart/cart.php:14

14 (0.140)

SELECT *
FROM oc_extension
WHERE `type` = 'openbay'

/home/secretnamaatest/public_html/system/library/openbay.php:61

15 (0.149)

SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC

/home/secretnamaatest/public_html/catalog/model/setting/event.php:4

16 (0.680)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

17 (0.194)

SELECT *
FROM oc_customer_group cg
LEFT JOIN oc_customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id)
WHERE cgd.language_id = '1'
ORDER BY cg.sort_order ASC, cgd.name ASC

/home/secretnamaatest/public_html/catalog/model/account/customer_group.php:18

18 (0.265)

SELECT *
FROM `oc_custom_field` cf
LEFT JOIN `oc_custom_field_description` cfd ON (cf.custom_field_id = cfd.custom_field_id)
WHERE cf.status = '1' AND cfd.language_id = '1' AND cf.status = '1'
ORDER BY cf.sort_order ASC

/home/secretnamaatest/public_html/catalog/model/account/custom_field.php:13

19 (0.151)

SELECT *
FROM oc_custom_field_value cfv
LEFT JOIN oc_custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id)
WHERE cfv.custom_field_id = '28' AND cfvd.language_id = '1'
ORDER BY cfv.sort_order ASC

/home/secretnamaatest/public_html/catalog/model/account/custom_field.php:22

20 (0.096)

SELECT *
FROM oc_custom_field_value cfv
LEFT JOIN oc_custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id)
WHERE cfv.custom_field_id = '23' AND cfvd.language_id = '1'
ORDER BY cfv.sort_order ASC

/home/secretnamaatest/public_html/catalog/model/account/custom_field.php:22

21 (0.156)

SELECT *
FROM oc_custom_field_value cfv
LEFT JOIN oc_custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id)
WHERE cfv.custom_field_id = '26' AND cfvd.language_id = '1'
ORDER BY cfv.sort_order ASC

/home/secretnamaatest/public_html/catalog/model/account/custom_field.php:22

22 (0.122)

SELECT *
FROM oc_custom_field_value cfv
LEFT JOIN oc_custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id)
WHERE cfv.custom_field_id = '11' AND cfvd.language_id = '1'
ORDER BY cfv.sort_order ASC

/home/secretnamaatest/public_html/catalog/model/account/custom_field.php:22

23 (0.129)

SELECT *
FROM oc_custom_field_value cfv
LEFT JOIN oc_custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id)
WHERE cfv.custom_field_id = '38' AND cfvd.language_id = '1'
ORDER BY cfv.sort_order ASC

/home/secretnamaatest/public_html/catalog/model/account/custom_field.php:22

24 (0.120)

SELECT *
FROM oc_custom_field_value cfv
LEFT JOIN oc_custom_field_value_description cfvd ON (cfv.custom_field_value_id = cfvd.custom_field_value_id)
WHERE cfv.custom_field_id = '27' AND cfvd.language_id = '1'
ORDER BY cfv.sort_order ASC

/home/secretnamaatest/public_html/catalog/model/account/custom_field.php:22

25 (0.143)

SELECT DISTINCT *
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 i.information_id = '5' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

/home/secretnamaatest/public_html/catalog/model/catalog/information.php:4

26 (0.133)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

27 (0.134)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'column_left'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

28 (0.134)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/column_left'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

29 (0.053)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

30 (0.051)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'column_right'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

31 (0.057)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/column_right'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

32 (0.051)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

33 (0.050)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'content_top'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

34 (0.050)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/content_top'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

35 (0.051)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

36 (0.060)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'content_bottom'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

37 (0.049)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/content_bottom'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

38 (0.216)

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 = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

/home/secretnamaatest/public_html/catalog/model/catalog/information.php:10

39 (0.051)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

40 (0.048)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'block2'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

41 (0.050)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/block2'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

42 (0.050)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

43 (0.050)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'block3'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

44 (0.051)

SELECT *
FROM oc_module
WHERE module_id = '74'

/home/secretnamaatest/public_html/catalog/model/setting/module.php:4

45 (0.051)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'extension/module/newslettersubscribe'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

46 (0.052)

SELECT *
FROM oc_module
WHERE module_id = '44'

/home/secretnamaatest/public_html/catalog/model/setting/module.php:4

47 (0.070)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/block3'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

48 (0.215)

DELETE
FROM `oc_customer_online`
WHERE date_added < '2024-11-26 11:50:03'

/home/secretnamaatest/public_html/catalog/model/tool/online.php:4

49 (0.105)

REPLACE INTO `oc_customer_online` SET `ip` = '172.71.195.56', `customer_id` = '0', `url` = 'https://baladnashop.com/index.php?route=affiliate%2Fregister', `referer` = '', `date_added` = '2024-11-26 12:50:03'

/home/secretnamaatest/public_html/catalog/model/tool/online.php:6

50 (0.054)

SELECT phone
FROM oc_customer_group
WHERE customer_group_id = '1'

/home/secretnamaatest/public_html/catalog/model/account/customer_group.php:36

51 (0.052)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/footer'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

52 (0.053)

SELECT logo
FROM oc_customer_group
WHERE customer_group_id = '1'

/home/secretnamaatest/public_html/catalog/model/account/customer_group.php:24

53 (0.146)

SELECT *
FROM oc_offer_timer o
LEFT JOIN oc_offer_timer_description od ON (o.offer_timer_id = od.offer_timer_id)
WHERE od.language_id = '1' AND o.customer_group_id = '1' AND (o.date_start > adddate(now(),-1)) AND o.status = '1'

/home/secretnamaatest/public_html/catalog/model/offertimer/offertimer.php:13

54 (0.056)

SELECT *
FROM oc_extension
WHERE `type` = 'analytics'

/home/secretnamaatest/public_html/catalog/model/setting/extension.php:4

55 (0.345)

/home/secretnamaatest/public_html/catalog/model/catalog/information.php:10

56 (0.021)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

57 (0.019)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/language'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

58 (0.019)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/currency'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

59 (0.052)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/search'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

60 (0.055)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

61 (0.054)

SELECT *
FROM oc_extension
WHERE `type` = 'total'

/home/secretnamaatest/public_html/catalog/model/setting/extension.php:4

62 (0.054)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

63 (0.055)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

64 (0.056)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

65 (0.059)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

66 (0.055)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

67 (0.052)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '332be576f3d01debf92f1333e4'
ORDER BY free_offer DESC , bundle DESC

/home/secretnamaatest/public_html/system/library/cart/cart.php:34

68 (0.044)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/cart'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

69 (0.049)

SELECT *
FROM oc_category
WHERE category_id = '0'

/home/secretnamaatest/public_html/catalog/model/catalog/category.php:37

70 (0.075)

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 c.category_class = 0 AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/home/secretnamaatest/public_html/catalog/model/catalog/category.php:60

71 (0.051)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/menu'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

72 (0.052)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

73 (0.050)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'block1'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

74 (0.058)

SELECT *
FROM oc_module
WHERE module_id = '53'

/home/secretnamaatest/public_html/catalog/model/setting/module.php:4

75 (0.052)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/block1'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

76 (0.050)

SELECT *
FROM oc_layout_route
WHERE 'affiliate/register' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/home/secretnamaatest/public_html/catalog/model/design/layout.php:4

77 (0.049)

SELECT *
FROM oc_layout_module
WHERE layout_id = '19' AND position = 'block2'
ORDER BY sort_order

/home/secretnamaatest/public_html/catalog/model/design/layout.php:14

78 (0.052)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/block2'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

79 (0.046)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'common/header'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

80 (0.146)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'extension/module/facebook_business'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

81 (0.118)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'affiliate/register_iframe'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

82 (0.163)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tt_organica6' AND route = 'affiliate/register'

/home/secretnamaatest/public_html/catalog/model/design/theme.php:4

Affiliate Program

Account information

Customer Group

Customer Group

Affiliate Information

The payment methode you want to riseve mony in

Create Account

Information

Main Sections

account information

PAYMENT METHOD

Get Our App

Shipping

Success!

Affiliate Program

Account information

Customer Group

Customer Group

Affiliate Information

The payment methode you want to riseve mony in

Create Account

Information

Main Sections

account information

PAYMENT METHOD

Get Our App

Shipping