___schizoid (___schizoid) wrote,
___schizoid
___schizoid

И опять о них

Чем больше живу, тем больше убеждаюсь в том, что индусы - инопланетяне.

Вот вам загадко - что делает в течении около одной секунды нижеприведённый SQL:

SELECT t0.object_id, t0.discriminator, t0.object_version, t0.description, t1.object_id, t1.discriminator, t1.object_version, t1.channel_id, t1.description, t1.name, t2.object_id, t2.discriminator, t2.object_version, t2.channel_id, t2.description, t2.name, t2.fk2parent_channel, t0.fk2busi_inte_inte_comp_reas, t0.fk2busi_inte_inte_coun_code, t0.interaction_date, t0.interaction_date_complete, t0.interaction_email_address, t0.interaction_id, t0.fk2interaction_status, t0.fk2busi_inte_inte_sub_stat, t3.object_id, t3.object_version, t3.description, t3.ext_name, t3.name, t3.valid_for_end_date_time, t3.valid_for_start_date_time, t0.is_fully_validated, t0.last_state_change, t0.session_id, t0.fk2busin_interact_trigger, t0.work_interaction_id, t0.assigned_priority, t0.assigned_responsibility_date, t4.object_id, t4.discriminator, t4.object_version, t5.object_id, t5.object_version, t6.object_id, t6.discriminator, t6.object_version, t6.address_id, t6.city, t6.country, t6.ext_address_id, t6.postcode, t6.state_or_province, t6.box_nr, t6.box_type, t6.street_name, t6.street_nr_first, t6.street_nr_first_suffix, t6.street_nr_last, t6.street_nr_last_suffix, t6.flat_number, t6.stair_case, t6.house_name, t6.door, t6.door_suffix, t6.floor, t5.contact_medium_id, t5.fk2contact_phone_type, t5.email_address, t5.fax_number, t5.mobile_office_phone_number, t5.mob_off_pre_con_tim_end, t5.mob_off_pre_con_tim_start, t5.mobile_private_phone_number, t5.mob_pri_pre_con_tim_end, t5.mob_pri_pre_con_tim_start, t5.office_phone_number, t5.off_pre_con_tim_end, t5.off_pre_con_tim_start, t5.fk2preferred_contact_medium, t5.private_phone_number, t5.pri_pre_con_tim_end, t5.pri_pre_con_tim_start, t7.object_id, t7.discriminator, t7.object_version, t7.fk2party_contact_language, t7.party_id, t8.alive_during_end_date_time, t8.alive_during_start_date_time, t8.fk2gender, t8.fk2marital_status, t8.aristocratic_title, t8.family_name, t8.family_name_prefix, t8.fk2form_of_address, t8.generation, t8.given_name, t8.middle_names, t8.preferred_given_name, t8.qualifications, t8.nationality, t8.place_of_birth, t8.skills, t9.exists_during_end_date_time, t9.exists_during_start_date_time, t9.is_legal_entity, t9.fk2main_contact, t9.fk2name_type, t9.trading_name, t9.organization_type, t9.vat_number, t4.party_role_id, t4.party_role_risk_rating, t10.object_id, t10.object_version, t10.description, t10.ext_name, t10.name, t10.valid_for_end_date_time, t10.valid_for_start_date_time, t4.fk2party_role_status, t4.valid_for_end_date_time, t4.valid_for_start_date_time, t4.customer_rank, t4.fk2customer_customer_status, t0.fk2cust_orde_cust_orde_type, t0.due_date, t0.order_note, t0.is_building_upgrade_needed, t11.object_id, t11.discriminator, t11.object_version, t11.fk2contact_medium, t11.fk2party, t11.party_role_id, t11.party_role_risk_rating, t11.fk2party_role_type, t11.fk2party_role_status, t11.valid_for_end_date_time, t11.valid_for_start_date_time, t11.fk2credit_profile, t12.object_id, t12.discriminator, t12.object_version, t12.fk2contact_medium, t12.fk2party, t12.party_role_id, t12.party_role_risk_rating, t12.fk2party_role_type, t12.fk2party_role_status, t12.valid_for_end_date_time, t12.valid_for_start_date_time FROM product_orders t0, channels t1, channels t2, business_interaction_types t3, party_roles t4, contact_mediums t5, geographic_addresses t6, parties t7, individuals t8, organizations t9, party_role_types t10, party_roles t11, party_roles t12 WHERE (1 <> 1 AND t0.fk2interaction_status IN (?, ?, ?, ?, ?, ?)) AND t0.discriminator = ? AND t0.fk2interaction_channel = t1.object_id(+) AND t0.fk2interaction_type = t3.object_id(+) AND t0.fk2customer = t4.object_id(+) AND t0.fk2payer = t11.object_id(+) AND t0.fk2shipment_receiver = t12.object_id(+) AND t1.fk2parent_channel = t2.object_id(+) AND t4.fk2contact_medium = t5.object_id(+) AND t4.fk2party = t7.object_id(+) AND t4.fk2party_role_type = t10.object_id(+) AND t5.fk2address = t6.object_id(+) AND t7.object_id = t8.fk2party(+) AND t7.object_id = t9.fk2party(+) [params=(long) 1000000000007, (long) 1000000000006, (long) 1000000000008, (long) 1000000000005, (long) 1000000000004, (long) 1000000000000, (String) UPC_PRODUCT_ORDER] [reused=0]

Подсказка выделена жирным.
Tags: indians from space, lol, tech, work, гон
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 18 comments