Controller Execution Time ( Championship / OrderTables )
104 ms
Total Execution Time
Queries
0.0003
SELECT GET_LOCK('55927813330bdc1b1a14ffaff79ba15d', 300) AS ci_session_lockSpeed: 0.0003 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used
0.0008
SELECT `data`
FROM `bf_ci3_sessions`
WHERE `id` = '55927813330bdc1b1a14ffaff79ba15d'Speed: 0.0008 - Possible keys: - Key Used: - Type: - Rows: - Extra: no matching row IN const table
0.0018
SHOW TABLES FROM `hawari996_db2`
0.0004
SELECT *
FROM `bf_settings`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 43 - Extra:
0.0008
SELECT *
FROM `bf_championship`
WHERE `id` = 154Speed: 0.0008 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0016
SELECT *
FROM `bf_sponsors`
WHERE `relation_id` = 154
and `relation_type` = 8
and `sponser_type` = 1
and `deleted` =0
ORDER BY `created_on` DESC
LIMIT 6Speed: 0.0016 - Possible keys: - Key Used: - Type: ALL - Rows: 48 - Extra: Using WHERE; Using filesort
0.0005
SELECT *
FROM `bf_sponsors`
WHERE `relation_id` = 154
and `relation_type` = 8
and `sponser_type` = 2
and `deleted` =0
ORDER BY `created_on` DESC
LIMIT 6Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 48 - Extra: Using WHERE; Using filesort
0.0003
SELECT *
FROM `bf_sponsors`
WHERE `relation_id` = 154
and `relation_type` = 8
and `sponser_type` = 3
and `deleted` =0
ORDER BY `created_on` DESC
LIMIT 6Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 48 - Extra: Using WHERE; Using filesort
0.0003
SELECT number_of_groups FROM bf_championship WHERE deleted = 0 and id = 154Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0005
SELECT points_priorities FROM bf_championship WHERE id = 154Speed: 0.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0020
SELECT ct.team_id teamID, t.title Title, t.logo Logo, ct.points Points, ct.team_group teamGroup, ct.for_him_on_him, ct.for_him, ct.on_him FROM bf_champoinship_team ct LEFT JOIN bf_team t ON ct.team_id = t.id WHERE ct.deleted = 0 and ct.championship_id = 154 and ct.team_approval = 1 and ct.championship_approval = 1 and ct.team_group = 0 ORDER BY ct.`points` DESCSpeed: 0.0020 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE; Using filesort
0.0003
SELECT `points` FROM bf_champoinship_team WHERE team_id = 409 and championship_id = 154 and deleted = 0Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0005
SELECT points FROM bf_champoinship_team WHERE team_id = 509 and championship_id = 154 and deleted = 0Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0009
SELECT winner_id FROM bf_match WHERE(team_a_id = 409 and team_b_id = 509)OR (team_a_id = 509 and team_b_id = 409)and deleted = 0 and `level` = 1Speed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0003
SELECT `points` FROM bf_champoinship_team WHERE team_id = 509 and championship_id = 154 and deleted = 0Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0005
SELECT points FROM bf_champoinship_team WHERE team_id = 527 and championship_id = 154 and deleted = 0Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0006
SELECT winner_id FROM bf_match WHERE(team_a_id = 509 and team_b_id = 527)OR (team_a_id = 527 and team_b_id = 509)and deleted = 0 and `level` = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0004
SELECT `points` FROM bf_champoinship_team WHERE team_id = 527 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0005
SELECT points FROM bf_champoinship_team WHERE team_id = 550 and championship_id = 154 and deleted = 0Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0008
SELECT winner_id FROM bf_match WHERE(team_a_id = 527 and team_b_id = 550)OR (team_a_id = 550 and team_b_id = 527)and deleted = 0 and `level` = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0003
SELECT points_priorities FROM bf_championship WHERE id = 154Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0010
SELECT ct.team_id teamID, t.title Title, t.logo Logo, ct.points Points, ct.team_group teamGroup, ct.for_him_on_him, ct.for_him, ct.on_him FROM bf_champoinship_team ct LEFT JOIN bf_team t ON ct.team_id = t.id WHERE ct.deleted = 0 and ct.championship_id = 154 and ct.team_approval = 1 and ct.championship_approval = 1 and ct.team_group = 1 ORDER BY ct.`points` DESCSpeed: 0.0010 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE; Using filesort
0.0003
SELECT `points` FROM bf_champoinship_team WHERE team_id = 523 and championship_id = 154 and deleted = 0Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0004
SELECT points FROM bf_champoinship_team WHERE team_id = 546 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0005
SELECT winner_id FROM bf_match WHERE(team_a_id = 523 and team_b_id = 546)OR (team_a_id = 546 and team_b_id = 523)and deleted = 0 and `level` = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0004
SELECT `points` FROM bf_champoinship_team WHERE team_id = 546 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0004
SELECT points FROM bf_champoinship_team WHERE team_id = 416 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0009
SELECT winner_id FROM bf_match WHERE(team_a_id = 546 and team_b_id = 416)OR (team_a_id = 416 and team_b_id = 546)and deleted = 0 and `level` = 1Speed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0004
SELECT `points` FROM bf_champoinship_team WHERE team_id = 416 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0004
SELECT points FROM bf_champoinship_team WHERE team_id = 547 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0006
SELECT winner_id FROM bf_match WHERE(team_a_id = 416 and team_b_id = 547)OR (team_a_id = 547 and team_b_id = 416)and deleted = 0 and `level` = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0002
SELECT points_priorities FROM bf_championship WHERE id = 154Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0006
SELECT ct.team_id teamID, t.title Title, t.logo Logo, ct.points Points, ct.team_group teamGroup, ct.for_him_on_him, ct.for_him, ct.on_him FROM bf_champoinship_team ct LEFT JOIN bf_team t ON ct.team_id = t.id WHERE ct.deleted = 0 and ct.championship_id = 154 and ct.team_approval = 1 and ct.championship_approval = 1 and ct.team_group = 2 ORDER BY ct.`points` DESCSpeed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE; Using filesort
0.0004
SELECT `points` FROM bf_champoinship_team WHERE team_id = 548 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0006
SELECT points FROM bf_champoinship_team WHERE team_id = 422 and championship_id = 154 and deleted = 0Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0008
SELECT winner_id FROM bf_match WHERE(team_a_id = 548 and team_b_id = 422)OR (team_a_id = 422 and team_b_id = 548)and deleted = 0 and `level` = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0004
SELECT `points` FROM bf_champoinship_team WHERE team_id = 422 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0004
SELECT points FROM bf_champoinship_team WHERE team_id = 525 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0008
SELECT winner_id FROM bf_match WHERE(team_a_id = 422 and team_b_id = 525)OR (team_a_id = 525 and team_b_id = 422)and deleted = 0 and `level` = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0005
SELECT `for_him_on_him` FROM bf_champoinship_team WHERE team_id = 422 and championship_id = 154 and deleted = 0Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0004
SELECT for_him_on_him FROM bf_champoinship_team WHERE team_id = 525 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0003
SELECT `points` FROM bf_champoinship_team WHERE team_id = 525 and championship_id = 154 and deleted = 0Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0002
SELECT points FROM bf_champoinship_team WHERE team_id = 551 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0005
SELECT winner_id FROM bf_match WHERE(team_a_id = 525 and team_b_id = 551)OR (team_a_id = 551 and team_b_id = 525)and deleted = 0 and `level` = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0003
SELECT `for_him_on_him` FROM bf_champoinship_team WHERE team_id = 525 and championship_id = 154 and deleted = 0Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0005
SELECT for_him_on_him FROM bf_champoinship_team WHERE team_id = 551 and championship_id = 154 and deleted = 0Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE
0.0004
SELECT facebook_url FROM bf_optionsSpeed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra:
0.0002
SELECT twitter_url FROM bf_optionsSpeed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra:
0.0001
SELECT INstagram_url FROM bf_optionsSpeed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra:
0.0019
SELECT
M.id,
M.code CodeM,
M.relation_type ,
M.match_date ,
M.group ,
M.level ,
TA.title TitleTeamA,
TA.id TeamAID,
TB.title TitleTeamB,
TB.id TeamBID,
C.title Championship,
'' Stadium,
0 StaduimId
FROM
`bf_match` M INNER JOIN
`bf_team` TA INNER JOIN
`bf_team` TB INNER JOIN
`bf_championship` C
ON
M.`team_a_id` = TA.`id` and
M.`team_b_id` = TB.`id` and
M.`relation_id` = C.`id`
WHERE M.`relation_id` = 154 and M.deleted = 0 and M.status = 1 ORDER BY M.match_dateSpeed: 0.0019 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: Using filesort
0.0008
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 409 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 409 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 409 OR team_b_id = 409)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0011
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 509 and relation_id = 154 and level = 1Speed: 0.0011 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 509 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 509 OR team_b_id = 509)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0006
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 527 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0006
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 527 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 527 OR team_b_id = 527)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0006
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 550 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 550 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 550 OR team_b_id = 550)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0006
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 523 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 523 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 523 OR team_b_id = 523)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 546 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0006
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 546 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 546 OR team_b_id = 546)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0005
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 416 and relation_id = 154 and level = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 416 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 416 OR team_b_id = 416)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 547 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0009
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 547 and relation_id = 154 and level = 1Speed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0010
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 547 OR team_b_id = 547)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0010 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0009
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 548 and relation_id = 154 and level = 1Speed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 548 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 548 OR team_b_id = 548)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 422 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 422 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 422 OR team_b_id = 422)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 525 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0006
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 525 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0008
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 525 OR team_b_id = 525)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0007
SELECTCOUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 551 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0006
SELECTCOUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 551 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
0.0011
SELECTCOUNT(id) numDraws FROM bf_match WHERE deleted = 0 and status = 1 and(team_a_id = 551 OR team_b_id = 551)and ideal = 1 and relation_id = 154 and level = 1Speed: 0.0011 - Possible keys: - Key Used: - Type: ALL - Rows: 530 - Extra: Using WHERE
Array
(
[form_save] => Array
(
[description] => Save any form in the admin area.
[action] => $("input[name=save]").click();return false;
)
[create_new] => Array
(
[description] => Create a new record in the module.
[action] => window.location.href=$("a#create_new").attr("href");
)
[select_all] => Array
(
[description] => Select all records in an index page.
[action] => $("table input[type=checkbox]").click();return false;
)
[delete] => Array
(
[description] => Delete the record(s).
[action] => $("#delete-me.btn-danger").click();
)
[module_index] => Array
(
[description] => Return to the index of the current module.
[action] => window.location.href=$("a#list").attr("href");
)
[goto_content] => Array
(
[description] => Jump to the Content context.
[action] => window.location.href=$("#tb_content").attr("href")
)
[goto_reports] => Array
(
[description] => Jump to the Reports context.
[action] => window.location.href=$("#tb_reports").attr("href")
)
[goto_settings] => Array
(
[description] => Jump to the Settings context.
[action] => window.location.href=$("#tb_settings").attr("href")
)
[goto_developer] => Array
(
[description] => Jump to the Developer context.
[action] => window.location.href=$("#tb_developer").attr("href")
)
)