| 0.0059 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('754d75112e116e5318262ff120b9c219', '216.73.217.35', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1779471034, '')
|
| 0.0025 |
UPDATE `ci_sessions` SET `last_activity` = 1779471034, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";}' WHERE `session_id` = '754d75112e116e5318262ff120b9c219'
|
| 0.0009 |
SELECT *
FROM (`site_settings`)
|
| 0.0006 |
UPDATE `ci_sessions` SET `last_activity` = 1779471034, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";}' WHERE `session_id` = '754d75112e116e5318262ff120b9c219'
|
| 0.0012 |
SELECT *
FROM (`restaurents` rst)
WHERE `rst`.`subdomain` = 'chapterone'
|
| 0.0007 |
SELECT *
FROM (`restaurent_voucher_templates`)
WHERE `restaurent_id` = '3275'
|
| 0.0004 |
SELECT *
FROM (`currency`)
WHERE `id` = '2'
|
| 0.0008 |
SELECT *
FROM (`acl`)
INNER JOIN `acos` ON `acos`.`id` = `acl`.`aco_id`
WHERE `acl`.`role_id` = 3
AND `acos`.`method` = 'product'
AND `acos`.`class` = 'newstorefront'
|
| 0.0023 |
UPDATE `ci_sessions` SET `last_activity` = 1779471034, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";s:8:\"li_token\";s:32:\"9830b0704d6cb3932389bf71ceb5d9bf\";}' WHERE `session_id` = '754d75112e116e5318262ff120b9c219'
|
| 0.0004 |
UPDATE `ci_sessions` SET `last_activity` = 1779471034, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:2:\"en\";s:8:\"li_token\";s:32:\"9830b0704d6cb3932389bf71ceb5d9bf\";}' WHERE `session_id` = '754d75112e116e5318262ff120b9c219'
|
| 0.0011 |
SELECT *
FROM (`discounts`)
WHERE `restaurant_id` = '3275'
AND `status` = 1
|
| 0.0008 |
SELECT `id`, `name`, `slots`, `description`, `ori_price`, `price`, `purchase_price`, `header_img`, `terms`, `product_visibility_type`, `visibility_start_date`, `visibility_end_date`, `is_required_phone_number`, `is_required_gift_message`, `expiry_at`, `expires_month`, `is_offer`, `image`, `template_id`, `custom_template`, `product_type`, `price_values`, `valid_from_date_type`, `valid_from`, `valid_days_count`, `display_timer`, `custom_sidebar`, `custom_sidebar_text`, `product_visibility`, `storefront_preview`, `use_test_card`, `test_card_disable_time`, `expires_month`, `is_print`, `is_email`, `is_postal`, `is_scheduled_email`, `is_collect`, `is_card`, `is_additional_method`, `preparation_time`, `discount_mode_enable`, `is_monetary_voucher`, `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_event`, `is_giveaway`, `is_competition`, `is_bundle`, `datetime_event`, `contact_email`, `is_category`, `badge`, `badge_position`, `store_design`, `enable_store_design`, `minimum_amount`, `maximum_amount`, `gift_message_limit`, `dates_excluded`, `redemption_rules`
FROM (`products` p)
WHERE `restaurent_id` = '3275'
AND `id` = '12051'
AND `is_bonus` = 0
AND `status` = 1
ORDER BY `p`.`id` DESC
LIMIT 1
|
| 0.0022 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` = '12051'
|
| 0.0610 |
SELECT COUNT(*) AS `numrows`
FROM (`vouchers`)
WHERE `product_id` = '12051'
|
| 0.0010 |
SELECT SUM(t.vouchers_quantity) as quantity
FROM (`bundle_product_lines` b)
JOIN `transactions` t ON `t`.`id` = `b`.`transaction_id`
WHERE `b`.`product_id` = '12051'
AND `b`.`status` = 0
|
| 0.0006 |
SELECT `u`.*
FROM (`plan_master` u)
WHERE `id` = '2'
ORDER BY `u`.`id` DESC
|
| 0.0010 |
SELECT `p`.`id`, `p`.`sort`, `p`.`name`, `p`.`description`, `p`.`ori_price`, `p`.`price`, `p`.`slots`, `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`, `datetime_event`
FROM (`products` p)
WHERE `p`.`name` != 'External Import Product'
AND `p`.`restaurent_id` = '3275'
AND `p`.`status` = 1
AND `p`.`is_bonus` = 0
AND `p`.`competition_closed` = 0
ORDER BY `p`.`sort` DESC
LIMIT 100
|
| 0.0006 |
SELECT `g`.*, `gm`.`member_res_id`, `gm`.`import_products`, `gm`.`master_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` = '3275'
AND `gm`.`status` != 2
AND `gm`.`request_status` = 1
|
| 0.0010 |
SELECT *
FROM (`bonus_products`)
WHERE `product_id` IN ('13353', '13346', '12051')
AND `bonus_product_id` != 0
|
| 0.0076 |
SELECT *
FROM (`product_categories`)
WHERE `product_id` IN ('13353', '13346', '12051')
|
| 0.0066 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13353'
|
| 0.0005 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6648')
|
| 0.0672 |
SELECT COUNT(*) AS `numrows`
FROM (`vouchers`)
WHERE `product_id` = '13353'
|
| 0.0007 |
SELECT SUM(t.vouchers_quantity) as quantity
FROM (`bundle_product_lines` b)
JOIN `transactions` t ON `t`.`id` = `b`.`transaction_id`
WHERE `b`.`product_id` = '13353'
AND `b`.`status` = 0
|
| 0.0091 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '13346'
|
| 0.0005 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6648')
|
| 0.0728 |
SELECT COUNT(*) AS `numrows`
FROM (`vouchers`)
WHERE `product_id` = '13346'
|
| 0.0008 |
SELECT SUM(t.vouchers_quantity) as quantity
FROM (`bundle_product_lines` b)
JOIN `transactions` t ON `t`.`id` = `b`.`transaction_id`
WHERE `b`.`product_id` = '13346'
AND `b`.`status` = 0
|
| 0.0065 |
SELECT `cat`.`category_id`
FROM (`products` p)
JOIN `product_categories` cat ON `p`.`id` = `cat`.`product_id`
WHERE `p`.`id` = '12051'
|
| 0.0004 |
SELECT `c`.`name`
FROM (`categories` c)
WHERE `id` IN ('6648')
|
| 0.0335 |
SELECT COUNT(*) AS `numrows`
FROM (`vouchers`)
WHERE `product_id` = '12051'
|
| 0.0006 |
SELECT SUM(t.vouchers_quantity) as quantity
FROM (`bundle_product_lines` b)
JOIN `transactions` t ON `t`.`id` = `b`.`transaction_id`
WHERE `b`.`product_id` = '12051'
AND `b`.`status` = 0
|
| 0.0004 |
SELECT *
FROM (`categories`)
WHERE `id` IN ('6648', '6648', '6648')
AND `restaurent_id` IN ('3275')
ORDER BY `id` desc
|
| 0.0006 |
(SELECT `nav`.`id` as item_id, `nav`.`restaurant_id` as res_id, `nav`.`title` as name, `nav`.`url`, `nav`.`sort`, "custom_action" as type_table FROM (`quick_actions` nav) WHERE `nav`.`restaurant_id` = 3275 AND `nav`.`is_deleted` = 0 ) ORDER BY sort DESC
|
| 0.0004 |
SELECT *
FROM (`navbar_custom_links`)
WHERE `restaurant_id` = '3275'
AND `is_deleted` = 0
ORDER BY `sort` DESC
|
| 0.0004 |
SELECT *
FROM (`site_settings`)
WHERE `field` = 'delivery_management'
|
| 0.0003 |
SELECT *
FROM (`site_settings`)
WHERE `field` = 'tickets_terms_conditions'
|
| 0.0003 |
SELECT *
FROM (`site_settings`)
WHERE `field` = 'store_trms_condi'
|
| 0.0003 |
SELECT *
FROM (`collection_locations`)
WHERE `store_id` = '3275'
|
| 0.0005 |
SELECT *
FROM (`restaurent_voucher_templates`)
WHERE `restaurent_id` = '3275'
|
| 0.0004 |
SELECT *
FROM (`additional_purchase_details`)
WHERE `restaurent_id` = '3275'
|
| 0.0005 |
SELECT *
FROM (`countries`)
WHERE `code` = 'IE'
|
| 0.0005 |
SELECT `i`.*
FROM (`integrations` i)
WHERE `name` = 'ga'
AND `i`.`restaurent_id` = '3275'
ORDER BY `i`.`name` ASC
|
| 0.0004 |
SELECT `i`.*
FROM (`integrations` i)
WHERE `name` = 'fb'
AND `i`.`restaurent_id` = '3275'
ORDER BY `i`.`name` ASC
|
| 0.0008 |
SELECT *
FROM (`competition_product`)
WHERE `product_id` = '12051'
|
| 0.0007 |
SELECT *
FROM (`competition_product`)
WHERE `product_id` = '12051'
|
| 0.0006 |
SELECT *
FROM (`currency`)
WHERE `id` = 2
|
