Symfony Profiler

SELECT
  t0_.tenant_cd AS tenant_cd_0
FROM
  tenant t0_
WHERE
  t0_.subfolder = ?

SELECT t0_.tenant_cd AS tenant_cd_0 FROM tenant t0_ WHERE t0_.subfolder = 'inbound';

SELECT
  t0_.user_id AS user_id_0,
  t0_.name AS name_1,
  t0_.kana AS kana_2,
  t0_.user_type AS user_type_3,
  t0_.organization_code AS organization_code_4,
  t0_.username AS username_5,
  t0_.login_enabled AS login_enabled_6,
  t0_.salt AS salt_7,
  t0_.password AS password_8,
  t0_.nyuusya_tsuki AS nyuusya_tsuki_9,
  t0_.taisyoku_tsuki AS taisyoku_tsuki_10,
  t0_.koutuu_hi AS koutuu_hi_11,
  t0_.del_flag AS del_flag_12,
  t0_.update_user_id AS update_user_id_13,
  t0_.update_datetime AS update_datetime_14,
  t0_.create_user_id AS create_user_id_15,
  t0_.create_datetime AS create_datetime_16
FROM
  tbl_user t0_
WHERE
  t0_.user_id = ?

SELECT t0_.user_id AS user_id_0, t0_.name AS name_1, t0_.kana AS kana_2, t0_.user_type AS user_type_3, t0_.organization_code AS organization_code_4, t0_.username AS username_5, t0_.login_enabled AS login_enabled_6, t0_.salt AS salt_7, t0_.password AS password_8, t0_.nyuusya_tsuki AS nyuusya_tsuki_9, t0_.taisyoku_tsuki AS taisyoku_tsuki_10, t0_.koutuu_hi AS koutuu_hi_11, t0_.del_flag AS del_flag_12, t0_.update_user_id AS update_user_id_13, t0_.update_datetime AS update_datetime_14, t0_.create_user_id AS create_user_id_15, t0_.create_datetime AS create_datetime_16 FROM tbl_user t0_ WHERE t0_.user_id = '2000';

SELECT
  r0_.id AS id_0,
  r0_.role_level_no AS role_level_no_1,
  r0_.role_level AS role_level_2,
  r0_.name AS name_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5
FROM
  organization o1_
  INNER JOIN role_level r0_ ON (
    o1_.role_level_no = r0_.role_level_no
  )
WHERE
  o1_.organization_code = ?

SELECT r0_.id AS id_0, r0_.role_level_no AS role_level_no_1, r0_.role_level AS role_level_2, r0_.name AS name_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5 FROM organization o1_ INNER JOIN role_level r0_ ON (o1_.role_level_no = r0_.role_level_no) WHERE o1_.organization_code = '1001';

SELECT
  r0_.module_id AS module_id_0,
  r0_.role_id AS role_id_1,
  r0_.role_id AS role_id_2,
  r0_.module_id AS module_id_3
FROM
  role_module r0_
  INNER JOIN user_role u1_ ON (r0_.role_id = u1_.role_id)
WHERE
  u1_.login_user_id = ?

SELECT r0_.module_id AS module_id_0, r0_.role_id AS role_id_1, r0_.role_id AS role_id_2, r0_.module_id AS module_id_3 FROM role_module r0_ INNER JOIN user_role u1_ ON (r0_.role_id = u1_.role_id) WHERE u1_.login_user_id = 2000;

SELECT
  m0_.name AS name_0,
  m0_.identifier AS identifier_1,
  m0_.is_active AS is_active_2,
  m0_.position AS position_3,
  m0_.id AS id_4,
  m0_.organization_code AS organization_code_5
FROM
  module m0_
WHERE
  (
    m0_.is_active = ?
    AND m0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?
    )
  )
  AND (m0_.organization_code = '1001')

SELECT m0_.name AS name_0, m0_.identifier AS identifier_1, m0_.is_active AS is_active_2, m0_.position AS position_3, m0_.id AS id_4, m0_.organization_code AS organization_code_5 FROM module m0_ WHERE (m0_.is_active = 1 AND m0_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 117, 118, 119, 120, 298, 407, 515, 969)) AND (m0_.organization_code = '1001');

SELECT
  o0_.organization_code AS organization_code_0,
  o0_.ip_address AS ip_address_1
FROM
  organization o0_
WHERE
  o0_.login_flag = ?

SELECT o0_.organization_code AS organization_code_0, o0_.ip_address AS ip_address_1 FROM organization o0_ WHERE o0_.login_flag = 1;

SELECT
  o0_.id AS id_0,
  o0_.organization_code AS organization_code_1,
  o0_.role_level_no AS role_level_no_2,
  o0_.position AS position_3,
  o0_.ip_address AS ip_address_4,
  o0_.name AS name_5,
  o0_.login_flag AS login_flag_6,
  o0_.update_user_id AS update_user_id_7,
  o0_.update_datetime AS update_datetime_8,
  o0_.create_user_id AS create_user_id_9,
  o0_.create_datetime AS create_datetime_10
FROM
  organization o0_
WHERE
  o0_.organization_code = ?

SELECT o0_.id AS id_0, o0_.organization_code AS organization_code_1, o0_.role_level_no AS role_level_no_2, o0_.position AS position_3, o0_.ip_address AS ip_address_4, o0_.name AS name_5, o0_.login_flag AS login_flag_6, o0_.update_user_id AS update_user_id_7, o0_.update_datetime AS update_datetime_8, o0_.create_user_id AS create_user_id_9, o0_.create_datetime AS create_datetime_10 FROM organization o0_ WHERE o0_.organization_code = '1001';

SELECT
  t0.id AS id_1,
  t0.organization_code AS organization_code_2,
  t0.role_level_no AS role_level_no_3,
  t0.position AS position_4,
  t0.ip_address AS ip_address_5,
  t0.name AS name_6,
  t0.login_flag AS login_flag_7,
  t0.update_user_id AS update_user_id_8,
  t0.update_datetime AS update_datetime_9,
  t0.create_user_id AS create_user_id_10,
  t0.create_datetime AS create_datetime_11
FROM
  organization t0
WHERE
  t0.ip_address = ?
  AND t0.login_flag = ?

SELECT t0.id AS id_1, t0.organization_code AS organization_code_2, t0.role_level_no AS role_level_no_3, t0.position AS position_4, t0.ip_address AS ip_address_5, t0.name AS name_6, t0.login_flag AS login_flag_7, t0.update_user_id AS update_user_id_8, t0.update_datetime AS update_datetime_9, t0.create_user_id AS create_user_id_10, t0.create_datetime AS create_datetime_11 FROM organization t0 WHERE t0.ip_address = '111.217.89.138' AND t0.login_flag = 1;

SELECT
  m0_.name AS name_0
FROM
  media m0_

SELECT m0_.name AS name_0 FROM media m0_;

SELECT
  c0_.name AS name_0
FROM
  channel c0_

SELECT c0_.name AS name_0 FROM channel c0_;

SELECT
  p0_.name AS name_0
FROM
  payment_method p0_
ORDER BY
  p0_.position ASC

SELECT p0_.name AS name_0 FROM payment_method p0_ ORDER BY p0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.receive_code AS receive_code_2,
  t0.position AS position_3,
  t0.name AS name_4,
  t0.is_active AS is_active_5,
  t0.update_user_id AS update_user_id_6,
  t0.update_datetime AS update_datetime_7,
  t0.create_user_id AS create_user_id_8,
  t0.create_datetime AS create_datetime_9
FROM
  receive t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.receive_code AS receive_code_2, t0.position AS position_3, t0.name AS name_4, t0.is_active AS is_active_5, t0.update_user_id AS update_user_id_6, t0.update_datetime AS update_datetime_7, t0.create_user_id AS create_user_id_8, t0.create_datetime AS create_datetime_9 FROM receive t0 WHERE t0.is_active = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.identification_code AS identification_code_2,
  t0.identification_id AS identification_id_3,
  t0.position AS position_4,
  t0.is_active AS is_active_5,
  t0.update_user_id AS update_user_id_6,
  t0.update_datetime AS update_datetime_7,
  t0.create_user_id AS create_user_id_8,
  t0.create_datetime AS create_datetime_9
FROM
  identification t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.position DESC

SELECT t0.id AS id_1, t0.identification_code AS identification_code_2, t0.identification_id AS identification_id_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.update_user_id AS update_user_id_6, t0.update_datetime AS update_datetime_7, t0.create_user_id AS create_user_id_8, t0.create_datetime AS create_datetime_9 FROM identification t0 WHERE t0.is_active = 1 ORDER BY t0.position DESC;

SELECT
  t0_.name AS name_0,
  t0_.user_id AS user_id_1
FROM
  tbl_user t0_
WHERE
  t0_.user_type IN ('01', '02')

SELECT t0_.name AS name_0, t0_.user_id AS user_id_1 FROM tbl_user t0_ WHERE t0_.user_type IN ('01', '02');

SELECT
  o0_.id AS id_0,
  o0_.organization_code AS organization_code_1,
  o0_.role_level_no AS role_level_no_2,
  o0_.position AS position_3,
  o0_.ip_address AS ip_address_4,
  o0_.name AS name_5,
  o0_.login_flag AS login_flag_6,
  o0_.update_user_id AS update_user_id_7,
  o0_.update_datetime AS update_datetime_8,
  o0_.create_user_id AS create_user_id_9,
  o0_.create_datetime AS create_datetime_10
FROM
  organization o0_

SELECT o0_.id AS id_0, o0_.organization_code AS organization_code_1, o0_.role_level_no AS role_level_no_2, o0_.position AS position_3, o0_.ip_address AS ip_address_4, o0_.name AS name_5, o0_.login_flag AS login_flag_6, o0_.update_user_id AS update_user_id_7, o0_.update_datetime AS update_datetime_8, o0_.create_user_id AS create_user_id_9, o0_.create_datetime AS create_datetime_10 FROM organization o0_;

SELECT
  d0_.delivery_company_code AS delivery_company_code_0,
  d0_.delivery_time_code AS delivery_time_code_1,
  d0_.name AS name_2
FROM
  delivery_company_relation_delivery_time d0_
ORDER BY
  d0_.position ASC

SELECT d0_.delivery_company_code AS delivery_company_code_0, d0_.delivery_time_code AS delivery_time_code_1, d0_.name AS name_2 FROM delivery_company_relation_delivery_time d0_ ORDER BY d0_.position ASC;

SELECT
  d0_.id AS id_0,
  d0_.position AS position_1,
  d0_.delivery_company_code AS delivery_company_code_2,
  d0_.name AS name_3,
  d0_.is_active AS is_active_4,
  d0_.is_able_to_delivery_date AS is_able_to_delivery_date_5,
  d0_.is_able_to_delivery_time AS is_able_to_delivery_time_6,
  d0_.is_able_to_sender_msg AS is_able_to_sender_msg_7,
  d0_.notify_north_of_kanto AS notify_north_of_kanto_8,
  d0_.notify_nother_than_north_of_kanto AS notify_nother_than_north_of_kanto_9,
  d0_.update_user_id AS update_user_id_10,
  d0_.update_datetime AS update_datetime_11,
  d0_.create_user_id AS create_user_id_12,
  d0_.create_datetime AS create_datetime_13
FROM
  delivery_company d0_
WHERE
  d0_.is_active = ?
ORDER BY
  d0_.position ASC

SELECT d0_.id AS id_0, d0_.position AS position_1, d0_.delivery_company_code AS delivery_company_code_2, d0_.name AS name_3, d0_.is_active AS is_active_4, d0_.is_able_to_delivery_date AS is_able_to_delivery_date_5, d0_.is_able_to_delivery_time AS is_able_to_delivery_time_6, d0_.is_able_to_sender_msg AS is_able_to_sender_msg_7, d0_.notify_north_of_kanto AS notify_north_of_kanto_8, d0_.notify_nother_than_north_of_kanto AS notify_nother_than_north_of_kanto_9, d0_.update_user_id AS update_user_id_10, d0_.update_datetime AS update_datetime_11, d0_.create_user_id AS create_user_id_12, d0_.create_datetime AS create_datetime_13 FROM delivery_company d0_ WHERE d0_.is_active = 1 ORDER BY d0_.position ASC;

SELECT
  t0_.tenant_cd AS tenant_cd_0
FROM
  tenant t0_
WHERE
  t0_.subfolder = ?

SELECT t0_.tenant_cd AS tenant_cd_0 FROM tenant t0_ WHERE t0_.subfolder = 'inbound';

SELECT
  t0.id AS id_1,
  t0.key_str AS key_str_2,
  t0.value_kbn AS value_kbn_3,
  t0.int_value AS int_value_4,
  t0.string_value AS string_value_5,
  t0.date_value AS date_value_6,
  t0.name AS name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  system_setting t0

SELECT t0.id AS id_1, t0.key_str AS key_str_2, t0.value_kbn AS value_kbn_3, t0.int_value AS int_value_4, t0.string_value AS string_value_5, t0.date_value AS date_value_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM system_setting t0;

SELECT
  t0.id AS id_1,
  t0.key_str AS key_str_2,
  t0.value_kbn AS value_kbn_3,
  t0.int_value AS int_value_4,
  t0.string_value AS string_value_5,
  t0.date_value AS date_value_6,
  t0.name AS name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  system_setting t0

SELECT t0.id AS id_1, t0.key_str AS key_str_2, t0.value_kbn AS value_kbn_3, t0.int_value AS int_value_4, t0.string_value AS string_value_5, t0.date_value AS date_value_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM system_setting t0;

SELECT
  t0_.category_id AS category_id_0,
  t0_.item_id AS item_id_1,
  t0_.category_name AS category_name_2,
  t0_.item_name AS item_name_3,
  t0_.del_flag AS del_flag_4,
  t0_.is_active AS is_active_5,
  t0_.position AS position_6,
  t0_.update_user_id AS update_user_id_7,
  t0_.update_datetime AS update_datetime_8,
  t0_.create_user_id AS create_user_id_9,
  t0_.create_datetime AS create_datetime_10,
  t0_.item_id AS item_id_11,
  t0_.item_name AS item_name_12
FROM
  tbl_selectitem t0_
WHERE
  t0_.category_id = ?
  AND t0_.is_active = ?
ORDER BY
  t0_.position ASC,
  t0_.item_id ASC

SELECT t0_.category_id AS category_id_0, t0_.item_id AS item_id_1, t0_.category_name AS category_name_2, t0_.item_name AS item_name_3, t0_.del_flag AS del_flag_4, t0_.is_active AS is_active_5, t0_.position AS position_6, t0_.update_user_id AS update_user_id_7, t0_.update_datetime AS update_datetime_8, t0_.create_user_id AS create_user_id_9, t0_.create_datetime AS create_datetime_10, t0_.item_id AS item_id_11, t0_.item_name AS item_name_12 FROM tbl_selectitem t0_ WHERE t0_.category_id = '19' AND t0_.is_active = 1 ORDER BY t0_.position ASC, t0_.item_id ASC;

SELECT
  t0_.name AS name_0,
  t0_.user_id AS user_id_1
FROM
  tbl_user t0_
WHERE
  t0_.user_type IN ('01', '02')

SELECT t0_.name AS name_0, t0_.user_id AS user_id_1 FROM tbl_user t0_ WHERE t0_.user_type IN ('01', '02');

SELECT
  t0_.category_id AS category_id_0,
  t0_.item_id AS item_id_1,
  t0_.category_name AS category_name_2,
  t0_.item_name AS item_name_3,
  t0_.del_flag AS del_flag_4,
  t0_.is_active AS is_active_5,
  t0_.position AS position_6,
  t0_.update_user_id AS update_user_id_7,
  t0_.update_datetime AS update_datetime_8,
  t0_.create_user_id AS create_user_id_9,
  t0_.create_datetime AS create_datetime_10,
  t0_.item_id AS item_id_11,
  t0_.item_name AS item_name_12
FROM
  tbl_selectitem t0_
WHERE
  t0_.category_id = ?
  AND t0_.is_active = ?
ORDER BY
  t0_.position ASC,
  t0_.item_id ASC

SELECT t0_.category_id AS category_id_0, t0_.item_id AS item_id_1, t0_.category_name AS category_name_2, t0_.item_name AS item_name_3, t0_.del_flag AS del_flag_4, t0_.is_active AS is_active_5, t0_.position AS position_6, t0_.update_user_id AS update_user_id_7, t0_.update_datetime AS update_datetime_8, t0_.create_user_id AS create_user_id_9, t0_.create_datetime AS create_datetime_10, t0_.item_id AS item_id_11, t0_.item_name AS item_name_12 FROM tbl_selectitem t0_ WHERE t0_.category_id = '04' AND t0_.is_active = 1 ORDER BY t0_.position ASC, t0_.item_id ASC;

SELECT
  t0_.category_id AS category_id_0,
  t0_.item_id AS item_id_1,
  t0_.category_name AS category_name_2,
  t0_.item_name AS item_name_3,
  t0_.del_flag AS del_flag_4,
  t0_.is_active AS is_active_5,
  t0_.position AS position_6,
  t0_.update_user_id AS update_user_id_7,
  t0_.update_datetime AS update_datetime_8,
  t0_.create_user_id AS create_user_id_9,
  t0_.create_datetime AS create_datetime_10,
  t0_.item_id AS item_id_11,
  t0_.item_name AS item_name_12
FROM
  tbl_selectitem t0_
WHERE
  t0_.category_id = ?
  AND t0_.is_active = ?
ORDER BY
  t0_.position ASC,
  t0_.item_id ASC

SELECT t0_.category_id AS category_id_0, t0_.item_id AS item_id_1, t0_.category_name AS category_name_2, t0_.item_name AS item_name_3, t0_.del_flag AS del_flag_4, t0_.is_active AS is_active_5, t0_.position AS position_6, t0_.update_user_id AS update_user_id_7, t0_.update_datetime AS update_datetime_8, t0_.create_user_id AS create_user_id_9, t0_.create_datetime AS create_datetime_10, t0_.item_id AS item_id_11, t0_.item_name AS item_name_12 FROM tbl_selectitem t0_ WHERE t0_.category_id = '05' AND t0_.is_active = 1 ORDER BY t0_.position ASC, t0_.item_id ASC;