| 0.0003 |
SELECT GET_LOCK('836ba1b317a74725841013a37f6d3c3b', 300) AS ci_session_lock
|
| 0.0027 |
SELECT `data`
FROM `tblsessions`
WHERE `id` = 'fe1b4c4d61dcefec184c57e8eb51179cf39d3471'
|
| 0.0028 |
SHOW COLUMNS FROM `tbloptions`
|
| 0.0066 |
SELECT `name`, `value`
FROM `tbloptions`
WHERE `autoload` = 1
|
| 0.0016 |
SELECT *
FROM `tblmigrations`
LIMIT 1
|
| 0.0016 |
SELECT *
FROM `tblmodules`
|
| 0.0049 |
SELECT COUNT(*) AS `numrows`
FROM `tblstaff`
WHERE `admin` = 1
AND `staffid` = 0
|
| 0.0024 |
SELECT *
FROM `tblstaff_permissions`
WHERE `staff_id` = 0
|
| 0.0005 |
SELECT `value`
FROM `tbloptions`
WHERE `name` = 'whatsapp_chat'
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `tbloptions`
WHERE `name` = 'whatsapp_api_verification_id'
|
| 0.0015 |
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.0011 |
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.0008 |
UPDATE `tbloptions` SET `value` = 1
WHERE `name` = 'whatsapp_api_heartbeat'
|
| 0.0029 |
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.0033 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'staff'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0019 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'customers'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0018 |
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.0018 |
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.0018 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'tasks'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0018 |
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.0018 |
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.0017 |
SELECT *
FROM `tblcustomfields`
WHERE `fieldto` = 'purchase_contract'
AND `only_admin` = 0
AND `active` = 1
ORDER BY `field_order` ASC
|
| 0.0018 |
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.0132 |
SHOW TABLES FROM `mihaidev_ecodivision`
|
| 0.0006 |
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.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.0004 |
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.0003 |
SELECT *
FROM `tblmigrations`
LIMIT 1
|
| 0.0040 |
SHOW COLUMNS FROM `tblitems`
|
| 0.0005 |
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.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.0016 |
SELECT *
FROM `tbldepartments`
WHERE `hidefromclient` = 0
|
| 0.0011 |
SELECT *
FROM `tbltickets_priorities`
|
| 0.0012 |
SELECT *
FROM `tbltickets_status`
ORDER BY `statusorder` ASC
|
| 0.0004 |
SELECT *
FROM `tblcurrencies`
|
| 0.0011 |
SELECT *
FROM `tblservices`
ORDER BY `name` ASC
|
| 0.0004 |
SELECT `value`
FROM `tbloptions`
WHERE `name` = 'crm_logo'
|
