Debug JSON

{
    "tpl": "apotheke",
    "group_id_type": "pzn",
    "q": "Teva",
    "qRaw": "Teva",
    "code_value": "",
    "code_type": "",
    "cat": "",
    "brand": "",
    "shop": "",
    "pmin": "",
    "pmax": "",
    "sort": "relevance",
    "page": 1,
    "ps": 48,
    "mode": "fts",
    "has_fts": true,
    "has_json1": false,
    "has_found_ids_json": true,
    "has_price_num": true,
    "has_merchant_name": true,
    "has_image_url": true,
    "fts_query": "teva*",
    "search_where_sql": "WHERE p.rowid IN (\r\n                SELECT rowid\r\n                FROM products_fts\r\n                WHERE products_fts MATCH :ftsq\r\n            )",
    "search_bind": {
        ":ftsq": "teva*"
    },
    "quick_counts": {
        "final_count": 3,
        "has_fts": 1,
        "has_json1": 0,
        "has_found_ids_json": 1,
        "has_final_category_path": 1,
        "fts_query": "teva*",
        "group_id_type": "pzn",
        "has_merchant_name": 1,
        "has_image_url": 1
    },
    "raw_rows_truncated": false,
    "raw_cap": 1200,
    "is_detail_view": false,
    "detail_identifier": "",
    "detail_identifier_type": "",
    "detail_offer_count": 0,
    "detail_merchant_count": 0,
    "raw_rows_count": 3,
    "grouped_count": 3,
    "grouped_source_rows_count": 3,
    "single_count": 0,
    "display_total_count": 3,
    "page_detail_rows_count": 0,
    "grouped_rows_page_count": 3,
    "single_rows_page_count": 0,
    "detail_summary": null,
    "detail_lead": null,
    "price_history_pzn": "",
    "quicknav_top_paths_debug": [
        {
            "path": "Erkältung/Einreibung und Inhalation",
            "count": 1,
            "depth": 1
        },
        {
            "path": "Nutrition/Mineralstoffe",
            "count": 1,
            "depth": 1
        },
        {
            "path": "Sonstige Arzneimittel/Blutbildung",
            "count": 1,
            "depth": 1
        }
    ],
    "raw_rows_all": [
        {
            "id": "135778",
            "title": "TEVA Nebusal 7 % Inhalationslösung erhöht die Mobilisierung von Sekreten in den unteren Atemwegen, 60 St. Ampullen",
            "merchant_name": "Apohealth DE",
            "category": "Erkältung/Einreibung und Inhalation",
            "brand": "Teva",
            "ean": null,
            "price": "EUR67.41",
            "image_url": "https://go.apothekeversand.de/i/teva-nebusal-7-inhalationsloesung-erhoeht-die-mobilisierung-von-sekreten-in-den-unteren-atemwegen-60-st-ampullen-67-41-eur-pzn-09332413/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5MzMyNDEzXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGQ1MWU1ZjgxMzJjY2VkNmVmZDk4YjgzMzdjNjUzODU4ZDI2ZmRjNQ",
            "link": "https://go.apothekeversand.de/r/teva-nebusal-7-inhalationsloesung-erhoeht-die-mobilisierung-von-sekreten-in-den-unteren-atemwegen-60-st-ampullen-67-41-eur-pzn-09332413/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTIxMzI0MSZhPTU4NDU3NyZtPTk4NzI5",
            "found_ids_json": "[{\"type\":\"pzn\",\"value\":\"09332413\"}]",
            "category_path_runtime": "Erkältung/Einreibung und Inhalation",
            "gtin": null,
            "mpn": "9332413",
            "description": "Inhalationslösung zur gezielten Versorgung Lösung zum Inhalieren Medizinprodukt aus der Apotheke Hersteller: Teva GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 09332413",
            "short_description": "",
            "price_num": "67.41",
            "delivery_cost": "DE: 0.00 EUR / 1-3 days ; AT: 0.00 EUR / 2-4 days ; CH: 3.60 EUR / 3-5 days ; US: 11.40 EUR / 3-5 days ; CA: 11.40 EUR / 6-10 days ; GB: 0.00 EUR / 2-5 days ; FR: 0.00 EUR / 3-4 days ;",
            "awin_merchant_id": "98729",
            "alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/09332413_02.jpeg",
            "price_old": "69.49",
            "savings_percent": null,
            "isbn": null,
            "merchant_category": "Erkältung/Einreibung und Inhalation",
            "final_category_path": "Erkältung/Einreibung und Inhalation",
            "group_pzn": "09332413",
            "family_ids_json": "[{\"type\":\"pzn\",\"value\":\"09332413\"}]",
            "family_signature": "apotheke|title|teva-nebusal-inhalationsloesung-erhoeht-die-mobilisierung-von-sekreten-in-den-unteren-atemwegen-ampullen|str-7|form-loesung",
            "family_variant_key": "60-st",
            "family_variant_label": "60 St",
            "family_type": null,
            "images": [
                "https://go.apothekeversand.de/i/teva-nebusal-7-inhalationsloesung-erhoeht-die-mobilisierung-von-sekreten-in-den-unteren-atemwegen-60-st-ampullen-67-41-eur-pzn-09332413/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5MzMyNDEzXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGQ1MWU1ZjgxMzJjY2VkNmVmZDk4YjgzMzdjNjUzODU4ZDI2ZmRjNQ",
                "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/09332413_02.jpeg"
            ],
            "final_category_key_runtime": "erkaeltung-einreibung-und-inhalation",
            "final_category_leaf_runtime": "Erkältung/Einreibung und Inhalation",
            "final_category_depth_runtime": 1,
            "category_display": "Erkältung/Einreibung und Inhalation",
            "category_leaf_label": "Erkältung/Einreibung und Inhalation",
            "price_value": 67.41,
            "price_old_value": 69.49,
            "savings_percent_value": null,
            "discount_percent": 3,
            "price_currency": "EUR",
            "deeplink": "https://go.apothekeversand.de/r/teva-nebusal-7-inhalationsloesung-erhoeht-die-mobilisierung-von-sekreten-in-den-unteren-atemwegen-60-st-ampullen-67-41-eur-pzn-09332413/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTIxMzI0MSZhPTU4NDU3NyZtPTk4NzI5",
            "brand_name": "Teva",
            "product_short_description": "",
            "pack_size_label": "60 Stück",
            "slug_pzn": "09332413"
        },
        {
            "id": "123208",
            "title": "Calcet 475 mg Filmtabletten Phosphatbinder, 200 St. Tabletten",
            "merchant_name": "Apohealth DE",
            "category": "Nutrition/Mineralstoffe",
            "brand": "Teva",
            "ean": "4150016274165",
            "price": "EUR16.85",
            "image_url": "https://go.apothekeversand.de/i/calcet-475-mg-filmtabletten-phosphatbinder-200-st-tabletten-16-85-eur-pzn-01627416/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAxNjI3NDE2XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGEzYWI5NTZiYjZkNWUwYjhmZDdkZjY4ZWZlN2U1NzgxMmE4MzhmYQ",
            "link": "https://go.apothekeversand.de/r/calcet-475-mg-filmtabletten-phosphatbinder-200-st-tabletten-16-85-eur-pzn-01627416/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTE3NTcwNiZhPTU4NDU3NyZtPTk4NzI5",
            "found_ids_json": "[{\"type\":\"pzn\",\"value\":\"01627416\"},{\"type\":\"ean\",\"value\":\"4150016274165\"}]",
            "category_path_runtime": "Nutrition/Mineralstoffe",
            "gtin": null,
            "mpn": "1627416",
            "description": "Wirkstoff: Calciumacetat gegen erhöhte Phosphatwerte Tabletten zum Einnehmen apothekenpflichtiges Arzneimittel Hersteller: Teva GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 01627416",
            "short_description": "",
            "price_num": "16.85",
            "delivery_cost": "DE: 2.40 EUR / 1-3 days ; AT: 2.40 EUR / 2-4 days ; CH: 10.80 EUR / 3-5 days ; US: 21.00 EUR / 3-5 days ; CA: 21.00 EUR / 6-10 days ; GB: 7.80 EUR / 2-5 days ; FR: 2.40 EUR / 3-4 days ;",
            "awin_merchant_id": "98729",
            "alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/20134508939123af32f6ac7165f687fb.jpeg",
            "price_old": "16.49",
            "savings_percent": null,
            "isbn": null,
            "merchant_category": "Nutrition/Mineralstoffe",
            "final_category_path": "Nutrition/Mineralstoffe",
            "group_pzn": "01627416",
            "family_ids_json": "[{\"type\":\"pzn\",\"value\":\"01627416\"},{\"type\":\"ean\",\"value\":\"4150016274165\"}]",
            "family_signature": "apotheke|title|calcet-phosphatbinder|str-475-mg|form-tabletten",
            "family_variant_key": "200-st",
            "family_variant_label": "200 St",
            "family_type": null,
            "images": [
                "https://go.apothekeversand.de/i/calcet-475-mg-filmtabletten-phosphatbinder-200-st-tabletten-16-85-eur-pzn-01627416/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAxNjI3NDE2XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGEzYWI5NTZiYjZkNWUwYjhmZDdkZjY4ZWZlN2U1NzgxMmE4MzhmYQ",
                "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/20134508939123af32f6ac7165f687fb.jpeg"
            ],
            "final_category_key_runtime": "nutrition-mineralstoffe",
            "final_category_leaf_runtime": "Nutrition/Mineralstoffe",
            "final_category_depth_runtime": 1,
            "category_display": "Nutrition/Mineralstoffe",
            "category_leaf_label": "Nutrition/Mineralstoffe",
            "price_value": 16.85,
            "price_old_value": 16.49,
            "savings_percent_value": null,
            "discount_percent": null,
            "price_currency": "EUR",
            "deeplink": "https://go.apothekeversand.de/r/calcet-475-mg-filmtabletten-phosphatbinder-200-st-tabletten-16-85-eur-pzn-01627416/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTE3NTcwNiZhPTU4NDU3NyZtPTk4NzI5",
            "brand_name": "Teva",
            "product_short_description": "",
            "pack_size_label": "475 Milligramm",
            "slug_pzn": "01627416"
        },
        {
            "id": "122463",
            "title": "DreisaFol Tabletten bei Folsäuremangelzuständen, 100 St. Tabletten",
            "merchant_name": "Apohealth DE",
            "category": "Sonstige Arzneimittel/Blutbildung",
            "brand": "Teva",
            "ean": "4150012239373",
            "price": "EUR21.33",
            "image_url": "https://go.apothekeversand.de/i/dreisafol-tabletten-bei-folsaeuremangelzustaenden-100-st-tabletten-21-33-eur-pzn-01223937/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAxMjIzOTM3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9MDk0YWMxY2RhYzViZDQ1OThhOTMzMGIzZDE4Y2ZiYjVhMjFiZDA2ZQ",
            "link": "https://go.apothekeversand.de/r/dreisafol-tabletten-bei-folsaeuremangelzustaenden-100-st-tabletten-21-33-eur-pzn-01223937/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTE4NDQxOSZhPTU4NDU3NyZtPTk4NzI5",
            "found_ids_json": "[{\"type\":\"pzn\",\"value\":\"01223937\"},{\"type\":\"ean\",\"value\":\"4150012239373\"}]",
            "category_path_runtime": "Sonstige Arzneimittel/Blutbildung",
            "gtin": null,
            "mpn": "1223937",
            "description": "Wirkstoff: Folsäure bei Mangel an Folsäure Tabletten zum Einnehmen apothekenpflichtiges Arzneimittel Hersteller: Teva GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 01223937",
            "short_description": "",
            "price_num": "21.33",
            "delivery_cost": "DE: 0.00 EUR / 1-3 days ; AT: 2.40 EUR / 2-4 days ; CH: 4.80 EUR / 3-5 days ; US: 22.20 EUR / 3-5 days ; CA: 4.80 EUR / 6-10 days ; GB: 2.40 EUR / 2-5 days ; FR: 3.00 EUR / 3-4 days ;",
            "awin_merchant_id": "98729",
            "alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/cc4766e266a50320198a13d631f3014e.jpeg",
            "price_old": "21.99",
            "savings_percent": null,
            "isbn": null,
            "merchant_category": "Sonstige Arzneimittel/Blutbildung",
            "final_category_path": "Sonstige Arzneimittel/Blutbildung",
            "group_pzn": "01223937",
            "family_ids_json": "[{\"type\":\"pzn\",\"value\":\"01223937\"},{\"type\":\"ean\",\"value\":\"4150012239373\"}]",
            "family_signature": "apotheke|title|dreisafol-bei-folsaeuremangelzustaenden|form-gel",
            "family_variant_key": "100-st",
            "family_variant_label": "100 St",
            "family_type": null,
            "images": [
                "https://go.apothekeversand.de/i/dreisafol-tabletten-bei-folsaeuremangelzustaenden-100-st-tabletten-21-33-eur-pzn-01223937/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAxMjIzOTM3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9MDk0YWMxY2RhYzViZDQ1OThhOTMzMGIzZDE4Y2ZiYjVhMjFiZDA2ZQ",
                "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/cc4766e266a50320198a13d631f3014e.jpeg"
            ],
            "final_category_key_runtime": "sonstige-arzneimittel-blutbildung",
            "final_category_leaf_runtime": "Sonstige Arzneimittel/Blutbildung",
            "final_category_depth_runtime": 1,
            "category_display": "Sonstige Arzneimittel/Blutbildung",
            "category_leaf_label": "Sonstige Arzneimittel/Blutbildung",
            "price_value": 21.33,
            "price_old_value": 21.99,
            "savings_percent_value": null,
            "discount_percent": 3,
            "price_currency": "EUR",
            "deeplink": "https://go.apothekeversand.de/r/dreisafol-tabletten-bei-folsaeuremangelzustaenden-100-st-tabletten-21-33-eur-pzn-01223937/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTE4NDQxOSZhPTU4NDU3NyZtPTk4NzI5",
            "brand_name": "Teva",
            "product_short_description": "",
            "pack_size_label": "100 Stück",
            "slug_pzn": "01223937"
        }
    ],
    "grouped_rows_all": [
        {
            "group_id": "01223937",
            "group_type": "PZN",
            "title": "DreisaFol Tabletten bei Folsäuremangelzuständen, 100 St. Tabletten",
            "image_url": "https://go.apothekeversand.de/i/dreisafol-tabletten-bei-folsaeuremangelzustaenden-100-st-tabletten-21-33-eur-pzn-01223937/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAxMjIzOTM3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9MDk0YWMxY2RhYzViZDQ1OThhOTMzMGIzZDE4Y2ZiYjVhMjFiZDA2ZQ",
            "brand": "Teva",
            "currency": "EUR",
            "min_price": 21.33,
            "max_price": 21.33,
            "row_count": 1,
            "merchant_count": 1,
            "detail_url": "preisvergleich.php?q=01223937",
            "description": "Wirkstoff: Folsäure bei Mangel an Folsäure Tabletten zum Einnehmen apothekenpflichtiges Arzneimittel Hersteller: Teva GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 01223937",
            "order_pos": 2
        },
        {
            "group_id": "01627416",
            "group_type": "PZN",
            "title": "Calcet 475 mg Filmtabletten Phosphatbinder, 200 St. Tabletten",
            "image_url": "https://go.apothekeversand.de/i/calcet-475-mg-filmtabletten-phosphatbinder-200-st-tabletten-16-85-eur-pzn-01627416/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAxNjI3NDE2XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGEzYWI5NTZiYjZkNWUwYjhmZDdkZjY4ZWZlN2U1NzgxMmE4MzhmYQ",
            "brand": "Teva",
            "currency": "EUR",
            "min_price": 16.85,
            "max_price": 16.85,
            "row_count": 1,
            "merchant_count": 1,
            "detail_url": "preisvergleich.php?q=01627416",
            "description": "Wirkstoff: Calciumacetat gegen erhöhte Phosphatwerte Tabletten zum Einnehmen apothekenpflichtiges Arzneimittel Hersteller: Teva GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 01627416",
            "order_pos": 1
        },
        {
            "group_id": "09332413",
            "group_type": "PZN",
            "title": "TEVA Nebusal 7 % Inhalationslösung erhöht die Mobilisierung von Sekreten in den unteren Atemwegen, 60 St. Ampullen",
            "image_url": "https://go.apothekeversand.de/i/teva-nebusal-7-inhalationsloesung-erhoeht-die-mobilisierung-von-sekreten-in-den-unteren-atemwegen-60-st-ampullen-67-41-eur-pzn-09332413/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5MzMyNDEzXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGQ1MWU1ZjgxMzJjY2VkNmVmZDk4YjgzMzdjNjUzODU4ZDI2ZmRjNQ",
            "brand": "Teva",
            "currency": "EUR",
            "min_price": 67.41,
            "max_price": 67.41,
            "row_count": 1,
            "merchant_count": 1,
            "detail_url": "preisvergleich.php?q=09332413",
            "description": "Inhalationslösung zur gezielten Versorgung Lösung zum Inhalieren Medizinprodukt aus der Apotheke Hersteller: Teva GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 09332413",
            "order_pos": 0
        }
    ],
    "single_rows_all": [],
    "get": {
        "debug": "1",
        "q": "Teva"
    }
}