| 0.0001 |
SELECT GET_LOCK('e8113d8fece329a39641965042f783fd', 300) AS ci_session_lockSpeed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
| 0.0010 |
SELECT `data`
FROM `bf_ci3_sessions`
WHERE `id` = 'e8113d8fece329a39641965042f783fd'Speed: 0.0010 - Possible keys: - Key Used: - Type: - Rows: - Extra: no matching row IN const table |
| 0.0016 |
SHOW TABLES FROM `hawari996_db2` |
| 0.0008 |
SELECT *
FROM `bf_settings`Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 43 - Extra: |
| 0.0015 |
SELECT *
FROM `bf_championship`
WHERE `id` = 154Speed: 0.0015 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0018 |
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.0018 - Possible keys: - Key Used: - Type: ALL - Rows: 49 - Extra: Using WHERE; Using filesort |
| 0.0004 |
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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 49 - Extra: Using WHERE; Using filesort |
| 0.0002 |
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.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 49 - 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.0004 |
SELECT points_priorities FROM bf_championship WHERE id = 154Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0043 |
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.0043 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE; Using filesort |
| 0.0004 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 409 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 = 509 and championship_id = 154 and deleted = 0Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0004 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 509 and championship_id = 154 and deleted = 0Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT points FROM bf_champoinship_team WHERE team_id = 527 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 527 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT points FROM bf_champoinship_team WHERE team_id = 550 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0001 |
SELECT points_priorities FROM bf_championship WHERE id = 154Speed: 0.0001 - 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 = 1 ORDER BY ct.`points` DESCSpeed: 0.0006 - 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.0002 |
SELECT points FROM bf_champoinship_team WHERE team_id = 546 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 546 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT points FROM bf_champoinship_team WHERE team_id = 416 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0021 |
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.0021 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0003 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 416 and championship_id = 154 and deleted = 0Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0003 |
SELECT points FROM bf_champoinship_team WHERE team_id = 547 and championship_id = 154 and deleted = 0Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0001 |
SELECT points_priorities FROM bf_championship WHERE id = 154Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 |
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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE; Using filesort |
| 0.0002 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 548 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT points FROM bf_champoinship_team WHERE team_id = 422 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 422 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT points FROM bf_champoinship_team WHERE team_id = 525 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT `points` FROM bf_champoinship_team WHERE team_id = 525 and championship_id = 154 and deleted = 0Speed: 0.0002 - 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.0007 |
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.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0002 |
SELECT `for_him_on_him` FROM bf_champoinship_team WHERE team_id = 525 and championship_id = 154 and deleted = 0Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 299 - Extra: Using WHERE |
| 0.0002 |
SELECT for_him_on_him 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.0003 |
SELECT facebook_url FROM bf_optionsSpeed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: |
| 0.0003 |
SELECT twitter_url FROM bf_optionsSpeed: 0.0003 - 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.0021 |
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.0021 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: Using filesort |
| 0.0009 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 409 and relation_id = 154 and level = 1Speed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0007 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 409 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 509 and relation_id = 154 and level = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0007 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 509 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0006 |
SELECT COUNT(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.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0004 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 527 and relation_id = 154 and level = 1Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0006 |
SELECT COUNT(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: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0006 |
SELECT COUNT(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: 531 - Extra: Using WHERE |
| 0.0007 |
SELECT COUNT(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: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0004 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 523 and relation_id = 154 and level = 1Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0006 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 523 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 546 and relation_id = 154 and level = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 546 and relation_id = 154 and level = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 416 and relation_id = 154 and level = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0004 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 547 and relation_id = 154 and level = 1Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0004 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 547 and relation_id = 154 and level = 1Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0006 |
SELECT COUNT(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.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0004 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 548 and relation_id = 154 and level = 1Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0004 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 548 and relation_id = 154 and level = 1Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0007 |
SELECT COUNT(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: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 422 and relation_id = 154 and level = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0006 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 422 and relation_id = 154 and level = 1Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0005 |
SELECT COUNT(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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0008 |
SELECT COUNT(id) numWins FROM bf_match WHERE deleted = 0 and status = 1 and winner_id = 525 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0008 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 525 and relation_id = 154 and level = 1Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0018 |
SELECT COUNT(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.0018 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0007 |
SELECT COUNT(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: 531 - Extra: Using WHERE |
| 0.0007 |
SELECT COUNT(id) numLoss FROM bf_match WHERE deleted = 0 and status = 1 and loser_id = 551 and relation_id = 154 and level = 1Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0007 |
SELECT COUNT(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.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE |
| 0.0460 |
Total Query Execution Time |
