https://flap-shop.com/administrator/customer/page/1?resume=1

Query Metrics

18 Database Queries
17 Different statements
4.47 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.75 ms
(39.18%)
1
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_customer d0_ WHERE (d0_.customer_status_id IN (?, ?)) AND d0_.discriminator_type IN ('customer')
Parameters:
[
  1
  2
]
0.86 ms
(19.24%)
1
SELECT d0_.id AS id_0, d0_.name01 AS name01_1, d0_.name02 AS name02_2, d0_.kana01 AS kana01_3, d0_.kana02 AS kana02_4, d0_.company_name AS company_name_5, d0_.postal_code AS postal_code_6, d0_.addr01 AS addr01_7, d0_.addr02 AS addr02_8, d0_.email AS email_9, d0_.phone_number AS phone_number_10, d0_.birth AS birth_11, d0_.password AS password_12, d0_.salt AS salt_13, d0_.secret_key AS secret_key_14, d0_.first_buy_date AS first_buy_date_15, d0_.last_buy_date AS last_buy_date_16, d0_.buy_times AS buy_times_17, d0_.buy_total AS buy_total_18, d0_.note AS note_19, d0_.reset_key AS reset_key_20, d0_.reset_expire AS reset_expire_21, d0_.point AS point_22, d0_.create_date AS create_date_23, d0_.update_date AS update_date_24, d0_.gmo_epsilon_credit_card_expiration_date AS gmo_epsilon_credit_card_expiration_date_25, d0_.card_change_request_mail_send_date AS card_change_request_mail_send_date_26, d0_.check_date AS check_date_27, d0_.discriminator_type AS discriminator_type_28, d0_.customer_status_id AS customer_status_id_29, d0_.sex_id AS sex_id_30, d0_.job_id AS job_id_31, d0_.country_id AS country_id_32, d0_.pref_id AS pref_id_33, d0_.customer_rank_id AS customer_rank_id_34 FROM dtb_customer d0_ WHERE (d0_.customer_status_id IN (?, ?) AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('customer') ORDER BY d0_.update_date DESC, d0_.id DESC
Parameters:
[
  1
  2
  287
  124
  1916
  300
  120
  994
  239
  678
  222
  725
  1782
  30
  1493
  471
  309
  1940
  868
  1938
  1939
  1035
  1807
  1337
  621
  1595
  1920
  229
  695
  1917
  402
  1132
  876
  369
  784
  91
  909
  578
  67
  1844
  1122
  1171
  36
  1357
  1841
  1631
  277
  928
  361
  1717
  258
  415
]
0.32 ms
(7.19%)
1
SELECT DISTINCT d0_.id AS id_0, d0_.update_date AS update_date_1, d0_.id AS id_2 FROM dtb_customer d0_ WHERE (d0_.customer_status_id IN (?, ?)) AND d0_.discriminator_type IN ('customer') ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 50
Parameters:
[
  1
  2
]
0.16 ms
(3.69%)
2
SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = ? AND t0.discriminator_type IN ('authorityrole')
Parameters:
[
  1
]
0.15 ms
(3.44%)
1
SET SESSION time_zone = '+00:00'
Parameters:
[]
0.14 ms
(3.07%)
1
SELECT t0.id AS id_1, t0.contract_code AS contract_code_2, t0.environmental_setting AS environmental_setting_3, t0.credit_payment_setting AS credit_payment_setting_4, t0.use_payment AS use_payment_5, t0.use_convenience AS use_convenience_6, t0.card_expiration_notification_days AS card_expiration_notification_days_7, t0.regular AS regular_8, t0.block_mode AS block_mode_9, t0.access_frequency_time AS access_frequency_time_10, t0.access_frequency AS access_frequency_11, t0.block_time AS block_time_12, t0.white_list AS white_list_13, t0.regular_order_notification_email AS regular_order_notification_email_14, t0.next_delivery_date_changeable_range_days AS next_delivery_date_changeable_range_days_15, t0.first_delivery_days AS first_delivery_days_16, t0.next_delivery_days_at_regular_resumption AS next_delivery_days_at_regular_resumption_17, t0.next_delivery_days_after_re_payment AS next_delivery_days_after_re_payment_18, t0.regular_order_deadline AS regular_order_deadline_19, t0.regular_delivery_notification_email_days AS regular_delivery_notification_email_days_20, t0.regular_stoppable_count AS regular_stoppable_count_21, t0.regular_cancelable_count AS regular_cancelable_count_22, t0.regular_resumable_period AS regular_resumable_period_23, t0.regular_specified_count_notification_mail AS regular_specified_count_notification_mail_24, t0.regular_point_magnification AS regular_point_magnification_25 FROM plg_eccube_payment_lite42_config t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.11 ms
(2.57%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_customer_status m0_ WHERE m0_.discriminator_type IN ('customerstatus') ORDER BY m0_.sort_no ASC
Parameters:
[]
0.11 ms
(2.51%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_pref m0_ WHERE m0_.discriminator_type IN ('pref') ORDER BY m0_.sort_no ASC
Parameters:
[]
0.10 ms
(2.35%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_customer_status t0 WHERE t0.id IN (?, ?) AND t0.discriminator_type IN ('customerstatus')
Parameters:
[
  1
  2
]
0.10 ms
(2.33%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.discount_rate AS discount_rate_2, p0_.discount_value AS discount_value_3, p0_.point_rate AS point_rate_4, p0_.delivery_free_condition AS delivery_free_condition_5, p0_.cond_amount AS cond_amount_6, p0_.cond_buytimes AS cond_buytimes_7, p0_.initial_flg AS initial_flg_8, p0_.fixed_flg AS fixed_flg_9, p0_.priority AS priority_10, p0_.extension_period AS extension_period_11, p0_.create_date AS create_date_12, p0_.update_date AS update_date_13, p0_.discriminator_type AS discriminator_type_14 FROM plg_customerrank_dtb_customer_rank p0_ WHERE p0_.discriminator_type IN ('customerrank') ORDER BY p0_.priority DESC
Parameters:
[]
0.10 ms
(2.28%)
1
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.authentication_key AS authentication_key_29, t0.php_path AS php_path_30, t0.option_point AS option_point_31, t0.basic_point_rate AS basic_point_rate_32, t0.point_conversion_rate AS point_conversion_rate_33, t0.country_id AS country_id_34, t0.pref_id AS pref_id_35, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
  1
]
0.10 ms
(2.24%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.login_id AS login_id_4, t0.password AS password_5, t0.salt AS salt_6, t0.sort_no AS sort_no_7, t0.two_factor_auth_key AS two_factor_auth_key_8, t0.two_factor_auth_enabled AS two_factor_auth_enabled_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.login_date AS login_date_12, t0.work_id AS work_id_13, t0.authority_id AS authority_id_14, t0.creator_id AS creator_id_15, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = ? AND t0.work_id = ? AND t0.discriminator_type IN ('member') LIMIT 1
Parameters:
[
  "flapshop"
  1
]
0.10 ms
(2.21%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_customer_status m0_ WHERE (m0_.id IN (?, ?)) AND m0_.discriminator_type IN ('customerstatus') ORDER BY m0_.sort_no ASC
Parameters:
[
  "1"
  "2"
]
0.10 ms
(2.19%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_page_max t0 WHERE t0.discriminator_type IN ('pagemax')
Parameters:
[]
0.10 ms
(2.15%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_sex m0_ WHERE m0_.discriminator_type IN ('sex') ORDER BY m0_.sort_no ASC
Parameters:
[]
0.09 ms
(1.95%)
1
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[]
0.06 ms
(1.41%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Eccube\Entity\AbstractEntity No errors.
Eccube\Entity\Product No errors.
Eccube\Entity\BaseInfo No errors.
Eccube\Entity\Page No errors.
Eccube\Entity\PageLayout No errors.
Eccube\Entity\Block No errors.
Eccube\Entity\BlockPosition No errors.
Eccube\Entity\Master\AbstractMasterEntity No errors.
Eccube\Entity\Master\DeviceType No errors.
Eccube\Entity\AuthorityRole No errors.
Eccube\Entity\Layout No errors.
Eccube\Entity\Member No errors.
Eccube\Entity\Master\Work No errors.
Eccube\Entity\Master\Authority No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Eccube\Entity\Master\PageMax No errors.
Eccube\Entity\Order No errors.
Eccube\Entity\Customer No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\MailHistory No errors.
Eccube\Entity\Csv No errors.
Eccube\Entity\Master\CsvType No errors.
Eccube\Entity\Shipping No errors.
Plugin\EccubePaymentLite42\Entity\Config No errors.
Plugin\EccubePaymentLite42\Entity\GmoEpsilonPayment No errors.
Plugin\EccubePaymentLite42\Entity\ConvenienceStore No errors.
Plugin\EccubePaymentLite42\Entity\IpBlackList No errors.
Plugin\EccubePaymentLite42\Entity\MyPageRegularSetting No errors.
Eccube\Entity\Master\CustomerStatus No errors.
Plugin\CustomerRank42\Entity\CustomerRank No errors.
Eccube\Entity\Master\Job No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Eccube\Entity\CustomerAddress No errors.
Plugin\CustomerRank42\Entity\CustomerRankConfig No errors.
Plugin\CustomerRank42\Entity\ConfigStatus No errors.