Die MYSQL-Ausführungszeit zeigt weniger Zeit an, da sie tatsächlich zum Anzeigen der Daten benötigt wird [geschlossen] ⇐ Php

[Anonymous]

Ich habe eine Abfrage in MYSQL wie folgt. Es dient dazu, Daten an ein Codeigniter-Programm abzurufen, indem ein Auswahlfeld ausgefüllt wird.

Code: Select all

SELECT
pharmacy_products.id,
pharmacy_products.product_name,
pharmacy_products.product_display_name,
pharmacy_products.pack_size,
pharmacy_products.top_up_level,
pharmacy_products.current_physical_stock,
pharmacy_products.purchasing_status,
pharmacy_products.po_number,
pharmacy_products.added_supplier,
users.user_name,
pharmacy_products.added_to_supplier_time,
pharmacy_products.added_packs,
pharmacy_products.last_pack_purchase_price,
GROUP_CONCAT(
'',
pharmacy_suppliers.suppier_alternate_name,
'' SEPARATOR ''
) AS suppliers
FROM
pharmacy_products
LEFT JOIN pharmacy_product_to_companies ON pharmacy_products.id = pharmacy_product_to_companies.product_id
LEFT JOIN pharmacy_suppliers ON pharmacy_product_to_companies.company_id = pharmacy_suppliers.id
LEFT JOIN users ON pharmacy_products.added_to_supplier_by = users.user_id
WHERE
pharmacy_products.current_physical_stock