Query Metrics
2
Database Queries
2
Different statements
0.46 ms
Query time
0
Invalid entities
0
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.30 ms |
SELECT i0_.id AS id_0, i0_.ip_address AS ip_address_1, i0_.reason AS reason_2, i0_.created_at AS created_at_3, i0_.expires_at AS expires_at_4, i0_.is_active AS is_active_5, i0_.created_by_id AS created_by_id_6 FROM `ip_blacklist` i0_ WHERE i0_.ip_address = ? AND i0_.is_active = 1 AND ((i0_.expires_at IS NULL OR i0_.expires_at > ?))
Parameters:
[ "66.249.73.130" "2026-07-28 02:30:12" ] |
||||||||||||||||||||||
| 2 | 0.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.fields AS fields_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.lookup AS lookup_10, t0.is_business AS is_business_11, t0.url AS url_12, t0.phone_number AS phone_number_13, t0.condition_rating AS condition_rating_14, t0.media_url AS media_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.owner_id AS owner_id_18, t0.category_id AS category_id_19, t0.location_id AS location_id_20, t0.listing_type_id AS listing_type_id_21, t0.offer_type_id AS offer_type_id_22, t0.price_type_id AS price_type_id_23, t0.state_id AS state_id_24, t0.status_id AS status_id_25 FROM listing t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"2023-cadillac-escalade-esv-4wd-premium-luxury"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| forsalebyowner | doctrine.dbal.forsalebyowner_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| forsalebyowner | doctrine.orm.forsalebyowner_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
forsalebyowner entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\IpBlacklist | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Listing | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\City | No errors. |
| App\Entity\ListingType | No errors. |
| App\Entity\OfferType | No errors. |
| App\Entity\PriceType | No errors. |
| App\Entity\ListingCondition | No errors. |
| App\Entity\ListingStatus | No errors. |
| App\Entity\IpBlacklistHistory | No errors. |
| App\Entity\UserAddress | No errors. |
| App\Entity\Store | No errors. |
| App\Entity\Conversation | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\UserFavorite | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\ImportLog | No errors. |
| App\Entity\UserServerEmail | No errors. |
| App\Entity\ListingImage | No errors. |
| App\Entity\StoreListing | No errors. |
| App\Entity\ListingViewCount | No errors. |
| App\Entity\ListingPhoneClick | No errors. |
| App\Entity\CategoryForm | No errors. |
| App\Entity\VehicleModel | No errors. |
| App\Entity\Province | No errors. |
| App\Entity\PostalCode | No errors. |
forsalebyowner entity manager
No loaded entities.