| 0.0039 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('752d66364541f59477a7a741a9f09c19', '216.73.216.161', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1749982328, '')
|
| 0.0012 |
UPDATE `ci_sessions` SET `last_activity` = 1749982328, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";}' WHERE `session_id` = '752d66364541f59477a7a741a9f09c19'
|
| 0.0008 |
SELECT *
FROM (`site_settings`)
|
| 0.0006 |
UPDATE `ci_sessions` SET `last_activity` = 1749982328, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";}' WHERE `session_id` = '752d66364541f59477a7a741a9f09c19'
|
| 0.0010 |
SELECT *
FROM (`restaurents` rst)
WHERE `rst`.`subdomain` = 'webdevelopment'
|
| 0.0006 |
SELECT *
FROM (`restaurent_voucher_templates`)
WHERE `restaurent_id` = '2643'
|
| 0.0004 |
SELECT *
FROM (`currency`)
WHERE `id` = '2'
|
| 0.0010 |
SELECT *
FROM (`acl`)
INNER JOIN `acos` ON `acos`.`id` = `acl`.`aco_id`
WHERE `acl`.`role_id` = 3
AND `acos`.`method` = 'index'
AND `acos`.`class` = 'newstorefront'
|
| 0.0013 |
UPDATE `ci_sessions` SET `last_activity` = 1749982328, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";s:8:\"li_token\";s:32:\"82433f33a55d57242027a5a5019d2ea6\";}' WHERE `session_id` = '752d66364541f59477a7a741a9f09c19'
|
| 0.0077 |
SELECT `p`.`id`, `p`.`sort`, `p`.`name`, `p`.`description`, `p`.`ori_price`, `p`.`price`, `p`.`product_visibility_type`, `p`.`purchase_price`, `p`.`header_img`, `p`.`is_offer`, `p`.`image`, `p`.`product_type`, `p`.`price_values`, `p`.`is_featured`, `p`.`visibility_start_date`, `p`.`visibility_end_date`, `p`.`product_visibility`, `p`.`expiry_at`, `p`.`expires_month`, `p`.`storefront_preview`, `p`.`is_monetary_voucher`, `discount_mode_enable`, `discount_percentage`, `scheduler_discount_mode_enable`, `discount_enable_at`, `discount_disable_at`, `bonus_mode_enable`, `bonus_percentage`, `scheduler_bonus_mode_enable`, `bonus_enable_at`, `bonus_disable_at`, `is_category`, `is_custom`, `button_text`, `button_link`, `badge`, `badge_position`, `is_event`, `is_giveaway`, `is_competition`, `is_bundle`, `code`
FROM (`products` p)
WHERE `p`.`name` != 'External Import Product'
AND `p`.`restaurent_id` = '2643'
AND `p`.`status` = 1
AND `p`.`is_bonus` = 0
ORDER BY `p`.`sort` DESC
LIMIT 50
|
| 0.0011 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` IN ('13226', '13221', '13215', '13213', '13212', '13161', '13160', '13152', '13207', '13211', '9484', '13205', '13204', '13203', '13199', '13180', '13179', '13178', '13143', '12774', '12907', '13175', '13216', '13217', '13219', '13222', '13223', '13224', '13225')
AND `bonus_product_id` != 0
|
| 0.0078 |
SELECT *
FROM (`product_categories`)
WHERE `product_id` IN ('13226', '13221', '13215', '13213', '13212', '13161', '13160', '13152', '13207', '13211', '9484', '13205', '13204', '13203', '13199', '13180', '13179', '13178', '13143', '12774', '12907', '13175', '13216', '13217', '13219', '13222', '13223', '13224', '13225')
|
| 0.0121 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13226'
|
| 0.0005 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6743')
|
| 0.0209 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13221'
|
| 0.0079 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13215'
|
| 0.0145 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13213'
|
| 0.0007 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6744')
|
| 0.0078 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13212'
|
| 0.0038 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6744')
|
| 0.0091 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13161'
|
| 0.0005 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0145 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13160'
|
| 0.0007 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0075 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13152'
|
| 0.0165 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0077 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13207'
|
| 0.0131 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6744', '6744')
|
| 0.0076 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13211'
|
| 0.0018 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6743')
|
| 0.0124 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '9484'
|
| 0.0068 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0077 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13205'
|
| 0.0068 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0079 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13204'
|
| 0.0040 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0075 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13203'
|
| 0.0006 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0123 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13199'
|
| 0.0062 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0081 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13180'
|
| 0.0159 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13179'
|
| 0.0016 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0185 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13178'
|
| 0.0094 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6732')
|
| 0.0070 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13143'
|
| 0.0008 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13143'
|
| 0.0086 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '12774'
|
| 0.0048 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '12774'
|
| 0.0079 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '12907'
|
| 0.0013 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '12907'
|
| 0.0078 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13175'
|
| 0.0009 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13175'
|
| 0.0224 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13216'
|
| 0.0134 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13216'
|
| 0.0082 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13217'
|
| 0.0013 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13217'
|
| 0.0079 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13219'
|
| 0.0101 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13219'
|
| 0.0080 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13222'
|
| 0.0051 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13222'
|
| 0.0077 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13223'
|
| 0.0099 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13223'
|
| 0.0082 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13224'
|
| 0.0094 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13224'
|
| 0.0078 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13225'
|
| 0.0012 |
SELECT *
FROM (`product_giveaway_details`)
WHERE `product_id` = '13225'
|
| 0.0010 |
SELECT `g`.*, `gm`.`member_res_id`, `gm`.`import_products`, `gm`.`id` as group_member_id
FROM (`group` g)
JOIN `group_members` gm ON `gm`.`group_id`=`g`.`id`
JOIN `restaurents` r ON `r`.`id` = `g`.`master_res_id`
WHERE `gm`.`member_res_id` = '2643'
AND `gm`.`status` != 2
AND `gm`.`request_status` = 1
|
| 0.0006 |
SELECT *
FROM (`categories`)
WHERE `id` IN ('6732', '6732', '6732', '6743', '6732', '6744', '6744', '6743', '6732', '6744', '6744', '6732', '6732', '6732', '6732', '6732')
AND `restaurent_id` = '2643'
ORDER BY `id` desc
|
| 0.0008 |
SELECT *
FROM (`navbar_custom_links`)
WHERE `restaurant_id` = '2643'
AND `is_deleted` = 0
ORDER BY `sort` DESC
|
| 0.0012 |
UPDATE `ci_sessions` SET `last_activity` = 1749982328, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";s:8:\"li_token\";s:32:\"82433f33a55d57242027a5a5019d2ea6\";s:12:\"query_params\";b:0;}' WHERE `session_id` = '752d66364541f59477a7a741a9f09c19'
|
| 0.0007 |
SELECT *
FROM (`countries`)
WHERE `code` = 'IE'
|
| 0.0006 |
SELECT `i`.*
FROM (`integrations` i)
WHERE `name` = 'ga'
AND `i`.`restaurent_id` = '2643'
ORDER BY `i`.`name` ASC
|
| 0.0006 |
SELECT `i`.*
FROM (`integrations` i)
WHERE `name` = 'fb'
AND `i`.`restaurent_id` = '2643'
ORDER BY `i`.`name` ASC
|
| 0.0011 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13215'
|
| 0.0009 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13221'
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13213'
|
| 0.0083 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13212'
|
| 0.0111 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13161'
|
| 0.0011 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13160'
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13211'
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '9484'
|
| 0.0009 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13205'
|
| 0.0012 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13204'
|
| 0.0009 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13203'
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13180'
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13179'
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13178'
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '12774'
|
| 0.0008 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13175'
|
| 0.0008 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13216'
|
| 0.0009 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '13217'
|
| 0.0005 |
SELECT *
FROM (`currency`)
WHERE `id` = 2
|
