(0.002) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.002) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE `sales_user`.`email` = 'demo@microweb.jp' LIMIT 21; args=('demo@microweb.jp',); alias=default (0.001) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE `sales_user`.`email` = 'demo@microweb.jp' LIMIT 21; args=('demo@microweb.jp',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created` FROM `authtoken_token` WHERE `authtoken_token`.`user_id` = 1 LIMIT 21; args=(1,); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created` FROM `authtoken_token` WHERE `authtoken_token`.`user_id` = 1 LIMIT 21; args=(1,); alias=default (0.001) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.001) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.001) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.001) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.003) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.001) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.003) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.001) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.001) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.003) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.001) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.001) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.003) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.001) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.002) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.002) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.003) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.003) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.001) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.001) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.000) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.000) SELECT VERSION(), @@sql_mode, @@default_storage_engine, @@sql_auto_is_null, @@lower_case_table_names, CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL ; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240728 AND schedule.schedule_out_date <= 20241016) OR (20240728 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241016 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240728, 20241016, 20240728, 20241016); alias=default (0.001) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240728 AND schedule.schedule_out_date <= 20241016) OR (20240728 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241016 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240728, 20241016, 20240728, 20241016); alias=default (0.000) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240728 AND `sales_holiday`.`holiday` <= 20241016); args=(False, 20240728, 20241016); alias=default (0.000) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240728 AND `sales_holiday`.`holiday` <= 20241016); args=(False, 20240728, 20241016); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.002) SELECT buying_h.buying_no , buying_h.buying_status , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_b.buying_list_no , buying_b.goods_name , buying_b.amount , buying_b.buying_list_memo , buying_h.buying_memo , buying_b.account_cd , account.account_name , buying_b.account_sub_cd , account_sub.account_sub_name FROM sales_tbl_buying_h as buying_h INNER JOIN sales_tbl_buying_b as buying_b ON buying_b.comp_cd = buying_h.comp_cd AND buying_b.buying_no = buying_h.buying_no AND buying_b.rkind = 9 LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_account as account ON account.comp_cd = buying_b.comp_cd AND account.account_cd = buying_b.account_cd AND account.del_flg = FALSE LEFT JOIN sales_account_sub as account_sub ON account_sub.comp_cd = buying_b.comp_cd AND account_sub.account_cd = buying_b.account_cd AND account_sub.account_sub_cd = buying_b.account_sub_cd AND account_sub.del_flg = FALSE LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC, buying_b.buying_list_no ASC ; args=('skvKwjHvns',); alias=default (0.002) SELECT buying_h.buying_no , buying_h.buying_status , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_b.buying_list_no , buying_b.goods_name , buying_b.amount , buying_b.buying_list_memo , buying_h.buying_memo , buying_b.account_cd , account.account_name , buying_b.account_sub_cd , account_sub.account_sub_name FROM sales_tbl_buying_h as buying_h INNER JOIN sales_tbl_buying_b as buying_b ON buying_b.comp_cd = buying_h.comp_cd AND buying_b.buying_no = buying_h.buying_no AND buying_b.rkind = 9 LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_account as account ON account.comp_cd = buying_b.comp_cd AND account.account_cd = buying_b.account_cd AND account.del_flg = FALSE LEFT JOIN sales_account_sub as account_sub ON account_sub.comp_cd = buying_b.comp_cd AND account_sub.account_cd = buying_b.account_cd AND account_sub.account_sub_cd = buying_b.account_sub_cd AND account_sub.del_flg = FALSE LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC, buying_b.buying_list_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.003) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.003) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.001) SELECT sales_h.sales_no , sales_h.sales_status , sales_h.sales_date , invoice.invoice_date , sales_h.estimate_no , sales_h.receive_no , bus.bus_no , bus.bus_title , sales_h.client_cd , sales_h.client_name , sales_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , sales_h.price_before_tax , sales_h.tax , sales_h.price_including_tax , sales_h.sales_memo , sales_h.delivery_slip_date FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 LEFT JOIN sales_user as usr ON sales_h.user_id = usr.id WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 and sales_h.delivery_slip_date = 0 ORDER BY sales_h.sales_no ASC ; args=('skvKwjHvns',); alias=default (0.001) SELECT sales_h.sales_no , sales_h.sales_status , sales_h.sales_date , invoice.invoice_date , sales_h.estimate_no , sales_h.receive_no , bus.bus_no , bus.bus_title , sales_h.client_cd , sales_h.client_name , sales_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , sales_h.price_before_tax , sales_h.tax , sales_h.price_including_tax , sales_h.sales_memo , sales_h.delivery_slip_date FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 LEFT JOIN sales_user as usr ON sales_h.user_id = usr.id WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 and sales_h.delivery_slip_date = 0 ORDER BY sales_h.sales_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_setting_list`.`id`, `sales_setting_list`.`comp_cd`, `sales_setting_list`.`setting_key`, `sales_setting_list`.`setting_list_no`, `sales_setting_list`.`created_date`, `sales_setting_list`.`add_date`, `sales_setting_list`.`add_user_id`, `sales_setting_list`.`upd_date`, `sales_setting_list`.`upd_user_id`, `sales_setting_list`.`del_flg`, `sales_setting_list`.`setting_list_value`, `sales_setting_list`.`setting_list_rank`, `sales_setting_list`.`setting_list_memo`, `sales_setting_list`.`display_flg` FROM `sales_setting_list` WHERE (`sales_setting_list`.`comp_cd` = 'skvKwjHvns' AND `sales_setting_list`.`del_flg` = 0 AND `sales_setting_list`.`setting_key` = 'sales_closing_date') ORDER BY `sales_setting_list`.`setting_list_rank` ASC; args=('skvKwjHvns', False, 'sales_closing_date'); alias=default (0.000) SELECT `sales_setting_list`.`id`, `sales_setting_list`.`comp_cd`, `sales_setting_list`.`setting_key`, `sales_setting_list`.`setting_list_no`, `sales_setting_list`.`created_date`, `sales_setting_list`.`add_date`, `sales_setting_list`.`add_user_id`, `sales_setting_list`.`upd_date`, `sales_setting_list`.`upd_user_id`, `sales_setting_list`.`del_flg`, `sales_setting_list`.`setting_list_value`, `sales_setting_list`.`setting_list_rank`, `sales_setting_list`.`setting_list_memo`, `sales_setting_list`.`display_flg` FROM `sales_setting_list` WHERE (`sales_setting_list`.`comp_cd` = 'skvKwjHvns' AND `sales_setting_list`.`del_flg` = 0 AND `sales_setting_list`.`setting_key` = 'sales_closing_date') ORDER BY `sales_setting_list`.`setting_list_rank` ASC; args=('skvKwjHvns', False, 'sales_closing_date'); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_setting_list`.`id`, `sales_setting_list`.`comp_cd`, `sales_setting_list`.`setting_key`, `sales_setting_list`.`setting_list_no`, `sales_setting_list`.`created_date`, `sales_setting_list`.`add_date`, `sales_setting_list`.`add_user_id`, `sales_setting_list`.`upd_date`, `sales_setting_list`.`upd_user_id`, `sales_setting_list`.`del_flg`, `sales_setting_list`.`setting_list_value`, `sales_setting_list`.`setting_list_rank`, `sales_setting_list`.`setting_list_memo`, `sales_setting_list`.`display_flg` FROM `sales_setting_list` WHERE (`sales_setting_list`.`comp_cd` = 'skvKwjHvns' AND `sales_setting_list`.`del_flg` = 0 AND `sales_setting_list`.`setting_key` = 'sales_closing_date') ORDER BY `sales_setting_list`.`setting_list_rank` ASC; args=('skvKwjHvns', False, 'sales_closing_date'); alias=default (0.000) SELECT `sales_setting_list`.`id`, `sales_setting_list`.`comp_cd`, `sales_setting_list`.`setting_key`, `sales_setting_list`.`setting_list_no`, `sales_setting_list`.`created_date`, `sales_setting_list`.`add_date`, `sales_setting_list`.`add_user_id`, `sales_setting_list`.`upd_date`, `sales_setting_list`.`upd_user_id`, `sales_setting_list`.`del_flg`, `sales_setting_list`.`setting_list_value`, `sales_setting_list`.`setting_list_rank`, `sales_setting_list`.`setting_list_memo`, `sales_setting_list`.`display_flg` FROM `sales_setting_list` WHERE (`sales_setting_list`.`comp_cd` = 'skvKwjHvns' AND `sales_setting_list`.`del_flg` = 0 AND `sales_setting_list`.`setting_key` = 'sales_closing_date') ORDER BY `sales_setting_list`.`setting_list_rank` ASC; args=('skvKwjHvns', False, 'sales_closing_date'); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.002) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.002) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.001) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.001) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.001) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.000) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.001) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.001) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.001) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.001) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240728 AND schedule.schedule_out_date <= 20241016) OR (20240728 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241016 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240728, 20241016, 20240728, 20241016); alias=default (0.001) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240728 AND schedule.schedule_out_date <= 20241016) OR (20240728 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241016 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240728, 20241016, 20240728, 20241016); alias=default (0.000) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240728 AND `sales_holiday`.`holiday` <= 20241016); args=(False, 20240728, 20241016); alias=default (0.000) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240728 AND `sales_holiday`.`holiday` <= 20241016); args=(False, 20240728, 20241016); alias=default Not Found: /api/.env Not Found: /api/.env Not Found: /api/.git/config Not Found: /api/.git/config Internal Server Error: /api/api-token-auth/ Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection self.connect() File "/usr/local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 270, in connect self.connection = self.get_new_connection(conn_params) File "/usr/local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 247, in get_new_connection connection = Database.connect(**conn_params) File "/usr/local/lib64/python3.9/site-packages/MySQLdb/__init__.py", line 121, in Connect return Connection(*args, **kwargs) File "/usr/local/lib64/python3.9/site-packages/MySQLdb/connections.py", line 193, in __init__ super().__init__(*args, **kwargs2) MySQLdb.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/django/core/handlers/exception.py", line 55, in inner response = get_response(request) File "/usr/local/lib/python3.9/site-packages/django/core/handlers/base.py", line 197, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/local/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 56, in wrapper_view return view_func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/views/generic/base.py", line 104, in view return self.dispatch(request, *args, **kwargs) File "/usr/local/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch response = self.handle_exception(exc) File "/usr/local/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception self.raise_uncaught_exception(exc) File "/usr/local/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception raise exc File "/usr/local/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch response = handler(request, *args, **kwargs) File "/usr/local/lib/python3.9/site-packages/rest_framework/authtoken/views.py", line 56, in post serializer.is_valid(raise_exception=True) File "/usr/local/lib/python3.9/site-packages/rest_framework/serializers.py", line 227, in is_valid self._validated_data = self.run_validation(self.initial_data) File "/usr/local/lib/python3.9/site-packages/rest_framework/serializers.py", line 429, in run_validation value = self.validate(value) File "/usr/local/lib/python3.9/site-packages/rest_framework/authtoken/serializers.py", line 28, in validate user = authenticate(request=self.context.get('request'), File "/usr/local/lib/python3.9/site-packages/django/views/decorators/debug.py", line 42, in sensitive_variables_wrapper return func(*func_args, **func_kwargs) File "/usr/local/lib/python3.9/site-packages/django/contrib/auth/__init__.py", line 77, in authenticate user = backend.authenticate(request, **credentials) File "/usr/local/lib/python3.9/site-packages/django/contrib/auth/backends.py", line 46, in authenticate user = UserModel._default_manager.get_by_natural_key(username) File "/usr/local/lib/python3.9/site-packages/django/contrib/auth/base_user.py", line 54, in get_by_natural_key return self.get(**{self.model.USERNAME_FIELD: username}) File "/usr/local/lib/python3.9/site-packages/django/db/models/manager.py", line 87, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/models/query.py", line 633, in get num = len(clone) File "/usr/local/lib/python3.9/site-packages/django/db/models/query.py", line 380, in __len__ self._fetch_all() File "/usr/local/lib/python3.9/site-packages/django/db/models/query.py", line 1881, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/usr/local/lib/python3.9/site-packages/django/db/models/query.py", line 91, in __iter__ results = compiler.execute_sql( File "/usr/local/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1560, in execute_sql cursor = self.connection.cursor() File "/usr/local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 330, in cursor return self._cursor() File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 306, in _cursor self.ensure_connection() File "/usr/local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection self.connect() File "/usr/local/lib/python3.9/site-packages/django/db/utils.py", line 91, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection self.connect() File "/usr/local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/backends/base/base.py", line 270, in connect self.connection = self.get_new_connection(conn_params) File "/usr/local/lib/python3.9/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/usr/local/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 247, in get_new_connection connection = Database.connect(**conn_params) File "/usr/local/lib64/python3.9/site-packages/MySQLdb/__init__.py", line 121, in Connect return Connection(*args, **kwargs) File "/usr/local/lib64/python3.9/site-packages/MySQLdb/connections.py", line 193, in __init__ super().__init__(*args, **kwargs2) django.db.utils.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)") (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.012) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE `sales_user`.`email` = 'demo@microweb.jp' LIMIT 21; args=('demo@microweb.jp',); alias=default (0.012) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE `sales_user`.`email` = 'demo@microweb.jp' LIMIT 21; args=('demo@microweb.jp',); alias=default (0.002) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created` FROM `authtoken_token` WHERE `authtoken_token`.`user_id` = 1 LIMIT 21; args=(1,); alias=default (0.002) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created` FROM `authtoken_token` WHERE `authtoken_token`.`user_id` = 1 LIMIT 21; args=(1,); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.006) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.006) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.008) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.008) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.002) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.002) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.004) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.004) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.001) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.001) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.005) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.005) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.005) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.005) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.002) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.002) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.005) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.005) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.005) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240729 AND schedule.schedule_out_date <= 20241017) OR (20240729 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241017 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240729, 20241017, 20240729, 20241017); alias=default (0.005) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240729 AND schedule.schedule_out_date <= 20241017) OR (20240729 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241017 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240729, 20241017, 20240729, 20241017); alias=default (0.002) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.002) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.003) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240729 AND `sales_holiday`.`holiday` <= 20241017); args=(False, 20240729, 20241017); alias=default (0.003) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240729 AND `sales_holiday`.`holiday` <= 20241017); args=(False, 20240729, 20241017); alias=default Not Found: /api/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.019) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE `sales_user`.`email` = 'demo@microweb.jp' LIMIT 21; args=('demo@microweb.jp',); alias=default (0.019) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE `sales_user`.`email` = 'demo@microweb.jp' LIMIT 21; args=('demo@microweb.jp',); alias=default (0.002) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created` FROM `authtoken_token` WHERE `authtoken_token`.`user_id` = 1 LIMIT 21; args=(1,); alias=default (0.002) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created` FROM `authtoken_token` WHERE `authtoken_token`.`user_id` = 1 LIMIT 21; args=(1,); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.001) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.003) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.003) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.003) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.003) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`parent_dep_id` = 0) ORDER BY `sales_department`.`dep_rank` ASC, `sales_department`.`dep_id` ASC; args=('skvKwjHvns', False, 0); alias=default (0.008) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.008) SELECT concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) as estimate_ym , count(estimate_h.amount) as cnt , sum(estimate_h.amount) as amount FROM sales_tbl_estimate_h as estimate_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = estimate_h.comp_cd AND bus.bus_no = estimate_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_user as usr ON bus.bus_user_id = usr.id WHERE estimate_h.comp_cd = 'skvKwjHvns' AND estimate_h.rkind = 9 AND estimate_h.estimate_status = 0 -- AND (bus.public_flg = TRUE or bus.bus_user_id = 1) GROUP BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) ORDER BY concat(substr(cast(estimate_h.estimate_date as char), 1, 4),'/',substr(cast(estimate_h.estimate_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.002) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.002) SELECT `sales_tbl_hold`.`id`, `sales_tbl_hold`.`comp_cd`, `sales_tbl_hold`.`user_id`, `sales_tbl_hold`.`key`, `sales_tbl_hold`.`hold` FROM `sales_tbl_hold` WHERE (`sales_tbl_hold`.`comp_cd` = 'skvKwjHvns' AND `sales_tbl_hold`.`key` = 'schedule' AND `sales_tbl_hold`.`user_id` = 1) ORDER BY `sales_tbl_hold`.`id` ASC LIMIT 1; args=('skvKwjHvns', 'schedule', 1); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.000) SELECT `sales_department`.`id`, `sales_department`.`comp_cd`, `sales_department`.`dep_id`, `sales_department`.`created_date`, `sales_department`.`add_date`, `sales_department`.`add_user_id`, `sales_department`.`upd_date`, `sales_department`.`upd_user_id`, `sales_department`.`del_flg`, `sales_department`.`parent_dep_id`, `sales_department`.`dep_level`, `sales_department`.`dep_rank`, `sales_department`.`dep_name` FROM `sales_department` WHERE (`sales_department`.`comp_cd` = 'skvKwjHvns' AND `sales_department`.`del_flg` = 0 AND `sales_department`.`dep_id` = 0) ORDER BY `sales_department`.`id` ASC LIMIT 1; args=('skvKwjHvns', False, 0); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.000) SELECT `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `sales_user` WHERE (`sales_user`.`comp_cd` = 'skvKwjHvns' AND `sales_user`.`dep_id` = 0) ORDER BY `sales_user`.`id` ASC; args=('skvKwjHvns', 0); alias=default (0.004) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.004) SELECT concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) as receive_ym , count(distinct receive_h.receive_no) as cnt , sum(receive_b.amount) as amount FROM sales_tbl_receive_h as receive_h INNER JOIN sales_tbl_receive_b as receive_b ON receive_b.comp_cd = receive_h.comp_cd AND receive_b.receive_no = receive_h.receive_no AND receive_b.rkind = 9 LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = receive_h.comp_cd AND bus.bus_no = receive_h.bus_no AND bus.rkind = 9 WHERE receive_h.comp_cd = 'skvKwjHvns' AND receive_h.rkind = 9 AND receive_b.receive_status = 1 -- AND (receive_h.bus_no = '' OR (bus.public_flg = TRUE or bus.bus_user_id = 1)) GROUP BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) ORDER BY concat(substr(cast(receive_h.receive_date as char), 1, 4),'/',substr(cast(receive_h.receive_date as char), 5, 2)) DESC ; args=('skvKwjHvns', 1); alias=default (0.004) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.004) SELECT concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) as sales_ym , max(sales_h.client_name) as client_name , sum(sales_h.price_before_tax) as price_before_tax FROM sales_tbl_sales_h as sales_h LEFT JOIN sales_tbl_bus as bus ON bus.comp_cd = sales_h.comp_cd AND bus.bus_no = sales_h.bus_no AND bus.rkind = 9 LEFT JOIN sales_tbl_invoice as invoice ON invoice.comp_cd = sales_h.comp_cd AND invoice.invoice_no = sales_h.invoice_no AND invoice.client_cd = sales_h.client_cd AND invoice.rkind = 9 WHERE sales_h.comp_cd = 'skvKwjHvns' AND sales_h.rkind = 9 AND sales_h.sales_status = 2 GROUP BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)), sales_h.client_cd ORDER BY concat(substr(cast(sales_h.sales_date as char), 1, 4),'/',substr(cast(sales_h.sales_date as char), 5, 2)) DESC, sales_h.client_cd ASC ; args=('skvKwjHvns',); alias=default (0.002) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.002) SELECT order_h.order_no , order_h.order_status , order_h.order_date , order_h.client_cd , order_h.client_name , order_h.contact_name , order_h.amount , order_h.order_memo FROM sales_tbl_order_h as order_h WHERE order_h.comp_cd = 'skvKwjHvns' AND order_h.rkind = 9 AND order_h.order_status = 1 ORDER BY order_h.order_no ASC ; args=('skvKwjHvns',); alias=default (0.004) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.004) SELECT buying_h.buying_no , buying_h.buying_date , case when buying_h.adjust_no is not null then 'table-success' else 'bg-white' end as bgcolor , adjust.adjust_date , buying_h.order_no , buying_h.client_cd , buying_h.client_name , buying_h.contact_name , concat(usr.last_name,' ',usr.first_name) as bus_user_name , buying_h.price_before_tax , buying_h.tax , buying_h.price_including_tax , buying_h.buying_memo FROM sales_tbl_buying_h as buying_h LEFT JOIN sales_tbl_adjust as adjust ON adjust.comp_cd = buying_h.comp_cd AND adjust.adjust_no = buying_h.adjust_no AND adjust.client_cd = buying_h.client_cd AND adjust.rkind = 9 LEFT JOIN sales_user as usr ON buying_h.user_id = usr.id WHERE buying_h.comp_cd = 'skvKwjHvns' AND buying_h.rkind = 9 ORDER BY buying_h.buying_no ASC ; args=('skvKwjHvns',); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.000) SELECT `sales_permission`.`id`, `sales_permission`.`permission_name`, `sales_permission`.`created_date`, `sales_permission`.`add_date`, `sales_permission`.`add_user_id`, `sales_permission`.`upd_date`, `sales_permission`.`upd_user_id`, `sales_permission`.`del_flg` FROM `sales_permission` WHERE `sales_permission`.`del_flg` = 0 ORDER BY `sales_permission`.`id` ASC; args=(False,); alias=default (0.002) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.002) SELECT `sales_company`.`comp_cd`, `sales_company`.`created_date`, `sales_company`.`add_date`, `sales_company`.`add_user_id`, `sales_company`.`upd_date`, `sales_company`.`upd_user_id`, `sales_company`.`del_flg`, `sales_company`.`comp_key`, `sales_company`.`comp_name`, `sales_company`.`comp_kana`, `sales_company`.`comp_zip`, `sales_company`.`comp_pref`, `sales_company`.`comp_add1`, `sales_company`.`comp_add2`, `sales_company`.`comp_add3`, `sales_company`.`comp_tel`, `sales_company`.`comp_fax`, `sales_company`.`comp_mobile`, `sales_company`.`comp_closing_month`, `sales_company`.`comp_number`, `sales_company`.`total_amount_disp_flg`, `sales_company`.`business_registration_number`, `sales_company`.`gdrive_cd` FROM `sales_company` WHERE `sales_company`.`comp_cd` = 'skvKwjHvns' LIMIT 21; args=('skvKwjHvns',); alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; args=None; alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.000) SELECT `authtoken_token`.`key`, `authtoken_token`.`user_id`, `authtoken_token`.`created`, `sales_user`.`id`, `sales_user`.`password`, `sales_user`.`last_login`, `sales_user`.`is_superuser`, `sales_user`.`email`, `sales_user`.`first_name`, `sales_user`.`last_name`, `sales_user`.`is_staff`, `sales_user`.`is_active`, `sales_user`.`date_joined`, `sales_user`.`is_admin`, `sales_user`.`authority`, `sales_user`.`comp_cd`, `sales_user`.`dep_id`, `sales_user`.`icon` FROM `authtoken_token` INNER JOIN `sales_user` ON (`authtoken_token`.`user_id` = `sales_user`.`id`) WHERE `authtoken_token`.`key` = '21d536c9dac973ceac6d6e11414b0b0237054cd4' LIMIT 21; args=('21d536c9dac973ceac6d6e11414b0b0237054cd4',); alias=default (0.003) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240730 AND schedule.schedule_out_date <= 20241018) OR (20240730 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241018 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240730, 20241018, 20240730, 20241018); alias=default (0.003) SELECT schedule.id , schedule.client_cd , schedule.client_name , schedule.contact_name , schedule.subject , schedule.contents , schedule.schedule_user_id as user_id , concat(usr.last_name,' ',usr.first_name) as user_name , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time FROM sales_tbl_schedule as schedule LEFT JOIN sales_user as usr ON usr.comp_cd = schedule.comp_cd AND usr.id = schedule.schedule_user_id WHERE schedule.comp_cd = 'skvKwjHvns' AND schedule.rkind = 9 AND ((schedule.schedule_in_date >= 20240730 AND schedule.schedule_out_date <= 20241018) OR (20240730 between schedule.schedule_in_date AND schedule.schedule_out_date) OR (20241018 between schedule.schedule_in_date AND schedule.schedule_out_date)) ORDER BY schedule.schedule_user_id , schedule.schedule_in_date , schedule.schedule_in_time , schedule.schedule_out_date , schedule.schedule_out_time ; args=('skvKwjHvns', 20240730, 20241018, 20240730, 20241018); alias=default (0.002) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240730 AND `sales_holiday`.`holiday` <= 20241018); args=(False, 20240730, 20241018); alias=default (0.002) SELECT `sales_holiday`.`id`, `sales_holiday`.`comp_cd`, `sales_holiday`.`holiday`, `sales_holiday`.`holiday_name`, `sales_holiday`.`created_date`, `sales_holiday`.`add_date`, `sales_holiday`.`add_user_id`, `sales_holiday`.`upd_date`, `sales_holiday`.`upd_user_id`, `sales_holiday`.`del_flg` FROM `sales_holiday` WHERE (`sales_holiday`.`del_flg` = 0 AND `sales_holiday`.`holiday` >= 20240730 AND `sales_holiday`.`holiday` <= 20241018); args=(False, 20240730, 20241018); alias=default