2.70 ms (25.73%)
|
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.nb_entite AS nb_entite_2, p0_.nb_user AS nb_user_3, p0_.count_manager AS count_manager_4, p0_.price AS price_5, p0_.state AS state_6, p0_.delail_by_mounth AS delail_by_mounth_7, p0_.stripe_price AS stripe_price_8, p0_.max_duplications_per_month AS max_duplications_per_month_9, p0_.description AS description_10, p0_.option1 AS option1_11, p0_.option2 AS option2_12, p0_.option3 AS option3_13, p0_.option4 AS option4_14, p0_.option5 AS option5_15, p0_.option6 AS option6_16, p0_.option7 AS option7_17, p0_.option8 AS option8_18, p0_.option9 AS option9_19, p0_.option10 AS option10_20, p0_.uuid AS uuid_21, p0_.updated_at AS updated_at_22, p0_.created_at AS created_at_23 FROM packaging p0_ WHERE p0_.state = ? AND p0_.delail_by_mounth = ? ORDER BY p0_.price ASC
Parameters: [
"active"
1
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.nb_entite AS nb_entite_2, p0_.nb_user AS nb_user_3, p0_.count_manager AS count_manager_4, p0_.price AS price_5, p0_.state AS state_6, p0_.delail_by_mounth AS delail_by_mounth_7, p0_.stripe_price AS stripe_price_8, p0_.max_duplications_per_month AS max_duplications_per_month_9, p0_.description AS description_10, p0_.option1 AS option1_11, p0_.option2 AS option2_12, p0_.option3 AS option3_13, p0_.option4 AS option4_14, p0_.option5 AS option5_15, p0_.option6 AS option6_16, p0_.option7 AS option7_17, p0_.option8 AS option8_18, p0_.option9 AS option9_19, p0_.option10 AS option10_20, p0_.uuid AS uuid_21, p0_.updated_at AS updated_at_22, p0_.created_at AS created_at_23 FROM packaging p0_ WHERE p0_.state = 'active' AND p0_.delail_by_mounth = 1 ORDER BY p0_.price ASC;
|
2.70 ms (25.72%)
|
7 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1
Parameters: [
"manager"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;
|
1.99 ms (18.96%)
|
2 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;
|
1.61 ms (15.36%)
|
2 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;
|
1.07 ms (10.19%)
|
1 |
SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 50
SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = 1 ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 50;
|
0.42 ms (4.04%)
|
1 |
SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 5
SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = 1 ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 5;
|