Query Metrics
42
Database Queries
3
Different statements
12.49 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
10.97 ms (87.78%) |
40 |
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:
[
14
]
|
1.06 ms (8.48%) |
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:
[
"a boire"
]
|
0.47 ms (3.74%) |
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:
[
14
]
|
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\Company | 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\CompanyAssociation | 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\CartProduct | 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\Variable | No errors. |