Latest News

Showing 1 - 2 (2)
  • first news

    first news brief...more

    Date & Time Posted Nov 30th -0001, 00:00:00
  • second news

    second news brief...more

    Date & Time Posted Nov 30th -0001, 00:00:00
Showing 1 - 2 (2)
 
Affiliate Program
(default) 95 queries took 70 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `news`882
2DESCRIBE `settings`441
3DESCRIBE `currencies`331
4DESCRIBE `languages`441
5DESCRIBE `translations`991
6DESCRIBE `products`24242
7DESCRIBE `categories`10102
8DESCRIBE `limits`552
9DESCRIBE `auctions`27272
10DESCRIBE `statuses`331
11DESCRIBE `users`21212
12DESCRIBE `genders`221
13DESCRIBE `sources`441
14DESCRIBE `points`552
15DESCRIBE `addresses`13133
16DESCRIBE `user_address_types`221
17DESCRIBE `countries`551
18DESCRIBE `bids`881
19DESCRIBE `bidbutlers`882
20DESCRIBE `accounts`992
21DESCRIBE `affiliates`882
22DESCRIBE `affiliate_codes`441
23DESCRIBE `referrals`661
24DESCRIBE `credits`772
25DESCRIBE `watchlists`551
26DESCRIBE `reminders`332
27DESCRIBE `messages`552
28DESCRIBE `auction_emails`221
29DESCRIBE `autobids`441
30DESCRIBE `smartbids`441
31DESCRIBE `images`772
32DESCRIBE `image_defaults`331
33DESCRIBE `setting_increments`771
34SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
35SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE `Setting`.`name` = 'default_meta_description' LIMIT 1110
36SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE `Setting`.`name` = 'default_meta_keywords' LIMIT 1110
37SELECT COUNT(*) AS `count` FROM `news` AS `News` WHERE 1 = 1 110
38SELECT `News`.`id`, `News`.`title`, `News`.`meta_description`, `News`.`meta_keywords`, `News`.`brief`, `News`.`content`, `News`.`created`, `News`.`modified` FROM `news` AS `News` WHERE 1 = 1 ORDER BY `created` desc LIMIT 10220
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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:02' AND `Auction`.`end_time` > '2010-07-31 18:53:02' 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:53:03' AND `Auction`.`end_time` > '2010-07-31 18:53:03' 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:53:03' AND `Auction`.`end_time` > '2010-07-31 18:53:03' 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:53:03' AND `Auction`.`end_time` > '2010-07-31 18:53:03' 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:53:03' AND `Auction`.`end_time` > '2010-07-31 18:53:03' 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:53:03' AND end_time > '2010-07-31 18:53:03' 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:53:03' 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:53:03' AND end_time > '2010-07-31 18:53:03' 111
90DESCRIBE `pages`13132
91DESCRIBE `departments`331
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`.`top_show` > 0 ORDER BY `Page`.`top_order` ASC 110
94SELECT `Language`.`id`, `Language`.`language`, `Language`.`server_name`, `Language`.`default` FROM `languages` AS `Language` WHERE `Language`.`server_name` = 'bidnow.ch' AND `default` = 0 LIMIT 1000
95SELECT `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