John MacTavish 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
John MacTavish 2 Pointer Doolys Bedford A 0.475 31 40 7 12 1 4 0

Round Results

Date Home Away POS Round 1 Round 2 Round 3 Round 4
2018-11-26 Doolys Bedford A Supercue 5 W Roger Lohnes W Mike Bangay L Craig Dixon L Nick MacDonald
2018-11-19 Maritime A Doolys Bedford A 14 W Moe Sutherland L Dave Richard L Brian White L Tim Brown
2018-11-12 Doolys Bedford A Oasis 6 L Andrew Davis L Chris Kelly W Eric DeWolfe W Norm Leaman
2018-11-05 Doolys Portland A Doolys Bedford A 16 L Allen Giles W Joe Mckay L Barry Chaisson L Mike Rice
2018-10-29 Doolys Bedford A Doolittles 7 L Damien Caines L Allan Irvine W Yarnell Arsenault W Wayne Bowser
2018-10-22 Maritime B Doolys Bedford A 11 W Dave Phelps W Mike Corkery W Mike DortJr. W Frank Symonds
2018-10-15 Doolys Bedford A Doolys Rockingham A 7 L Eric Boudreau L James McBurnie L Lorne Logan L Frank OShea
2018-10-01 Railbirds B Doolys Bedford A 14 W John Snyder L Nick Barker L Adam Cormier W Dana Murphy
2018-09-24 Doolys Bedford A Locas 5 L Steve Belshaw W Sheldon Clyke W Tyson Beals L Brad Smith
2018-09-17 Buddys A Doolys Bedford A 11 L Dustin Reaney W Wendell Power W Chris Longaphy W Rob Major
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' => 593
'After Sanitise:' =>
'_a' => document
'doc_id' => 20
'id' => 593

SESSION:
'__client' =>
'ip_address' => 54.234.228.78
'useragent' => CCBot/2.0 (https://commoncrawl.org/faq/)
'session_start' => 1544633916
'session_last' => 1544633916
'language' => en-CA
'__system' =>
'token' => b673a3bbfd36c60df334575373defdfa

MySQLi
Queries (79):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `cc6_CubeCart_sessions` WHERE cc6_CubeCart_sessions.session_id = 't2vnf21kumtvie53gqjoi643p6' LIMIT 1; -- (0.00064802169799805 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.234.228.78','','t2vnf21kumtvie53gqjoi643p6','1544633916','1544633916','CCBot/2.0 (https://commoncrawl.org/faq/)'); -- (0.072643041610718 sec) [NOT CACHED]
[3] SELECT * FROM `cc6_CubeCart_lang_strings` WHERE cc6_CubeCart_lang_strings.language = 'en-CA' ; -- (0.00075006484985352 sec) [CACHE WRITE]
[4] SELECT * FROM `cc6_CubeCart_hooks` WHERE cc6_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00068187713623047 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.00066208839416504 sec) [CACHE WRITE]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `cc6_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00058984756469727 sec) [CACHE WRITE]
[7] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'logos' LIMIT 1; -- (0.00087404251098633 sec) [CACHE WRITE]
[8] SELECT FOUND_ROWS() as Count; -- (0.00034189224243164 sec) [NOT CACHED]
[9] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00061988830566406 sec) [CACHE WRITE]
[10] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'livehelp' AND cc6_CubeCart_modules.status = '1' ; -- (0.00068521499633789 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.00085806846618652 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.00091290473937988 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.00056099891662598 sec) [CACHE WRITE]
[14] SELECT * FROM `cc6_CubeCart_currency` WHERE cc6_CubeCart_currency.code = 'CAD' ; -- (0.00050711631774902 sec) [CACHE WRITE]
[15] SELECT * FROM `cc6_CubeCart_documents` WHERE cc6_CubeCart_documents.doc_id = '20' AND cc6_CubeCart_documents.doc_status = '1' ; -- (0.00053310394287109 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.00055909156799316 sec) [CACHE WRITE]
[17] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.00042200088500977 sec) [CACHE WRITE]
[18] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.0003960132598877 sec) [CACHE WRITE]
[19] select distinct id, name from cc6_MensLeague_teams where id != 1 and id != 2; -- (0.0009000301361084 sec) [CACHE WRITE]
[20] select distinct (date_format(date,"%Y")) as date from cc6_MensLeague_schedule order by date desc; -- (0.00086402893066406 sec) [CACHE WRITE]
[21] select distinct date from cc6_MensLeague_schedule order by date desc; -- (0.0015268325805664 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 = 593 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.016942024230957 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 = 593 order by date desc; -- (0.004133939743042 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.00057101249694824 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.00056004524230957 sec) [CACHE WRITE]
[28] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'login' ; -- (0.0005190372467041 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.00058317184448242 sec) [CACHE WRITE]
[31] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.00038981437683105 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.00049304962158203 sec) [CACHE WRITE]
[34] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'search' ; -- (0.00052809715270996 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.0017950534820557 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.00057101249694824 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.00054383277893066 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.00056815147399902 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.00053691864013672 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.0005340576171875 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.00054121017456055 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.00054192543029785 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.00054192543029785 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.00054383277893066 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.00054097175598145 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.00054788589477539 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.00054001808166504 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.00054097175598145 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.00056886672973633 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.00054693222045898 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.00054097175598145 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.00054502487182617 sec) [CACHE WRITE]
[54] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.00048398971557617 sec) [CACHE WRITE]
[55] SELECT FOUND_ROWS() as Count; -- (0.0002140998840332 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.00040602684020996 sec) [CACHE WRITE]
[57] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'contact' ; -- (0.00051307678222656 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.00061511993408203 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.0006108283996582 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.00060796737670898 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.0006101131439209 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.00064396858215332 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.00061392784118652 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.00060796737670898 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.00060701370239258 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.0006098747253418 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.0006411075592041 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.00061488151550293 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.0006098747253418 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.00060796737670898 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.00060701370239258 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.00062990188598633 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.00059700012207031 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.00059700012207031 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.00059986114501953 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.00060200691223145 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.00062799453735352 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.00060701370239258 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.00014996528625488 sec) [CACHE WRITE]

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