GET https://friq.ch/cron/bexio/import-all

Response
200 OK
IP
10.4.23.29
Profiled on
Token
1fd993

Query Metrics

348 Database Queries
14 Different statements
783.86 ms Query time
0 Invalid entities
290 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
746.56 ms
(95.24%) 		250 
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
Parameters: 
[
  1
  "bexio"
  "invoice"
  "3022"
]
View formatted query    View runnable query    Explain query    View query backtrace
15.16 ms
(1.93%) 		8 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5.20 ms
(0.66%) 		26 
DELETE FROM order_line WHERE id = ?
Parameters: 
[
  58078
]
View formatted query    View runnable query    Explain query    View query backtrace
4.41 ms
(0.56%) 		26 
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  """
    <strong>Description<br /><br /></strong>Dans le prolongement de notre rencontre de fin d&rsquo;ann&eacute;e derni&egrave;re, nous vous proposons une offre compl&egrave;te et sur mesure pour r&eacute;pondre &agrave; l&rsquo;ensemble de vos besoins en signal&eacute;tique.<br /><br /><span style="text-decoration: underline;">Selon validation par e-mail du 8 juin 2025</span><br />\r\n
    <ul>\r\n
    <li>Signal&eacute;tique ext&eacute;rieure pour bureaux et centres</li>\r\n
    <li>Signal&eacute;tique pour Rue st-Maurice 4</li>\r\n
    <li>Marquage pour places de parc</li>\r\n
    <li>Marquage des entr&eacute;es pour St-S&eacute;bastien 4 &agrave; Del&eacute;mont et Route de C&oelig;uve 37 &agrave; Porrentruy</li>\r\n
    </ul>
    """
  null
  null
  null
  null
  null
  "{"id":3501,"type":"KbPositionText","text":"<strong>Description<br \/><br \/><\/strong>Dans le prolongement de notre rencontre de fin d&rsquo;ann&eacute;e derni&egrave;re, nous vous proposons une offre compl&egrave;te et sur mesure pour r&eacute;pondre &agrave; l&rsquo;ensemble de vos besoins en signal&eacute;tique.<br \/><br \/><span style=\"text-decoration: underline;\">Selon validation par e-mail du 8 juin 2025<\/span><br \/>\r\n<ul>\r\n<li>Signal&eacute;tique ext&eacute;rieure pour bureaux et centres<\/li>\r\n<li>Signal&eacute;tique pour Rue st-Maurice 4<\/li>\r\n<li>Marquage pour places de parc<\/li>\r\n<li>Marquage des entr&eacute;es pour St-S&eacute;bastien 4 &agrave; Del&eacute;mont et Route de C&oelig;uve 37 &agrave; Porrentruy<\/li>\r\n<\/ul>","show_pos_nr":false,"pos":null,"internal_pos":1,"parent_id":null,"is_optional":false}"
  235
]
View formatted query    View runnable query    Explain query    View query backtrace
2.22 ms
(0.28%) 		4 
INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "bexio"
  "order"
  235
  "2403"
  "pull"
  "success"
  "Commande mise à jour depuis Bexio."
  "{"id":2403,"document_nr":"POM-COMCL2026-02403","title":"AJAM-Signal\u00e9tique-b\u00e2timents","contact_id":832,"contact_sub_id":null,"user_id":45,"project_id":null,"logopaper_id":1,"language_id":2,"bank_account_id":1,"currency_id":1,"payment_type_id":4,"header":"Merci pour votre commande","footer":"Cordialement, l'\u00e9quipe","total_gross":"4246.000000","total_net":"4246.000000","total_taxes":"343.9260","total":"4589.950000","total_rounding_difference":0.02,"mwst_type":0,"mwst_is_net":true,"show_position_taxes":true,"is_valid_from":"2026-03-13","contact_address":"AJAM - Association Jurassienne d'Accueil des Migrants\nRue Saint-S\u00e9bastien 4\nCH - 2800 Del\u00e9mont","delivery_address_type":0,"delivery_address":"AJAM - Association Jurassienne d'Accueil des Migrants\nRue Saint-S\u00e9bastien 4\nCH - 2800 Del\u00e9mont","kb_item_status_id":5,"is_recurring":false,"api_reference":"","viewed_by_client_at":null,"updated_at":"2026-06-09 07:05:44","template_slug":"5fbe6df9b774d50dce04b108","taxs":[{"percentage":"8.10","value":"343.9260"}],"positions":[{"id":3501,"type":"KbPositionText","text":"<strong>Description<br \/><br \/><\/strong>Dans le prolongement de notre rencontre de fin d&rsquo;ann&eacute;e derni&egrave;re, nous vous proposons une offre compl&egrave;te et sur mesure pour r&eacute;pondre &agrave; l&rsquo;ensemble de vos besoins en signal&eacute;tique.<br \/><br \/><span style=\"text-decoration: underline;\">Selon validation par e-mail du 8 juin 2025<\/span><br \/>\r\n<ul>\r\n<li>Signal&eacute;tique ext&eacute;rieure pour bureaux et centres<\/li>\r\n<li>Signal&eacute;tique pour Rue st-Maurice 4<\/li>\r\n<li>Marquage pour places de parc<\/li>\r\n<li>Marquage des entr&eacute;es pour St-S&eacute;bastien 4 &agrave; Del&eacute;mont et Route de C&oelig;uve 37 &agrave; Porrentruy<\/li>\r\n<\/ul>","show_pos_nr":false,"pos":null,"internal_pos":1,"parent_id":null,"is_optional":false},{"id":3373,"type":"KbPositionSubposition","text":"<strong>Signal&eacute;tique ext&eacute;rieure bureaux + centres<br \/><br \/><\/strong>Livraison des &eacute;l&eacute;ments &agrave; Del&eacute;mont.<br \/>La pose des &eacute;l&eacute;ments sur les b&acirc;timents est assur&eacute;e par le client.","pos":"1","internal_pos":2,"show_pos_nr":true,"parent_id":null,"is_optional":false,"total_sum":"1681.000000","show_pos_prices":true},{"id":12743,"type":"KbPositionArticle","amount":"7.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Plaques A3<\/strong>\r\n<ul>\r\n<li>Aluminum 3mm d'&eacute;paisseur<\/li>\r\n<li>Dimensions pr&eacute;vues: A3<\/li>\r\n<li>Film pvc coul&eacute; teint&eacute; dans la masse<\/li>\r\n<li>D&eacute;coupe, &eacute;chenillage et tape d'application<\/li>\r\n<li>Pose sur support<\/li>\r\n<li>Livraison &agrave; Del&eacute;mont<\/li>\r\n<\/ul>\r\n<em><\/em>","unit_price":"66.000000","discount_in_percent":"0.0000","position_total":"462.000000","pos":"1.1","internal_pos":3,"parent_id":3373,"is_optional":false,"article_id":3},{"id":12744,"type":"KbPositionArticle","amount":"2.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Vitrines d'affichage ext&eacute;rieures (bureau Porrentruy + centre Montfaucon)<\/strong>\r\n<ul>\r\n<li>Boitiers d'affichage en verre s&eacute;curit<\/li>\r\n<li>Format 790 x 650 mm (pour affichage de 4 feuilles A4)<\/li>\r\n<li>Cadre en aluminium &eacute;tanche<\/li>\r\n<li>Avec syst&egrave;me de verrouillage (+ jeu de 2 cl&eacute;s)<\/li>\r\n<li>Poids: <span class=\"_1MkxNefptZewb61IApId0y\" data-test-id=\"html-to-react-id\">7.8<\/span> kg<\/li>\r\n<li>Fond utilisable comme &eacute;critoire<\/li>\r\n<li>Livraison &agrave; Del&eacute;mont<\/li>\r\n<\/ul>\r\n<em><\/em>","unit_price":"609.000000","discount_in_percent":"0.0000","position_total":"1218.000000","pos":"1.2","internal_pos":4,"parent_id":3373,"is_optional":false,"article_id":4},{"id":12745,"type":"KbPositionArticle","amount":"1.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Plexiglas<\/strong><ul>\n<li>Bo\u00eetier en plexiglas pli\u00e9 pour affiche interchangeable<\/li>\n<li>Epaisseur 3mm<\/li>\n<li>Format A4 ou A3<\/li>\n<\/ul> <i>Ce syst\u00e8me se fixe id\u00e9alement avec un adh\u00e9sif double face haute r\u00e9sistance.<\/i>","unit_price":"1.000000","discount_in_percent":"0.0000","position_total":"1.000000","pos":"1.3","internal_pos":5,"parent_id":3373,"is_optional":false,"article_id":5},{"id":3374,"type":"KbPositionSubposition","text":"<strong>Marquage places de parc<\/strong><br>","pos":"2","internal_pos":6,"show_pos_nr":true,"parent_id":null,"is_optional":false,"total_sum":"980.000000","show_pos_prices":true},{"id":12746,"type":"KbPositionArticle","amount":"10.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Supports aluminium &agrave; planter<\/strong>\r\n<ul>\r\n<li>Plaque support de 350x100mm pour collage des visuels<\/li>\r\n<li>Tige int&eacute;gr&eacute;e pour plantage (soud&eacute;e &agrave; la plaque)<\/li>\r\n<li>Marquage personnalis&eacute; (Immatriculation) ou g&eacute;n&eacute;rique (logo AJAM)<\/li>\r\n<li>Laminage de protection longue dur&eacute;e<\/li>\r\n<li>Pose sur support<\/li>\r\n<li>Livraison &agrave; Del&eacute;mont<\/li>\r\n<li>Estimation &agrave; 10 pi&egrave;ces<\/li>\r\n<\/ul>\r\n<em><\/em>","unit_price":"90.000000","discount_in_percent":"0.0000","position_total":"900.000000","pos":"2.1","internal_pos":7,"parent_id":3374,"is_optional":false,"article_id":6},{"id":12747,"type":"KbPositionArticle","amount":"1.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Chablon pour peinture place de parc<\/strong>\r\n<ul>\r\n<li>Chablon, mati&egrave;re acier &eacute;p. 1,5mm<\/li>\r\n<li>Dimensions: 800x500mm environ<\/li>\r\n<li>La peinture des places de parc est &agrave; la charge du client<\/li>\r\n<li>Livraison &agrave; Del&eacute;mont<\/li>\r\n<\/ul>\r\n<em><\/em>","unit_price":"80.000000","discount_in_percent":"0.0000","position_total":"80.000000","pos":"2.2","internal_pos":8,"parent_id":3374,"is_optional":false,"article_id":7},{"id":3460,"type":"KbPositionSubposition","text":"<strong>Marquage portes d'entr&eacute;e<\/strong><br \/>\r\n<ul>\r\n<li>Rue St-S&eacute;bastien 4 &agrave; Del&eacute;mont<\/li>\r\n<li>Route de Coeuve 37 &agrave; Porrentruy<\/li>\r\n<\/ul>","pos":"3","internal_pos":9,"show_pos_nr":true,"parent_id":null,"is_optional":false,"total_sum":"550.000000","show_pos_prices":true},{"id":18222,"type":"KbPositionCustom","amount":"1.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Marquage vitre entr&eacute;e<\/strong><br \/>\r\n<ul>\r\n<li>Film PVC longue dur&eacute;e<\/li>\r\n<li>Impression quadri et laminage de protection anti-UV<\/li>\r\n<li>Dimension:\r\n<ul>\r\n<li>900x920mm (Del&eacute;mont)<\/li>\r\n<li>1500x800mm (Porrentruy)<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Pose sur sites*<\/li>\r\n<li>Frais de d&eacute;placement &agrave; Porrentruy inclus (1.-\/km)<\/li>\r\n<\/ul>\r\n<br \/><em>*Badaboom se d&eacute;charge de toute responsabilit&eacute; dans le cas o&ugrave; les supports de pose pr&eacute;senteraient des d&eacute;fauts non visibles et susceptibles d'emp&ecirc;cher une d&eacute;pose et\/ou un nettoyage et une application optimal.<\/em>","unit_price":"550.000000","discount_in_percent":null,"position_total":"550.000000","pos":"3.1","internal_pos":10,"parent_id":3460,"is_optional":false},{"id":3375,"type":"KbPositionSubposition","text":"<strong>Signal\u00e9tique rue St-Maurice (Del\u00e9mont)<\/strong><br>","pos":"4","internal_pos":11,"show_pos_nr":true,"parent_id":null,"is_optional":false,"total_sum":"815.000000","show_pos_prices":true},{"id":12748,"type":"KbPositionArticle","amount":"1.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Enseigne porte principale<\/strong><ul>\n<li>Panneau aluminum 3mm d'\u00e9paisseur<\/li>\n<li>Dimensions pr\u00e9vue: 2000x1000mm<\/li>\n<li>Conception et impression num\u00e9rique<\/li>\n<li>Laminage de protection anti-UV&nbsp; longue dur\u00e9e<\/li>\n<li>Pose sur site<\/li>\n<\/ul> <i><\/i>","unit_price":"530.000000","discount_in_percent":"0.0000","position_total":"530.000000","pos":"4.1","internal_pos":12,"parent_id":3375,"is_optional":false,"article_id":9},{"id":12749,"type":"KbPositionArticle","amount":"1.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Panneau lat\u00e9ral entr\u00e9e<\/strong><ul>\n<li>Panneau aluminum 3mm d'\u00e9paisseur<\/li>\n<li>Dimensions pr\u00e9vues: 830x630mm<\/li>\n<li>Conception et impression num\u00e9rique<\/li>\n<li>Laminage de protection anti-UV&nbsp; longue dur\u00e9e<\/li>\n<li>Pose sur site<\/li>\n<\/ul> <i><\/i>","unit_price":"285.000000","discount_in_percent":"0.0000","position_total":"285.000000","pos":"4.2","internal_pos":13,"parent_id":3375,"is_optional":false,"article_id":10},{"id":12742,"type":"KbPositionArticle","amount":"2.000000","amount_reserved":"0.000000","amount_open":"0.000000","amount_completed":"0.000000","unit_id":1,"account_id":101,"unit_name":"Stk","tax_id":28,"tax_value":"8.10","text":"<strong>Frais annexes (estimation)<\/strong> <i><\/i>","unit_price":"110.000000","discount_in_percent":"0.0000","position_total":"220.000000","pos":"5","internal_pos":14,"parent_id":null,"is_optional":false,"article_id":2}],"network_link":""}"
  "2026-07-07 04:01:14"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2.10 ms
(0.27%) 		4 
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.number AS number_3, t0.title AS title_4, t0.status AS status_5, t0.recurring AS recurring_6, t0.currency AS currency_7, t0.total_net AS total_net_8, t0.total_taxes AS total_taxes_9, t0.total_gross AS total_gross_10, t0.order_date AS order_date_11, t0.valid_until AS valid_until_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.repetition_payload AS repetition_payload_15, t0.raw_payload AS raw_payload_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.next_due_date AS next_due_date_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21 FROM `order` t0 WHERE t0.id = ?
Parameters: 
[
  235
]
View formatted query    View runnable query    Explain query    View query backtrace
1.62 ms
(0.21%) 		8 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.41 ms
(0.18%) 		4 
UPDATE integration_connection SET last_sync_at = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  "2026-07-07 04:01:11"
  "2026-07-07 04:01:11"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.40 ms
(0.18%) 		4 
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.order_entity_id AS order_entity_id_10 FROM order_line t0 WHERE t0.order_entity_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters: 
[
  235
]
View formatted query    View runnable query    Explain query    View query backtrace
1.39 ms
(0.18%) 		4 
UPDATE external_reference SET last_pulled_at = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  "2026-07-07 04:01:14"
  "2026-07-07 04:01:14"
  3089
]
View formatted query    View runnable query    Explain query    View query backtrace
0.93 ms
(0.12%) 		2 
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.label AS label_3, t0.enabled AS enabled_4, t0.mode AS mode_5, t0.access_token AS access_token_6, t0.refresh_token AS refresh_token_7, t0.expires_at AS expires_at_8, t0.last_sync_at AS last_sync_at_9, t0.last_error AS last_error_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.company_id AS company_id_13 FROM integration_connection t0 WHERE t0.company_id = ? AND t0.provider = ? LIMIT 1
Parameters: 
[
  1
  "bexio"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(0.11%) 		4 
UPDATE `order` SET order_date = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  "2026-03-13 00:00:00"
  "2026-07-07 04:01:14"
  "2026-07-07 04:01:14"
  235
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.06%) 		3 
SELECT t0.id AS id_1, t0.type AS type_2, t0.display_name AS display_name_3, t0.company_name AS company_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.street AS street_11, t0.house_number AS house_number_12, t0.address_addition AS address_addition_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.country_code AS country_code_16, t0.vat_number AS vat_number_17, t0.status AS status_18, t0.source AS source_19, t0.notes AS notes_20, t0.active AS active_21, t0.last_synced_at AS last_synced_at_22, t0.sync_status AS sync_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.company_id AS company_id_26 FROM client t0 WHERE t0.id = ?
Parameters: 
[
  787
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.02%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.website AS website_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.vat_number AS vat_number_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM company t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ExternalReference 249
App\Entity\OrderLine 26
App\Entity\Order 4
App\Entity\SyncLog 4
App\Entity\Client 3
App\Entity\Company 2
App\Entity\IntegrationConnection 2

Entities Mapping

Class Mapping errors
App\Entity\Company No errors.
App\Entity\CompanyUser No errors.
App\Entity\IntegrationConnection No errors.
App\Entity\ExternalReference No errors.
App\Entity\Order No errors.
App\Entity\Client No errors.
App\Entity\OrderLine No errors.
App\Entity\SyncLog No errors.