Query Metrics
1
Database Queries
1
Different statements
1.25 ms
Query time
24
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.25 ms (100.00%) |
1 |
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n1_.id AS id_2, n1_.title AS title_3, n1_.text AS text_4, n1_.link AS link_5, n1_.created_at AS created_at_6, n1_.process_at AS process_at_7, n1_.recipient AS recipient_8, n0_.innovation_id AS innovation_id_9, n1_.tag_id AS tag_id_10 FROM notification_announcement n0_ INNER JOIN notification_innovation n1_ ON n0_.innovation_id = n1_.id ORDER BY n0_.created_at DESC LIMIT 3
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| readonly | doctrine.dbal.readonly_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| readonly | doctrine.orm.readonly_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| Supportbox\Component\AccountBundle\Entity\User |
|
| Supportbox\Component\AccountBundle\Entity\Job | No errors. |
| Supportbox\Component\MailBundle\Entity\Permission | No errors. |
| Supportbox\Component\AccountBundle\Entity\BillingEmbed | No errors. |
| Supportbox\Account\Payment\ChannelSettings | No errors. |
| Supportbox\Purchase\Persist\AiPricing | No errors. |
| Supportbox\Purchase\Persist\CreditPricing | No errors. |
| Supportbox\Component\AccountBundle\Entity\Company |
|
| Supportbox\Purchase\Persist\PurchasePerChannel | No errors. |
| Supportbox\Purchase\Persist\Purchase | No errors. |
| Supportbox\Phone\Filter\Persist\ListFilter |
|
| Supportbox\Phone\Filter\Persist\UnnamedListFilter |
|
| Supportbox\Account\Company\Persist\CompanyPermissionLog | No errors. |
| Supportbox\Component\MailBundle\Entity\Mailbox |
|
| Supportbox\Phone\PhoneBox\Persist\PhoneBox |
|
| Supportbox\Phone\Security\Permission\Persist\PhoneBoxPermission | No errors. |
| Supportbox\WebChat\ChatBox\Persist\ChatBox |
|
| Supportbox\WebChat\Security\Permission\Persist\ChatBoxPermission | No errors. |
| Supportbox\Mailbox\Receiving\Distribution\DistributionPermission | No errors. |
| Supportbox\Component\MailBundle\Entity\Message |
|
| Supportbox\Notification\Announcement\Persist\Announcement | No errors. |
| Supportbox\Component\AccountBundle\Entity\UserAiPermission | No errors. |
| Supportbox\Component\AccountBundle\Entity\UserAccessRequest | No errors. |
| Supportbox\Notification\Innovation\Persist\Innovation | No errors. |
| Supportbox\Notification\Tag\Persist\NotificationTag | No errors. |
| Supportbox\WebChat\ChatBot\Persist\Usage\ChatBotGPTUsage | No errors. |
| Supportbox\LucyAI\Usage\Persist\LucyAIUsage | No errors. |
| Supportbox\Prompt\Persist\Prompt | No errors. |
| Supportbox\WebChat\ChatBot\Persist\ChatBoxChatBotQATheme | No errors. |
| Supportbox\WebChat\ChatBot\Persist\Usage\ChatBotQAUsage | No errors. |
| Supportbox\WebChat\ChatBot\Persist\ChatBoxChatBotTexts | No errors. |
| Supportbox\WebChat\ChatBot\Persist\ChatBoxChatBot | No errors. |
| Supportbox\WebChat\ChatBot\Persist\ChatBoxChatBotButtonBased |
|
| Supportbox\Mailbox\Settings\Persist\MailboxOrderWebhook | No errors. |
| Supportbox\WebChat\ChatBot\Persist\ChatBoxChatBotOrderWebhook | No errors. |
| Supportbox\Component\PluginMailTicketBundle\Entity\PluginMailTicket | No errors. |
| Supportbox\Component\MailBundle\Entity\Ticket |
|
| Supportbox\WorkingHours\Persist\WorkingHours | No errors. |
| Supportbox\WorkingHours\Persist\WorkingHoursMailbox | No errors. |
| Supportbox\Mail\Log\Persist\LogMailTicket | No errors. |
| Supportbox\Mail\Log\Persist\LogMailTicketStatus | No errors. |
| Supportbox\Mail\Log\Persist\LogMailTicketAssign | No errors. |
| Supportbox\Mail\Log\Persist\LogMailTicketTag | No errors. |
| Supportbox\Mail\Message\Mail\Persist\MailMessageMail | No errors. |
| Supportbox\WebChat\Ticket\Persist\ChatTicket |
|
| Supportbox\WebChat\Log\Persist\ChatTicketLog |
|
| Supportbox\WebChat\Log\Persist\ChatTicketLogStatus |
|
| Supportbox\WebChat\Log\Persist\ChatTicketLogChatBot |
|
| Supportbox\WorkingHours\Persist\WorkingHoursChatbox | No errors. |
| Supportbox\WebChat\ChatBot\Persist\ChatBot | No errors. |
| Supportbox\WebChat\MessageChatBot\Persist\ChatMessageChatBotReaction | No errors. |
| Supportbox\Crm\Person\Persist\Person |
|
| Supportbox\Phone\Ticket\Persist\PhoneTicket |
|
| Supportbox\Phone\Message\Persist\PhoneMessage |
|
| Supportbox\WorkingHours\Persist\WorkingHoursPhonebox | No errors. |
| Supportbox\LucyAI\Persist\ChatBoxAgent |
|
| Supportbox\LucyAI\Persist\AgentArticle | No errors. |
| Supportbox\WebChat\MessageChatBot\Persist\ChatMessageChatBot |
|
| Supportbox\LucyAI\Persist\Agent |
|
| Supportbox\WebChat\Message\Persist\ChatAttachment |
|
| Supportbox\WebChat\MessageButton\Persist\ChatMessageButton | No errors. |
| Supportbox\Notification\Configuration\Persist\BaseNotificationConfiguration |
|
| Supportbox\Notification\Configuration\Persist\NotificationConfigurationLiveChat |
|
| Supportbox\Notification\Mobile\Persist\MobileNotificationSns | No errors. |
| Supportbox\WebChat\Message\Persist\ChatMessage |
|
| Supportbox\Mailbox\Spf\Persist\MailboxSpf | No errors. |
| Supportbox\Mailbox\Dkim\Persist\MailboxDkim | No errors. |
| Supportbox\Menu\Persist\MenuPosition | No errors. |
| Supportbox\Menu\Persist\MenuCategory | No errors. |
| Supportbox\Component\MailBundle\Entity\Folder | No errors. |
| Supportbox\Component\CoreBundle\Entity\HomepageNotice | No errors. |
| Supportbox\Component\MailBundle\Entity\Attachment | No errors. |
| Supportbox\Mailbox\Attachment\MailboxAttachment | No errors. |
| Supportbox\Component\MailBundle\Entity\Contact | No errors. |
| Supportbox\Mailbox\Settings\Persist\MailboxUtm | No errors. |
| Supportbox\Mailbox\Settings\Persist\MailboxDefaultTicketStatus | No errors. |
| Supportbox\Mailbox\Settings\Persist\MailboxSla | No errors. |
| Supportbox\Mailbox\Settings\Persist\MailboxWebhook | No errors. |
| Supportbox\Mailbox\Settings\Persist\MailboxLucy | No errors. |
| Supportbox\Mailbox\Settings\Persist\MailboxSettings | No errors. |
| Supportbox\Mail\Gmail\Persist\MailboxOAuthGoogle | No errors. |
| Supportbox\Phone\Line\Persist\PhoneLine | No errors. |
| Supportbox\Component\AccountBundle\Entity\Settings\UserSettingsPhone | No errors. |
| Supportbox\LucyAI\Persist\MailboxAgent | No errors. |
readonly entity manager
No loaded entities.