Radeon R7 M445 vs GeForce GTX 280M
Aggregierte Leistungsbewertung
Wir haben Radeon R7 M445 und GeForce GTX 280M miteinander verglichen und dabei die technischen Daten und alle relevanten Benchmarks berücksichtigt.
R7 M445 übertrifft GTX 280M um beeindruckende 64%, basierend auf unseren aggregierten Benchmark-Ergebnissen.
Primäre Details
Informationen über den Typ (für Desktops oder Laptops) und die Architektur von Radeon R7 M445 und GeForce GTX 280M sowie über die Startzeit des Verkaufs und die Kosten zu diesem Zeitpunkt.
| Platz in der Leistungsbewertung | 804 | 938 |
| Platz nach Beliebtheit | nicht in den Top-100 | nicht in den Top-100 |
| Bewertung der Kostenwirksamkeit | 0.10 | 0.17 |
| Architektur | GCN (2011−2017) | G9x (2007−2010) |
| Codename | Meso | N10E-GTX |
| Typ | Für Laptops | Für Laptops |
| Veröffentlichungsdatum | 15 Mai 2016 (8 Jahre vor) | 2 März 2009 (15 Jahre vor) |
Bewertung der Kostenwirksamkeit
Um einen Index zu erhalten, vergleichen wir die Leistung von Grafikkarten und ihre Kosten, wobei die Kosten anderer Grafikkarten berücksichtigt werden.
GTX 280M hat ein 70% besseres Preis-Leistungs-Verhältnis als R7 M445.
Detaillierte Spezifikationen
Allgemeine Parameter von Radeon R7 M445 und GeForce GTX 280M: Anzahl der Shader, Frequenz des Videokerns, technologischer Prozess, Texturierungs- und Rechengeschwindigkeit. Diese Parameter sprechen indirekt über die Leistung von Radeon R7 M445 und GeForce GTX 280M, obwohl für eine genaue Bewertung die Ergebnisse von Benchmarks und Spieletests berücksichtigt werden müssen.
| Anzahl der Shader-Prozessoren | 320 | 128 |
| Kernfrequenz | 920 MHz | 585 MHz |
| Anzahl der Transistoren | 1,550 million | 754 million |
| Technologischer Herstellungsprozess | 28 nm | 55 nm |
| Leistungsaufnahme (TDP) | 15-25 Watt | 75 Watt |
| Texturiergeschwindigkeit | 18.40 | 37.44 |
| Gleitkomma-Leistung | 588.8 gflops | 374.5 gflops |
Formfaktor und Kompatibilität
Informationen zur Kompatibilität von Radeon R7 M445 und GeForce GTX 280M mit anderen Computerkomponenten. Es ist nützlich, wenn Sie z.B eine zukünftige Computerkonfiguration auswählen oder die vorhandene aktualisieren möchten. Bei Laptop-Grafikkarten ist das die geschätzte Größe des Laptops, Bus und Anschluss, wenn die Grafikkarte in einen Steckplatz gesteckt wird, anstatt mit dem Motherboard verlötet zu werden.
| Laptop-Größe | keine Angaben | large |
| Schnittstelle | PCIe 3.0 x8 | MXM-IV |
VRAM-Kapazität und -Typ
Die Parameter des auf Radeon R7 M445 und GeForce GTX 280M installierten Speichers sind Typ, Größe, Bus, Frequenz und Bandbreite. Die in den Prozessor integrierten Grafikkarten, die keinen eigenen Speicher haben, werden einen gemeinsam genutzten Teil des RAM-Systems verwenden.
| Speichertyp | GDDR5 | GDDR3 |
| Maximale Speicherkapazität | 4 GB | 1 GB |
| Speicherbusbreite | 64 Bit | 256 Bit |
| Speicherfrequenz | 2000 MHz | 950 MHz |
| Speicherbandbreite | 32 GB/s | 60.8 GB/s |
| Multiplexspeicher | - | - |
Konnektivität und Ausgänge
Arten und Anzahl der Videoanschlüsse auf Radeon R7 M445 und GeForce GTX 280M. In der Regel ist dieser Abschnitt nur für Desktop-Referenzvideokarten relevant, da für Notebooks die Verfügbarkeit bestimmter Videoausgänge vom Modell des Laptops abhängt.
| Videoanschlüsse | No outputs | No outputs |
API-Kompatibilität
Die von Radeon R7 M445 und GeForce GTX 280M unterstützten APIs, einschließlich ihrer Versionen.
| DirectX | 12 (12_0) | 11.1 (10_0) |
| Shader-Modell | 6.0 | 4.0 |
| OpenGL | 4.6 | 3.3 |
| OpenCL | 2.0 | 1.1 |
| Vulkan | 1.2.131 | N/A |
| CUDA | keine Angaben | + |
Synthetische Benchmark-Leistung
Nicht-Gaming-Benchmarks Leistung von Radeon R7 M445 und GeForce GTX 280M. Die Gesamtpunktzahl liegt zwischen 0 und 100, wobei 100 der derzeit schnellsten Grafikkarte entspricht.
Kombinierte synthetische Benchmark-Ergebnisse
Dies ist unsere kombinierte Benchmark-Leistungsbewertung. Wir verbessern regelmäßig unsere kombinierten Algorithmen, aber wenn Sie einige wahrgenommene Ungereimtheiten finden, können Sie sich gerne im Kommentarbereich äußern, wir beheben Probleme in der Regel schnell.
Radeon R7 M445 übertrifft GeForce GTX 280M um 64% in unseren kombinierten Benchmark-Ergebnissen.
Passmark
Dies ist wahrscheinlich der am weitesten verbreitete Benchmark, Teil der Passmark PerformanceTest Suite. Er unterzieht die Grafikkarte einer gründlichen Bewertung und bietet vier separate Benchmarks für die Direct3D-Versionen 9, 10, 11 und 12 (der letzte wird, wenn möglich, in 4K-Auflösung durchgeführt) sowie einige weitere Tests, die die DirectCompute-Fähigkeiten ansprechen.
Benchmark-Abdeckung: 25%
Radeon R7 M445 übertrifft GeForce GTX 280M um 64% in Passmark.
3DMark Vantage Performance
3DMark Vantage ist ein veralteter DirectX 10-Benchmark. Er belastet die Grafikkarte mit zwei Szenen, eine zeigt ein Mädchen, das aus einer Militärbasis in einer Meereshöhle flieht, die andere zeigt eine Raumflotte, die einen wehrlosen Planeten angreift. Er wurde im April 2017 eingestellt und stattdessen wird nun der Time Spy-Benchmark zur Verwendung empfohlen.
Benchmark-Abdeckung: 17%
Radeon R7 M445 übertrifft GeForce GTX 280M um 3% in 3DMark Vantage Performance.
Spielleistung
Die Ergebnisse von Radeon R7 M445 und GeForce GTX 280M in Spielen, werden in FPS gemessen.
Durchschnittliche FPS für alle PC-Spiele
Hier sind die durchschnittlichen Bilder pro Sekunde in einer großen Anzahl von beliebten Spielen in verschiedenen Auflösungen:
| Full HD | 14
+75%
| 8−9
−75%
|
FPS-Leistung in beliebten Spielen
Full HD
Low Preset
| Cyberpunk 2077 | 5−6
+25%
|
4−5
−25%
|
Full HD
Medium Preset
| Assassin's Creed Odyssey | 8−9
+33.3%
|
6−7
−33.3%
|
| Battlefield 5 | 3−4
+200%
|
1−2
−200%
|
| Call of Duty: Modern Warfare | 6−7
+50%
|
4−5
−50%
|
| Cyberpunk 2077 | 5−6
+25%
|
4−5
−25%
|
| Far Cry 5 | 4−5
+100%
|
2−3
−100%
|
| Far Cry New Dawn | 6−7
+50%
|
4−5
−50%
|
| Forza Horizon 4 | 10−12
+175%
|
4−5
−175%
|
| Hitman 3 | 7−8
+16.7%
|
6−7
−16.7%
|
| Horizon Zero Dawn | 20−22
+33.3%
|
14−16
−33.3%
|
| Metro Exodus | 1−2 | 0−1 |
| Red Dead Redemption 2 | 6−7
+100%
|
3−4
−100%
|
| Shadow of the Tomb Raider | 10−12
+37.5%
|
8−9
−37.5%
|
| Watch Dogs: Legion | 35−40
+12.1%
|
30−35
−12.1%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 8−9
+33.3%
|
6−7
−33.3%
|
| Battlefield 5 | 3−4
+200%
|
1−2
−200%
|
| Call of Duty: Modern Warfare | 6−7
+50%
|
4−5
−50%
|
| Cyberpunk 2077 | 5−6
+25%
|
4−5
−25%
|
| Far Cry 5 | 4−5
+100%
|
2−3
−100%
|
| Far Cry New Dawn | 6−7
+50%
|
4−5
−50%
|
| Forza Horizon 4 | 10−12
+175%
|
4−5
−175%
|
| Hitman 3 | 7−8
+16.7%
|
6−7
−16.7%
|
| Horizon Zero Dawn | 20−22
+33.3%
|
14−16
−33.3%
|
| Metro Exodus | 1−2 | 0−1 |
| Red Dead Redemption 2 | 6−7
+100%
|
3−4
−100%
|
| Shadow of the Tomb Raider | 10−12
+37.5%
|
8−9
−37.5%
|
| The Witcher 3: Wild Hunt | 12−14
+18.2%
|
10−12
−18.2%
|
| Watch Dogs: Legion | 35−40
+12.1%
|
30−35
−12.1%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 8−9
+33.3%
|
6−7
−33.3%
|
| Call of Duty: Modern Warfare | 6−7
+50%
|
4−5
−50%
|
| Cyberpunk 2077 | 5−6
+25%
|
4−5
−25%
|
| Far Cry 5 | 4−5
+100%
|
2−3
−100%
|
| Forza Horizon 4 | 10−12
+175%
|
4−5
−175%
|
| Hitman 3 | 7−8
+16.7%
|
6−7
−16.7%
|
| Horizon Zero Dawn | 20−22
+33.3%
|
14−16
−33.3%
|
| Shadow of the Tomb Raider | 10−12
+37.5%
|
8−9
−37.5%
|
| The Witcher 3: Wild Hunt | 5
−120%
|
10−12
+120%
|
| Watch Dogs: Legion | 35−40
+12.1%
|
30−35
−12.1%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 6−7
+100%
|
3−4
−100%
|
1440p
High Preset
| Battlefield 5 | 4−5
+100%
|
2−3
−100%
|
| Far Cry New Dawn | 4−5
+100%
|
2−3
−100%
|
1440p
Ultra Preset
| Assassin's Creed Odyssey | 2−3
+100%
|
1−2
−100%
|
| Call of Duty: Modern Warfare | 1−2 | 0−1 |
| Cyberpunk 2077 | 1−2
+0%
|
1−2
+0%
|
| Far Cry 5 | 3−4
+50%
|
2−3
−50%
|
| Hitman 3 | 7−8
+0%
|
7−8
+0%
|
| Horizon Zero Dawn | 7−8
+40%
|
5−6
−40%
|
| The Witcher 3: Wild Hunt | 2−3
+100%
|
1−2
−100%
|
| Watch Dogs: Legion | 14−16
+100%
|
7−8
−100%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 5−6
+25%
|
4−5
−25%
|
4K
High Preset
| Battlefield 5 | 0−1 | 0−1 |
| Far Cry New Dawn | 1−2
+0%
|
1−2
+0%
|
4K
Ultra Preset
| Assassin's Creed Odyssey | 2−3
+100%
|
1−2
−100%
|
| Assassin's Creed Valhalla | 1−2
+0%
|
1−2
+0%
|
| Call of Duty: Modern Warfare | 1−2 | 0−1 |
| Far Cry 5 | 1−2 | 0−1 |
| Watch Dogs: Legion | 0−1 | 0−1 |
4K
Epic Preset
| Red Dead Redemption 2 | 3−4
+0%
|
3−4
+0%
|
So konkurrieren R7 M445 und GTX 280M in beliebten Spielen:
- R7 M445 ist 75% schneller in 1080p
Hier ist die Bandbreite der Leistungsunterschiede bei beliebten Spielen:
- in Forza Horizon 4, mit 1080p-Auflösung und dem Medium Preset, ist der R7 M445 um 175% schneller.
- in The Witcher 3: Wild Hunt, mit 1080p-Auflösung und dem Ultra Preset, ist der GTX 280M um 120% schneller.
Alles in allem, in beliebten Spielen:
- R7 M445 liegt in 43 Tests vorn (88%)
- GTX 280M liegt in 1 Test vorn (2%)
- es gibt ein Unentschieden in 5 Tests (10%)
Zusammenfassung der Vor- und Nachteile
| Leistungsbewertung | 2.44 | 1.49 |
| Neuheit | 15 Mai 2016 | 2 März 2009 |
| Maximale Speicherkapazität | 4 GB | 1 GB |
| Technologischer Prozess | 28 nm | 55 nm |
| Leistungsaufnahme (TDP) | 15 Watt | 75 Watt |
R7 M445 hat eine um 63.8% höhere Gesamtleistungsbewertung, einen Altersvorsprung von 7 Jahren, eine 300% höhere maximale VRAM Menge, ein 96.4% fortschrittlicheres Lithografieverfahren, und 400% weniger Stromverbrauch.
Der Radeon R7 M445 ist unsere empfohlene Wahl, da er den GeForce GTX 280M in Leistungstests schlägt.
Wenn Sie noch Fragen zur Wahl zwischen Radeon R7 M445 und GeForce GTX 280M haben - fragen Sie in den Kommentaren, und wir werden antworten.
Vergleiche mit ähnlichen GPUs
Wir haben mehrere Grafikkarten-Vergleiche ausgewählt, deren Leistung den getesteten Karten mehr oder weniger nahe kommt, so dass Sie mehr wahrscheinliche Optionen in Betracht ziehen können.
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6" where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(2.44 - b.result) asc /* # 1 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(2.44 - b.result) asc /* # 1 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(2.44 - b.result) asc /* # 1 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video_notebook_0_301_L6
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(2.44 - b.result) asc /* # 1 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=487 and pop.lang="6" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=487 and pop2.item2=i._id and pop2.lang="6" where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2009-03-02","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(1.49 - b.result) asc /* # 2 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=487 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=487 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2009-03-02","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(1.49 - b.result) asc /* # 2 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=487 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=487 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2009-03-02","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(1.49 - b.result) asc /* # 2 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video_notebook_0_487_L6
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=487 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=487 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2009-03-02","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(1.49 - b.result) asc /* # 2 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6" where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(2.44 - b.result) asc /* # 1 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(2.44 - b.result) asc /* # 1 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(2.44 - b.result) asc /* # 1 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video_notebook_0_301_L6
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=301 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=301 and pop2.item2=i._id and pop2.lang="6"
where b.benchmark_id=-1 and i.type="notebook" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-05-15","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(2.44 - b.result) asc /* # 1 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
