About Us | Contact

About Us

test

 
Affiliate Program
(default) 93 queries took 58 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`13132
2DESCRIBE `departments`331
3DESCRIBE `settings`441
4DESCRIBE `currencies`331
5DESCRIBE `languages`441
6DESCRIBE `translations`991
7DESCRIBE `products`24242
8DESCRIBE `categories`10102
9DESCRIBE `limits`551
10DESCRIBE `auctions`27272
11DESCRIBE `statuses`331
12DESCRIBE `users`21212
13DESCRIBE `genders`221
14DESCRIBE `sources`441
15DESCRIBE `points`551
16DESCRIBE `addresses`13132
17DESCRIBE `user_address_types`221
18DESCRIBE `countries`551
19DESCRIBE `bids`881
20DESCRIBE `bidbutlers`881
21DESCRIBE `accounts`991
22DESCRIBE `affiliates`881
23DESCRIBE `affiliate_codes`441
24DESCRIBE `referrals`661
25DESCRIBE `credits`771
26DESCRIBE `watchlists`551
27DESCRIBE `reminders`331
28DESCRIBE `messages`551
29DESCRIBE `auction_emails`221
30DESCRIBE `autobids`441
31DESCRIBE `smartbids`441
32DESCRIBE `images`771
33DESCRIBE `image_defaults`331
34DESCRIBE `setting_increments`771
35SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
36SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE `Setting`.`name` = 'default_meta_description' LIMIT 1110
37SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE `Setting`.`name` = 'default_meta_keywords' LIMIT 1110
38SELECT `Page`.`id`, `Page`.`name`, `Page`.`title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`content`, `Page`.`slug`, `Page`.`top_show`, `Page`.`top_order`, `Page`.`bottom_show`, `Page`.`bottom_order`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`slug` = 'about-us' LIMIT 1110
39SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc 15150
40SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 4 AND `Auction`.`start_time` < '2010-07-31 18:52:48' AND `Auction`.`end_time` > '2010-07-31 18:52:48' 111
41SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 4 LIMIT 1110
42SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 8 AND `Category`.`lft` > 7 ORDER BY `Category`.`lft` asc 000
43SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 9 AND `Auction`.`start_time` < '2010-07-31 18:52:48' AND `Auction`.`end_time` > '2010-07-31 18:52:48' 111
44SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 9 LIMIT 1110
45SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 18 AND `Category`.`lft` > 17 ORDER BY `Category`.`lft` asc 000
46SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 2 AND `Auction`.`start_time` < '2010-07-31 18:52:48' AND `Auction`.`end_time` > '2010-07-31 18:52:48' 111
47SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 2 LIMIT 1110
48SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 4 AND `Category`.`lft` > 3 ORDER BY `Category`.`lft` asc 000
49SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 6 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
50SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 6 LIMIT 1110
51SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 12 AND `Category`.`lft` > 11 ORDER BY `Category`.`lft` asc 000
52SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 15 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
53SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 15 LIMIT 1110
54SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 30 AND `Category`.`lft` > 29 ORDER BY `Category`.`lft` asc 000
55SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 12 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
56SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 12 LIMIT 1110
57SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 24 AND `Category`.`lft` > 23 ORDER BY `Category`.`lft` asc 000
58SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 14 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
59SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 14 LIMIT 1110
60SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 28 AND `Category`.`lft` > 27 ORDER BY `Category`.`lft` asc 000
61SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 7 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
62SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 7 LIMIT 1110
63SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 14 AND `Category`.`lft` > 13 ORDER BY `Category`.`lft` asc 000
64SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 5 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
65SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 5 LIMIT 1110
66SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 10 AND `Category`.`lft` > 9 ORDER BY `Category`.`lft` asc 000
67SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 16 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
68SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 16 LIMIT 1110
69SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 32 AND `Category`.`lft` > 31 ORDER BY `Category`.`lft` asc 000
70SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 8 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
71SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 8 LIMIT 1110
72SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 16 AND `Category`.`lft` > 15 ORDER BY `Category`.`lft` asc 000
73SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 10 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
74SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 10 LIMIT 1110
75SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 20 AND `Category`.`lft` > 19 ORDER BY `Category`.`lft` asc 000
76SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 11 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
77SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 11 LIMIT 1110
78SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 22 AND `Category`.`lft` > 21 ORDER BY `Category`.`lft` asc 000
79SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 3 AND `Auction`.`start_time` < '2010-07-31 18:52:49' AND `Auction`.`end_time` > '2010-07-31 18:52:49' 111
80SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 3 LIMIT 1110
81SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 6 AND `Category`.`lft` > 5 ORDER BY `Category`.`lft` asc 000
82SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`category_id` = 13 AND `Auction`.`start_time` < '2010-07-31 18:52:50' AND `Auction`.`end_time` > '2010-07-31 18:52:50' 111
83SELECT `Category`.`lft`, `Category`.`rght` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 13 LIMIT 1110
84SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 26 AND `Category`.`lft` > 25 ORDER BY `Category`.`lft` asc 000
85SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 0 ORDER BY `Category`.`name` asc 15150
86SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE start_time < '2010-07-31 18:52:50' AND end_time > '2010-07-31 18:52:50' 111
87SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE start_time > '2010-07-31 18:52:50' 111
88SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `closed` = 1 110
89SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `products` AS `Product` ON (`Auction`.`product_id` = `Product`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Auction`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `Winner` ON (`Auction`.`winner_id` = `Winner`.`id`) LEFT JOIN `users` AS `Leader` ON (`Auction`.`leader_id` = `Leader`.`id`) LEFT JOIN `messages` AS `Message` ON (`Message`.`auction_id` = `Auction`.`id`) LEFT JOIN `auction_emails` AS `AuctionEmail` ON (`AuctionEmail`.`auction_id` = `Auction`.`id`) WHERE `Product`.`free` = 1 AND start_time < '2010-07-31 18:52:50' AND end_time > '2010-07-31 18:52:50' 111
90SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
91SELECT `Page`.`id`, `Page`.`name`, `Page`.`title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`content`, `Page`.`slug`, `Page`.`top_show`, `Page`.`top_order`, `Page`.`bottom_show`, `Page`.`bottom_order`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`top_show` > 0 ORDER BY `Page`.`top_order` ASC 110
92SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
93SELECT `Page`.`id`, `Page`.`name`, `Page`.`title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`content`, `Page`.`slug`, `Page`.`top_show`, `Page`.`top_order`, `Page`.`bottom_show`, `Page`.`bottom_order`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`bottom_show` > 0 ORDER BY `Page`.`bottom_order` ASC 110