POST https://junedev.housemaster.com/hg/report-upload-mirror

Response
200 OK
IP
52.42.29.174
Profiled on
Token
faa928

Query Metrics

4 Database Queries
1 Different statements
4202.86 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 1035.58 ms 
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: 
[
  "ftd4@verizon.net"
]
View formatted query    View runnable query    Explain query
2 1118.96 ms 
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: 
[
  "ftd4@verizon.net"
]
View formatted query    View runnable query    Explain query
3 1010.21 ms 
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: 
[
  "ftd4@verizon.net"
]
View formatted query    View runnable query    Explain query
4 1038.11 ms 
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: 
[
  "ftd4@verizon.net"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
bbp doctrine.dbal.bbp_connection
housemaster doctrine.dbal.housemaster_connection

Entity Managers

Name Service
inertia doctrine.orm.inertia_entity_manager
default doctrine.orm.default_entity_manager
bbp doctrine.orm.bbp_entity_manager
housemaster doctrine.orm.housemaster_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

inertia entity manager

No loaded entities.

default entity manager

Class Mapping errors
FOS\UserBundle\Model\User No errors.
App\AppBundle\Entity\User No errors.
App\AppBundle\Entity\SweepstakesAgentInfo No errors.
App\AppBundle\Entity\SweepstakesContact No errors.
App\AppBundle\Entity\IsnCredentials No errors.
App\AppBundle\Entity\BetaQuestions No errors.
App\AppBundle\Entity\InspectorNotificationSettings No errors.
App\AppBundle\Entity\OfficeSettings No errors.
App\AppBundle\Entity\ApiKeys No errors.
App\AppBundle\Entity\ShortUrls No errors.
App\AppBundle\Entity\MailjetEmail No errors.
App\AppBundle\Entity\OfferStat
  • The association App\AppBundle\Entity\OfferStat#offer refers to the inverse side field App\AppBundle\Entity\Offer#offerStats which does not exist.
App\AppBundle\Entity\HGReport No errors.
App\AppBundle\Entity\HGReportUser No errors.
App\AppBundle\Entity\HomeGaugeFileUpload No errors.
App\AppBundle\Entity\Home No errors.
App\AppBundle\Entity\RepairWiseCardPayment No errors.
App\AppBundle\Entity\HGReportNotifications No errors.
App\AppBundle\Entity\RepairRequest No errors.
App\AppBundle\Entity\RepairWiseToken No errors.
App\AppBundle\Entity\RepairWiseReportLink No errors.

bbp entity manager

No loaded entities.

housemaster entity manager

No loaded entities.