0.0005 |
SHOW TABLES FROM `shamel_db` |
0.0003 |
SELECT *
FROM `bf_users`Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 31 - Extra: |
0.0001 |
SELECT GET_LOCK('ad4313tp8kl3kt49mo5ibim7s2', 300) AS ci_session_lockSpeed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
0.0002 |
SELECT `data`
FROM `bf_ci3_sessions`
WHERE `id` = 'ad4313tp8kl3kt49mo5ibim7s2'Speed: 0.0002 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
0.0002 |
SELECT *
FROM `bf_settings`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 42 - Extra: |
0.0004 |
SELECT * FROM `bf_pages` WHERE `deleted` = '0' and `id`= 23 |
0.0003 |
SELECT
`title`
FROM
`bf_pages`
WHERE `id` = '23'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0013 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 3 ORDER BY Rand() LIMIT 8 |
0.0009 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 3 ORDER BY Rand() LIMIT 5 |
0.0009 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 4 ORDER BY Rand() LIMIT 5 |
0.0009 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 4 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 6 ORDER BY Rand() LIMIT 5 |
0.0006 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 6 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 7 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 7 ORDER BY Rand() LIMIT 5 |
0.0006 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 9 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 9 ORDER BY Rand() LIMIT 5 |
0.0008 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 3 ORDER BY Rand() LIMIT 5 |
0.0008 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 3 ORDER BY Rand() LIMIT 5 |
0.0009 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 4 ORDER BY Rand() LIMIT 5 |
0.0009 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 4 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 6 ORDER BY Rand() LIMIT 5 |
0.0006 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 6 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 7 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 7 ORDER BY Rand() LIMIT 5 |
0.0007 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 9 ORDER BY Rand() LIMIT 5 |
0.0006 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.category_id,
P.is_fixed_price,
P.status,
P.created_on,
P.deleted,
C.title titleCompany,
C.id idCompany,
CT.title titleCategory,
CT.id idCategory,
B.title titleBrand
FROM
`bf_products` P INNER JOIN
`bf_company` C INNER JOIN
`bf_category` CT INNER JOIN
`bf_brands` B
ON
P.`company_id` = C.`id` and
P.`category_id` = CT.`id` and
P.`brand_id` = B.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1') and P.`category_id` = 9 ORDER BY Rand() LIMIT 5 |
0.0172 |
Total Query Execution Time |