Debug JSON

{
    "tpl": "apotheke",
    "group_id_type": "pzn",
    "q": "Klettorell",
    "qRaw": "Klettorell",
    "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": "klettorell*",
    "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": "klettorell*"
    },
    "quick_counts": {
        "final_count": 4,
        "has_fts": 1,
        "has_json1": 0,
        "has_found_ids_json": 1,
        "has_final_category_path": 1,
        "fts_query": "klettorell*",
        "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": 4,
    "grouped_count": 3,
    "grouped_source_rows_count": 4,
    "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": "Kosmetik und Körperpflege/Körperpflege",
            "count": 1,
            "depth": 1
        }
    ],
    "raw_rows_all": [
        {
            "id": "316701",
            "title": "Klettorell Shampoo 150ml",
            "merchant_name": "Volksversand Versandapotheke DE",
            "category": null,
            "brand": "Klettorell",
            "ean": null,
            "price": "EUR10.90",
            "image_url": "https://go.apothekeversand.de/i/klettorell-shampoo-150ml-10-90-eur-pzn-09262150/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRjhiJTJGMzYlMkY4YiUyRjEwNDYzMjk4XzEyODB4MTI4MC5qcGcmZmVlZElkPTMwOTQ5Jms9NWRmNDUxNmFiMDA0ZTNmMzc3ODE5NzM3MGNmOGViZTQ3NDYxZmNjMQ",
            "link": "https://go.apothekeversand.de/r/klettorell-shampoo-150ml-10-90-eur-pzn-09262150/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00NDU1NjMxODM0MCZhPTU3OTcxMyZtPTEzOTg0",
            "found_ids_json": "[{\"type\":\"pzn\",\"value\":\"09262150\"}]",
            "category_path_runtime": "",
            "gtin": null,
            "mpn": "09262150",
            "description": "PZN: 09262150 Klettorell Shampoo 150ml",
            "short_description": "Klettorell Shampoo 150ml günstig bestellen! ✓, Gratis-Versand für Bonuskunden ✓, Schnelle Lieferung ✓, Großes Sortiment",
            "price_num": "10.9",
            "delivery_cost": "3.49",
            "awin_merchant_id": "13984",
            "alternate_image": null,
            "price_old": null,
            "savings_percent": null,
            "isbn": null,
            "merchant_category": null,
            "final_category_path": null,
            "group_pzn": "09262150",
            "family_ids_json": "[{\"type\":\"pzn\",\"value\":\"09262150\"}]",
            "family_signature": "apotheke|title|klettorell-shampoo",
            "family_variant_key": "150-ml",
            "family_variant_label": "150 ml",
            "family_type": null,
            "images": [
                "https://go.apothekeversand.de/i/klettorell-shampoo-150ml-10-90-eur-pzn-09262150/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRjhiJTJGMzYlMkY4YiUyRjEwNDYzMjk4XzEyODB4MTI4MC5qcGcmZmVlZElkPTMwOTQ5Jms9NWRmNDUxNmFiMDA0ZTNmMzc3ODE5NzM3MGNmOGViZTQ3NDYxZmNjMQ"
            ],
            "final_category_key_runtime": "",
            "final_category_leaf_runtime": "",
            "final_category_depth_runtime": 0,
            "category_display": "",
            "category_leaf_label": "",
            "price_value": 10.9,
            "price_old_value": null,
            "savings_percent_value": null,
            "discount_percent": null,
            "price_currency": "EUR",
            "deeplink": "https://go.apothekeversand.de/r/klettorell-shampoo-150ml-10-90-eur-pzn-09262150/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00NDU1NjMxODM0MCZhPTU3OTcxMyZtPTEzOTg0",
            "brand_name": "Klettorell",
            "product_short_description": "Klettorell Shampoo 150ml günstig bestellen! ✓, Gratis-Versand für Bonuskunden ✓, Schnelle Lieferung ✓, Großes Sortiment",
            "pack_size_label": "150 Milliliter",
            "slug_pzn": "09262150"
        },
        {
            "id": "291114",
            "title": "Klettorell Creme Structur",
            "merchant_name": "Volksversand Versandapotheke DE",
            "category": null,
            "brand": null,
            "ean": null,
            "price": "EUR25.00",
            "image_url": "https://go.apothekeversand.de/i/klettorell-creme-structur-25-00-eur-pzn-00044351/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRmRlJTJGMmUlMkYwMSUyRjEwMjg2MDA0LWtsZXR0b3JlbGxfY3JlbWVfc3RydWN0dXJfMTI4MHgxMjgwLmpwZyZmZWVkSWQ9MzA5NDkmaz1lZGNhZDJjYzA2Nzc4ZGQ2YjllZDQ0OGVkNGFhNmI0M2E4YjdhMGVh",
            "link": "https://go.apothekeversand.de/r/klettorell-creme-structur-25-00-eur-pzn-00044351/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zMDg5MTkwODA1OSZhPTU3OTcxMyZtPTEzOTg0",
            "found_ids_json": "[{\"type\":\"pzn\",\"value\":\"00044351\"}]",
            "category_path_runtime": "",
            "gtin": null,
            "mpn": "00044351",
            "description": "PZN: 00044351 Klettorell Creme Structur",
            "short_description": "Klettorell Creme Structur günstig bestellen! ✓, Gratis-Versand für Bonuskunden ✓, Schnelle Lieferung ✓, Großes Sortiment",
            "price_num": "25.0",
            "delivery_cost": "0.00",
            "awin_merchant_id": "13984",
            "alternate_image": null,
            "price_old": null,
            "savings_percent": null,
            "isbn": null,
            "merchant_category": null,
            "final_category_path": null,
            "group_pzn": "00044351",
            "family_ids_json": "[{\"type\":\"pzn\",\"value\":\"00044351\"}]",
            "family_signature": "apotheke|title|klettorell-structur|form-creme",
            "family_variant_key": "",
            "family_variant_label": "",
            "family_type": null,
            "images": [
                "https://go.apothekeversand.de/i/klettorell-creme-structur-25-00-eur-pzn-00044351/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRmRlJTJGMmUlMkYwMSUyRjEwMjg2MDA0LWtsZXR0b3JlbGxfY3JlbWVfc3RydWN0dXJfMTI4MHgxMjgwLmpwZyZmZWVkSWQ9MzA5NDkmaz1lZGNhZDJjYzA2Nzc4ZGQ2YjllZDQ0OGVkNGFhNmI0M2E4YjdhMGVh"
            ],
            "final_category_key_runtime": "",
            "final_category_leaf_runtime": "",
            "final_category_depth_runtime": 0,
            "category_display": "",
            "category_leaf_label": "",
            "price_value": 25,
            "price_old_value": null,
            "savings_percent_value": null,
            "discount_percent": null,
            "price_currency": "EUR",
            "deeplink": "https://go.apothekeversand.de/r/klettorell-creme-structur-25-00-eur-pzn-00044351/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zMDg5MTkwODA1OSZhPTU3OTcxMyZtPTEzOTg0",
            "brand_name": "",
            "product_short_description": "Klettorell Creme Structur günstig bestellen! ✓, Gratis-Versand für Bonuskunden ✓, Schnelle Lieferung ✓, Großes Sortiment",
            "pack_size_label": "",
            "slug_pzn": "00044351"
        },
        {
            "id": "277092",
            "title": "Klettorell Flüssigseife",
            "merchant_name": "Volksversand Versandapotheke DE",
            "category": null,
            "brand": null,
            "ean": null,
            "price": "EUR11.99",
            "image_url": "https://go.apothekeversand.de/i/klettorell-fluessigseife-11-99-eur-pzn-00051204/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRmVlJTJGY2YlMkYzYSUyRjEwMTI2MDE4XzEyODB4MTI4MC5qcGcmZmVlZElkPTMwOTQ5Jms9OWUzYjkzYzU4Yjc5NTIwZGI0ZmNmZDRlNTcxMTBjNjZjZjI1ODY4Ng",
            "link": "https://go.apothekeversand.de/r/klettorell-fluessigseife-11-99-eur-pzn-00051204/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0yMzI2NTkyNDkxMSZhPTU3OTcxMyZtPTEzOTg0",
            "found_ids_json": "[{\"type\":\"pzn\",\"value\":\"00051204\"}]",
            "category_path_runtime": "",
            "gtin": null,
            "mpn": "00051204",
            "description": "PZN: 00051204 Klettorell Flüssigseife",
            "short_description": "Klettorell Flüssigseife günstig bestellen! ✓, Gratis-Versand für Bonuskunden ✓, Schnelle Lieferung ✓, Großes Sortiment",
            "price_num": "11.99",
            "delivery_cost": "3.49",
            "awin_merchant_id": "13984",
            "alternate_image": null,
            "price_old": null,
            "savings_percent": null,
            "isbn": null,
            "merchant_category": null,
            "final_category_path": null,
            "group_pzn": "00051204",
            "family_ids_json": "[{\"type\":\"pzn\",\"value\":\"00051204\"}]",
            "family_signature": "apotheke|title|klettorell-fluessigseife",
            "family_variant_key": "",
            "family_variant_label": "",
            "family_type": null,
            "images": [
                "https://go.apothekeversand.de/i/klettorell-fluessigseife-11-99-eur-pzn-00051204/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRmVlJTJGY2YlMkYzYSUyRjEwMTI2MDE4XzEyODB4MTI4MC5qcGcmZmVlZElkPTMwOTQ5Jms9OWUzYjkzYzU4Yjc5NTIwZGI0ZmNmZDRlNTcxMTBjNjZjZjI1ODY4Ng"
            ],
            "final_category_key_runtime": "",
            "final_category_leaf_runtime": "",
            "final_category_depth_runtime": 0,
            "category_display": "",
            "category_leaf_label": "",
            "price_value": 11.99,
            "price_old_value": null,
            "savings_percent_value": null,
            "discount_percent": null,
            "price_currency": "EUR",
            "deeplink": "https://go.apothekeversand.de/r/klettorell-fluessigseife-11-99-eur-pzn-00051204/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0yMzI2NTkyNDkxMSZhPTU3OTcxMyZtPTEzOTg0",
            "brand_name": "",
            "product_short_description": "Klettorell Flüssigseife günstig bestellen! ✓, Gratis-Versand für Bonuskunden ✓, Schnelle Lieferung ✓, Großes Sortiment",
            "pack_size_label": "",
            "slug_pzn": "00051204"
        },
        {
            "id": "121194",
            "title": "Klettorell Flüssigseife, 150 ml Lösung",
            "merchant_name": "Apohealth DE",
            "category": "Kosmetik und Körperpflege/Körperpflege",
            "brand": "Klettorell",
            "ean": "4150000512044",
            "price": "EUR13.03",
            "image_url": "https://go.apothekeversand.de/i/klettorell-fluessigseife-150-ml-loesung-13-03-eur-pzn-00051204/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjc4ZDdhMGVlNTEzNmE3NDQ3ZmZiYmU3MTcxYTUyNWNkLmpwZWcmZmVlZElkPTk1NTI2Jms9OWE5Nzc2NzNkYmJhOTg1OWI5NWUyNGJhOTY4ZjkxODQ0OWE4ZmQ4Nw",
            "link": "https://go.apothekeversand.de/r/klettorell-fluessigseife-150-ml-loesung-13-03-eur-pzn-00051204/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00NDU1MTUxMzY3NSZhPTU4NDU3NyZtPTk4NzI5",
            "found_ids_json": "[{\"type\":\"mpn\",\"value\":\"51204\"},{\"type\":\"ean\",\"value\":\"4150000512044\"},{\"type\":\"pzn\",\"value\":\"00051204\"}]",
            "category_path_runtime": "Kosmetik und Körperpflege/Körperpflege",
            "gtin": null,
            "mpn": "51204",
            "description": "hochwertige medizinische Hautpflege für empfindliche Haut Seife zur gezielten Anwendung Dermokosmetik aus der Apotheke Hersteller: Schumann-Morwinski Vertrieb+Kommunikation GmbH & Co. KG, Deutschland (Originalprodukt aus Deutschland) PZN: 00051204",
            "short_description": "",
            "price_num": "13.03",
            "delivery_cost": "DE: 2.40 EUR / 1-3 days ; AT: 2.40 EUR / 2-4 days ; CH: 2.40 EUR / 3-5 days ; US: 22.80 EUR / 3-5 days ; CA: 4.20 EUR / 6-10 days ; GB: 2.40 EUR / 2-5 days ; FR: 3.60 EUR / 3-4 days ;",
            "awin_merchant_id": "98729",
            "alternate_image": null,
            "price_old": "11.49",
            "savings_percent": null,
            "isbn": null,
            "merchant_category": "Kosmetik und Körperpflege/Körperpflege",
            "final_category_path": "Kosmetik und Körperpflege/Körperpflege",
            "group_pzn": "00051204",
            "family_ids_json": "[{\"type\":\"mpn\",\"value\":\"51204\"},{\"type\":\"ean\",\"value\":\"4150000512044\"},{\"type\":\"pzn\",\"value\":\"00051204\"}]",
            "family_signature": "apotheke|title|klettorell-fluessigseife|form-loesung",
            "family_variant_key": "150-ml",
            "family_variant_label": "150 ml",
            "family_type": null,
            "images": [
                "https://go.apothekeversand.de/i/klettorell-fluessigseife-150-ml-loesung-13-03-eur-pzn-00051204/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjc4ZDdhMGVlNTEzNmE3NDQ3ZmZiYmU3MTcxYTUyNWNkLmpwZWcmZmVlZElkPTk1NTI2Jms9OWE5Nzc2NzNkYmJhOTg1OWI5NWUyNGJhOTY4ZjkxODQ0OWE4ZmQ4Nw"
            ],
            "final_category_key_runtime": "kosmetik-und-koerperpflege-koerperpflege",
            "final_category_leaf_runtime": "Kosmetik und Körperpflege/Körperpflege",
            "final_category_depth_runtime": 1,
            "category_display": "Kosmetik und Körperpflege/Körperpflege",
            "category_leaf_label": "Kosmetik und Körperpflege/Körperpflege",
            "price_value": 13.03,
            "price_old_value": 11.49,
            "savings_percent_value": null,
            "discount_percent": null,
            "price_currency": "EUR",
            "deeplink": "https://go.apothekeversand.de/r/klettorell-fluessigseife-150-ml-loesung-13-03-eur-pzn-00051204/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00NDU1MTUxMzY3NSZhPTU4NDU3NyZtPTk4NzI5",
            "brand_name": "Klettorell",
            "product_short_description": "",
            "pack_size_label": "150 Milliliter",
            "slug_pzn": "00051204"
        }
    ],
    "grouped_rows_all": [
        {
            "group_id": "00044351",
            "group_type": "PZN",
            "title": "Klettorell Creme Structur",
            "image_url": "https://go.apothekeversand.de/i/klettorell-creme-structur-25-00-eur-pzn-00044351/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRmRlJTJGMmUlMkYwMSUyRjEwMjg2MDA0LWtsZXR0b3JlbGxfY3JlbWVfc3RydWN0dXJfMTI4MHgxMjgwLmpwZyZmZWVkSWQ9MzA5NDkmaz1lZGNhZDJjYzA2Nzc4ZGQ2YjllZDQ0OGVkNGFhNmI0M2E4YjdhMGVh",
            "brand": "",
            "currency": "EUR",
            "min_price": 25,
            "max_price": 25,
            "row_count": 1,
            "merchant_count": 1,
            "detail_url": "preisvergleich.php?q=00044351",
            "description": "PZN: 00044351 Klettorell Creme Structur",
            "order_pos": 1
        },
        {
            "group_id": "00051204",
            "group_type": "PZN",
            "title": "Klettorell Flüssigseife",
            "image_url": "https://go.apothekeversand.de/i/klettorell-fluessigseife-11-99-eur-pzn-00051204/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRmVlJTJGY2YlMkYzYSUyRjEwMTI2MDE4XzEyODB4MTI4MC5qcGcmZmVlZElkPTMwOTQ5Jms9OWUzYjkzYzU4Yjc5NTIwZGI0ZmNmZDRlNTcxMTBjNjZjZjI1ODY4Ng",
            "brand": "",
            "currency": "EUR",
            "min_price": 11.99,
            "max_price": 13.03,
            "row_count": 2,
            "merchant_count": 2,
            "detail_url": "preisvergleich.php?q=00051204",
            "description": "PZN: 00051204 Klettorell Flüssigseife",
            "order_pos": 2
        },
        {
            "group_id": "09262150",
            "group_type": "PZN",
            "title": "Klettorell Shampoo 150ml",
            "image_url": "https://go.apothekeversand.de/i/klettorell-shampoo-150ml-10-90-eur-pzn-09262150/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBdm9sa3N2ZXJzYW5kLmRlJTJGbWVkaWElMkZpbWFnZSUyRjhiJTJGMzYlMkY4YiUyRjEwNDYzMjk4XzEyODB4MTI4MC5qcGcmZmVlZElkPTMwOTQ5Jms9NWRmNDUxNmFiMDA0ZTNmMzc3ODE5NzM3MGNmOGViZTQ3NDYxZmNjMQ",
            "brand": "Klettorell",
            "currency": "EUR",
            "min_price": 10.9,
            "max_price": 10.9,
            "row_count": 1,
            "merchant_count": 1,
            "detail_url": "preisvergleich.php?q=09262150",
            "description": "PZN: 09262150 Klettorell Shampoo 150ml",
            "order_pos": 0
        }
    ],
    "single_rows_all": [],
    "get": {
        "debug": "1",
        "q": "Klettorell"
    }
}