Notice (8): Undefined index: state [APP/Controller/Component/FilterComponent.php, line 147]
Phone: 386-253-6783
Address: 1700 W International Speedway Blvd, Daytona Beach, FL, 32114
Phone: 850-769-3659
Address: 2150 MARTIN LUTHER KING JR. BLVD.,, Panama City, FL, 32405
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Setting`.`value` FROM `malletin_db`.`settings` AS `Setting` WHERE `type` = 'state' AND `key` = 'FL' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT COUNT(*) AS `count` FROM `malletin_db`.`malls` AS `Mall` WHERE `Mall`.`type` = 'mall' AND `Mall`.`state_id` = 'FL' | 1 | 1 | 1 | |
| 3 | SELECT `Mall`.`id`, `Mall`.`name`, `Mall`.`url_key`, `Mall`.`type`, `Mall`.`phone`, `Mall`.`address`, `Mall`.`state_id`, `Mall`.`state_name`, `Mall`.`city_id`, `Mall`.`city_name`, `Mall`.`zipcode`, `Mall`.`bizhours`, `Mall`.`kw_news`, `Mall`.`kw_jobs`, `Mall`.`website`, `Mall`.`photo`, `Mall`.`gmaps_lat`, `Mall`.`gmaps_lon`, `Mall`.`res_desc1`, `Mall`.`res_link1`, `Mall`.`res_desc2`, `Mall`.`res_link2`, `Mall`.`res_desc3`, `Mall`.`res_link3`, `Mall`.`res_desc4`, `Mall`.`res_link4`, `Mall`.`res_desc5`, `Mall`.`res_link5`, `Mall`.`fb_feed_url`, `Mall`.`is_sub_nl`, `Mall`.`nl_email`, `Mall`.`created`, `Mall`.`modified`, `Mall`.`job_num` FROM `malletin_db`.`malls` AS `Mall` WHERE `Mall`.`type` = 'mall' AND `Mall`.`state_id` = 'FL' ORDER BY `Mall`.`id` ASC LIMIT 10 | 10 | 10 | 1 | |
| 4 | SELECT COUNT(*) AS `count` FROM `malletin_db`.`malls` AS `Mall` WHERE `Mall`.`type` = 'mall' AND `Mall`.`state_id` = 'FL' | 1 | 1 | 1 | |
| 5 | SELECT `Mall`.`state_id`, `Mall`.`state_name`, `Mall`.`city_id`, `Mall`.`city_name`, COUNT(id) AS cnt FROM `malletin_db`.`malls` AS `Mall` WHERE 1 = 1 GROUP BY `Mall`.`state_id`, `Mall`.`city_id` | 736 | 736 | 5 |
