Query Metrics
4
Database Queries
3
Different statements
7.18 ms
Query time
0
Invalid entities
Grouped Statements
default connection
No database queries were performed.
database_akn_dump connection
No database queries were performed.
database_akn connection
No database queries were performed.
database_akn_old connection
No database queries were performed.
database_akn_live connection
No database queries were performed.
database_akn_dump_live connection
No database queries were performed.
database_akn_live_ionos connection
Time▼ | Count | Info |
---|---|---|
2.11 ms (0.00%) |
2 |
INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime) VALUES(?,?,?)
Parameters:
[ "import/customers" "Start" "2024-09-21 14:20:03" ] |
database_akn_dump_live_ionos connection
Time▼ | Count | Info |
---|---|---|
3.18 ms (0.00%) |
1 |
SELECT * , customers.customer_number as customer_number , customers.email as customer_email , k1.key_text as price_list , k2.key_text as salesman , k3.key_text as salesarea , k4.key_text as tour , k5.key_text as payment_term , k6.key_text as delivery_term , k7.key_text as `group` FROM customers LEFT JOIN contacts ON (customers.customer_number = contacts.customer_number) LEFT JOIN `keys` as k1 ON (k1.key_number = customers.price_list AND k1.key_kind = 7) LEFT JOIN `keys` as k2 ON (k2.key_number = customers.salesman AND k2.key_kind = 8) LEFT JOIN `keys` as k3 ON (k3.key_number = customers.sales_area AND k3.key_kind = 9) LEFT JOIN `keys` as k4 ON (k4.key_number = customers.tour AND k4.key_kind = 52) LEFT JOIN `keys` as k5 ON (k5.key_number = customers.payment_term AND k5.key_kind = 4) LEFT JOIN `keys` as k6 ON (k6.key_number = customers.delivery_term AND k6.key_kind = 5) LEFT JOIN `keys` as k7 ON (k7.key_number = customers.group AND k7.key_kind = 3) WHERE customers.customer_number IS NOT NULL AND customers.street IS NOT NULL AND customers.street !='' AND customers.email IS NOT NULL AND customers.email !='' AND customers.email LIKE '%@%' AND name_1 IS NOT NULL AND name_1 != '' AND upload_done IS NULL -- AND customers.customer_number = '14254' -- #TODO: REMOVE THIS LINE!!! LIMIT 50 ;
Parameters:
[] |
1.90 ms (0.00%) |
1 |
UPDATE customers SET upload_done = 1, upload_failed = 1 WHERE customer_number = '' OR (upload_done IS NULL AND upload_failed IS NULL) ;
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
database_akn_dump | doctrine.dbal.database_akn_dump_connection |
database_akn | doctrine.dbal.database_akn_connection |
database_akn_old | doctrine.dbal.database_akn_old_connection |
database_akn_live | doctrine.dbal.database_akn_live_connection |
database_akn_dump_live | doctrine.dbal.database_akn_dump_live_connection |
database_akn_live_ionos | doctrine.dbal.database_akn_live_ionos_connection |
database_akn_dump_live_ionos | doctrine.dbal.database_akn_dump_live_ionos_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.