Query Metrics
2
Database Queries
2
Different statements
0.51 ms
Query time
0
Invalid entities
17
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.28 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:
[ "216.73.217.9" "2026-06-05 14:45:32" ] |
||||||||||||||||||||||||||
| 2 | 0.23 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.word_limit AS word_limit_2, p0_.photo_limit AS photo_limit_3, p0_.conversation_limit AS conversation_limit_4, p0_.allowed_media_link AS allowed_media_link_5, p0_.slug AS slug_6, p0_.base_listing_limit AS base_listing_limit_7, p0_.base_store_limit AS base_store_limit_8, p0_.listings_per_addon_store AS listings_per_addon_store_9, p0_.is_active AS is_active_10, p0_.is_custom AS is_custom_11, p0_.addon_store_price AS addon_store_price_12, p0_.description AS description_13, p0_.allowed_website AS allowed_website_14, p1_.id AS id_15, p1_.price AS price_16, p1_.is_active AS is_active_17, p1_.billing_cycle AS billing_cycle_18, p1_.plan_id AS plan_id_19 FROM plan p0_ LEFT JOIN plan_pricing_option p1_ ON p0_.id = p1_.plan_id AND (p1_.is_active = ?) WHERE p0_.is_active = ? AND p0_.is_custom = ? ORDER BY p0_.base_listing_limit ASC
Parameters:
[ 1 1 0 ]
|
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 |
|---|---|
| App\Entity\PlanPricingOption | 13 |
| App\Entity\Plan | 4 |
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\Plan | No errors. |
| App\Entity\PlanPricingOption | No errors. |
| App\Entity\Promo | No errors. |
| App\Entity\Subscription | No errors. |
forsalebyowner entity manager
No loaded entities.