Created
July 23, 2010 04:00
-
-
Save raphaelcosta/486990 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH NAME: NAME_TELEPHONE_NUMBER | |
SQL (0.5ms) SELECT COUNT(*) AS count_id FROM `database_fields` WHERE (`database_fields`.`database_id` = 30) AND (`database_fields`.`field_type_id` = 9) | |
DatabaseField Load (0.4ms) SELECT `database_fields`.* FROM `database_fields` WHERE (`database_fields`.`database_id` = 30) AND (`database_fields`.`field_type_id` = 9) | |
EntryValue Load (1.1ms) SELECT `entry_values`.* FROM `entry_values` WHERE (`entry_values`.`entry_id` = 1202) AND (`entry_values`.`database_field_id` = 77) LIMIT 1 | |
DatabaseField Load (0.4ms) SELECT `database_fields`.* FROM `database_fields` WHERE (`database_fields`.`id` = 77) LIMIT 1 | |
FieldType Load (0.4ms) SELECT `field_types`.* FROM `field_types` WHERE (`field_types`.`id` = 9) LIMIT 1 | |
Multiple_fields_criteria: keep_order | |
EntryValue Load (0.5ms) SELECT `entry_values`.* FROM `entry_values` WHERE (`entry_values`.`entry_id` = 1398) AND (`entry_values`.`database_field_id` = 77) LIMIT 1 | |
DatabaseField Load (0.4ms) SELECT `database_fields`.* FROM `database_fields` WHERE (`database_fields`.`id` = 77) LIMIT 1 | |
FieldType Load (0.4ms) SELECT `field_types`.* FROM `field_types` WHERE (`field_types`.`id` = 9) LIMIT 1 | |
FIELD PRECISION 0.5 | |
VALUE BE MERGED: JARBAS MOREIRA DE CARVALHO | |
SELF VALUE: DENIZART P. DE CARVALHO | |
RESULT: 0.15 | |
SQL (0.5ms) SELECT COUNT(*) AS count_id FROM `database_fields` WHERE (`database_fields`.`database_id` = 30) AND (`database_fields`.`field_type_id` = 13) | |
DatabaseField Load (0.4ms) SELECT `database_fields`.* FROM `database_fields` WHERE (`database_fields`.`database_id` = 30) AND (`database_fields`.`field_type_id` = 13) | |
EntryValue Load (0.8ms) SELECT `entry_values`.* FROM `entry_values` WHERE (`entry_values`.`entry_id` = 1202) AND (`entry_values`.`database_field_id` = 83) LIMIT 1 | |
DatabaseField Load (0.4ms) SELECT `database_fields`.* FROM `database_fields` WHERE (`database_fields`.`id` = 83) LIMIT 1 | |
FieldType Load (0.4ms) SELECT `field_types`.* FROM `field_types` WHERE (`field_types`.`id` = 13) LIMIT 1 | |
Multiple_fields_criteria: keep_order | |
EntryValue Load (0.9ms) SELECT `entry_values`.* FROM `entry_values` WHERE (`entry_values`.`entry_id` = 1398) AND (`entry_values`.`database_field_id` = 83) LIMIT 1 | |
FIELD PRECISION 0.8 | |
VALUE BE MERGED: 41301409990 | |
SELF VALUE: 41301409990 | |
RESULT: 0.7 | |
MATCHRATE 0.85 | |
MERGED WITH 0.85 in name_telephone_number |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment