CRM Software Logo

A panel of Microsoft Dynamics CRM experts provide reviews and opinions to aid professionals with the CRM selection process.

 
 
 
 
Show Buttons
Hide Buttons
"120" 62 | 0.0001 | enabled | not cached | 11118 | SELECT * FROM crmwp_posts WHERE ID = 17694 LIMIT 1 63 | 0.0001 | enabled | not cached | 8377 | SELECT * FROM crmwp_posts WHERE ID = 3034 LIMIT 1 64 | 0.0001 | enabled | not cached | 3681 | SELECT * FROM crmwp_users WHERE ID = '50' 65 | 0.0003 | enabled | not cached | 7021 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (50) ORDER BY umeta_id ASC 66 | 0.0006 | enabled | not cached | 577 | SELECT post_id FROM crmwp_postmeta WHERE meta_key = "author_id" AND meta_value="50" 67 | 0.0001 | enabled | not cached | 10394 | SELECT * FROM crmwp_posts WHERE ID = 1278 LIMIT 1 68 | 0.0006 | enabled | not cached | 577 | SELECT post_id FROM crmwp_postmeta WHERE meta_key = "author_id" AND meta_value="1" 69 | 0.0001 | enabled | not cached | 9069 | SELECT * FROM crmwp_posts WHERE ID = 17460 LIMIT 1 70 | 0.0001 | enabled | not cached | 3661 | SELECT * FROM crmwp_users WHERE ID = '113' 71 | 0.0002 | enabled | not cached | 5747 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (113) ORDER BY umeta_id ASC 72 | 0.0006 | enabled | not cached | 579 | SELECT post_id FROM crmwp_postmeta WHERE meta_key = "author_id" AND meta_value="113" 73 | 0.0001 | enabled | not cached | 9459 | SELECT * FROM crmwp_posts WHERE ID = 13721 LIMIT 1 74 | 0.0001 | enabled | not cached | 3707 | SELECT * FROM crmwp_users WHERE ID = '112' 75 | 0.0003 | enabled | not cached | 5627 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (112) ORDER BY umeta_id ASC 76 | 0.0006 | enabled | not cached | 579 | SELECT post_id FROM crmwp_postmeta WHERE meta_key = "author_id" AND meta_value="112" 77 | 0.0001 | enabled | not cached | 9813 | SELECT * FROM crmwp_posts WHERE ID = 13745 LIMIT 1 78 | 0.0001 | enabled | not cached | 3697 | SELECT * FROM crmwp_users WHERE ID = '104' 79 | 0.0003 | enabled | not cached | 6057 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (104) ORDER BY umeta_id ASC 80 | 0.0006 | enabled | not cached | 579 | SELECT post_id FROM crmwp_postmeta WHERE meta_key = "author_id" AND meta_value="104" 81 | 0.0001 | enabled | not cached | 10053 | SELECT * FROM crmwp_posts WHERE ID = 11045 LIMIT 1 82 | 0.0001 | enabled | not cached | 3703 | SELECT * FROM crmwp_users WHERE ID = '135' 83 | 0.0002 | enabled | not cached | 5547 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (135) ORDER BY umeta_id ASC 84 | 0.0006 | enabled | not cached | 579 | SELECT post_id FROM crmwp_postmeta WHERE meta_key = "author_id" AND meta_value="135" 85 | 0.0001 | enabled | not cached | 11265 | SELECT * FROM crmwp_posts WHERE ID = 21890 LIMIT 1 86 | 0.0001 | enabled | not cached | 3684 | SELECT * FROM crmwp_users WHERE ID = '53' 87 | 0.0003 | enabled | not cached | 8688 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (53) ORDER BY umeta_id ASC 88 | 0.0006 | enabled | not cached | 577 | SELECT post_id FROM crmwp_postmeta WHERE meta_key = "author_id" AND meta_value="53" 89 | 0.0001 | enabled | not cached | 11525 | SELECT * FROM crmwp_posts WHERE ID = 1582 LIMIT 1 90 | 0.0003 | enabled | not cached | 1062 | SELECT crmwp_posts.ID FROM crmwp_posts WHERE 1=1 AND crmwp_posts.post_type = 'post' AND ((crmwp_posts.post_status = 'publish')) ORDER BY crmwp_posts.post_date DESC LIMIT 0, 10 91 | 0.0005 | enabled | not cached | 57231 | SELECT crmwp_posts.* FROM crmwp_posts WHERE ID IN (29880,29870,29866,29857,29859,29849,29836,29830,29813,29811) 92 | 0.0016 | enabled | not cached | 28932 | SELECT t.*, tt.*, tr.object_id FROM crmwp_terms AS t INNER JOIN crmwp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN crmwp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (29811, 29813, 29830, 29836, 29849, 29857, 29859, 29866, 29870, 29880) ORDER BY t.name ASC 93 | 0.0008 | enabled | not cached | 19564 | SELECT post_id, meta_key, meta_value FROM crmwp_postmeta WHERE post_id IN (29811,29813,29830,29836,29849,29857,29859,29866,29870,29880) ORDER BY meta_id ASC 94 | 0.0006 | enabled | not cached | 23119 | SELECT * FROM crmwp_postmeta WHERE post_id IN (29880,29870,29866,29857,29859,29849,29836,29830,29813,29811) 95 | 0.0001 | enabled | not cached | 3679 | SELECT * FROM crmwp_users WHERE ID = '85' 96 | 0.0003 | enabled | not cached | 6132 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (85) ORDER BY umeta_id ASC 97 | 0.0001 | enabled | not cached | 3690 | SELECT * FROM crmwp_users WHERE ID = '12' 98 | 0.0002 | enabled | not cached | 4988 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (12) ORDER BY umeta_id ASC 99 | 0.0001 | enabled | not cached | 3686 | SELECT * FROM crmwp_users WHERE ID = '145' 100 | 0.0002 | enabled | not cached | 5257 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (145) ORDER BY umeta_id ASC 101 | 0.0001 | enabled | not cached | 3682 | SELECT * FROM crmwp_users WHERE ID = '23' 102 | 0.0003 | enabled | not cached | 6870 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (23) ORDER BY umeta_id ASC 103 | 0.0001 | enabled | not cached | 3730 | SELECT * FROM crmwp_users WHERE ID = '140' 104 | 0.0002 | enabled | not cached | 4879 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (140) ORDER BY umeta_id ASC 105 | 0.0001 | enabled | not cached | 3690 | SELECT * FROM crmwp_users WHERE ID = '147' 106 | 0.0002 | enabled | not cached | 4171 | SELECT user_id, meta_key, meta_value FROM crmwp_usermeta WHERE user_id IN (147) ORDER BY umeta_id ASC 107 | 0.001 | enabled | not cached | 17485 | SELECT t.*, tt.* FROM crmwp_terms AS t INNER JOIN crmwp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND t.term_id NOT IN (684,2015) AND tt.count > 0 ORDER BY t.name ASC 108 | 0.0001 | enabled | not cached | 1358 | SELECT term_id, meta_key, meta_value FROM crmwp_termmeta WHERE term_id IN (14,965,24,631,25,2529,3530,3543,26,518,30,3996,32,27,28,22,23,2283,3531,3953,16,1649,1679,13,3631,3628,3703,15,165,1678,416,1011,33,948,1067,31,1461,863,2296,406,2213,3326,4098,195,1582,680,1523,29,424) ORDER BY meta_id ASC 109 | 0.0004 | enabled | not cached | 3517 | SELECT t.*, tt.* FROM crmwp_terms AS t INNER JOIN crmwp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category') AND tt.count > 0 ORDER BY t.name ASC 110 | 0.0001 | enabled | not cached | 1157 | SELECT term_id, meta_key, meta_value FROM crmwp_termmeta WHERE term_id IN (2) ORDER BY meta_id ASC 111 | 0.0004 | enabled | not cached | 16126 | SELECT * FROM crmwp_links INNER JOIN crmwp_term_relationships AS tr ON (crmwp_links.link_id = tr.object_id) INNER JOIN crmwp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 2 ) AND taxonomy = 'link_category' ORDER BY link_name ASC 112 | 0.0001 | enabled | not cached | 548 | SELECT option_value FROM crmwp_options WHERE option_name = 'links_recently_updated_time' LIMIT 1 113 | 0.0001 | enabled | not cached | 591 | SELECT COUNT(tt.term_id) FROM crmwp_term_taxonomy AS tt WHERE tt.taxonomy = 'link_category' 114 | 0.0001 | enabled | not cached | 564 | SELECT tt.term_id FROM crmwp_term_taxonomy AS tt WHERE tt.taxonomy = 'link_category' 115 | 0.0001 | enabled | not cached | 1124 | SELECT src_or_tx_name, role_name FROM crmwp_role_scope_rs WHERE role_type = 'rs' AND topic = 'term' AND max_scope = 'term' AND obj_or_term_id = '0' 116 | 0.0001 | enabled | not cached | 1642 | SELECT role_name, obj_or_term_id, require_for AS assign_for, inherited_from FROM crmwp_role_scope_rs WHERE role_type = 'rs' AND topic = 'term' AND max_scope = 'term' AND src_or_tx_name = 'link_category' AND require_for IN ('entity', 'both') 117 | 0.0004 | enabled | not cached | 3500 | SELECT DISTINCT t.*, tt.* FROM crmwp_term_taxonomy AS tt INNER JOIN crmwp_terms AS t ON t.term_id = tt.term_id WHERE tt.taxonomy = 'link_category' ORDER BY t.name 118 | 0.0004 | enabled | not cached | 16167 | SELECT * FROM crmwp_links INNER JOIN crmwp_term_relationships AS tr ON (crmwp_links.link_id = tr.object_id) INNER JOIN crmwp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND ( ( ( ( ( ( 1=1 ) ) ) ) ) ) AND link_visible = 'Y' AND ( tt.term_id = 2 ) AND taxonomy = 'link_category' ORDER BY link_name ASC 119 | 0.0082 | enabled | not cached | 16430 | SELECT t.*, tt.* FROM crmwp_terms AS t INNER JOIN crmwp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND tt.count > 0 ORDER BY tt.count DESC LIMIT 45 120 | 0.0001 | enabled | not cached | 1317 | SELECT term_id, meta_key, meta_value FROM crmwp_termmeta WHERE term_id IN (3,4,364,175,216,6,34,3914,35,48,225,61,9,46,362,18,17,3903,5,101,47,7,2174,21,537,1749,19,11,734,62,102,166,196,698,3928,36,208,354,3904,92,2212,686,291,157,118) ORDER BY meta_id ASC 121 | 0.1703 | enabled | not cached | 16950 | SELECT DISTINCT t.*, tt.*, COUNT(p.ID) AS count FROM crmwp_terms AS t INNER JOIN crmwp_term_taxonomy AS tt ON tt.term_id = t.term_id AND tt.taxonomy = 'post_tag' INNER JOIN crmwp_term_relationships AS tagr ON tagr.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN crmwp_posts AS p ON p.ID = tagr.object_id WHERE p.ID IN (SELECT crmwp_posts.ID FROM crmwp_posts WHERE 1=1 ) GROUP BY t.term_id ORDER BY count DESC LIMIT 45 122 | 0.0005 | enabled | not cached | 8216 | SELECT option_name, option_value FROM crmwp_options WHERE option_name LIKE 'csbwfs_%' 123 | 0.0001 | enabled | cached | 8246 | SELECT option_name, option_value FROM crmwp_options WHERE option_name LIKE 'csbwfs_%' -->