Skip to content

Instantly share code, notes, and snippets.

@raphaelcosta
Created July 23, 2010 04:00
Show Gist options
  • Save raphaelcosta/486990 to your computer and use it in GitHub Desktop.
Save raphaelcosta/486990 to your computer and use it in GitHub Desktop.
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