35.25 ms
(50.98%)
|
1 |
SELECT a0_.enabled_notification AS enabled_notification_0, a0_.status AS status_1, c1_.id AS id_2, c1_.price AS price_3, c1_.origin AS origin_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c1_.money_advance AS money_advance_7, c1_.cash AS cash_8, c1_.credit AS credit_9, c1_.bank_check AS bank_check_10, c1_.bank_check_detail AS bank_check_detail_11, c1_.is_done AS is_done_12, c1_.currency AS currency_13, c1_.is_done_date AS is_done_date_14, c1_.signaled_date AS signaled_date_15, c1_.costs_transfer AS costs_transfer_16, c1_.costs_delivery AS costs_delivery_17, c1_.costs_pledge AS costs_pledge_18, c1_.costs_bank_sealing AS costs_bank_sealing_19, c1_.costs_rents AS costs_rents_20, c1_.exchange_rate_usd AS exchange_rate_usd_21, c1_.exchange_rate_eur AS exchange_rate_eur_22, c1_.description AS description_23, c1_.is_group_sale AS is_group_sale_24, c1_.group_sale AS group_sale_25, c1_.money_advance_currency AS money_advance_currency_26, c1_.cash_currency AS cash_currency_27, c1_.receipt_generated AS receipt_generated_28, c1_.procedure_location AS procedure_location_29, c1_.procedure_date AS procedure_date_30, c1_.procedure_time AS procedure_time_31, c1_.procedure_days AS procedure_days_32, c1_.balance AS balance_33, c1_.cash_multiple AS cash_multiple_34, c1_.money_advance_multiple AS money_advance_multiple_35, c1_.fecha_facturacion AS fecha_facturacion_36, c2_.id AS id_37, c2_.name AS name_38, c2_.year AS year_39, c2_.description AS description_40, c2_.created_at AS created_at_41, c2_.updated_at AS updated_at_42, c2_.km AS km_43, c2_.patent AS patent_44, c2_.price_purchase AS price_purchase_45, c2_.price_sale AS price_sale_46, c2_.price_currency_purchase AS price_currency_purchase_47, c2_.price_currency_sale AS price_currency_sale_48, c2_.features AS features_49, c2_.status AS status_50, c2_.engine_number AS engine_number_51, c2_.chassis_number AS chassis_number_52, c2_.type AS type_53, c2_.settlement AS settlement_54, c2_.position AS position_55, c2_.features_infoauto AS features_infoauto_56, c2_.color AS color_57, c2_.is_opportunity AS is_opportunity_58, c2_.is_0km AS is_0km_59, c2_.is_immediate_delivery AS is_immediate_delivery_60, c2_.is_consignacion AS is_consignacion_61, c2_.is_active AS is_active_62, c3_.id AS id_63, c3_.description AS description_64, c3_.created_at AS created_at_65, c3_.update_at AS update_at_66, c4_.id AS id_67, c4_.amount AS amount_68, c4_.detail AS detail_69, c5_.id AS id_70, c5_.name AS name_71, c5_.year AS year_72, c5_.description AS description_73, c5_.created_at AS created_at_74, c5_.updated_at AS updated_at_75, c5_.km AS km_76, c5_.patent AS patent_77, c5_.price_purchase AS price_purchase_78, c5_.price_sale AS price_sale_79, c5_.price_currency_purchase AS price_currency_purchase_80, c5_.price_currency_sale AS price_currency_sale_81, c5_.features AS features_82, c5_.status AS status_83, c5_.engine_number AS engine_number_84, c5_.chassis_number AS chassis_number_85, c5_.type AS type_86, c5_.settlement AS settlement_87, c5_.position AS position_88, c5_.features_infoauto AS features_infoauto_89, c5_.color AS color_90, c5_.is_opportunity AS is_opportunity_91, c5_.is_0km AS is_0km_92, c5_.is_immediate_delivery AS is_immediate_delivery_93, c5_.is_consignacion AS is_consignacion_94, c5_.is_active AS is_active_95, u6_.id AS id_96, u6_.first_name AS first_name_97, u6_.last_name AS last_name_98, u6_.email AS email_99, u6_.roles AS roles_100, u6_.password AS password_101, u6_.image AS image_102, u6_.created_at AS created_at_103, u6_.updated_at AS updated_at_104, u6_.agency_days_notification AS agency_days_notification_105, u6_.allow_user AS allow_user_106, u6_.allow_clients AS allow_clients_107, u6_.allow_vehicles AS allow_vehicles_108, u6_.allow_vehicles_buys AS allow_vehicles_buys_109, u6_.allow_vehicles_sales AS allow_vehicles_sales_110, u6_.allow_vehicles_resales AS allow_vehicles_resales_111, u6_.allow_agency AS allow_agency_112, u6_.allow_administration AS allow_administration_113, u6_.allow_transfers AS allow_transfers_114, u6_.allow_system AS allow_system_115, u6_.cellphone AS cellphone_116, c7_.id AS id_117, c7_.first_name AS first_name_118, c7_.last_name AS last_name_119, c7_.condicion_fiscal AS condicion_fiscal_120, c7_.dni AS dni_121, c7_.telephone AS telephone_122, c7_.cellphone AS cellphone_123, c7_.address AS address_124, c7_.address_number AS address_number_125, c7_.address_floor AS address_floor_126, c7_.address_apartment AS address_apartment_127, c7_.location AS location_128, c7_.state AS state_129, c7_.origin AS origin_130, c7_.description AS description_131, c7_.notify_by_email AS notify_by_email_132, c7_.notify_by_whatsapp AS notify_by_whatsapp_133, c7_.notify_vehicle_entry AS notify_vehicle_entry_134, c7_.notify_criteria AS notify_criteria_135, c7_.created_at AS created_at_136, c7_.updated_at AS updated_at_137, c7_.email AS email_138, c7_.licence_venc AS licence_venc_139, c1_.car_sale_id AS car_sale_id_140, c1_.user_id AS user_id_141, c1_.car_sale_payment_id AS car_sale_payment_id_142, c1_.client_id AS client_id_143, c2_.updated_by_id AS updated_by_id_144, c2_.brand_id AS brand_id_145, c2_.branches_id AS branches_id_146, c2_.destination_id AS destination_id_147, c3_.car_sale_pay_id AS car_sale_pay_id_148, c3_.car_id AS car_id_149, c4_.car_sale_id AS car_sale_id_150, c5_.updated_by_id AS updated_by_id_151, c5_.brand_id AS brand_id_152, c5_.branches_id AS branches_id_153, c5_.destination_id AS destination_id_154, u6_.profile_id AS profile_id_155, c7_.user_id AS user_id_156 FROM car_sale c1_ LEFT JOIN car c2_ ON c1_.car_sale_id = c2_.id LEFT JOIN car_sale_car_payment c3_ ON c1_.id = c3_.car_sale_pay_id LEFT JOIN car_sale_bank_check c4_ ON c1_.id = c4_.car_sale_id LEFT JOIN car c5_ ON c3_.car_id = c5_.id LEFT JOIN user u6_ ON c1_.user_id = u6_.id LEFT JOIN client c7_ ON c1_.client_id = c7_.id LEFT JOIN agency a0_ ON (c1_.id = a0_.sale_id) WHERE c1_.id > ? AND (c2_.name LIKE ? OR c2_.patent LIKE ? OR u6_.first_name LIKE ? OR u6_.last_name LIKE ? OR c1_.price LIKE ? OR c1_.origin LIKE ?) ORDER BY c1_.is_done DESC, c1_.is_done_date ASC LIMIT 10 OFFSET 10
Parameters: [
"0"
"%hr-v%"
"%hr-v%"
"%hr-v%"
"%hr-v%"
"%hr-v%"
"%hr-v%"
]
SELECT
a0_.enabled_notification AS enabled_notification_0,
a0_.status AS status_1,
c1_.id AS id_2,
c1_.price AS price_3,
c1_.origin AS origin_4,
c1_.created_at AS created_at_5,
c1_.updated_at AS updated_at_6,
c1_.money_advance AS money_advance_7,
c1_.cash AS cash_8,
c1_.credit AS credit_9,
c1_.bank_check AS bank_check_10,
c1_.bank_check_detail AS bank_check_detail_11,
c1_.is_done AS is_done_12,
c1_.currency AS currency_13,
c1_.is_done_date AS is_done_date_14,
c1_.signaled_date AS signaled_date_15,
c1_.costs_transfer AS costs_transfer_16,
c1_.costs_delivery AS costs_delivery_17,
c1_.costs_pledge AS costs_pledge_18,
c1_.costs_bank_sealing AS costs_bank_sealing_19,
c1_.costs_rents AS costs_rents_20,
c1_.exchange_rate_usd AS exchange_rate_usd_21,
c1_.exchange_rate_eur AS exchange_rate_eur_22,
c1_.description AS description_23,
c1_.is_group_sale AS is_group_sale_24,
c1_.group_sale AS group_sale_25,
c1_.money_advance_currency AS money_advance_currency_26,
c1_.cash_currency AS cash_currency_27,
c1_.receipt_generated AS receipt_generated_28,
c1_.procedure_location AS procedure_location_29,
c1_.procedure_date AS procedure_date_30,
c1_.procedure_time AS procedure_time_31,
c1_.procedure_days AS procedure_days_32,
c1_.balance AS balance_33,
c1_.cash_multiple AS cash_multiple_34,
c1_.money_advance_multiple AS money_advance_multiple_35,
c1_.fecha_facturacion AS fecha_facturacion_36,
c2_.id AS id_37,
c2_.name AS name_38,
c2_.year AS year_39,
c2_.description AS description_40,
c2_.created_at AS created_at_41,
c2_.updated_at AS updated_at_42,
c2_.km AS km_43,
c2_.patent AS patent_44,
c2_.price_purchase AS price_purchase_45,
c2_.price_sale AS price_sale_46,
c2_.price_currency_purchase AS price_currency_purchase_47,
c2_.price_currency_sale AS price_currency_sale_48,
c2_.features AS features_49,
c2_.status AS status_50,
c2_.engine_number AS engine_number_51,
c2_.chassis_number AS chassis_number_52,
c2_.type AS type_53,
c2_.settlement AS settlement_54,
c2_.position AS position_55,
c2_.features_infoauto AS features_infoauto_56,
c2_.color AS color_57,
c2_.is_opportunity AS is_opportunity_58,
c2_.is_0km AS is_0km_59,
c2_.is_immediate_delivery AS is_immediate_delivery_60,
c2_.is_consignacion AS is_consignacion_61,
c2_.is_active AS is_active_62,
c3_.id AS id_63,
c3_.description AS description_64,
c3_.created_at AS created_at_65,
c3_.update_at AS update_at_66,
c4_.id AS id_67,
c4_.amount AS amount_68,
c4_.detail AS detail_69,
c5_.id AS id_70,
c5_.name AS name_71,
c5_.year AS year_72,
c5_.description AS description_73,
c5_.created_at AS created_at_74,
c5_.updated_at AS updated_at_75,
c5_.km AS km_76,
c5_.patent AS patent_77,
c5_.price_purchase AS price_purchase_78,
c5_.price_sale AS price_sale_79,
c5_.price_currency_purchase AS price_currency_purchase_80,
c5_.price_currency_sale AS price_currency_sale_81,
c5_.features AS features_82,
c5_.status AS status_83,
c5_.engine_number AS engine_number_84,
c5_.chassis_number AS chassis_number_85,
c5_.type AS type_86,
c5_.settlement AS settlement_87,
c5_.position AS position_88,
c5_.features_infoauto AS features_infoauto_89,
c5_.color AS color_90,
c5_.is_opportunity AS is_opportunity_91,
c5_.is_0km AS is_0km_92,
c5_.is_immediate_delivery AS is_immediate_delivery_93,
c5_.is_consignacion AS is_consignacion_94,
c5_.is_active AS is_active_95,
u6_.id AS id_96,
u6_.first_name AS first_name_97,
u6_.last_name AS last_name_98,
u6_.email AS email_99,
u6_.roles AS roles_100,
u6_.password AS password_101,
u6_.image AS image_102,
u6_.created_at AS created_at_103,
u6_.updated_at AS updated_at_104,
u6_.agency_days_notification AS agency_days_notification_105,
u6_.allow_user AS allow_user_106,
u6_.allow_clients AS allow_clients_107,
u6_.allow_vehicles AS allow_vehicles_108,
u6_.allow_vehicles_buys AS allow_vehicles_buys_109,
u6_.allow_vehicles_sales AS allow_vehicles_sales_110,
u6_.allow_vehicles_resales AS allow_vehicles_resales_111,
u6_.allow_agency AS allow_agency_112,
u6_.allow_administration AS allow_administration_113,
u6_.allow_transfers AS allow_transfers_114,
u6_.allow_system AS allow_system_115,
u6_.cellphone AS cellphone_116,
c7_.id AS id_117,
c7_.first_name AS first_name_118,
c7_.last_name AS last_name_119,
c7_.condicion_fiscal AS condicion_fiscal_120,
c7_.dni AS dni_121,
c7_.telephone AS telephone_122,
c7_.cellphone AS cellphone_123,
c7_.address AS address_124,
c7_.address_number AS address_number_125,
c7_.address_floor AS address_floor_126,
c7_.address_apartment AS address_apartment_127,
c7_.location AS location_128,
c7_.state AS state_129,
c7_.origin AS origin_130,
c7_.description AS description_131,
c7_.notify_by_email AS notify_by_email_132,
c7_.notify_by_whatsapp AS notify_by_whatsapp_133,
c7_.notify_vehicle_entry AS notify_vehicle_entry_134,
c7_.notify_criteria AS notify_criteria_135,
c7_.created_at AS created_at_136,
c7_.updated_at AS updated_at_137,
c7_.email AS email_138,
c7_.licence_venc AS licence_venc_139,
c1_.car_sale_id AS car_sale_id_140,
c1_.user_id AS user_id_141,
c1_.car_sale_payment_id AS car_sale_payment_id_142,
c1_.client_id AS client_id_143,
c2_.updated_by_id AS updated_by_id_144,
c2_.brand_id AS brand_id_145,
c2_.branches_id AS branches_id_146,
c2_.destination_id AS destination_id_147,
c3_.car_sale_pay_id AS car_sale_pay_id_148,
c3_.car_id AS car_id_149,
c4_.car_sale_id AS car_sale_id_150,
c5_.updated_by_id AS updated_by_id_151,
c5_.brand_id AS brand_id_152,
c5_.branches_id AS branches_id_153,
c5_.destination_id AS destination_id_154,
u6_.profile_id AS profile_id_155,
c7_.user_id AS user_id_156
FROM
car_sale c1_
LEFT JOIN car c2_ ON c1_.car_sale_id = c2_.id
LEFT JOIN car_sale_car_payment c3_ ON c1_.id = c3_.car_sale_pay_id
LEFT JOIN car_sale_bank_check c4_ ON c1_.id = c4_.car_sale_id
LEFT JOIN car c5_ ON c3_.car_id = c5_.id
LEFT JOIN user u6_ ON c1_.user_id = u6_.id
LEFT JOIN client c7_ ON c1_.client_id = c7_.id
LEFT JOIN agency a0_ ON (c1_.id = a0_.sale_id)
WHERE
c1_.id > ?
AND (
c2_.name LIKE ?
OR c2_.patent LIKE ?
OR u6_.first_name LIKE ?
OR u6_.last_name LIKE ?
OR c1_.price LIKE ?
OR c1_.origin LIKE ?
)
ORDER BY
c1_.is_done DESC,
c1_.is_done_date ASC
LIMIT
10
OFFSET
10
SELECT a0_.enabled_notification AS enabled_notification_0, a0_.status AS status_1, c1_.id AS id_2, c1_.price AS price_3, c1_.origin AS origin_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c1_.money_advance AS money_advance_7, c1_.cash AS cash_8, c1_.credit AS credit_9, c1_.bank_check AS bank_check_10, c1_.bank_check_detail AS bank_check_detail_11, c1_.is_done AS is_done_12, c1_.currency AS currency_13, c1_.is_done_date AS is_done_date_14, c1_.signaled_date AS signaled_date_15, c1_.costs_transfer AS costs_transfer_16, c1_.costs_delivery AS costs_delivery_17, c1_.costs_pledge AS costs_pledge_18, c1_.costs_bank_sealing AS costs_bank_sealing_19, c1_.costs_rents AS costs_rents_20, c1_.exchange_rate_usd AS exchange_rate_usd_21, c1_.exchange_rate_eur AS exchange_rate_eur_22, c1_.description AS description_23, c1_.is_group_sale AS is_group_sale_24, c1_.group_sale AS group_sale_25, c1_.money_advance_currency AS money_advance_currency_26, c1_.cash_currency AS cash_currency_27, c1_.receipt_generated AS receipt_generated_28, c1_.procedure_location AS procedure_location_29, c1_.procedure_date AS procedure_date_30, c1_.procedure_time AS procedure_time_31, c1_.procedure_days AS procedure_days_32, c1_.balance AS balance_33, c1_.cash_multiple AS cash_multiple_34, c1_.money_advance_multiple AS money_advance_multiple_35, c1_.fecha_facturacion AS fecha_facturacion_36, c2_.id AS id_37, c2_.name AS name_38, c2_.year AS year_39, c2_.description AS description_40, c2_.created_at AS created_at_41, c2_.updated_at AS updated_at_42, c2_.km AS km_43, c2_.patent AS patent_44, c2_.price_purchase AS price_purchase_45, c2_.price_sale AS price_sale_46, c2_.price_currency_purchase AS price_currency_purchase_47, c2_.price_currency_sale AS price_currency_sale_48, c2_.features AS features_49, c2_.status AS status_50, c2_.engine_number AS engine_number_51, c2_.chassis_number AS chassis_number_52, c2_.type AS type_53, c2_.settlement AS settlement_54, c2_.position AS position_55, c2_.features_infoauto AS features_infoauto_56, c2_.color AS color_57, c2_.is_opportunity AS is_opportunity_58, c2_.is_0km AS is_0km_59, c2_.is_immediate_delivery AS is_immediate_delivery_60, c2_.is_consignacion AS is_consignacion_61, c2_.is_active AS is_active_62, c3_.id AS id_63, c3_.description AS description_64, c3_.created_at AS created_at_65, c3_.update_at AS update_at_66, c4_.id AS id_67, c4_.amount AS amount_68, c4_.detail AS detail_69, c5_.id AS id_70, c5_.name AS name_71, c5_.year AS year_72, c5_.description AS description_73, c5_.created_at AS created_at_74, c5_.updated_at AS updated_at_75, c5_.km AS km_76, c5_.patent AS patent_77, c5_.price_purchase AS price_purchase_78, c5_.price_sale AS price_sale_79, c5_.price_currency_purchase AS price_currency_purchase_80, c5_.price_currency_sale AS price_currency_sale_81, c5_.features AS features_82, c5_.status AS status_83, c5_.engine_number AS engine_number_84, c5_.chassis_number AS chassis_number_85, c5_.type AS type_86, c5_.settlement AS settlement_87, c5_.position AS position_88, c5_.features_infoauto AS features_infoauto_89, c5_.color AS color_90, c5_.is_opportunity AS is_opportunity_91, c5_.is_0km AS is_0km_92, c5_.is_immediate_delivery AS is_immediate_delivery_93, c5_.is_consignacion AS is_consignacion_94, c5_.is_active AS is_active_95, u6_.id AS id_96, u6_.first_name AS first_name_97, u6_.last_name AS last_name_98, u6_.email AS email_99, u6_.roles AS roles_100, u6_.password AS password_101, u6_.image AS image_102, u6_.created_at AS created_at_103, u6_.updated_at AS updated_at_104, u6_.agency_days_notification AS agency_days_notification_105, u6_.allow_user AS allow_user_106, u6_.allow_clients AS allow_clients_107, u6_.allow_vehicles AS allow_vehicles_108, u6_.allow_vehicles_buys AS allow_vehicles_buys_109, u6_.allow_vehicles_sales AS allow_vehicles_sales_110, u6_.allow_vehicles_resales AS allow_vehicles_resales_111, u6_.allow_agency AS allow_agency_112, u6_.allow_administration AS allow_administration_113, u6_.allow_transfers AS allow_transfers_114, u6_.allow_system AS allow_system_115, u6_.cellphone AS cellphone_116, c7_.id AS id_117, c7_.first_name AS first_name_118, c7_.last_name AS last_name_119, c7_.condicion_fiscal AS condicion_fiscal_120, c7_.dni AS dni_121, c7_.telephone AS telephone_122, c7_.cellphone AS cellphone_123, c7_.address AS address_124, c7_.address_number AS address_number_125, c7_.address_floor AS address_floor_126, c7_.address_apartment AS address_apartment_127, c7_.location AS location_128, c7_.state AS state_129, c7_.origin AS origin_130, c7_.description AS description_131, c7_.notify_by_email AS notify_by_email_132, c7_.notify_by_whatsapp AS notify_by_whatsapp_133, c7_.notify_vehicle_entry AS notify_vehicle_entry_134, c7_.notify_criteria AS notify_criteria_135, c7_.created_at AS created_at_136, c7_.updated_at AS updated_at_137, c7_.email AS email_138, c7_.licence_venc AS licence_venc_139, c1_.car_sale_id AS car_sale_id_140, c1_.user_id AS user_id_141, c1_.car_sale_payment_id AS car_sale_payment_id_142, c1_.client_id AS client_id_143, c2_.updated_by_id AS updated_by_id_144, c2_.brand_id AS brand_id_145, c2_.branches_id AS branches_id_146, c2_.destination_id AS destination_id_147, c3_.car_sale_pay_id AS car_sale_pay_id_148, c3_.car_id AS car_id_149, c4_.car_sale_id AS car_sale_id_150, c5_.updated_by_id AS updated_by_id_151, c5_.brand_id AS brand_id_152, c5_.branches_id AS branches_id_153, c5_.destination_id AS destination_id_154, u6_.profile_id AS profile_id_155, c7_.user_id AS user_id_156 FROM car_sale c1_ LEFT JOIN car c2_ ON c1_.car_sale_id = c2_.id LEFT JOIN car_sale_car_payment c3_ ON c1_.id = c3_.car_sale_pay_id LEFT JOIN car_sale_bank_check c4_ ON c1_.id = c4_.car_sale_id LEFT JOIN car c5_ ON c3_.car_id = c5_.id LEFT JOIN user u6_ ON c1_.user_id = u6_.id LEFT JOIN client c7_ ON c1_.client_id = c7_.id LEFT JOIN agency a0_ ON (c1_.id = a0_.sale_id) WHERE c1_.id > '0' AND (c2_.name LIKE '%hr-v%' OR c2_.patent LIKE '%hr-v%' OR u6_.first_name LIKE '%hr-v%' OR u6_.last_name LIKE '%hr-v%' OR c1_.price LIKE '%hr-v%' OR c1_.origin LIKE '%hr-v%') ORDER BY c1_.is_done DESC, c1_.is_done_date ASC LIMIT 10 OFFSET 10;
|
32.84 ms
(47.49%)
|
1 |
SELECT a0_.enabled_notification AS enabled_notification_0, a0_.status AS status_1, c1_.id AS id_2, c1_.price AS price_3, c1_.origin AS origin_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c1_.money_advance AS money_advance_7, c1_.cash AS cash_8, c1_.credit AS credit_9, c1_.bank_check AS bank_check_10, c1_.bank_check_detail AS bank_check_detail_11, c1_.is_done AS is_done_12, c1_.currency AS currency_13, c1_.is_done_date AS is_done_date_14, c1_.signaled_date AS signaled_date_15, c1_.costs_transfer AS costs_transfer_16, c1_.costs_delivery AS costs_delivery_17, c1_.costs_pledge AS costs_pledge_18, c1_.costs_bank_sealing AS costs_bank_sealing_19, c1_.costs_rents AS costs_rents_20, c1_.exchange_rate_usd AS exchange_rate_usd_21, c1_.exchange_rate_eur AS exchange_rate_eur_22, c1_.description AS description_23, c1_.is_group_sale AS is_group_sale_24, c1_.group_sale AS group_sale_25, c1_.money_advance_currency AS money_advance_currency_26, c1_.cash_currency AS cash_currency_27, c1_.receipt_generated AS receipt_generated_28, c1_.procedure_location AS procedure_location_29, c1_.procedure_date AS procedure_date_30, c1_.procedure_time AS procedure_time_31, c1_.procedure_days AS procedure_days_32, c1_.balance AS balance_33, c1_.cash_multiple AS cash_multiple_34, c1_.money_advance_multiple AS money_advance_multiple_35, c1_.fecha_facturacion AS fecha_facturacion_36, c2_.id AS id_37, c2_.name AS name_38, c2_.year AS year_39, c2_.description AS description_40, c2_.created_at AS created_at_41, c2_.updated_at AS updated_at_42, c2_.km AS km_43, c2_.patent AS patent_44, c2_.price_purchase AS price_purchase_45, c2_.price_sale AS price_sale_46, c2_.price_currency_purchase AS price_currency_purchase_47, c2_.price_currency_sale AS price_currency_sale_48, c2_.features AS features_49, c2_.status AS status_50, c2_.engine_number AS engine_number_51, c2_.chassis_number AS chassis_number_52, c2_.type AS type_53, c2_.settlement AS settlement_54, c2_.position AS position_55, c2_.features_infoauto AS features_infoauto_56, c2_.color AS color_57, c2_.is_opportunity AS is_opportunity_58, c2_.is_0km AS is_0km_59, c2_.is_immediate_delivery AS is_immediate_delivery_60, c2_.is_consignacion AS is_consignacion_61, c2_.is_active AS is_active_62, c3_.id AS id_63, c3_.description AS description_64, c3_.created_at AS created_at_65, c3_.update_at AS update_at_66, c4_.id AS id_67, c4_.amount AS amount_68, c4_.detail AS detail_69, c5_.id AS id_70, c5_.name AS name_71, c5_.year AS year_72, c5_.description AS description_73, c5_.created_at AS created_at_74, c5_.updated_at AS updated_at_75, c5_.km AS km_76, c5_.patent AS patent_77, c5_.price_purchase AS price_purchase_78, c5_.price_sale AS price_sale_79, c5_.price_currency_purchase AS price_currency_purchase_80, c5_.price_currency_sale AS price_currency_sale_81, c5_.features AS features_82, c5_.status AS status_83, c5_.engine_number AS engine_number_84, c5_.chassis_number AS chassis_number_85, c5_.type AS type_86, c5_.settlement AS settlement_87, c5_.position AS position_88, c5_.features_infoauto AS features_infoauto_89, c5_.color AS color_90, c5_.is_opportunity AS is_opportunity_91, c5_.is_0km AS is_0km_92, c5_.is_immediate_delivery AS is_immediate_delivery_93, c5_.is_consignacion AS is_consignacion_94, c5_.is_active AS is_active_95, u6_.id AS id_96, u6_.first_name AS first_name_97, u6_.last_name AS last_name_98, u6_.email AS email_99, u6_.roles AS roles_100, u6_.password AS password_101, u6_.image AS image_102, u6_.created_at AS created_at_103, u6_.updated_at AS updated_at_104, u6_.agency_days_notification AS agency_days_notification_105, u6_.allow_user AS allow_user_106, u6_.allow_clients AS allow_clients_107, u6_.allow_vehicles AS allow_vehicles_108, u6_.allow_vehicles_buys AS allow_vehicles_buys_109, u6_.allow_vehicles_sales AS allow_vehicles_sales_110, u6_.allow_vehicles_resales AS allow_vehicles_resales_111, u6_.allow_agency AS allow_agency_112, u6_.allow_administration AS allow_administration_113, u6_.allow_transfers AS allow_transfers_114, u6_.allow_system AS allow_system_115, u6_.cellphone AS cellphone_116, c7_.id AS id_117, c7_.first_name AS first_name_118, c7_.last_name AS last_name_119, c7_.condicion_fiscal AS condicion_fiscal_120, c7_.dni AS dni_121, c7_.telephone AS telephone_122, c7_.cellphone AS cellphone_123, c7_.address AS address_124, c7_.address_number AS address_number_125, c7_.address_floor AS address_floor_126, c7_.address_apartment AS address_apartment_127, c7_.location AS location_128, c7_.state AS state_129, c7_.origin AS origin_130, c7_.description AS description_131, c7_.notify_by_email AS notify_by_email_132, c7_.notify_by_whatsapp AS notify_by_whatsapp_133, c7_.notify_vehicle_entry AS notify_vehicle_entry_134, c7_.notify_criteria AS notify_criteria_135, c7_.created_at AS created_at_136, c7_.updated_at AS updated_at_137, c7_.email AS email_138, c7_.licence_venc AS licence_venc_139 FROM car_sale c1_ LEFT JOIN car c2_ ON c1_.car_sale_id = c2_.id LEFT JOIN car_sale_car_payment c3_ ON c1_.id = c3_.car_sale_pay_id LEFT JOIN car_sale_bank_check c4_ ON c1_.id = c4_.car_sale_id LEFT JOIN car c5_ ON c3_.car_id = c5_.id LEFT JOIN user u6_ ON c1_.user_id = u6_.id LEFT JOIN client c7_ ON c1_.client_id = c7_.id LEFT JOIN agency a0_ ON (c1_.id = a0_.sale_id) WHERE c1_.id > ? AND (c2_.name LIKE ? OR c2_.patent LIKE ? OR u6_.first_name LIKE ? OR u6_.last_name LIKE ? OR c1_.price LIKE ? OR c1_.origin LIKE ?)
Parameters: [
"0"
"%hr-v%"
"%hr-v%"
"%hr-v%"
"%hr-v%"
"%hr-v%"
"%hr-v%"
]
SELECT
a0_.enabled_notification AS enabled_notification_0,
a0_.status AS status_1,
c1_.id AS id_2,
c1_.price AS price_3,
c1_.origin AS origin_4,
c1_.created_at AS created_at_5,
c1_.updated_at AS updated_at_6,
c1_.money_advance AS money_advance_7,
c1_.cash AS cash_8,
c1_.credit AS credit_9,
c1_.bank_check AS bank_check_10,
c1_.bank_check_detail AS bank_check_detail_11,
c1_.is_done AS is_done_12,
c1_.currency AS currency_13,
c1_.is_done_date AS is_done_date_14,
c1_.signaled_date AS signaled_date_15,
c1_.costs_transfer AS costs_transfer_16,
c1_.costs_delivery AS costs_delivery_17,
c1_.costs_pledge AS costs_pledge_18,
c1_.costs_bank_sealing AS costs_bank_sealing_19,
c1_.costs_rents AS costs_rents_20,
c1_.exchange_rate_usd AS exchange_rate_usd_21,
c1_.exchange_rate_eur AS exchange_rate_eur_22,
c1_.description AS description_23,
c1_.is_group_sale AS is_group_sale_24,
c1_.group_sale AS group_sale_25,
c1_.money_advance_currency AS money_advance_currency_26,
c1_.cash_currency AS cash_currency_27,
c1_.receipt_generated AS receipt_generated_28,
c1_.procedure_location AS procedure_location_29,
c1_.procedure_date AS procedure_date_30,
c1_.procedure_time AS procedure_time_31,
c1_.procedure_days AS procedure_days_32,
c1_.balance AS balance_33,
c1_.cash_multiple AS cash_multiple_34,
c1_.money_advance_multiple AS money_advance_multiple_35,
c1_.fecha_facturacion AS fecha_facturacion_36,
c2_.id AS id_37,
c2_.name AS name_38,
c2_.year AS year_39,
c2_.description AS description_40,
c2_.created_at AS created_at_41,
c2_.updated_at AS updated_at_42,
c2_.km AS km_43,
c2_.patent AS patent_44,
c2_.price_purchase AS price_purchase_45,
c2_.price_sale AS price_sale_46,
c2_.price_currency_purchase AS price_currency_purchase_47,
c2_.price_currency_sale AS price_currency_sale_48,
c2_.features AS features_49,
c2_.status AS status_50,
c2_.engine_number AS engine_number_51,
c2_.chassis_number AS chassis_number_52,
c2_.type AS type_53,
c2_.settlement AS settlement_54,
c2_.position AS position_55,
c2_.features_infoauto AS features_infoauto_56,
c2_.color AS color_57,
c2_.is_opportunity AS is_opportunity_58,
c2_.is_0km AS is_0km_59,
c2_.is_immediate_delivery AS is_immediate_delivery_60,
c2_.is_consignacion AS is_consignacion_61,
c2_.is_active AS is_active_62,
c3_.id AS id_63,
c3_.description AS description_64,
c3_.created_at AS created_at_65,
c3_.update_at AS update_at_66,
c4_.id AS id_67,
c4_.amount AS amount_68,
c4_.detail AS detail_69,
c5_.id AS id_70,
c5_.name AS name_71,
c5_.year AS year_72,
c5_.description AS description_73,
c5_.created_at AS created_at_74,
c5_.updated_at AS updated_at_75,
c5_.km AS km_76,
c5_.patent AS patent_77,
c5_.price_purchase AS price_purchase_78,
c5_.price_sale AS price_sale_79,
c5_.price_currency_purchase AS price_currency_purchase_80,
c5_.price_currency_sale AS price_currency_sale_81,
c5_.features AS features_82,
c5_.status AS status_83,
c5_.engine_number AS engine_number_84,
c5_.chassis_number AS chassis_number_85,
c5_.type AS type_86,
c5_.settlement AS settlement_87,
c5_.position AS position_88,
c5_.features_infoauto AS features_infoauto_89,
c5_.color AS color_90,
c5_.is_opportunity AS is_opportunity_91,
c5_.is_0km AS is_0km_92,
c5_.is_immediate_delivery AS is_immediate_delivery_93,
c5_.is_consignacion AS is_consignacion_94,
c5_.is_active AS is_active_95,
u6_.id AS id_96,
u6_.first_name AS first_name_97,
u6_.last_name AS last_name_98,
u6_.email AS email_99,
u6_.roles AS roles_100,
u6_.password AS password_101,
u6_.image AS image_102,
u6_.created_at AS created_at_103,
u6_.updated_at AS updated_at_104,
u6_.agency_days_notification AS agency_days_notification_105,
u6_.allow_user AS allow_user_106,
u6_.allow_clients AS allow_clients_107,
u6_.allow_vehicles AS allow_vehicles_108,
u6_.allow_vehicles_buys AS allow_vehicles_buys_109,
u6_.allow_vehicles_sales AS allow_vehicles_sales_110,
u6_.allow_vehicles_resales AS allow_vehicles_resales_111,
u6_.allow_agency AS allow_agency_112,
u6_.allow_administration AS allow_administration_113,
u6_.allow_transfers AS allow_transfers_114,
u6_.allow_system AS allow_system_115,
u6_.cellphone AS cellphone_116,
c7_.id AS id_117,
c7_.first_name AS first_name_118,
c7_.last_name AS last_name_119,
c7_.condicion_fiscal AS condicion_fiscal_120,
c7_.dni AS dni_121,
c7_.telephone AS telephone_122,
c7_.cellphone AS cellphone_123,
c7_.address AS address_124,
c7_.address_number AS address_number_125,
c7_.address_floor AS address_floor_126,
c7_.address_apartment AS address_apartment_127,
c7_.location AS location_128,
c7_.state AS state_129,
c7_.origin AS origin_130,
c7_.description AS description_131,
c7_.notify_by_email AS notify_by_email_132,
c7_.notify_by_whatsapp AS notify_by_whatsapp_133,
c7_.notify_vehicle_entry AS notify_vehicle_entry_134,
c7_.notify_criteria AS notify_criteria_135,
c7_.created_at AS created_at_136,
c7_.updated_at AS updated_at_137,
c7_.email AS email_138,
c7_.licence_venc AS licence_venc_139
FROM
car_sale c1_
LEFT JOIN car c2_ ON c1_.car_sale_id = c2_.id
LEFT JOIN car_sale_car_payment c3_ ON c1_.id = c3_.car_sale_pay_id
LEFT JOIN car_sale_bank_check c4_ ON c1_.id = c4_.car_sale_id
LEFT JOIN car c5_ ON c3_.car_id = c5_.id
LEFT JOIN user u6_ ON c1_.user_id = u6_.id
LEFT JOIN client c7_ ON c1_.client_id = c7_.id
LEFT JOIN agency a0_ ON (c1_.id = a0_.sale_id)
WHERE
c1_.id > ?
AND (
c2_.name LIKE ?
OR c2_.patent LIKE ?
OR u6_.first_name LIKE ?
OR u6_.last_name LIKE ?
OR c1_.price LIKE ?
OR c1_.origin LIKE ?
)
SELECT a0_.enabled_notification AS enabled_notification_0, a0_.status AS status_1, c1_.id AS id_2, c1_.price AS price_3, c1_.origin AS origin_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c1_.money_advance AS money_advance_7, c1_.cash AS cash_8, c1_.credit AS credit_9, c1_.bank_check AS bank_check_10, c1_.bank_check_detail AS bank_check_detail_11, c1_.is_done AS is_done_12, c1_.currency AS currency_13, c1_.is_done_date AS is_done_date_14, c1_.signaled_date AS signaled_date_15, c1_.costs_transfer AS costs_transfer_16, c1_.costs_delivery AS costs_delivery_17, c1_.costs_pledge AS costs_pledge_18, c1_.costs_bank_sealing AS costs_bank_sealing_19, c1_.costs_rents AS costs_rents_20, c1_.exchange_rate_usd AS exchange_rate_usd_21, c1_.exchange_rate_eur AS exchange_rate_eur_22, c1_.description AS description_23, c1_.is_group_sale AS is_group_sale_24, c1_.group_sale AS group_sale_25, c1_.money_advance_currency AS money_advance_currency_26, c1_.cash_currency AS cash_currency_27, c1_.receipt_generated AS receipt_generated_28, c1_.procedure_location AS procedure_location_29, c1_.procedure_date AS procedure_date_30, c1_.procedure_time AS procedure_time_31, c1_.procedure_days AS procedure_days_32, c1_.balance AS balance_33, c1_.cash_multiple AS cash_multiple_34, c1_.money_advance_multiple AS money_advance_multiple_35, c1_.fecha_facturacion AS fecha_facturacion_36, c2_.id AS id_37, c2_.name AS name_38, c2_.year AS year_39, c2_.description AS description_40, c2_.created_at AS created_at_41, c2_.updated_at AS updated_at_42, c2_.km AS km_43, c2_.patent AS patent_44, c2_.price_purchase AS price_purchase_45, c2_.price_sale AS price_sale_46, c2_.price_currency_purchase AS price_currency_purchase_47, c2_.price_currency_sale AS price_currency_sale_48, c2_.features AS features_49, c2_.status AS status_50, c2_.engine_number AS engine_number_51, c2_.chassis_number AS chassis_number_52, c2_.type AS type_53, c2_.settlement AS settlement_54, c2_.position AS position_55, c2_.features_infoauto AS features_infoauto_56, c2_.color AS color_57, c2_.is_opportunity AS is_opportunity_58, c2_.is_0km AS is_0km_59, c2_.is_immediate_delivery AS is_immediate_delivery_60, c2_.is_consignacion AS is_consignacion_61, c2_.is_active AS is_active_62, c3_.id AS id_63, c3_.description AS description_64, c3_.created_at AS created_at_65, c3_.update_at AS update_at_66, c4_.id AS id_67, c4_.amount AS amount_68, c4_.detail AS detail_69, c5_.id AS id_70, c5_.name AS name_71, c5_.year AS year_72, c5_.description AS description_73, c5_.created_at AS created_at_74, c5_.updated_at AS updated_at_75, c5_.km AS km_76, c5_.patent AS patent_77, c5_.price_purchase AS price_purchase_78, c5_.price_sale AS price_sale_79, c5_.price_currency_purchase AS price_currency_purchase_80, c5_.price_currency_sale AS price_currency_sale_81, c5_.features AS features_82, c5_.status AS status_83, c5_.engine_number AS engine_number_84, c5_.chassis_number AS chassis_number_85, c5_.type AS type_86, c5_.settlement AS settlement_87, c5_.position AS position_88, c5_.features_infoauto AS features_infoauto_89, c5_.color AS color_90, c5_.is_opportunity AS is_opportunity_91, c5_.is_0km AS is_0km_92, c5_.is_immediate_delivery AS is_immediate_delivery_93, c5_.is_consignacion AS is_consignacion_94, c5_.is_active AS is_active_95, u6_.id AS id_96, u6_.first_name AS first_name_97, u6_.last_name AS last_name_98, u6_.email AS email_99, u6_.roles AS roles_100, u6_.password AS password_101, u6_.image AS image_102, u6_.created_at AS created_at_103, u6_.updated_at AS updated_at_104, u6_.agency_days_notification AS agency_days_notification_105, u6_.allow_user AS allow_user_106, u6_.allow_clients AS allow_clients_107, u6_.allow_vehicles AS allow_vehicles_108, u6_.allow_vehicles_buys AS allow_vehicles_buys_109, u6_.allow_vehicles_sales AS allow_vehicles_sales_110, u6_.allow_vehicles_resales AS allow_vehicles_resales_111, u6_.allow_agency AS allow_agency_112, u6_.allow_administration AS allow_administration_113, u6_.allow_transfers AS allow_transfers_114, u6_.allow_system AS allow_system_115, u6_.cellphone AS cellphone_116, c7_.id AS id_117, c7_.first_name AS first_name_118, c7_.last_name AS last_name_119, c7_.condicion_fiscal AS condicion_fiscal_120, c7_.dni AS dni_121, c7_.telephone AS telephone_122, c7_.cellphone AS cellphone_123, c7_.address AS address_124, c7_.address_number AS address_number_125, c7_.address_floor AS address_floor_126, c7_.address_apartment AS address_apartment_127, c7_.location AS location_128, c7_.state AS state_129, c7_.origin AS origin_130, c7_.description AS description_131, c7_.notify_by_email AS notify_by_email_132, c7_.notify_by_whatsapp AS notify_by_whatsapp_133, c7_.notify_vehicle_entry AS notify_vehicle_entry_134, c7_.notify_criteria AS notify_criteria_135, c7_.created_at AS created_at_136, c7_.updated_at AS updated_at_137, c7_.email AS email_138, c7_.licence_venc AS licence_venc_139 FROM car_sale c1_ LEFT JOIN car c2_ ON c1_.car_sale_id = c2_.id LEFT JOIN car_sale_car_payment c3_ ON c1_.id = c3_.car_sale_pay_id LEFT JOIN car_sale_bank_check c4_ ON c1_.id = c4_.car_sale_id LEFT JOIN car c5_ ON c3_.car_id = c5_.id LEFT JOIN user u6_ ON c1_.user_id = u6_.id LEFT JOIN client c7_ ON c1_.client_id = c7_.id LEFT JOIN agency a0_ ON (c1_.id = a0_.sale_id) WHERE c1_.id > '0' AND (c2_.name LIKE '%hr-v%' OR c2_.patent LIKE '%hr-v%' OR u6_.first_name LIKE '%hr-v%' OR u6_.last_name LIKE '%hr-v%' OR c1_.price LIKE '%hr-v%' OR c1_.origin LIKE '%hr-v%');
|