GET https://test.kimia.pro/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CSiteController%253A%253Afaq

Response
200 OK
IP
216.73.216.214
Profiled on
Token
bd1df7

Query Metrics

4 Database Queries
4 Different statements
5.94 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.63 ms 
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slogan AS slogan_2, e0_.content AS content_3, e0_.thumbnail_display AS thumbnail_display_4, e0_.email AS email_5, e0_.phone AS phone_6, e0_.size AS size_7, e0_.type AS type_8, e0_.objective AS objective_9, e0_.slug AS slug_10, e0_.rccm AS rccm_11, e0_.id_nat AS id_nat_12, e0_.created_at AS created_at_13, e0_.updated_at AS updated_at_14, e0_.is_active AS is_active_15, e0_.activated_at AS activated_at_16, e0_.deactivated_at AS deactivated_at_17, e0_.current_state AS current_state_18, e0_.deleted_at AS deleted_at_19, e0_.wallets AS wallets_20, e0_.thumbnail_id AS thumbnail_id_21, e0_.thumbnail_small_id AS thumbnail_small_id_22, e0_.thumbnail_black_id AS thumbnail_black_id_23, e0_.thumbnail_black_small_id AS thumbnail_black_small_id_24, e0_.user_id AS user_id_25, e0_.address_id AS address_id_26, e0_.currency_id AS currency_id_27, e0_.model_id AS model_id_28 FROM establishment e0_ WHERE e0_.id = ? OR e0_.slug = ?
Parameters: 
[
  "test"
  "test"
]
View formatted query    View runnable query    Explain query
2 0.81 ms 
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.direction AS direction_8, t0.is_public AS is_public_9, t0.path AS path_10, t0.url AS url_11, t0.is_menu AS is_menu_12, t0.background_id AS background_id_13, t0.image_id AS image_id_14, t0.created_by_id AS created_by_id_15, t0.parent_id AS parent_id_16 FROM cms t0 WHERE t0.is_menu = ? AND t0.is_public = ? AND t0.type = ?
Parameters: 
[
  1
  1
  "Page"
]
View formatted query    View runnable query    Explain query
3 0.82 ms 
SELECT t0.id AS id_1, t0.quote AS quote_2, t0.author AS author_3, t0.profesion AS profesion_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_public AS is_public_7, t0.thumbnail_id AS thumbnail_id_8 FROM cms_quote t0 WHERE t0.is_public = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
4 0.68 ms 
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.is_validated AS is_validated_4, t0.is_public AS is_public_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM cms_faq t0 WHERE t0.is_public = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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\Establishment No errors.
App\Entity\Attachment No errors.
App\Entity\User
  • The field 'App\Entity\User#bannedAt' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\Address No errors.
App\Entity\Currency No errors.
App\Entity\Model No errors.
App\Entity\Cms No errors.
App\Entity\CmsQuote No errors.
App\Entity\Department
  • The association App\Entity\Department#collections refers to the owning side field App\Entity\Collections#department which does not exist.
App\Entity\Document No errors.
App\Entity\ConnectionLog No errors.
App\Entity\Client No errors.
App\Entity\Planning No errors.
App\Entity\Invitation No errors.
App\Entity\Operation No errors.
App\Entity\Article No errors.
App\Entity\Collections No errors.
App\Entity\Journal No errors.
App\Entity\Supply No errors.
App\Entity\Promotion
  • The association App\Entity\Promotion#orders refers to the owning side field App\Entity\Order#promotion which does not exist.
App\Entity\Rate No errors.
App\Entity\Employee No errors.
App\Entity\Subscription No errors.
App\Entity\Order No errors.
App\Entity\Configuration No errors.
App\Entity\Menu No errors.
App\Entity\QrCode No errors.
App\Entity\Bot No errors.
App\Entity\Role No errors.
App\Entity\Advertisement No errors.
App\Entity\Contract No errors.
App\Entity\Mutuality No errors.
App\Entity\MutualityCategory No errors.
App\Entity\CardType No errors.
App\Entity\Gateway No errors.
App\Entity\ArticleDepartment No errors.
App\Entity\WalletOperation No errors.
App\Entity\Flow No errors.
App\Entity\Service No errors.
App\Entity\OTP No errors.
App\Entity\UserDetail No errors.
App\Entity\Lot No errors.
App\Entity\Invoice No errors.
App\Entity\Attendance No errors.
App\Entity\Card No errors.
App\Entity\Option No errors.
App\Entity\ArticleSupply No errors.
App\Entity\Tax No errors.
Tchoulom\ViewCounterBundle\Entity\ViewCounter No errors.
App\Entity\ViewCounter No errors.
App\Entity\FlowUser No errors.
App\Entity\EmployeeContract No errors.
App\Entity\Plan No errors.
App\Entity\OrderItems No errors.
App\Entity\Shipment No errors.
App\Entity\Transaction No errors.
App\Entity\ModelMenu No errors.
App\Entity\AdvertisementAttachment No errors.
App\Entity\ArticleDepartmentPackage No errors.
App\Entity\FlowStep No errors.
App\Entity\CmsPartner No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Revision No errors.
App\Entity\Contact No errors.
App\Entity\ArticleLog No errors.
App\Entity\CmsContact No errors.
App\Entity\LoginAttempt No errors.
App\Entity\CmsNewsletter No errors.
App\Entity\Notification No errors.
App\Entity\LotConfiguration No errors.
App\Entity\FlowAction No errors.
App\Entity\FlowModel No errors.
App\Entity\Ticket No errors.
App\Entity\Discover No errors.
App\Entity\Event No errors.
App\Entity\CmsFaq No errors.
App\Entity\FlowProcess No errors.
Vich\UploaderBundle\Entity\File No errors.