https://352-iss-fix-safe-zone-iphone.review.mechanic.works/profile_ctr/increase-shows/ Return to referer URL

Query Metrics

6 Database Queries
6 Different statements
3.96 ms Query time
8 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

default connection

Time Count Info
1.13 ms
(28.46%)
1
SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1
Parameters:
[
  "/profile_ctr/increase-shows/"
]
0.97 ms
(24.42%)
1
SELECT p0_.id AS id_0, p0_.is_dummy AS is_dummy_1, p0_.uri_identity AS uri_identity_2, p0_.name AS name_3, p0_.description AS description_4, p0_.client_types AS client_types_5, p0_.phone_number AS phone_number_6, p0_.is_masseur AS is_masseur_7, p0_.extra_charge AS extra_charge_8, p0_.prepayment AS prepayment_9, p0_.prepayment_amount AS prepayment_amount_10, p0_.prepayment_comment AS prepayment_comment_11, p0_.is_approved AS is_approved_12, p0_.moderation_status AS moderation_status_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.inactivated_at AS inactivated_at_16, p0_.seo AS seo_17, p0_.delete_mode AS delete_mode_18, p0_.deleted_at AS deleted_at_19, p0_.person_gender AS person_gender_20, p0_.person_age AS person_age_21, p0_.person_height AS person_height_22, p0_.person_weight AS person_weight_23, p0_.person_breast_size AS person_breast_size_24, p0_.person_breast_type AS person_breast_type_25, p0_.person_cloth_size AS person_cloth_size_26, p0_.person_shoes_size AS person_shoes_size_27, p0_.person_body_type AS person_body_type_28, p0_.person_hair_color AS person_hair_color_29, p0_.person_private_haircut AS person_private_haircut_30, p0_.person_nationality AS person_nationality_31, p0_.person_has_tattoo AS person_has_tattoo_32, p0_.person_has_piercing AS person_has_piercing_33, p0_.messengers_telegram AS messengers_telegram_34, p0_.messengers_whatsapp AS messengers_whatsapp_35, p0_.messengers_telegram_username AS messengers_telegram_username_36, p0_.call_time_from AS call_time_from_37, p0_.call_time_to AS call_time_to_38, p0_.call_answering_to AS call_answering_to_39, p0_.client_min_age AS client_min_age_40, p0_.client_max_age AS client_max_age_41, p0_.apartments_one_hour_price AS apartments_one_hour_price_42, p0_.apartments_two_hours_price AS apartments_two_hours_price_43, p0_.apartments_night_price AS apartments_night_price_44, p0_.take_out_one_hour_price AS take_out_one_hour_price_45, p0_.take_out_two_hours_price AS take_out_two_hours_price_46, p0_.take_out_night_price AS take_out_night_price_47, p0_.take_out_locations AS take_out_locations_48, p0_.express_provided AS express_provided_49, p0_.express_price AS express_price_50, p0_.car_provided AS car_provided_51, p0_.map_latitude AS map_latitude_52, p0_.map_longitude AS map_longitude_53, p0_.user_id AS user_id_54, p0_.city_id AS city_id_55, p0_.primary_station_id AS primary_station_id_56 FROM profiles p0_ WHERE (p0_.id IN (?)) AND (p0_.deleted_at IS NULL) ORDER BY FIELD(p0_.id, ?) ASC
Parameters:
[
  "1"
  "1"
]
0.51 ms
(12.84%)
1
SELECT t0.type AS type_1, t0.position_group AS position_group_2, t0.position AS position_3, t0.placed_at AS placed_at_4, t0.placed_until AS placed_until_5, t0.profile_id AS profile_id_6, t0.placement_price_id AS placement_price_id_7 FROM profile_adboard_placements t0 WHERE t0.profile_id = ?
Parameters:
[
  1
]
0.48 ms
(12.15%)
1
SELECT t0.id AS id_1, t0.placed_at AS placed_at_2, t0.placed_until AS placed_until_3, t0.profile_id AS profile_id_4, t0.entity_type FROM placement_hidings t0 WHERE t0.profile_id = ? AND t0.entity_type IN ('profile')
Parameters:
[
  1
]
0.45 ms
(11.38%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('adm_apr_ph')
Parameters:
[
  1
]
0.43 ms
(10.75%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('avatar')
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection
multi_website doctrine.dbal.multi_website_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
multi_website doctrine.orm.multi_website_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Sales\Profile\AdBoardPlacement No errors.
App\Entity\Sales\PaidPlacementPrice
  • The field 'App\Entity\Sales\PaidPlacementPrice#priceAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Profile\PersonParameters No errors.
App\Entity\Messengers
  • The field 'App\Entity\Messengers#whatsApp' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\PhoneCallRestrictions No errors.
App\Entity\Profile\ClientRestrictions No errors.
App\Entity\ApartmentsPricing No errors.
App\Entity\TakeOutPricing No errors.
App\Entity\ExpressPricing No errors.
App\Entity\Profile\CarPricing No errors.
App\Entity\Location\MapCoordinate
  • The field 'App\Entity\Location\MapCoordinate#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Location\MapCoordinate#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Profile\Profile
  • The field 'App\Entity\Profile\Profile#messengers.whatsApp' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Profile\Profile#mapCoordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Profile\Profile#mapCoordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\Profile\Profile#placementHiding is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sales\Profile\PlacementHiding#profile does not contain the required 'inversedBy="placementHiding"' attribute.
  • The field App\Entity\Profile\Profile#providedServices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\ProfileService#profile does not contain the required 'inversedBy="providedServices"' attribute.
  • The mappings App\Entity\Profile\Profile#selfies and App\Entity\Profile\Selfie#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#videos and App\Entity\Profile\Video#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#adminApprovalPhoto and App\Entity\Profile\AdminApprovalPhoto#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#avatar and App\Entity\Profile\Avatar#profile are inconsistent with each other.
App\Entity\SEO\PageMetadata No errors.
App\Entity\Location\City
  • The field 'App\Entity\Location\City#mapCoordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Location\City#mapCoordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Sales\PaidPlacementsOrder No errors.
App\Entity\User No errors.
App\Entity\Account\Advertiser No errors.
App\Entity\Location\Station No errors.
App\Entity\Sales\Profile\TopPlacement No errors.
App\Entity\Sales\PlacementHiding No errors.
App\Entity\Sales\Profile\PlacementHiding No errors.
App\Entity\Profile\ProfileService No errors.
App\Entity\Profile\Photo No errors.
App\Entity\Profile\Selfie No errors.
App\Entity\Profile\Video No errors.
App\Entity\Profile\FileProcessingTask No errors.
App\Entity\Profile\AdminApprovalPhoto No errors.
App\Entity\Profile\Confirmation\ConfirmationRequest
  • The mappings App\Entity\Profile\Confirmation\ConfirmationRequest#videos and App\Entity\Profile\Confirmation\Video#confirmationRequest are inconsistent with each other.
App\Entity\Profile\Confirmation\ModerationRequest
  • The mappings App\Entity\Profile\Confirmation\ModerationRequest#videos and App\Entity\Profile\Confirmation\Video#confirmationRequest are inconsistent with each other.
App\Entity\Profile\Avatar No errors.
App\Entity\Profile\Comment\Comment No errors.
App\Entity\Profile\Comment\CommentByCustomer
  • The field App\Entity\Profile\Comment\CommentByCustomer#comments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\Comment\Comment#parent does not contain the required 'inversedBy="comments"' attribute.

multi_website entity manager

No loaded entities.