| 1 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`descripcionadicional`, `Category`.`created`, `Category`.`modified` FROM `compra_appcompraflores2`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`lft` ASC | | 25 | 25 | 1 |
| 2 | SELECT `Banner`.`id`, `Banner`.`name`, `Banner`.`title`, `Banner`.`subtitle`, `Banner`.`link`, `Banner`.`image`, `Banner`.`active`, `Banner`.`created`, `Banner`.`modified`, `Banner`.`grupobanner_id` FROM `compra_appcompraflores2`.`banners` AS `Banner` WHERE 1 = 1 | | 12 | 12 | 0 |
| 3 | SELECT `Order`.`id`, `Order`.`first_name`, `Order`.`last_name`, `Order`.`identity_number`, `Order`.`email`, `Order`.`phone`, `Order`.`neighborhood`, `Order`.`billing_address`, `Order`.`billing_address2`, `Order`.`billing_city`, `Order`.`billing_zip`, `Order`.`billing_state`, `Order`.`billing_country`, `Order`.`shipping_address`, `Order`.`shipping_address2`, `Order`.`shipping_city`, `Order`.`shipping_zip`, `Order`.`shipping_state`, `Order`.`shipping_country`, `Order`.`weight`, `Order`.`order_item_count`, `Order`.`observations`, `Order`.`subtotal`, `Order`.`tax`, `Order`.`shipping`, `Order`.`total`, `Order`.`order_type`, `Order`.`authorization`, `Order`.`transaction`, `Order`.`status`, `Order`.`ip_address`, `Order`.`created`, `Order`.`modified` FROM `compra_appcompraflores2`.`orders` AS `Order` WHERE ((`Order`.`created` > '2026-03-01 00:00:01') AND (`Order`.`created` < '2026-03-01 23:59:59')) ORDER BY `Order`.`created` DESC LIMIT 1000 | | 0 | 0 | 13 |
| 4 | SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Brand`.`active`, `Brand`.`created`, `Brand`.`modified` FROM `compra_appcompraflores2`.`brands` AS `Brand` WHERE `Brand`.`active` = 1 AND `Brand`.`slug` = 'rosas' LIMIT 1 | | 1 | 1 | 0 |
| 5 | SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`brand_id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`image`, `Product`.`price`, `Product`.`weight`, `Product`.`tags`, `Product`.`views`, `Product`.`active`, `Product`.`created`, `Product`.`modified`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`video`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Brand`.`active`, `Brand`.`created`, `Brand`.`modified` FROM `compra_appcompraflores2`.`products` AS `Product` LEFT JOIN `compra_appcompraflores2`.`brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`active` = 1 AND `Product`.`brand_id` = 2 AND `Brand`.`active` = 1 ORDER BY `Product`.`name` ASC LIMIT 40, 40 | | 40 | 40 | 1 |
| 6 | SELECT COUNT(*) AS `count` FROM `compra_appcompraflores2`.`products` AS `Product` LEFT JOIN `compra_appcompraflores2`.`brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`active` = 1 AND `Product`.`brand_id` = 2 AND `Brand`.`active` = 1 | | 1 | 1 | 1 |
| 7 | SELECT * FROM products WHERE products.active = 1 ORDER BY products.id DESC LIMIT 0, 16; | | 16 | 16 | 0 |
| 8 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`descripcionadicional`, `Category`.`created`, `Category`.`modified` FROM `compra_appcompraflores2`.`categories` AS `Category` WHERE 1 = 1 | | 25 | 25 | 0 |
| 9 | SELECT * FROM products JOIN categories ON categories.id = products.category_id WHERE products.category_id LIKE '%29%' ORDER BY products.price ASC LIMIT 1 | | 1 | 1 | 1 |
| 10 | SELECT * FROM products JOIN categories ON categories.id = products.category_id WHERE products.category_id LIKE '%30%' ORDER BY products.price ASC LIMIT 1 | | 1 | 1 | 1 |
| 11 | SELECT * FROM products JOIN categories ON categories.id = products.category_id WHERE products.category_id LIKE '%31%' ORDER BY products.price ASC LIMIT 1 | | 1 | 1 | 1 |
