0.0068 |
SELECT GET_LOCK('9d2fdb5795890d07696344f3d1036070', 300) AS ci_session_lockSpeed: 0.0068 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
0.0032 |
SELECT `data`
FROM `bf_ci3_sessions`
WHERE `id` = '9d2fdb5795890d07696344f3d1036070'Speed: 0.0032 - Possible keys: - Key Used: - Type: - Rows: - Extra: no matching row IN const table |
0.0060 |
SHOW TABLES FROM `hawari996_db2` |
0.0039 |
SELECT *
FROM `bf_settings`Speed: 0.0039 - Possible keys: - Key Used: - Type: ALL - Rows: 43 - Extra: |
0.0071 |
SELECT *
FROM `bf_match`
WHERE `status` = 1
and `deleted` =0
ORDER BY `created_on` DESCSpeed: 0.0071 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE; Using filesort |
0.0058 |
SELECT * FROM bf_match WHERE deleted = 0 and status = 1 ORDER BY created_on DESC LIMIT 48, 24Speed: 0.0058 - Possible keys: - Key Used: - Type: ALL - Rows: 531 - Extra: Using WHERE; Using filesort |
0.0038 |
SELECT facebook_url FROM bf_optionsSpeed: 0.0038 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: |
0.0039 |
SELECT twitter_url FROM bf_optionsSpeed: 0.0039 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: |
0.0040 |
SELECT INstagram_url FROM bf_optionsSpeed: 0.0040 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: |
0.0037 |
SELECT title FROM `bf_team` WHERE `id` = 554 and deleted = 0Speed: 0.0037 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0003 |
SELECT title FROM `bf_team` WHERE `id` = 443 and deleted = 0Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0020 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 155Speed: 0.0020 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 420 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 489 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 126Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 469 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 501 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 126Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 407 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 502 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 127Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 504 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 408 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 127Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 489 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 460 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 135Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 400 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 535 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 135Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 414 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 404 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 128Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 453 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 518 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0003 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 128Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 285 and deleted = 0Speed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: no matching row IN const table |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 286 and deleted = 0Speed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: no matching row IN const table |
0.0002 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 45Speed: 0.0002 - Possible keys: - Key Used: - Type: - Rows: - Extra: no matching row IN const table |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 524 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 525 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 153Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 528 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 446 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 153Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 522 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 521 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 153Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 406 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 523 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 153Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 454 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 519 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 128Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 446 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 514 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 128Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 518 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 453 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 128Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 398 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 405 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 130Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 491 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 412 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 135Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 413 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 453 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 127Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 469 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 503 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 127Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 412 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 491 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 126Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 397 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 403 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 126Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 553 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT title FROM `bf_team` WHERE `id` = 510 and deleted = 0Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0001 |
SELECT S.title FROM bf_championship C INner join bf_stadium S ON C.stadium_id = S.id WHERE C.id = 155Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0004 |
SELECT * FROM `bf_news` WHERE
`featured` = '1' and
`id` <> '48' and
`deleted` = 0 and
`status` = 1 and
`created_on` < '2023-01-28 11:20:10'
ORDER BY `created_on` DESC
LIMIT 3Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: range - Rows: 50 - Extra: Using WHERE; Using filesort |
0.0003 |
SELECT * FROM `bf_news` WHERE
`featured` = '1' and
`id` <> '48' and
`deleted` = 0 and
`status` = 1 and
`created_on` < '2023-01-28 11:20:10'
ORDER BY `created_on` DESC
LIMIT 3Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: range - Rows: 50 - Extra: Using WHERE; Using filesort |
0.0567 |
Total Query Execution Time |