Back

SQL Details

Executed SQL
SELECT item_type_mapping.created AS item_type_mapping_created, item_type_mapping.updated AS item_type_mapping_updated, item_type_mapping.id AS item_type_mapping_id, item_type_mapping.item_type_id AS item_type_mapping_item_type_id, item_type_mapping.mapping AS item_type_mapping_mapping, item_type_mapping.version_id AS item_type_mapping_version_id 
FROM item_type_mapping 
WHERE item_type_mapping.item_type_id = %(item_type_id_1)s AND item_type_mapping.mapping IS NOT NULL ORDER BY item_type_mapping.created DESC 
 LIMIT %(param_1)s
Original query duration
0.6137 ms
ITEM_TYPE_MAPPING_CREATED ITEM_TYPE_MAPPING_UPDATED ITEM_TYPE_MAPPING_ID ITEM_TYPE_MAPPING_ITEM_TYPE_ID ITEM_TYPE_MAPPING_MAPPING ITEM_TYPE_MAPPING_VERSION_ID
2022-03-24 23:55:14.713184 2022-03-24 23:55:14.713190 46 21 {'pubdate': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'system_file': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'system_file': {'URI': {'@value': 'subitem_systemfile_filename.subitem_systemfile_filename_uri', '@attributes': {'label': 'subitem_systemfile_filename.subitem_systemfile_filename_label', 'objectType': 'subitem_systemfile_filename.subitem_systemfile_filename_type'}}, 'date': {'@value': 'subitem_systemfile_datetime.subitem_systemfile_datetime_date', '@attributes': {'dateType': 'subitem_systemfile_datetime.subitem_systemfile_datetime_type'}}, 'extent': {'@value': 'subitem_systemfile_size'}, 'version': {'@value': 'subitem_systemfile_version'}, 'mimeType': {'@value': 'subitem_systemfile_mimetype'}}}, 'junii2_mapping': '', 'oai_dc_mapping': {'system_file': {'@value': 'subitem_systemfile_datetime.subitem_systemfile_datetime_date'}}, 'display_lang_type': ''}, 'item_1583103067471': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'title': {'@value': 'subitem_1551255647225', '@attributes': {'xml:lang': 'subitem_1551255648112'}}}, 'junii2_mapping': '', 'oai_dc_mapping': {'title': {'@value': 'subitem_1551255647225'}}, 'display_lang_type': ''}, 'item_1583103085720': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': {'description': {'@value': 'interim'}}, 'display_lang_type': ''}, 'item_1583103108160': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': {'subject': ''}, 'display_lang_type': ''}, 'item_1583103120197': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'file': {'URI': {'@value': 'url.url', '@attributes': {'label': 'url.label', 'objectType': 'url.objectType'}}, 'date': {'@value': 'fileDate.fileDateValue', '@attributes': {'dateType': 'displaytype'}}, 'extent': {'@value': 'filesize.value'}, 'version': {'@value': 'version'}, 'mimeType': {'@value': 'format'}}}, 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'item_1583103131163': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'item_1583103147082': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'item_1583103211336': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'item_1583103233624': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'item_1583105942107': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'creator': {'creatorName': {'@value': 'subitem_authors.subitem_authors_fullname'}}}, 'junii2_mapping': '', 'oai_dc_mapping': {'creator': {'@value': 'subitem_authors.subitem_authors_fullname'}}, 'display_lang_type': ''}, 'item_1583108359239': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'item_1583108428133': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'type': {'@value': '=journal article'}}, 'junii2_mapping': '', 'oai_dc_mapping': {'type': ''}, 'display_lang_type': ''}, 'item_1583159729339': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'date': {'@attributes': {'dateType': 'item_1583159729339'}}}, 'junii2_mapping': '', 'oai_dc_mapping': {'date': ''}, 'display_lang_type': ''}, 'item_1583159847033': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': '', 'junii2_mapping': '', 'oai_dc_mapping': '', 'display_lang_type': ''}, 'system_identifier_doi': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'system_identifier': {'@value': 'subitem_systemidt_identifier', '@attributes': {'identifierType': 'subitem_systemidt_identifier_type'}}}, 'junii2_mapping': '', 'oai_dc_mapping': {'identifier': {'@value': 'subitem_systemidt_identifier'}}, 'display_lang_type': ''}, 'system_identifier_hdl': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'system_identifier': {'@value': 'subitem_systemidt_identifier', '@attributes': {'identifierType': 'subitem_systemidt_identifier_type'}}}, 'junii2_mapping': '', 'oai_dc_mapping': {'identifier': {'@value': 'subitem_systemidt_identifier'}}, 'display_lang_type': ''}, 'system_identifier_uri': {'lom_mapping': '', 'lido_mapping': '', 'spase_mapping': '', 'jpcoar_mapping': {'system_identifier': {'@value': 'subitem_systemidt_identifier', '@attributes': {'identifierType': 'subitem_systemidt_identifier_type'}}}, 'junii2_mapping': '', 'oai_dc_mapping': {'identifier': {'@value': 'subitem_systemidt_identifier'}}, 'display_lang_type': ''}} 1