(default) 6 queries took 6 ms Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `postcodes`		4	4	3
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';		1	1	3
3	SELECT `Postcode`.`id`, `Postcode`.`postcode`, `Postcode`.`latitude`, `Postcode`.`longitude` FROM `postcodes` AS `Postcode` WHERE `Postcode`.`postcode` = 'E153NS' LIMIT 1		1	1	0
4	SELECT COUNT(*) AS `count` FROM `outlets` AS `Outlet` WHERE (3963.0 * ACOS( SIN("51.536415"*PI()/180 ) * SIN( `Outlet`.`latitude`*PI()/180 ) + COS( "51.536415"*PI()/180 ) * COS( `Outlet`.`latitude`*PI()/180 ) * COS( (`Outlet`.`longitude`*PI()/180) - ("0.002968"*PI()/180) ) ) ) 		1	1	0
5	SELECT `Outlet`.`id`, `Outlet`.`name`, `Outlet`.`cuisine`, `Outlet`.`building_name`, `Outlet`.`number`, `Outlet`.`road`, `Outlet`.`town`, `Outlet`.`postcode`, `Outlet`.`telephone`, `Outlet`.`latitude`, `Outlet`.`longitude`, `Outlet`.`private_rooms`, `Outlet`.`salah`, ((3963.0 * ACOS( SIN("51.536415"*PI()/180 ) * SIN( `Outlet`.`latitude`*PI()/180 ) + COS( "51.536415"*PI()/180 ) * COS( `Outlet`.`latitude`*PI()/180 ) * COS( (`Outlet`.`longitude`*PI()/180) - ("0.002968"*PI()/180) ) ) )) AS `Outlet__distance` FROM `outlets` AS `Outlet` WHERE (3963.0 * ACOS( SIN("51.536415"*PI()/180 ) * SIN( `Outlet`.`latitude`*PI()/180 ) + COS( "51.536415"*PI()/180 ) * COS( `Outlet`.`latitude`*PI()/180 ) * COS( (`Outlet`.`longitude`*PI()/180) - ("0.002968"*PI()/180) ) ) ) LIMIT 5		5	5	0
6	SELECT `Image`.`id`, `Image`.`outlet_id`, `Image`.`description` FROM `images` AS `Image` WHERE `Image`.`outlet_id` IN (2, 3, 4, 5, 6) 		3	3	0