| 1 |
0.60 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.status AS status_7 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.status AS status_7 FROM `user` t0 WHERE t0.id = 1;
|
| 2 |
3.03 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.company_name AS company_name_1 FROM company c0_ WHERE (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) AND (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) AND (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) ORDER BY c0_.company_name ASC LIMIT 25
Parameters: [
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
]
SELECT
DISTINCT c0_.id AS id_0,
c0_.company_name AS company_name_1
FROM
company c0_
WHERE
(
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
AND (
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
AND (
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
ORDER BY
c0_.company_name ASC
LIMIT
25
SELECT DISTINCT c0_.id AS id_0, c0_.company_name AS company_name_1 FROM company c0_ WHERE (LOWER(CONCAT(c0_.company_name, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%houston%' OR LOWER(c0_.roles) LIKE '%houston%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%houston%') AND (LOWER(CONCAT(c0_.company_name, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%auto%' OR LOWER(c0_.roles) LIKE '%auto%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%auto%') AND (LOWER(CONCAT(c0_.company_name, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%show%' OR LOWER(c0_.roles) LIKE '%show%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%show%') ORDER BY c0_.company_name ASC LIMIT 25;
|
| 3 |
0.92 ms |
SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.active AS active_2, c0_.address1 AS address1_3, c0_.address2 AS address2_4, c0_.city AS city_5, c0_.state AS state_6, c0_.zip AS zip_7, c0_.country AS country_8, c0_.phone AS phone_9, c0_.fax AS fax_10, c0_.website AS website_11, c0_.facebook AS facebook_12, c0_.instagram AS instagram_13, c0_.linkedin AS linkedin_14, c0_.twitter AS twitter_15, c0_.marine_related AS marine_related_16, c0_.non_profit AS non_profit_17, c0_.opt_out AS opt_out_18, c0_.black_ball AS black_ball_19, c0_.notes AS notes_20, c0_.dba AS dba_21, c0_.business_type AS business_type_22, c0_.filter_invitations AS filter_invitations_23, c0_.mailing_address1 AS mailing_address1_24, c0_.mailing_address2 AS mailing_address2_25, c0_.mailing_city AS mailing_city_26, c0_.mailing_state AS mailing_state_27, c0_.mailing_zip AS mailing_zip_28, c0_.mailing_country AS mailing_country_29, c0_.password AS password_30, c0_.logo AS logo_31, c0_.username AS username_32, c0_.password_plain AS password_plain_33, c0_.roles AS roles_34, c0_.company_description AS company_description_35, c0_.date_created AS date_created_36, c0_.membership_level AS membership_level_37, c0_.primary_contact_id AS primary_contact_id_38, c0_.biz_type_id AS biz_type_id_39 FROM company c0_ WHERE (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) AND (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) AND (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) AND c0_.id IN (?) ORDER BY c0_.company_name ASC
Parameters: [
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
36638
]
SELECT
c0_.id AS id_0,
c0_.company_name AS company_name_1,
c0_.active AS active_2,
c0_.address1 AS address1_3,
c0_.address2 AS address2_4,
c0_.city AS city_5,
c0_.state AS state_6,
c0_.zip AS zip_7,
c0_.country AS country_8,
c0_.phone AS phone_9,
c0_.fax AS fax_10,
c0_.website AS website_11,
c0_.facebook AS facebook_12,
c0_.instagram AS instagram_13,
c0_.linkedin AS linkedin_14,
c0_.twitter AS twitter_15,
c0_.marine_related AS marine_related_16,
c0_.non_profit AS non_profit_17,
c0_.opt_out AS opt_out_18,
c0_.black_ball AS black_ball_19,
c0_.notes AS notes_20,
c0_.dba AS dba_21,
c0_.business_type AS business_type_22,
c0_.filter_invitations AS filter_invitations_23,
c0_.mailing_address1 AS mailing_address1_24,
c0_.mailing_address2 AS mailing_address2_25,
c0_.mailing_city AS mailing_city_26,
c0_.mailing_state AS mailing_state_27,
c0_.mailing_zip AS mailing_zip_28,
c0_.mailing_country AS mailing_country_29,
c0_.password AS password_30,
c0_.logo AS logo_31,
c0_.username AS username_32,
c0_.password_plain AS password_plain_33,
c0_.roles AS roles_34,
c0_.company_description AS company_description_35,
c0_.date_created AS date_created_36,
c0_.membership_level AS membership_level_37,
c0_.primary_contact_id AS primary_contact_id_38,
c0_.biz_type_id AS biz_type_id_39
FROM
company c0_
WHERE
(
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
AND (
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
AND (
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
AND c0_.id IN (?)
ORDER BY
c0_.company_name ASC
SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.active AS active_2, c0_.address1 AS address1_3, c0_.address2 AS address2_4, c0_.city AS city_5, c0_.state AS state_6, c0_.zip AS zip_7, c0_.country AS country_8, c0_.phone AS phone_9, c0_.fax AS fax_10, c0_.website AS website_11, c0_.facebook AS facebook_12, c0_.instagram AS instagram_13, c0_.linkedin AS linkedin_14, c0_.twitter AS twitter_15, c0_.marine_related AS marine_related_16, c0_.non_profit AS non_profit_17, c0_.opt_out AS opt_out_18, c0_.black_ball AS black_ball_19, c0_.notes AS notes_20, c0_.dba AS dba_21, c0_.business_type AS business_type_22, c0_.filter_invitations AS filter_invitations_23, c0_.mailing_address1 AS mailing_address1_24, c0_.mailing_address2 AS mailing_address2_25, c0_.mailing_city AS mailing_city_26, c0_.mailing_state AS mailing_state_27, c0_.mailing_zip AS mailing_zip_28, c0_.mailing_country AS mailing_country_29, c0_.password AS password_30, c0_.logo AS logo_31, c0_.username AS username_32, c0_.password_plain AS password_plain_33, c0_.roles AS roles_34, c0_.company_description AS company_description_35, c0_.date_created AS date_created_36, c0_.membership_level AS membership_level_37, c0_.primary_contact_id AS primary_contact_id_38, c0_.biz_type_id AS biz_type_id_39 FROM company c0_ WHERE (LOWER(CONCAT(c0_.company_name, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%houston%' OR LOWER(c0_.roles) LIKE '%houston%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%houston%') AND (LOWER(CONCAT(c0_.company_name, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%auto%' OR LOWER(c0_.roles) LIKE '%auto%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%auto%') AND (LOWER(CONCAT(c0_.company_name, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%show%' OR LOWER(c0_.roles) LIKE '%show%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%show%') AND c0_.id IN (36638) ORDER BY c0_.company_name ASC;
|
| 4 |
2.86 ms |
SELECT count(*) AS sclr_0 FROM company c0_ WHERE (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) AND (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?) AND (LOWER(CONCAT(c0_.company_name, '')) LIKE ? OR LOWER(CONCAT(c0_.address1, '')) LIKE ? OR LOWER(CONCAT(c0_.address2, '')) LIKE ? OR LOWER(CONCAT(c0_.city, '')) LIKE ? OR LOWER(CONCAT(c0_.state, '')) LIKE ? OR LOWER(CONCAT(c0_.zip, '')) LIKE ? OR LOWER(CONCAT(c0_.country, '')) LIKE ? OR LOWER(CONCAT(c0_.phone, '')) LIKE ? OR LOWER(CONCAT(c0_.fax, '')) LIKE ? OR LOWER(CONCAT(c0_.website, '')) LIKE ? OR LOWER(CONCAT(c0_.facebook, '')) LIKE ? OR LOWER(CONCAT(c0_.instagram, '')) LIKE ? OR LOWER(CONCAT(c0_.linkedin, '')) LIKE ? OR LOWER(CONCAT(c0_.twitter, '')) LIKE ? OR LOWER(CONCAT(c0_.notes, '')) LIKE ? OR LOWER(CONCAT(c0_.dba, '')) LIKE ? OR LOWER(CONCAT(c0_.business_type, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE ? OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE ? OR LOWER(CONCAT(c0_.password, '')) LIKE ? OR LOWER(CONCAT(c0_.logo, '')) LIKE ? OR LOWER(CONCAT(c0_.username, '')) LIKE ? OR LOWER(CONCAT(c0_.password_plain, '')) LIKE ? OR LOWER(c0_.roles) LIKE ? OR LOWER(CONCAT(c0_.company_description, '')) LIKE ? OR LOWER(CONCAT(c0_.membership_level, '')) LIKE ?)
Parameters: [
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%houston%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%auto%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
"%show%"
]
SELECT
count(*) AS sclr_0
FROM
company c0_
WHERE
(
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
AND (
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
AND (
LOWER(
CONCAT(c0_.company_name, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.phone, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.fax, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.website, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.facebook, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.instagram, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.linkedin, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.twitter, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.notes, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.dba, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.business_type, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address1, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_address2, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_city, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_state, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_zip, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.mailing_country, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.logo, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.username, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.password_plain, '')
) LIKE ?
OR LOWER(c0_.roles) LIKE ?
OR LOWER(
CONCAT(c0_.company_description, '')
) LIKE ?
OR LOWER(
CONCAT(c0_.membership_level, '')
) LIKE ?
)
SELECT count(*) AS sclr_0 FROM company c0_ WHERE (LOWER(CONCAT(c0_.company_name, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%houston%' OR LOWER(c0_.roles) LIKE '%houston%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%houston%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%houston%') AND (LOWER(CONCAT(c0_.company_name, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%auto%' OR LOWER(c0_.roles) LIKE '%auto%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%auto%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%auto%') AND (LOWER(CONCAT(c0_.company_name, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.address1, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.address2, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.city, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.state, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.zip, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.country, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.phone, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.fax, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.website, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.facebook, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.instagram, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.linkedin, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.twitter, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.notes, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.dba, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.business_type, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_address1, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_address2, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_city, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_state, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_zip, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.mailing_country, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.password, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.logo, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.username, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.password_plain, '')) LIKE '%show%' OR LOWER(c0_.roles) LIKE '%show%' OR LOWER(CONCAT(c0_.company_description, '')) LIKE '%show%' OR LOWER(CONCAT(c0_.membership_level, '')) LIKE '%show%');
|
| 5 |
0.34 ms |
SELECT t0.id AS id_1, t0.send_complimentary_tickets AS send_complimentary_tickets_2, t0.notes AS notes_3, t0.send_email_invite AS send_email_invite_4, t0.show_selection_id AS show_selection_id_5, t0.company_id AS company_id_6 FROM prospect t0 WHERE t0.company_id = ?
SELECT t0.id AS id_1, t0.send_complimentary_tickets AS send_complimentary_tickets_2, t0.notes AS notes_3, t0.send_email_invite AS send_email_invite_4, t0.show_selection_id AS show_selection_id_5, t0.company_id AS company_id_6 FROM prospect t0 WHERE t0.company_id = 36638;
|
| 6 |
0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.first_name AS first_name_3, t0.middle_name AS middle_name_4, t0.last_name AS last_name_5, t0.suffix AS suffix_6, t0.nickname AS nickname_7, t0.cell_phone AS cell_phone_8, t0.phone AS phone_9, t0.phone_extension AS phone_extension_10, t0.email AS email_11, t0.email2 AS email2_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.linked_in AS linked_in_15, t0.twitter AS twitter_16, t0.notes AS notes_17, t0.date_created AS date_created_18, t0.fax AS fax_19, t0.company_id AS company_id_20 FROM contact t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.first_name AS first_name_3, t0.middle_name AS middle_name_4, t0.last_name AS last_name_5, t0.suffix AS suffix_6, t0.nickname AS nickname_7, t0.cell_phone AS cell_phone_8, t0.phone AS phone_9, t0.phone_extension AS phone_extension_10, t0.email AS email_11, t0.email2 AS email2_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.linked_in AS linked_in_15, t0.twitter AS twitter_16, t0.notes AS notes_17, t0.date_created AS date_created_18, t0.fax AS fax_19, t0.company_id AS company_id_20 FROM contact t0 WHERE t0.id = 37695;
|