Query Metrics
2
Database Queries
2
Different statements
0.49 ms
Query time
22
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.display_name AS display_name_4, t0.is_active AS is_active_5 FROM language t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
||||||||||||||||||||||||||||
| 2 | 0.16 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_main AS is_main_2, c0_.generic_value AS generic_value_3, c0_.high_value_threshold AS high_value_threshold_4, c0_.is_updated AS is_updated_5, c0_.is_active AS is_active_6, c0_.can_have_cp AS can_have_cp_7, c0_.slug AS slug_8, c0_.is_public AS is_public_9, c0_.generic_high_value AS generic_high_value_10, c0_.newsletter_default_footer_image AS newsletter_default_footer_image_11, c0_.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_12, c0_.google_id AS google_id_13, c0_.max_quantity_same_lot_item AS max_quantity_same_lot_item_14, c0_.parent_id AS parent_id_15, c0_.scan_category_group_id AS scan_category_group_id_16 FROM category c0_ INNER JOIN category_lang c1_ ON c0_.id = c1_.category_id AND (c1_.language_id = ?) WHERE c1_.slug = ? AND c0_.is_active = 1 AND c0_.is_public = 1 HAVING c0_.parent_id IS NOT NULL
Parameters:
[ 2 "office-and-school-supplies" ]
|
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\Language | No errors. |
| App\Entity\Front\CountryLang | No errors. |
| App\Entity\Front\Cart | No errors. |
| App\Entity\Front\Order |
|
| App\Entity\Information\ProductConditionLang | No errors. |
| App\Entity\Front\Customer |
|
| App\Entity\CategoryLang | No errors. |
| App\Entity\SupplierLang | No errors. |
| App\Entity\Front\WebsitePageLang | No errors. |
| App\Entity\Front\HomepageAlertLang | No errors. |
| App\Entity\Category |
|
| App\Entity\ScanCategoryGroup |
|
| App\Entity\Product |
|
| App\Entity\ProductConditionDiscount | No errors. |
| App\Entity\MappingCategory |
|
| App\Entity\CategoryAction | No errors. |
| App\Entity\Lot |
|
| App\Entity\SupplierProductConditionDiscount | No errors. |
| App\Entity\SupplierCategoryValue | No errors. |
| App\Entity\Front\FrontProduct | No errors. |
| App\Entity\Newsletter | No errors. |
| App\Entity\ReportStockRotationEntry | No errors. |
| App\Entity\Front\OrderCategoryDiscount | No errors. |
| App\Entity\Front\Country | No errors. |
| App\Entity\Front\CartProduct | No errors. |
| App\Entity\Front\ShippingMode |
|
| App\Entity\Front\Address |
|
| App\Entity\Front\State | No errors. |
| App\Entity\Front\CartShippingMode | No errors. |
| App\Entity\Front\CartDiscount | No errors. |
| App\Entity\Front\OrderFrontProduct | No errors. |
| App\Entity\Front\OrderShippingTax | No errors. |
| App\Entity\Front\OrderStatus |
|
| App\Entity\Front\OrderHistory | No errors. |
| App\Entity\Front\OrderPaymentIntent | No errors. |
| App\Entity\Front\OrderPayment | No errors. |
| App\Entity\Front\OrderDiscount | No errors. |
| App\Entity\Front\OrderDiscountTax | No errors. |
| App\Entity\Warehouse |
|
| App\Entity\Front\TaxRuleGroup |
|
| App\Entity\Front\OrderFrontProductTax | No errors. |
| App\Entity\Front\OrderRefund | No errors. |
| App\Entity\StockUpdate | No errors. |
| App\Entity\Information\ProductCondition |
|
| App\Entity\Front\CustomerGroup | No errors. |
| App\Entity\Front\WhishListItem | No errors. |
| App\Entity\Truckload | No errors. |
| App\Entity\Supplier |
|
| App\Entity\Front\WebsitePage | No errors. |
| App\Entity\Front\HomepageAlert | No errors. |
| App\Entity\TriageScan | No errors. |
| App\Entity\ScanSession | No errors. |
| App\Entity\ReportScanGroup | No errors. |
| App\Entity\ReportPerformanceEntryGroup |
|
| App\Entity\User |
|
| App\Entity\ProductAction | No errors. |
| App\Entity\MerchantSku | No errors. |
| App\Entity\ManifestItem |
|
| App\Entity\LotItem | No errors. |
| App\Entity\PreparationLot |
|
| App\Entity\Analysis\UpcItemDb | No errors. |
| App\Entity\ProductUpdateLog | No errors. |
| App\Entity\ProductCpPhoto | No errors. |
| App\Entity\MarketingPhoto | No errors. |
| App\Entity\Analysis\Synccentric | No errors. |
| App\Entity\InternalSku |
|
| App\Entity\Information\Action |
|
| App\Entity\Po |
|
| App\Entity\TruckloadLot |
|
| App\Entity\LotPhoto | No errors. |
| App\Entity\StockLocationUpdate | No errors. |
| App\Entity\CombinedManifestLot | No errors. |
| App\Entity\Front\FrontProductImage | No errors. |
| App\Entity\TruckloadFrontProduct | No errors. |
| App\Entity\Front\FrontProductListingProgress | No errors. |
| App\Entity\StockLocation | No errors. |
| App\Entity\TruckloadIncludedFrontProduct | No errors. |
| App\Entity\ReportStockRotation | No errors. |