Dave Elias Statistics

Currently viewing stats from Current Season on All Dates

Select match results from      on    

Overview

Name Class Team AVG Points Games 1PW 2PW 4GW MaxC CurC
Dave Elias 2 Pointer Doolys Rockingham B 0.292 14 24 0 7 0 3 0

Round Results

Date Home Away POS Round 1 Round 2 Round 3 Round 4
2018-11-26 Doolys Rockingham B Doolys Burnside A 6 W Jason Ross L Jeff Saulnier L Kyle Richard L Derek Levesque
2018-11-19 Doolys Rockingham B Doolys Portland B 6 L Marcel Verette W Brian Smart Sr L Mike McNaughton L Doug Redden
2018-11-12 Doolys Rockingham B Doolys Bedford B 6 W Richard Drysdale L Gerry Lunn L Jeremy Croft L Dan Lundrigan
2018-11-05 Doolys Rockingham B Maritime A 6 L Christian Coffey L Brian Flynn W Ed Skinner L Richard Moore
2018-10-29 Doolys Rockingham B Railbirds B 6 L Nick Barker L Adam Cormier L Ray Billard L Steve Young
2018-10-22 Doolys Rockingham B Resolutes 6 L Jonathan Underwood W Joe Belliveau W Jordan Hollett W Paul Murphy
Average (Avg) - 1 Pt Wins (1PW) - 2 Pt Wins (2PW) - 4 Game Wins (4GW) - Maximum Consecutive Wins (MaxCon) - Current Consecutive Wins (CurC) - Position (POS)

PHP:
[Notice] /var/www/html/creativefreedom.biz/classes/cubecart.class.php:539 - Undefined variable: iv
GET:
'Before Sanitise:' =>
'_a' => document
'doc_id' => 20
'id' => 1233
'After Sanitise:' =>
'_a' => document
'doc_id' => 20
'id' => 1233

SESSION:
'__client' =>
'ip_address' => 54.167.15.6
'useragent' => CCBot/2.0 (https://commoncrawl.org/faq/)
'session_start' => 1544658752
'session_last' => 1544658752
'language' => en-CA
'__system' =>
'token' => 67c5d8262a18fdf788ad241d482a1156

MySQLi
Queries (79):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `cc6_CubeCart_sessions` WHERE cc6_CubeCart_sessions.session_id = 'k8hn0hgdagb7h611o0e2u8s0f5' LIMIT 1; -- (0.0006411075592041 sec) [NOT CACHED]
[2] INSERT INTO `cc6_CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`) VALUES ('0','0','54.167.15.6','','k8hn0hgdagb7h611o0e2u8s0f5','1544658752','1544658752','CCBot/2.0 (https://commoncrawl.org/faq/)'); -- (0.11254000663757 sec) [NOT CACHED]
[3] SELECT * FROM `cc6_CubeCart_lang_strings` WHERE cc6_CubeCart_lang_strings.language = 'en-CA' ; -- (0.00069713592529297 sec) [CACHE WRITE]
[4] SELECT * FROM `cc6_CubeCart_hooks` WHERE cc6_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00066995620727539 sec) [CACHE WRITE]
[5] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `cc6_CubeCart_code_snippet` WHERE cc6_CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00067710876464844 sec) [CACHE WRITE]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `cc6_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00057101249694824 sec) [CACHE WRITE]
[7] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'logos' LIMIT 1; -- (0.00084900856018066 sec) [CACHE WRITE]
[8] SELECT FOUND_ROWS() as Count; -- (0.00034618377685547 sec) [NOT CACHED]
[9] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00061297416687012 sec) [CACHE WRITE]
[10] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'livehelp' AND cc6_CubeCart_modules.status = '1' ; -- (0.00063991546630859 sec) [CACHE WRITE]
[11] SELECT path FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '20' ; -- (0.00054597854614258 sec) [CACHE WRITE]
[12] SELECT path FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '20' ; -- (0.00055885314941406 sec) [CACHE WRITE]
[13] SELECT path FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '20' ; -- (0.00056195259094238 sec) [CACHE WRITE]
[14] SELECT * FROM `cc6_CubeCart_currency` WHERE cc6_CubeCart_currency.code = 'CAD' ; -- (0.00051093101501465 sec) [CACHE WRITE]
[15] SELECT * FROM `cc6_CubeCart_documents` WHERE cc6_CubeCart_documents.doc_id = '20' AND cc6_CubeCart_documents.doc_status = '1' ; -- (0.00053000450134277 sec) [CACHE WRITE]
[16] SELECT path FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '20' ; -- (0.00055813789367676 sec) [CACHE WRITE]
[17] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.00042605400085449 sec) [CACHE WRITE]
[18] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.00043487548828125 sec) [CACHE WRITE]
[19] select distinct id, name from cc6_MensLeague_teams where id != 1 and id != 2; -- (0.00091409683227539 sec) [CACHE WRITE]
[20] select distinct (date_format(date,"%Y")) as date from cc6_MensLeague_schedule order by date desc; -- (0.0011041164398193 sec) [CACHE WRITE]
[21] select distinct date from cc6_MensLeague_schedule order by date desc; -- (0.0023558139801025 sec) [CACHE WRITE]
[22] set @player=0, @count=0; -- (0.00013995170593262 sec) [CACHE WRITE]
[23] select (@rank := if(@points = points, @rank +1, if(@points := points, @rank + 1, @rank + 1 ))) as rank, er.* from (select cc6_MensLeague_players.id as `id`, cc6_MensLeague_players.name as `name`, cc6_MensLeague_players_result.date as `date`, cc6_MensLeague_players_result.player as `player`, sum(cc6_MensLeague_players_result.points) as `points`, sum(cc6_MensLeague_players_result.4gw) as `4gw`, sum(cc6_MensLeague_players_result.games) as `games`, @1pw := sum(cc6_MensLeague_players_result.1pw) as `1pw`, @2pw := sum(cc6_MensLeague_players_result.2pw) as `2pw`, @wins := (@2pw+@1pw) as `wins`, @avg := format((sum(cc6_MensLeague_players_result.1pw)+sum(cc6_MensLeague_players_result.2pw))/sum(cc6_MensLeague_players_result.games),3) as `avg`, (select name from cc6_MensLeague_teams where cc6_MensLeague_teams.id = team) as `team`, (select max(@count := if(outcome = 2 and player = cc6_MensLeague_players.id, @count+1, 0)) from cc6_MensLeague_rounds ignore index (outcome) where player = cc6_MensLeague_players.id order by id) as `maxcon`, (select sum(id > coalesce((select max(id) from cc6_MensLeague_rounds p2 where (p2.player,p2.outcome) = (cc6_MensLeague_players.id,1)),0)) as current from cc6_MensLeague_rounds p use index(outcome) where (player,outcome) = (cc6_MensLeague_players.id,2)) as `curcon` from cc6_MensLeague_players join cc6_MensLeague_players_result on cc6_MensLeague_players_result.player = cc6_MensLeague_players.id where cc6_MensLeague_players.id = 1233 and cc6_MensLeague_players_result.date group by `id`) er cross join (select @rank := 0, @points := -1) params order by points desc, avg desc, games desc, id desc limit 1; -- (0.017316102981567 sec) [CACHE WRITE]
[24] select cc6_MensLeague_records.date as date, position, r1_pts, r2_pts, r3_pts, r4_pts, (select name from cc6_MensLeague_players where cc6_MensLeague_players.id = cc6_MensLeague_records.r1_vs) as r1_vs, (select name from cc6_MensLeague_players where cc6_MensLeague_players.id = cc6_MensLeague_records.r2_vs) as r2_vs, (select name from cc6_MensLeague_players where cc6_MensLeague_players.id = cc6_MensLeague_records.r3_vs) as r3_vs, (select name from cc6_MensLeague_players where cc6_MensLeague_players.id = cc6_MensLeague_records.r4_vs) as r4_vs, (select name from cc6_MensLeague_teams where cc6_MensLeague_teams.id = cc6_MensLeague_records.home) as home, (select name from cc6_MensLeague_teams where cc6_MensLeague_teams.id = cc6_MensLeague_records.away) as away from cc6_MensLeague_records ignore index(position) inner join cc6_MensLeague_schedule on cc6_MensLeague_schedule.id = cc6_MensLeague_records.matchup where player = 1233 order by date desc; -- (0.0038740634918213 sec) [CACHE WRITE]
[25] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'languages' LIMIT 1; -- (0.0004279613494873 sec) [CACHE WRITE]
[26] SELECT * FROM `cc6_CubeCart_currency` WHERE cc6_CubeCart_currency.active = '1' ; -- (0.00057697296142578 sec) [CACHE WRITE]
[27] SELECT path FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '20' ; -- (0.00056099891662598 sec) [CACHE WRITE]
[28] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'login' ; -- (0.00055289268493652 sec) [CACHE WRITE]
[29] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'register' ; -- (0.00049614906311035 sec) [CACHE WRITE]
[30] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `cc6_CubeCart_category` WHERE cc6_CubeCart_category.cat_parent_id = '0' AND cc6_CubeCart_category.status = '1' AND cc6_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00057601928710938 sec) [CACHE WRITE]
[31] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.00039410591125488 sec) [CACHE WRITE]
[32] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00049614906311035 sec) [CACHE WRITE]
[33] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'certificates' ; -- (0.00049591064453125 sec) [CACHE WRITE]
[34] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'search' ; -- (0.00052595138549805 sec) [CACHE WRITE]
[35] SELECT * FROM `cc6_CubeCart_documents` WHERE cc6_CubeCart_documents.doc_parent_id = '0' AND cc6_CubeCart_documents.doc_status = '1' AND cc6_CubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.0018301010131836 sec) [CACHE WRITE]
[36] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '2' ; -- (0.00056195259094238 sec) [CACHE WRITE]
[37] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '8' ; -- (0.00054693222045898 sec) [CACHE WRITE]
[38] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '5' ; -- (0.00054502487182617 sec) [CACHE WRITE]
[39] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '6' ; -- (0.00057196617126465 sec) [CACHE WRITE]
[40] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '7' ; -- (0.00054407119750977 sec) [CACHE WRITE]
[41] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '9' ; -- (0.00054287910461426 sec) [CACHE WRITE]
[42] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '10' ; -- (0.00054502487182617 sec) [CACHE WRITE]
[43] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '11' ; -- (0.000640869140625 sec) [CACHE WRITE]
[44] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '12' ; -- (0.00056815147399902 sec) [CACHE WRITE]
[45] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '13' ; -- (0.00054407119750977 sec) [CACHE WRITE]
[46] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '20' ; -- (0.00054717063903809 sec) [CACHE WRITE]
[47] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '14' ; -- (0.00054383277893066 sec) [CACHE WRITE]
[48] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '21' ; -- (0.00054502487182617 sec) [CACHE WRITE]
[49] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '15' ; -- (0.00054407119750977 sec) [CACHE WRITE]
[50] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '16' ; -- (0.0005490779876709 sec) [CACHE WRITE]
[51] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '17' ; -- (0.00054407119750977 sec) [CACHE WRITE]
[52] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '18' ; -- (0.00054502487182617 sec) [CACHE WRITE]
[53] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'doc' AND cc6_CubeCart_seo_urls.item_id = '19' ; -- (0.00054311752319336 sec) [CACHE WRITE]
[54] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.0004580020904541 sec) [CACHE WRITE]
[55] SELECT FOUND_ROWS() as Count; -- (0.0001990795135498 sec) [NOT CACHED]
[56] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.folder = 'Contact_Form' LIMIT 1; -- (0.00040388107299805 sec) [CACHE WRITE]
[57] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'contact' ; -- (0.00050997734069824 sec) [CACHE WRITE]
[58] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00087594985961914 sec) [NOT CACHED]
[59] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00061893463134766 sec) [NOT CACHED]
[60] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00063896179199219 sec) [NOT CACHED]
[61] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.0006108283996582 sec) [NOT CACHED]
[62] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060606002807617 sec) [NOT CACHED]
[63] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060391426086426 sec) [NOT CACHED]
[64] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060701370239258 sec) [NOT CACHED]
[65] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00064206123352051 sec) [NOT CACHED]
[66] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00061392784118652 sec) [NOT CACHED]
[67] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00059795379638672 sec) [NOT CACHED]
[68] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00059914588928223 sec) [NOT CACHED]
[69] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060606002807617 sec) [NOT CACHED]
[70] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00063705444335938 sec) [NOT CACHED]
[71] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.0006110668182373 sec) [NOT CACHED]
[72] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.0005950927734375 sec) [NOT CACHED]
[73] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060415267944336 sec) [NOT CACHED]
[74] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060391426086426 sec) [NOT CACHED]
[75] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00062394142150879 sec) [NOT CACHED]
[76] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060510635375977 sec) [NOT CACHED]
[77] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060105323791504 sec) [NOT CACHED]
[78] SELECT * FROM `cc6_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `cc6_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE cc6_CubeCart_inventory.status = '1' -- (0.00060105323791504 sec) [NOT CACHED]
[79] SELECT SQL_CALC_FOUND_ROWS `name`, `product_id`, `quantity`, `price`, `sale_price` FROM `cc6_CubeCart_inventory` WHERE cc6_CubeCart_inventory.status = '1' ORDER BY popularity DESC LIMIT 10; -- (0.00014805793762207 sec) [CACHE WRITE]

Memory: Peak Usage / Max (%):
2.99MB / -1 (-313574400%)
Cache (File): Disabled
Cache Used: 0.00 KB of 4.00 KB (0.00%) [Clear Cache]
Page Load Time:
-0.578576 seconds