0.0004 |
SHOW TABLES FROM `shamel_db` |
0.0004 |
SELECT *
FROM `bf_users`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 31 - Extra: |
0.0001 |
SELECT GET_LOCK('k03r7n0fa0uc5u953aeghcmepp', 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` = 'k03r7n0fa0uc5u953aeghcmepp'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.0005 |
SELECT
P.id ,
P.title ,
P.main_image ,
P.image_1 ,
P.image_2 ,
P.image_3 ,
P.image_4 ,
P.description,
P.manufacture ,
P.price,
P.quantity,
P.is_fixed_price,
P.brand_id,
P.company_id,
P.status,
P.created_on,
P.deleted,
P.category_id,
P.sub_category_id,
P.location,
P.machine_name,
P.machine_part_number,
P.manufacturer_part_number,
P.item_attachment,
P.manufacturing_year,
P.manufacturer_origin,
P.video,
P.weight,
P.item_technical_variation,
P.unit,
C.title titleCompany,
C.email emailCompany
FROM
`bf_products` P INNER JOIN
`bf_company` C
ON
P.`company_id` = C.`id`
WHERE ( P.`deleted` = '0' and P.`status`= '1' ) and P.`id`= 38 |
0.0002 |
SELECT DATE_FORMAT(modified_on, '%d %M %Y') AS dateReview ,stars,name,subject,message FROM bf_reviews WHERE status = 1 and product_id = '38' ORDER BY id DESCSpeed: 0.0002 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 1 - Extra: Using WHERE |
0.0002 |
SELECT * FROM `bf_warehouse_locations` WHERE `deleted` <> 1 and `id` = 1 |
0.0002 |
SELECT * FROM `bf_category` WHERE `deleted` <> 1 and `id` = 3 |
0.0002 |
SELECT * FROM `bf_category` WHERE `deleted` <> 1 and `id` = 0 |
0.0003 |
SELECT
CS.id ,
CS.price ,
CS.notes ,
CS.created_on,
CS.deleted,
C.title titleCompany,
S.id IdShipping,
S.title titleShipping,
S.price PriceShipping
FROM
`bf_company_shipping` CS INNER JOIN
`bf_company` C INNER JOIN
`bf_shipping` S
ON
CS.`company_id` = C.`id` and
CS.`shipping_id` = S.`id`
WHERE CS.`deleted` = '0' and CS.`company_id`= 4 |
0.0002 |
SELECT AVG(`stars`) AS Reviews FROM `bf_reviews` WHERE `product_id` = 38Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
0.0003 |
SELECT AVG(rating) AVGRating FROM bf_cart WHERE product_id = 38 and status = 4Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 157 - Extra: Using WHERE |
0.0003 |
SELECT * FROM `bf_products` WHERE `id` = '38'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
0.0016 |
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.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 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.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` = 4 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` = 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` = 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` = 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.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` = 3 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` = 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` = 4 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` = 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.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` = 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` = 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.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.0001 |
SELECT `title` FROM `bf_brands` WHERE `deleted` <> 1 and `id` = 1 |
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` = 3 ORDER BY Rand() LIMIT 5 |
0.0001 |
SELECT AVG(`stars`) AS Reviews FROM `bf_reviews` WHERE `product_id` = 50Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
0.0001 |
SELECT AVG(`stars`) AS Reviews FROM `bf_reviews` WHERE `product_id` = 96Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
0.0001 |
SELECT AVG(`stars`) AS Reviews FROM `bf_reviews` WHERE `product_id` = 90Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
0.0001 |
SELECT AVG(`stars`) AS Reviews FROM `bf_reviews` WHERE `product_id` = 30Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
0.0001 |
SELECT AVG(`stars`) AS Reviews FROM `bf_reviews` WHERE `product_id` = 32Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using WHERE |
0.0202 |
Total Query Execution Time |