Greg Johnston 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
Greg Johnston 1 Pointer Locas 0.472 17 36 17 0 0 4 0

Round Results

Date Home Away POS Round 1 Round 2 Round 3 Round 4
2018-11-26 Doolys Portland A Locas 10 W Iain Campbell L Jim Chute L Doug Eldershaw L Pierre Therrien
2018-11-19 Doolys Burnside B Locas 10 W Derrick Goodyear L Don Goodyear W Jamie Murphy W Clayton Milly
2018-11-12 Doolys Rockingham A Locas 11 L Calvin Wood W Terry Miller W Larry Kent W Mike Wood
2018-11-05 Doolys Portland B Locas 10 L Joe Clark W Jeff Nielsen L Ross Thibault L Doug Laffin
2018-10-29 Maritime B Locas 10 W Dave Phelps W Clarence Rose L Steve Hipson L Shane Demolitor
2018-10-22 Buddys A Locas 10 W Dustin Reaney L Wendell Power W Jim Sheppard L John Burbidge
2018-10-15 Railbirds A Locas 10 W Pat Sampson L Rob Schwartz W Wayne Lampman W Howie Sheppard
2018-10-01 Doolys Rockingham B Locas 10 L Donnie Downey L Tom Dempsey W Randy Bourque L Mardy Walsh
2018-09-24 Doolys Bedford A Locas 11 L Richard Brown W Paul Kidney L Ted Dehmel L Brent Urquhart
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' => 209
'After Sanitise:' =>
'_a' => document
'doc_id' => 20
'id' => 209

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

MySQLi
Queries (79):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `cc6_CubeCart_sessions` WHERE cc6_CubeCart_sessions.session_id = 'th0fhid6u8oc5df7emkjrt8up2' LIMIT 1; -- (0.00062799453735352 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','','th0fhid6u8oc5df7emkjrt8up2','1544634010','1544634010','CCBot/2.0 (https://commoncrawl.org/faq/)'); -- (0.074917078018188 sec) [NOT CACHED]
[3] SELECT * FROM `cc6_CubeCart_lang_strings` WHERE cc6_CubeCart_lang_strings.language = 'en-CA' ; -- (0.00077295303344727 sec) [CACHE WRITE]
[4] SELECT * FROM `cc6_CubeCart_hooks` WHERE cc6_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00068497657775879 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.00068092346191406 sec) [CACHE WRITE]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `cc6_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00058388710021973 sec) [CACHE WRITE]
[7] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'logos' LIMIT 1; -- (0.00088095664978027 sec) [CACHE WRITE]
[8] SELECT FOUND_ROWS() as Count; -- (0.0003509521484375 sec) [NOT CACHED]
[9] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00060415267944336 sec) [CACHE WRITE]
[10] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'livehelp' AND cc6_CubeCart_modules.status = '1' ; -- (0.00068497657775879 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.0008540153503418 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.00091695785522461 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.00088596343994141 sec) [CACHE WRITE]
[14] SELECT * FROM `cc6_CubeCart_currency` WHERE cc6_CubeCart_currency.code = 'CAD' ; -- (0.00090384483337402 sec) [CACHE WRITE]
[15] SELECT * FROM `cc6_CubeCart_documents` WHERE cc6_CubeCart_documents.doc_id = '20' AND cc6_CubeCart_documents.doc_status = '1' ; -- (0.00092101097106934 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.00089597702026367 sec) [CACHE WRITE]
[17] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.0006721019744873 sec) [CACHE WRITE]
[18] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'social' AND cc6_CubeCart_modules.status = '1' ; -- (0.00070285797119141 sec) [CACHE WRITE]
[19] select distinct id, name from cc6_MensLeague_teams where id != 1 and id != 2; -- (0.0015239715576172 sec) [CACHE WRITE]
[20] select distinct (date_format(date,"%Y")) as date from cc6_MensLeague_schedule order by date desc; -- (0.0012960433959961 sec) [CACHE WRITE]
[21] select distinct date from cc6_MensLeague_schedule order by date desc; -- (0.0043530464172363 sec) [CACHE WRITE]
[22] set @player=0, @count=0; -- (0.0001378059387207 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 = 209 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.016754865646362 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 = 209 order by date desc; -- (0.0040791034698486 sec) [CACHE WRITE]
[25] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00045895576477051 sec) [CACHE WRITE]
[26] SELECT * FROM `cc6_CubeCart_currency` WHERE cc6_CubeCart_currency.active = '1' ; -- (0.00057816505432129 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.0005640983581543 sec) [CACHE WRITE]
[28] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'login' ; -- (0.00050997734069824 sec) [CACHE WRITE]
[29] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'register' ; -- (0.00049805641174316 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.00057005882263184 sec) [CACHE WRITE]
[31] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.00039386749267578 sec) [CACHE WRITE]
[32] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00049304962158203 sec) [CACHE WRITE]
[33] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'certificates' ; -- (0.00049686431884766 sec) [CACHE WRITE]
[34] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'search' ; -- (0.00052714347839355 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.0018079280853271 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.00054717063903809 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.00054597854614258 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.00054287910461426 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.00056815147399902 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.00054478645324707 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.00054311752319336 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.00053620338439941 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.00053620338439941 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.00057005882263184 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.00054311752319336 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.00054502487182617 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.00054407119750977 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.00055098533630371 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.00054383277893066 sec) [CACHE WRITE]
[54] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.00045990943908691 sec) [CACHE WRITE]
[55] SELECT FOUND_ROWS() as Count; -- (0.00020599365234375 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.00040316581726074 sec) [CACHE WRITE]
[57] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'contact' ; -- (0.00051212310791016 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.00060701370239258 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.00061392784118652 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.00064682960510254 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.00060105323791504 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.00060200691223145 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.00060701370239258 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.00060510635375977 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.00064182281494141 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.00060582160949707 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.00060486793518066 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.00063204765319824 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.00061297416687012 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.00059390068054199 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.00060510635375977 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.00060486793518066 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.00060296058654785 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.00060009956359863 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.00060200691223145 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.00014710426330566 sec) [CACHE WRITE]

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