Query Metrics

31 Database Queries
4 Different statements
10.19 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.17 ms
(80.24%)
28
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  35
]
1.06 ms
(10.38%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.placement AS placement_3, t0.title AS title_4, t0.description AS description_5, t0.tier1maturin_fees_pc AS tier1maturin_fees_pc_6, t0.tier2maturin_fees_pc AS tier2maturin_fees_pc_7, t0.tier2maturin_fees_minprice AS tier2maturin_fees_minprice_8, t0.tier2maturin_fees_maxprice AS tier2maturin_fees_maxprice_9, t0.packing_fees_amount AS packing_fees_amount_10, t0.packing_supplies_fees_amount AS packing_supplies_fees_amount_11, t0.meta_description AS meta_description_12, t0.is_displayed_for_buyer AS is_displayed_for_buyer_13, t0.sub_category_id AS sub_category_id_14, t0.image_id AS image_id_15, t0.banner_id AS banner_id_16 FROM category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "fruits et legumes"
]
0.56 ms
(5.47%)
1
SELECT c0_.id AS id_0, c0_.placement AS placement_1, c0_.name AS name_2 FROM category c0_ WHERE c0_.sub_category_id = ? AND c0_.placement > 0 ORDER BY c0_.placement ASC
Parameters:
[
  35
]
0.40 ms
(3.92%)
1
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.name AS name_3, t0.url_name AS url_name_4, t0.description AS description_5, t0.logo_id AS logo_id_6, t0.banner_id AS banner_id_7 FROM company_association t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  7
]

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
App\Entity\User No errors.
App\Entity\Product No errors.
App\Entity\Image No errors.
App\Entity\Notification No errors.
App\Entity\Message No errors.
App\Entity\Cart No errors.
App\Entity\Category No errors.
App\Entity\CompanyAssociation No errors.
App\Entity\Company No errors.
App\Entity\Variable No errors.
App\Entity\CartProduct No errors.
App\Entity\Pricing No errors.
App\Entity\UserVariables No errors.
App\Entity\UserShippingLocation No errors.
App\Entity\UserSearch No errors.
App\Entity\UserViewedProduct No errors.
App\Entity\FinancialLog No errors.
App\Entity\UserFavorite No errors.
App\Entity\CartCoupon No errors.
App\Entity\RecurringOrder No errors.
App\Entity\Subscription No errors.
App\Entity\EmailSent No errors.
App\Entity\UserSurvey No errors.
App\Entity\Conservation No errors.
App\Entity\Tag No errors.
App\Entity\Ingredient No errors.
App\Entity\Storage No errors.
App\Entity\Certification No errors.
App\Entity\DeliveryLocation No errors.
App\Entity\DeliveryMethod No errors.
App\Entity\CompanyLocation No errors.
App\Entity\Region No errors.
App\Entity\ProductReplenishmentItem No errors.
App\Entity\ProductDeal No errors.
App\Entity\Badge No errors.
App\Entity\Diet No errors.
App\Entity\SuggestedGroup No errors.
App\Entity\ProductInBox No errors.
App\Entity\ProductReplacementScript No errors.
App\Entity\Corporative No errors.
App\Entity\CustomOrder No errors.
App\Entity\MaturinOrder No errors.
App\Entity\Invoice No errors.
App\Entity\CompanyPayment No errors.
App\Entity\CompanySubscription No errors.
App\Entity\CompanyDeposit No errors.
App\Entity\CompanyDefaultShipping No errors.
App\Entity\ProductReplenishment No errors.
App\Entity\InvoiceService No errors.
App\Entity\ProductAdjustment No errors.