GET http://misolus.com/org/impt

Query Metrics

9 Database Queries
9 Different statements
28.59 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.46 ms
(29.59%)
1
SELECT t0.id AS id_1, t0.source_route AS source_route_2, t0.target_route AS target_route_3, t0.creation_date AS creation_date_4 FROM redirections t0 WHERE t0.source_route = ? LIMIT 1
Parameters:
[
  "/org/impt"
]
8.42 ms
(29.45%)
1
"COMMIT"
Parameters:
[]
2.49 ms
(8.70%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM sector t0 WHERE t0.id = ?
Parameters:
[
  12
]
2.25 ms
(7.87%)
1
UPDATE organization SET visits_count = ? WHERE id = ?
Parameters:
[
  106
  226
]
1.77 ms
(6.18%)
1
"START TRANSACTION"
Parameters:
[]
1.66 ms
(5.81%)
1
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.title AS title_3, t0.creation_date AS creation_date_4, t0.status AS status_5, t0.description AS description_6, t0.price AS price_7, t0.promo_price AS promo_price_8, t0.video_url AS video_url_9, t0.youtube_id AS youtube_id_10, t0.is_video AS is_video_11, t0.org_id AS org_id_12 FROM post t0 WHERE t0.org_id = ?
Parameters:
[
  226
]
1.47 ms
(5.15%)
1
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.refrer_code AS refrer_code_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.visits_count AS visits_count_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.subscription_status AS subscription_status_13, t0.email AS email_14, t0.gain AS gain_15, t0.total_members AS total_members_16, t0.monetizing_enabled AS monetizing_enabled_17, t0.auto_link_clients_enabled AS auto_link_clients_enabled_18, t0.description AS description_19, t0.password AS password_20, t0.subscribers_count AS subscribers_count_21, t0.type AS type_22, t0.address AS address_23, t0.phone AS phone_24, t0.whatsapp_phone AS whatsapp_phone_25, t0.is_enabled AS is_enabled_26, t0.can_create_coupon AS can_create_coupon_27, t0.can_receive_partnership_request AS can_receive_partnership_request_28, t0.website_link AS website_link_29, t0.can_receive_agreements AS can_receive_agreements_30, t0.can_send_agreements AS can_send_agreements_31, t0.slug AS slug_32, t0.devis_enabled AS devis_enabled_33, t0.is_managed_in_house AS is_managed_in_house_34, t0.is_slug_manuel AS is_slug_manuel_35, t0.use_calendar AS use_calendar_36, t0.params AS params_37, t0.sector_id AS sector_id_38, t0.city_id AS city_id_39, t0.subscription_id AS subscription_id_40 FROM organization t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "impt"
]
1.05 ms
(3.67%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM city t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.02 ms
(3.59%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.creation_date AS creation_date_3, t0.name AS name_4, t0.devis_message_id AS devis_message_id_5, t0.org_id AS org_id_6 FROM media t0 WHERE t0.org_id = ?
Parameters:
[
  226
]

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\Redirection No errors.
App\Entity\Organization No errors.
App\Entity\Sector
  • The association App\Entity\Sector#companies refers to the owning side field App\Entity\User#sector which does not exist.
App\Entity\City
  • The mappings App\Entity\City#offer and App\Entity\Offer#cities are inconsistent with each other.
App\Entity\Subscription
  • The association App\Entity\Subscription#packs refers to the owning side field App\Entity\Pack#subscription which does not exist.
App\Entity\UserOrganization No errors.
App\Entity\Payment No errors.
App\Entity\Model No errors.
App\Entity\User
  • The association App\Entity\User#getReceivedMessages refers to the owning side field App\Entity\Message#toUser which does not exist.
App\Entity\Notification No errors.
App\Entity\Blocking No errors.
App\Entity\Post No errors.
App\Entity\Devis
  • The association App\Entity\Devis#fromOrg refers to the inverse side field App\Entity\Organization#sentDevis which does not exist.
App\Entity\Media
  • The association App\Entity\Media#devisMessage refers to the inverse side field App\Entity\DevisMessage#media which does not exist.
App\Entity\ConParticipant No errors.
App\Entity\AgOption No errors.
App\Entity\AgEvent No errors.
App\Entity\MClient No errors.
App\Entity\Offer
  • The association App\Entity\Offer#cities refers to the inverse side field App\Entity\City#offers which does not exist.
  • The field App\Entity\Offer#offerOrgs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\OfferOrg#offer does not contain the required 'inversedBy="offerOrgs"' attribute.
App\Entity\DevisMessage
  • The mappings App\Entity\DevisMessage#medias and App\Entity\Media#devisMessage are inconsistent with each other.