05 Mar, 2026
ACURE
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Config`.`key`, `Config`.`value` FROM `acurebd_main`.`configs` AS `Config` WHERE 1 = 1 | 67 | 67 | 0 | |
| 2 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`product_id` FROM `acurebd_main`.`categories` AS `Category` WHERE `Category`.`status` = '1' AND `Category`.`parent_id` = 0 ORDER BY `Category`.`sequence` ASC | 12 | 12 | 0 | |
| 3 | SELECT `ChildCategory`.`id`, `ChildCategory`.`name`, `ChildCategory`.`slug`, `ChildCategory`.`parent_id` FROM `acurebd_main`.`categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_id` IN (73, 4, 9, 29, 28, 21, 30, 24, 20, 26, 6, 15) | 40 | 40 | 0 | |
| 4 | SELECT `News`.`id`, `News`.`title`, `News`.`color_code` FROM `acurebd_main`.`news` AS `News` WHERE `type` = '1' AND `status` = '1' ORDER BY `sequence` ASC | 0 | 0 | 0 | |
| 5 | BEGIN | 0 | 0 | 0 | |
| 6 | ROLLBACK | 0 | 0 | 0 | |
| 7 | SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`details`, `Blog`.`writer_name`, `Blog`.`publish_date`, `Blog`.`user_id`, `Blog`.`status`, `Blog`.`created`, `Blog`.`slug`, `Blog`.`meta_title`, `Blog`.`meta_key`, `Blog`.`meta_description`, `User`.`id`, `User`.`role_id`, `User`.`staff_id`, `User`.`dealer_id`, `User`.`showroom_id`, `User`.`customer_id`, `User`.`corporateclient_id`, `User`.`manager_id`, `User`.`marketingrepresentative_id`, `User`.`salesrepresentative_id`, `User`.`username`, `User`.`password`, `User`.`device_no`, `User`.`gitax`, `User`.`sc`, `User`.`ship`, `User`.`vat`, `User`.`status`, `User`.`created`, `User`.`modified` FROM `acurebd_main`.`blogs` AS `Blog` LEFT JOIN `acurebd_main`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `Blog`.`created` DESC | 39 | 39 | 2 | |
| 8 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`b_title`, `Product`.`slug`, `Product`.`barcode`, `Product`.`parent_id`, `Product`.`category_id`, `Product`.`categories`, `Product`.`brand_id`, `Product`.`model`, `Product`.`specification`, `Product`.`details`, `Product`.`details_en`, `Product`.`details_bn`, `Product`.`meta_des`, `Product`.`meta_tag`, `Product`.`p_price`, `Product`.`price`, `Product`.`special_price`, `Product`.`special_pricep`, `Product`.`wholesale_price`, `Product`.`wholesale_pricep`, `Product`.`dealer_price`, `Product`.`dealer_pricep`, `Product`.`showroom_price`, `Product`.`showroom_pricep`, `Product`.`stock`, `Product`.`sold_qty`, `Product`.`unit`, `Product`.`unit_value`, `Product`.`unit_name`, `Product`.`offer_type`, `Product`.`is_corporate_porduct`, `Product`.`meta_title`, `Product`.`meta_key`, `Product`.`meta_description`, `Product`.`rating`, `Product`.`avg_rating`, `Product`.`status`, `Product`.`created`, `Product`.`modified`, `Product`.`viewtime`, `Product`.`totalview`, (CONCAT(`Product`.`name`, " -- " , `Product`.`unit_name`)) AS `Product__label` FROM `acurebd_main`.`products` AS `Product` WHERE `Product`.`brand_id` IN (41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 30, 28, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1) | 0 | 0 | 5 |
