Debug JSON
{
"tpl": "apotheke",
"group_id_type": "pzn",
"q": "",
"qRaw": "4150021207547",
"code_value": "4150021207547",
"code_type": "ean",
"cat": "",
"brand": "",
"shop": "",
"pmin": "",
"pmax": "",
"sort": "price_asc",
"page": 1,
"ps": 48,
"mode": "id_like_typed",
"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": "",
"search_where_sql": "WHERE ((\r\n UPPER(COALESCE(p.found_ids_json, '')) LIKE :json_like_type_value ESCAPE '\\'\r\n OR\r\n UPPER(COALESCE(p.found_ids_json, '')) LIKE :json_like_type_name ESCAPE '\\'\r\n ) OR COALESCE(p.ean, '') = :direct_ean)",
"search_bind": {
":json_like_type_value": "%\"TYPE\":\"EAN\",\"VALUE\":\"4150021207547\"%",
":json_like_type_name": "%\"TYPE\":\"EAN\",\"NAME\":\"4150021207547\"%",
":direct_ean": "4150021207547"
},
"quick_counts": {
"final_count": 1,
"has_fts": 1,
"has_json1": 0,
"has_found_ids_json": 1,
"has_final_category_path": 1,
"fts_query": "",
"group_id_type": "pzn",
"has_merchant_name": 1,
"has_image_url": 1
},
"raw_rows_truncated": false,
"raw_cap": 300,
"is_detail_view": true,
"detail_identifier": "4150021207547",
"detail_identifier_type": "EAN",
"detail_offer_count": 1,
"detail_merchant_count": 1,
"raw_rows_count": 1,
"grouped_count": 0,
"grouped_source_rows_count": 0,
"single_count": 0,
"display_total_count": 1,
"page_detail_rows_count": 1,
"grouped_rows_page_count": 0,
"single_rows_page_count": 0,
"detail_summary": {
"group_id": "4150021207547",
"group_type": "EAN",
"title": "DHU Aesculus D3 Dilution, 20 ml Lösung",
"brand": "DHU",
"description": "enthält homöopathisch potenzierten Wirkstoff zur Anwendung gemäß homöopathischen Arzneimittelbildern Lösung zum Einnehmen Homöopathisches Arzneimittel aus der Apotheke Hersteller: DHU-Arzneimittel GmbH & Co. KG, Deutschland (Originalprodukt aus Deutschland) PZN: 02120754",
"image_url": "https://go.apothekeversand.de/i/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAyMTIwNzU0XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Y2ZlN2YxYTVlMjM5MTUyZDdiODhiYmRiMjAxYjcwNWU2MDVkN2E5Ng",
"min_price": 14.72,
"max_price": 14.72,
"row_count": 1,
"merchant_count": 1
},
"detail_lead": {
"id": "125726",
"title": "DHU Aesculus D3 Dilution, 20 ml Lösung",
"merchant_name": "Apohealth DE",
"category": "Naturheilkunde/Klassische Homöopathie",
"brand": "DHU",
"ean": "4150021207547",
"price": "EUR14.72",
"image_url": "https://go.apothekeversand.de/i/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAyMTIwNzU0XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Y2ZlN2YxYTVlMjM5MTUyZDdiODhiYmRiMjAxYjcwNWU2MDVkN2E5Ng",
"link": "https://go.apothekeversand.de/r/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zOTcwMTU1NDY2NCZhPTU4NDU3NyZtPTk4NzI5",
"found_ids_json": "[{\"type\":\"pzn\",\"value\":\"02120754\"},{\"type\":\"ean\",\"value\":\"4150021207547\"}]",
"category_path_runtime": "Naturheilkunde/Klassische Homöopathie",
"gtin": null,
"mpn": "2120754",
"description": "enthält homöopathisch potenzierten Wirkstoff zur Anwendung gemäß homöopathischen Arzneimittelbildern Lösung zum Einnehmen Homöopathisches Arzneimittel aus der Apotheke Hersteller: DHU-Arzneimittel GmbH & Co. KG, Deutschland (Originalprodukt aus Deutschland) PZN: 02120754",
"short_description": "",
"price_num": "14.72",
"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: 2.40 EUR / 3-4 days ;",
"awin_merchant_id": "98729",
"alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/02120754_02.jpeg",
"price_old": "15.49",
"savings_percent": null,
"isbn": null,
"merchant_category": "Naturheilkunde/Klassische Homöopathie",
"final_category_path": "Naturheilkunde/Klassische Homöopathie",
"group_pzn": "02120754",
"family_ids_json": "[{\"type\":\"pzn\",\"value\":\"02120754\"},{\"type\":\"ean\",\"value\":\"4150021207547\"}]",
"family_signature": "apotheke|title|dhu-aesculus-d3-dilution|form-loesung",
"family_variant_key": "20-ml",
"family_variant_label": "20 ml",
"family_type": null,
"images": [
"https://go.apothekeversand.de/i/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAyMTIwNzU0XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Y2ZlN2YxYTVlMjM5MTUyZDdiODhiYmRiMjAxYjcwNWU2MDVkN2E5Ng",
"https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/02120754_02.jpeg"
],
"final_category_key_runtime": "naturheilkunde-klassische-homoeopathie",
"final_category_leaf_runtime": "Naturheilkunde/Klassische Homöopathie",
"final_category_depth_runtime": 1,
"category_display": "Naturheilkunde/Klassische Homöopathie",
"category_leaf_label": "Naturheilkunde/Klassische Homöopathie",
"price_value": 14.72,
"price_old_value": 15.49,
"savings_percent_value": null,
"discount_percent": 5,
"price_currency": "EUR",
"deeplink": "https://go.apothekeversand.de/r/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zOTcwMTU1NDY2NCZhPTU4NDU3NyZtPTk4NzI5",
"brand_name": "DHU",
"product_short_description": "",
"pack_size_label": "20 Milliliter",
"slug_pzn": "02120754"
},
"price_history_pzn": "02120754",
"quicknav_top_paths_debug": [
{
"path": "Naturheilkunde/Klassische Homöopathie",
"count": 1,
"depth": 1
}
],
"raw_rows_all": [
{
"id": "125726",
"title": "DHU Aesculus D3 Dilution, 20 ml Lösung",
"merchant_name": "Apohealth DE",
"category": "Naturheilkunde/Klassische Homöopathie",
"brand": "DHU",
"ean": "4150021207547",
"price": "EUR14.72",
"image_url": "https://go.apothekeversand.de/i/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAyMTIwNzU0XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Y2ZlN2YxYTVlMjM5MTUyZDdiODhiYmRiMjAxYjcwNWU2MDVkN2E5Ng",
"link": "https://go.apothekeversand.de/r/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zOTcwMTU1NDY2NCZhPTU4NDU3NyZtPTk4NzI5",
"found_ids_json": "[{\"type\":\"pzn\",\"value\":\"02120754\"},{\"type\":\"ean\",\"value\":\"4150021207547\"}]",
"category_path_runtime": "Naturheilkunde/Klassische Homöopathie",
"gtin": null,
"mpn": "2120754",
"description": "enthält homöopathisch potenzierten Wirkstoff zur Anwendung gemäß homöopathischen Arzneimittelbildern Lösung zum Einnehmen Homöopathisches Arzneimittel aus der Apotheke Hersteller: DHU-Arzneimittel GmbH & Co. KG, Deutschland (Originalprodukt aus Deutschland) PZN: 02120754",
"short_description": "",
"price_num": "14.72",
"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: 2.40 EUR / 3-4 days ;",
"awin_merchant_id": "98729",
"alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/02120754_02.jpeg",
"price_old": "15.49",
"savings_percent": null,
"isbn": null,
"merchant_category": "Naturheilkunde/Klassische Homöopathie",
"final_category_path": "Naturheilkunde/Klassische Homöopathie",
"group_pzn": "02120754",
"family_ids_json": "[{\"type\":\"pzn\",\"value\":\"02120754\"},{\"type\":\"ean\",\"value\":\"4150021207547\"}]",
"family_signature": "apotheke|title|dhu-aesculus-d3-dilution|form-loesung",
"family_variant_key": "20-ml",
"family_variant_label": "20 ml",
"family_type": null,
"images": [
"https://go.apothekeversand.de/i/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAyMTIwNzU0XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Y2ZlN2YxYTVlMjM5MTUyZDdiODhiYmRiMjAxYjcwNWU2MDVkN2E5Ng",
"https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/02120754_02.jpeg"
],
"final_category_key_runtime": "naturheilkunde-klassische-homoeopathie",
"final_category_leaf_runtime": "Naturheilkunde/Klassische Homöopathie",
"final_category_depth_runtime": 1,
"category_display": "Naturheilkunde/Klassische Homöopathie",
"category_leaf_label": "Naturheilkunde/Klassische Homöopathie",
"price_value": 14.72,
"price_old_value": 15.49,
"savings_percent_value": null,
"discount_percent": 5,
"price_currency": "EUR",
"deeplink": "https://go.apothekeversand.de/r/dhu-aesculus-d3-dilution-20-ml-loesung-14-72-eur-pzn-02120754/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zOTcwMTU1NDY2NCZhPTU4NDU3NyZtPTk4NzI5",
"brand_name": "DHU",
"product_short_description": "",
"pack_size_label": "20 Milliliter",
"slug_pzn": "02120754"
}
],
"grouped_rows_all": [],
"single_rows_all": [],
"get": {
"debug": "1",
"q": "4150021207547"
}
}
