https://sistema.dgautomotores.com.ar/car/sale/indexJson Return to referer URL

Method
POST
HTTP Status
200
IP
181.98.128.191
Profiled on
Token
5e4984

Query Metrics

3 Database Queries
3 Different statements
11.80 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.96 ms 
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.agency_days_notification AS agency_days_notification_10, t0.allow_user AS allow_user_11, t0.allow_clients AS allow_clients_12, t0.allow_vehicles AS allow_vehicles_13, t0.allow_vehicles_buys AS allow_vehicles_buys_14, t0.allow_vehicles_sales AS allow_vehicles_sales_15, t0.allow_vehicles_resales AS allow_vehicles_resales_16, t0.allow_agency AS allow_agency_17, t0.allow_administration AS allow_administration_18, t0.allow_transfers AS allow_transfers_19, t0.allow_system AS allow_system_20, t0.cellphone AS cellphone_21, t0.profile_id AS profile_id_22 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
2 6.99 ms 
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 ((c1_.is_done = 1 AND MONTH(c1_.is_done_date) = MONTH(CURRENT_DATE) AND YEAR(c1_.is_done_date) = YEAR(CURRENT_DATE)) OR c1_.is_done = 0)
Parameters: 
[
  "0"
]
View formatted query    View runnable query    Explain query
3 3.86 ms 
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 ((c1_.is_done = 1 AND MONTH(c1_.is_done_date) = MONTH(CURRENT_DATE) AND YEAR(c1_.is_done_date) = YEAR(CURRENT_DATE)) OR c1_.is_done = 0) ORDER BY c1_.is_done DESC, c1_.is_done_date ASC LIMIT 10
Parameters: 
[
  "0"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Profile No errors.
App\Entity\CarBuy No errors.
App\Entity\CarSale No errors.
App\Entity\Client No errors.
App\Entity\CarResale No errors.
App\Entity\Car No errors.
App\Entity\CarSaleCarPayment No errors.
App\Entity\CarSaleBankCheck No errors.
App\Entity\Agency No errors.
App\Entity\Brand No errors.
App\Entity\Branches No errors.
App\Entity\Destinations No errors.