Query Metrics
6
Database Queries
6
Different statements
7.05 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.67 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 = ?
Parameters:
[
1
]
|
| 2 | 2.63 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 ? ORDER BY c0_.company_name ASC LIMIT 25
Parameters:
[ "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" ] |
| 3 | 0.66 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 c0_.id IN (?) ORDER BY c0_.company_name ASC
Parameters:
[ "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" 37337 ] |
| 4 | 2.41 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 ?
Parameters:
[ "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" "%marty%" ] |
| 5 | 0.36 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 = ?
Parameters:
[
37337
]
|
| 6 | 0.33 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 = ?
Parameters:
[
36694
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Prospect | 2 |
| App\Entity\ShowInfo | 2 |
| App\Entity\User | 1 |
| App\Entity\Company | 1 |
| App\Entity\Contact | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\TodoNotes | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\BusinessType | No errors. |
| App\Entity\Prospect | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\ExhibitorProduct | No errors. |
| App\Entity\ExhibitorService | No errors. |
| App\Entity\ShowInfo | No errors. |