GET https://dev.fsbo.ca/stores/44

Query Metrics

18 Database Queries
7 Different statements
1.95 ms Query time
0 Invalid entities
44 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.09 ms
(55.86%)
12
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
]
0.23 ms
(11.88%)
1
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"
]
0.15 ms
(7.57%)
1
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"
]
0.15 ms
(7.47%)
1
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
]
0.12 ms
(6.04%)
1
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
]
0.12 ms
(6.04%)
1
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
]
0.10 ms
(5.13%)
1
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
]

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.