Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.votes AS votes_2,
  t0.created_on AS created_on_3,
  t0.is_skip AS is_skip_4,
  t0.user_id AS user_id_5,
  t0.vote_event_id AS vote_event_id_6,
  t0.vendor_id AS vendor_id_7
FROM
  vote_item t0
WHERE
  t0.vote_event_id = ?

SELECT t0.id AS id_1, t0.votes AS votes_2, t0.created_on AS created_on_3, t0.is_skip AS is_skip_4, t0.user_id AS user_id_5, t0.vote_event_id AS vote_event_id_6, t0.vendor_id AS vendor_id_7 FROM vote_item t0 WHERE t0.vote_event_id = 45;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.registrationdate AS registrationdate_3,
  t0.taxid AS taxid_4,
  t0.products_and_services AS products_and_services_5,
  t0.rating AS rating_6,
  t0.is_mature AS is_mature_7,
  t0.website AS website_8,
  t0.twitter AS twitter_9,
  t0.table_request_type AS table_request_type_10,
  t0.seating_requests AS seating_requests_11,
  t0.neighbor_requests AS neighbor_requests_12,
  t0.other_requests AS other_requests_13,
  t0.special_requests AS special_requests_14,
  t0.createdon AS createdon_15,
  t0.remote_id AS remote_id_16,
  t0.image_block AS image_block_17,
  t0.table_amount AS table_amount_18,
  t0.num_assistants AS num_assistants_19,
  t0.assistant_amount AS assistant_amount_20,
  t0.has_endcap AS has_endcap_21,
  t0.status AS status_22,
  t0.image_urls AS image_urls_23,
  t0.mature_dealers_section AS mature_dealers_section_24,
  t0.table_category AS table_category_25,
  t0.area AS area_26,
  t27.id AS id_28,
  t27.first_name AS first_name_29,
  t27.last_name AS last_name_30,
  t27.badge_name AS badge_name_31,
  t27.badge_number AS badge_number_32,
  t27.email_address AS email_address_33,
  t27.createdon AS createdon_34,
  t27.vendor_id AS vendor_id_35,
  t36.id AS id_37,
  t36.street1 AS street1_38,
  t36.stree2 AS stree2_39,
  t36.city AS city_40,
  t36.state AS state_41,
  t36.postal AS postal_42,
  t36.country AS country_43,
  t36.createdon AS createdon_44,
  t36.vendor_id AS vendor_id_45
FROM
  vendor t0
  LEFT JOIN vendor_contact t27 ON t27.vendor_id = t0.id
  LEFT JOIN vendor_address t36 ON t36.vendor_id = t0.id
WHERE
  t0.status != ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.registrationdate AS registrationdate_3, t0.taxid AS taxid_4, t0.products_and_services AS products_and_services_5, t0.rating AS rating_6, t0.is_mature AS is_mature_7, t0.website AS website_8, t0.twitter AS twitter_9, t0.table_request_type AS table_request_type_10, t0.seating_requests AS seating_requests_11, t0.neighbor_requests AS neighbor_requests_12, t0.other_requests AS other_requests_13, t0.special_requests AS special_requests_14, t0.createdon AS createdon_15, t0.remote_id AS remote_id_16, t0.image_block AS image_block_17, t0.table_amount AS table_amount_18, t0.num_assistants AS num_assistants_19, t0.assistant_amount AS assistant_amount_20, t0.has_endcap AS has_endcap_21, t0.status AS status_22, t0.image_urls AS image_urls_23, t0.mature_dealers_section AS mature_dealers_section_24, t0.table_category AS table_category_25, t0.area AS area_26, t27.id AS id_28, t27.first_name AS first_name_29, t27.last_name AS last_name_30, t27.badge_name AS badge_name_31, t27.badge_number AS badge_number_32, t27.email_address AS email_address_33, t27.createdon AS createdon_34, t27.vendor_id AS vendor_id_35, t36.id AS id_37, t36.street1 AS street1_38, t36.stree2 AS stree2_39, t36.city AS city_40, t36.state AS state_41, t36.postal AS postal_42, t36.country AS country_43, t36.createdon AS createdon_44, t36.vendor_id AS vendor_id_45 FROM vendor t0 LEFT JOIN vendor_contact t27 ON t27.vendor_id = t0.id LEFT JOIN vendor_address t36 ON t36.vendor_id = t0.id WHERE t0.status != 'Approved';

SELECT
  t0.id AS id_1,
  t0.votes AS votes_2,
  t0.created_on AS created_on_3,
  t0.is_skip AS is_skip_4,
  t0.user_id AS user_id_5,
  t0.vote_event_id AS vote_event_id_6,
  t0.vendor_id AS vendor_id_7
FROM
  vote_item t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.votes AS votes_2, t0.created_on AS created_on_3, t0.is_skip AS is_skip_4, t0.user_id AS user_id_5, t0.vote_event_id AS vote_event_id_6, t0.vendor_id AS vendor_id_7 FROM vote_item t0 WHERE t0.user_id = 5;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.title AS title_6,
  t0.is_verified AS is_verified_7,
  t0.createdon AS createdon_8,
  t0.is_deleted AS is_deleted_9
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.name AS name_5, t0.title AS title_6, t0.is_verified AS is_verified_7, t0.createdon AS createdon_8, t0.is_deleted AS is_deleted_9 FROM user t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.votes AS votes_2,
  t0.created_on AS created_on_3,
  t0.is_skip AS is_skip_4,
  t0.user_id AS user_id_5,
  t0.vote_event_id AS vote_event_id_6,
  t0.vendor_id AS vendor_id_7
FROM
  vote_item t0
WHERE
  t0.user_id = ?
  AND t0.vendor_id = ?
  AND t0.vote_event_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.votes AS votes_2, t0.created_on AS created_on_3, t0.is_skip AS is_skip_4, t0.user_id AS user_id_5, t0.vote_event_id AS vote_event_id_6, t0.vendor_id AS vendor_id_7 FROM vote_item t0 WHERE t0.user_id = 5 AND t0.vendor_id = 3209 AND t0.vote_event_id = 45 LIMIT 1;

SELECT
  v.id
FROM
  vendor v
WHERE
  v.id < :vid
  and v.status != :app
  and v.table_category = :tcat
ORDER BY
  v.id DESC
LIMIT
  1

SELECT v.id FROM vendor v WHERE v.id < :vid and v.status != :app and v.table_category = :tcat ORDER BY v.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.is_primary AS is_primary_3,
  t0.createdon AS createdon_4,
  t0.vendor_id AS vendor_id_5
FROM
  vendor_category t0
WHERE
  t0.vendor_id = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.is_primary AS is_primary_3, t0.createdon AS createdon_4, t0.vendor_id AS vendor_id_5 FROM vendor_category t0 WHERE t0.vendor_id = 3209;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.staff_votes AS staff_votes_3,
  t0.max_vendor_votes AS max_vendor_votes_4,
  t0.starts_on AS starts_on_5,
  t0.ends_on AS ends_on_6,
  t0.created_on AS created_on_7,
  t0.vote_complete AS vote_complete_8,
  t0.status AS status_9,
  t0.table_category AS table_category_10,
  t0.created_by_id AS created_by_id_11
FROM
  vote_event t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.staff_votes AS staff_votes_3, t0.max_vendor_votes AS max_vendor_votes_4, t0.starts_on AS starts_on_5, t0.ends_on AS ends_on_6, t0.created_on AS created_on_7, t0.vote_complete AS vote_complete_8, t0.status AS status_9, t0.table_category AS table_category_10, t0.created_by_id AS created_by_id_11 FROM vote_event t0;

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.createdon AS createdon_3,
  t0.vendor_id AS vendor_id_4
FROM
  vendor_image t0
WHERE
  t0.vendor_id = ?

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.createdon AS createdon_3, t0.vendor_id AS vendor_id_4 FROM vendor_image t0 WHERE t0.vendor_id = 3209;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.title AS title_6,
  t0.is_verified AS is_verified_7,
  t0.createdon AS createdon_8,
  t0.is_deleted AS is_deleted_9
FROM
  user t0

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.title AS title_6, t0.is_verified AS is_verified_7, t0.createdon AS createdon_8, t0.is_deleted AS is_deleted_9 FROM user t0;

SELECT
  t0.id AS id_1,
  t0.createdon AS createdon_2,
  t0.message AS message_3,
  t0.type AS type_4,
  t0.owner_id AS owner_id_5,
  t0.vendor_id AS vendor_id_6
FROM
  vendor_note t0
WHERE
  t0.vendor_id = ?

SELECT t0.id AS id_1, t0.createdon AS createdon_2, t0.message AS message_3, t0.type AS type_4, t0.owner_id AS owner_id_5, t0.vendor_id AS vendor_id_6 FROM vendor_note t0 WHERE t0.vendor_id = 3209;

SELECT
  v.id
FROM
  vendor v
WHERE
  v.id > :vid
  and v.status != :app
  and v.table_category = :tcat
ORDER BY
  v.id ASC
LIMIT
  1

SELECT v.id FROM vendor v WHERE v.id > :vid and v.status != :app and v.table_category = :tcat ORDER BY v.id ASC LIMIT 1;