Query Metrics
12
Database Queries
6
Different statements
8.91 ms
Query time
12
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.30 ms (37.02%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"test_izidore_2"
]
|
|
1.99 ms (22.32%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.plural_name AS plural_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.parentLevel AS parentLevel_9, t8.peopleToCarry AS peopleToCarry_10, t8.carbon_foot_print AS carbon_foot_print_11, t8.active AS active_12, t8.slug AS slug_13, t8.volume_in_m3 AS volume_in_m3_14, t8.format AS format_15, t8.id AS id_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.parent AS parent_19 FROM stuff_type_translation t0 LEFT JOIN stuff_type t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = ?
Parameters:
[
65
]
|
|
1.62 ms (18.15%) |
1 |
SELECT t0.parentLevel AS parentLevel_1, t0.peopleToCarry AS peopleToCarry_2, t0.carbon_foot_print AS carbon_foot_print_3, t0.active AS active_4, t0.slug AS slug_5, t0.volume_in_m3 AS volume_in_m3_6, t0.format AS format_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent AS parent_11 FROM stuff_type t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"chaise"
]
|
|
0.89 ms (10.04%) |
3 |
SELECT t0.parentLevel AS parentLevel_1, t0.peopleToCarry AS peopleToCarry_2, t0.carbon_foot_print AS carbon_foot_print_3, t0.active AS active_4, t0.slug AS slug_5, t0.volume_in_m3 AS volume_in_m3_6, t0.format AS format_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent AS parent_11 FROM stuff_type t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
0.75 ms (8.45%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.36 ms (4.03%) |
1 |
SELECT t0.slug AS slug_1, t0.type AS type_2, t0.text AS text_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM seotext t0 WHERE t0.slug = ? AND t0.type = ? LIMIT 1
Parameters:
[ "chaise" "STUFF_TYPE" ] |
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\AbstractEntity | No errors. |
| App\Entity\UtmCampaign | No errors. |
| App\Entity\FavoriteAnonymous | No errors. |
| App\Entity\FavoriteAnonymousAnnounce | No errors. |
| App\Entity\FavoriteAnonymousStuff | No errors. |
| App\Entity\Favorite | No errors. |
| App\Entity\FavoriteAnnounce | No errors. |
| App\Entity\FavoriteStuff | No errors. |
| App\Entity\Announce | No errors. |
| App\Entity\Stuff | No errors. |
| App\Entity\ContactThread | No errors. |
| App\Entity\ContactThreadMessage | No errors. |
| App\Entity\StuffType | No errors. |
| App\Entity\DeliveryProviderStuffTypePolicy | No errors. |
| App\Entity\Brand |
|
| App\Entity\StuffTag | No errors. |
| App\Entity\Search |
|
| App\Entity\StuffTypeTranslation | No errors. |
| App\Entity\SEOText | No errors. |
| App\Entity\Sponsor |
|
| App\Entity\AnnounceOrder | No errors. |
| App\Entity\AnnounceOrderWithdrawal | No errors. |
| App\Entity\UserBusiness |
|
| App\Entity\FrenchCity |
|
| App\Entity\User | No errors. |
| App\Entity\Address |
|
| App\Entity\Room | No errors. |
| App\Entity\PreFilledRoomImage | No errors. |
| App\Entity\AnnounceLibraryImage | No errors. |
| App\Entity\AnnounceOption | No errors. |
| App\Entity\PaymentTransaction | No errors. |
| App\Entity\CalendarAvailability | No errors. |
| App\Entity\BusinessShop | No errors. |
| App\Entity\AnnounceOrderStuff |
|
| App\Entity\AnnouncePreOrderStuff | No errors. |
| App\Entity\StuffPicture | No errors. |
| App\Entity\ProCertificator | No errors. |
| App\Entity\ProVoucher | No errors. |
| App\Entity\Negotiation |
|
| App\Entity\ContactThreadMessageDocument | No errors. |
| App\Entity\DeliveryProvider | No errors. |
| App\Entity\ProValuator | No errors. |
| App\Entity\SearchUser | No errors. |
| App\Entity\AnnounceOrderPickupDate | No errors. |
| App\Entity\PaymentAuthorization | No errors. |
| App\Entity\Delivery | No errors. |
| App\Entity\Voucher | No errors. |
| App\Entity\BankAccount | No errors. |
| App\Entity\BusinessAccess | No errors. |
| App\Entity\BusinessInformations | No errors. |
| App\Entity\Picture |
|
| App\Entity\ConfigCatalogAlgolia | No errors. |
| App\Entity\KycProcess | No errors. |
| App\Entity\NotificationToken | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\NotificationPreferences | No errors. |
| App\Entity\Business | No errors. |
| App\Entity\CGUVersion | No errors. |
| App\Entity\RoomType | No errors. |
| App\Entity\Discount | No errors. |
| App\Entity\AnnouncePreOrder | No errors. |
| App\Entity\DeliveryProviderOption | No errors. |
| App\Entity\Valuation | No errors. |
| App\Entity\SearchAlert | No errors. |
| App\Entity\PaymentCard | No errors. |
| App\Entity\DeliveryOption | No errors. |
| App\Entity\BusinessDocument | No errors. |
| App\Entity\AlertNewsletter | No errors. |
| App\Entity\AlertNewsletterCampaign | No errors. |
| App\Entity\RoomTypeTranslation | No errors. |
| App\Entity\ValidationCode | No errors. |
| App\Entity\DeliveryCityGroup |
|
| App\Entity\ResetPasswordRequest | No errors. |
| App\Entity\AppVersion | No errors. |
| App\Entity\View | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\ContactThreadMessageBlocker | No errors. |
| App\Entity\InvoiceItem | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\ServerError | No errors. |
| App\Entity\StuffTypeTag |
|
| App\Entity\StuffTypeTagTranslation | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Testimonial | No errors. |
| App\Entity\KycDocument | No errors. |
| App\Entity\Locality |
|
| Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry | No errors. |
| Gedmo\Loggable\Entity\LogEntry | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| Algolia\SearchBundle\Entity\Aggregator | No errors. |