Debug JSON
{
"tpl": "apotheke",
"group_id_type": "pzn",
"q": "",
"qRaw": "4150039356428",
"code_value": "4150039356428",
"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\":\"4150039356428\"%",
":json_like_type_name": "%\"TYPE\":\"EAN\",\"NAME\":\"4150039356428\"%",
":direct_ean": "4150039356428"
},
"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": "4150039356428",
"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": "4150039356428",
"group_type": "EAN",
"title": "P-Tabletten blau Lichtenstein, 100 St. Tabletten",
"brand": "Zentiva",
"description": "hochwertiges medizinisches Hilfsmittel zur gezielten Versorgung Tabletten zum Einnehmen apothekenpflichtiges Arzneimittel Hersteller: Zentiva Pharma GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 03935642",
"image_url": "https://go.apothekeversand.de/i/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAzOTM1NjQyXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Zjk1OGFlYmJkMWM1MWMzODdhZGIzMjA3MDNmNWNlNjZmNjc1NmM2Mw",
"min_price": 33.46,
"max_price": 33.46,
"row_count": 1,
"merchant_count": 1
},
"detail_lead": {
"id": "128686",
"title": "P-Tabletten blau Lichtenstein, 100 St. Tabletten",
"merchant_name": "Apohealth DE",
"category": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"brand": "Zentiva",
"ean": "4150039356428",
"price": "EUR33.46",
"image_url": "https://go.apothekeversand.de/i/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAzOTM1NjQyXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Zjk1OGFlYmJkMWM1MWMzODdhZGIzMjA3MDNmNWNlNjZmNjc1NmM2Mw",
"link": "https://go.apothekeversand.de/r/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTIwMTc2NyZhPTU4NDU3NyZtPTk4NzI5",
"found_ids_json": "[{\"type\":\"pzn\",\"value\":\"03935642\"},{\"type\":\"ean\",\"value\":\"4150039356428\"}]",
"category_path_runtime": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"gtin": null,
"mpn": "3935642",
"description": "hochwertiges medizinisches Hilfsmittel zur gezielten Versorgung Tabletten zum Einnehmen apothekenpflichtiges Arzneimittel Hersteller: Zentiva Pharma GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 03935642",
"short_description": "",
"price_num": "33.46",
"delivery_cost": "DE: 0.00 EUR / 1-3 days ; AT: 3.00 EUR / 2-4 days ; CH: 4.20 EUR / 3-5 days ; US: 21.00 EUR / 3-5 days ; CA: 3.60 EUR / 6-10 days ; GB: 1.80 EUR / 2-5 days ; FR: 4.20 EUR / 3-4 days ;",
"awin_merchant_id": "98729",
"alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/3c1769aeb94b18a5cf62a66363b8d8e9.jpeg",
"price_old": "34.49",
"savings_percent": null,
"isbn": null,
"merchant_category": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"final_category_path": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"group_pzn": "03935642",
"family_ids_json": "[{\"type\":\"pzn\",\"value\":\"03935636\"},{\"type\":\"ean\",\"value\":\"4150039356367\"},{\"type\":\"pzn\",\"value\":\"03935642\"},{\"type\":\"ean\",\"value\":\"4150039356428\"}]",
"family_signature": "apotheke|title|p-blau-lichtenstein|form-tabletten",
"family_variant_key": "100-st",
"family_variant_label": "100 St",
"family_type": null,
"images": [
"https://go.apothekeversand.de/i/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAzOTM1NjQyXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Zjk1OGFlYmJkMWM1MWMzODdhZGIzMjA3MDNmNWNlNjZmNjc1NmM2Mw",
"https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/3c1769aeb94b18a5cf62a66363b8d8e9.jpeg"
],
"final_category_key_runtime": "sonstige-arzneimittel-sonstige-arzneimittel",
"final_category_leaf_runtime": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"final_category_depth_runtime": 1,
"category_display": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"category_leaf_label": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"price_value": 33.46,
"price_old_value": 34.49,
"savings_percent_value": null,
"discount_percent": 3,
"price_currency": "EUR",
"deeplink": "https://go.apothekeversand.de/r/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTIwMTc2NyZhPTU4NDU3NyZtPTk4NzI5",
"brand_name": "Zentiva",
"product_short_description": "",
"pack_size_label": "100 Stück",
"slug_pzn": "03935642"
},
"price_history_pzn": "03935642",
"quicknav_top_paths_debug": [
{
"path": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"count": 1,
"depth": 1
}
],
"raw_rows_all": [
{
"id": "128686",
"title": "P-Tabletten blau Lichtenstein, 100 St. Tabletten",
"merchant_name": "Apohealth DE",
"category": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"brand": "Zentiva",
"ean": "4150039356428",
"price": "EUR33.46",
"image_url": "https://go.apothekeversand.de/i/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAzOTM1NjQyXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Zjk1OGFlYmJkMWM1MWMzODdhZGIzMjA3MDNmNWNlNjZmNjc1NmM2Mw",
"link": "https://go.apothekeversand.de/r/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTIwMTc2NyZhPTU4NDU3NyZtPTk4NzI5",
"found_ids_json": "[{\"type\":\"pzn\",\"value\":\"03935642\"},{\"type\":\"ean\",\"value\":\"4150039356428\"}]",
"category_path_runtime": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"gtin": null,
"mpn": "3935642",
"description": "hochwertiges medizinisches Hilfsmittel zur gezielten Versorgung Tabletten zum Einnehmen apothekenpflichtiges Arzneimittel Hersteller: Zentiva Pharma GmbH, Deutschland (Originalprodukt aus Deutschland) PZN: 03935642",
"short_description": "",
"price_num": "33.46",
"delivery_cost": "DE: 0.00 EUR / 1-3 days ; AT: 3.00 EUR / 2-4 days ; CH: 4.20 EUR / 3-5 days ; US: 21.00 EUR / 3-5 days ; CA: 3.60 EUR / 6-10 days ; GB: 1.80 EUR / 2-5 days ; FR: 4.20 EUR / 3-4 days ;",
"awin_merchant_id": "98729",
"alternate_image": "https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/3c1769aeb94b18a5cf62a66363b8d8e9.jpeg",
"price_old": "34.49",
"savings_percent": null,
"isbn": null,
"merchant_category": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"final_category_path": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"group_pzn": "03935642",
"family_ids_json": "[{\"type\":\"pzn\",\"value\":\"03935636\"},{\"type\":\"ean\",\"value\":\"4150039356367\"},{\"type\":\"pzn\",\"value\":\"03935642\"},{\"type\":\"ean\",\"value\":\"4150039356428\"}]",
"family_signature": "apotheke|title|p-blau-lichtenstein|form-tabletten",
"family_variant_key": "100-st",
"family_variant_label": "100 St",
"family_type": null,
"images": [
"https://go.apothekeversand.de/i/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly9pbWFnZXMyLnByb2R1Y3RzZXJ2ZS5jb20vP3c9MjAwJmg9MjAwJmJnPXdoaXRlJnRyaW09NSZ0PWxldHRlcmJveCZ1cmw9c3NsJTNBbmJnMS55b3VyLW9iamVjdHN0b3JhZ2UuY29tJTJGaW5zcGlyYXgtaW1hZ2Utc2VydmVyLWJ1Y2tldCUyRjAzOTM1NjQyXzAxLmpwZWcmZmVlZElkPTk1NTI2Jms9Zjk1OGFlYmJkMWM1MWMzODdhZGIzMjA3MDNmNWNlNjZmNjc1NmM2Mw",
"https://nbg1.your-objectstorage.com/inspirax-image-server-bucket/3c1769aeb94b18a5cf62a66363b8d8e9.jpeg"
],
"final_category_key_runtime": "sonstige-arzneimittel-sonstige-arzneimittel",
"final_category_leaf_runtime": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"final_category_depth_runtime": 1,
"category_display": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"category_leaf_label": "Sonstige Arzneimittel/Sonstige Arzneimittel",
"price_value": 33.46,
"price_old_value": 34.49,
"savings_percent_value": null,
"discount_percent": 3,
"price_currency": "EUR",
"deeplink": "https://go.apothekeversand.de/r/p-tabletten-blau-lichtenstein-100-st-tabletten-33-46-eur-pzn-03935642/aHR0cHM6Ly93d3cuYXdpbjEuY29tL3BjbGljay5waHA_cD0zODQxOTIwMTc2NyZhPTU4NDU3NyZtPTk4NzI5",
"brand_name": "Zentiva",
"product_short_description": "",
"pack_size_label": "100 Stück",
"slug_pzn": "03935642"
}
],
"grouped_rows_all": [],
"single_rows_all": [],
"get": {
"debug": "1",
"q": "4150039356428"
}
}
