1
2.64 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . password AS password_3 , t0 . name AS name_4 , t0 . roles AS roles_5 , t0 . theme AS theme_6 , t0 . is_active AS is_active_7 , t0 . telegram_chat_id AS telegram_chat_id_8 , t0 . telegram_link_token AS telegram_link_token_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . organization_id AS organization_id_13 FROM "user" t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . password AS password_3 , t0 . name AS name_4 , t0 . roles AS roles_5 , t0 . theme AS theme_6 , t0 . is_active AS is_active_7 , t0 . telegram_chat_id AS telegram_chat_id_8 , t0 . telegram_link_token AS telegram_link_token_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 , t0 . deleted_at AS deleted_at_12 , t0 . organization_id AS organization_id_13 FROM "user" t0 WHERE t0 . id = 2 ;
Copy
2
1.57 ms
SELECT t0 . id AS id_1 , t0 . uuid AS uuid_2 , t0 . plan AS plan_3 , t0 . label AS label_4 , t0 . fee AS fee_5 , t0 . user_limit AS user_limit_6 , t0 . account_limit AS account_limit_7 , t0 . trial_days AS trial_days_8 , t0 . duration_months AS duration_months_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 FROM plan_config t0
SELECT t0 . id AS id_1 , t0 . uuid AS uuid_2 , t0 . plan AS plan_3 , t0 . label AS label_4 , t0 . fee AS fee_5 , t0 . user_limit AS user_limit_6 , t0 . account_limit AS account_limit_7 , t0 . trial_days AS trial_days_8 , t0 . duration_months AS duration_months_9 , t0 . created_at AS created_at_10 , t0 . updated_at AS updated_at_11 FROM plan_config t0 ;
Copy
3
1.21 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . is_active AS is_active_4 , t0 . primary_color AS primary_color_5 , t0 . secondary_color AS secondary_color_6 , t0 . accent_color AS accent_color_7 , t0 . navbar_color AS navbar_color_8 , t0 . logo_path AS logo_path_9 , t0 . timezone AS timezone_10 , t0 . plan AS plan_11 , t0 . billing_started_at AS billing_started_at_12 , t0 . plan_expires_at AS plan_expires_at_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 FROM organization t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . is_active AS is_active_4 , t0 . primary_color AS primary_color_5 , t0 . secondary_color AS secondary_color_6 , t0 . accent_color AS accent_color_7 , t0 . navbar_color AS navbar_color_8 , t0 . logo_path AS logo_path_9 , t0 . timezone AS timezone_10 , t0 . plan AS plan_11 , t0 . billing_started_at AS billing_started_at_12 , t0 . plan_expires_at AS plan_expires_at_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 FROM organization t0 WHERE t0 . id = 2 ;
Copy
4
1.86 ms
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . password AS password_2 , u0_ . name AS name_3 , u0_ . roles AS roles_4 , u0_ . theme AS theme_5 , u0_ . is_active AS is_active_6 , u0_ . telegram_chat_id AS telegram_chat_id_7 , u0_ . telegram_link_token AS telegram_link_token_8 , u0_ . created_at AS created_at_9 , u0_ . updated_at AS updated_at_10 , u0_ . deleted_at AS deleted_at_11 , u0_ . organization_id AS organization_id_12 FROM "user" u0_ WHERE u0_ . organization_id = ? ORDER BY u0_ . name ASC
SELECT u0_ . id AS id_0 , u0_ . email AS email_1 , u0_ . password AS password_2 , u0_ . name AS name_3 , u0_ . roles AS roles_4 , u0_ . theme AS theme_5 , u0_ . is_active AS is_active_6 , u0_ . telegram_chat_id AS telegram_chat_id_7 , u0_ . telegram_link_token AS telegram_link_token_8 , u0_ . created_at AS created_at_9 , u0_ . updated_at AS updated_at_10 , u0_ . deleted_at AS deleted_at_11 , u0_ . organization_id AS organization_id_12 FROM "user" u0_ WHERE u0_ . organization_id = 2 ORDER BY u0_ . name ASC ;
Copy
5
1.87 ms
SELECT SUM (b0_ . amount ) AS sclr_0 FROM billing_payment b0_ WHERE b0_ . organization_id = ? AND b0_ . deleted_at IS NULL AND b0_ . status = ?
Parameters :
[
2
"verificado "
]
SELECT SUM (b0_ . amount ) AS sclr_0 FROM billing_payment b0_ WHERE b0_ . organization_id = 2 AND b0_ . deleted_at IS NULL AND b0_ . status = 'verificado' ;
Copy
6
1.10 ms
SELECT b0_ . id AS id_0 , b0_ . uuid AS uuid_1 , b0_ . amount AS amount_2 , b0_ . concept AS concept_3 , b0_ . paid_at AS paid_at_4 , b0_ . status AS status_5 , b0_ . method AS method_6 , b0_ . reference AS reference_7 , b0_ . file_path AS file_path_8 , b0_ . created_at AS created_at_9 , b0_ . updated_at AS updated_at_10 , b0_ . deleted_at AS deleted_at_11 , b0_ . organization_id AS organization_id_12 FROM billing_payment b0_ WHERE b0_ . organization_id = ? AND b0_ . deleted_at IS NULL ORDER BY b0_ . paid_at DESC , b0_ . id DESC
SELECT b0_ . id AS id_0 , b0_ . uuid AS uuid_1 , b0_ . amount AS amount_2 , b0_ . concept AS concept_3 , b0_ . paid_at AS paid_at_4 , b0_ . status AS status_5 , b0_ . method AS method_6 , b0_ . reference AS reference_7 , b0_ . file_path AS file_path_8 , b0_ . created_at AS created_at_9 , b0_ . updated_at AS updated_at_10 , b0_ . deleted_at AS deleted_at_11 , b0_ . organization_id AS organization_id_12 FROM billing_payment b0_ WHERE b0_ . organization_id = 2 AND b0_ . deleted_at IS NULL ORDER BY b0_ . paid_at DESC , b0_ . id DESC ;
Copy
7
3.77 ms
SELECT w0_ . id AS id_0 , w0_ . uuid AS uuid_1 , w0_ . name AS name_2 , w0_ . phone AS phone_3 , w0_ . is_enabled AS is_enabled_4 , w0_ . sort_order AS sort_order_5 , w0_ . template_pago AS template_pago_6 , w0_ . template_estado_cuenta AS template_estado_cuenta_7 , w0_ . template_vencimiento AS template_vencimiento_8 , w0_ . image_path AS image_path_9 , w0_ . created_at AS created_at_10 , w0_ . updated_at AS updated_at_11 , w0_ . deleted_at AS deleted_at_12 , w0_ . organization_id AS organization_id_13 FROM whatsapp_config w0_ WHERE w0_ . organization_id = ? AND w0_ . deleted_at IS NULL ORDER BY w0_ . sort_order ASC , w0_ . id ASC
SELECT w0_ . id AS id_0 , w0_ . uuid AS uuid_1 , w0_ . name AS name_2 , w0_ . phone AS phone_3 , w0_ . is_enabled AS is_enabled_4 , w0_ . sort_order AS sort_order_5 , w0_ . template_pago AS template_pago_6 , w0_ . template_estado_cuenta AS template_estado_cuenta_7 , w0_ . template_vencimiento AS template_vencimiento_8 , w0_ . image_path AS image_path_9 , w0_ . created_at AS created_at_10 , w0_ . updated_at AS updated_at_11 , w0_ . deleted_at AS deleted_at_12 , w0_ . organization_id AS organization_id_13 FROM whatsapp_config w0_ WHERE w0_ . organization_id = 2 AND w0_ . deleted_at IS NULL ORDER BY w0_ . sort_order ASC , w0_ . id ASC ;
Copy
8
3.93 ms
SELECT p0_ . id AS id_0 , p0_ . uuid AS uuid_1 , p0_ . name AS name_2 , p0_ . type AS type_3 , p0_ . bank AS bank_4 , p0_ . clabe AS clabe_5 , p0_ . account_number AS account_number_6 , p0_ . holder AS holder_7 , p0_ . is_active AS is_active_8 , p0_ . created_at AS created_at_9 , p0_ . updated_at AS updated_at_10 , p0_ . deleted_at AS deleted_at_11 , p0_ . organization_id AS organization_id_12 FROM payment_method p0_ WHERE p0_ . deleted_at IS NULL AND p0_ . organization_id IN (? ) ORDER BY p0_ . is_active DESC , p0_ . name ASC
SELECT p0_ . id AS id_0 , p0_ . uuid AS uuid_1 , p0_ . name AS name_2 , p0_ . type AS type_3 , p0_ . bank AS bank_4 , p0_ . clabe AS clabe_5 , p0_ . account_number AS account_number_6 , p0_ . holder AS holder_7 , p0_ . is_active AS is_active_8 , p0_ . created_at AS created_at_9 , p0_ . updated_at AS updated_at_10 , p0_ . deleted_at AS deleted_at_11 , p0_ . organization_id AS organization_id_12 FROM payment_method p0_ WHERE p0_ . deleted_at IS NULL AND p0_ . organization_id IN (2 ) ORDER BY p0_ . is_active DESC , p0_ . name ASC ;
Copy