- Midi Lib

SQL Queries

Order	Elapsed	Query
0	0.0002	SELECT `t0`.* FROM `session` t0 WHERE (`t0`.`sessionKey` = '3kj0gdpt7obub52ue80dnf5ia2')
1	0.0002	SELECT `t0`.`name`, SUM(`t1`.`id`) AS `deviceCnt` FROM `manufacturer` t0 LEFT JOIN `device` `t1` ON ((`t0`.`id` = `t1`.`manuId`) ) WHERE (`t1`.`status` != 'potential') GROUP BY `t0`.`id` HAVING (`deviceCnt` > 0)