| 0.0002 |
SELECT GET_LOCK('91397accfb9fda2e7f3962155b4dca7d', 300) AS ci_session_lock
|
| 0.0018 |
SELECT `data`
FROM `tblsessions`
WHERE `id` = '17b67e3482f154cc04144aaf9c2cb91c34db76ac'
|
| 0.0023 |
SHOW COLUMNS FROM `tbloptions`
|
| 0.0062 |
SELECT `name`, `value`
FROM `tbloptions`
WHERE `autoload` = 1
|
| 0.0012 |
SELECT *
FROM `tblmigrations`
LIMIT 1
|
| 0.0013 |
SELECT *
FROM `tblmodules`
|
| 0.0044 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `admin` = 1
AND `staffid` = 0
|
| 0.0022 |
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.0012 |
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.0008 |
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.0008 |
UPDATE `tbloptions` SET `value` = 1
WHERE `name` = 'whatsapp_api_verified'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'whatsapp_api_heartbeat'
|
| 0.0007 |
UPDATE `tbloptions` SET `value` = 1
WHERE `name` = 'whatsapp_api_heartbeat'
|
| 0.0026 |
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.0035 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'staff'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0018 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'customers'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'credit_note'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'subscriptions'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'tickets'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'contracts'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'invoice'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'estimate'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'tasks'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'proposal'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'leads'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'opportunities'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'projects'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'event'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'other'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'proforma'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'approval'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'invoice_rejected_anaf'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'efactura_signature'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'appointly'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_receipt'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'pre_orders_handover'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'pre_orders_notify'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'order_delivered_review'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'order_btipay_payment_link'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
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.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_quotation'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'debit_note'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_statement'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0025 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_contract'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0022 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'vendor'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_invoice_reminder'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'change_candidate_status'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'new_candidate_have_applied'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'change_candidate_job_applied_status'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'change_candidate_interview_schedule_status'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'inventory_warning'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'goods_delivery'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'shipment_status'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'stock_reservation'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'sa_order'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0129 |
SHOW TABLES FROM `mihaidev_ecodivision`
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'authenticator_2fa_enabled_customers'
|
| 0.0003 |
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.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_warehouse_id'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_invoice_send_mode'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_invoice_url_secret'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_cron_interval_products'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_cron_interval_orders'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_cron_last_run_products'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_cron_last_run_orders'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_api_alert_enabled'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_api_alert_email'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_api_alert_last_at'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'emag_api_alert_last_hash'
|
| 0.0002 |
SELECT *
FROM `tblmigrations`
LIMIT 1
|
| 0.0039 |
SHOW COLUMNS FROM `tblitems`
|
| 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.0003 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `staffid` = 0
AND `is_not_staff` = 0
|
| 0.0003 |
SELECT `value`
FROM `tbloptions`
WHERE `name` = 'show_chart_of_accounts'
|
| 0.0017 |
SELECT *
FROM `tbldepartments`
WHERE `hidefromclient` = 0
|
| 0.0010 |
SELECT *
FROM `tbltickets_priorities`
|
| 0.0011 |
SELECT *
FROM `tbltickets_status`
ORDER BY `statusorder` ASC
|
| 0.0003 |
SELECT *
FROM `tblcurrencies`
|
| 0.0010 |
SELECT *
FROM `tblservices`
ORDER BY `name` ASC
|
| 0.0004 |
SELECT `value`
FROM `tbloptions`
WHERE `name` = 'crm_logo'
|
