http://admin.puzzlebooking.com/api/agency-notifications Return to referer URL

Query Metrics

5 Database Queries
4 Different statements
7.11 ms Query time
10 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.06 ms
(43.01%)
1
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, t0.status AS status_7, t0.type AS type_8, t0.phone AS phone_9, t0.address AS address_10, t0.api_token AS api_token_11, t0.last_login_date AS last_login_date_12, t0.puzzle_code AS puzzle_code_13, t0.deleted_at AS deleted_at_14, t0.agency_id AS agency_id_15, t0.lighting_contract_id AS lighting_contract_id_16, t0.consent_contract_id AS consent_contract_id_17, t0.register_message_contract_id AS register_message_contract_id_18, t0.register_phone_contract_id AS register_phone_contract_id_19, t0.register_email_contract_id AS register_email_contract_id_20 FROM user t0 WHERE t0.api_token = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "R1JVUCBBTktBOjE3MjA1OTg2MTc="
]
2.09 ms
(29.45%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo_white AS logo_white_3, t0.logo AS logo_4, t0.is_edit AS is_edit_5, t0.mail_logo AS mail_logo_6, t0.mail_logo_background AS mail_logo_background_7, t0.site_address AS site_address_8, t0.phone AS phone_9, t0.mail AS mail_10, t0.address AS address_11, t0.panel_site_address AS panel_site_address_12, t0.language AS language_13, t0.is_domestic_hotel AS is_domestic_hotel_14, t0.is_abroad_hotel AS is_abroad_hotel_15, t0.is_cyprus_hotel AS is_cyprus_hotel_16, t0.is_domestic_tour AS is_domestic_tour_17, t0.is_abroad_tour AS is_abroad_tour_18, t0.is_domestic_flight AS is_domestic_flight_19, t0.is_abroad_flight AS is_abroad_flight_20, t0.is_domestic_transfer AS is_domestic_transfer_21, t0.is_abroad_transfer AS is_abroad_transfer_22, t0.noreply_mail AS noreply_mail_23, t0.user_id AS user_id_24 FROM sites t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "PUZZLEBOOKING"
]
1.03 ms
(14.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.puzzle_code AS puzzle_code_4, t0.fax AS fax_5, t0.phone AS phone_6, t0.address AS address_7, t0.payment_type AS payment_type_8, t0.email AS email_9, t0.vat_office AS vat_office_10, t0.vat_number AS vat_number_11, t0.document_voucher AS document_voucher_12, t0.credit_amount AS credit_amount_13, t0.credit_cur AS credit_cur_14, t0.agency_rate AS agency_rate_15, t0.agency_package_tour_program_rate AS agency_package_tour_program_rate_16, t0.deleted_at AS deleted_at_17, t0.site_id AS site_id_18 FROM agency t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  83
]
0.93 ms
(13.09%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.reservation_id AS reservation_id_4, t0.agency_id AS agency_id_5 FROM notification_agency t0 WHERE t0.agency_id = ? ORDER BY t0.status DESC, t0.id DESC
Parameters:
[
  83
]

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
  • The association App\Entity\User#puzzleForwardingLogs refers to the owning side field App\Entity\PuzzleForwardingLogs#user which does not exist.
App\Entity\Agency No errors.
App\Entity\Contract No errors.
App\Entity\SearchLogHotel
  • The mappings App\Entity\SearchLogHotel#hotel_destination and App\Entity\HotelDestination#searchLogHotels are inconsistent with each other.
App\Entity\Reservation
  • The mappings App\Entity\Reservation#reservationInvoices and App\Entity\ReservationInvoice#reservation are inconsistent with each other.
  • The association App\Entity\Reservation#currencyRate refers to the inverse side field App\Entity\CurrencyRate#reservation which does not exist.
  • The association App\Entity\Reservation#reservationDayPrices refers to the owning side field App\Entity\ReservationDayPrice#reservation which does not exist.
App\Entity\PuzzleForwardingLogs No errors.
App\Entity\Refund No errors.
App\Entity\Sites No errors.
App\Entity\Hotel
  • The field App\Entity\Hotel#hotelHotelCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HotelHotelCategory#hotel does not contain the required 'inversedBy="hotelHotelCategories"' attribute.
  • The association App\Entity\Hotel#hotel_concept refers to the owning side field App\Entity\HotelConcept#hotel which does not exist.
App\Entity\Tour
  • The field App\Entity\Tour#seoPage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SeoPage#tour does not contain the required 'inversedBy="seoPage"' attribute.
  • The mappings App\Entity\Tour#firstFlightDeparture and App\Entity\Airport#tourPrices are inconsistent with each other.
  • The mappings App\Entity\Tour#endFlightAirline and App\Entity\Airline#tourPrices are inconsistent with each other.
  • The mappings App\Entity\Tour#endFlightOrigin and App\Entity\Airport#tourPrices are inconsistent with each other.
  • The mappings App\Entity\Tour#endFlightDeparture and App\Entity\Airport#tourPrices are inconsistent with each other.
  • The mappings App\Entity\Tour#defaultCategory and App\Entity\TourCategory#toursDefault are inconsistent with each other.
  • The field App\Entity\Tour#tourTourCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TourTourCategory#tour does not contain the required 'inversedBy="tourTourCategories"' attribute.
App\Entity\HotelDestination
  • The association App\Entity\HotelDestination#searchLogHotels refers to the owning side field App\Entity\SearchLogHotel#destination which does not exist.
  • The association App\Entity\HotelDestination#seoPages refers to the owning side field App\Entity\SeoPage#hotelDestination which does not exist.
  • The association App\Entity\HotelDestination#prePaymentCampaigns refers to the owning side field App\Entity\PrePaymentCampaign#HotelDestination which does not exist.
App\Entity\TourDestination
  • The field App\Entity\TourDestination#seoPage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SeoPage#tour_destination does not contain the required 'inversedBy="seoPage"' attribute.
  • The association App\Entity\TourDestination#hotelMinuteDeals refers to the owning side field App\Entity\HotelMinuteDeals#tourDestination which does not exist.
  • The association App\Entity\TourDestination#searchSuggestions refers to the owning side field App\Entity\SearchSuggestion#tourDestination which does not exist.
App\Entity\Landmarks No errors.
App\Entity\BankAccount No errors.
App\Entity\SeoMenuCategory No errors.
App\Entity\LogoAccountingCode No errors.
App\Entity\HotelMinuteDeals No errors.
App\Entity\PrePaymentCampaign
  • The mappings App\Entity\PrePaymentCampaign#hotelDestination and App\Entity\HotelDestination#prePaymentCampaigns are inconsistent with each other.
App\Entity\MarketingCampaign
  • The association App\Entity\MarketingCampaign#campaignsTours refers to the inverse side field App\Entity\Tour#marketingCampaigns which does not exist.
App\Entity\PaymentPartialSetting No errors.
App\Entity\PackageProfit No errors.
App\Entity\SearchSuggestion No errors.
App\Entity\BannerArea No errors.
App\Entity\Request No errors.
App\Entity\SeoPageSites No errors.
App\Entity\HotelSite No errors.
App\Entity\TourSite No errors.
App\Entity\HotelDestinationSite No errors.
App\Entity\HotelCategorySite No errors.
App\Entity\TourDestinationSite No errors.
App\Entity\PosInstallment No errors.
App\Entity\Discount No errors.
App\Entity\Image
  • The mappings App\Entity\Image#coverImageHotelCategory and App\Entity\HotelCategory#images are inconsistent with each other.
App\Entity\AgencyProduct No errors.
App\Entity\NotificationAgency No errors.