| 0.0003 |
SELECT GET_LOCK('7e3ee78504d5da11a31d3c8c169e3c49', 300) AS ci_session_lock
|
| 0.0005 |
SELECT `data`
FROM `tblsessions`
WHERE `id` = '577a6368a5f4d3b812dd2c3b44c1021913b334fa'
|
| 0.0025 |
SHOW COLUMNS FROM `tbloptions`
|
| 0.0050 |
SELECT `name`, `value`
FROM `tbloptions`
WHERE `autoload` = 1
|
| 0.0004 |
SELECT *
FROM `tblmigrations`
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `tblmodules`
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `admin` = 1
AND `staffid` = 0
|
| 0.0014 |
SELECT *
FROM `tblstaff_permissions`
WHERE `staff_id` = 0
|
| 0.0004 |
SELECT `value`
FROM `tbloptions`
WHERE `name` = 'whatsapp_chat'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'whatsapp_api_verification_id'
|
| 0.0017 |
UPDATE `tbloptions` SET `value` = '38690826'
WHERE `name` = 'whatsapp_api_verification_id'
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'whatsapp_api_last_verification'
|
| 0.0010 |
UPDATE `tbloptions` SET `value` = 999999999
WHERE `name` = 'whatsapp_api_last_verification'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'whatsapp_api_verified'
|
| 0.0009 |
UPDATE `tbloptions` SET `value` = 1
WHERE `name` = 'whatsapp_api_verified'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'whatsapp_api_heartbeat'
|
| 0.0010 |
UPDATE `tbloptions` SET `value` = 1
WHERE `name` = 'whatsapp_api_heartbeat'
|
| 0.0005 |
SELECT `tblbilling_bank`.*, `tblcurrencies`.`name` AS `currency_name`
FROM `tblbilling_bank`
LEFT JOIN `tblcurrencies` ON `tblcurrencies`.`id` = `tblbilling_bank`.`currency_id`
WHERE `tblbilling_bank`.`cash` = 0
AND `tblbilling_bank`.`status` = 1
AND `tblbilling_bank`.`show_on_document` = 1
|
| 0.0018 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'staff'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'customers'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'credit_note'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'subscriptions'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'tickets'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0015 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'contracts'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'invoice'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'estimate'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'tasks'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'proposal'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'leads'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'opportunities'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'projects'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'event'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0015 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'other'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'proforma'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'approval'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'invoice_rejected_anaf'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0015 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'appointly'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_receipt'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0015 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'pre_orders_handover'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'pre_orders_notify'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0015 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'order_delivered_review'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_order'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_request'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_quotation'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'debit_note'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_statement'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0015 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_contract'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'vendor'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_invoice_reminder'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'inventory_warning'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0016 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'goods_delivery'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0021 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'shipment_status'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0108 |
SHOW TABLES FROM `mihaidev_ecodivision`
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'authenticator_2fa_enabled_customers'
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'authenticator_2fa_enabled_admins'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'authenticator_2fa_app_name'
|
| 0.0004 |
SELECT *
FROM `tblmigrations`
LIMIT 1
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `staffid` = 0
AND `is_not_staff` = 0
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `staffid` = 0
AND `is_not_staff` = 0
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `staffid` = 0
AND `is_not_staff` = 0
|
| 0.0004 |
SELECT `value`
FROM `tbloptions`
WHERE `name` = 'show_chart_of_accounts'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `admin` = 1
AND `staffid` = 0
|
| 0.0004 |
SELECT *
FROM `tbldepartments`
WHERE `hidefromclient` = 0
|
| 0.0003 |
SELECT *
FROM `tbltickets_priorities`
|
| 0.0003 |
SELECT *
FROM `tbltickets_status`
ORDER BY `statusorder` ASC
|
| 0.0003 |
SELECT *
FROM `tblcurrencies`
|
| 0.0003 |
SELECT *
FROM `tblservices`
ORDER BY `name` ASC
|
| 0.0003 |
SELECT `value`
FROM `tbloptions`
WHERE `name` = 'crm_logo'
|
