Listings

Starry Night $200.50	I and the village $120.00	Starry Night 2 $200.00
Brushing $150.00	Postman $350.00	Ships $100.00
Flowering almond $430.00	Field $130.00	Open plain $345.23

Results: 1-9 of 10

1 | 2

9 18

(default) 15 queries took 8 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `listings`	12	12	1
2	DESCRIBE `users`	9	9	1
3	DESCRIBE `account_types`	4	4	1
4	DESCRIBE `listing_images`	8	8	1
5	DESCRIBE `categories`	4	4	1
6	DESCRIBE `store_listings`	3	3	1
7	DESCRIBE `stores`	4	4	1
8	SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) WHERE `Listing`.`active` = 1 AND `Listing`.`reported` = 0	1	1	0
9	SELECT `Listing`.`id`, `Listing`.`user_id`, `Listing`.`listing_type_id`, `Listing`.`category_id`, `Listing`.`name`, `Listing`.`description`, `Listing`.`price`, `Listing`.`payment_link`, `Listing`.`active`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`reported`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`account_type_id`, `User`.`firstname`, `User`.`lastname`, `User`.`name`, `User`.`email`, `User`.`bio`, `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) WHERE `Listing`.`active` = 1 AND `Listing`.`reported` = 0 ORDER BY `Listing`.`id` ASC LIMIT 9	9	9	0
10	SELECT `ListingImage`.`id`, `ListingImage`.`listing_id`, `ListingImage`.`user_id`, `ListingImage`.`location`, `ListingImage`.`description`, `ListingImage`.`active`, `ListingImage`.`created`, `ListingImage`.`modified` FROM `listing_images` AS `ListingImage` WHERE `ListingImage`.`listing_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)	9	9	0
11	SELECT `StoreListing`.`id`, `StoreListing`.`store_id`, `StoreListing`.`listing_id` FROM `store_listings` AS `StoreListing` WHERE `StoreListing`.`listing_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)	1	1	0
12	SELECT `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1	29	29	0
13	SELECT `Listing`.`id`, `Listing`.`user_id`, `Listing`.`listing_type_id`, `Listing`.`category_id`, `Listing`.`name`, `Listing`.`description`, `Listing`.`price`, `Listing`.`payment_link`, `Listing`.`active`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`reported` FROM `listings` AS `Listing` WHERE `Listing`.`category_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29)	10	10	0
14	DESCRIBE `favorites`	3	3	1
15	SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`listing_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`account_type_id`, `User`.`firstname`, `User`.`lastname`, `User`.`name`, `User`.`email`, `User`.`bio`, `Listing`.`id`, `Listing`.`user_id`, `Listing`.`listing_type_id`, `Listing`.`category_id`, `Listing`.`name`, `Listing`.`description`, `Listing`.`price`, `Listing`.`payment_link`, `Listing`.`active`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`reported` FROM `favorites` AS `Favorite` LEFT JOIN `users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) LEFT JOIN `listings` AS `Listing` ON (`Favorite`.`listing_id` = `Listing`.`id`) WHERE `Favorite`.`user_id` IS NULL	0	0	0

(default) 15 queries took 8 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `listings`

DESCRIBE `users`

DESCRIBE `account_types`

DESCRIBE `listing_images`

DESCRIBE `categories`

DESCRIBE `store_listings`

DESCRIBE `stores`

SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) WHERE `Listing`.`active` = 1 AND `Listing`.`reported` = 0

SELECT `Listing`.`id`, `Listing`.`user_id`, `Listing`.`listing_type_id`, `Listing`.`category_id`, `Listing`.`name`, `Listing`.`description`, `Listing`.`price`, `Listing`.`payment_link`, `Listing`.`active`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`reported`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`account_type_id`, `User`.`firstname`, `User`.`lastname`, `User`.`name`, `User`.`email`, `User`.`bio`, `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) WHERE `Listing`.`active` = 1 AND `Listing`.`reported` = 0 ORDER BY `Listing`.`id` ASC LIMIT 9

SELECT `ListingImage`.`id`, `ListingImage`.`listing_id`, `ListingImage`.`user_id`, `ListingImage`.`location`, `ListingImage`.`description`, `ListingImage`.`active`, `ListingImage`.`created`, `ListingImage`.`modified` FROM `listing_images` AS `ListingImage` WHERE `ListingImage`.`listing_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)

SELECT `StoreListing`.`id`, `StoreListing`.`store_id`, `StoreListing`.`listing_id` FROM `store_listings` AS `StoreListing` WHERE `StoreListing`.`listing_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1

DESCRIBE `favorites`

SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`listing_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`account_type_id`, `User`.`firstname`, `User`.`lastname`, `User`.`name`, `User`.`email`, `User`.`bio`, `Listing`.`id`, `Listing`.`user_id`, `Listing`.`listing_type_id`, `Listing`.`category_id`, `Listing`.`name`, `Listing`.`description`, `Listing`.`price`, `Listing`.`payment_link`, `Listing`.`active`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`reported` FROM `favorites` AS `Favorite` LEFT JOIN `users` AS `User` ON (`Favorite`.`user_id` = `User`.`id`) LEFT JOIN `listings` AS `Listing` ON (`Favorite`.`listing_id` = `Listing`.`id`) WHERE `Favorite`.`user_id` IS NULL

ArtGallery.org

Categories

Listings