| 1 |
2.05 ms |
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.order_no AS order_no_2, o0_.status AS status_3, o0_.payment_status AS payment_status_4, o0_.created_at AS created_at_5, o0_.edited_at AS edited_at_6, o0_.description AS description_7, o0_.type AS type_8, o0_.payment_method AS payment_method_9, o0_.payment_method_id AS payment_method_id_10, o0_.payment_info AS payment_info_11, o0_.billing_address1 AS billing_address1_12, o0_.billing_address2 AS billing_address2_13, o0_.billing_city AS billing_city_14, o0_.billing_state AS billing_state_15, o0_.billing_zip_code AS billing_zip_code_16, o0_.billing_country AS billing_country_17, o0_.shipping_address1 AS shipping_address1_18, o0_.shipping_address2 AS shipping_address2_19, o0_.shipping_city AS shipping_city_20, o0_.shipping_state AS shipping_state_21, o0_.shipping_zip_code AS shipping_zip_code_22, o0_.shipping_country AS shipping_country_23, o0_.subtotal AS subtotal_24, o0_.total AS total_25, o0_.discount AS discount_26, o0_.billing_first_name AS billing_first_name_27, o0_.billing_last_name AS billing_last_name_28, o0_.billing_company AS billing_company_29, o0_.billing_phone AS billing_phone_30, o0_.billing_email AS billing_email_31, o0_.coupon AS coupon_32, o0_.abandon_time AS abandon_time_33, o0_.source AS source_34, o0_.deleted AS deleted_35, o0_.deleted_by AS deleted_by_36, o0_.deleted_time AS deleted_time_37, m1_.id AS id_38, m1_.name AS name_39, m1_.first_name AS first_name_40, m1_.last_name AS last_name_41, m1_.email AS email_42, m1_.phone AS phone_43, m1_.fei AS fei_44, m1_.street AS street_45, m1_.city AS city_46, m1_.state AS state_47, m1_.zip AS zip_48, m1_.industry AS industry_49, m1_.ethnicity AS ethnicity_50, m1_.external_id AS external_id_51, m1_.revenue AS revenue_52, m1_.type AS type_53, m1_.gender AS gender_54, m1_.business_type AS business_type_55, m1_.business_structure AS business_structure_56, m1_.geographic_market AS geographic_market_57, m1_.description AS description_58, m1_.naics AS naics_59, m1_.nigp AS nigp_60, m1_.keywords AS keywords_61, m1_.certifications AS certifications_62, m1_.certification_entity AS certification_entity_63, m1_.certification_type AS certification_type_64, m1_.certification_date AS certification_date_65, m1_.year_established AS year_established_66, m1_.qualify_status AS qualify_status_67, m1_.website AS website_68, m1_.employees AS employees_69, m1_.status AS status_70, m1_.revenue_class AS revenue_class_71, m1_.rating AS rating_72, m1_.your_industry AS your_industry_73, m1_.professional_licenses AS professional_licenses_74, m1_.dba AS dba_75, m1_.created_at AS created_at_76, m1_.modified_at AS modified_at_77, m1_.senate AS senate_78, m1_.house_of_representatives AS house_of_representatives_79, m1_.congressional AS congressional_80, m1_.commissioner AS commissioner_81, m1_.school_board AS school_board_82, m1_.city_council AS city_council_83, m1_.deleted AS deleted_84, o0_.assigned_user_id AS assigned_user_id_85, o0_.assigned_member_id AS assigned_member_id_86 FROM `order` o0_ LEFT JOIN member m1_ ON o0_.assigned_member_id = m1_.id ORDER BY o0_.id ASC LIMIT 20 OFFSET 180
SELECT
o0_.id AS id_0,
o0_.name AS name_1,
o0_.order_no AS order_no_2,
o0_.status AS status_3,
o0_.payment_status AS payment_status_4,
o0_.created_at AS created_at_5,
o0_.edited_at AS edited_at_6,
o0_.description AS description_7,
o0_.type AS type_8,
o0_.payment_method AS payment_method_9,
o0_.payment_method_id AS payment_method_id_10,
o0_.payment_info AS payment_info_11,
o0_.billing_address1 AS billing_address1_12,
o0_.billing_address2 AS billing_address2_13,
o0_.billing_city AS billing_city_14,
o0_.billing_state AS billing_state_15,
o0_.billing_zip_code AS billing_zip_code_16,
o0_.billing_country AS billing_country_17,
o0_.shipping_address1 AS shipping_address1_18,
o0_.shipping_address2 AS shipping_address2_19,
o0_.shipping_city AS shipping_city_20,
o0_.shipping_state AS shipping_state_21,
o0_.shipping_zip_code AS shipping_zip_code_22,
o0_.shipping_country AS shipping_country_23,
o0_.subtotal AS subtotal_24,
o0_.total AS total_25,
o0_.discount AS discount_26,
o0_.billing_first_name AS billing_first_name_27,
o0_.billing_last_name AS billing_last_name_28,
o0_.billing_company AS billing_company_29,
o0_.billing_phone AS billing_phone_30,
o0_.billing_email AS billing_email_31,
o0_.coupon AS coupon_32,
o0_.abandon_time AS abandon_time_33,
o0_.source AS source_34,
o0_.deleted AS deleted_35,
o0_.deleted_by AS deleted_by_36,
o0_.deleted_time AS deleted_time_37,
m1_.id AS id_38,
m1_.name AS name_39,
m1_.first_name AS first_name_40,
m1_.last_name AS last_name_41,
m1_.email AS email_42,
m1_.phone AS phone_43,
m1_.fei AS fei_44,
m1_.street AS street_45,
m1_.city AS city_46,
m1_.state AS state_47,
m1_.zip AS zip_48,
m1_.industry AS industry_49,
m1_.ethnicity AS ethnicity_50,
m1_.external_id AS external_id_51,
m1_.revenue AS revenue_52,
m1_.type AS type_53,
m1_.gender AS gender_54,
m1_.business_type AS business_type_55,
m1_.business_structure AS business_structure_56,
m1_.geographic_market AS geographic_market_57,
m1_.description AS description_58,
m1_.naics AS naics_59,
m1_.nigp AS nigp_60,
m1_.keywords AS keywords_61,
m1_.certifications AS certifications_62,
m1_.certification_entity AS certification_entity_63,
m1_.certification_type AS certification_type_64,
m1_.certification_date AS certification_date_65,
m1_.year_established AS year_established_66,
m1_.qualify_status AS qualify_status_67,
m1_.website AS website_68,
m1_.employees AS employees_69,
m1_.status AS status_70,
m1_.revenue_class AS revenue_class_71,
m1_.rating AS rating_72,
m1_.your_industry AS your_industry_73,
m1_.professional_licenses AS professional_licenses_74,
m1_.dba AS dba_75,
m1_.created_at AS created_at_76,
m1_.modified_at AS modified_at_77,
m1_.senate AS senate_78,
m1_.house_of_representatives AS house_of_representatives_79,
m1_.congressional AS congressional_80,
m1_.commissioner AS commissioner_81,
m1_.school_board AS school_board_82,
m1_.city_council AS city_council_83,
m1_.deleted AS deleted_84,
o0_.assigned_user_id AS assigned_user_id_85,
o0_.assigned_member_id AS assigned_member_id_86
FROM
`order` o0_
LEFT JOIN member m1_ ON o0_.assigned_member_id = m1_.id
ORDER BY
o0_.id ASC
LIMIT
20 OFFSET 180
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.order_no AS order_no_2, o0_.status AS status_3, o0_.payment_status AS payment_status_4, o0_.created_at AS created_at_5, o0_.edited_at AS edited_at_6, o0_.description AS description_7, o0_.type AS type_8, o0_.payment_method AS payment_method_9, o0_.payment_method_id AS payment_method_id_10, o0_.payment_info AS payment_info_11, o0_.billing_address1 AS billing_address1_12, o0_.billing_address2 AS billing_address2_13, o0_.billing_city AS billing_city_14, o0_.billing_state AS billing_state_15, o0_.billing_zip_code AS billing_zip_code_16, o0_.billing_country AS billing_country_17, o0_.shipping_address1 AS shipping_address1_18, o0_.shipping_address2 AS shipping_address2_19, o0_.shipping_city AS shipping_city_20, o0_.shipping_state AS shipping_state_21, o0_.shipping_zip_code AS shipping_zip_code_22, o0_.shipping_country AS shipping_country_23, o0_.subtotal AS subtotal_24, o0_.total AS total_25, o0_.discount AS discount_26, o0_.billing_first_name AS billing_first_name_27, o0_.billing_last_name AS billing_last_name_28, o0_.billing_company AS billing_company_29, o0_.billing_phone AS billing_phone_30, o0_.billing_email AS billing_email_31, o0_.coupon AS coupon_32, o0_.abandon_time AS abandon_time_33, o0_.source AS source_34, o0_.deleted AS deleted_35, o0_.deleted_by AS deleted_by_36, o0_.deleted_time AS deleted_time_37, m1_.id AS id_38, m1_.name AS name_39, m1_.first_name AS first_name_40, m1_.last_name AS last_name_41, m1_.email AS email_42, m1_.phone AS phone_43, m1_.fei AS fei_44, m1_.street AS street_45, m1_.city AS city_46, m1_.state AS state_47, m1_.zip AS zip_48, m1_.industry AS industry_49, m1_.ethnicity AS ethnicity_50, m1_.external_id AS external_id_51, m1_.revenue AS revenue_52, m1_.type AS type_53, m1_.gender AS gender_54, m1_.business_type AS business_type_55, m1_.business_structure AS business_structure_56, m1_.geographic_market AS geographic_market_57, m1_.description AS description_58, m1_.naics AS naics_59, m1_.nigp AS nigp_60, m1_.keywords AS keywords_61, m1_.certifications AS certifications_62, m1_.certification_entity AS certification_entity_63, m1_.certification_type AS certification_type_64, m1_.certification_date AS certification_date_65, m1_.year_established AS year_established_66, m1_.qualify_status AS qualify_status_67, m1_.website AS website_68, m1_.employees AS employees_69, m1_.status AS status_70, m1_.revenue_class AS revenue_class_71, m1_.rating AS rating_72, m1_.your_industry AS your_industry_73, m1_.professional_licenses AS professional_licenses_74, m1_.dba AS dba_75, m1_.created_at AS created_at_76, m1_.modified_at AS modified_at_77, m1_.senate AS senate_78, m1_.house_of_representatives AS house_of_representatives_79, m1_.congressional AS congressional_80, m1_.commissioner AS commissioner_81, m1_.school_board AS school_board_82, m1_.city_council AS city_council_83, m1_.deleted AS deleted_84, o0_.assigned_user_id AS assigned_user_id_85, o0_.assigned_member_id AS assigned_member_id_86 FROM `order` o0_ LEFT JOIN member m1_ ON o0_.assigned_member_id = m1_.id ORDER BY o0_.id ASC LIMIT 20 OFFSET 180;
|