Greg Shelly 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 Shelly 1 Pointer Railbirds B 0.417 17 36 15 0 0 5 0

Round Results

Date Home Away POS Round 1 Round 2 Round 3 Round 4
2018-11-26 Maritime A Railbirds B 3 L Dave Richard L Paul Benoit L Norm Best L Bill Hiltz
2018-11-19 Doolys Sackville Railbirds B 11 L Terry Nelson L Gary Steele L Dan Moffatt L Trevor ONeil
2018-11-05 Doolys Burnside B Railbirds B 11 W Bill Kean L Derrick Goodyear L Don Goodyear W Jamie Murphy
2018-10-29 Doolys Rockingham B Railbirds B 11 L Randy Bourque W Mardy Walsh W Donnie Downey W Tom Dempsey
2018-10-22 Doolittles Railbirds B 12 W Dave Raisebeck W Jeremy Daley W Robert Smith L Ryan Milligan
2018-10-15 Spryfield Legion Railbirds B 10 W Hughie Sutherland W Joey Robart L Tony Leblanc W John Hurshman
2018-10-01 Railbirds B Doolys Bedford A 1 L Brent Urquhart W Derek Cole W Max Maher W Ted Dehmel
2018-09-24 Resolutes Railbirds B 12 L Jimmy Murphy L Bill Murphy L Johnny Evans L Dave McEachern
2018-09-17 Locas Railbirds B 12 L Gavin Burlingham L Gary Kelly L Sledge Hammer W Ghost Locas1
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' => 989
'After Sanitise:' =>
'_a' => document
'doc_id' => 20
'id' => 989

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

MySQLi
Queries (79):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `cc6_CubeCart_sessions` WHERE cc6_CubeCart_sessions.session_id = '4n9ruhuk7dfvcstubgq7bv1pr3' 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','3.80.177.176','','4n9ruhuk7dfvcstubgq7bv1pr3','1544716653','1544716653','CCBot/2.0 (https://commoncrawl.org/faq/)'); -- (0.072880029678345 sec) [NOT CACHED]
[3] SELECT * FROM `cc6_CubeCart_lang_strings` WHERE cc6_CubeCart_lang_strings.language = 'en-CA' ; -- (0.00069594383239746 sec) [CACHE WRITE]
[4] SELECT * FROM `cc6_CubeCart_hooks` WHERE cc6_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00068783760070801 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.00067400932312012 sec) [CACHE WRITE]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `cc6_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00057005882263184 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.00034594535827637 sec) [NOT CACHED]
[9] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00061583518981934 sec) [CACHE WRITE]
[10] SELECT `folder` FROM `cc6_CubeCart_modules` WHERE cc6_CubeCart_modules.module = 'livehelp' AND cc6_CubeCart_modules.status = '1' ; -- (0.00067615509033203 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.00053501129150391 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.00056791305541992 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.00056004524230957 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.00053501129150391 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.00062012672424316 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.00090909004211426 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.0015518665313721 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 = 989 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.016955137252808 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 = 989 order by date desc; -- (0.0040559768676758 sec) [CACHE WRITE]
[25] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00043511390686035 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.00056600570678711 sec) [CACHE WRITE]
[28] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'login' ; -- (0.00055217742919922 sec) [CACHE WRITE]
[29] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'register' ; -- (0.00049686431884766 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.00057220458984375 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.00053596496582031 sec) [CACHE WRITE]
[33] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'certificates' ; -- (0.00049710273742676 sec) [CACHE WRITE]
[34] SELECT `path` FROM `cc6_CubeCart_seo_urls` WHERE cc6_CubeCart_seo_urls.type = 'search' ; -- (0.00052499771118164 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.0018329620361328 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.00054812431335449 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.00055313110351562 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.00057220458984375 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.00054383277893066 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.00054097175598145 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.00054502487182617 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.0005650520324707 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.00054502487182617 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.00054287910461426 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.00056982040405273 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.00054192543029785 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.0005490779876709 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.00054597854614258 sec) [CACHE WRITE]
[54] SELECT SQL_CALC_FOUND_ROWS `array` FROM `cc6_CubeCart_config` WHERE cc6_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.00046205520629883 sec) [CACHE WRITE]
[55] SELECT FOUND_ROWS() as Count; -- (0.00020313262939453 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.0011370182037354 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.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.00061202049255371 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.000640869140625 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.00061488151550293 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.0006108283996582 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.00068807601928711 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.00061392784118652 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.0006110668182373 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.00061607360839844 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.00059890747070312 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.00064706802368164 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.0006098747253418 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.00060892105102539 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.00060915946960449 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.00060796737670898 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.00064492225646973 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.00060296058654785 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.00015115737915039 sec) [CACHE WRITE]

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