Query Metrics
64
Database Queries
14
Different statements
79.07 ms
Query time
9
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
49.76 ms (62.94%) |
50 |
SELECT t0.position AS position_1, t0.id AS id_2, t0.turn_id AS turn_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_turn_taxon t0 WHERE t0.turn_id = ?
Parameters:
[
1405
]
|
|
9.06 ms (11.45%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 3 "es_ES" ] |
|
5.98 ms (7.56%) |
1 |
SELECT DISTINCT id_20 FROM (SELECT DISTINCT id_20, start_14 FROM (SELECT s0_.name AS name_0, s0_.lastname AS lastname_1, s0_.dni AS dni_2, s0_.color AS color_3, s0_.pay_status AS pay_status_4, s0_.turn_status AS turn_status_5, s0_.final_status AS final_status_6, s0_.how_meet_us_other AS how_meet_us_other_7, s0_.phone_number AS phone_number_8, s0_.reschedule AS reschedule_9, s0_.create_customer AS create_customer_10, s0_.create__pay_customer AS create__pay_customer_11, s0_.create_product AS create_product_12, s0_.enabled AS enabled_13, s0_.start AS start_14, s0_.end AS end_15, s0_.duration AS duration_16, s0_.description AS description_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.id AS id_20, s0_.id AS id_21, CASE WHEN s0_.customer_id IS NULL THEN CONCAT(CASE WHEN s0_.lastname IS NULL THEN '' ELSE CONCAT(s0_.lastname, ' ') END, s0_.name) ELSE CONCAT(s1_.last_name, ' ', s1_.first_name) END AS sclr_22, s2_.name AS name_23, CONCAT(s3_.lastname, ' ', s3_.name) AS sclr_24, s0_.start AS start_25, s0_.duration AS duration_26, s0_.turn_status AS turn_status_27, s0_.final_status AS final_status_28, CASE WHEN s4_.id IS NULL THEN s0_.pay_status ELSE s5_.state END AS sclr_29, s1_.id AS id_30, s4_.id AS id_31, s0_.reschedule AS reschedule_32, s0_.enabled AS enabled_33, s1_.first_name AS first_name_34, s1_.last_name AS last_name_35, s3_.name AS name_36, s3_.lastname AS lastname_37, s4_.id AS id_38, s5_.state AS state_39 FROM sylius_turn s0_ LEFT JOIN sylius_customer s1_ ON s0_.customer_id = s1_.id LEFT JOIN sylius_product_room s2_ ON s0_.room_id = s2_.id LEFT JOIN sylius_professional s3_ ON s0_.professional_id = s3_.id LEFT JOIN sylius_pay_customer s4_ ON s0_.payCustomer_id = s4_.id LEFT JOIN sylius_turn_taxon s6_ ON s0_.id = s6_.turn_id LEFT JOIN sylius_taxon s7_ ON s6_.taxon_id = s7_.id LEFT JOIN sylius_taxon_translation s8_ ON s7_.id = s8_.translatable_id LEFT JOIN sylius_pay s5_ ON s4_.pay_id = s5_.id WHERE s0_.enabled = ?) dctrn_result_inner ORDER BY start_14 DESC) dctrn_result LIMIT 50
Parameters:
[
1
]
|
|
4.65 ms (5.88%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_20 FROM (SELECT s0_.name AS name_0, s0_.lastname AS lastname_1, s0_.dni AS dni_2, s0_.color AS color_3, s0_.pay_status AS pay_status_4, s0_.turn_status AS turn_status_5, s0_.final_status AS final_status_6, s0_.how_meet_us_other AS how_meet_us_other_7, s0_.phone_number AS phone_number_8, s0_.reschedule AS reschedule_9, s0_.create_customer AS create_customer_10, s0_.create__pay_customer AS create__pay_customer_11, s0_.create_product AS create_product_12, s0_.enabled AS enabled_13, s0_.start AS start_14, s0_.end AS end_15, s0_.duration AS duration_16, s0_.description AS description_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.id AS id_20, s0_.id AS id_21, CASE WHEN s0_.customer_id IS NULL THEN CONCAT(CASE WHEN s0_.lastname IS NULL THEN '' ELSE CONCAT(s0_.lastname, ' ') END, s0_.name) ELSE CONCAT(s1_.last_name, ' ', s1_.first_name) END AS sclr_22, s2_.name AS name_23, CONCAT(s3_.lastname, ' ', s3_.name) AS sclr_24, s0_.start AS start_25, s0_.duration AS duration_26, s0_.turn_status AS turn_status_27, s0_.final_status AS final_status_28, CASE WHEN s4_.id IS NULL THEN s0_.pay_status ELSE s5_.state END AS sclr_29, s1_.id AS id_30, s4_.id AS id_31, s0_.reschedule AS reschedule_32, s0_.enabled AS enabled_33 FROM sylius_turn s0_ LEFT JOIN sylius_customer s1_ ON s0_.customer_id = s1_.id LEFT JOIN sylius_product_room s2_ ON s0_.room_id = s2_.id LEFT JOIN sylius_professional s3_ ON s0_.professional_id = s3_.id LEFT JOIN sylius_pay_customer s4_ ON s0_.payCustomer_id = s4_.id LEFT JOIN sylius_turn_taxon s6_ ON s0_.id = s6_.turn_id LEFT JOIN sylius_taxon s7_ ON s6_.taxon_id = s7_.id LEFT JOIN sylius_taxon_translation s8_ ON s7_.id = s8_.translatable_id LEFT JOIN sylius_pay s5_ ON s4_.pay_id = s5_.id WHERE s0_.enabled = ? ORDER BY s0_.start DESC) dctrn_result) dctrn_table
Parameters:
[
1
]
|
|
3.91 ms (4.95%) |
2 |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.shop_billing_data_id AS shop_billing_data_id_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.enabled AS enabled_28, t26.by_default AS by_default_29, t26.created_at AS created_at_30, t26.updated_at AS updated_at_31, t26.id AS id_32, t0.default_tax_zone_id AS default_tax_zone_id_33, t0.menu_taxon_id AS menu_taxon_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id
Parameters:
[] |
|
2.19 ms (2.77%) |
1 |
SELECT s0_.name AS name_0, s0_.lastname AS lastname_1, s0_.dni AS dni_2, s0_.color AS color_3, s0_.pay_status AS pay_status_4, s0_.turn_status AS turn_status_5, s0_.final_status AS final_status_6, s0_.how_meet_us_other AS how_meet_us_other_7, s0_.phone_number AS phone_number_8, s0_.reschedule AS reschedule_9, s0_.create_customer AS create_customer_10, s0_.create__pay_customer AS create__pay_customer_11, s0_.create_product AS create_product_12, s0_.enabled AS enabled_13, s0_.start AS start_14, s0_.end AS end_15, s0_.duration AS duration_16, s0_.description AS description_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.id AS id_20, s0_.id AS id_21, CASE WHEN s0_.customer_id IS NULL THEN CONCAT(CASE WHEN s0_.lastname IS NULL THEN '' ELSE CONCAT(s0_.lastname, ' ') END, s0_.name) ELSE CONCAT(s1_.last_name, ' ', s1_.first_name) END AS sclr_22, s2_.name AS name_23, CONCAT(s3_.lastname, ' ', s3_.name) AS sclr_24, s0_.start AS start_25, s0_.duration AS duration_26, s0_.turn_status AS turn_status_27, s0_.final_status AS final_status_28, CASE WHEN s4_.id IS NULL THEN s0_.pay_status ELSE s5_.state END AS sclr_29, s1_.id AS id_30, s4_.id AS id_31, s0_.reschedule AS reschedule_32, s0_.enabled AS enabled_33, s0_.payCustomer_id AS payCustomer_id_34, s0_.product_id AS product_id_35, s0_.professional_id AS professional_id_36, s0_.customer_id AS customer_id_37, s0_.room_id AS room_id_38, s0_.main_taxon_id AS main_taxon_id_39 FROM sylius_turn s0_ LEFT JOIN sylius_customer s1_ ON s0_.customer_id = s1_.id LEFT JOIN sylius_product_room s2_ ON s0_.room_id = s2_.id LEFT JOIN sylius_professional s3_ ON s0_.professional_id = s3_.id LEFT JOIN sylius_pay_customer s4_ ON s0_.payCustomer_id = s4_.id LEFT JOIN sylius_turn_taxon s6_ ON s0_.id = s6_.turn_id LEFT JOIN sylius_taxon s7_ ON s6_.taxon_id = s7_.id LEFT JOIN sylius_taxon_translation s8_ ON s7_.id = s8_.translatable_id LEFT JOIN sylius_pay s5_ ON s4_.pay_id = s5_.id WHERE s0_.enabled = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.start DESC
Parameters:
[ 1 1405 1414 1419 1416 1421 1418 1415 1420 1400 1417 1413 1412 1404 1390 1411 1403 1408 1410 1409 1398 1392 1402 1391 1407 1406 1393 1397 1396 1395 1401 1385 1386 1388 1387 1394 1389 1399 1384 1383 1380 1376 1335 1382 1379 1378 1381 1377 1369 1348 1359 ] |
|
0.99 ms (1.25%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.locale_code AS locale_code_23, t0.type AS type_24, t0.phone AS phone_25, t0.birthday AS birthday_26, t0.adminUserGroup_id AS adminUserGroup_id_27, t0.professional_id AS professional_id_28, t29.type AS type_30, t29.legend AS legend_31, t29.path AS path_32, t29.id AS id_33, t29.owner_id AS owner_id_34 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t29 ON t29.owner_id = t0.id WHERE t0.id = ?
Parameters:
[
20
]
|
|
0.51 ms (0.65%) |
1 |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.shop_billing_data_id AS shop_billing_data_id_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.enabled AS enabled_28, t26.by_default AS by_default_29, t26.created_at AS created_at_30, t26.updated_at AS updated_at_31, t26.id AS id_32, t0.default_tax_zone_id AS default_tax_zone_id_33, t0.menu_taxon_id AS menu_taxon_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id WHERE t0.hostname = ? AND t0.enabled = ? LIMIT 1
Parameters:
[ "cmp-system.com" 1 ] |
|
0.41 ms (0.52%) |
1 |
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.path AS path_6, t0.price AS price_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.currency_id AS currency_id_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.39 ms (0.49%) |
1 |
SELECT t0.state AS state_1, t0.imports AS imports_2, t0.pays AS pays_3, t0.balance AS balance_4, t0.credit AS credit_5, t0.enabled AS enabled_6, t0.finish AS finish_7, t0.import_negative AS import_negative_8, t0.pay_currency_code AS pay_currency_code_9, t0.description AS description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.id AS id_13, t0.payProvider_id AS payProvider_id_14, t0.payCustomer_id AS payCustomer_id_15, t0.payProfessional_id AS payProfessional_id_16, t0.payFixAcount_id AS payFixAcount_id_17, t0.product_id AS product_id_18, t0.pay_fixed_id AS pay_fixed_id_19, t0.currency_id AS currency_id_20 FROM sylius_pay t0 WHERE t0.id = ?
Parameters:
[
974
]
|
|
0.33 ms (0.42%) |
1 |
SELECT t0.enabled AS enabled_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.pay_id AS pay_id_6, t0.turn_id AS turn_id_7, t0.customer_id AS customer_id_8 FROM sylius_pay_customer t0 WHERE t0.id = ?
Parameters:
[
916
]
|
|
0.31 ms (0.39%) |
1 |
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ?
Parameters:
[
1
]
|
|
0.30 ms (0.38%) |
1 |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
1
]
|
|
0.27 ms (0.35%) |
1 |
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
1
]
|
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 |
|---|---|
| Sylius\Component\Order\Model\Order | No errors. |
| Sylius\Component\Core\Model\Order | No errors. |
| Sylius\Component\Shipping\Model\Shipment | No errors. |
| Sylius\Component\Core\Model\Shipment | No errors. |
| Sylius\Component\User\Model\User | No errors. |
| Sylius\Component\Core\Model\AdminUser |
|
| Sylius\Component\Core\Model\AdminUserGroup | No errors. |
| Sylius\Component\Customer\Model\Professional | No errors. |
| Sylius\Component\Core\Model\Image | No errors. |
| Sylius\Component\Core\Model\AvatarImage | No errors. |
| Sylius\Component\Customer\Model\Customer |
|
| Sylius\Component\User\Model\UserOAuth | No errors. |
| Sylius\Component\Channel\Model\Channel | No errors. |
| Sylius\Component\Core\Model\Channel | No errors. |
| Sylius\Component\Core\Model\ShopBillingData | No errors. |
| Sylius\Component\Locale\Model\Locale | No errors. |
| Sylius\Component\Currency\Model\Currency |
|
| Sylius\Component\Addressing\Model\Zone | No errors. |
| Sylius\Component\Taxonomy\Model\Taxon | No errors. |
| Sylius\Component\Core\Model\Taxon | No errors. |
| Sylius\Component\Payment\Model\PayAcount | No errors. |
| Sylius\Component\Addressing\Model\Country | No errors. |
| Sylius\Component\Customer\Model\Turn |
|
| Sylius\Component\Product\Model\ProductRoom | No errors. |
| Sylius\Component\Payment\Model\PayCustomer |
|
| Sylius\Component\Customer\Model\TurnTaxon | No errors. |
| Sylius\Component\Taxonomy\Model\TaxonTranslation | No errors. |
| Sylius\Component\Payment\Model\Pay | No errors. |
| Sylius\Component\Product\Model\Product |
|
| Sylius\Component\Core\Model\Product |
|
| Sylius\Component\Core\Model\ProductTaxon | No errors. |
| Sylius\Component\Core\Model\TaxonImage | No errors. |
| Sylius\Component\Payment\Model\PayProvider | No errors. |
| Sylius\Component\Payment\Model\PayProfessional |
|
| Sylius\Component\Payment\Model\PayFixAcount | No errors. |
| Sylius\Component\Payment\Model\PayFixed |
|
| Sylius\Component\Payment\Model\PayImport | No errors. |
| Sylius\Component\Payment\Model\PayMov | No errors. |