Symfony Profiler

SELECT
  t0.is_published AS is_published_1,
  t0.date_added AS date_added_2,
  t0.created_by AS created_by_3,
  t0.created_by_user AS created_by_user_4,
  t0.date_modified AS date_modified_5,
  t0.modified_by AS modified_by_6,
  t0.modified_by_user AS modified_by_user_7,
  t0.checked_out AS checked_out_8,
  t0.checked_out_by AS checked_out_by_9,
  t0.checked_out_by_user AS checked_out_by_user_10,
  t0.id AS id_11,
  t0.name AS name_12,
  t0.description AS description_13,
  t0.properties AS properties_14,
  t0.uuid AS uuid_15
FROM
  projects t0
  INNER JOIN company_projects_xref ON t0.id = company_projects_xref.project_id
WHERE
  company_projects_xref.company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.is_published AS is_published_1, t0.date_added AS date_added_2, t0.created_by AS created_by_3, t0.created_by_user AS created_by_user_4, t0.date_modified AS date_modified_5, t0.modified_by AS modified_by_6, t0.modified_by_user AS modified_by_user_7, t0.checked_out AS checked_out_8, t0.checked_out_by AS checked_out_by_9, t0.checked_out_by_user AS checked_out_by_user_10, t0.id AS id_11, t0.name AS name_12, t0.description AS description_13, t0.properties AS properties_14, t0.uuid AS uuid_15 FROM projects t0 INNER JOIN company_projects_xref ON t0.id = company_projects_xref.project_id WHERE company_projects_xref.company_id = 118 ORDER BY t0.name ASC;

SELECT
  u0_.is_published AS is_published_0,
  u0_.date_added AS date_added_1,
  u0_.created_by AS created_by_2,
  u0_.created_by_user AS created_by_user_3,
  u0_.date_modified AS date_modified_4,
  u0_.modified_by AS modified_by_5,
  u0_.modified_by_user AS modified_by_user_6,
  u0_.checked_out AS checked_out_7,
  u0_.checked_out_by AS checked_out_by_8,
  u0_.checked_out_by_user AS checked_out_by_user_9,
  u0_.id AS id_10,
  u0_.username AS username_11,
  u0_.password AS password_12,
  u0_.first_name AS first_name_13,
  u0_.last_name AS last_name_14,
  u0_.email AS email_15,
  u0_.position AS position_16,
  u0_.timezone AS timezone_17,
  u0_.locale AS locale_18,
  u0_.last_login AS last_login_19,
  u0_.last_active AS last_active_20,
  u0_.preferences AS preferences_21,
  u0_.signature AS signature_22,
  r1_.is_published AS is_published_23,
  r1_.date_added AS date_added_24,
  r1_.created_by AS created_by_25,
  r1_.created_by_user AS created_by_user_26,
  r1_.date_modified AS date_modified_27,
  r1_.modified_by AS modified_by_28,
  r1_.modified_by_user AS modified_by_user_29,
  r1_.checked_out AS checked_out_30,
  r1_.checked_out_by AS checked_out_by_31,
  r1_.checked_out_by_user AS checked_out_by_user_32,
  r1_.id AS id_33,
  r1_.name AS name_34,
  r1_.description AS description_35,
  r1_.is_admin AS is_admin_36,
  r1_.readable_permissions AS readable_permissions_37,
  r1_.uuid AS uuid_38,
  u0_.role_id AS role_id_39
FROM
  users u0_
  LEFT JOIN roles r1_ ON u0_.role_id = r1_.id
WHERE
  (
    u0_.username = ?
    OR u0_.email = ?
  )
  AND u0_.is_published = ?

SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.preferences AS preferences_21, u0_.signature AS signature_22, r1_.is_published AS is_published_23, r1_.date_added AS date_added_24, r1_.created_by AS created_by_25, r1_.created_by_user AS created_by_user_26, r1_.date_modified AS date_modified_27, r1_.modified_by AS modified_by_28, r1_.modified_by_user AS modified_by_user_29, r1_.checked_out AS checked_out_30, r1_.checked_out_by AS checked_out_by_31, r1_.checked_out_by_user AS checked_out_by_user_32, r1_.id AS id_33, r1_.name AS name_34, r1_.description AS description_35, r1_.is_admin AS is_admin_36, r1_.readable_permissions AS readable_permissions_37, r1_.uuid AS uuid_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE (u0_.username = 'admin' OR u0_.email = 'admin') AND u0_.is_published = 1;

SELECT
  COUNT(comp.id) as count
FROM
  companies comp
WHERE
  comp.deleted IS NULL

SELECT COUNT(comp.id) as count FROM companies comp WHERE comp.deleted IS NULL;

SELECT
  count(cl.lead_id) as thecount,
  cl.company_id
FROM
  companies_leads cl
WHERE
  cl.company_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  cl.company_id

SELECT count(cl.lead_id) as thecount, cl.company_id FROM companies_leads cl WHERE cl.company_id IN (118, 78, 318, 174, 179, 527, 210, 382, 381, 235, 154, 326, 119, 377, 496, 368, 367, 526, 488, 288, 221, 312, 268, 149, 341, 147, 98, 294, 81, 150) GROUP BY cl.company_id;

SELECT
  comp.*
FROM
  companies comp
WHERE
  comp.deleted IS NULL
ORDER BY
  comp.companyname ASC
LIMIT
  30

SELECT comp.* FROM companies comp WHERE comp.deleted IS NULL ORDER BY comp.companyname ASC LIMIT 30;

SELECT
  c0_.is_published AS is_published_0,
  c0_.date_added AS date_added_1,
  c0_.created_by AS created_by_2,
  c0_.created_by_user AS created_by_user_3,
  c0_.date_modified AS date_modified_4,
  c0_.modified_by AS modified_by_5,
  c0_.modified_by_user AS modified_by_user_6,
  c0_.checked_out AS checked_out_7,
  c0_.checked_out_by AS checked_out_by_8,
  c0_.checked_out_by_user AS checked_out_by_user_9,
  c0_.id AS id_10,
  c0_.social_cache AS social_cache_11,
  c0_.score AS score_12,
  c0_.deleted AS deleted_13,
  c0_.companyemail AS companyemail_14,
  c0_.companyaddress1 AS companyaddress1_15,
  c0_.companyaddress2 AS companyaddress2_16,
  c0_.companyphone AS companyphone_17,
  c0_.companycity AS companycity_18,
  c0_.companystate AS companystate_19,
  c0_.companyzipcode AS companyzipcode_20,
  c0_.companycountry AS companycountry_21,
  c0_.companyname AS companyname_22,
  c0_.companywebsite AS companywebsite_23,
  c0_.companyindustry AS companyindustry_24,
  c0_.companydescription AS companydescription_25,
  (
    CASE WHEN c0_.id = 118 THEN 0 WHEN c0_.id = 78 THEN 1 WHEN c0_.id = 318 THEN 2 WHEN c0_.id = 174 THEN 3 WHEN c0_.id = 179 THEN 4 WHEN c0_.id = 527 THEN 5 WHEN c0_.id = 210 THEN 6 WHEN c0_.id = 382 THEN 7 WHEN c0_.id = 381 THEN 8 WHEN c0_.id = 235 THEN 9 WHEN c0_.id = 154 THEN 10 WHEN c0_.id = 326 THEN 11 WHEN c0_.id = 119 THEN 12 WHEN c0_.id = 377 THEN 13 WHEN c0_.id = 496 THEN 14 WHEN c0_.id = 368 THEN 15 WHEN c0_.id = 367 THEN 16 WHEN c0_.id = 526 THEN 17 WHEN c0_.id = 488 THEN 18 WHEN c0_.id = 288 THEN 19 WHEN c0_.id = 221 THEN 20 WHEN c0_.id = 312 THEN 21 WHEN c0_.id = 268 THEN 22 WHEN c0_.id = 149 THEN 23 WHEN c0_.id = 341 THEN 24 WHEN c0_.id = 147 THEN 25 WHEN c0_.id = 98 THEN 26 WHEN c0_.id = 294 THEN 27 WHEN c0_.id = 81 THEN 28 WHEN c0_.id = 150 THEN 29 ELSE 30 END
  ) AS sclr_26,
  c0_.owner_id AS owner_id_27
FROM
  companies c0_
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  sclr_26 ASC

SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.social_cache AS social_cache_11, c0_.score AS score_12, c0_.deleted AS deleted_13, c0_.companyemail AS companyemail_14, c0_.companyaddress1 AS companyaddress1_15, c0_.companyaddress2 AS companyaddress2_16, c0_.companyphone AS companyphone_17, c0_.companycity AS companycity_18, c0_.companystate AS companystate_19, c0_.companyzipcode AS companyzipcode_20, c0_.companycountry AS companycountry_21, c0_.companyname AS companyname_22, c0_.companywebsite AS companywebsite_23, c0_.companyindustry AS companyindustry_24, c0_.companydescription AS companydescription_25, (CASE WHEN c0_.id = 118 THEN 0 WHEN c0_.id = 78 THEN 1 WHEN c0_.id = 318 THEN 2 WHEN c0_.id = 174 THEN 3 WHEN c0_.id = 179 THEN 4 WHEN c0_.id = 527 THEN 5 WHEN c0_.id = 210 THEN 6 WHEN c0_.id = 382 THEN 7 WHEN c0_.id = 381 THEN 8 WHEN c0_.id = 235 THEN 9 WHEN c0_.id = 154 THEN 10 WHEN c0_.id = 326 THEN 11 WHEN c0_.id = 119 THEN 12 WHEN c0_.id = 377 THEN 13 WHEN c0_.id = 496 THEN 14 WHEN c0_.id = 368 THEN 15 WHEN c0_.id = 367 THEN 16 WHEN c0_.id = 526 THEN 17 WHEN c0_.id = 488 THEN 18 WHEN c0_.id = 288 THEN 19 WHEN c0_.id = 221 THEN 20 WHEN c0_.id = 312 THEN 21 WHEN c0_.id = 268 THEN 22 WHEN c0_.id = 149 THEN 23 WHEN c0_.id = 341 THEN 24 WHEN c0_.id = 147 THEN 25 WHEN c0_.id = 98 THEN 26 WHEN c0_.id = 294 THEN 27 WHEN c0_.id = 81 THEN 28 WHEN c0_.id = 150 THEN 29 ELSE 30 END) AS sclr_26, c0_.owner_id AS owner_id_27 FROM companies c0_ WHERE c0_.id IN (118, 78, 318, 174, 179, 527, 210, 382, 381, 235, 154, 326, 119, 377, 496, 368, 367, 526, 488, 288, 221, 312, 268, 149, 341, 147, 98, 294, 81, 150) ORDER BY sclr_26 ASC;

SELECT
  l0_.is_published AS is_published_0,
  l0_.date_added AS date_added_1,
  l0_.created_by AS created_by_2,
  l0_.created_by_user AS created_by_user_3,
  l0_.date_modified AS date_modified_4,
  l0_.modified_by AS modified_by_5,
  l0_.modified_by_user AS modified_by_user_6,
  l0_.checked_out AS checked_out_7,
  l0_.checked_out_by AS checked_out_by_8,
  l0_.checked_out_by_user AS checked_out_by_user_9,
  l0_.id AS id_10,
  l0_.label AS label_11,
  l0_.alias AS alias_12,
  l0_.type AS type_13,
  l0_.field_group AS field_group_14,
  l0_.default_value AS default_value_15,
  l0_.is_required AS is_required_16,
  l0_.is_fixed AS is_fixed_17,
  l0_.is_visible AS is_visible_18,
  l0_.is_short_visible AS is_short_visible_19,
  l0_.is_listable AS is_listable_20,
  l0_.is_publicly_updatable AS is_publicly_updatable_21,
  l0_.is_unique_identifer AS is_unique_identifer_22,
  l0_.is_index AS is_index_23,
  l0_.char_length_limit AS char_length_limit_24,
  l0_.field_order AS field_order_25,
  l0_.object AS object_26,
  l0_.properties AS properties_27,
  l0_.column_is_not_created AS column_is_not_created_28,
  l0_.column_is_not_removed AS column_is_not_removed_29,
  l0_.original_is_published_value AS original_is_published_value_30,
  l0_.uuid AS uuid_31
FROM
  lead_fields l0_
WHERE
  l0_.is_published = ?
  AND l0_.object = ?
ORDER BY
  l0_.field_order ASC

SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.is_index AS is_index_23, l0_.char_length_limit AS char_length_limit_24, l0_.field_order AS field_order_25, l0_.object AS object_26, l0_.properties AS properties_27, l0_.column_is_not_created AS column_is_not_created_28, l0_.column_is_not_removed AS column_is_not_removed_29, l0_.original_is_published_value AS original_is_published_value_30, l0_.uuid AS uuid_31 FROM lead_fields l0_ WHERE l0_.is_published = 1 AND l0_.object = 'company' ORDER BY l0_.field_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.bundle AS bundle_1,
  p0_.name AS name_2,
  p0_.bitwise AS bitwise_3,
  p0_.uuid AS uuid_4
FROM
  permissions p0_
WHERE
  p0_.role_id = ?
ORDER BY
  p0_.bundle ASC

SELECT p0_.id AS id_0, p0_.bundle AS bundle_1, p0_.name AS name_2, p0_.bitwise AS bitwise_3, p0_.uuid AS uuid_4 FROM permissions p0_ WHERE p0_.role_id = 1 ORDER BY p0_.bundle ASC;

SELECT
  f.id,
  f.label,
  f.alias,
  f.type,
  f.field_group as "group",
  f.object,
  f.is_fixed,
  f.properties,
  f.default_value
FROM
  lead_fields f
WHERE
  (f.is_published = ?)
  AND (object = ?)
ORDER BY
  f.field_order asc

SELECT f.id, f.label, f.alias, f.type, f.field_group as "group", f.object, f.is_fixed, f.properties, f.default_value FROM lead_fields f WHERE (f.is_published = 1) AND (object = 'company') ORDER BY f.field_order asc;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.is_missing AS is_missing_3,
  p0_.bundle AS bundle_4,
  p0_.version AS version_5,
  p0_.author AS author_6
FROM
  plugins p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.is_missing AS is_missing_3, p0_.bundle AS bundle_4, p0_.version AS version_5, p0_.author AS author_6 FROM plugins p0_ ORDER BY p0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.is_published AS is_published_2,
  p0_.supported_features AS supported_features_3,
  p0_.api_keys AS api_keys_4,
  p0_.feature_settings AS feature_settings_5,
  p0_.plugin_id AS plugin_id_6
FROM
  plugin_integration_settings p0_
  INNER JOIN plugins p1_ ON p0_.plugin_id = p1_.id

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_published AS is_published_2, p0_.supported_features AS supported_features_3, p0_.api_keys AS api_keys_4, p0_.feature_settings AS feature_settings_5, p0_.plugin_id AS plugin_id_6 FROM plugin_integration_settings p0_ INNER JOIN plugins p1_ ON p0_.plugin_id = p1_.id;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.is_published AS is_published_2,
  p0_.supported_features AS supported_features_3,
  p0_.api_keys AS api_keys_4,
  p0_.feature_settings AS feature_settings_5,
  p0_.plugin_id AS plugin_id_6
FROM
  plugin_integration_settings p0_
WHERE
  p0_.name = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_published AS is_published_2, p0_.supported_features AS supported_features_3, p0_.api_keys AS api_keys_4, p0_.feature_settings AS feature_settings_5, p0_.plugin_id AS plugin_id_6 FROM plugin_integration_settings p0_ WHERE p0_.name = 'grapesjsbuilder' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.is_published AS is_published_2,
  p0_.supported_features AS supported_features_3,
  p0_.api_keys AS api_keys_4,
  p0_.feature_settings AS feature_settings_5,
  p0_.plugin_id AS plugin_id_6
FROM
  plugin_integration_settings p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_published AS is_published_2, p0_.supported_features AS supported_features_3, p0_.api_keys AS api_keys_4, p0_.feature_settings AS feature_settings_5, p0_.plugin_id AS plugin_id_6 FROM plugin_integration_settings p0_;