Query Metrics
18
Database Queries
5
Different statements
2.05 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.26 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.packages AS packages_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM boost_profile_setting t0 WHERE t0.type = ? AND t0.active = ? LIMIT 1
Parameters:
[ "Display Boost Modal Automatic Time In Seconds" 1 ] |
2 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.packages AS packages_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM boost_profile_setting t0 WHERE t0.type = ? AND t0.active = ? LIMIT 1
Parameters:
[ "Activate The Boost Profile Functionality" 1 ] |
3 | 0.19 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.action AS action_3, t0.active AS active_4, t0.value AS value_5, t0.packages AS packages_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM media_setting t0 WHERE t0.type = ? AND t0.action = ? LIMIT 1
Parameters:
[ "Image" "Content For Packages Upgrade Modal" ] |
4 | 0.09 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.action AS action_3, t0.active AS active_4, t0.value AS value_5, t0.packages AS packages_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM media_setting t0 WHERE t0.type = ? AND t0.action = ? LIMIT 1
Parameters:
[ "Image" "Content For Packages Upgrade Modal" ] |
5 | 0.08 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.action AS action_3, t0.active AS active_4, t0.value AS value_5, t0.packages AS packages_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM media_setting t0 WHERE t0.type = ? AND t0.action = ? LIMIT 1
Parameters:
[ "Video" "Content For Packages Upgrade Modal" ] |
6 | 0.08 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.action AS action_3, t0.active AS active_4, t0.value AS value_5, t0.packages AS packages_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM media_setting t0 WHERE t0.type = ? AND t0.action = ? LIMIT 1
Parameters:
[ "Video" "Content For Packages Upgrade Modal" ] |
7 | 0.14 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.menu_icon AS menu_icon_4, t0.slug AS slug_5, t0.content AS content_6, t0.active AS active_7, t0.active_until AS active_until_8, t0.created_at AS created_at_9, t0.last_updated_at AS last_updated_at_10, t0.custom_js_code AS custom_js_code_11, t0.custom_css_code AS custom_css_code_12, t0.created_by AS created_by_13, t0.include_in_menu AS include_in_menu_14, t0.last_modified_by AS last_modified_by_15, t0.revision AS revision_16 FROM soc_cms_pages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"social_support"
]
|
8 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.menu_icon AS menu_icon_4, t0.slug AS slug_5, t0.content AS content_6, t0.active AS active_7, t0.active_until AS active_until_8, t0.created_at AS created_at_9, t0.last_updated_at AS last_updated_at_10, t0.custom_js_code AS custom_js_code_11, t0.custom_css_code AS custom_css_code_12, t0.created_by AS created_by_13, t0.include_in_menu AS include_in_menu_14, t0.last_modified_by AS last_modified_by_15, t0.revision AS revision_16 FROM soc_cms_pages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"terms_and_conditions"
]
|
9 | 0.08 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.menu_icon AS menu_icon_4, t0.slug AS slug_5, t0.content AS content_6, t0.active AS active_7, t0.active_until AS active_until_8, t0.created_at AS created_at_9, t0.last_updated_at AS last_updated_at_10, t0.custom_js_code AS custom_js_code_11, t0.custom_css_code AS custom_css_code_12, t0.created_by AS created_by_13, t0.include_in_menu AS include_in_menu_14, t0.last_modified_by AS last_modified_by_15, t0.revision AS revision_16 FROM soc_cms_pages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"privacy"
]
|
10 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.menu_icon AS menu_icon_4, t0.slug AS slug_5, t0.content AS content_6, t0.active AS active_7, t0.active_until AS active_until_8, t0.created_at AS created_at_9, t0.last_updated_at AS last_updated_at_10, t0.custom_js_code AS custom_js_code_11, t0.custom_css_code AS custom_css_code_12, t0.created_by AS created_by_13, t0.include_in_menu AS include_in_menu_14, t0.last_modified_by AS last_modified_by_15, t0.revision AS revision_16 FROM soc_cms_pages t0 WHERE t0.include_in_menu = ?
Parameters:
[
1
]
|
11 | 0.15 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "audio_upload_chat" 1 ] |
12 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "chat_video_send" 1 ] |
13 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "audio_upload_chat" 1 ] |
14 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "chat_video_send" 1 ] |
15 | 0.08 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "audio_upload_chat" 1 ] |
16 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "chat_video_send" 1 ] |
17 | 0.09 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "audio_upload_chat" 1 ] |
18 | 0.13 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.cost AS cost_4, t0.active AS active_5, t0.is_system AS is_system_6, t0.upgradable_packages AS upgradable_packages_7, t0.not_display_audio_button_packages AS not_display_audio_button_packages_8, t0.upload_file_size AS upload_file_size_9, t0.recording_time AS recording_time_10, t0.audio_unlock_duration AS audio_unlock_duration_11 FROM soc_credits_actions t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "chat_video_send" 1 ] |
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 |
---|---|
FOS\UserBundle\Model\User | No errors. |
Social\UserBundle\Entity\User | No errors. |
Social\FrontendBundle\Entity\Relationship | No errors. |
Social\InternalBundle\Entity\BoostProfileSetting | No errors. |
Social\InternalBundle\Entity\CentralPayPayment\CPCustomersEntity | No errors. |
Social\InternalBundle\Entity\CentralPayCustomersEntity | No errors. |
Social\FrontendBundle\Entity\HistoryApiip | No errors. |
Social\InternalBundle\Entity\PaymentsBanEntity | No errors. |
Social\UserBundle\Entity\UserComponents\UserSignupPollData | No errors. |
Social\InternalBundle\Entity\EmailList |
|
Social\FrontendBundle\Entity\Album | No errors. |
Social\FrontendBundle\Entity\Image | No errors. |
Social\FrontendBundle\Entity\Audio | No errors. |
Social\FrontendBundle\Entity\Video | No errors. |
Social\InternalBundle\Entity\BannedCardsEntity | No errors. |
Social\FrontendBundle\Entity\ImageComment | No errors. |
Social\FrontendBundle\Entity\ImageLike | No errors. |
Social\FrontendBundle\Entity\VideoComment | No errors. |
Social\FrontendBundle\Entity\VideoLike | No errors. |
Social\UserBundle\Entity\UserChatConnection | No errors. |
Social\FrontendBundle\Entity\Alert | No errors. |
Social\FrontendBundle\Entity\Message | No errors. |
Social\FrontendBundle\Entity\Payment | No errors. |
Social\UserBundle\Entity\UserInterestedIn | No errors. |
Social\FrontendBundle\Entity\OpenTokSession | No errors. |
Social\FrontendBundle\Entity\PscConfirmationPayment | No errors. |
Social\InternalBundle\Entity\PaymentEntity | No errors. |
Social\CreditsBundle\Entity\CreditUserHistoryEntity | No errors. |
Social\CreditsBundle\Entity\CreditRefundRequestsEntity | No errors. |
Social\InternalBundle\Entity\CentralPayPaymentsEntity | No errors. |
Social\InternalBundle\Entity\CentralPayInstallmentsEntity | No errors. |
Social\InternalBundle\Entity\AdminAlertsEntity | No errors. |
Social\InternalBundle\Entity\MemberReport | No errors. |
Social\InternalBundle\Entity\TrafficPoolUsers | No errors. |
Social\InternalBundle\Entity\EmailSpamReportsEntity | No errors. |
Social\InternalBundle\Entity\SentsioApiDetail | No errors. |
Social\UserBundle\Entity\UserTracking | No errors. |
Social\UserBundle\Entity\UserBlockingQueue | No errors. |
Social\InternalBundle\Entity\PackagesList | No errors. |
Social\FrontendBundle\Entity\Location | No errors. |
Social\FrontendBundle\Entity\PaymentReference | No errors. |
Social\InternalBundle\Entity\Language | No errors. |
Social\FrontendBundle\Entity\NewLocation | No errors. |
Social\InternalBundle\Entity\TrafficPool | No errors. |
Social\FrontendBundle\Entity\MediaSetting | No errors. |
Social\CmsBundle\Entity\CmsPagesEntity | No errors. |
Social\InternalBundle\Entity\CentralPayPayment\CPSavedCardsEntity | No errors. |
Social\InternalBundle\Entity\CentralPayPayment\CPInstallments | No errors. |
Social\InternalBundle\Entity\CentralPayPayment\CPPaymentsEntity | No errors. |
Social\InternalBundle\Entity\CentralPayUserCardsEntity | No errors. |
Social\InternalBundle\Entity\TrafficPoll\UrlParameters | No errors. |
Social\InternalBundle\Entity\EmailListScreenshot | No errors. |
Social\InternalBundle\Entity\EmailSiteSource | No errors. |
Social\InternalBundle\Entity\EmailListStatus | No errors. |
Social\FrontendBundle\Entity\ChatVideo | No errors. |
Social\FrontendBundle\Entity\PaymentCancel | No errors. |
Social\FrontendBundle\Entity\Rebill | No errors. |
Social\InternalBundle\Entity\MemberReportReasonItem | No errors. |
Social\InternalBundle\Entity\EmailLog | No errors. |
Social\InternalBundle\Entity\IpTrack | No errors. |
Social\InternalBundle\Entity\IpList | No errors. |
Social\InternalBundle\Entity\PaymentProcessor | No errors. |
Social\FrontendBundle\Entity\Region | No errors. |
Social\InternalBundle\Entity\LocationCompletions | No errors. |
Social\InternalBundle\Entity\TrafficPoll\Redirects | No errors. |
Social\InternalBundle\Entity\TrafficPoll\Conversions | No errors. |
Social\InternalBundle\Entity\TrafficPoll\PopunderRedirects | No errors. |
Social\InternalBundle\Entity\TrafficPoll\CommercialCards | No errors. |
Social\CreditsBundle\Entity\CreditActionsEntity | No errors. |