| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `UserTrack`.`id`, `UserTrack`.`visitor_id`, `UserTrack`.`referral`, `UserTrack`.`url`, `UserTrack`.`order_id`, `UserTrack`.`order_type`, `UserTrack`.`user_id`, `UserTrack`.`headers`, `UserTrack`.`cart_json`, `UserTrack`.`ip`, `UserTrack`.`created`, `UserTrack`.`modified` FROM `stageshopcleft_stage`.`user_tracks` AS `UserTrack` WHERE `UserTrack`.`visitor_id` = 'i2dde8bed3f9bf99437cff9b1281dcd62330120' LIMIT 1 | 0 | 0 | 1 | maybe slow |
| BEGIN | | | | |
| INSERT INTO `stageshopcleft_stage`.`user_tracks` (`visitor_id`, `ip`, `referral`, `headers`, `url`, `order_id`, `user_id`, `order_type`, `cart_json`, `modified`, `created`) VALUES ('i2dde8bed3f9bf99437cff9b1281dcd62330120', '216.73.216.114', '/', '{\"USER\":\"stageshopcleft\",\"HOME\":\"\\/home\\/stageshopcleft\",\"SCRIPT_NAME\":\"\\/app\\/webroot\\/index.php\",\"REQUEST_URI\":\"\\/?carttype=shopping&ordertype=general\",\"QUERY_STRING\":\"carttype=shopping&ordertype=general\",\"REQUEST_METHOD\":\"GET\",\"SERVER_PROTOCOL\":\"HTTP\\/2.0\",\"GATEWAY_INTERFACE\":\"CGI\\/1.1\",\"REDIRECT_QUERY_STRING\":\"carttype=shopping&ordertype=general\",\"REDIRECT_URL\":\"\\/\",\"REMOTE_PORT\":\"44548\",\"SCRIPT_FILENAME\":\"\\/home\\/stageshopcleft\\/public_html\\/app\\/webroot\\/index.php\",\"SERVER_ADMIN\":\"webmaster@staging.cleftcoffee.com\",\"CONTEXT_DOCUMENT_ROOT\":\"\\/home\\/stageshopcleft\\/public_html\",\"CONTEXT_PREFIX\":\"\",\"REQUEST_SCHEME\":\"https\",\"DOCUMENT_ROOT\":\"\\/home\\/stageshopcleft\\/public_html\",\"REMOTE_ADDR\":\"216.73.216.114\",\"SERVER_PORT\":\"443\",\"SERVER_ADDR\":\"72.167.148.169\",\"SERVER_NAME\":\"staging.cleftcoffee.com\",\"SERVER_SOFTWARE\":\"Apache\",\"SERVER_SIGNATURE\":\"\",\"PATH\":\"\\/usr\\/local\\/jdk\\/bin:\\/usr\\/kerberos\\/sbin:\\/usr\\/kerberos\\/bin:\\/usr\\/local\\/sbin:\\/usr\\/local\\/bin:\\/sbin:\\/bin:\\/usr\\/sbin:\\/usr\\/bin:\\/usr\\/X11R6\\/bin:\\/usr\\/local\\/bin:\\/usr\\/X11R6\\/bin:\\/root\\/bin:\\/opt\\/bin\",\"HTTP_X_HTTPS\":\"1\",\"HTTP_HOST\":\"staging.cleftcoffee.com\",\"HTTP_ACCEPT_ENCODING\":\"gzip, br, zstd, deflate\",\"HTTP_USER_AGENT\":\"Mozilla\\/5.0 AppleWebKit\\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\\/1.0; +claudebot@anthropic.com)\",\"HTTP_ACCEPT\":\"*\\/*\",\"proxy-nokeepalive\":\"1\",\"H2_STREAM_TAG\":\"1167400-33-5\",\"H2_STREAM_ID\":\"5\",\"H2_PUSHED_ON\":\"\",\"H2_PUSHED\":\"\",\"H2_PUSH\":\"off\",\"H2PUSH\":\"off\",\"HTTP2\":\"on\",\"SSL_TLS_SNI\":\"staging.cleftcoffee.com\",\"HTTPS\":\"on\",\"HTTP_AUTHORIZATION\":\"\",\"SCRIPT_URI\":\"https:\\/\\/staging.cleftcoffee.com\\/\",\"SCRIPT_URL\":\"\\/\",\"UNIQUE_ID\":\"ahW6_5LwX13gYsJSvCGcKgABUwY\",\"REDIRECT_STATUS\":\"200\",\"REDIRECT_H2_STREAM_TAG\":\"1167400-33-5\",\"REDIRECT_H2_STREAM_ID\":\"5\",\"REDIRECT_H2_PUSHED_ON\":\"\",\"REDIRECT_H2_PUSHED\":\"\",\"REDIRECT_H2_PUSH\":\"off\",\"REDIRECT_H2PUSH\":\"off\",\"REDIRECT_HTTP2\":\"on\",\"REDIRECT_SSL_TLS_SNI\":\"staging.cleftcoffee.com\",\"REDIRECT_HTTPS\":\"on\",\"REDIRECT_SCRIPT_URI\":\"https:\\/\\/staging.cleftcoffee.com\\/\",\"REDIRECT_SCRIPT_URL\":\"\\/\",\"REDIRECT_UNIQUE_ID\":\"ahW6_5LwX13gYsJSvCGcKgABUwY\",\"FCGI_ROLE\":\"RESPONDER\",\"PHP_SELF\":\"\\/app\\/webroot\\/index.php\",\"REQUEST_TIME_FLOAT\":1779809023.9592640399932861328125,\"REQUEST_TIME\":1779809023,\"argv\":[\"carttype=shopping&ordertype=general\"],\"argc\":1}', '/?carttype=shopping&ordertype=general', NULL, NULL, 'general', NULL, '2026-05-26 15:23:44', '2026-05-26 15:23:44') | 1 | 1 | 0 | |
| COMMIT | | | | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`status`, `Category`.`created`, `Category`.`modified` FROM `stageshopcleft_stage`.`categories` AS `Category` WHERE `status` = 'active' | 6 | 6 | 0 | |
| SELECT `Coffee`.`id`, `Coffee`.`name`, `Coffee`.`description`, `Coffee`.`image`, `Coffee`.`cleft_favorites`, `Coffee`.`favorite_flavors`, `Coffee`.`manual_order`, `Coffee`.`shop_order`, `Coffee`.`slug`, `Coffee`.`views`, `Coffee`.`status`, `Coffee`.`created`, `Coffee`.`modified` FROM `stageshopcleft_stage`.`coffees` AS `Coffee` WHERE `cleft_favorites` = 1 | 7 | 7 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`image`, `Product`.`customized_price`, `Product`.`partner_price`, `Product`.`wholesale_price`, `Product`.`cleft_price`, `Product`.`price`, `Product`.`weight`, `Product`.`product_type`, `Product`.`coffee_id`, `Product`.`sku`, `Product`.`views`, `Product`.`active`, `Product`.`created`, `Product`.`modified` FROM `stageshopcleft_stage`.`products` AS `Product` WHERE `Product`.`active` = '1' AND `Product`.`coffee_id` IN (1, 2, 5, 6, 12, 16, 47) | 10 | 10 | 1 | maybe slow |
| SELECT `Coffee`.`id`, `Coffee`.`name`, `Coffee`.`description`, `Coffee`.`image`, `Coffee`.`cleft_favorites`, `Coffee`.`favorite_flavors`, `Coffee`.`manual_order`, `Coffee`.`shop_order`, `Coffee`.`slug`, `Coffee`.`views`, `Coffee`.`status`, `Coffee`.`created`, `Coffee`.`modified` FROM `stageshopcleft_stage`.`coffees` AS `Coffee` WHERE `favorite_flavors` = 1 | 5 | 5 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`image`, `Product`.`customized_price`, `Product`.`partner_price`, `Product`.`wholesale_price`, `Product`.`cleft_price`, `Product`.`price`, `Product`.`weight`, `Product`.`product_type`, `Product`.`coffee_id`, `Product`.`sku`, `Product`.`views`, `Product`.`active`, `Product`.`created`, `Product`.`modified` FROM `stageshopcleft_stage`.`products` AS `Product` WHERE `Product`.`active` = '1' AND `Product`.`coffee_id` IN (22, 24, 25, 32, 50) | 9 | 9 | 0 | |
| SELECT `Coffee`.`id`, `Coffee`.`name`, `Coffee`.`description`, `Coffee`.`image`, `Coffee`.`cleft_favorites`, `Coffee`.`favorite_flavors`, `Coffee`.`manual_order`, `Coffee`.`shop_order`, `Coffee`.`slug`, `Coffee`.`views`, `Coffee`.`status`, `Coffee`.`created`, `Coffee`.`modified` FROM `stageshopcleft_stage`.`coffees` AS `Coffee` WHERE `Coffee`.`status` = 1 AND `Coffee`.`shop_order` = 1 | 25 | 25 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`image`, `Product`.`customized_price`, `Product`.`partner_price`, `Product`.`wholesale_price`, `Product`.`cleft_price`, `Product`.`price`, `Product`.`weight`, `Product`.`product_type`, `Product`.`coffee_id`, `Product`.`sku`, `Product`.`views`, `Product`.`active`, `Product`.`created`, `Product`.`modified` FROM `stageshopcleft_stage`.`products` AS `Product` WHERE `Product`.`active` = '1' AND `Product`.`coffee_id` IN (1, 2, 5, 6, 12, 16, 17, 18, 22, 24, 25, 26, 27, 31, 32, 37, 40, 47, 50, 51, 52, 53, 54, 55, 56) | 45 | 45 | 1 | |
| SELECT `Coffee`.`id`, `Coffee`.`name` FROM `stageshopcleft_stage`.`coffees` AS `Coffee` WHERE 1 = 1 ORDER BY `Coffee`.`views` DESC LIMIT 6 | 6 | 6 | 0 | |