| # | query | time | rows |
|---|
| 1 | SELECT * FROM (`sessions`) WHERE `session_id` = 'm2k4uspeg82obicclaog4q28a4' LIMIT 0, 1 | 0.652 ms | 0 |
| 2 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.471 ms | 1 |
| 3 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.477 ms | 0 |
| 4 | SELECT `nodes`.* FROM (`nodes`) WHERE `nodes`.`id` = '75344' ORDER BY `nodes`.`id` ASC LIMIT 0, 1 | 176.127 ms | 1 |
| 5 | UPDATE `nodes` SET `views` = 222 WHERE `id` = 75344 | 4.346 ms | 1 |
| 6 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tickers' GROUP BY `term`.`name` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 1.251 ms | 0 |
| 7 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tags' GROUP BY `term`.`name` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 1.309 ms | 3 |
| 8 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tickers' AND `user_id` = 4852 GROUP BY `term`.`id` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 1.302 ms | 0 |
| 9 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tags' AND `user_id` = 4852 GROUP BY `term`.`id` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 1.432 ms | 1 |
| 10 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.408 ms | 1 |
| 11 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.623 ms | 0 |
| 12 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.435 ms | 1 |
| 13 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.407 ms | 0 |
| 14 | SELECT `screen_categories`.* FROM (`screen_categories`) WHERE user_id is null ORDER BY `screen_categories`.`sequence` ASC | 0.533 ms | 7 |
| 15 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.699 ms | 1 |
| 16 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.428 ms | 0 |
| 17 | SELECT `config`.* FROM (`config`) WHERE `name` = 'site_message' ORDER BY `config`.`id` ASC LIMIT 0, 1 | 0.333 ms | 1 |
| 18 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.383 ms | 1 |
| 19 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 1.218 ms | 0 |
| 20 | SELECT `users`.* FROM (`users`) WHERE `users`.`id` = 4852 ORDER BY `users`.`id` ASC LIMIT 0, 1 | 0.722 ms | 1 |
| 21 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.498 ms | 1 |
| 22 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.466 ms | 0 |
| 23 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tags' AND `user_id` = 4852 GROUP BY `term`.`id` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 0.621 ms | 1 |
| 24 | SELECT `screens`.* FROM (`screens`) WHERE `node_id` = 75344 AND `is_pro` = 1 ORDER BY `screens`.`name` ASC LIMIT 0, 1 | 0.575 ms | 0 |
| 25 | SELECT `profiles`.* FROM (`profiles`) WHERE `profiles`.`id` = 4852 ORDER BY `profiles`.`id` ASC LIMIT 0, 1 | 0.504 ms | 1 |
| 26 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tickers' GROUP BY `term`.`name` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 0.619 ms | 0 |
| 27 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tickers' GROUP BY `term`.`name` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 0.604 ms | 0 |
| 28 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `node_id` = 75344 AND `taxon` = 'tags' GROUP BY `term`.`name` ORDER BY `node_taxon_terms`.`id` ASC LIMIT 0, 10 | 0.755 ms | 3 |
| 29 | SELECT `user`.`id` AS `user:id`, `user`.`profile_id` AS `user:profile_id`, `user`.`uuid` AS `user:uuid`, `user`.`facebook_id` AS `user:facebook_id`, `user`.`email_hash` AS `user:email_hash`, `user`.`active` AS `user:active`, `user`.`email` AS `user:email`, `user`.`username` AS `user:username`, `user`.`password` AS `user:password`, `user`.`logins` AS `user:logins`, `user`.`last_login` AS `user:last_login`, `user`.`last_free_trial` AS `user:last_free_trial`, `user`.`registration_date` AS `user:registration_date`, `user`.`chart_preferences` AS `user:chart_preferences`, `user`.`solus` AS `user:solus`, `user`.`mailchimp` AS `user:mailchimp`, `user`.`terms` AS `user:terms`, `user`.`ip` AS `user:ip`, `user`.`session_id` AS `user:session_id`, `user`.`removed_permissions` AS `user:removed_permissions`, `user`.`comment_preferences` AS `user:comment_preferences`, `user`.`monitor_preferences` AS `user:monitor_preferences`, `user`.`suspended_until` AS `user:suspended_until`, `user`.`suspend_count` AS `user:suspend_count`, `user`.`marketing_source` AS `user:marketing_source`, `user`.`has_done` AS `user:has_done`, `user`.`edition` AS `user:edition`, `user:profile`.`id` AS `user:profile:id`, `user:profile`.`user_id` AS `user:profile:user_id`, `user:profile`.`image` AS `user:profile:image`, `user:profile`.`company_image` AS `user:profile:company_image`, `user:profile`.`company_name` AS `user:profile:company_name`, `user:profile`.`company_email` AS `user:profile:company_email`, `user:profile`.`company_phone` AS `user:profile:company_phone`, `user:profile`.`realname` AS `user:profile:realname`, `user:profile`.`profilename` AS `user:profile:profilename`, `user:profile`.`occupation` AS `user:profile:occupation`, `user:profile`.`promote_what` AS `user:profile:promote_what`, `user:profile`.`phone` AS `user:profile:phone`, `user:profile`.`address` AS `user:profile:address`, `user:profile`.`hometown` AS `user:profile:hometown`, `user:profile`.`county` AS `user:profile:county`, `user:profile`.`country` AS `user:profile:country`, `user:profile`.`show_email` AS `user:profile:show_email`, `user:profile`.`postcode` AS `user:profile:postcode`, `user:profile`.`about` AS `user:profile:about`, `user:profile`.`company_about` AS `user:profile:company_about`, `user:profile`.`interests` AS `user:profile:interests`, `user:profile`.`timehorizon` AS `user:profile:timehorizon`, `user:profile`.`riskappetite` AS `user:profile:riskappetite`, `user:profile`.`strategy` AS `user:profile:strategy`, `user:profile`.`signature` AS `user:profile:signature`, `user:profile`.`signature_text` AS `user:profile:signature_text`, `user:profile`.`web` AS `user:profile:web`, `user:profile`.`blog_name` AS `user:profile:blog_name`, `user:profile`.`disclaimer` AS `user:profile:disclaimer`, `user:profile`.`updated_at` AS `user:profile:updated_at`, `user:profile`.`rss` AS `user:profile:rss`, `user:profile`.`twitter` AS `user:profile:twitter`, `user:profile`.`linkedin` AS `user:profile:linkedin`, `user:profile`.`location` AS `user:profile:location`, `user:profile`.`Q_TradeFrequency` AS `user:profile:Q_TradeFrequency`, `user:profile`.`Q_TradeRule` AS `user:profile:Q_TradeRule`, `user:profile`.`Q_HoldingPeriod` AS `user:profile:Q_HoldingPeriod`, `user:profile`.`Q_PortfolioSize` AS `user:profile:Q_PortfolioSize`, `user:profile`.`Q_Diversification` AS `user:profile:Q_Diversification`, `user:profile`.`Q_Derivatives` AS `user:profile:Q_Derivatives`, `nodes`.* FROM (`nodes`) LEFT JOIN `users` AS `user` ON (`user`.`id` = `nodes`.`user_id`) LEFT JOIN `profiles` AS `user:profile` ON (`user:profile`.`id` = `user`.`profile_id`) WHERE `type` = 'comment' AND `parent_id` = 75344 ORDER BY `id` DESC LIMIT 0, 20 | 1.762 ms | 0 |
| 30 | SELECT `nodes`.* FROM (`nodes`) WHERE user_id IS NULL AND `created_at` > '2013-07-20 5:05:08' AND `type` != 'draft' ORDER BY `nodes`.`id` ASC | 1.167 ms | 0 |
| 31 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.381 ms | 1 |
| 32 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.355 ms | 0 |
| 33 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 4852 | 0.427 ms | 2 |
| 34 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (2,1004) ORDER BY `roles`.`id` ASC | 0.503 ms | 2 |
| 35 | SELECT `node_taxon_terms`.*, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `peer_id` = 4852 AND `user_id` > 0 AND `term_id` = 0 AND `node_id` = 0 AND `taxon` = 'favorite' ORDER BY `node_taxon_terms`.`id` ASC | 4.186 ms | 379 |
| 36 | SELECT *, `peer`.`id` AS `peer:id`, `peer`.`profile_id` AS `peer:profile_id`, `peer`.`uuid` AS `peer:uuid`, `peer`.`facebook_id` AS `peer:facebook_id`, `peer`.`email_hash` AS `peer:email_hash`, `peer`.`active` AS `peer:active`, `peer`.`email` AS `peer:email`, `peer`.`username` AS `peer:username`, `peer`.`password` AS `peer:password`, `peer`.`logins` AS `peer:logins`, `peer`.`last_login` AS `peer:last_login`, `peer`.`last_free_trial` AS `peer:last_free_trial`, `peer`.`registration_date` AS `peer:registration_date`, `peer`.`chart_preferences` AS `peer:chart_preferences`, `peer`.`solus` AS `peer:solus`, `peer`.`mailchimp` AS `peer:mailchimp`, `peer`.`terms` AS `peer:terms`, `peer`.`ip` AS `peer:ip`, `peer`.`session_id` AS `peer:session_id`, `peer`.`removed_permissions` AS `peer:removed_permissions`, `peer`.`comment_preferences` AS `peer:comment_preferences`, `peer`.`monitor_preferences` AS `peer:monitor_preferences`, `peer`.`suspended_until` AS `peer:suspended_until`, `peer`.`suspend_count` AS `peer:suspend_count`, `peer`.`marketing_source` AS `peer:marketing_source`, `peer`.`has_done` AS `peer:has_done`, `peer`.`edition` AS `peer:edition`, `term`.`id` AS `term:id`, `term`.`ticker` AS `term:ticker`, `term`.`RIC` AS `term:RIC`, `term`.`PI` AS `term:PI`, `term`.`ISIN` AS `term:ISIN`, `term`.`name` AS `term:name`, `term`.`alt_name` AS `term:alt_name`, `term`.`reuters_name` AS `term:reuters_name`, `term`.`google_name` AS `term:google_name`, `term`.`exchange` AS `term:exchange`, `term`.`RepoNo` AS `term:RepoNo`, `term`.`is_stock` AS `term:is_stock`, `term`.`type` AS `term:type`, `term`.`allow_landing` AS `term:allow_landing`, `term`.`alias_id` AS `term:alias_id`, `term`.`image` AS `term:image`, `term`.`delisted` AS `term:delisted`, `term`.`updated_at` AS `term:updated_at`, `term`.`owner_id` AS `term:owner_id`, `term`.`category_id` AS `term:category_id`, `term`.`sentiment` AS `term:sentiment`, `term`.`definition` AS `term:definition`, `term`.`banned` AS `term:banned`, `term`.`banned_words` AS `term:banned_words`, `term`.`tickerize` AS `term:tickerize`, `term`.`snippet` AS `term:snippet`, `term`.`is_client` AS `term:is_client`, `term`.`updated_at_other` AS `term:updated_at_other`, `term`.`cached_at` AS `term:cached_at` FROM (`node_taxon_terms`) LEFT JOIN `users` AS `peer` ON (`peer`.`id` = `node_taxon_terms`.`peer_id`) LEFT JOIN `terms` AS `term` ON (`term`.`id` = `node_taxon_terms`.`term_id`) WHERE `taxon` = 'favorite' AND `node_taxon_terms`.`user_id` = 4852 AND `peer_id` > 0 AND `node_id` = 0 AND `term_id` = 0 AND `parent_id` = 0 ORDER BY `peer`.`username` ASC | 2.670 ms | 5 |
| 37 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.495 ms | 1 |
| 38 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.467 ms | 0 |
| 39 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.309 ms | 1 |
| 40 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.389 ms | 0 |
| 41 | SELECT `role_id` AS `id` FROM (`roles_users`) WHERE `roles_users`.`user_id` = 0 | 0.457 ms | 1 |
| 42 | SELECT `roles`.* FROM (`roles`) WHERE `roles`.`id` IN (0) ORDER BY `roles`.`id` ASC | 0.393 ms | 0 |
| ? | 42 total | 212.159 ms | 418 |
|---|
Source: http://www.stockopedia.co.uk/content/3-reasons-why-property-investors-should-consider-stocks-75344/
brandy michael pineda charles taylor carl crawford mad cow disease rampart nick collins
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.