Specialising In

Tri-ang
RAILWAYS

THE WORLD'S FINEST AND MOST
COMPREHENSIVE MODEL RAILWAY SYSTEMS

Last updated 1 hour, 19 minutes ago

(default) 7 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Cart`.`id`, `Cart`.`item_id`, `Cart`.`qty`, `Cart`.`ct_session_id`, `Cart`.`created`, `Cart`.`modified`, `Item`.`id`, `Item`.`parent_id`, `Item`.`category_id`, `Item`.`status_id`, `Item`.`status`, `Item`.`brand`, `Item`.`cat_num`, `Item`.`store_category`, `Item`.`title`, `Item`.`condition`, `Item`.`description`, `Item`.`stock_qty`, `Item`.`qty`, `Item`.`unit_cost`, `Item`.`unit_asking`, `Item`.`ref`, `Item`.`barcode_url`, `Item`.`buy_it_now_price`, `Item`.`domestic_type`, `Item`.`postage_cost`, `Item`.`additonal_postage`, `Item`.`ships_to`, `Item`.`international_type`, `Item`.`international_postage_cost`, `Item`.`international_additonal_postage`, `Item`.`notes`, `Item`.`currency`, `Item`.`purchase`, `Item`.`refurb_costs`, `Item`.`total_cost`, `Item`.`sold_used`, `Item`.`used`, `Item`.`profit_loss`, `Item`.`sell_price`, `Item`.`auto_relist`, `Item`.`expense`, `Item`.`ebay_cond`, `Item`.`ebay_category`, `Item`.`dispatch_time`, `Item`.`listing_duration`, `Item`.`used_date`, `Item`.`is_live`, `Item`.`ebayid`, `Item`.`sold_date`, `Item`.`purchase_date`, `Item`.`marked_paid`, `Item`.`listed_date`, `Item`.`listing_count`, `Item`.`ended`, `Item`.`start`, `Item`.`end`, `Item`.`lft`, `Item`.`rght`, `Item`.`created`, `Item`.`modified`, `Item`.`uuid`, `Item`.`title_details`, `Item`.`owing`, `Item`.`paid`, `Item`.`charged`, `Item`.`rai`, `Item`.`lh_expense`, `Item`.`lh_capital_expense`, `Item`.`deposit`, `Item`.`withdrawn`, `Item`.`bank_rt`, `Item`.`cash_rt` FROM `triang_prod`.`carts` AS `Cart` LEFT JOIN `triang_prod`.`items` AS `Item` ON (`Cart`.`item_id` = `Item`.`id`) WHERE `Cart`.`ct_session_id` = '7e1fa429247809bf6d6c35906ff4a1dd199bec0f'001
2SELECT `Cart`.`id`, `Cart`.`item_id`, `Cart`.`qty`, `Cart`.`ct_session_id`, `Cart`.`created`, `Cart`.`modified` FROM `triang_prod`.`carts` AS `Cart` WHERE `Cart`.`created` < '2016-07-29 13:25:54'000
3SELECT `Status`.`id`, `Status`.`name` FROM `triang_prod`.`statuses` AS `Status` WHERE 1 = 132320
4SELECT `Item`.`id`, `Item`.`parent_id`, `Item`.`category_id`, `Item`.`status_id`, `Item`.`status`, `Item`.`brand`, `Item`.`cat_num`, `Item`.`store_category`, `Item`.`title`, `Item`.`condition`, `Item`.`description`, `Item`.`stock_qty`, `Item`.`qty`, `Item`.`unit_cost`, `Item`.`unit_asking`, `Item`.`ref`, `Item`.`barcode_url`, `Item`.`buy_it_now_price`, `Item`.`domestic_type`, `Item`.`postage_cost`, `Item`.`additonal_postage`, `Item`.`ships_to`, `Item`.`international_type`, `Item`.`international_postage_cost`, `Item`.`international_additonal_postage`, `Item`.`notes`, `Item`.`currency`, `Item`.`purchase`, `Item`.`refurb_costs`, `Item`.`total_cost`, `Item`.`sold_used`, `Item`.`used`, `Item`.`profit_loss`, `Item`.`sell_price`, `Item`.`auto_relist`, `Item`.`expense`, `Item`.`ebay_cond`, `Item`.`ebay_category`, `Item`.`dispatch_time`, `Item`.`listing_duration`, `Item`.`used_date`, `Item`.`is_live`, `Item`.`ebayid`, `Item`.`sold_date`, `Item`.`purchase_date`, `Item`.`marked_paid`, `Item`.`listed_date`, `Item`.`listing_count`, `Item`.`ended`, `Item`.`start`, `Item`.`end`, `Item`.`lft`, `Item`.`rght`, `Item`.`created`, `Item`.`modified`, `Item`.`uuid`, `Item`.`title_details`, `Item`.`owing`, `Item`.`paid`, `Item`.`charged`, `Item`.`rai`, `Item`.`lh_expense`, `Item`.`lh_capital_expense`, `Item`.`deposit`, `Item`.`withdrawn`, `Item`.`bank_rt`, `Item`.`cash_rt`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`in_menu`, `Category`.`created`, `Category`.`modified` FROM `triang_prod`.`items` AS `Item` LEFT JOIN `triang_prod`.`categories` AS `Category` ON (`Item`.`category_id` = `Category`.`id`) WHERE `Item`.`category_id` = '4' AND `Item`.`status_id` = 5 AND `Item`.`qty` > 0 ORDER BY `Item`.`id` desc LIMIT 5001
5SELECT `Item`.`modified`, `Item`.`id` FROM `triang_prod`.`items` AS `Item` LEFT JOIN `triang_prod`.`categories` AS `Category` ON (`Item`.`category_id` = `Category`.`id`) LEFT JOIN `triang_prod`.`statuses` AS `Status` ON (`Item`.`status_id` = `Status`.`id`) WHERE 1 = 1 ORDER BY `Item`.`modified` desc LIMIT 1110
6SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`in_menu`, `Category`.`created`, `Category`.`modified` FROM `triang_prod`.`categories` AS `Category` WHERE `Category`.`in_menu` = '1'15150
7SELECT `Item`.`status_id`, `Item`.`category_id` FROM `triang_prod`.`items` AS `Item` WHERE `Item`.`status_id` = 5 AND `Item`.`category_id` IN (1, 3, 4, 5, 6, 7, 8, 10, 12, 13, 15, 18, 19, 21, 22)51510