Doug Kiley 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
Doug Kiley 1 Pointer Doolys Kempt 0.500 11 20 10 0 1 4 4

Round Results

Date Home Away POS Round 1 Round 2 Round 3 Round 4
2018-11-26 Doolys Rockingham A Doolys Kempt 11 W Randy Wells W Calvin Wood W Larry Kent W Mike Wood
2018-11-05 Railbirds A Doolys Kempt 11 L Howie Sheppard W Pat Sampson L Sonny Hart L Rob Schwartz
2018-10-15 Doolys Kempt Doolys Rockingham B 3 L Morris Boudreau W Tim Kays W Chris Murphy L Tim MacLean
2018-09-24 Doolys Burnside B Doolys Kempt 12 W Bill Kean L Jamie Murphy L Don Goodyear L Derrick Goodyear
2018-09-17 Doolys Kempt Doolys Portland A 4 W Jim Lachapelle W Charlie Boutilier L Doug Eldershaw L Andrew McCracken
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' => 1143
'After Sanitise:' =>
'_a' => document
'doc_id' => 20
'id' => 1143

SESSION:
'__client' =>
'ip_address' => 3.80.177.176
'useragent' => CCBot/2.0 (https://commoncrawl.org/faq/)
'session_start' => 1544716620
'session_last' => 1544716620
'language' => en-CA
'__system' =>
'token' => 8ee6eb870ddece1e5db14782ffc96a81

MySQLi
Queries (79):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `cc6_CubeCart_sessions` WHERE cc6_CubeCart_sessions.session_id = 'm02c75c0v9nf6tbis8f7q2re02' LIMIT 1; -- (0.00063300132751465 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','3.80.177.176','','m02c75c0v9nf6tbis8f7q2re02','1544716620','1544716620','CCBot/2.0 (https://commoncrawl.org/faq/)'); -- (0.076919078826904 sec) [NOT CACHED]
[3] SELECT * FROM `cc6_CubeCart_lang_strings` WHERE cc6_CubeCart_lang_strings.language = 'en-CA' ; -- (0.00069093704223633 sec) [CACHE WRITE]
[4] SELECT * FROM `cc6_CubeCart_hooks` WHERE cc6_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00065898895263672 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.00074076652526855 sec) [CACHE WRITE]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `cc6_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00056982040405273 sec) [CACHE WRITE]
[7] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'logos' LIMIT 1; -- (0.00081706047058105 sec) [CACHE WRITE]
[8] SELECT FOUND_ROWS() as Count; -- (0.00034785270690918 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.00066208839416504 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.00084686279296875 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.00056695938110352 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.00055694580078125 sec) [CACHE WRITE]
[14] SELECT * FROM `cc6_CubeCart_currency` WHERE cc6_CubeCart_currency.code = 'CAD' ; -- (0.00050902366638184 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.00055503845214844 sec) [CACHE WRITE]
[17] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.00042510032653809 sec) [CACHE WRITE]
[18] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.00040006637573242 sec) [CACHE WRITE]
[19] select distinct id, name from cc6_MensLeague_teams where id != 1 and id != 2; -- (0.00095200538635254 sec) [CACHE WRITE]
[20] select distinct (date_format(date,"%Y")) as date from cc6_MensLeague_schedule order by date desc; -- (0.00081610679626465 sec) [CACHE WRITE]
[21] select distinct date from cc6_MensLeague_schedule order by date desc; -- (0.0015029907226562 sec) [CACHE WRITE]
[22] set @player=0, @count=0; -- (0.00013399124145508 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 = 1143 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.016839981079102 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 = 1143 order by date desc; -- (0.003741979598999 sec) [CACHE WRITE]
[25] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00043082237243652 sec) [CACHE WRITE]
[26] SELECT * FROM `cc6_CubeCart_currency` WHERE cc6_CubeCart_currency.active = '1' ; -- (0.00057220458984375 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.00059390068054199 sec) [CACHE WRITE]
[28] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'login' ; -- (0.00052213668823242 sec) [CACHE WRITE]
[29] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'register' ; -- (0.00049495697021484 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.00061297416687012 sec) [CACHE WRITE]
[31] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.00038909912109375 sec) [CACHE WRITE]
[32] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00049495697021484 sec) [CACHE WRITE]
[33] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'certificates' ; -- (0.00049495697021484 sec) [CACHE WRITE]
[34] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'search' ; -- (0.00052285194396973 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.0017778873443604 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.00056695938110352 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.00054502487182617 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.00056290626525879 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.00053906440734863 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.00054311752319336 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.00054311752319336 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.00056791305541992 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.00054311752319336 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.00054621696472168 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.00054597854614258 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.00054407119750977 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.00054717063903809 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.00054502487182617 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.00054383277893066 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.00054788589477539 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.00048708915710449 sec) [CACHE WRITE]
[55] SELECT FOUND_ROWS() as Count; -- (0.00020718574523926 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.00040483474731445 sec) [CACHE WRITE]
[57] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'contact' ; -- (0.00050902366638184 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.00061702728271484 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.00061511993408203 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.0006098747253418 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.00060510635375977 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.00066304206848145 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.0006110668182373 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.00060915946960449 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.00060820579528809 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.0006110668182373 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.00064587593078613 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.00061893463134766 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.0005950927734375 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.00060677528381348 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.00060415267944336 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.00063991546630859 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.00059795379638672 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.00060105323791504 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.00060200691223145 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.00060606002807617 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.0006251335144043 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.00060510635375977 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 (-313283200%)
Cache (File): Disabled
Cache Used: 0.00 KB of 4.00 KB (0.00%) [Clear Cache]
Page Load Time:
0.345105 seconds