Filter
Popular brands
Brands > All brands
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Brand`.`id`, `Brand`.`name` FROM `malletin_db`.`brands` AS `Brand` WHERE 1 = 1 LIMIT 10 | 10 | 10 | 79 | |
| 2 | SELECT COUNT(*) AS `count` FROM `malletin_db`.`brands` AS `Brand` WHERE 1 = 1 | 1 | 1 | 0 | |
| 3 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`url_key`, `Brand`.`kw_news`, `Brand`.`kw_jobs`, `Brand`.`website`, `Brand`.`photo`, `Brand`.`res_desc1`, `Brand`.`res_link1`, `Brand`.`res_desc2`, `Brand`.`res_link2`, `Brand`.`res_desc3`, `Brand`.`res_link3`, `Brand`.`res_desc4`, `Brand`.`res_link4`, `Brand`.`res_desc5`, `Brand`.`res_link5`, `Brand`.`fb_feed_url`, `Brand`.`is_sub_nl`, `Brand`.`nl_email`, `Brand`.`matched_by_email`, `Brand`.`created`, `Brand`.`modified` FROM `malletin_db`.`brands` AS `Brand` WHERE 1 = 1 ORDER BY `Brand`.`id` DESC LIMIT 10 | 10 | 10 | 1 | |
| 4 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`lft`, `Category`.`rght`, `BrandsCategory`.`id`, `BrandsCategory`.`brand_id`, `BrandsCategory`.`cat_id` FROM `malletin_db`.`categories` AS `Category` JOIN `malletin_db`.`brands_categories` AS `BrandsCategory` ON (`BrandsCategory`.`brand_id` IN (2691, 2517, 2516, 2513, 2512, 2511, 2510, 2509, 2508, 2507) AND `BrandsCategory`.`cat_id` = `Category`.`id`) | 0 | 0 | 0 | |
| 5 | SELECT COUNT(*) AS `count` FROM `malletin_db`.`brands` AS `Brand` WHERE 1 = 1 | 1 | 1 | 0 | |
| 6 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`lft`, `Category`.`rght` FROM `malletin_db`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`lft` asc | 0 | 0 | 0 |