SQL

Debug Stats

SUMMARY

total: {'count': 0, 'unaccounted': 0.36784052848815918, 'time': 0.40204095840454102}
memcache.get: {'count': 14, 'time': 0.01378178596496582}
infobase: {'count': 3, 'time': 0.020418643951416016}
solr: {'count': 1, 'time': 0.0}

Details

solr 0.0
    {'query': {'subject_key': u'sql'}, 'rows': 12, 'kw': {'sort': 'edition_count desc', 'facet.mincount': 1, 'facet_wrapper': <bound method SubjectEngine.facet_wrapper of <openlibrary.plugins.worksearch.subjects.SubjectEngine instance at 0x4228758>>, 'fields': ['key', 'author_name', 'author_key', 'title', 'edition_count', 'ia', 'cover_edition_key', 'has_fulltext', 'subject', 'ia_collection_s', 'public_scan_b', 'overdrive_s', 'lending_edition_s'], 'facets': [{'sort': 'count'}, 'language', 'publisher_facet', {'limit': -1}, 'subject_facet', 'person_facet', 'place_facet', 'time_facet', 'has_fulltext', 'language'], 'facet.limit': 25, 'doc_wrapper': <function work_wrapper at 0x2985c08>}, 'start': 0}
memcache.get 0.000537872314453
    {'hit': True, 'key': '/books/OL19149574M'}
memcache.get 0.000406980514526
    {'hit': True, 'key': '/books/OL7668326M'}
memcache.get 0.000645160675049
    {'hit': True, 'key': '/books/OL7595963M'}
memcache.get 0.000571966171265
    {'hit': True, 'key': '/books/OL997087M'}
memcache.get 0.000317811965942
    {'hit': True, 'key': '/books/OL1700945M'}
memcache.get 0.000370025634766
    {'hit': True, 'key': '/books/OL24753825M'}
memcache.get 0.000540018081665
    {'hit': True, 'key': '/books/OL24216623M'}
memcache.get 0.000607967376709
    {'hit': True, 'key': '/books/OL17924723M'}
memcache.get 0.00100708007812
    {'hit': True, 'key': '/books/OL24766420M'}
memcache.get 0.00526309013367
    {'hit': True, 'key': '/books/OL8667358M'}
memcache.get 0.00070595741272
    {'hit': True, 'key': '/_store/ebooks/books/OL404168M'}
memcache.get 0.00144982337952
    {'hit': False, 'key': '/_store/ebooks/books/OL2208397M'}
infobase 0.00538396835327
    {'path': '/openlibrary.org/_store/ebooks/books/OL2208397M', 'data': None, 'method': 'GET', 'error': True}
memcache.get 0.000383138656616
    {'hit': False, 'key': '/_store/ebooks/books/OL1700945M'}
infobase 0.00296187400818
    {'path': '/openlibrary.org/_store/ebooks/books/OL1700945M', 'data': None, 'method': 'GET', 'error': True}
memcache.get 0.000974893569946
    {'hit': True, 'key': 'inlibrary.libraries-hash'}
infobase 0.01207280159
    {'path': '/openlibrary.org/things', 'data': {'query': '{"type": "/type/list", "seeds": "subject:sql", "limit": 1000, "offset": 0}', 'details': 'False'}, 'method': 'GET'}