Debug JSON
{
"tpl": "apotheke",
"group_id_type": "pzn",
"q": "",
"qRaw": "4150095173779",
"code_value": "4150095173779",
"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\":\"4150095173779\"%",
":json_like_type_name": "%\"TYPE\":\"EAN\",\"NAME\":\"4150095173779\"%",
":direct_ean": "4150095173779"
},
"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": "4150095173779",
"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": "4150095173779",
"group_type": "EAN",
"title": "GC MI Paste plus Minze mit Calcium und Phosphat, 40 g Paste",
"brand": "GC",
"description": "hochwertige medizinische Mundpflege zur Pflege von Zahnfleisch und Zähnen Creme zum Auftragen auf die Zähne Medizinprodukt aus der Apotheke Hersteller: Dent-O-Care Dentalvertriebs GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 09517377",
"image_url": "https://go.apothekeversand.de/i/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5NTE3Mzc3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGZiNTNjNjZkZWI5OWFiNzI0ZjhkMzk1MDE0ZGRmYzU3MGM3NDgyOQ",
"min_price": 26.36,
"max_price": 26.36,
"row_count": 1,
"merchant_count": 1
},
"detail_lead": {
"id": "137023",
"title": "GC MI Paste plus Minze mit Calcium und Phosphat, 40 g Paste",
"merchant_name": "Apohealth DE",
"category": "Kosmetik und Körperpflege/Zahnpflege",
"brand": "GC",
"ean": "4150095173779",
"price": "EUR26.36",
"image_url": "https://go.apothekeversand.de/i/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5NTE3Mzc3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGZiNTNjNjZkZWI5OWFiNzI0ZjhkMzk1MDE0ZGRmYzU3MGM3NDgyOQ",
"link": "https://go.apothekeversand.de/r/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00MDk4MjA5NzkzOCZhPTU4NDU3NyZtPTk4NzI5",
"found_ids_json": "[{\"type\":\"pzn\",\"value\":\"09517377\"},{\"type\":\"ean\",\"value\":\"4150095173779\"}]",
"category_path_runtime": "Kosmetik und Körperpflege/Zahnpflege",
"gtin": null,
"mpn": "9517377",
"description": "hochwertige medizinische Mundpflege zur Pflege von Zahnfleisch und Zähnen Creme zum Auftragen auf die Zähne Medizinprodukt aus der Apotheke Hersteller: Dent-O-Care Dentalvertriebs GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 09517377",
"short_description": "",
"price_num": "26.36",
"delivery_cost": "DE: 0.00 EUR / 1-3 days ; AT: 2.40 EUR / 2-4 days ; CH: 3.60 EUR / 3-5 days ; US: 20.40 EUR / 3-5 days ; CA: 2.40 EUR / 6-10 days ; GB: 1.20 EUR / 2-5 days ; FR: 3.60 EUR / 3-4 days ;",
"awin_merchant_id": "98729",
"alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/09517377_02.jpeg",
"price_old": "24.49",
"savings_percent": null,
"isbn": null,
"merchant_category": "Kosmetik und Körperpflege/Zahnpflege",
"final_category_path": "Kosmetik und Körperpflege/Zahnpflege",
"group_pzn": "09517377",
"family_ids_json": "[{\"type\":\"pzn\",\"value\":\"09517377\"},{\"type\":\"ean\",\"value\":\"4150095173779\"}]",
"family_signature": "apotheke|title|gc-mi-paste-plus-minze-mit-calcium-und-phosphat-paste|form-creme",
"family_variant_key": "40-g",
"family_variant_label": "40 g",
"family_type": null,
"images": [
"https://go.apothekeversand.de/i/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5NTE3Mzc3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGZiNTNjNjZkZWI5OWFiNzI0ZjhkMzk1MDE0ZGRmYzU3MGM3NDgyOQ",
"https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/09517377_02.jpeg"
],
"final_category_key_runtime": "kosmetik-und-koerperpflege-zahnpflege",
"final_category_leaf_runtime": "Kosmetik und Körperpflege/Zahnpflege",
"final_category_depth_runtime": 1,
"category_display": "Kosmetik und Körperpflege/Zahnpflege",
"category_leaf_label": "Kosmetik und Körperpflege/Zahnpflege",
"price_value": 26.36,
"price_old_value": 24.49,
"savings_percent_value": null,
"discount_percent": null,
"price_currency": "EUR",
"deeplink": "https://go.apothekeversand.de/r/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00MDk4MjA5NzkzOCZhPTU4NDU3NyZtPTk4NzI5",
"brand_name": "GC",
"product_short_description": "",
"pack_size_label": "40 Gramm",
"slug_pzn": "09517377"
},
"price_history_pzn": "09517377",
"quicknav_top_paths_debug": [
{
"path": "Kosmetik und Körperpflege/Zahnpflege",
"count": 1,
"depth": 1
}
],
"raw_rows_all": [
{
"id": "137023",
"title": "GC MI Paste plus Minze mit Calcium und Phosphat, 40 g Paste",
"merchant_name": "Apohealth DE",
"category": "Kosmetik und Körperpflege/Zahnpflege",
"brand": "GC",
"ean": "4150095173779",
"price": "EUR26.36",
"image_url": "https://go.apothekeversand.de/i/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5NTE3Mzc3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGZiNTNjNjZkZWI5OWFiNzI0ZjhkMzk1MDE0ZGRmYzU3MGM3NDgyOQ",
"link": "https://go.apothekeversand.de/r/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00MDk4MjA5NzkzOCZhPTU4NDU3NyZtPTk4NzI5",
"found_ids_json": "[{\"type\":\"pzn\",\"value\":\"09517377\"},{\"type\":\"ean\",\"value\":\"4150095173779\"}]",
"category_path_runtime": "Kosmetik und Körperpflege/Zahnpflege",
"gtin": null,
"mpn": "9517377",
"description": "hochwertige medizinische Mundpflege zur Pflege von Zahnfleisch und Zähnen Creme zum Auftragen auf die Zähne Medizinprodukt aus der Apotheke Hersteller: Dent-O-Care Dentalvertriebs GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 09517377",
"short_description": "",
"price_num": "26.36",
"delivery_cost": "DE: 0.00 EUR / 1-3 days ; AT: 2.40 EUR / 2-4 days ; CH: 3.60 EUR / 3-5 days ; US: 20.40 EUR / 3-5 days ; CA: 2.40 EUR / 6-10 days ; GB: 1.20 EUR / 2-5 days ; FR: 3.60 EUR / 3-4 days ;",
"awin_merchant_id": "98729",
"alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/09517377_02.jpeg",
"price_old": "24.49",
"savings_percent": null,
"isbn": null,
"merchant_category": "Kosmetik und Körperpflege/Zahnpflege",
"final_category_path": "Kosmetik und Körperpflege/Zahnpflege",
"group_pzn": "09517377",
"family_ids_json": "[{\"type\":\"pzn\",\"value\":\"09517377\"},{\"type\":\"ean\",\"value\":\"4150095173779\"}]",
"family_signature": "apotheke|title|gc-mi-paste-plus-minze-mit-calcium-und-phosphat-paste|form-creme",
"family_variant_key": "40-g",
"family_variant_label": "40 g",
"family_type": null,
"images": [
"https://go.apothekeversand.de/i/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjA5NTE3Mzc3XzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9ZGZiNTNjNjZkZWI5OWFiNzI0ZjhkMzk1MDE0ZGRmYzU3MGM3NDgyOQ",
"https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/09517377_02.jpeg"
],
"final_category_key_runtime": "kosmetik-und-koerperpflege-zahnpflege",
"final_category_leaf_runtime": "Kosmetik und Körperpflege/Zahnpflege",
"final_category_depth_runtime": 1,
"category_display": "Kosmetik und Körperpflege/Zahnpflege",
"category_leaf_label": "Kosmetik und Körperpflege/Zahnpflege",
"price_value": 26.36,
"price_old_value": 24.49,
"savings_percent_value": null,
"discount_percent": null,
"price_currency": "EUR",
"deeplink": "https://go.apothekeversand.de/r/gc-mi-paste-plus-minze-mit-calcium-und-phosphat-40-g-paste-26-36-eur-pzn-09517377/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD00MDk4MjA5NzkzOCZhPTU4NDU3NyZtPTk4NzI5",
"brand_name": "GC",
"product_short_description": "",
"pack_size_label": "40 Gramm",
"slug_pzn": "09517377"
}
],
"grouped_rows_all": [],
"single_rows_all": [],
"get": {
"debug": "1",
"q": "4150095173779"
}
}
