| 1 | SELECT Apisetting.createuser as 'CREATE',Apisetting.delete as 'DELETE' ,Apisetting.put as PUT,Apisetting.post as POST,Apisetting.get as GET,Apisetting.competition_id, `Apisetting`.`name`, `Apisetting`.`key` FROM `apisettings` AS `Apisetting` LEFT JOIN `competitions` AS `Competition` ON (`Apisetting`.`competition_id` = `Competition`.`id`) WHERE `key` IS NULL AND `enable` = 1 LIMIT 1 | | 0 | 0 | 0 |
| 2 | SELECT `Application`.`id`, `Application`.`youtube_url`, `Application`.`created`, `Application`.`modified`, `Application`.`completed`, `Application`.`user_id`, `Application`.`url`, `Application`.`slug`, `Application`.`title`, `Application`.`description`, `Application`.`platforms`, `Application`.`pricing`, `Application`.`keywords`, `Application`.`target_users`, `Application`.`looking_for`, `Application`.`logo_image`, `Application`.`pricing_free`, `Application`.`icon`, `Application`.`featured`, `Application`.`pitch`, `Application`.`count_rating`, `Application`.`user_rating`, `Application`.`itunes`, `Application`.`source`, `Application`.`published`, `Application`.`qrcode`, `Application`.`business`, `Application`.`technology_innovation`, `Application`.`scenarios`, `Application`.`differentiation`, `Application`.`hashtag_app`, `User`.`id`, `User`.`created`, `User`.`modified`, `User`.`registered`, `User`.`organization_type_id`, `User`.`mobile_role_type_id`, `User`.`organization_name`, `User`.`organization_url`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`email`, `User`.`phone_number`, `User`.`country`, `User`.`city`, `User`.`banned`, `User`.`password`, `User`.`profile_image`, `User`.`application_url`, `User`.`source`, `User`.`twitter_username`, `User`.`ip_created`, (CONCAT(`User`.`first_name`, ' ', `User`.`last_name`)) AS `User__name` FROM `applications` AS `Application` LEFT JOIN `users` AS `User` ON (`Application`.`user_id` = `User`.`id`) WHERE `slug` = 'callmyname-1' ORDER BY `Application`.`created` desc LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `Price`.`id`, `Price`.`application_id`, `Price`.`name`, `Price`.`price`, `Price`.`comment`, `Price`.`created`, `Price`.`modified` FROM `applications_prices` AS `Price` WHERE `Price`.`application_id` = (1853) | | 0 | 0 | 1 |
| 4 | SELECT `Link`.`id`, `Link`.`url`, `Link`.`application_id`, `Link`.`name`, `Link`.`created`, `Link`.`modified` FROM `applications_links` AS `Link` WHERE `Link`.`application_id` = (1853) | | 5 | 5 | 1 |
| 5 | SELECT `Vote`.`id`, `Vote`.`app_id`, `Vote`.`competition_id`, `Vote`.`user_id`, `Vote`.`fb_id`, `Vote`.`twitter_img`, `Vote`.`twitter_id`, `Vote`.`vote_date`, `Vote`.`vote_ip`, `Vote`.`name`, `Vote`.`email`, `Vote`.`created`, `Vote`.`modified` FROM `votes` AS `Vote` WHERE `Vote`.`app_id` = (1853) | | 0 | 0 | 9 |
| 6 | SELECT `Winner`.`id`, `Winner`.`type`, `Winner`.`app_id`, `Winner`.`event_id`, `Winner`.`competition_id`, `Winner`.`created`, `Winner`.`modified` FROM `winners` AS `Winner` WHERE `Winner`.`app_id` = (1853) | | 0 | 0 | 0 |
| 7 | SELECT `Finalist`.`id`, `Finalist`.`app_id`, `Finalist`.`event_id`, `Finalist`.`created`, `Finalist`.`modified` FROM `finalists` AS `Finalist` WHERE `Finalist`.`app_id` = (1853) | | 0 | 0 | 0 |
| 8 | SELECT `Event`.`id`, `Event`.`created`, `Event`.`modified`, `Event`.`type`, `Event`.`editor_id`, `Event`.`name`, `Event`.`lang`, `Event`.`url`, `Event`.`region_id`, `Event`.`country_id`, `Event`.`city`, `Event`.`venue`, `Event`.`date_start`, `Event`.`deathline`, `Event`.`support_deadline`, `Event`.`timezone`, `Event`.`overview`, `Event`.`description`, `Event`.`agenda`, `Event`.`workshops`, `Event`.`speakers`, `Event`.`practical`, `Event`.`step_info`, `Event`.`avg_rating`, `Event`.`num_visitors`, `Event`.`slug`, `Event`.`icon`, `Event`.`thumb`, `Event`.`fb_appid`, `Event`.`fb_icon`, `Event`.`featured`, `Event`.`date_confirmed`, `Event`.`published`, `Event`.`branded`, `Event`.`external_url`, `Event`.`themed`, `Event`.`submit_notes`, `Event`.`register`, `Event`.`canceled`, `Event`.`subject_email`, `Event`.`subject_body`, `Event`.`app_submit_subject_email`, `Event`.`app_submit_body_email`, `Event`.`max_attendee`, `Event`.`min_supporters`, `Event`.`min_apps`, `Event`.`min_finalists`, `Event`.`hashtags`, `Event`.`event_hashtag`, `Event`.`contact_email`, `Event`.`admin_email`, `Event`.`app_selected_subject_email`, `Event`.`app_selected_body_email`, `Event`.`app_notselected_subject_email`, `Event`.`app_notselected_body_email`, `Event`.`app_finalist_subject_email`, `Event`.`app_finalist_body_email`, `Event`.`app_notfinalist_subject_email`, `Event`.`app_notfinalist_body_email`, `ApplicationsEvent`.`id`, `ApplicationsEvent`.`application_id`, `ApplicationsEvent`.`event_id`, `ApplicationsEvent`.`winner`, `ApplicationsEvent`.`telephone`, `ApplicationsEvent`.`extra_data`, `ApplicationsEvent`.`selected`, `ApplicationsEvent`.`selected_email_sent`, `ApplicationsEvent`.`created`, `ApplicationsEvent`.`modified` FROM `events` AS `Event` JOIN `applications_events` AS `ApplicationsEvent` ON (`ApplicationsEvent`.`application_id` = 1853 AND `ApplicationsEvent`.`event_id` = `Event`.`id`) | | 0 | 0 | 1 |
| 9 | SELECT `Competition`.`id`, `Competition`.`slug`, `Competition`.`title`, `Competition`.`lang`, `Competition`.`description`, `Competition`.`overview`, `Competition`.`prizes`, `Competition`.`rules`, `Competition`.`process`, `Competition`.`about`, `Competition`.`week`, `Competition`.`prize`, `Competition`.`published`, `Competition`.`date_start`, `Competition`.`deathline`, `Competition`.`submit_notes`, `Competition`.`app_submit_subject_email`, `Competition`.`app_submit_body_email`, `Competition`.`created`, `Competition`.`modified`, `Competition`.`featured`, `Competition`.`branded`, `Competition`.`themed`, `Competition`.`fb_appid`, `Competition`.`fb_icon`, `Competition`.`comp_image`, `Competition`.`hashtags`, `Competition`.`voting_hashtags`, `Competition`.`hashtag_comp`, `Competition`.`twitter_act`, `Competition`.`validate_apps`, `Competition`.`admin_email`, `Competition`.`contact_email`, `Competition`.`voting_start`, `Competition`.`date_end`, `Competition`.`app_validation_body_email`, `Competition`.`app_refusing_body_email`, `Competition`.`submit_url`, `ApplicationsCompetition`.`id`, `ApplicationsCompetition`.`application_id`, `ApplicationsCompetition`.`competition_id`, `ApplicationsCompetition`.`total_votes`, `ApplicationsCompetition`.`twitter_votes`, `ApplicationsCompetition`.`winner`, `ApplicationsCompetition`.`telephone`, `ApplicationsCompetition`.`category`, `ApplicationsCompetition`.`businesscase`, `ApplicationsCompetition`.`created`, `ApplicationsCompetition`.`modified`, `ApplicationsCompetition`.`countries`, `ApplicationsCompetition`.`cities`, `ApplicationsCompetition`.`open_data`, `ApplicationsCompetition`.`validated`, `ApplicationsCompetition`.`hackathome` FROM `competitions` AS `Competition` JOIN `applications_competitions` AS `ApplicationsCompetition` ON (`ApplicationsCompetition`.`application_id` = 1853 AND `ApplicationsCompetition`.`competition_id` = `Competition`.`id`) | | 0 | 0 | 1 |
| 10 | SELECT `Image`.`id`, `Image`.`created`, `Image`.`modified`, `Image`.`path`, `Image`.`name`, `Image`.`size`, `Image`.`mimetype`, `ApplicationsImage`.`id`, `ApplicationsImage`.`application_id`, `ApplicationsImage`.`image_id` FROM `images` AS `Image` JOIN `applications_images` AS `ApplicationsImage` ON (`ApplicationsImage`.`application_id` = 1853 AND `ApplicationsImage`.`image_id` = `Image`.`id`) | | 0 | 0 | 1 |
| 11 | SELECT `Video`.`id`, `Video`.`created`, `Video`.`modified`, `Video`.`url`, `Video`.`title`, `Video`.`description`, `Video`.`author`, `Video`.`thumbnail`, `Video`.`video_created`, `Video`.`length`, `Video`.`video_id`, `ApplicationsVideo`.`id`, `ApplicationsVideo`.`application_id`, `ApplicationsVideo`.`video_id`, `ApplicationsVideo`.`created`, `ApplicationsVideo`.`modified` FROM `videos` AS `Video` JOIN `applications_videos` AS `ApplicationsVideo` ON (`ApplicationsVideo`.`application_id` = 1853 AND `ApplicationsVideo`.`video_id` = `Video`.`id`) | | 0 | 0 | 1 |
| 12 | SELECT `Platform`.`id`, `Platform`.`created`, `Platform`.`modified`, `Platform`.`name`, `Platform`.`url`, `Platform`.`description`, `Platform`.`priority`, `ApplicationsPlatform`.`application_id`, `ApplicationsPlatform`.`platform_id` FROM `platforms` AS `Platform` JOIN `applications_platforms` AS `ApplicationsPlatform` ON (`ApplicationsPlatform`.`application_id` = 1853 AND `ApplicationsPlatform`.`platform_id` = `Platform`.`id`) | | 6 | 6 | 1 |
| 13 | SELECT `Store`.`id`, `Store`.`created`, `Store`.`modified`, `Store`.`name`, `Store`.`url`, `Store`.`description`, `Store`.`priority`, `ApplicationsStore`.`application_id`, `ApplicationsStore`.`store_id` FROM `stores` AS `Store` JOIN `applications_stores` AS `ApplicationsStore` ON (`ApplicationsStore`.`application_id` = 1853 AND `ApplicationsStore`.`store_id` = `Store`.`id`) | | 8 | 8 | 1 |
| 14 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`description`, `Category`.`created`, `Category`.`modified`, `Category`.`priority`, `Category`.`store_id`, `ApplicationsCategory`.`id`, `ApplicationsCategory`.`application_id`, `ApplicationsCategory`.`category_id` FROM `categories` AS `Category` JOIN `applications_categories` AS `ApplicationsCategory` ON (`ApplicationsCategory`.`application_id` = 1853 AND `ApplicationsCategory`.`category_id` = `Category`.`id`) | | 0 | 0 | 1 |
| 15 | SELECT `ApplicationsStore`.`store_id` FROM `applications_stores` AS `ApplicationsStore` WHERE `application_id` = 1853 | | 8 | 8 | 0 |
| 16 | SELECT `ApplicationsStore`.`application_id` FROM `applications_stores` AS `ApplicationsStore` WHERE `application_id` != 1853 AND store_id IN (6, 8, 11, 25, 38, 40, 42, 80) ORDER BY RAND(NOW()) ASC LIMIT 5 | | 5 | 5 | 4 |
| 17 | SELECT `Application`.`id`, `Application`.`title`, `Application`.`slug`, `Application`.`icon`, `Application`.`description` FROM `applications` AS `Application` WHERE id IN (1361, 584, 2783, 2539, 532) ORDER BY `Application`.`created` desc | | 5 | 5 | 1 |
| 18 | SELECT `ApplicationsPlatform`.`platform_id` FROM `applications_platforms` AS `ApplicationsPlatform` WHERE `application_id` = 1853 | | 6 | 6 | 0 |
| 19 | SELECT `ApplicationsPlatform`.`application_id` FROM `applications_platforms` AS `ApplicationsPlatform` WHERE `application_id` != 1853 AND platform_id IN (5, 7, 10, 11, 16, 19) ORDER BY RAND(NOW()) ASC LIMIT 5 | | 5 | 5 | 4 |
| 20 | SELECT `Application`.`id`, `Application`.`title`, `Application`.`slug`, `Application`.`icon`, `Application`.`description` FROM `applications` AS `Application` WHERE id IN (809, 2712, 1820, 385, 1612) ORDER BY `Application`.`created` desc | | 5 | 5 | 1 |
