All (47)
Debug (47)
1. Fbck_Db::query : 86 lines in 1ms
SQL : SELECT * FROM site__campaign WHERE site__campaign.site_id='1'
2. Fbck_Db::query : 44 lines in 1ms
SQL : SELECT ref_fr ref, title_fr title, text_fr text, section_ref FROM site__info WHERE
site__info.site_id='1' ORDER BY RAND() asc
3. Fbck_Db::query : 25 lines in 0ms
SQL : SELECT value, name FROM site__setting WHERE site__setting.site_id='1'
4. Fbck_Db::query : 1 line in 0ms
SQL : SELECT value, code FROM site__incentive WHERE site__incentive.site_id='1' AND
site__incentive.published='1'
5. Fbck_Db::query : 1 line in 0ms
SQL : SELECT value, id FROM site__setting WHERE site__setting.name='event_cat' AND
site__setting.site_id='1' LIMIT 1
6. Fbck_Db::query : 0 line in 1ms
SQL : SELECT meta__merchant.*, site__site_merchant.*, meta__program.fixed_max, meta__program.fixed_min,
meta__program.variable_max, meta__program.variable_min, site_ck__current_offers.* FROM
meta__merchant LEFT JOIN site__site_merchant ON site__site_merchant.merchant_id=meta__merchant.id
LEFT JOIN meta__program ON meta__merchant.program_id=meta__program.id LEFT JOIN
site_ck__current_offers ON site_ck__current_offers.merchant_id=meta__merchant.id WHERE
meta__merchant.is_offline='0' AND site__site_merchant.published='1' AND
site_ck__current_offers.menu='1' AND site__site_merchant.site_id='1' AND
site_ck__current_offers.published_from<'2019-12-07 22:16:36' AND
site_ck__current_offers.published_to>'2019-12-07 22:16:36' AND
site_ck__current_offers.category_id='1' ORDER BY site_ck__current_offers.position asc, RAND() asc
LIMIT 8
7. Fbck_Db::query : 0 line in 1ms
SQL : SELECT meta__merchant.*, site__site_merchant.*, meta__program.fixed_max, meta__program.fixed_min,
meta__program.variable_max, meta__program.variable_min, site_ck__current_offers.* FROM
meta__merchant LEFT JOIN site__site_merchant ON site__site_merchant.merchant_id=meta__merchant.id
LEFT JOIN meta__program ON meta__merchant.program_id=meta__program.id LEFT JOIN
site_ck__current_offers ON site_ck__current_offers.merchant_id=meta__merchant.id WHERE
meta__merchant.is_offline='0' AND site__site_merchant.published='1' AND
site_ck__current_offers.odm='1' AND site_ck__current_offers.menu='0' AND
site__site_merchant.site_id='1' AND site_ck__current_offers.published_from<'2019-12-07 22:16:36' AND
site_ck__current_offers.published_to>'2019-12-07 22:16:36' AND
site_ck__current_offers.category_id='1' ORDER BY site_ck__current_offers.position asc, RAND() asc
LIMIT 8
8. Fbck_Db::query : 30 lines in 2ms
SQL : SELECT meta__merchant.*, meta__program.fixed_max, meta__program.fixed_min,
meta__program.variable_max, meta__program.variable_min, site__site_merchant.* FROM meta__merchant
LEFT JOIN meta__program ON meta__merchant.program_id=meta__program.id LEFT JOIN site__site_merchant
ON site__site_merchant.merchant_id=meta__merchant.id WHERE meta__merchant.top_category_id='1' AND
meta__merchant.is_offline='0' AND site__site_merchant.published='1' AND
site__site_merchant.site_id='1' ORDER BY RAND() asc
9. Fbck_Db::query : 1 line in 0ms
SQL : SELECT value, id FROM site__setting WHERE site__setting.name='cashback_increase_length_in_days' AND
site__setting.site_id='1' LIMIT 1
10. Fbck_Db::query : 114 lines in 10ms
SQL : SELECT meta__merchant.*, meta__program.fixed_max, meta__program.fixed_min,
meta__program.variable_max, meta__program.variable_min, site__site_merchant.* FROM meta__merchant
LEFT JOIN meta__program ON meta__merchant.program_id=meta__program.id LEFT JOIN site__site_merchant
ON site__site_merchant.merchant_id=meta__merchant.id WHERE
site__site_merchant.published_in_cashback_increase='1' AND
site__site_merchant.cashback_increased_on>'2019-08-29' AND meta__merchant.is_offline='0' AND
site__site_merchant.published='1' AND site__site_merchant.site_id='1' ORDER BY RAND() desc
11. Fbck_Db::query : 6 lines in 1ms
SQL : SELECT meta__merchant.*, site__site_merchant.*, meta__program.fixed_max, meta__program.fixed_min,
meta__program.variable_max, meta__program.variable_min FROM meta__merchant LEFT JOIN
site__site_merchant ON site__site_merchant.merchant_id=meta__merchant.id LEFT JOIN meta__program ON
meta__merchant.program_id=meta__program.id WHERE meta__merchant.is_offline='0' AND
site__site_merchant.published='1' AND site__site_merchant.site_id='1' AND
meta__merchant.top_category_id='1' ORDER BY RAND() asc LIMIT 6
12. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
13. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
14. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
15. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
16. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
17. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
18. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
19. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
20. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
21. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
22. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
23. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
24. Fbck_Db::query : 81 lines in 1ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
25. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
26. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
27. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
28. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
29. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
30. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
31. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
32. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
33. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
34. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
35. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
36. Fbck_Db::query : 81 lines in 0ms
SQL : SELECT id, ref_fr ref, title_fr title, icon, image, menu_image, evenement FROM meta__category ORDER
BY meta__category.title_fr asc
37. Fbck_Db::query : 79 lines in 0ms
SQL : SELECT * FROM meta__category_category
38. Fbck_Db::query : 1 line in 0ms
SQL : SELECT meta__merchant.*, site__site_merchant.*, site__site_program.tracking_url,
meta__program.variable_min, meta__program.variable_max, meta__program.fixed_min,
meta__program.fixed_max, meta__program.platform_program_ref FROM meta__merchant LEFT JOIN
site__site_merchant ON site__site_merchant.merchant_id=meta__merchant.id LEFT JOIN
site__site_program ON site__site_program.program_id=meta__merchant.program_id LEFT JOIN
meta__program ON meta__merchant.program_id=meta__program.id WHERE meta__merchant.ref='auchan-drive'
AND site__site_merchant.published='1' AND site__site_merchant.site_id='1' AND
site__site_program.site_id='1' LIMIT 1
39. Fbck_Db::query : 0 line in 5ms
SQL : SELECT meta__merchant.*, site__site_merchant.*, site__site_program.tracking_url,
meta__program.variable_min, meta__program.variable_max, meta__program.fixed_min,
meta__program.fixed_max, meta__program.platform_program_ref FROM meta__merchant LEFT JOIN
site__site_merchant ON site__site_merchant.merchant_id=meta__merchant.id LEFT JOIN
site__site_program ON site__site_program.program_id=meta__merchant.program_id LEFT JOIN
meta__program ON meta__merchant.program_id=meta__program.id WHERE
meta__merchant.merchant_online_id='2372' AND site__site_merchant.published='1' AND
site__site_merchant.site_id='1' LIMIT 1
40. Fbck_Db::query : 1 line in 1ms
SQL : SELECT meta__category_merchant.category_id, meta__category.ref_fr, meta__category.title_fr FROM
meta__category_merchant LEFT JOIN meta__category ON
meta__category.id=meta__category_merchant.category_id WHERE
meta__category_merchant.merchant_id='2372' ORDER BY meta__category.title_fr asc
41. Fbck_Db::query : 1 line in 0ms
SQL : SELECT meta__promotion.title_fr title, meta__promotion.short_title, meta__promotion.expired_on,
meta__promotion.expired_on_disabled, meta__promotion.promotional_code, meta__promotion.conditions,
meta__promotion.published_on, meta__promotion.category, meta__promotion.tracking_enabled,
meta__promotion.tracking_spec_url, meta__promotion.id, site__site_promotion.* FROM meta__promotion
LEFT JOIN site__site_promotion ON site__site_promotion.promotion_id=meta__promotion.id WHERE
site__site_promotion.published='1' AND site__site_promotion.site_id='1' AND
meta__promotion.merchant_id='2372' AND ((meta__promotion.published_on<='2019-12-07 22:16:37') OR
(meta__promotion.published_on IS NULL)) AND ((meta__promotion.expired_on>'2019-12-07 22:16:37') OR
(meta__promotion.expired_on IS NULL))
42. Fbck_Db::query : 1 line in 1ms
SQL : SELECT meta__merchant.*, meta__domainset.name, meta__domainset_domain.domain FROM meta__merchant
LEFT JOIN meta__domainset ON meta__domainset.id=meta__merchant.domainset_id LEFT JOIN
meta__domainset_domain ON meta__domainset_domain.domainset_id=meta__domainset.id WHERE
meta__merchant.id='2372' LIMIT 1
43. Fbck_Db::query : 0 line in 0ms
SQL : SELECT * FROM site__member_merchant WHERE site__member_merchant.member_id='0' AND
site__member_merchant.merchant_id='2372'
44. Fbck_Db::query : 1 line in 0ms
SQL : SELECT value, id FROM site__setting WHERE site__setting.name='cashback_increase_length_in_days' AND
site__setting.site_id='1' LIMIT 1
45. Fbck_Db::query : 114 lines in 11ms
SQL : SELECT meta__merchant.*, meta__program.fixed_max, meta__program.fixed_min,
meta__program.variable_max, meta__program.variable_min, site__site_merchant.* FROM meta__merchant
LEFT JOIN meta__program ON meta__merchant.program_id=meta__program.id LEFT JOIN site__site_merchant
ON site__site_merchant.merchant_id=meta__merchant.id WHERE
site__site_merchant.published_in_cashback_increase='1' AND
site__site_merchant.cashback_increased_on>'2019-08-29' AND meta__merchant.is_offline='0' AND
site__site_merchant.published='1' AND site__site_merchant.site_id='1' ORDER BY meta__merchant.name
asc
46. Fbck_Db::query : 1 line in 0ms
SQL : SELECT value, id FROM site__setting WHERE site__setting.name='cashback_increase_length_in_days' AND
site__setting.site_id='1' LIMIT 1
47. Fbck_Db::query : 114 lines in 6ms
SQL : SELECT meta__merchant.*, meta__program.fixed_max, meta__program.fixed_min,
meta__program.variable_max, meta__program.variable_min, site__site_merchant.* FROM meta__merchant
LEFT JOIN meta__program ON meta__merchant.program_id=meta__program.id LEFT JOIN site__site_merchant
ON site__site_merchant.merchant_id=meta__merchant.id WHERE
site__site_merchant.published_in_cashback_increase='1' AND
site__site_merchant.cashback_increased_on>'2019-08-29' AND meta__merchant.is_offline='0' AND
site__site_merchant.published='1' AND site__site_merchant.site_id='1' ORDER BY
site__site_merchant.cashback_increased_on desc