Query Metrics
35
Database Queries
5
Different statements
6.72 ms
Query time
0
Invalid entities
61
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.59 ms |
SELECT p0_.id AS id_0, p0_.company_name AS company_name_1, p0_.slug AS slug_2, p0_.legal_name AS legal_name_3, p0_.structure_type AS structure_type_4, p0_.siren AS siren_5, p0_.siret AS siret_6, p0_.naf_code AS naf_code_7, p0_.vat_number AS vat_number_8, p0_.address AS address_9, p0_.address_complement AS address_complement_10, p0_.postal_code AS postal_code_11, p0_.city AS city_12, p0_.country AS country_13, p0_.latitude AS latitude_14, p0_.longitude AS longitude_15, p0_.geohash AS geohash_16, p0_.phone_public AS phone_public_17, p0_.phone_private AS phone_private_18, p0_.website AS website_19, p0_.facebook_url AS facebook_url_20, p0_.instagram_url AS instagram_url_21, p0_.linkedin_url AS linkedin_url_22, p0_.short_description AS short_description_23, p0_.long_description AS long_description_24, p0_.logo AS logo_25, p0_.cover_image AS cover_image_26, p0_.signature_image AS signature_image_27, p0_.profile_status AS profile_status_28, p0_.verification_status AS verification_status_29, p0_.completion_score AS completion_score_30, p0_.average_rating AS average_rating_31, p0_.reviews_count AS reviews_count_32, p0_.response_time_minutes AS response_time_minutes_33, p0_.is_featured AS is_featured_34, p0_.featured_until AS featured_until_35, p0_.search_visibility AS search_visibility_36, p0_.verified_at AS verified_at_37, p0_.created_at AS created_at_38, p0_.updated_at AS updated_at_39, p0_.deleted_at AS deleted_at_40, p0_.description AS description_41, p0_.metier AS metier_42, p0_.experience AS experience_43, p0_.document_verification_status AS document_verification_status_44, p0_.company_last_verification_at AS company_last_verification_at_45, p0_.company_verification_source AS company_verification_source_46, p0_.company_verification_note AS company_verification_note_47, p0_.is_on_vacation AS is_on_vacation_48, p0_.vacation_return_date AS vacation_return_date_49, u1_.id AS id_50, u1_.email AS email_51, u1_.roles AS roles_52, u1_.password AS password_53, u1_.first_name AS first_name_54, u1_.last_name AS last_name_55, u1_.phone_number AS phone_number_56, u1_.phone_verified_at AS phone_verified_at_57, u1_.email_verified_at AS email_verified_at_58, u1_.is_verified AS is_verified_59, u1_.avatar AS avatar_60, u1_.locale AS locale_61, u1_.timezone AS timezone_62, u1_.status AS status_63, u1_.last_login_at AS last_login_at_64, u1_.login_count AS login_count_65, u1_.reset_token AS reset_token_66, u1_.reset_token_expires_at AS reset_token_expires_at_67, u1_.created_at AS created_at_68, u1_.updated_at AS updated_at_69, u1_.deleted_at AS deleted_at_70, u1_.notify_on_quote_request_received AS notify_on_quote_request_received_71, u1_.notify_on_message_received AS notify_on_message_received_72, u1_.notify_on_quote_request_accepted AS notify_on_quote_request_accepted_73, u1_.notify_on_review_received AS notify_on_review_received_74, p0_.user_id AS user_id_75 FROM prestataire_profile p0_ LEFT JOIN "user" u1_ ON p0_.user_id = u1_.id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 115 117 118 116 114 123 119 121 120 125 122 124 126 127 131 130 ]
|
||||||||||||||||||||||||||
| 2 | 0.24 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"127"
]
|
||||||||||||||||||||||||||
| 3 | 0.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"233"
]
|
||||||||||||||||||||||||||
| 4 | 0.14 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"130"
]
|
||||||||||||||||||||||||||
| 5 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"237"
]
|
||||||||||||||||||||||||||
| 6 | 0.12 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"131"
]
|
||||||||||||||||||||||||||
| 7 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"239"
]
|
||||||||||||||||||||||||||
| 8 | 0.11 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"121"
]
|
||||||||||||||||||||||||||
| 9 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"227"
]
|
||||||||||||||||||||||||||
| 10 | 0.11 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"114"
]
|
||||||||||||||||||||||||||
| 11 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"220"
]
|
||||||||||||||||||||||||||
| 12 | 0.12 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"115"
]
|
||||||||||||||||||||||||||
| 13 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"221"
]
|
||||||||||||||||||||||||||
| 14 | 0.11 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"116"
]
|
||||||||||||||||||||||||||
| 15 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"222"
]
|
||||||||||||||||||||||||||
| 16 | 0.11 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"117"
]
|
||||||||||||||||||||||||||
| 17 | 0.16 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"223"
]
|
||||||||||||||||||||||||||
| 18 | 0.18 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"118"
]
|
||||||||||||||||||||||||||
| 19 | 0.16 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"224"
]
|
||||||||||||||||||||||||||
| 20 | 0.14 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"119"
]
|
||||||||||||||||||||||||||
| 21 | 0.14 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"225"
]
|
||||||||||||||||||||||||||
| 22 | 0.12 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"120"
]
|
||||||||||||||||||||||||||
| 23 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"226"
]
|
||||||||||||||||||||||||||
| 24 | 0.12 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"122"
]
|
||||||||||||||||||||||||||
| 25 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"228"
]
|
||||||||||||||||||||||||||
| 26 | 0.15 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"123"
]
|
||||||||||||||||||||||||||
| 27 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"229"
]
|
||||||||||||||||||||||||||
| 28 | 0.11 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"124"
]
|
||||||||||||||||||||||||||
| 29 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"230"
]
|
||||||||||||||||||||||||||
| 30 | 0.12 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"125"
]
|
||||||||||||||||||||||||||
| 31 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"231"
]
|
||||||||||||||||||||||||||
| 32 | 0.11 ms |
SELECT t0.id AS id_1, t0.stripe_customer_id AS stripe_customer_id_2, t0.stripe_default_payment_method_id AS stripe_default_payment_method_id_3, t0.default_payment_method_type AS default_payment_method_type_4, t0.billing_email AS billing_email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.prestataire_profile_id AS prestataire_profile_id_8 FROM subscription_customer t0 WHERE t0.prestataire_profile_id = ?
Parameters:
[
"126"
]
|
||||||||||||||||||||||||||
| 33 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.company_name AS company_name_3, t0.siret AS siret_4, t0.billing_address AS billing_address_5, t0.billing_postal_code AS billing_postal_code_6, t0.billing_city AS billing_city_7, t0.billing_country AS billing_country_8, t0.default_address AS default_address_9, t0.default_postal_code AS default_postal_code_10, t0.default_city AS default_city_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.user_id AS user_id_16 FROM client_profile t0 WHERE t0.user_id = ?
Parameters:
[
"232"
]
|
||||||||||||||||||||||||||
| 34 | 0.44 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.icon AS icon_4, s0_.image AS image_5, s0_.position AS position_6, s0_.color AS color_7, s0_.seo_title AS seo_title_8, s0_.seo_description AS seo_description_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_active AS is_active_12, s0_.parent_id AS parent_id_13 FROM service_category s0_ WHERE s0_.parent_id IS NULL AND s0_.is_active = ? ORDER BY s0_.position ASC, s0_.name ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||
| 35 | 0.37 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.icon AS icon_4, s0_.image AS image_5, s0_.position AS position_6, s0_.color AS color_7, s0_.seo_title AS seo_title_8, s0_.seo_description AS seo_description_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_active AS is_active_12, s1_.id AS id_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.icon AS icon_17, s1_.image AS image_18, s1_.position AS position_19, s1_.color AS color_20, s1_.seo_title AS seo_title_21, s1_.seo_description AS seo_description_22, s1_.created_at AS created_at_23, s1_.updated_at AS updated_at_24, s1_.is_active AS is_active_25, s0_.parent_id AS parent_id_26, s1_.parent_id AS parent_id_27 FROM service_category s0_ LEFT JOIN service_category s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.is_active = ? AND (s1_.id IS NULL OR s1_.is_active = ?) ORDER BY s0_.position ASC, s1_.position ASC
Parameters:
[ 1 1 ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Prestataire\Entity\PrestataireProfile | 16 |
| App\Account\Entity\User | 16 |
| App\Catalog\Entity\ServiceCategory | 15 |
| App\Subscription\Entity\SubscriptionCustomer | 14 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Catalog\Entity\ServiceCategory | No errors. |
| App\Prestataire\Entity\PrestataireProfile | No errors. |
| App\Account\Entity\User | No errors. |
| App\Prestataire\Entity\PrestataireService | No errors. |
| App\Prestataire\Entity\PrestataireInterventionZone | No errors. |
| App\Prestataire\Entity\PrestataireAppointment | No errors. |
| App\Quote\Entity\QuoteRequest | No errors. |
| App\Prestataire\Entity\PrestataireDocument | No errors. |
| App\Subscription\Entity\SubscriptionCustomer | No errors. |
| App\Subscription\Entity\PrestataireSubscription | No errors. |
| App\Subscription\Entity\SubscriptionCreditMovement | No errors. |
| App\Prestataire\Entity\PrestataireAvailability | No errors. |
| App\Review\Entity\Favorite | No errors. |
| App\Account\Entity\ClientProfile | No errors. |
| App\Messaging\Entity\Notification | No errors. |
| App\Catalog\Entity\Service | No errors. |