| 1 |
0.42 ms |
SET TIME ZONE 'UTC'
SET TIME ZONE 'UTC';
|
| 2 |
4.88 ms |
SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4, o0_.status AS status_5, o0_.dns_ready AS dns_ready_6, o0_.status_detail AS status_detail_7, o0_.verification_token AS verification_token_8, o0_.status_changed_at AS status_changed_at_9 FROM organization_domains o0_ WHERE o0_.domain = ?
Parameters: [
"ofiladdict.tokii.fr"
]
SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4, o0_.status AS status_5, o0_.dns_ready AS dns_ready_6, o0_.status_detail AS status_detail_7, o0_.verification_token AS verification_token_8, o0_.status_changed_at AS status_changed_at_9 FROM organization_domains o0_ WHERE o0_.domain = 'ofiladdict.tokii.fr';
|
| 3 |
3.10 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.hashed_password AS hashed_password_3, t0.display_name AS display_name_4, t0.roles AS roles_5, t0.avatar_url AS avatar_url_6, t0.status AS status_7, t0.custom_status_text AS custom_status_text_8, t0.last_seen_at AS last_seen_at_9, t0.created_at AS created_at_10, t0.is_email_verified AS is_email_verified_11, t0.email_verification_token AS email_verification_token_12, t0.email_verification_token_expires_at AS email_verification_token_expires_at_13, t0.account_type AS account_type_14, t0.description AS description_15, t0.organization_category AS organization_category_16, t0.featured_channel_id AS featured_channel_id_17, t0.contact_email AS contact_email_18, t0.website_url AS website_url_19, t0.phone_number AS phone_number_20, t0.postal_address AS postal_address_21, t0.group_visibility AS group_visibility_22, t0.timezone AS timezone_23, t0.accepts_membership_requests AS accepts_membership_requests_24, t0.tutorial_completed AS tutorial_completed_25, t0.archived_at AS archived_at_26, t0.subdomain AS subdomain_27, t0.home_subdomain AS home_subdomain_28, t0.deleted_at AS deleted_at_29, t0.white_label_config AS white_label_config_30 FROM users t0 WHERE t0.id = ?
Parameters: [
"01a154cc-beb0-72dd-8312-040cb8716c73"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.hashed_password AS hashed_password_3, t0.display_name AS display_name_4, t0.roles AS roles_5, t0.avatar_url AS avatar_url_6, t0.status AS status_7, t0.custom_status_text AS custom_status_text_8, t0.last_seen_at AS last_seen_at_9, t0.created_at AS created_at_10, t0.is_email_verified AS is_email_verified_11, t0.email_verification_token AS email_verification_token_12, t0.email_verification_token_expires_at AS email_verification_token_expires_at_13, t0.account_type AS account_type_14, t0.description AS description_15, t0.organization_category AS organization_category_16, t0.featured_channel_id AS featured_channel_id_17, t0.contact_email AS contact_email_18, t0.website_url AS website_url_19, t0.phone_number AS phone_number_20, t0.postal_address AS postal_address_21, t0.group_visibility AS group_visibility_22, t0.timezone AS timezone_23, t0.accepts_membership_requests AS accepts_membership_requests_24, t0.tutorial_completed AS tutorial_completed_25, t0.archived_at AS archived_at_26, t0.subdomain AS subdomain_27, t0.home_subdomain AS home_subdomain_28, t0.deleted_at AS deleted_at_29, t0.white_label_config AS white_label_config_30 FROM users t0 WHERE t0.id = '01a154cc-beb0-72dd-8312-040cb8716c73';
|
| 4 |
0.85 ms |
SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4, o0_.status AS status_5, o0_.dns_ready AS dns_ready_6, o0_.status_detail AS status_detail_7, o0_.verification_token AS verification_token_8, o0_.status_changed_at AS status_changed_at_9 FROM organization_domains o0_ WHERE o0_.domain = ?
Parameters: [
"ofiladdict.tokii.fr"
]
SELECT o0_.id AS id_0, o0_.organization_id AS organization_id_1, o0_.domain AS domain_2, o0_.verified AS verified_3, o0_.created_at AS created_at_4, o0_.status AS status_5, o0_.dns_ready AS dns_ready_6, o0_.status_detail AS status_detail_7, o0_.verification_token AS verification_token_8, o0_.status_changed_at AS status_changed_at_9 FROM organization_domains o0_ WHERE o0_.domain = 'ofiladdict.tokii.fr';
|
| 5 |
2.34 ms |
SELECT COUNT(m0_.id) AS sclr_0 FROM memberships m0_ WHERE m0_.container_id = ?
Parameters: [
"01a154cc-beb0-72dd-8312-040cb8716c73"
]
SELECT COUNT(m0_.id) AS sclr_0 FROM memberships m0_ WHERE m0_.container_id = '01a154cc-beb0-72dd-8312-040cb8716c73';
|
| 6 |
1.25 ms |
SELECT page_id FROM page_builder_homepages WHERE owner_id = ?
Parameters: [
"01a154cc-beb0-72dd-8312-040cb8716c73"
]
SELECT page_id FROM page_builder_homepages WHERE owner_id = '01a154cc-beb0-72dd-8312-040cb8716c73';
|
| 7 |
2.05 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.owner_type AS owner_type_4, t0.owner_id AS owner_id_5, t0.status AS status_6, t0.visibility AS visibility_7, t0.document AS document_8, t0.published_document AS published_document_9, t0.seo AS seo_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.published_at AS published_at_14 FROM page_builder_pages t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"ofiladdict"
]
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.owner_type AS owner_type_4, t0.owner_id AS owner_id_5, t0.status AS status_6, t0.visibility AS visibility_7, t0.document AS document_8, t0.published_document AS published_document_9, t0.seo AS seo_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.published_at AS published_at_14 FROM page_builder_pages t0 WHERE t0.slug = 'ofiladdict' LIMIT 1;
|
| 8 |
0.98 ms |
SELECT kind, page_id FROM page_builder_legal_pages WHERE owner_id = ?
Parameters: [
"01a154cc-beb0-72dd-8312-040cb8716c73"
]
SELECT kind, page_id FROM page_builder_legal_pages WHERE owner_id = '01a154cc-beb0-72dd-8312-040cb8716c73';
|
| 9 |
4.03 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.owner_type AS owner_type_4, t0.owner_id AS owner_id_5, t0.status AS status_6, t0.visibility AS visibility_7, t0.document AS document_8, t0.published_document AS published_document_9, t0.seo AS seo_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.published_at AS published_at_14 FROM page_builder_pages t0 WHERE t0.owner_type = ? AND t0.owner_id = ? ORDER BY t0.updated_at DESC
Parameters: [
"organization"
"01a154cc-beb0-72dd-8312-040cb8716c73"
]
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.owner_type AS owner_type_4, t0.owner_id AS owner_id_5, t0.status AS status_6, t0.visibility AS visibility_7, t0.document AS document_8, t0.published_document AS published_document_9, t0.seo AS seo_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.published_at AS published_at_14 FROM page_builder_pages t0 WHERE t0.owner_type = 'organization' AND t0.owner_id = '01a154cc-beb0-72dd-8312-040cb8716c73' ORDER BY t0.updated_at DESC;
|
| 10 |
0.84 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.owner_type AS owner_type_4, t0.owner_id AS owner_id_5, t0.status AS status_6, t0.visibility AS visibility_7, t0.document AS document_8, t0.published_document AS published_document_9, t0.seo AS seo_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.published_at AS published_at_14 FROM page_builder_pages t0 WHERE t0.owner_type = ? AND t0.owner_id = ? ORDER BY t0.updated_at DESC
Parameters: [
"group"
"01a154cc-beb0-72dd-8312-040cb8716c73"
]
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.owner_type AS owner_type_4, t0.owner_id AS owner_id_5, t0.status AS status_6, t0.visibility AS visibility_7, t0.document AS document_8, t0.published_document AS published_document_9, t0.seo AS seo_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.published_at AS published_at_14 FROM page_builder_pages t0 WHERE t0.owner_type = 'group' AND t0.owner_id = '01a154cc-beb0-72dd-8312-040cb8716c73' ORDER BY t0.updated_at DESC;
|
| 11 |
5.63 ms |
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.theme_id AS theme_id_4, t0.overrides AS overrides_5, t0.custom_css AS custom_css_6, t0.text_styles AS text_styles_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM theme_assignments t0 WHERE t0.owner_type = ? AND t0.owner_id = ? LIMIT 1
Parameters: [
"page"
"01a154d0-2c7e-7ec7-b094-bd77f7c864c3"
]
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.theme_id AS theme_id_4, t0.overrides AS overrides_5, t0.custom_css AS custom_css_6, t0.text_styles AS text_styles_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM theme_assignments t0 WHERE t0.owner_type = 'page' AND t0.owner_id = '01a154d0-2c7e-7ec7-b094-bd77f7c864c3' LIMIT 1;
|
| 12 |
0.78 ms |
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.theme_id AS theme_id_4, t0.overrides AS overrides_5, t0.custom_css AS custom_css_6, t0.text_styles AS text_styles_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM theme_assignments t0 WHERE t0.owner_type = ? AND t0.owner_id = ? LIMIT 1
Parameters: [
"page"
"01a154d0-2c7e-7ec7-b094-bd77f7c864c3"
]
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.theme_id AS theme_id_4, t0.overrides AS overrides_5, t0.custom_css AS custom_css_6, t0.text_styles AS text_styles_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM theme_assignments t0 WHERE t0.owner_type = 'page' AND t0.owner_id = '01a154d0-2c7e-7ec7-b094-bd77f7c864c3' LIMIT 1;
|
| 13 |
1.84 ms |
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.header AS header_4, t0.footer AS footer_5, t0.updated_at AS updated_at_6 FROM page_builder_site_chrome t0 WHERE t0.owner_type = ? AND t0.owner_id = ? LIMIT 1
Parameters: [
"organization"
"01a154cc-beb0-72dd-8312-040cb8716c73"
]
SELECT t0.id AS id_1, t0.owner_type AS owner_type_2, t0.owner_id AS owner_id_3, t0.header AS header_4, t0.footer AS footer_5, t0.updated_at AS updated_at_6 FROM page_builder_site_chrome t0 WHERE t0.owner_type = 'organization' AND t0.owner_id = '01a154cc-beb0-72dd-8312-040cb8716c73' LIMIT 1;
|
| 14 |
1.85 ms |
SELECT 1 FROM channels WHERE id = ? AND purpose = ? AND deleted_at IS NULL
Parameters: [
"01a154d0-2bf6-74d0-bc8c-897b35056e01"
"shop"
]
SELECT 1 FROM channels WHERE id = '01a154d0-2bf6-74d0-bc8c-897b35056e01' AND purpose = 'shop' AND deleted_at IS NULL;
|
| 15 |
2.26 ms |
SELECT t0.id AS id_1, t0.conversation_id AS conversation_id_2, t0.currency AS currency_3, t0.enabled AS enabled_4, t0.closed_message AS closed_message_5, t0.pickup_enabled AS pickup_enabled_6, t0.shipping_enabled AS shipping_enabled_7, t0.pickup_address AS pickup_address_8, t0.pickup_instructions AS pickup_instructions_9, t0.flat_shipping_cents AS flat_shipping_cents_10, t0.free_shipping_threshold_cents AS free_shipping_threshold_cents_11, t0.packaging_grams AS packaging_grams_12, t0.default_item_grams AS default_item_grams_13, t0.pickup_lead_time AS pickup_lead_time_14, t0.shipping_lead_time AS shipping_lead_time_15, t0.return_instructions AS return_instructions_16, t0.default_low_stock_threshold AS default_low_stock_threshold_17, t0.abandoned_carts_enabled AS abandoned_carts_enabled_18, t0.abandoned_cart_first_delay_hours AS abandoned_cart_first_delay_hours_19, t0.abandoned_cart_second_delay_hours AS abandoned_cart_second_delay_hours_20, t0.abandoned_cart_discount_bps AS abandoned_cart_discount_bps_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23 FROM shop_shops t0 WHERE t0.conversation_id = ? LIMIT 1
Parameters: [
"01a154d0-2bf6-74d0-bc8c-897b35056e01"
]
SELECT t0.id AS id_1, t0.conversation_id AS conversation_id_2, t0.currency AS currency_3, t0.enabled AS enabled_4, t0.closed_message AS closed_message_5, t0.pickup_enabled AS pickup_enabled_6, t0.shipping_enabled AS shipping_enabled_7, t0.pickup_address AS pickup_address_8, t0.pickup_instructions AS pickup_instructions_9, t0.flat_shipping_cents AS flat_shipping_cents_10, t0.free_shipping_threshold_cents AS free_shipping_threshold_cents_11, t0.packaging_grams AS packaging_grams_12, t0.default_item_grams AS default_item_grams_13, t0.pickup_lead_time AS pickup_lead_time_14, t0.shipping_lead_time AS shipping_lead_time_15, t0.return_instructions AS return_instructions_16, t0.default_low_stock_threshold AS default_low_stock_threshold_17, t0.abandoned_carts_enabled AS abandoned_carts_enabled_18, t0.abandoned_cart_first_delay_hours AS abandoned_cart_first_delay_hours_19, t0.abandoned_cart_second_delay_hours AS abandoned_cart_second_delay_hours_20, t0.abandoned_cart_discount_bps AS abandoned_cart_discount_bps_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23 FROM shop_shops t0 WHERE t0.conversation_id = '01a154d0-2bf6-74d0-bc8c-897b35056e01' LIMIT 1;
|