GET https://promail.7ap.tech/drops/1?p=drops%2F1

Query Metrics

12 Database Queries
12 Different statements
41.51 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.56 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 = ?
Parameters:
[
  1
]
2 5.22 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
Parameters:
[]
3 2.35 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 = ?
Parameters:
[
  1
  "sent"
]
4 0.73 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
Parameters:
[
  1
  "sent"
]
5 5.12 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 = ?
Parameters:
[
  1
]
6 4.87 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 = ?
Parameters:
[
  1
]
7 3.27 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 = ?
Parameters:
[
  1
]
8 2.56 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 = ?
Parameters:
[
  1
]
9 5.28 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 = ?
Parameters:
[
  1
]
10 5.66 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 = ?
Parameters:
[
  1
]
11 5.14 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 = ?
Parameters:
[
  1
]
12 0.76 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 = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Drop No errors.
App\Entity\Offer No errors.
App\Entity\DataList No errors.
App\Entity\Smtp No errors.
App\Entity\Server No errors.
App\Entity\Send No errors.
App\Entity\Openers No errors.
App\Entity\Clicker No errors.
App\Entity\Unsub No errors.
App\Entity\TrackingUrl No errors.
App\Entity\ImageUrl No errors.
App\Entity\Customer No errors.
App\Entity\Suppression No errors.
App\Entity\OfferBody No errors.
App\Entity\OfferSubject No errors.
App\Entity\OfferFrom No errors.