一覧

id name description parent order items
3 テストカテゴリテストかてごり テストカテゴリテストかてごり 0 0 6
4 かてごりその３ かてごりその３せつめい 0 0 3
18 queries took 58 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `categories`770
2DESCRIBE `items`550
3DESCRIBE `products`990
4SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE 1 = 1 441
5SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 0 221
6SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 3 001
7SELECT `Item`.`id`, `Item`.`product_id`, `Item`.`category_id`, `Item`.`created`, `Item`.`modified`, `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`url`, `Product`.`price`, `Product`.`imgL`, `Product`.`imgS`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `items` AS `Item` LEFT JOIN `products` AS `Product` ON (`Item`.`product_id` = `Product`.`id`) LEFT JOIN `categories` AS `Category` ON (`Item`.`category_id` = `Category`.`id`) WHERE `Item`.`category_id` = 3 6645
8SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 4 111
9SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 2 111
10SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 1 000
11SELECT `Item`.`id`, `Item`.`product_id`, `Item`.`category_id`, `Item`.`created`, `Item`.`modified`, `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`url`, `Product`.`price`, `Product`.`imgL`, `Product`.`imgS`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `items` AS `Item` LEFT JOIN `products` AS `Product` ON (`Item`.`product_id` = `Product`.`id`) LEFT JOIN `categories` AS `Category` ON (`Item`.`category_id` = `Category`.`id`) WHERE `Item`.`category_id` = 1 331
12SELECT `Item`.`id`, `Item`.`product_id`, `Item`.`category_id`, `Item`.`created`, `Item`.`modified`, `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`url`, `Product`.`price`, `Product`.`imgL`, `Product`.`imgS`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `items` AS `Item` LEFT JOIN `products` AS `Product` ON (`Item`.`product_id` = `Product`.`id`) LEFT JOIN `categories` AS `Category` ON (`Item`.`category_id` = `Category`.`id`) WHERE `Item`.`category_id` = 2 001
13SELECT `Item`.`id`, `Item`.`product_id`, `Item`.`category_id`, `Item`.`created`, `Item`.`modified`, `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`url`, `Product`.`price`, `Product`.`imgL`, `Product`.`imgS`, `Product`.`created`, `Product`.`modified`, `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `items` AS `Item` LEFT JOIN `products` AS `Product` ON (`Item`.`product_id` = `Product`.`id`) LEFT JOIN `categories` AS `Category` ON (`Item`.`category_id` = `Category`.`id`) WHERE `Item`.`category_id` = 4 001
14SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 0 ORDER BY `order` ASC 221
15SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 3 ORDER BY `order` ASC 001
16SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 4 ORDER BY `order` ASC 111
17SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 2 ORDER BY `order` ASC 111
18SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`parent`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`parent` = 1 ORDER BY `order` ASC 001