| Queries | Time | Rows |
| PRAGMA auto_vacuum=FULL | 0.001 | 0 |
| PRAGMA foreign_keys=ON | 0.000 | 0 |
| SELECT `categories`.*
FROM categories
WHERE `is_new` = 0
AND `is_service` = 1
AND `hold` = 1
ORDER BY `categories`.`ord` ASC | 0.000 | 5 |
| SELECT `categories`.*
FROM categories
WHERE `is_new` = 0
AND `kind` = 4
ORDER BY `categories`.`ord` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `countries`.*
FROM countries
WHERE `is_new` = 0
AND `menu_title` = 'Canada'
ORDER BY `countries`.`ord` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `settings`.*
FROM settings
WHERE `settings`.`id` = 1
ORDER BY `settings`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `countries`.*
FROM countries
WHERE `is_new` = 0
ORDER BY `countries`.`ord` ASC | 0.001 | 24 |
| SELECT `regions`.*
FROM regions
WHERE `is_new` = 0
AND `country_id` = 268
ORDER BY `regions`.`ord` ASC | 0.000 | 6 |
| SELECT `stores`.*
FROM stores
WHERE `region_id` = 132
ORDER BY `stores`.`ord` ASC | 0.000 | 2 |
| SELECT `stores`.*
FROM stores
WHERE `region_id` = 146
ORDER BY `stores`.`ord` ASC | 0.000 | 1 |
| SELECT `stores`.*
FROM stores
WHERE `region_id` = 82
ORDER BY `stores`.`ord` ASC | 0.000 | 1 |
| SELECT `stores`.*
FROM stores
WHERE `region_id` = 81
ORDER BY `stores`.`ord` ASC | 0.000 | 2 |
| SELECT `stores`.*
FROM stores
WHERE `region_id` = 131
ORDER BY `stores`.`ord` ASC | 0.000 | 1 |
| SELECT `stores`.*
FROM stores
WHERE `region_id` = 83
ORDER BY `stores`.`ord` ASC | 0.000 | 1 |
| Total: 14 | 0.005 | 46 |