General
| Name |
Open Connections |
Max Connections |
| HALO |
1 |
INF |
| HALO_DEV |
2 |
INF |
SQL Queries
| |
Name |
Records |
Time |
Usage |
Datasource |
Source |
Line |
Cached |
|
|
qSettings
|
1 |
1.42 ms |
94% |
HALO |
/var/www/html/halo/services/admin.cfc |
28 |
No |
SQL (Merged Parameters)
SELECT siteId, siteName, masterSiteId, siteTemplate, companyName, domain, phone, phoneClickToCall, newellVendor, googleAnalyticsAccount, googleAnalyticsProfileId, roiId,
facebookId, twitterId, blogFeed,
adminIpList, maxLookupPerDay
FROM settings
WHERE domain = 'www.junkauto.com'
SQL (Explicit Parameters)
SELECT siteId, siteName, masterSiteId, siteTemplate, companyName, domain, phone, phoneClickToCall, newellVendor, googleAnalyticsAccount, googleAnalyticsProfileId, roiId,
facebookId, twitterId, blogFeed,
adminIpList, maxLookupPerDay
FROM settings
WHERE domain = {type: "CF_SQL_VARCHAR", value: 'www.junkauto.com'}
Query column usage
the following columns are NOT used:
googleAnalyticsProfileId
|
|
|
getTestimonials
|
1 |
1.39 ms |
100% |
HALO |
/var/www/html/halo/services/main.cfc |
152 |
No |
SQL
SELECT IFNULL(COUNT(*), 0) AS total
FROM testimonials
Query column usage
All columns are used
|
|
|
getTestimonials
|
6 |
0.926 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
161 |
No |
SQL (Merged Parameters)
SELECT testimonial, name, location
FROM testimonials
ORDER BY 'id'
LIMIT 1, 6
SQL (Explicit Parameters)
SELECT testimonial, name, location
FROM testimonials
ORDER BY {type: "CF_SQL_VARCHAR", value: 'id'}
LIMIT {type: "CF_SQL_INTEGER", value: 1}, {type: "CF_SQL_INTEGER", value: 6}
Query column usage
None of the columns are used
|
|
|
getTweets
|
21 |
0 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
177 |
Yes |
SQL (Merged Parameters)
SELECT tweet
FROM tweets
WHERE siteId = 1
ORDER BY id
LIMIT 21
SQL (Explicit Parameters)
SELECT tweet
FROM tweets
WHERE siteId = {type: "CF_SQL_INTEGER", value: 1}
ORDER BY id
LIMIT {type: "CF_SQL_INTEGER", value: 21}
Query column usage
None of the columns are used
|
|
|
qLatestOffers
|
21 |
0 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
132 |
Yes |
SQL (Merged Parameters)
SELECT CONVERT(TRIM(CONCAT(vehicleYear, ' ', make)) USING latin1) AS vehicle, city, pickupState, quotedValue
FROM quotes
WHERE quotedValue > 200
AND LENGTH(city) <= 16
ORDER BY id DESC, dateCreated DESC
LIMIT 21
SQL (Explicit Parameters)
SELECT CONVERT(TRIM(CONCAT(vehicleYear, ' ', make)) USING latin1) AS vehicle, city, pickupState, quotedValue
FROM quotes
WHERE quotedValue > 200
AND LENGTH(city) <= 16
ORDER BY id DESC, dateCreated DESC
LIMIT {type: "CF_SQL_INTEGER", value: 21}
Query column usage
None of the columns are used
|
|
|
qSettings
|
1 |
1.1 ms |
94% |
HALO |
/var/www/html/halo/services/admin.cfc |
28 |
No |
SQL (Merged Parameters)
SELECT siteId, siteName, masterSiteId, siteTemplate, companyName, domain, phone, phoneClickToCall, newellVendor, googleAnalyticsAccount, googleAnalyticsProfileId, roiId,
facebookId, twitterId, blogFeed,
adminIpList, maxLookupPerDay
FROM settings
WHERE domain = 'www.junkauto.com'
SQL (Explicit Parameters)
SELECT siteId, siteName, masterSiteId, siteTemplate, companyName, domain, phone, phoneClickToCall, newellVendor, googleAnalyticsAccount, googleAnalyticsProfileId, roiId,
facebookId, twitterId, blogFeed,
adminIpList, maxLookupPerDay
FROM settings
WHERE domain = {type: "CF_SQL_VARCHAR", value: 'www.junkauto.com'}
Query column usage
the following columns are NOT used:
googleAnalyticsProfileId
|
|
|
getTestimonials
|
1 |
0.798 ms |
100% |
HALO |
/var/www/html/halo/services/main.cfc |
152 |
No |
SQL
SELECT IFNULL(COUNT(*), 0) AS total
FROM testimonials
Query column usage
All columns are used
|
|
|
getTestimonials
|
6 |
0.864 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
161 |
No |
SQL (Merged Parameters)
SELECT testimonial, name, location
FROM testimonials
ORDER BY 'id'
LIMIT 2, 6
SQL (Explicit Parameters)
SELECT testimonial, name, location
FROM testimonials
ORDER BY {type: "CF_SQL_VARCHAR", value: 'id'}
LIMIT {type: "CF_SQL_INTEGER", value: 2}, {type: "CF_SQL_INTEGER", value: 6}
Query column usage
None of the columns are used
|
|
|
getTweets
|
21 |
0 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
177 |
Yes |
SQL (Merged Parameters)
SELECT tweet
FROM tweets
WHERE siteId = 1
ORDER BY id
LIMIT 21
SQL (Explicit Parameters)
SELECT tweet
FROM tweets
WHERE siteId = {type: "CF_SQL_INTEGER", value: 1}
ORDER BY id
LIMIT {type: "CF_SQL_INTEGER", value: 21}
Query column usage
None of the columns are used
|
|
|
qLatestOffers
|
21 |
0 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
132 |
Yes |
SQL (Merged Parameters)
SELECT CONVERT(TRIM(CONCAT(vehicleYear, ' ', make)) USING latin1) AS vehicle, city, pickupState, quotedValue
FROM quotes
WHERE quotedValue > 200
AND LENGTH(city) <= 16
ORDER BY id DESC, dateCreated DESC
LIMIT 21
SQL (Explicit Parameters)
SELECT CONVERT(TRIM(CONCAT(vehicleYear, ' ', make)) USING latin1) AS vehicle, city, pickupState, quotedValue
FROM quotes
WHERE quotedValue > 200
AND LENGTH(city) <= 16
ORDER BY id DESC, dateCreated DESC
LIMIT {type: "CF_SQL_INTEGER", value: 21}
Query column usage
None of the columns are used
|
|
|
qVehicleYears
|
40 |
1.1 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
55 |
No |
SQL (Merged Parameters)
SELECT vehicleYear
FROM vehicleYears
WHERE vehicleYear <= 2026
ORDER BY vehicleYear
SQL (Explicit Parameters)
SELECT vehicleYear
FROM vehicleYears
WHERE vehicleYear <= {type: "CF_SQL_INTEGER", value: 2026}
ORDER BY vehicleYear
Query column usage
None of the columns are used
|
|
|
getTestimonials
|
1 |
0.771 ms |
100% |
HALO |
/var/www/html/halo/services/main.cfc |
152 |
No |
SQL
SELECT IFNULL(COUNT(*), 0) AS total
FROM testimonials
Query column usage
All columns are used
|
|
|
getTestimonials
|
9 |
0.961 ms |
0% |
HALO |
/var/www/html/halo/services/main.cfc |
161 |
No |
SQL (Merged Parameters)
SELECT testimonial, name, location
FROM testimonials
ORDER BY 'id'
LIMIT 1, 10
SQL (Explicit Parameters)
SELECT testimonial, name, location
FROM testimonials
ORDER BY {type: "CF_SQL_VARCHAR", value: 'id'}
LIMIT {type: "CF_SQL_INTEGER", value: 1}, {type: "CF_SQL_INTEGER", value: 10}
Query column usage
None of the columns are used
|
|
|