CakePHP: the rapid development php framework: Salesmen

home

Salesmen

Joe Smith

Dealers:

JR's Jeeps

Cars:

CJ7

Wrangler

Scout

Vince's Volkswagens

Cars:

GTI

Beetle

Golf

Cabriolet

Jane Rogers

Dealers:

JR's Jeeps

Cars:

CJ7

Wrangler

Scout

Stan Getz

Dealers:

Vince's Volkswagens

Cars:

GTI

Beetle

Golf

Cabriolet

Corey's Cryslers

Cars:

La Baron

Robert Plant

Dealers:

JR's Jeeps

Cars:

CJ7

Wrangler

Scout

Vince's Volkswagens

Cars:

GTI

Beetle

Golf

Cabriolet

Corey's Cryslers

Cars:

La Baron

Patrick's Pontiacs

Cars:

Firebird

Freebird

Jimmy Rogers

Dealers:

JR's Jeeps

Cars:

CJ7

Wrangler

Scout

Vince's Volkswagens

Cars:

GTI

Beetle

Golf

Cabriolet

Albert King

Dealers:

JR's Jeeps

Cars:

CJ7

Wrangler

Scout

Vince's Volkswagens

Cars:

GTI

Beetle

Golf

Cabriolet

(db3) 2 queries took 1 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `salesmen`		2	2	1
2	SELECT `Salesman`.`id`, `Salesman`.`name` FROM `salesmen` AS `Salesman` WHERE 1 = 1		6	6	0

(db3) 2 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `salesmen`

SELECT `Salesman`.`id`, `Salesman`.`name` FROM `salesmen` AS `Salesman` WHERE 1 = 1

(db2) 3 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `dealers`	2	2	0
2	DESCRIBE `dealers_salesmen`	3	3	1
3	SELECT `Dealer`.`id`, `Dealer`.`name`, `DealersSalesman`.`id`, `DealersSalesman`.`dealer_id`, `DealersSalesman`.`salesman_id` FROM `dealers` AS `Dealer` JOIN `dealers_salesmen` AS `DealersSalesman` ON (`DealersSalesman`.`salesman_id` IN (1, 2, 3, 4, 5, 6) AND `DealersSalesman`.`dealer_id` = `Dealer`.`id`)	13	13	0

(db2) 3 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `dealers`

DESCRIBE `dealers_salesmen`

SELECT `Dealer`.`id`, `Dealer`.`name`, `DealersSalesman`.`id`, `DealersSalesman`.`dealer_id`, `DealersSalesman`.`salesman_id` FROM `dealers` AS `Dealer` JOIN `dealers_salesmen` AS `DealersSalesman` ON (`DealersSalesman`.`salesman_id` IN (1, 2, 3, 4, 5, 6) AND `DealersSalesman`.`dealer_id` = `Dealer`.`id`)

(default) 7 queries took 2 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `cars`	3	3	1
2	SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 4)	10	10	0
3	SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 4)	10	10	0
4	SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 4)	10	10	0
5	SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 4)	10	10	1
6	SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 4)	10	10	0
7	SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 4)	10	10	0

(default) 7 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `cars`

SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 4)