Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.str_nomber AS str_nomber_3,
  t0.floor AS floor_4,
  t0.door AS door_5,
  t0.city AS city_6,
  t0.postal_code AS postal_code_7,
  t0.country AS country_8,
  t0.total_rooms AS total_rooms_9,
  t0.total_bathrooms AS total_bathrooms_10,
  t0.lift AS lift_11,
  t0.door_man AS door_man_12,
  t0.room_size AS room_size_13,
  t0.window_type AS window_type_14,
  t0.inner_outer_position AS inner_outer_position_15,
  t0.title AS title_16,
  t0.url AS url_17,
  t0.description AS description_18,
  t0.price AS price_19,
  t0.deposit AS deposit_20,
  t0.rental_conditions AS rental_conditions_21,
  t0.publish_date AS publish_date_22,
  t0.last_update AS last_update_23,
  t0.available_from AS available_from_24,
  t0.active AS active_25,
  t0.internal_ref AS internal_ref_26,
  t0.images AS images_27,
  t0.three_d AS three_d_28,
  t0.bed_size AS bed_size_29,
  t0.wifi AS wifi_30,
  t0.living_room AS living_room_31,
  t0.lat_long AS lat_long_32,
  t0.lang AS lang_33,
  t0.user_id_id AS user_id_id_34
FROM
  room t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.street AS street_2, t0.str_nomber AS str_nomber_3, t0.floor AS floor_4, t0.door AS door_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.total_rooms AS total_rooms_9, t0.total_bathrooms AS total_bathrooms_10, t0.lift AS lift_11, t0.door_man AS door_man_12, t0.room_size AS room_size_13, t0.window_type AS window_type_14, t0.inner_outer_position AS inner_outer_position_15, t0.title AS title_16, t0.url AS url_17, t0.description AS description_18, t0.price AS price_19, t0.deposit AS deposit_20, t0.rental_conditions AS rental_conditions_21, t0.publish_date AS publish_date_22, t0.last_update AS last_update_23, t0.available_from AS available_from_24, t0.active AS active_25, t0.internal_ref AS internal_ref_26, t0.images AS images_27, t0.three_d AS three_d_28, t0.bed_size AS bed_size_29, t0.wifi AS wifi_30, t0.living_room AS living_room_31, t0.lat_long AS lat_long_32, t0.lang AS lang_33, t0.user_id_id AS user_id_id_34 FROM room t0 WHERE t0.url = 'habitacion-en-piso-compartido-en-madrid-65156ae2e55c2' LIMIT 1;

"COMMIT"

"COMMIT";

INSERT INTO listing_views (
  listing_type, listing_id, total_visits,
  visit_date
)
VALUES
  (?, ?, ?, ?)

INSERT INTO listing_views (listing_type, listing_id, total_visits, visit_date) VALUES ('room', 188, NULL, '1781082197');

SELECT
  t0.id AS id_1,
  t0.user_name AS user_name_2,
  t0.image AS image_3,
  t0.relation AS relation_4,
  t0.country AS country_5,
  t0.city AS city_6,
  t0.trust_score AS trust_score_7,
  t0.is_checked AS is_checked_8,
  t0.office_direction AS office_direction_9,
  t0.user_id AS user_id_10
FROM
  land_lord t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_name AS user_name_2, t0.image AS image_3, t0.relation AS relation_4, t0.country AS country_5, t0.city AS city_6, t0.trust_score AS trust_score_7, t0.is_checked AS is_checked_8, t0.office_direction AS office_direction_9, t0.user_id AS user_id_10 FROM land_lord t0 WHERE t0.user_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.register_date AS register_date_5,
  t0.phone AS phone_6,
  t0.confirmed_mail AS confirmed_mail_7,
  t8.id AS id_9,
  t8.name AS name_10,
  t8.user_type_id AS user_type_id_11
FROM
  user t0
  LEFT JOIN user_type t8 ON t8.user_type_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.register_date AS register_date_5, t0.phone AS phone_6, t0.confirmed_mail AS confirmed_mail_7, t8.id AS id_9, t8.name AS name_10, t8.user_type_id AS user_type_id_11 FROM user t0 LEFT JOIN user_type t8 ON t8.user_type_id = t0.id WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.relation AS relation_2,
  t0.user_name AS user_name_3,
  t0.ocupation AS ocupation_4,
  t0.image AS image_5,
  t0.age AS age_6,
  t0.country AS country_7,
  t0.social_profile AS social_profile_8,
  t0.user_id AS user_id_9
FROM
  tennant t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.relation AS relation_2, t0.user_name AS user_name_3, t0.ocupation AS ocupation_4, t0.image AS image_5, t0.age AS age_6, t0.country AS country_7, t0.social_profile AS social_profile_8, t0.user_id AS user_id_9 FROM tennant t0 WHERE t0.user_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.val AS val_3
FROM
  config t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.val AS val_3 FROM config t0 WHERE t0.name = 'maps_api_key' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.listing_type AS listing_type_2,
  t0.conditions AS conditions_3
FROM
  rental_conditions t0
WHERE
  t0.listing_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.listing_type AS listing_type_2, t0.conditions AS conditions_3 FROM rental_conditions t0 WHERE t0.listing_type = 'room' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";