Query Metrics
22
Database Queries
4
Different statements
93.60 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.77 ms |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM besc b0_ INNER JOIN user u1_ ON b0_.created_by_id = u1_.id LEFT JOIN extra_reference e2_ ON b0_.temp_ref_id = e2_.id LEFT JOIN redressement r3_ ON b0_.redressement_id = r3_.id LEFT JOIN exoneration e4_ ON b0_.exoneration_id = e4_.id LEFT JOIN besc_mask b5_ ON b0_.id = b5_.besc_id
Parameters:
[] |
| 2 | 69.03 ms |
SELECT b0_.id AS id_0, b0_.demande AS demande_1, b0_.number AS number_2, b0_.mode AS mode_3, b0_.sens AS sens_4, b0_.valeur AS valeur_5, b0_.valeur_finale AS valeur_finale_6, b0_.devise_valeur AS devise_valeur_7, b0_.reference_doc_number AS reference_doc_number_8, b0_.reference_doc_child_number AS reference_doc_child_number_9, b0_.shipper AS shipper_10, b0_.foreign_shipper AS foreign_shipper_11, b0_.forwarding_agent AS forwarding_agent_12, b0_.carrier AS carrier_13, b0_.country_of_origin AS country_of_origin_14, b0_.country_of_loading AS country_of_loading_15, b0_.port_of_loading AS port_of_loading_16, b0_.country_of_discharge AS country_of_discharge_17, b0_.port_of_discharge AS port_of_discharge_18, b0_.final_destination AS final_destination_19, b0_.loaded_at AS loaded_at_20, b0_.discharged_at AS discharged_at_21, b0_.eta AS eta_22, b0_.ata AS ata_23, b0_.etd AS etd_24, b0_.atd AS atd_25, b0_.incoterm AS incoterm_26, b0_.vessel AS vessel_27, b0_.voyage AS voyage_28, b0_.freight AS freight_29, b0_.freight_cur AS freight_cur_30, b0_.insurance AS insurance_31, b0_.insurance_cur AS insurance_cur_32, b0_.baf AS baf_33, b0_.baf_cur AS baf_cur_34, b0_.caf AS caf_35, b0_.caf_cur AS caf_cur_36, b0_.thc AS thc_37, b0_.thc_cur AS thc_cur_38, b0_.frais_sup AS frais_sup_39, b0_.frais_sup_cur AS frais_sup_cur_40, b0_.conditionnement AS conditionnement_41, b0_.created_at AS created_at_42, b0_.updated_at AS updated_at_43, b0_.submitted_at AS submitted_at_44, b0_.lastly_submitted_at AS lastly_submitted_at_45, b0_.verified_at AS verified_at_46, b0_.validated_at AS validated_at_47, b0_.status AS status_48, b0_.authenticated_at AS authenticated_at_49, b0_.printed_at AS printed_at_50, b0_.billed_at AS billed_at_51, b0_.paid_at AS paid_at_52, b0_.is_completed AS is_completed_53, b0_.is_locked AS is_locked_54, b0_.locked_at AS locked_at_55, b0_.is_suspended AS is_suspended_56, b0_.suspended_at AS suspended_at_57, b0_.motif_rejet AS motif_rejet_58, b0_.is_regul AS is_regul_59, b0_.pdf_data AS pdf_data_60, b0_.xml_data AS xml_data_61, b0_.classe_tarifaire AS classe_tarifaire_62, b0_.is_transit AS is_transit_63, b0_.country_of_transit AS country_of_transit_64, b0_.tarification_zone AS tarification_zone_65, b0_.integrity AS integrity_66, b0_.must_zip AS must_zip_67, b0_.is_files_converted AS is_files_converted_68, u1_.id AS id_69, u1_.company_uuid AS company_uuid_70, u1_.email AS email_71, u1_.name AS name_72, u1_.company_name AS company_name_73, u1_.roles AS roles_74, u1_.distant_id AS distant_id_75, u1_.token AS token_76, u1_.token_expired_at AS token_expired_at_77, u1_.is_consignataire_vehicule AS is_consignataire_vehicule_78, e2_.id AS id_79, e2_.ref AS ref_80, e2_.is_used AS is_used_81, e2_.created_at AS created_at_82, r3_.id AS id_83, r3_.valeur AS valeur_84, r3_.devise_valeur AS devise_valeur_85, r3_.status AS status_86, r3_.validated_at AS validated_at_87, r3_.description AS description_88, r3_.is_paid AS is_paid_89, r3_.is_main_paid AS is_main_paid_90, r3_.created_at AS created_at_91, r3_.paid_at AS paid_at_92, e4_.id AS id_93, e4_.description AS description_94, e4_.is_cancelled AS is_cancelled_95, e4_.valeur AS valeur_96, e4_.devise_valeur AS devise_valeur_97, e4_.created_at AS created_at_98, e4_.updated_at AS updated_at_99, e4_.validated_at AS validated_at_100, b5_.id AS id_101, b5_.demande AS demande_102, b5_.number AS number_103, b5_.mode AS mode_104, b5_.sens AS sens_105, b5_.valeur AS valeur_106, b5_.valeur_finale AS valeur_finale_107, b5_.devise_valeur AS devise_valeur_108, b5_.reference_doc_number AS reference_doc_number_109, b5_.reference_doc_child_number AS reference_doc_child_number_110, b5_.shipper AS shipper_111, b5_.foreign_shipper AS foreign_shipper_112, b5_.forwarding_agent AS forwarding_agent_113, b5_.carrier AS carrier_114, b5_.country_of_origin AS country_of_origin_115, b5_.country_of_loading AS country_of_loading_116, b5_.port_of_loading AS port_of_loading_117, b5_.country_of_discharge AS country_of_discharge_118, b5_.port_of_discharge AS port_of_discharge_119, b5_.final_destination AS final_destination_120, b5_.loaded_at AS loaded_at_121, b5_.discharged_at AS discharged_at_122, b5_.eta AS eta_123, b5_.ata AS ata_124, b5_.etd AS etd_125, b5_.atd AS atd_126, b5_.incoterm AS incoterm_127, b5_.vessel AS vessel_128, b5_.voyage AS voyage_129, b5_.freight AS freight_130, b5_.freight_cur AS freight_cur_131, b5_.insurance AS insurance_132, b5_.insurance_cur AS insurance_cur_133, b5_.baf AS baf_134, b5_.baf_cur AS baf_cur_135, b5_.caf AS caf_136, b5_.caf_cur AS caf_cur_137, b5_.thc AS thc_138, b5_.thc_cur AS thc_cur_139, b5_.frais_sup AS frais_sup_140, b5_.frais_sup_cur AS frais_sup_cur_141, b5_.conditionnement AS conditionnement_142, b5_.created_at AS created_at_143, b5_.updated_at AS updated_at_144, b5_.submitted_at AS submitted_at_145, b5_.lastly_submitted_at AS lastly_submitted_at_146, b5_.status AS status_147, b5_.invoice_value AS invoice_value_148, b5_.invoice_value_cur AS invoice_value_cur_149, b5_.fob_value AS fob_value_150, b5_.weight AS weight_151, b5_.volume AS volume_152, b5_.description AS description_153, b5_.number_of_vehicules AS number_of_vehicules_154, b5_.number_of_motos AS number_of_motos_155, b5_.number_of_container_fourty AS number_of_container_fourty_156, b5_.number_of_container_twenty AS number_of_container_twenty_157, b5_.number_of_pkgs AS number_of_pkgs_158, b5_.is_completed AS is_completed_159, b5_.motif_rejet AS motif_rejet_160, b5_.commercial_transactions AS commercial_transactions_161, b5_.classe_tarifaire AS classe_tarifaire_162, b5_.is_transit AS is_transit_163, b5_.country_of_transit AS country_of_transit_164, b5_.tarification_zone AS tarification_zone_165, b5_.is_initiated AS is_initiated_166, b5_.initiated_at AS initiated_at_167, b0_.created_by_id AS created_by_id_168, b0_.updated_by_id AS updated_by_id_169, b0_.submitted_by_id AS submitted_by_id_170, b0_.verified_by_id AS verified_by_id_171, b0_.validated_by_id AS validated_by_id_172, b0_.authenticated_by_id AS authenticated_by_id_173, b0_.printed_by_id AS printed_by_id_174, b0_.billed_by_id AS billed_by_id_175, b0_.paid_by_id AS paid_by_id_176, b0_.ref_doc_file_id AS ref_doc_file_id_177, b0_.ref_doc_child_file_id AS ref_doc_child_file_id_178, b0_.commercial_file_id AS commercial_file_id_179, b0_.fret_file_id AS fret_file_id_180, b0_.custom_declaration_file_id AS custom_declaration_file_id_181, b0_.packing_list_file_id AS packing_list_file_id_182, b0_.origin_certificate_file_id AS origin_certificate_file_id_183, b0_.special_authorisation_file_id AS special_authorisation_file_id_184, b0_.certificat_empotage_file_id AS certificat_empotage_file_id_185, b0_.vgm_file_id AS vgm_file_id_186, b0_.locked_by_id AS locked_by_id_187, b0_.suspended_by_id AS suspended_by_id_188, b0_.temp_ref_id AS temp_ref_id_189, b0_.redressement_id AS redressement_id_190, b0_.exoneration_id AS exoneration_id_191, e2_.user_id AS user_id_192, r3_.validated_by_id AS validated_by_id_193, e4_.exoneration_file_id AS exoneration_file_id_194, e4_.validated_by_id AS validated_by_id_195, e4_.updated_by_id AS updated_by_id_196, b5_.created_by_id AS created_by_id_197, b5_.updated_by_id AS updated_by_id_198, b5_.ref_doc_file_id AS ref_doc_file_id_199, b5_.ref_doc_child_file_id AS ref_doc_child_file_id_200, b5_.commercial_file_id AS commercial_file_id_201, b5_.fret_file_id AS fret_file_id_202, b5_.custom_declaration_file_id AS custom_declaration_file_id_203, b5_.packing_list_file_id AS packing_list_file_id_204, b5_.origin_certificate_file_id AS origin_certificate_file_id_205, b5_.special_authorisation_file_id AS special_authorisation_file_id_206, b5_.certificat_empotage_file_id AS certificat_empotage_file_id_207, b5_.vgm_file_id AS vgm_file_id_208, b5_.besc_id AS besc_id_209 FROM besc b0_ INNER JOIN user u1_ ON b0_.created_by_id = u1_.id LEFT JOIN extra_reference e2_ ON b0_.temp_ref_id = e2_.id LEFT JOIN redressement r3_ ON b0_.redressement_id = r3_.id LEFT JOIN exoneration e4_ ON b0_.exoneration_id = e4_.id LEFT JOIN besc_mask b5_ ON b0_.id = b5_.besc_id ORDER BY b0_.created_at DESC LIMIT 10
Parameters:
[] |
| 3 | 2.18 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1115
]
|
| 4 | 1.59 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1115
]
|
| 5 | 1.38 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1114
]
|
| 6 | 0.90 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1114
]
|
| 7 | 1.04 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1113
]
|
| 8 | 0.87 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1113
]
|
| 9 | 1.56 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1112
]
|
| 10 | 1.20 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1112
]
|
| 11 | 1.21 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1111
]
|
| 12 | 0.99 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1111
]
|
| 13 | 0.70 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1110
]
|
| 14 | 0.59 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1110
]
|
| 15 | 0.59 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1109
]
|
| 16 | 0.54 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1109
]
|
| 17 | 0.96 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1108
]
|
| 18 | 0.75 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1108
]
|
| 19 | 0.76 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1107
]
|
| 20 | 1.32 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1107
]
|
| 21 | 0.89 ms |
SELECT t0.id AS id_1, t0.invoice_value AS invoice_value_2, t0.invoice_value_cur AS invoice_value_cur_3, t0.fob_value AS fob_value_4, t0.weight AS weight_5, t0.volume AS volume_6, t0.description AS description_7, t0.number_of_vehicules AS number_of_vehicules_8, t0.number_of_motos AS number_of_motos_9, t0.number_of_container_fourty AS number_of_container_fourty_10, t0.number_of_container_twenty AS number_of_container_twenty_11, t0.number_of_pkgs AS number_of_pkgs_12, t0.packaging AS packaging_13, t0.ectn_id AS ectn_id_14 FROM cargo t0 WHERE t0.ectn_id = ?
Parameters:
[
1106
]
|
| 22 | 0.77 ms |
SELECT t0.id AS id_1, t0.numero_reference AS numero_reference_2, t0.isvalid AS isvalid_3, t0.besc_id AS besc_id_4 FROM reference_douane t0 WHERE t0.besc_id = ?
Parameters:
[
1106
]
|
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\Besc | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Cargo | No errors. |
| App\Entity\Container | No errors. |
| App\Entity\Vehicle | No errors. |
| App\Entity\Consignee | No errors. |
| App\Entity\ExtraReference | No errors. |
| App\Entity\Exoneration | No errors. |
| App\Entity\BescMask | No errors. |
| App\Entity\Redressement | No errors. |
| App\Entity\AttachmentFile | No errors. |
| App\Entity\NotifyParty | No errors. |
| App\Entity\Package | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Transhipment | No errors. |
| App\Entity\ReferenceGuce | No errors. |
| App\Entity\ReferenceDouane | No errors. |