https://318-iss-ctr-and-showmore.review.mechanic.works/profile_ctr/increase-shows/ Return to referer URL

Query Metrics

10 Database Queries
6 Different statements
4.82 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
0.89 ms
(18.43%)
2
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.87 ms
(18.11%)
2
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.85 ms
(17.67%)
2
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.80 ms
(16.53%)
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_.is_approved AS is_approved_9, p0_.moderation_status AS moderation_status_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.inactivated_at AS inactivated_at_13, p0_.seo AS seo_14, p0_.deleted_at AS deleted_at_15, p0_.person_gender AS person_gender_16, p0_.person_age AS person_age_17, p0_.person_height AS person_height_18, p0_.person_weight AS person_weight_19, p0_.person_breast_size AS person_breast_size_20, p0_.person_breast_type AS person_breast_type_21, p0_.person_cloth_size AS person_cloth_size_22, p0_.person_shoes_size AS person_shoes_size_23, p0_.person_body_type AS person_body_type_24, p0_.person_hair_color AS person_hair_color_25, p0_.person_private_haircut AS person_private_haircut_26, p0_.person_nationality AS person_nationality_27, p0_.person_has_tattoo AS person_has_tattoo_28, p0_.person_has_piercing AS person_has_piercing_29, p0_.messengers_telegram AS messengers_telegram_30, p0_.messengers_whatsapp AS messengers_whatsapp_31, p0_.call_time_from AS call_time_from_32, p0_.call_time_to AS call_time_to_33, p0_.call_answering_to AS call_answering_to_34, p0_.client_min_age AS client_min_age_35, p0_.client_max_age AS client_max_age_36, p0_.apartments_one_hour_price AS apartments_one_hour_price_37, p0_.apartments_two_hours_price AS apartments_two_hours_price_38, p0_.apartments_night_price AS apartments_night_price_39, p0_.take_out_one_hour_price AS take_out_one_hour_price_40, p0_.take_out_two_hours_price AS take_out_two_hours_price_41, p0_.take_out_night_price AS take_out_night_price_42, p0_.take_out_locations AS take_out_locations_43, p0_.express_provided AS express_provided_44, p0_.express_price AS express_price_45, p0_.car_provided AS car_provided_46, p0_.map_latitude AS map_latitude_47, p0_.map_longitude AS map_longitude_48, p0_.user_id AS user_id_49, p0_.city_id AS city_id_50 FROM profiles p0_ WHERE (p0_.id IN (?, ?)) AND (p0_.deleted_at IS NULL) ORDER BY FIELD(p0_.id, ?, ?) ASC
Parameters:
[
  "1"
  "2"
  "1"
  "2"
]
0.72 ms
(14.87%)
2
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
]
0.69 ms
(14.39%)
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/"
]

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\SEO\PageMetadata 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\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\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\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\User No errors.
App\Entity\Account\Advertiser 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.
App\Entity\Location\Station No errors.

multi_website entity manager

No loaded entities.