Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.provider AS provider_3,
  t0.ips AS ips_4
FROM
  server t0
  INNER JOIN drop_server ON t0.id = drop_server.server_id
WHERE
  drop_server.drop_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.provider AS provider_3, t0.ips AS ips_4 FROM server t0 INNER JOIN drop_server ON t0.id = drop_server.server_id WHERE drop_server.drop_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.isp AS isp_3,
  t0.country AS country_4
FROM
  data_list t0
  INNER JOIN drop_data_list ON t0.id = drop_data_list.data_list_id
WHERE
  drop_data_list.drop_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.isp AS isp_3, t0.country AS country_4 FROM data_list t0 INNER JOIN drop_data_list ON t0.id = drop_data_list.data_list_id WHERE drop_data_list.drop_id = 1;

SELECT
  t0.id AS id_1,
  t0.from_name AS from_name_2,
  t0.subject AS subject_3,
  t0.body AS body_4,
  t0.additional_headers AS additional_headers_5,
  t0.email_per_seconde AS email_per_seconde_6,
  t0.ips AS ips_7,
  t0.type_data AS type_data_8,
  t0.status AS status_9,
  t0.drop_start AS drop_start_10,
  t0.drop_stop AS drop_stop_11,
  t0.test_after AS test_after_12,
  t0.test_email AS test_email_13,
  t0.offer_id AS offer_id_14
FROM
  `drop` t0
ORDER BY
  t0.id DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.from_name AS from_name_2, t0.subject AS subject_3, t0.body AS body_4, t0.additional_headers AS additional_headers_5, t0.email_per_seconde AS email_per_seconde_6, t0.ips AS ips_7, t0.type_data AS type_data_8, t0.status AS status_9, t0.drop_start AS drop_start_10, t0.drop_stop AS drop_stop_11, t0.test_after AS test_after_12, t0.test_email AS test_email_13, t0.offer_id AS offer_id_14 FROM `drop` t0 ORDER BY t0.id DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.hostname AS hostname_2,
  t0.port AS port_3,
  t0.login AS login_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.email AS email_7,
  t0.auth AS auth_8
FROM
  smtp t0
  INNER JOIN drop_smtp ON t0.id = drop_smtp.smtp_id
WHERE
  drop_smtp.drop_id = ?

SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.port AS port_3, t0.login AS login_4, t0.password AS password_5, t0.name AS name_6, t0.email AS email_7, t0.auth AS auth_8 FROM smtp t0 INNER JOIN drop_smtp ON t0.id = drop_smtp.smtp_id WHERE drop_smtp.drop_id = 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.date_open AS date_open_3,
  t0.offer_id AS offer_id_4,
  t0.data_list_id AS data_list_id_5,
  t0.customer_id AS customer_id_6,
  t0.drop_id_id AS drop_id_id_7
FROM
  openers t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date_open AS date_open_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM openers t0 WHERE t0.drop_id_id = 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.date AS date_3,
  t0.offer_id AS offer_id_4,
  t0.data_list_id AS data_list_id_5,
  t0.customer_id AS customer_id_6,
  t0.drop_id_id AS drop_id_id_7
FROM
  clicker t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date AS date_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM clicker t0 WHERE t0.drop_id_id = 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.date_unsub AS date_unsub_3,
  t0.offer_id AS offer_id_4,
  t0.data_list_id AS data_list_id_5,
  t0.customer_id AS customer_id_6,
  t0.drop_id_id AS drop_id_id_7
FROM
  unsub t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.date_unsub AS date_unsub_3, t0.offer_id AS offer_id_4, t0.data_list_id AS data_list_id_5, t0.customer_id AS customer_id_6, t0.drop_id_id AS drop_id_id_7 FROM unsub t0 WHERE t0.drop_id_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sponsor AS sponsor_3,
  t0.id_sponsor AS id_sponsor_4,
  t0.url AS url_5,
  t0.unsub AS unsub_6
FROM
  offer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sponsor AS sponsor_3, t0.id_sponsor AS id_sponsor_4, t0.url AS url_5, t0.unsub AS unsub_6 FROM offer t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.open_track AS open_track_3,
  t0.click_track AS click_track_4,
  t0.unsub_track AS unsub_track_5,
  t0.status AS status_6,
  t0.error_message AS error_message_7,
  t0.tracking_url AS tracking_url_8,
  t0.image_server AS image_server_9,
  t0.drop_id_id AS drop_id_id_10,
  t0.smtp_id AS smtp_id_11,
  t0.customer_id AS customer_id_12
FROM
  send t0
WHERE
  t0.drop_id_id = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = 1 AND t0.status = 'sent';

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.open_track AS open_track_3,
  t0.click_track AS click_track_4,
  t0.unsub_track AS unsub_track_5,
  t0.status AS status_6,
  t0.error_message AS error_message_7,
  t0.tracking_url AS tracking_url_8,
  t0.image_server AS image_server_9,
  t0.drop_id_id AS drop_id_id_10,
  t0.smtp_id AS smtp_id_11,
  t0.customer_id AS customer_id_12
FROM
  send t0
WHERE
  t0.drop_id_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.open_track AS open_track_3,
  t0.click_track AS click_track_4,
  t0.unsub_track AS unsub_track_5,
  t0.status AS status_6,
  t0.error_message AS error_message_7,
  t0.tracking_url AS tracking_url_8,
  t0.image_server AS image_server_9,
  t0.drop_id_id AS drop_id_id_10,
  t0.smtp_id AS smtp_id_11,
  t0.customer_id AS customer_id_12
FROM
  send t0
WHERE
  t0.drop_id_id = ?
  AND t0.status = ?
  AND t0.error_message IS NULL

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.open_track AS open_track_3, t0.click_track AS click_track_4, t0.unsub_track AS unsub_track_5, t0.status AS status_6, t0.error_message AS error_message_7, t0.tracking_url AS tracking_url_8, t0.image_server AS image_server_9, t0.drop_id_id AS drop_id_id_10, t0.smtp_id AS smtp_id_11, t0.customer_id AS customer_id_12 FROM send t0 WHERE t0.drop_id_id = 1 AND t0.status = 'sent' AND t0.error_message IS NULL;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6
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.firstname AS firstname_5, t0.lastname AS lastname_6 FROM user t0 WHERE t0.id = 1;