Query Metrics
7
Database Queries
6
Different statements
23.24 ms
Query time
12
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 8.90 ms |
SELECT t0.name AS name_1, t0.color AS color_2, t0.second_color AS second_color_3, t0.recovery_price AS recovery_price_4, t0.started_valuation AS started_valuation_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.label AS label_10, t0.logo_id AS logo_id_11, t0.business_id AS business_id_12 FROM pro_valuator t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
"izidore"
]
|
| 2 | 5.34 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.is_main AS is_main_3, t0.menu_rank AS menu_rank_4, t0.default_partner_link AS default_partner_link_5, t0.quality AS quality_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.business_id AS business_id_10, t0.pro_valuator_id AS pro_valuator_id_11, t12.id AS id_13, t12.created_at AS created_at_14, t12.updated_at AS updated_at_15, t12.logo_id AS logo_id_16, t12.user_business_id AS user_business_id_17, t12.brand_id AS brand_id_18, t0.pro_voucher_id AS pro_voucher_id_19 FROM brand t0 LEFT JOIN pro_certificator t12 ON t12.brand_id = t0.id WHERE t0.pro_valuator_id IN (?)
Parameters:
[
3
]
|
| 3 | 3.07 ms |
SELECT s0_.parentLevel AS parentLevel_0, s0_.peopleToCarry AS peopleToCarry_1, s0_.carbon_foot_print AS carbon_foot_print_2, s0_.active AS active_3, s0_.slug AS slug_4, s0_.volume_in_m3 AS volume_in_m3_5, s0_.format AS format_6, s0_.id AS id_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s1_.id AS id_10, s1_.name AS name_11, s1_.plural_name AS plural_name_12, s1_.created_at AS created_at_13, s1_.updated_at AS updated_at_14, s1_.locale AS locale_15, s0_.parent AS parent_16, s1_.translatable_id AS translatable_id_17 FROM stuff_type s0_ LEFT JOIN stuff_type_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.active = 1 AND s0_.parentLevel >= ?
Parameters:
[
3
]
|
| 4 | 1.86 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.is_main AS is_main_3, t0.menu_rank AS menu_rank_4, t0.default_partner_link AS default_partner_link_5, t0.quality AS quality_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.business_id AS business_id_10, t0.pro_valuator_id AS pro_valuator_id_11, t12.id AS id_13, t12.created_at AS created_at_14, t12.updated_at AS updated_at_15, t12.logo_id AS logo_id_16, t12.user_business_id AS user_business_id_17, t12.brand_id AS brand_id_18, t0.pro_voucher_id AS pro_voucher_id_19 FROM brand t0 LEFT JOIN pro_certificator t12 ON t12.brand_id = t0.id ORDER BY t0.name ASC
Parameters:
[] |
| 5 | 0.56 ms |
SELECT DATABASE()
Parameters:
[] |
| 6 | 3.17 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"test_izidore_2"
]
|
| 7 | 0.35 ms |
SELECT DATABASE()
Parameters:
[] |
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\ProValuator | No errors. |
| App\Entity\Picture |
|
| App\Entity\UserBusiness |
|
| App\Entity\Valuation | No errors. |
| App\Entity\Brand |
|
| App\Entity\ProCertificator | No errors. |
| App\Entity\ProVoucher | No errors. |
| App\Entity\StuffType | No errors. |
| App\Entity\StuffTypeTranslation | No errors. |
| App\Entity\DeliveryProviderStuffTypePolicy | No errors. |
| App\Entity\StuffTag | No errors. |
| App\Entity\Search |
|
| App\Entity\Sponsor |
|
| App\Entity\AnnounceOrder | No errors. |
| App\Entity\AnnounceOrderWithdrawal | No errors. |
| 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\Negotiation |
|
| App\Entity\ContactThreadMessageDocument | No errors. |
| App\Entity\BusinessAccess | No errors. |
| App\Entity\BusinessInformations | No errors. |
| App\Entity\ConfigCatalogAlgolia | No errors. |
| App\Entity\DeliveryProvider | 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\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\BusinessDocument | No errors. |
| App\Entity\DeliveryProviderOption | No errors. |
| App\Entity\SearchAlert | No errors. |
| App\Entity\PaymentCard | No errors. |
| App\Entity\DeliveryOption | 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\SEOText | No errors. |
| 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. |