| 1 |
1.13 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.stock AS stock_4, p0_.minimum_stock AS minimum_stock_5, p0_.price AS price_6, p0_.discount_type AS discount_type_7, p0_.discount_value AS discount_value_8, p0_.active AS active_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.category_id AS category_id_12, p0_.business_id AS business_id_13 FROM product p0_ WHERE p0_.active = 1 AND p0_.business_id = ? AND p0_.stock > 0 ORDER BY p0_.id ASC LIMIT 20
SELECT DISTINCT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.stock AS stock_4, p0_.minimum_stock AS minimum_stock_5, p0_.price AS price_6, p0_.discount_type AS discount_type_7, p0_.discount_value AS discount_value_8, p0_.active AS active_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.category_id AS category_id_12, p0_.business_id AS business_id_13 FROM product p0_ WHERE p0_.active = 1 AND p0_.business_id = 1 AND p0_.stock > 0 ORDER BY p0_.id ASC LIMIT 20;
|
| 2 |
0.78 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.active = 1 AND p0_.business_id = ? AND p0_.stock > 0
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.active = 1 AND p0_.business_id = 1 AND p0_.stock > 0;
|
| 3 |
0.99 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = 1;
|
| 4 |
2.67 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = 2;
|
| 5 |
0.42 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = 3;
|
| 6 |
2.26 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = 4;
|
| 7 |
0.38 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = 5;
|