Skip to content

Instantly share code, notes, and snippets.

@jibiel

jibiel/gist:3dd0a0042d8746412dc65b9467c790c3 Secret

Created September 27, 2016 16:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jibiel/3dd0a0042d8746412dc65b9467c790c3 to your computer and use it in GitHub Desktop.
Save jibiel/3dd0a0042d8746412dc65b9467c790c3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] current_language is: en_us
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheAPC
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Using cache backend SugarCacheAPC, since 940 is less than 1000
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheWincache
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCachesMash
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheFile
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheMemory
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheZend
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheMemcache
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheRedis
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Found cache backend SugarCacheMemcached
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Hook called: ::after_entry_point
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Including module specific hook file for custom/modules
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Including Ext hook file for custom/application
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Begin: SugarRestService->__construct
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] SugarRestService->__construct serverclass = SugarRestJSON
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] End: SugarRestService->__construct
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Begin: SugarRestService->registerImplClass
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] End: SugarRestService->registerImplClass
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Begin: SugarRestService->serve
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Begin: SugarRestJSON->serve
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Begin: SugarWebServiceImpl->set_relationship
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Begin: SoapHelperWebServices->checkSessionAndModuleAccess -
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Begin: SoapHelperWebServices->validate_authenticated
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Hook called: Users::before_retrieve
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Including module specific hook file for custom/modules/Users
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Retrieve User : SELECT users.*,users_cstm.* FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = '1' AND users.deleted=0
Tue Sep 27 19:29:22 2016 [1283][-none-][DEBUG] Limit Query:SELECT users.*,users_cstm.* FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Query:SELECT users.*,users_cstm.* FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
Tue Sep 27 19:29:22 2016 [1283][-none-][INFO] Query Execution Time:0.00043296813964844
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query Execution Time:0.0001530647277832
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link).
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query Execution Time:0.00035285949707031
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Hook called: Users::after_retrieve
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Begin: SoapHelperWebServices->login_success
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Users language is = en_us
Tue Sep 27 19:29:22 2016 [1283][1][INFO] End: SoapHelperWebServices->login_success
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Begin: SoapHelperWebServices->validate_authenticated - passed
Tue Sep 27 19:29:22 2016 [1283][1][INFO] End: SoapHelperWebServices->validate_authenticated
Tue Sep 27 19:29:22 2016 [1283][1][INFO] End: SoapHelperWebServices->checkSessionAndModuleAccess -
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Begin: SoapHelperWebServices->new_handle_set_relationship
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Hook called: Contacts::before_retrieve
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Including module specific hook file for custom/modules/Contacts
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Retrieve Contact : SELECT contacts.*,contacts_cstm.* FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE contacts.id = 'ad9a94ff-098e-6074-af82-5627de78dcd6' AND contacts.deleted=0
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Limit Query:SELECT contacts.*,contacts_cstm.* FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE contacts.id = 'ad9a94ff-098e-6074-af82-5627de78dcd6' AND contacts.deleted=0 Start: 0 count: 1
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query:SELECT contacts.*,contacts_cstm.* FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE contacts.id = 'ad9a94ff-098e-6074-af82-5627de78dcd6' AND contacts.deleted=0 LIMIT 0,1
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query Execution Time:0.00048494338989258
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query:SELECT acc.id, acc.name, con_reports_to.first_name, con_reports_to.last_name
from contacts
left join accounts_contacts a_c on a_c.contact_id = 'ad9a94ff-098e-6074-af82-5627de78dcd6' and a_c.deleted=0
left join accounts acc on a_c.account_id = acc.id and acc.deleted=0
left join contacts con_reports_to on con_reports_to.id = contacts.reports_to_id
where contacts.id = 'ad9a94ff-098e-6074-af82-5627de78dcd6' ORDER BY a_c.date_modified DESC
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query Execution Time:0.00041699409484863
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (user_sync).
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query:SELECT user_id id FROM contacts_users WHERE contacts_users.contact_id = 'ad9a94ff-098e-6074-af82-5627de78dcd6' AND contacts_users.deleted=0
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query Execution Time:0.00015377998352051
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (assigned_user_id).
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (assigned_user_id)
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (assigned_user_id).
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (assigned_user_id)
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (account_id).
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (account_id)
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (account_id).
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (account_id)
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (reports_to_link).
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (campaign_contacts).
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'Contacts'
AND ear.bean_id = 'ad9a94ff-098e-6074-af82-5627de78dcd6'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Tue Sep 27 19:29:22 2016 [1283][1][INFO] Query Execution Time:0.0004570484161377
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Hook called: Contacts::after_retrieve
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (contact_leads).
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (contact_leads)
Tue Sep 27 19:29:22 2016 [1283][1][INFO] End: SoapHelperWebServices->new_handle_set_relationship
Tue Sep 27 19:29:22 2016 [1283][1][INFO] End: SugarWebServiceImpl->set_relationship
Tue Sep 27 19:29:22 2016 [1283][1][INFO] End: SugarRestJSON->serve
Tue Sep 27 19:29:22 2016 [1283][1][INFO] End: SugarRestService->serve
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Hook called: ::server_round_trip
Tue Sep 27 19:29:22 2016 [1283][1][DEBUG] Calling MySQLi::disconnect()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment