Query Metrics
9575
Database Queries
12
Different statements
2381.82 ms
Query time
8
Invalid entities
0
Cache hits
1
Cache misses
1
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1063.43 ms (44.65%) |
5139 |
SELECT t0.id AS id_1, t0.points AS points_2, t0.note AS note_3, t0.source AS source_4, t0.created_at AS created_at_5, t0.type AS type_6, t0.customer_id AS customer_id_7, t0.origin_order_id AS origin_order_id_8, t0.origin_invoice_id AS origin_invoice_id_9 FROM customer_wallet_point t0 WHERE t0.customer_id = ?
Parameters:
[
3480
]
|
1023.08 ms (42.95%) |
4354 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.nbr_users AS nbr_users_4, t0.nbr_stores AS nbr_stores_5, t0.nbr_vendors AS nbr_vendors_6, t0.nbr_records AS nbr_records_7, t0.nbr_apps AS nbr_apps_8, t0.code AS code_9 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
Parameters:
[
2903
]
|
238.75 ms (10.02%) |
1 |
SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c1_.id AS id_27, c1_.created_at AS created_at_28, c1_.name AS name_29, c1_.code AS code_30, s2_.id AS id_31, s2_.name AS name_32, s2_.description AS description_33, s2_.code AS code_34, s2_.is_enabled AS is_enabled_35, s2_.created_at AS created_at_36, s2_.processing_duration AS processing_duration_37, s2_.preparation_duration AS preparation_duration_38, s2_.shipping_duration AS shipping_duration_39, s2_.price AS price_40, s2_.is_separately_calculated AS is_separately_calculated_41, s2_.calculation_method AS calculation_method_42, s2_.declared_value_tax AS declared_value_tax_43, s2_.papers_fees AS papers_fees_44, s2_.cod_cash_fees AS cod_cash_fees_45, s2_.cod_check_or_bill_fees AS cod_check_or_bill_fees_46, s2_.is_taxes_included_in_price AS is_taxes_included_in_price_47, s2_.deleted_at AS deleted_at_48, u3_.id AS id_49, u3_.username AS username_50, u3_.roles AS roles_51, u3_.password AS password_52, u3_.is_valid AS is_valid_53, u3_.is_verified AS is_verified_54, u3_.exponent_push_token AS exponent_push_token_55, u3_.google_id AS google_id_56, u3_.avatar AS avatar_57, u3_.facebook_id AS facebook_id_58, u3_.is_auto_connect_used AS is_auto_connect_used_59, c4_.id AS id_60, c4_.name AS name_61, c4_.description AS description_62, c4_.is_default AS is_default_63, c4_.is_active AS is_active_64, c4_.color AS color_65, c4_.type AS type_66, c4_.zip_code AS zip_code_67, c4_.region_code AS region_code_68, c4_.lng AS lng_69, c4_.lat AS lat_70, AsBinary(c4_.geo_json) AS geo_json_71, c4_.meta_data AS meta_data_72, p5_.id AS id_73, p5_.start_at AS start_at_74, p5_.end_at AS end_at_75, p5_.description AS description_76, p5_.status AS status_77, p5_.created_at AS created_at_78, s6_.id AS id_79, s6_.name AS name_80, s6_.created_at AS created_at_81, s6_.description AS description_82, s6_.store_type AS store_type_83, s6_.deleted_at AS deleted_at_84, c7_.id AS id_85, c7_.subject AS subject_86, c7_.message AS message_87, c7_.created_at AS created_at_88, c7_.status AS status_89, c0_.customer_group_id AS customer_group_id_90, c0_.user_id AS user_id_91, c0_.vendor_id AS vendor_id_92, c0_.city_region_id AS city_region_id_93, c0_.store_id AS store_id_94, s2_.shipping_vehicle_type_id AS shipping_vehicle_type_id_95, s2_.customer_group_id AS customer_group_id_96, s2_.tax_vat_id AS tax_vat_id_97, s2_.shipping_tax_id AS shipping_tax_id_98, c4_.city_id AS city_id_99, c4_.vendor_id AS vendor_id_100, p5_.product_id AS product_id_101, p5_.customer_id AS customer_id_102, p5_.related_order_id AS related_order_id_103, s6_.city_id AS city_id_104, s6_.user_id AS user_id_105, s6_.city_region_id AS city_region_id_106, c7_.customer_id AS customer_id_107, c7_.complaint_subject_id AS complaint_subject_id_108, c7_.agent_id AS agent_id_109 FROM customer c0_ LEFT JOIN customer_group c1_ ON c0_.customer_group_id = c1_.id LEFT JOIN shipping_method s2_ ON c1_.id = s2_.customer_group_id AND (s2_.deleted_at IS NULL) LEFT JOIN user u3_ ON c0_.user_id = u3_.id LEFT JOIN city_region c4_ ON c0_.city_region_id = c4_.id LEFT JOIN product_subscription p5_ ON c0_.id = p5_.customer_id LEFT JOIN store s6_ ON c0_.store_id = s6_.id AND (s6_.deleted_at IS NULL) LEFT JOIN complaint c7_ ON c0_.id = c7_.customer_id WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.id ASC
Parameters:
[] |
27.91 ms (1.17%) |
1 |
SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.meta_data AS meta_data_26, c0_.customer_group_id AS customer_group_id_27, c0_.user_id AS user_id_28, c0_.vendor_id AS vendor_id_29, c0_.city_region_id AS city_region_id_30, c0_.store_id AS store_id_31 FROM customer c0_ WHERE (c0_.deleted_at IS NULL)
Parameters:
[] |
11.59 ms (0.49%) |
30 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.description AS description_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.company_name AS company_name_6, t0.address AS address_7, t0.city AS city_8, t0.country AS country_9, t0.department AS department_10, t0.postcode AS postcode_11, t0.email AS email_12, t0.tel AS tel_13, t0.comment AS comment_14, t0.status AS status_15, t0.status_shipping AS status_shipping_16, t0.source AS source_17, t0.delivery_at AS delivery_at_18, t0.recovery_at AS recovery_at_19, t0.old_order_number AS old_order_number_20, t0.reduction AS reduction_21, t0.distance AS distance_22, t0.payed_amount AS payed_amount_23, t0.start_processing_at AS start_processing_at_24, t0.delivery_type AS delivery_type_25, t0.start_delivery_at AS start_delivery_at_26, t0.is_to_do AS is_to_do_27, t0.collect_address AS collect_address_28, t0.shipping_address AS shipping_address_29, t0.collect_tel AS collect_tel_30, t0.collect_lng AS collect_lng_31, t0.collect_lat AS collect_lat_32, t0.shipping_lng AS shipping_lng_33, t0.shipping_lat AS shipping_lat_34, t0.is_heavy AS is_heavy_35, t0.shipping_tips AS shipping_tips_36, t0.wallet_payment_amount AS wallet_payment_amount_37, t0.is_checked AS is_checked_38, t0.token_stripe AS token_stripe_39, t0.order_type AS order_type_40, t0.deleted_at AS deleted_at_41, t0.created_by AS created_by_42, t0.meta_data AS meta_data_43, t0.default_currency AS default_currency_44, t0.extra_shipping_fees AS extra_shipping_fees_45, t0.extra_shipping_method_name AS extra_shipping_method_name_46, t0.extra_shipping_infos AS extra_shipping_infos_47, t0.notify_customer AS notify_customer_48, t0.update_notification_message AS update_notification_message_49, t0.customer_id AS customer_id_50, t0.demande_fund_id AS demande_fund_id_51, t0.shipping_method_id AS shipping_method_id_52, t0.agent_id AS agent_id_53, t0.payment_method_id AS payment_method_id_54, t0.coupon_id AS coupon_id_55, t0.agent_to_do_id AS agent_to_do_id_56, t0.city_region_shipping_id AS city_region_shipping_id_57, t0.city_region_collect_id AS city_region_collect_id_58, t0.vendor_id AS vendor_id_59, t0.store_id AS store_id_60, t0.shipment_id AS shipment_id_61, t0.invoice_id AS invoice_id_62, t0.dtype FROM `order` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
508
]
|
6.06 ms (0.25%) |
30 |
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.description AS description_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.product_id AS product_id_7, t0.customer_id AS customer_id_8, t0.related_order_id AS related_order_id_9 FROM product_subscription t0 WHERE t0.related_order_id = ?
Parameters:
[
508
]
|
3.38 ms (0.14%) |
6 |
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.vat_included_in_orders AS vat_included_in_orders_30, t0.vat_displayed_in_orders AS vat_displayed_in_orders_31, t0.side_bar_minimized AS side_bar_minimized_32, t0.mobile_app_scheme AS mobile_app_scheme_33, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_34, t0.developpement_env AS developpement_env_35, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_36, t0.mobile_app_scheme_android AS mobile_app_scheme_android_37, t0.title AS title_38, t0.order_prefix AS order_prefix_39, t0.invoice_prefix AS invoice_prefix_40, t0.is_geo_localisation_api_enabled AS is_geo_localisation_api_enabled_41, t0.is_web_socket_notification_enabled AS is_web_socket_notification_enabled_42, t0.absolute_url AS absolute_url_43, t0.front_theme_id AS front_theme_id_44, t0.default_value_added_tax_id AS default_value_added_tax_id_45, t0.website_theme_id AS website_theme_id_46 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"main"
]
|
2.90 ms (0.12%) |
3 |
SELECT t0.id AS id_2, t0.name AS name_3, t0.image AS image_4, t0.price AS price_5, t0.description AS description_6, t0.old_price AS old_price_7, t0.quantity AS quantity_8, t0.product_type AS product_type_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.meta_keywords AS meta_keywords_12, t0.slug AS slug_13, t0.created_at AS created_at_14, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_15, t0.percent_reduction AS percent_reduction_16, t0.sku_code AS sku_code_17, t0.short_description AS short_description_18, t0.is_published AS is_published_19, t0.sku_code_shop AS sku_code_shop_20, t0.end_at AS end_at_21, t0.type_reduction AS type_reduction_22, t0.value_reduction AS value_reduction_23, t0.subscription_monthly_price AS subscription_monthly_price_24, t0.subscription_yearly_price AS subscription_yearly_price_25, t0.deleted_at AS deleted_at_26, t0.label_price_from AS label_price_from_27, t0.meta_data AS meta_data_28, t0.default_currency AS default_currency_29, t0.video AS video_30, t0.video_thumbnail AS video_thumbnail_31, t0.cost_price AS cost_price_32, t0.position AS position_33, t0.parent_category_id AS parent_category_id_34, t0.promotion_id AS promotion_id_35, t0.vendor_id AS vendor_id_36, t0.brand_id AS brand_id_37, t0.cloned_product_id AS cloned_product_id_38, t0.store_id AS store_id_39, t0.dtype FROM product t0 LEFT JOIN shop_product t1 ON t0.id = t1.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
326
]
|
1.66 ms (0.07%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.old_id AS old_id_7, t0.icon AS icon_8, t0.deleted_at AS deleted_at_9, t0.slug AS slug_10, t0.position AS position_11, t0.parent_category_id AS parent_category_id_12, t0.promotion_id AS promotion_id_13 FROM categoryproduct t0 INNER JOIN product_category_product ON t0.id = product_category_product.category_product_id WHERE product_category_product.product_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
326
]
|
1.49 ms (0.06%) |
3 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.value AS value_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.image AS image_7, t0.sku_code AS sku_code_8, t0.cost_price AS cost_price_9, t0.attribut_id AS attribut_id_10, t0.product_id AS product_id_11 FROM attribut_value t0 WHERE t0.product_id = ?
Parameters:
[
326
]
|
1.33 ms (0.06%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_enabled AS is_enabled_4 FROM complaint_subject t0 WHERE t0.id = ?
Parameters:
[
4
]
|
0.25 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.old_id AS old_id_7, t0.icon AS icon_8, t0.deleted_at AS deleted_at_9, t0.slug AS slug_10, t0.position AS position_11, t0.parent_category_id AS parent_category_id_12, t0.promotion_id AS promotion_id_13 FROM categoryproduct t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
1
Misses
1
Puts
Number of cache misses
Region | Misses |
---|---|
append_depend | 1 |
Number of cache puts
Region | Puts |
---|---|
append_depend | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\IlaveU\ShopBundle\Entity\Customer\Customer | No errors. |
App\Entity\User | No errors. |
App\IlaveU\ShopBundle\Entity\Customer\CustomerGroup | No errors. |
App\IlaveU\ShopBundle\Entity\Vendor\Vendor | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\CityRegion |
|
App\IlaveU\ShopBundle\Entity\Store\Store |
|
App\IlaveU\ShopBundle\Entity\Order\Order |
|
App\IlaveU\ShopBundle\Entity\Product\Comment | No errors. |
App\IlaveU\ShopBundle\Entity\Customer\CustomerAddress | No errors. |
App\IlaveU\ShopBundle\Entity\Customer\CustomerWalletPoint |
|
App\IlaveU\ShopBundle\Entity\Customer\PackEngagement | No errors. |
App\IlaveU\ShopBundle\Entity\Promotion\Coupon | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\Shipment | No errors. |
App\IlaveU\ShopBundle\Entity\Payment\BankBookItem | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\CashOnDelivery | No errors. |
App\IlaveU\ShopBundle\Entity\Product\ProductSubscription | No errors. |
App\IlaveU\ShopBundle\Entity\Accounting\Invoice |
|
App\IlaveU\ShopBundle\Entity\Customer\Complaint | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\ShippingMethod | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\Vehicle\ShippingVehicleType | No errors. |
App\IlaveU\ShopBundle\Entity\Taxes\ValueAddedTax | No errors. |
App\IlaveU\ShopBundle\Entity\Taxes\ShippingTax | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\City | No errors. |
App\IlaveU\ShopBundle\Entity\Product\Product |
|
App\IlaveU\ShopBundle\Entity\Customer\ComplaintSubject | No errors. |
App\IlaveU\ShopBundle\Entity\Resource\Agent | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\ShippingRule | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\ShippingCalculationMethod | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\Country | No errors. |
App\Entity\Role | No errors. |
App\Entity\AiRequest | No errors. |
App\IlaveU\ShopBundle\Entity\Shipping\ShipmentItem | No errors. |
App\IlaveU\ShopBundle\Entity\Product\ProductShop |
|
App\IlaveU\ShopBundle\Entity\Product\CategoryProduct | No errors. |
App\IlaveU\ShopBundle\Entity\Promotion\Promotion | No errors. |
App\IlaveU\ShopBundle\Entity\Brand | No errors. |
App\IlaveU\ShopBundle\Entity\Product\AttributValue | No errors. |
App\IlaveU\ShopBundle\Entity\Product\ImageProduct | No errors. |
App\IlaveU\ShopBundle\Entity\Product\ProductVariant | No errors. |
App\IlaveU\ShopBundle\Entity\Order\OrderItem | No errors. |
App\IlaveU\ShopBundle\Entity\Product\ProductPack |
|
App\IlaveU\ShopBundle\Entity\Payment\PaymentMethod | No errors. |
App\Entity\Settings | No errors. |
App\Entity\FrontTheme | No errors. |
App\Entity\WebsiteTheme | No errors. |
App\IlaveU\ShopBundle\Entity\Product\Attribut | No errors. |
App\IlaveU\ShopBundle\Entity\Order\DemandeFund | No errors. |
App\IlaveU\ShopBundle\Entity\Order\Adjustment | No errors. |