Query Metrics
18
Database Queries
7
Different statements
1.95 ms
Query time
0
Invalid entities
44
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.23 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 17:51:34" ] |
||||||||||||||||||||||||||||||
| 2 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.header_image AS header_image_5, t0.background_image AS background_image_6, t0.shelf_image AS shelf_image_7, t0.is_published AS is_published_8, t0.header_text AS header_text_9, t0.header_text_type AS header_text_type_10, t0.header_sign_type AS header_sign_type_11, t0.header_font_size AS header_font_size_12, t0.header_background_color AS header_background_color_13, t0.header_text_color AS header_text_color_14, t0.header_font_weight AS header_font_weight_15, t0.frame_color AS frame_color_16, t0.background_color AS background_color_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.user_id AS user_id_20, t0.layout_id AS layout_id_21 FROM store t0 WHERE t0.id = ?
Parameters:
[
"44"
]
|
||||||||||||||||||||||||||||||
| 3 | 0.15 ms |
SELECT s0_.id AS id_0, s0_.store_row AS store_row_1, s0_.store_column AS store_column_2, s0_.position AS position_3, s0_.image AS image_4, s0_.store_id AS store_id_5, s0_.listing_id AS listing_id_6 FROM store_listing s0_ WHERE s0_.store_id = ?
Parameters:
[
44
]
|
||||||||||||||||||||||||||||||
| 4 | 0.14 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.id = ?
Parameters:
[
3200894
]
|
||||||||||||||||||||||||||||||
| 5 | 0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_value AS is_value_3 FROM price_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 6 | 0.10 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.id = ?
Parameters:
[
3211107
]
|
||||||||||||||||||||||||||||||
| 7 | 0.10 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.id = ?
Parameters:
[
3245744
]
|
||||||||||||||||||||||||||||||
| 8 | 0.10 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.id = ?
Parameters:
[
3245745
]
|
||||||||||||||||||||||||||||||
| 9 | 0.08 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.id = ?
Parameters:
[
3245747
]
|
||||||||||||||||||||||||||||||
| 10 | 0.08 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.id = ?
Parameters:
[
3245749
]
|
||||||||||||||||||||||||||||||
| 11 | 0.08 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.id = ?
Parameters:
[
3250993
]
|
||||||||||||||||||||||||||||||
| 12 | 0.08 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.id = ?
Parameters:
[
3255574
]
|
||||||||||||||||||||||||||||||
| 13 | 0.09 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.id = ?
Parameters:
[
3255575
]
|
||||||||||||||||||||||||||||||
| 14 | 0.08 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.id = ?
Parameters:
[
3255576
]
|
||||||||||||||||||||||||||||||
| 15 | 0.08 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.id = ?
Parameters:
[
3255577
]
|
||||||||||||||||||||||||||||||
| 16 | 0.09 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.id = ?
Parameters:
[
3255578
]
|
||||||||||||||||||||||||||||||
| 17 | 0.12 ms |
SELECT t0.id AS id_1, t0.store_row AS store_row_2, t0.store_column AS store_column_3, t0.position AS position_4, t0.image AS image_5, t0.store_id AS store_id_6, t0.listing_id AS listing_id_7 FROM store_listing t0 WHERE t0.store_id = ?
Parameters:
[
44
]
|
||||||||||||||||||||||||||||||
| 18 | 0.12 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.slug AS slug_3, t0.roles AS roles_4, t0.password AS password_5, t0.forsalebyowner_user_id AS forsalebyowner_user_id_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.user_name AS user_name_9, t0.phone AS phone_10, t0.created_at AS created_at_11, t0.google_id AS google_id_12, t0.avatar AS avatar_13, t0.tagline AS tagline_14, t0.is_active AS is_active_15, t0.confirmation_token AS confirmation_token_16, t0.confirmation_token_expires_at AS confirmation_token_expires_at_17, t0.promo_code AS promo_code_18, t0.show_phone_in_brochure AS show_phone_in_brochure_19, t0.default_search_view AS default_search_view_20, t0.description AS description_21, t0.website_address AS website_address_22, t0.allow_non_verified AS allow_non_verified_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.address AS address_26, t0.show_address_in_brochure AS show_address_in_brochure_27 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
400
]
|
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\StoreListing | 12 |
| App\Entity\Listing | 12 |
| App\Entity\Category | 12 |
| App\Entity\Store | 1 |
| App\Entity\User | 1 |
| App\Entity\StoreLayout | 1 |
| App\Entity\City | 1 |
| App\Entity\ListingType | 1 |
| App\Entity\OfferType | 1 |
| App\Entity\PriceType | 1 |
| App\Entity\ListingStatus | 1 |
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\Store | No errors. |
| App\Entity\StoreLayout | No errors. |
| App\Entity\StoreListing | 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\ListingImage | No errors. |
| App\Entity\Conversation | No errors. |
| App\Entity\ListingViewCount | No errors. |
| App\Entity\ListingPhoneClick | No errors. |
| App\Entity\UserAddress | 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. |
forsalebyowner entity manager
No loaded entities.