Log Messages

Total 30 items.

#	Time	Level	Category	Message

1	21:45:37.591	info	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=gymstable2
2	21:45:37.591	info	yii\db\Command::query	SELECT * FROM `suburb` WHERE (`name`='springfield central') AND (`state`='qld') AND (`zip`='4300') GROUP BY `name`
3	21:45:37.592	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `suburb`
4	21:45:37.592	info	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'suburb' AND kcu.table_name = 'suburb'
5	21:45:37.593	info	yii\db\Command::query	SELECT `id` FROM `suburb` WHERE (`name`='SPRINGFIELD CENTRAL') AND (`state`='QLD')
6	21:45:37.598	info	yii\db\Command::query	SELECT `meta`.* FROM `meta` INNER JOIN `location` `l` ON l.id = meta.meta_id WHERE `l`.`suburbId`='12410' ORDER BY `id` DESC
7	21:45:37.599	info	yii\db\Command::query	SELECT `id` FROM `suburb` WHERE (`name`='SPRINGFIELD CENTRAL') AND (`state`='QLD')
8	21:45:37.599	info	yii\db\Command::query	SELECT `meta`.* FROM `meta` INNER JOIN `location` `l` ON l.id = meta.meta_id WHERE `l`.`suburbId`='12410' ORDER BY `id` DESC
9	21:45:37.600	info	yii\db\Command::query	SELECT `id`, `is_mini_list`, (6371 /1 * acos( cos(radians(-27.6833)) * cos(radians(gymDetail.lat)) * cos(radians(gymDetail.lon) - radians(152.903)) + sin(radians(-27.6833)) * sin(radians(gymDetail.lat)) ) ) AS `distance` FROM `gymDetail` WHERE `status` = 1 HAVING `distance` < 10 ORDER BY `gymDetail`.`is_mini_list`, `distance` LIMIT 10
10	21:45:37.600	info	yii\db\Command::query	SELECT * FROM `gymDetail` WHERE `id` IN (-1, '203') ORDER BY FIELD (id, -1,203)
11	21:45:37.601	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `gymDetail`
12	21:45:37.602	info	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'gymDetail' AND kcu.table_name = 'gymDetail'
13	21:45:37.603	info	yii\db\Command::query	SELECT * FROM `suburb` WHERE `id`=947
14	21:45:37.603	info	yii\db\Command::query	SELECT * FROM `gymDetailMedia` WHERE `gymDetailId`=203
15	21:45:37.603	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `gymDetailMedia`
16	21:45:37.604	info	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'gymDetailMedia' AND kcu.table_name = 'gymDetailMedia'
17	21:45:37.604	info	yii\db\Command::query	SELECT * FROM `gymDetailImage` WHERE `gymDetailId`=203
18	21:45:37.604	info	yii\db\Command::query	SELECT * FROM `gymDetailPrice` WHERE `gymDetailId`=203
19	21:45:37.604	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `gymDetailPrice`
20	21:45:37.605	info	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'gymDetailPrice' AND kcu.table_name = 'gymDetailPrice'
21	21:45:37.607	info	yii\db\Command::query	SELECT `name`, `type`.`id` FROM `type` WHERE `isDeleted`=0
22	21:45:37.612	info	yii\db\Command::query	SELECT `name` FROM `type` WHERE `id`=4
23	21:45:37.612	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `type`
24	21:45:37.613	info	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'type' AND kcu.table_name = 'type'
25	21:45:37.614	info	yii\db\Command::query	SELECT `id`, `name` FROM `chain`
26	21:45:37.614	info	yii\db\Command::query	SELECT `id`, `name` FROM `chain`
27	21:45:37.614	info	yii\db\Command::query	SELECT * FROM `suburb` WHERE `id`=947
28	21:45:37.616	info	yii\db\Command::query	SHOW FULL COLUMNS FROM `url_meta`
29	21:45:37.616	info	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'url_meta' AND kcu.table_name = 'url_meta'
30	21:45:37.617	info	yii\db\Command::query	SELECT * FROM `url_meta` WHERE `url`='/location/springfield-central-qld-4300'