| 1 |
4.18 ms |
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;
|
| 2 |
1.94 ms |
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;
|
| 3 |
4.84 ms |
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 = 6 AND t0.status = 'sent';
|
| 4 |
0.79 ms |
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 = 6 AND t0.status = 'sent' AND t0.error_message IS NULL;
|
| 5 |
2.70 ms |
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 = 6;
|
| 6 |
2.09 ms |
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 = 6;
|
| 7 |
1.60 ms |
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 = 6;
|
| 8 |
0.96 ms |
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 = 5 AND t0.status = 'sent';
|
| 9 |
0.87 ms |
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 = 5 AND t0.status = 'sent' AND t0.error_message IS NULL;
|
| 10 |
0.58 ms |
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 = 5;
|
| 11 |
1.43 ms |
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 = 5;
|
| 12 |
0.38 ms |
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 = 5;
|
| 13 |
2.39 ms |
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 = 4 AND t0.status = 'sent';
|
| 14 |
0.55 ms |
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 = 4 AND t0.status = 'sent' AND t0.error_message IS NULL;
|
| 15 |
0.36 ms |
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 = 4;
|
| 16 |
0.35 ms |
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 = 4;
|
| 17 |
0.34 ms |
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 = 4;
|
| 18 |
1.66 ms |
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 = 3 AND t0.status = 'sent';
|
| 19 |
0.59 ms |
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 = 3 AND t0.status = 'sent' AND t0.error_message IS NULL;
|
| 20 |
0.37 ms |
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 = 3;
|
| 21 |
0.64 ms |
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 = 3;
|
| 22 |
0.40 ms |
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 = 3;
|
| 23 |
0.91 ms |
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 = 2 AND t0.status = 'sent';
|
| 24 |
0.43 ms |
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 = 2 AND t0.status = 'sent' AND t0.error_message IS NULL;
|
| 25 |
0.36 ms |
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 = 2;
|
| 26 |
0.71 ms |
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 = 2;
|
| 27 |
0.34 ms |
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 = 2;
|
| 28 |
0.42 ms |
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';
|
| 29 |
0.41 ms |
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;
|
| 30 |
0.34 ms |
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;
|
| 31 |
0.36 ms |
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;
|
| 32 |
0.55 ms |
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;
|
| 33 |
2.11 ms |
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;
|
| 34 |
2.79 ms |
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 = 6;
|
| 35 |
3.29 ms |
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 = 6;
|
| 36 |
2.35 ms |
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 = 6;
|
| 37 |
0.99 ms |
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 = 6;
|
| 38 |
0.43 ms |
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 = 5;
|
| 39 |
0.49 ms |
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 = 5;
|
| 40 |
0.47 ms |
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 = 5;
|
| 41 |
0.41 ms |
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 = 5;
|
| 42 |
0.61 ms |
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 = 4;
|
| 43 |
0.62 ms |
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 = 4;
|
| 44 |
0.96 ms |
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 = 4;
|
| 45 |
0.37 ms |
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 = 4;
|
| 46 |
0.72 ms |
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 = 3;
|
| 47 |
0.65 ms |
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 = 3;
|
| 48 |
0.44 ms |
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 = 3;
|
| 49 |
0.42 ms |
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 = 3;
|
| 50 |
0.38 ms |
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 = 2;
|
| 51 |
0.41 ms |
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 = 2;
|
| 52 |
0.39 ms |
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 = 2;
|
| 53 |
0.38 ms |
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 = 2;
|
| 54 |
0.44 ms |
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;
|
| 55 |
0.39 ms |
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;
|
| 56 |
0.43 ms |
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;
|
| 57 |
0.57 ms |
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;
|