Our development opt in to the projects they genuinely want to work on, committing wholeheartedly to delivering.
Software End School Management System provides user-friendly dashboards with login access for teachers, non-teaching staff, students, parents and management personnel of your inst
Web Based E-commerce
Web Based E-commerce
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`name`, `Menu`.`slug`, `Menu`.`url`, `Menu`.`type` FROM `softwaresbd_main`.`menus` AS `Menu` WHERE `Menu`.`status` = '1' ORDER BY `Menu`.`order` ASC | 10 | 10 | 0 | |
| 2 | SELECT `Config`.`key`, `Config`.`value` FROM `softwaresbd_main`.`configs` AS `Config` WHERE 1 = 1 | 15 | 15 | 0 | |
| 3 | BEGIN | 0 | 0 | 0 | |
| 4 | INSERT INTO `softwaresbd_main`.`logs` (`user_id`, `ip`, `port`, `controller`, `action`, `created`) VALUES (NULL, '98.80.143.34', '38280', 'projects', '/projects/project_view', '2024-10-06 06:57:18') | 1 | 1 | 1 | |
| 5 | COMMIT | 0 | 0 | 0 | |
| 6 | SELECT `Quicklink`.`id`, `Quicklink`.`name`, `Quicklink`.`links`, `Quicklink`.`status`, `Quicklink`.`created`, `Quicklink`.`modified` FROM `softwaresbd_main`.`quicklinks` AS `Quicklink` WHERE `status` = '1' | 4 | 4 | 0 | |
| 7 | SELECT `Project`.`id`, `Project`.`product_id`, `Project`.`client_id`, `Project`.`employee_id`, `Project`.`contractor_id`, `Project`.`name`, `Project`.`extra`, `Project`.`requirement`, `Project`.`web`, `Project`.`price`, `Project`.`advance`, `Project`.`paid`, `Project`.`contractor_percentage`, `Project`.`seq`, `Project`.`start_date`, `Project`.`end_date`, `Project`.`status`, `Project`.`created`, `Project`.`modified`, `Product`.`id`, `Product`.`name`, `Product`.`category_id`, `Product`.`description`, `Product`.`feature`, `Product`.`demo`, `Product`.`credential`, `Product`.`price`, `Product`.`seq`, `Product`.`is_public`, `Product`.`status`, `Product`.`created`, `Product`.`modified`, `Client`.`id`, `Client`.`name`, `Client`.`description`, `Client`.`address`, `Client`.`phone`, `Client`.`mobile`, `Client`.`email`, `Client`.`web`, `Client`.`contact_person`, `Client`.`contact_phone`, `Client`.`status`, `Client`.`created`, `Client`.`modified`, `Employee`.`id`, `Employee`.`name`, `Employee`.`designation`, `Employee`.`birthdate`, `Employee`.`gender`, `Employee`.`religion`, `Employee`.`blood_group`, `Employee`.`present_address`, `Employee`.`permanent_address`, `Employee`.`phone`, `Employee`.`email`, `Employee`.`join_date`, `Employee`.`leave_date`, `Employee`.`leav_type`, `Employee`.`education`, `Employee`.`marital_status`, `Employee`.`balance`, `Employee`.`salary`, `Employee`.`bonus`, `Employee`.`paid`, `Employee`.`gain`, `Employee`.`status`, `Employee`.`created`, `Employee`.`modified`, `Contractor`.`id`, `Contractor`.`name`, `Contractor`.`description`, `Contractor`.`address`, `Contractor`.`phone`, `Contractor`.`mobile`, `Contractor`.`email`, `Contractor`.`web`, `Contractor`.`status`, `Contractor`.`created`, `Contractor`.`modified` FROM `softwaresbd_main`.`projects` AS `Project` LEFT JOIN `softwaresbd_main`.`products` AS `Product` ON (`Project`.`product_id` = `Product`.`id`) LEFT JOIN `softwaresbd_main`.`clients` AS `Client` ON (`Project`.`client_id` = `Client`.`id`) LEFT JOIN `softwaresbd_main`.`employees` AS `Employee` ON (`Project`.`employee_id` = `Employee`.`id`) LEFT JOIN `softwaresbd_main`.`contractors` AS `Contractor` ON (`Project`.`contractor_id` = `Contractor`.`id`) WHERE `Project`.`status` = '1' AND `Product`.`is_public` = '1' | 3 | 3 | 1 | |
| 8 | SELECT `ProjectModification`.`id`, `ProjectModification`.`project_id`, `ProjectModification`.`employee_id`, `ProjectModification`.`modification`, `ProjectModification`.`price`, `ProjectModification`.`start_date`, `ProjectModification`.`end_date`, `ProjectModification`.`approve_date`, `ProjectModification`.`status`, `ProjectModification`.`created`, `ProjectModification`.`modified` FROM `softwaresbd_main`.`project_modifications` AS `ProjectModification` WHERE `ProjectModification`.`project_id` IN (3, 1, 6) | 0 | 0 | 0 | |
| 9 | SELECT `Receipt`.`id`, `Receipt`.`project_id`, `Receipt`.`payment_type`, `Receipt`.`amount`, `Receipt`.`balance`, `Receipt`.`pdate`, `Receipt`.`comments`, `Receipt`.`created` FROM `softwaresbd_main`.`receipts` AS `Receipt` WHERE `Receipt`.`project_id` IN (3, 1, 6) | 0 | 0 | 0 |
