| 1 |
2.44 ms |
SELECT a0_.email AS email_0, a0_.token AS token_1, a0_.confirmation_token AS confirmation_token_2, a0_.context_type AS context_type_3, a0_.password AS password_4, a0_.is_active AS is_active_5, a0_.is_blocked AS is_blocked_6, a0_.roles AS roles_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a0_.author_id AS author_id_16 FROM app_core_user_access a0_ WHERE a0_.email = ? AND a0_.is_active = 1
Parameters: [
"admin@technique.loc"
]
SELECT a0_.email AS email_0, a0_.token AS token_1, a0_.confirmation_token AS confirmation_token_2, a0_.context_type AS context_type_3, a0_.password AS password_4, a0_.is_active AS is_active_5, a0_.is_blocked AS is_blocked_6, a0_.roles AS roles_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a0_.author_id AS author_id_16 FROM app_core_user_access a0_ WHERE a0_.email = 'admin@technique.loc' AND a0_.is_active = 1;
|
| 2 |
0.56 ms |
SELECT t0.lastname AS lastname_1, t0.firstname AS firstname_2, t0.birth_place AS birth_place_3, t0.birth_date AS birth_date_4, t0.gender AS gender_5, t0.id AS id_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.deleted AS deleted_9, t0.locked AS locked_10, t0.is_draft AS is_draft_11, t0.can_be_deleted AS can_be_deleted_12, t0.owner_organization_id AS owner_organization_id_13, t0.access_id AS access_id_14, t15.email AS email_16, t15.token AS token_17, t15.confirmation_token AS confirmation_token_18, t15.context_type AS context_type_19, t15.password AS password_20, t15.is_active AS is_active_21, t15.is_blocked AS is_blocked_22, t15.roles AS roles_23, t15.id AS id_24, t15.date_add AS date_add_25, t15.date_upd AS date_upd_26, t15.deleted AS deleted_27, t15.locked AS locked_28, t15.is_draft AS is_draft_29, t15.can_be_deleted AS can_be_deleted_30, t15.owner_organization_id AS owner_organization_id_31, t15.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_actor t0 INNER JOIN app_core_user_access t15 ON t0.access_id = t15.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.access_id = ?
SELECT
t0.lastname AS lastname_1,
t0.firstname AS firstname_2,
t0.birth_place AS birth_place_3,
t0.birth_date AS birth_date_4,
t0.gender AS gender_5,
t0.id AS id_6,
t0.date_add AS date_add_7,
t0.date_upd AS date_upd_8,
t0.deleted AS deleted_9,
t0.locked AS locked_10,
t0.is_draft AS is_draft_11,
t0.can_be_deleted AS can_be_deleted_12,
t0.owner_organization_id AS owner_organization_id_13,
t0.access_id AS access_id_14,
t15.email AS email_16,
t15.token AS token_17,
t15.confirmation_token AS confirmation_token_18,
t15.context_type AS context_type_19,
t15.password AS password_20,
t15.is_active AS is_active_21,
t15.is_blocked AS is_blocked_22,
t15.roles AS roles_23,
t15.id AS id_24,
t15.date_add AS date_add_25,
t15.date_upd AS date_upd_26,
t15.deleted AS deleted_27,
t15.locked AS locked_28,
t15.is_draft AS is_draft_29,
t15.can_be_deleted AS can_be_deleted_30,
t15.owner_organization_id AS owner_organization_id_31,
t15.author_id AS author_id_32,
t0.author_id AS author_id_33,
t34.lastname AS lastname_35,
t34.firstname AS firstname_36,
t34.birth_place AS birth_place_37,
t34.birth_date AS birth_date_38,
t34.gender AS gender_39,
t34.id AS id_40,
t34.date_add AS date_add_41,
t34.date_upd AS date_upd_42,
t34.deleted AS deleted_43,
t34.locked AS locked_44,
t34.is_draft AS is_draft_45,
t34.can_be_deleted AS can_be_deleted_46,
t34.owner_organization_id AS owner_organization_id_47,
t34.access_id AS access_id_48,
t34.author_id AS author_id_49
FROM
app_core_user_actor t0
INNER JOIN app_core_user_access t15 ON t0.access_id = t15.id
LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id
WHERE
t0.access_id = ?
SELECT t0.lastname AS lastname_1, t0.firstname AS firstname_2, t0.birth_place AS birth_place_3, t0.birth_date AS birth_date_4, t0.gender AS gender_5, t0.id AS id_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.deleted AS deleted_9, t0.locked AS locked_10, t0.is_draft AS is_draft_11, t0.can_be_deleted AS can_be_deleted_12, t0.owner_organization_id AS owner_organization_id_13, t0.access_id AS access_id_14, t15.email AS email_16, t15.token AS token_17, t15.confirmation_token AS confirmation_token_18, t15.context_type AS context_type_19, t15.password AS password_20, t15.is_active AS is_active_21, t15.is_blocked AS is_blocked_22, t15.roles AS roles_23, t15.id AS id_24, t15.date_add AS date_add_25, t15.date_upd AS date_upd_26, t15.deleted AS deleted_27, t15.locked AS locked_28, t15.is_draft AS is_draft_29, t15.can_be_deleted AS can_be_deleted_30, t15.owner_organization_id AS owner_organization_id_31, t15.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_actor t0 INNER JOIN app_core_user_access t15 ON t0.access_id = t15.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.access_id = 1;
|
| 3 |
0.62 ms |
SELECT a0_.context_type AS context_type_0, a0_.id AS id_1, a0_.date_add AS date_add_2, a0_.date_upd AS date_upd_3, a0_.deleted AS deleted_4, a0_.locked AS locked_5, a0_.is_draft AS is_draft_6, a0_.can_be_deleted AS can_be_deleted_7, a0_.owner_organization_id AS owner_organization_id_8, a1_.lastname AS lastname_9, a1_.firstname AS firstname_10, a1_.birth_place AS birth_place_11, a1_.birth_date AS birth_date_12, a1_.gender AS gender_13, a1_.id AS id_14, a1_.date_add AS date_add_15, a1_.date_upd AS date_upd_16, a1_.deleted AS deleted_17, a1_.locked AS locked_18, a1_.is_draft AS is_draft_19, a1_.can_be_deleted AS can_be_deleted_20, a1_.owner_organization_id AS owner_organization_id_21, a0_.actor_id AS actor_id_22, a0_.organization_id AS organization_id_23, a0_.author_id AS author_id_24, a1_.access_id AS access_id_25, a1_.author_id AS author_id_26 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = ?
SELECT a0_.context_type AS context_type_0, a0_.id AS id_1, a0_.date_add AS date_add_2, a0_.date_upd AS date_upd_3, a0_.deleted AS deleted_4, a0_.locked AS locked_5, a0_.is_draft AS is_draft_6, a0_.can_be_deleted AS can_be_deleted_7, a0_.owner_organization_id AS owner_organization_id_8, a1_.lastname AS lastname_9, a1_.firstname AS firstname_10, a1_.birth_place AS birth_place_11, a1_.birth_date AS birth_date_12, a1_.gender AS gender_13, a1_.id AS id_14, a1_.date_add AS date_add_15, a1_.date_upd AS date_upd_16, a1_.deleted AS deleted_17, a1_.locked AS locked_18, a1_.is_draft AS is_draft_19, a1_.can_be_deleted AS can_be_deleted_20, a1_.owner_organization_id AS owner_organization_id_21, a0_.actor_id AS actor_id_22, a0_.organization_id AS organization_id_23, a0_.author_id AS author_id_24, a1_.access_id AS access_id_25, a1_.author_id AS author_id_26 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = 1;
|
| 4 |
0.60 ms |
SELECT t0.name AS name_1, t0.is_plateform_manager AS is_plateform_manager_2, t0.id AS id_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.deleted AS deleted_6, t0.locked AS locked_7, t0.is_draft AS is_draft_8, t0.can_be_deleted AS can_be_deleted_9, t0.owner_organization_id AS owner_organization_id_10, t0.actor_id AS actor_id_11, t12.lastname AS lastname_13, t12.firstname AS firstname_14, t12.birth_place AS birth_place_15, t12.birth_date AS birth_date_16, t12.gender AS gender_17, t12.id AS id_18, t12.date_add AS date_add_19, t12.date_upd AS date_upd_20, t12.deleted AS deleted_21, t12.locked AS locked_22, t12.is_draft AS is_draft_23, t12.can_be_deleted AS can_be_deleted_24, t12.owner_organization_id AS owner_organization_id_25, t12.access_id AS access_id_26, t12.author_id AS author_id_27, t0.thumbnail_id AS thumbnail_id_28, t29.filename AS filename_30, t29.original_name AS original_name_31, t29.mime_type AS mime_type_32, t29.extension AS extension_33, t29.size AS size_34, t29.url AS url_35, t29.id AS id_36, t29.date_add AS date_add_37, t29.date_upd AS date_upd_38, t29.deleted AS deleted_39, t29.locked AS locked_40, t29.is_draft AS is_draft_41, t29.can_be_deleted AS can_be_deleted_42, t29.owner_organization_id AS owner_organization_id_43, t29.author_id AS author_id_44, t0.author_id AS author_id_45, t46.lastname AS lastname_47, t46.firstname AS firstname_48, t46.birth_place AS birth_place_49, t46.birth_date AS birth_date_50, t46.gender AS gender_51, t46.id AS id_52, t46.date_add AS date_add_53, t46.date_upd AS date_upd_54, t46.deleted AS deleted_55, t46.locked AS locked_56, t46.is_draft AS is_draft_57, t46.can_be_deleted AS can_be_deleted_58, t46.owner_organization_id AS owner_organization_id_59, t46.access_id AS access_id_60, t46.author_id AS author_id_61 FROM app_core_user_organization t0 INNER JOIN app_core_user_actor t12 ON t0.actor_id = t12.id LEFT JOIN app_core_attachment t29 ON t0.thumbnail_id = t29.id LEFT JOIN app_core_user_actor t46 ON t0.author_id = t46.id WHERE t0.id IN (?)
SELECT
t0.name AS name_1,
t0.is_plateform_manager AS is_plateform_manager_2,
t0.id AS id_3,
t0.date_add AS date_add_4,
t0.date_upd AS date_upd_5,
t0.deleted AS deleted_6,
t0.locked AS locked_7,
t0.is_draft AS is_draft_8,
t0.can_be_deleted AS can_be_deleted_9,
t0.owner_organization_id AS owner_organization_id_10,
t0.actor_id AS actor_id_11,
t12.lastname AS lastname_13,
t12.firstname AS firstname_14,
t12.birth_place AS birth_place_15,
t12.birth_date AS birth_date_16,
t12.gender AS gender_17,
t12.id AS id_18,
t12.date_add AS date_add_19,
t12.date_upd AS date_upd_20,
t12.deleted AS deleted_21,
t12.locked AS locked_22,
t12.is_draft AS is_draft_23,
t12.can_be_deleted AS can_be_deleted_24,
t12.owner_organization_id AS owner_organization_id_25,
t12.access_id AS access_id_26,
t12.author_id AS author_id_27,
t0.thumbnail_id AS thumbnail_id_28,
t29.filename AS filename_30,
t29.original_name AS original_name_31,
t29.mime_type AS mime_type_32,
t29.extension AS extension_33,
t29.size AS size_34,
t29.url AS url_35,
t29.id AS id_36,
t29.date_add AS date_add_37,
t29.date_upd AS date_upd_38,
t29.deleted AS deleted_39,
t29.locked AS locked_40,
t29.is_draft AS is_draft_41,
t29.can_be_deleted AS can_be_deleted_42,
t29.owner_organization_id AS owner_organization_id_43,
t29.author_id AS author_id_44,
t0.author_id AS author_id_45,
t46.lastname AS lastname_47,
t46.firstname AS firstname_48,
t46.birth_place AS birth_place_49,
t46.birth_date AS birth_date_50,
t46.gender AS gender_51,
t46.id AS id_52,
t46.date_add AS date_add_53,
t46.date_upd AS date_upd_54,
t46.deleted AS deleted_55,
t46.locked AS locked_56,
t46.is_draft AS is_draft_57,
t46.can_be_deleted AS can_be_deleted_58,
t46.owner_organization_id AS owner_organization_id_59,
t46.access_id AS access_id_60,
t46.author_id AS author_id_61
FROM
app_core_user_organization t0
INNER JOIN app_core_user_actor t12 ON t0.actor_id = t12.id
LEFT JOIN app_core_attachment t29 ON t0.thumbnail_id = t29.id
LEFT JOIN app_core_user_actor t46 ON t0.author_id = t46.id
WHERE
t0.id IN (?)
SELECT t0.name AS name_1, t0.is_plateform_manager AS is_plateform_manager_2, t0.id AS id_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.deleted AS deleted_6, t0.locked AS locked_7, t0.is_draft AS is_draft_8, t0.can_be_deleted AS can_be_deleted_9, t0.owner_organization_id AS owner_organization_id_10, t0.actor_id AS actor_id_11, t12.lastname AS lastname_13, t12.firstname AS firstname_14, t12.birth_place AS birth_place_15, t12.birth_date AS birth_date_16, t12.gender AS gender_17, t12.id AS id_18, t12.date_add AS date_add_19, t12.date_upd AS date_upd_20, t12.deleted AS deleted_21, t12.locked AS locked_22, t12.is_draft AS is_draft_23, t12.can_be_deleted AS can_be_deleted_24, t12.owner_organization_id AS owner_organization_id_25, t12.access_id AS access_id_26, t12.author_id AS author_id_27, t0.thumbnail_id AS thumbnail_id_28, t29.filename AS filename_30, t29.original_name AS original_name_31, t29.mime_type AS mime_type_32, t29.extension AS extension_33, t29.size AS size_34, t29.url AS url_35, t29.id AS id_36, t29.date_add AS date_add_37, t29.date_upd AS date_upd_38, t29.deleted AS deleted_39, t29.locked AS locked_40, t29.is_draft AS is_draft_41, t29.can_be_deleted AS can_be_deleted_42, t29.owner_organization_id AS owner_organization_id_43, t29.author_id AS author_id_44, t0.author_id AS author_id_45, t46.lastname AS lastname_47, t46.firstname AS firstname_48, t46.birth_place AS birth_place_49, t46.birth_date AS birth_date_50, t46.gender AS gender_51, t46.id AS id_52, t46.date_add AS date_add_53, t46.date_upd AS date_upd_54, t46.deleted AS deleted_55, t46.locked AS locked_56, t46.is_draft AS is_draft_57, t46.can_be_deleted AS can_be_deleted_58, t46.owner_organization_id AS owner_organization_id_59, t46.access_id AS access_id_60, t46.author_id AS author_id_61 FROM app_core_user_organization t0 INNER JOIN app_core_user_actor t12 ON t0.actor_id = t12.id LEFT JOIN app_core_attachment t29 ON t0.thumbnail_id = t29.id LEFT JOIN app_core_user_actor t46 ON t0.author_id = t46.id WHERE t0.id IN (1);
|
| 5 |
0.95 ms |
SELECT a0_.context_type AS context_type_0, a0_.id AS id_1, a0_.date_add AS date_add_2, a0_.date_upd AS date_upd_3, a0_.deleted AS deleted_4, a0_.locked AS locked_5, a0_.is_draft AS is_draft_6, a0_.can_be_deleted AS can_be_deleted_7, a0_.owner_organization_id AS owner_organization_id_8, a1_.lastname AS lastname_9, a1_.firstname AS firstname_10, a1_.birth_place AS birth_place_11, a1_.birth_date AS birth_date_12, a1_.gender AS gender_13, a1_.id AS id_14, a1_.date_add AS date_add_15, a1_.date_upd AS date_upd_16, a1_.deleted AS deleted_17, a1_.locked AS locked_18, a1_.is_draft AS is_draft_19, a1_.can_be_deleted AS can_be_deleted_20, a1_.owner_organization_id AS owner_organization_id_21, a0_.actor_id AS actor_id_22, a0_.organization_id AS organization_id_23, a0_.author_id AS author_id_24, a1_.access_id AS access_id_25, a1_.author_id AS author_id_26 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = ?
SELECT a0_.context_type AS context_type_0, a0_.id AS id_1, a0_.date_add AS date_add_2, a0_.date_upd AS date_upd_3, a0_.deleted AS deleted_4, a0_.locked AS locked_5, a0_.is_draft AS is_draft_6, a0_.can_be_deleted AS can_be_deleted_7, a0_.owner_organization_id AS owner_organization_id_8, a1_.lastname AS lastname_9, a1_.firstname AS firstname_10, a1_.birth_place AS birth_place_11, a1_.birth_date AS birth_date_12, a1_.gender AS gender_13, a1_.id AS id_14, a1_.date_add AS date_add_15, a1_.date_upd AS date_upd_16, a1_.deleted AS deleted_17, a1_.locked AS locked_18, a1_.is_draft AS is_draft_19, a1_.can_be_deleted AS can_be_deleted_20, a1_.owner_organization_id AS owner_organization_id_21, a0_.actor_id AS actor_id_22, a0_.organization_id AS organization_id_23, a0_.author_id AS author_id_24, a1_.access_id AS access_id_25, a1_.author_id AS author_id_26 FROM app_core_user_workspace a0_ INNER JOIN app_core_user_actor a1_ ON a0_.actor_id = a1_.id WHERE a1_.access_id = 1;
|
| 6 |
0.66 ms |
SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.actor_id = ? LIMIT 1
SELECT
t0.context_type AS context_type_1,
t0.id AS id_2,
t0.date_add AS date_add_3,
t0.date_upd AS date_upd_4,
t0.deleted AS deleted_5,
t0.locked AS locked_6,
t0.is_draft AS is_draft_7,
t0.can_be_deleted AS can_be_deleted_8,
t0.owner_organization_id AS owner_organization_id_9,
t0.actor_id AS actor_id_10,
t11.lastname AS lastname_12,
t11.firstname AS firstname_13,
t11.birth_place AS birth_place_14,
t11.birth_date AS birth_date_15,
t11.gender AS gender_16,
t11.id AS id_17,
t11.date_add AS date_add_18,
t11.date_upd AS date_upd_19,
t11.deleted AS deleted_20,
t11.locked AS locked_21,
t11.is_draft AS is_draft_22,
t11.can_be_deleted AS can_be_deleted_23,
t11.owner_organization_id AS owner_organization_id_24,
t11.access_id AS access_id_25,
t11.author_id AS author_id_26,
t0.organization_id AS organization_id_27,
t28.name AS name_29,
t28.is_plateform_manager AS is_plateform_manager_30,
t28.id AS id_31,
t28.date_add AS date_add_32,
t28.date_upd AS date_upd_33,
t28.deleted AS deleted_34,
t28.locked AS locked_35,
t28.is_draft AS is_draft_36,
t28.can_be_deleted AS can_be_deleted_37,
t28.owner_organization_id AS owner_organization_id_38,
t28.actor_id AS actor_id_39,
t28.thumbnail_id AS thumbnail_id_40,
t28.author_id AS author_id_41,
t0.author_id AS author_id_42,
t43.lastname AS lastname_44,
t43.firstname AS firstname_45,
t43.birth_place AS birth_place_46,
t43.birth_date AS birth_date_47,
t43.gender AS gender_48,
t43.id AS id_49,
t43.date_add AS date_add_50,
t43.date_upd AS date_upd_51,
t43.deleted AS deleted_52,
t43.locked AS locked_53,
t43.is_draft AS is_draft_54,
t43.can_be_deleted AS can_be_deleted_55,
t43.owner_organization_id AS owner_organization_id_56,
t43.access_id AS access_id_57,
t43.author_id AS author_id_58
FROM
app_core_user_workspace t0
INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id
INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id
LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id
WHERE
t0.actor_id = ?
LIMIT
1
SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.actor_id = 1 LIMIT 1;
|
| 7 |
0.70 ms |
SELECT t0.matricule AS matricule_1, t0.position AS position_2, t0.is_blocked AS is_blocked_3, t0.blog_roles AS blog_roles_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.actor_id AS actor_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29, t0.contact_id AS contact_id_30, t31.phone AS phone_32, t31.email AS email_33, t31.web_site AS web_site_34, t31.address AS address_35, t31.city AS city_36, t31.id AS id_37, t31.date_add AS date_add_38, t31.date_upd AS date_upd_39, t31.deleted AS deleted_40, t31.locked AS locked_41, t31.is_draft AS is_draft_42, t31.can_be_deleted AS can_be_deleted_43, t31.owner_organization_id AS owner_organization_id_44, t31.country_id AS country_id_45, t31.state_id AS state_id_46, t31.author_id AS author_id_47, t0.organization_id AS organization_id_48, t49.name AS name_50, t49.is_plateform_manager AS is_plateform_manager_51, t49.id AS id_52, t49.date_add AS date_add_53, t49.date_upd AS date_upd_54, t49.deleted AS deleted_55, t49.locked AS locked_56, t49.is_draft AS is_draft_57, t49.can_be_deleted AS can_be_deleted_58, t49.owner_organization_id AS owner_organization_id_59, t49.actor_id AS actor_id_60, t49.thumbnail_id AS thumbnail_id_61, t49.author_id AS author_id_62, t0.author_id AS author_id_63, t64.lastname AS lastname_65, t64.firstname AS firstname_66, t64.birth_place AS birth_place_67, t64.birth_date AS birth_date_68, t64.gender AS gender_69, t64.id AS id_70, t64.date_add AS date_add_71, t64.date_upd AS date_upd_72, t64.deleted AS deleted_73, t64.locked AS locked_74, t64.is_draft AS is_draft_75, t64.can_be_deleted AS can_be_deleted_76, t64.owner_organization_id AS owner_organization_id_77, t64.access_id AS access_id_78, t64.author_id AS author_id_79 FROM app_core_user_collaborator t0 INNER JOIN app_core_user_actor t14 ON t0.actor_id = t14.id LEFT JOIN app_core_location_contact t31 ON t0.contact_id = t31.id INNER JOIN app_core_user_organization t49 ON t0.organization_id = t49.id LEFT JOIN app_core_user_actor t64 ON t0.author_id = t64.id WHERE t0.actor_id = ? AND t0.organization_id = ? LIMIT 1
SELECT
t0.matricule AS matricule_1,
t0.position AS position_2,
t0.is_blocked AS is_blocked_3,
t0.blog_roles AS blog_roles_4,
t0.id AS id_5,
t0.date_add AS date_add_6,
t0.date_upd AS date_upd_7,
t0.deleted AS deleted_8,
t0.locked AS locked_9,
t0.is_draft AS is_draft_10,
t0.can_be_deleted AS can_be_deleted_11,
t0.owner_organization_id AS owner_organization_id_12,
t0.actor_id AS actor_id_13,
t14.lastname AS lastname_15,
t14.firstname AS firstname_16,
t14.birth_place AS birth_place_17,
t14.birth_date AS birth_date_18,
t14.gender AS gender_19,
t14.id AS id_20,
t14.date_add AS date_add_21,
t14.date_upd AS date_upd_22,
t14.deleted AS deleted_23,
t14.locked AS locked_24,
t14.is_draft AS is_draft_25,
t14.can_be_deleted AS can_be_deleted_26,
t14.owner_organization_id AS owner_organization_id_27,
t14.access_id AS access_id_28,
t14.author_id AS author_id_29,
t0.contact_id AS contact_id_30,
t31.phone AS phone_32,
t31.email AS email_33,
t31.web_site AS web_site_34,
t31.address AS address_35,
t31.city AS city_36,
t31.id AS id_37,
t31.date_add AS date_add_38,
t31.date_upd AS date_upd_39,
t31.deleted AS deleted_40,
t31.locked AS locked_41,
t31.is_draft AS is_draft_42,
t31.can_be_deleted AS can_be_deleted_43,
t31.owner_organization_id AS owner_organization_id_44,
t31.country_id AS country_id_45,
t31.state_id AS state_id_46,
t31.author_id AS author_id_47,
t0.organization_id AS organization_id_48,
t49.name AS name_50,
t49.is_plateform_manager AS is_plateform_manager_51,
t49.id AS id_52,
t49.date_add AS date_add_53,
t49.date_upd AS date_upd_54,
t49.deleted AS deleted_55,
t49.locked AS locked_56,
t49.is_draft AS is_draft_57,
t49.can_be_deleted AS can_be_deleted_58,
t49.owner_organization_id AS owner_organization_id_59,
t49.actor_id AS actor_id_60,
t49.thumbnail_id AS thumbnail_id_61,
t49.author_id AS author_id_62,
t0.author_id AS author_id_63,
t64.lastname AS lastname_65,
t64.firstname AS firstname_66,
t64.birth_place AS birth_place_67,
t64.birth_date AS birth_date_68,
t64.gender AS gender_69,
t64.id AS id_70,
t64.date_add AS date_add_71,
t64.date_upd AS date_upd_72,
t64.deleted AS deleted_73,
t64.locked AS locked_74,
t64.is_draft AS is_draft_75,
t64.can_be_deleted AS can_be_deleted_76,
t64.owner_organization_id AS owner_organization_id_77,
t64.access_id AS access_id_78,
t64.author_id AS author_id_79
FROM
app_core_user_collaborator t0
INNER JOIN app_core_user_actor t14 ON t0.actor_id = t14.id
LEFT JOIN app_core_location_contact t31 ON t0.contact_id = t31.id
INNER JOIN app_core_user_organization t49 ON t0.organization_id = t49.id
LEFT JOIN app_core_user_actor t64 ON t0.author_id = t64.id
WHERE
t0.actor_id = ?
AND t0.organization_id = ?
LIMIT
1
SELECT t0.matricule AS matricule_1, t0.position AS position_2, t0.is_blocked AS is_blocked_3, t0.blog_roles AS blog_roles_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.actor_id AS actor_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29, t0.contact_id AS contact_id_30, t31.phone AS phone_32, t31.email AS email_33, t31.web_site AS web_site_34, t31.address AS address_35, t31.city AS city_36, t31.id AS id_37, t31.date_add AS date_add_38, t31.date_upd AS date_upd_39, t31.deleted AS deleted_40, t31.locked AS locked_41, t31.is_draft AS is_draft_42, t31.can_be_deleted AS can_be_deleted_43, t31.owner_organization_id AS owner_organization_id_44, t31.country_id AS country_id_45, t31.state_id AS state_id_46, t31.author_id AS author_id_47, t0.organization_id AS organization_id_48, t49.name AS name_50, t49.is_plateform_manager AS is_plateform_manager_51, t49.id AS id_52, t49.date_add AS date_add_53, t49.date_upd AS date_upd_54, t49.deleted AS deleted_55, t49.locked AS locked_56, t49.is_draft AS is_draft_57, t49.can_be_deleted AS can_be_deleted_58, t49.owner_organization_id AS owner_organization_id_59, t49.actor_id AS actor_id_60, t49.thumbnail_id AS thumbnail_id_61, t49.author_id AS author_id_62, t0.author_id AS author_id_63, t64.lastname AS lastname_65, t64.firstname AS firstname_66, t64.birth_place AS birth_place_67, t64.birth_date AS birth_date_68, t64.gender AS gender_69, t64.id AS id_70, t64.date_add AS date_add_71, t64.date_upd AS date_upd_72, t64.deleted AS deleted_73, t64.locked AS locked_74, t64.is_draft AS is_draft_75, t64.can_be_deleted AS can_be_deleted_76, t64.owner_organization_id AS owner_organization_id_77, t64.access_id AS access_id_78, t64.author_id AS author_id_79 FROM app_core_user_collaborator t0 INNER JOIN app_core_user_actor t14 ON t0.actor_id = t14.id LEFT JOIN app_core_location_contact t31 ON t0.contact_id = t31.id INNER JOIN app_core_user_organization t49 ON t0.organization_id = t49.id LEFT JOIN app_core_user_actor t64 ON t0.author_id = t64.id WHERE t0.actor_id = 1 AND t0.organization_id = 1 LIMIT 1;
|
| 8 |
7.51 ms |
SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10
SELECT
DISTINCT id_11
FROM
(
SELECT
DISTINCT id_11,
position_9
FROM
(
SELECT
a0_.status AS status_0,
a0_.target AS target_1,
a0_.group_type AS group_type_2,
a0_.target_menu AS target_menu_3,
a0_.client_type AS client_type_4,
a0_.lend_type AS lend_type_5,
a0_.lend_types AS lend_types_6,
a0_.show_in_menu AS show_in_menu_7,
a0_.show_title AS show_title_8,
a0_.position AS position_9,
a0_.anchor AS anchor_10,
a0_.id AS id_11,
a0_.date_add AS date_add_12,
a0_.date_upd AS date_upd_13,
a0_.deleted AS deleted_14,
a0_.locked AS locked_15,
a0_.is_draft AS is_draft_16,
a0_.can_be_deleted AS can_be_deleted_17,
a0_.owner_organization_id AS owner_organization_id_18,
a1_.sub_title AS sub_title_19,
a1_.id AS id_20,
a1_.locale AS locale_21,
a1_.name AS name_22,
a1_.description AS description_23,
a1_.meta_description AS meta_description_24,
a1_.work_keys AS work_keys_25,
a1_.slug AS slug_26,
a2_.color AS color_27,
a2_.bg_color AS bg_color_28,
a2_.type AS type_29,
a2_.target AS target_30,
a2_.target_menu AS target_menu_31,
a2_.client_type AS client_type_32,
a2_.position AS position_33,
a2_.status AS status_34,
a2_.id AS id_35,
a2_.date_add AS date_add_36,
a2_.date_upd AS date_upd_37,
a2_.deleted AS deleted_38,
a2_.locked AS locked_39,
a2_.is_draft AS is_draft_40,
a2_.can_be_deleted AS can_be_deleted_41,
a2_.owner_organization_id AS owner_organization_id_42
FROM
app_business_product a0_
INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id
LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id
WHERE
a0_.deleted = 0
AND a0_.deleted = 0
) dctrn_result_inner
ORDER BY
position_9 ASC
) dctrn_result
LIMIT
10
SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10;
|
| 9 |
1.52 ms |
SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.position ASC
Parameters: [
38
23
29
32
33
34
35
36
37
2
]
SELECT
a0_.status AS status_0,
a0_.target AS target_1,
a0_.group_type AS group_type_2,
a0_.target_menu AS target_menu_3,
a0_.client_type AS client_type_4,
a0_.lend_type AS lend_type_5,
a0_.lend_types AS lend_types_6,
a0_.show_in_menu AS show_in_menu_7,
a0_.show_title AS show_title_8,
a0_.position AS position_9,
a0_.anchor AS anchor_10,
a0_.id AS id_11,
a0_.date_add AS date_add_12,
a0_.date_upd AS date_upd_13,
a0_.deleted AS deleted_14,
a0_.locked AS locked_15,
a0_.is_draft AS is_draft_16,
a0_.can_be_deleted AS can_be_deleted_17,
a0_.owner_organization_id AS owner_organization_id_18,
a1_.sub_title AS sub_title_19,
a1_.id AS id_20,
a1_.locale AS locale_21,
a1_.name AS name_22,
a1_.description AS description_23,
a1_.meta_description AS meta_description_24,
a1_.work_keys AS work_keys_25,
a1_.slug AS slug_26,
a2_.color AS color_27,
a2_.bg_color AS bg_color_28,
a2_.type AS type_29,
a2_.target AS target_30,
a2_.target_menu AS target_menu_31,
a2_.client_type AS client_type_32,
a2_.position AS position_33,
a2_.status AS status_34,
a2_.id AS id_35,
a2_.date_add AS date_add_36,
a2_.date_upd AS date_upd_37,
a2_.deleted AS deleted_38,
a2_.locked AS locked_39,
a2_.is_draft AS is_draft_40,
a2_.can_be_deleted AS can_be_deleted_41,
a2_.owner_organization_id AS owner_organization_id_42,
a0_.type_id AS type_id_43,
a0_.parent_id AS parent_id_44,
a0_.thumbnail_id AS thumbnail_id_45,
a0_.author_id AS author_id_46,
a1_.entity_id AS entity_id_47,
a2_.author_id AS author_id_48
FROM
app_business_product a0_
INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id
LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id
WHERE
a0_.deleted = 0
AND a0_.deleted = 0
AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
a0_.position ASC
SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.deleted = 0 AND a0_.id IN (38, 23, 29, 32, 33, 34, 35, 36, 37, 2) ORDER BY a0_.position ASC;
|
| 10 |
1.13 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.color AS color_10, t9.bg_color AS bg_color_11, t9.type AS type_12, t9.target AS target_13, t9.target_menu AS target_menu_14, t9.client_type AS client_type_15, t9.position AS position_16, t9.status AS status_17, t9.id AS id_18, t9.date_add AS date_add_19, t9.date_upd AS date_upd_20, t9.deleted AS deleted_21, t9.locked AS locked_22, t9.is_draft AS is_draft_23, t9.can_be_deleted AS can_be_deleted_24, t9.owner_organization_id AS owner_organization_id_25, t9.author_id AS author_id_26 FROM app_business_category_i18n t0 INNER JOIN app_business_category t9 ON t0.entity_id = t9.id WHERE t0.entity_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.color AS color_10, t9.bg_color AS bg_color_11, t9.type AS type_12, t9.target AS target_13, t9.target_menu AS target_menu_14, t9.client_type AS client_type_15, t9.position AS position_16, t9.status AS status_17, t9.id AS id_18, t9.date_add AS date_add_19, t9.date_upd AS date_upd_20, t9.deleted AS deleted_21, t9.locked AS locked_22, t9.is_draft AS is_draft_23, t9.can_be_deleted AS can_be_deleted_24, t9.owner_organization_id AS owner_organization_id_25, t9.author_id AS author_id_26 FROM app_business_category_i18n t0 INNER JOIN app_business_category t9 ON t0.entity_id = t9.id WHERE t0.entity_id = 9;
|
| 11 |
1.96 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.id IN (?)
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.id IN (?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.id IN (3);
|
| 12 |
0.73 ms |
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ?
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = 3;
|
| 13 |
1.19 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?, ?, ?)
Parameters: [
2
23
29
32
]
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?, ?, ?, ?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (2, 23, 29, 32);
|
| 14 |
0.58 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.color AS color_10, t9.bg_color AS bg_color_11, t9.type AS type_12, t9.target AS target_13, t9.target_menu AS target_menu_14, t9.client_type AS client_type_15, t9.position AS position_16, t9.status AS status_17, t9.id AS id_18, t9.date_add AS date_add_19, t9.date_upd AS date_upd_20, t9.deleted AS deleted_21, t9.locked AS locked_22, t9.is_draft AS is_draft_23, t9.can_be_deleted AS can_be_deleted_24, t9.owner_organization_id AS owner_organization_id_25, t9.author_id AS author_id_26 FROM app_business_category_i18n t0 INNER JOIN app_business_category t9 ON t0.entity_id = t9.id WHERE t0.entity_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.color AS color_10, t9.bg_color AS bg_color_11, t9.type AS type_12, t9.target AS target_13, t9.target_menu AS target_menu_14, t9.client_type AS client_type_15, t9.position AS position_16, t9.status AS status_17, t9.id AS id_18, t9.date_add AS date_add_19, t9.date_upd AS date_upd_20, t9.deleted AS deleted_21, t9.locked AS locked_22, t9.is_draft AS is_draft_23, t9.can_be_deleted AS can_be_deleted_24, t9.owner_organization_id AS owner_organization_id_25, t9.author_id AS author_id_26 FROM app_business_category_i18n t0 INNER JOIN app_business_category t9 ON t0.entity_id = t9.id WHERE t0.entity_id = 14;
|
| 15 |
0.69 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?)
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (3);
|
| 16 |
0.40 ms |
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ?
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = 4;
|
| 17 |
0.50 ms |
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ?
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = 5;
|
| 18 |
0.59 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?)
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (4);
|
| 19 |
0.40 ms |
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ?
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = 6;
|
| 20 |
0.65 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?)
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (5);
|
| 21 |
0.39 ms |
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ?
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = 42;
|
| 22 |
0.51 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?)
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (6);
|
| 23 |
0.39 ms |
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ?
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = 45;
|
| 24 |
0.46 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?)
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (42);
|
| 25 |
0.41 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?)
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (45);
|
| 26 |
0.34 ms |
SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?, ?, ?)
Parameters: [
47
197
64
67
]
SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (47, 197, 64, 67);
|
| 27 |
0.47 ms |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?)
Parameters: [
33
34
35
36
37
38
]
SELECT
t0.status AS status_1,
t0.target AS target_2,
t0.group_type AS group_type_3,
t0.target_menu AS target_menu_4,
t0.client_type AS client_type_5,
t0.lend_type AS lend_type_6,
t0.lend_types AS lend_types_7,
t0.show_in_menu AS show_in_menu_8,
t0.show_title AS show_title_9,
t0.position AS position_10,
t0.anchor AS anchor_11,
t0.id AS id_12,
t0.date_add AS date_add_13,
t0.date_upd AS date_upd_14,
t0.deleted AS deleted_15,
t0.locked AS locked_16,
t0.is_draft AS is_draft_17,
t0.can_be_deleted AS can_be_deleted_18,
t0.owner_organization_id AS owner_organization_id_19,
t0.type_id AS type_id_20,
t21.color AS color_22,
t21.bg_color AS bg_color_23,
t21.type AS type_24,
t21.target AS target_25,
t21.target_menu AS target_menu_26,
t21.client_type AS client_type_27,
t21.position AS position_28,
t21.status AS status_29,
t21.id AS id_30,
t21.date_add AS date_add_31,
t21.date_upd AS date_upd_32,
t21.deleted AS deleted_33,
t21.locked AS locked_34,
t21.is_draft AS is_draft_35,
t21.can_be_deleted AS can_be_deleted_36,
t21.owner_organization_id AS owner_organization_id_37,
t21.author_id AS author_id_38,
t0.parent_id AS parent_id_39,
t40.status AS status_41,
t40.target AS target_42,
t40.group_type AS group_type_43,
t40.target_menu AS target_menu_44,
t40.client_type AS client_type_45,
t40.lend_type AS lend_type_46,
t40.lend_types AS lend_types_47,
t40.show_in_menu AS show_in_menu_48,
t40.show_title AS show_title_49,
t40.position AS position_50,
t40.anchor AS anchor_51,
t40.id AS id_52,
t40.date_add AS date_add_53,
t40.date_upd AS date_upd_54,
t40.deleted AS deleted_55,
t40.locked AS locked_56,
t40.is_draft AS is_draft_57,
t40.can_be_deleted AS can_be_deleted_58,
t40.owner_organization_id AS owner_organization_id_59,
t40.type_id AS type_id_60,
t40.parent_id AS parent_id_61,
t40.thumbnail_id AS thumbnail_id_62,
t40.author_id AS author_id_63,
t0.thumbnail_id AS thumbnail_id_64,
t65.filename AS filename_66,
t65.original_name AS original_name_67,
t65.mime_type AS mime_type_68,
t65.extension AS extension_69,
t65.size AS size_70,
t65.url AS url_71,
t65.id AS id_72,
t65.date_add AS date_add_73,
t65.date_upd AS date_upd_74,
t65.deleted AS deleted_75,
t65.locked AS locked_76,
t65.is_draft AS is_draft_77,
t65.can_be_deleted AS can_be_deleted_78,
t65.owner_organization_id AS owner_organization_id_79,
t65.author_id AS author_id_80,
t0.author_id AS author_id_81,
t82.lastname AS lastname_83,
t82.firstname AS firstname_84,
t82.birth_place AS birth_place_85,
t82.birth_date AS birth_date_86,
t82.gender AS gender_87,
t82.id AS id_88,
t82.date_add AS date_add_89,
t82.date_upd AS date_upd_90,
t82.deleted AS deleted_91,
t82.locked AS locked_92,
t82.is_draft AS is_draft_93,
t82.can_be_deleted AS can_be_deleted_94,
t82.owner_organization_id AS owner_organization_id_95,
t82.access_id AS access_id_96,
t82.author_id AS author_id_97
FROM
app_business_product t0
LEFT JOIN app_business_category t21 ON t0.type_id = t21.id
LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id
LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id
LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id
WHERE
t0.parent_id IN (?, ?, ?, ?, ?, ?)
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (33, 34, 35, 36, 37, 38);
|
| 28 |
1.69 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
SELECT
COUNT(*) AS dctrn_count
FROM
(
SELECT
DISTINCT id_11
FROM
(
SELECT
a0_.status AS status_0,
a0_.target AS target_1,
a0_.group_type AS group_type_2,
a0_.target_menu AS target_menu_3,
a0_.client_type AS client_type_4,
a0_.lend_type AS lend_type_5,
a0_.lend_types AS lend_types_6,
a0_.show_in_menu AS show_in_menu_7,
a0_.show_title AS show_title_8,
a0_.position AS position_9,
a0_.anchor AS anchor_10,
a0_.id AS id_11,
a0_.date_add AS date_add_12,
a0_.date_upd AS date_upd_13,
a0_.deleted AS deleted_14,
a0_.locked AS locked_15,
a0_.is_draft AS is_draft_16,
a0_.can_be_deleted AS can_be_deleted_17,
a0_.owner_organization_id AS owner_organization_id_18,
a1_.sub_title AS sub_title_19,
a1_.id AS id_20,
a1_.locale AS locale_21,
a1_.name AS name_22,
a1_.description AS description_23,
a1_.meta_description AS meta_description_24,
a1_.work_keys AS work_keys_25,
a1_.slug AS slug_26,
a2_.color AS color_27,
a2_.bg_color AS bg_color_28,
a2_.type AS type_29,
a2_.target AS target_30,
a2_.target_menu AS target_menu_31,
a2_.client_type AS client_type_32,
a2_.position AS position_33,
a2_.status AS status_34,
a2_.id AS id_35,
a2_.date_add AS date_add_36,
a2_.date_upd AS date_upd_37,
a2_.deleted AS deleted_38,
a2_.locked AS locked_39,
a2_.is_draft AS is_draft_40,
a2_.can_be_deleted AS can_be_deleted_41,
a2_.owner_organization_id AS owner_organization_id_42
FROM
app_business_product a0_
INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id
LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id
WHERE
a0_.deleted = 0
AND a0_.deleted = 0
ORDER BY
a0_.position ASC
) dctrn_result
) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table;
|