GeForce GTX 960M vs NVS 5400M
Aggregierte Leistungsbewertung
Wir haben GeForce GTX 960M mit NVS 5400M verglichen, einschließlich Spezifikationen und Leistungsdaten.
GTX 960M übertrifft NVS 5400M um satte 443%, basierend auf unseren aggregierten Benchmark-Ergebnissen.
Primäre Details
Informationen über den Typ (für Desktops oder Laptops) und die Architektur von GeForce GTX 960M und NVS 5400M sowie über die Startzeit des Verkaufs und die Kosten zu diesem Zeitpunkt.
| Platz in der Leistungsbewertung | 460 | 916 |
| Platz nach Beliebtheit | nicht in den Top-100 | nicht in den Top-100 |
| Bewertung der Kostenwirksamkeit | 1.52 | 0.06 |
| Architektur | Maxwell (2014−2018) | Fermi (2010−2014) |
| Codename | N16P-GX | N13P-NS1 |
| Typ | Für Laptops | Für mobile Workstations |
| Veröffentlichungsdatum | 12 März 2015 (9 Jahre vor) | 1 Juni 2012 (12 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 960M hat ein 2433% besseres Preis-Leistungs-Verhältnis als NVS 5400M.
Detaillierte Spezifikationen
Allgemeine Parameter von GeForce GTX 960M und NVS 5400M: Anzahl der Shader, Frequenz des Videokerns, technologischer Prozess, Texturierungs- und Rechengeschwindigkeit. Diese Parameter sprechen indirekt über die Leistung von GeForce GTX 960M und NVS 5400M, obwohl für eine genaue Bewertung die Ergebnisse von Benchmarks und Spieletests berücksichtigt werden müssen.
| Anzahl der Shader-Prozessoren | 640 | 96 |
| Kernfrequenz | 1096 MHz | 660 MHz |
| Boost-Frequenz | 1202 MHz | keine Angaben |
| Anzahl der Transistoren | 1,870 million | 585 million |
| Technologischer Herstellungsprozess | 28 nm | 40 nm |
| Leistungsaufnahme (TDP) | 75 Watt | 35 Watt |
| Texturiergeschwindigkeit | 47.04 | 10.56 |
| Gleitkomma-Leistung | 1,505 gflops | 253.4 gflops |
Formfaktor und Kompatibilität
Informationen zur Kompatibilität von GeForce GTX 960M und NVS 5400M 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 | medium sized | medium sized |
| Schnittstelle | MXM-B (3.0) | MXM |
| SLI-Unterstützung | + | keine Angaben |
VRAM-Kapazität und -Typ
Die Parameter des auf GeForce GTX 960M und NVS 5400M 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 | DDR3 |
| Maximale Speicherkapazität | 4 GB | 2 GB |
| Speicherbusbreite | 128 Bit | 128 Bit |
| Speicherfrequenz | 5000 MHz | 1800 MHz |
| Speicherbandbreite | 80.19 GB/s | 28.8 GB/s |
| Multiplexspeicher | - | - |
Konnektivität und Ausgänge
Arten und Anzahl der Videoanschlüsse auf GeForce GTX 960M und NVS 5400M. 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 |
Unterstützte Technologien
Technologische Lösungen und APIs, die von GeForce GTX 960M und NVS 5400M unterstützt werden. Sie brauchen diese Informationen, wenn Sie eine bestimmte Technologie für Ihre Zwecke benötigen.
| Optimus | + | keine Angaben |
| Ansel | + | keine Angaben |
API-Kompatibilität
Die von GeForce GTX 960M und NVS 5400M unterstützten APIs, einschließlich ihrer Versionen.
| DirectX | 12 (11_0) | 12 (11_0) |
| Shader-Modell | 5.1 | 5.1 |
| OpenGL | 4.6 | 4.6 |
| OpenCL | 1.2 | 1.1 |
| Vulkan | 1.1.126 | N/A |
| CUDA | + | + |
Synthetische Benchmark-Leistung
Nicht-Gaming-Benchmarks Leistung von GeForce GTX 960M und NVS 5400M. 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.
GeForce GTX 960M übertrifft NVS 5400M um 443% 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%
GeForce GTX 960M übertrifft NVS 5400M um 443% in Passmark.
3DMark 11 Performance GPU
3DMark 11 ist ein veralteter DirectX 11-Benchmark von Futuremark. Er verwendet vier Tests, die auf zwei Szenen basieren. Die eine sind ein paar U-Boote, die das versunkene Wrack eines gesunkenen Schiffes erkunden, die andere ist ein verlassener Tempel tief im Dschungel. Alle Tests sind stark mit volumetrischen Beleuchtungen und Tessellation ausgestattet und sind trotz der Auflösung von 1280x720 relativ anspruchsvoll. Der 3DMark 11 wurde im Januar 2020 eingestellt und wird nun von Time Spy abgelöst.
Benchmark-Abdeckung: 17%
GeForce GTX 960M übertrifft NVS 5400M um 372% in 3DMark 11 Performance GPU.
GeekBench 5 OpenCL
Geekbench 5 ist ein weit verbreiteter Grafikkarten-Benchmark, kombiniert aus 11 verschiedenen Testszenarien. Alle diese Szenarien beruhen auf der direkten Nutzung der Rechenleistung der GPU, es ist kein 3D-Rendering involviert. Diese Variante verwendet die OpenCL-API der Khronos Group.
Benchmark-Abdeckung: 9%
GeForce GTX 960M übertrifft NVS 5400M um 411% in GeekBench 5 OpenCL.
Spielleistung
Die Ergebnisse von GeForce GTX 960M und NVS 5400M 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:
| 900p | 95
+494%
| 16−18
−494%
|
| Full HD | 36
+71.4%
| 21
−71.4%
|
| 1440p | 15
+650%
| 2−3
−650%
|
| 4K | 14
+600%
| 2−3
−600%
|
FPS-Leistung in beliebten Spielen
Full HD
Low Preset
| Cyberpunk 2077 | 14−16
+250%
|
4−5
−250%
|
Full HD
Medium Preset
| Assassin's Creed Odyssey | 25
+317%
|
6−7
−317%
|
| Assassin's Creed Valhalla | 12−14
+550%
|
2−3
−550%
|
| Battlefield 5 | 30
+500%
|
5−6
−500%
|
| Call of Duty: Modern Warfare | 18−20
+260%
|
5−6
−260%
|
| Cyberpunk 2077 | 14−16
+250%
|
4−5
−250%
|
| Far Cry 5 | 28
+1300%
|
2−3
−1300%
|
| Far Cry New Dawn | 31
+675%
|
4−5
−675%
|
| Forza Horizon 4 | 84
+1580%
|
5−6
−1580%
|
| Hitman 3 | 16−18
+183%
|
6−7
−183%
|
| Horizon Zero Dawn | 50−55
+213%
|
16−18
−213%
|
| Metro Exodus | 31
+520%
|
5−6
−520%
|
| Red Dead Redemption 2 | 24−27
+700%
|
3−4
−700%
|
| Shadow of the Tomb Raider | 48
+433%
|
9−10
−433%
|
| Watch Dogs: Legion | 55−60
+73.5%
|
30−35
−73.5%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 31
+417%
|
6−7
−417%
|
| Assassin's Creed Valhalla | 12−14
+550%
|
2−3
−550%
|
| Battlefield 5 | 23
+475%
|
4−5
−475%
|
| Call of Duty: Modern Warfare | 18−20
+260%
|
5−6
−260%
|
| Cyberpunk 2077 | 14−16
+250%
|
4−5
−250%
|
| Far Cry 5 | 24
+1100%
|
2−3
−1100%
|
| Far Cry New Dawn | 23
+475%
|
4−5
−475%
|
| Forza Horizon 4 | 71
+1320%
|
5−6
−1320%
|
| Hitman 3 | 16−18
+183%
|
6−7
−183%
|
| Horizon Zero Dawn | 50−55
+213%
|
16−18
−213%
|
| Metro Exodus | 26
+550%
|
4−5
−550%
|
| Red Dead Redemption 2 | 24−27
+700%
|
3−4
−700%
|
| Shadow of the Tomb Raider | 27−30
+222%
|
9−10
−222%
|
| The Witcher 3: Wild Hunt | 73
+508%
|
12−14
−508%
|
| Watch Dogs: Legion | 55−60
+73.5%
|
30−35
−73.5%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 11
+83.3%
|
6−7
−83.3%
|
| Assassin's Creed Valhalla | 12−14
+550%
|
2−3
−550%
|
| Call of Duty: Modern Warfare | 18−20
+260%
|
5−6
−260%
|
| Cyberpunk 2077 | 14−16
+250%
|
4−5
−250%
|
| Far Cry 5 | 18
+800%
|
2−3
−800%
|
| Forza Horizon 4 | 25
+400%
|
5−6
−400%
|
| Hitman 3 | 16−18
+183%
|
6−7
−183%
|
| Horizon Zero Dawn | 50−55
+213%
|
16−18
−213%
|
| Shadow of the Tomb Raider | 27−30
+222%
|
9−10
−222%
|
| The Witcher 3: Wild Hunt | 14
+16.7%
|
12−14
−16.7%
|
| Watch Dogs: Legion | 55−60
+73.5%
|
30−35
−73.5%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 24−27
+700%
|
3−4
−700%
|
1440p
High Preset
| Battlefield 5 | 14
+600%
|
2−3
−600%
|
| Far Cry New Dawn | 15
+650%
|
2−3
−650%
|
1440p
Ultra Preset
| Assassin's Creed Odyssey | 8
+700%
|
1−2
−700%
|
| Assassin's Creed Valhalla | 4−5 | 0−1 |
| Call of Duty: Modern Warfare | 9−10
+800%
|
1−2
−800%
|
| Cyberpunk 2077 | 4−5
+300%
|
1−2
−300%
|
| Far Cry 5 | 10
+400%
|
2−3
−400%
|
| Forza Horizon 4 | 45
+463%
|
8−9
−463%
|
| Hitman 3 | 12−14
+71.4%
|
7−8
−71.4%
|
| Horizon Zero Dawn | 18−20
+260%
|
5−6
−260%
|
| Metro Exodus | 15
+650%
|
2−3
−650%
|
| Shadow of the Tomb Raider | 10−11
+900%
|
1−2
−900%
|
| The Witcher 3: Wild Hunt | 8−9
+700%
|
1−2
−700%
|
| Watch Dogs: Legion | 55−60
+600%
|
8−9
−600%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 14−16
+275%
|
4−5
−275%
|
4K
High Preset
| Battlefield 5 | 6
+500%
|
1−2
−500%
|
| Far Cry New Dawn | 7
+600%
|
1−2
−600%
|
| Hitman 3 | 5−6 | 0−1 |
| Horizon Zero Dawn | 35−40
+483%
|
6−7
−483%
|
| Metro Exodus | 8
+700%
|
1−2
−700%
|
| The Witcher 3: Wild Hunt | 10
+900%
|
1−2
−900%
|
4K
Ultra Preset
| Assassin's Creed Odyssey | 5−6
+150%
|
2−3
−150%
|
| Assassin's Creed Valhalla | 4−5
+300%
|
1−2
−300%
|
| Call of Duty: Modern Warfare | 4−5 | 0−1 |
| Cyberpunk 2077 | 1−2 | 0−1 |
| Far Cry 5 | 4
+300%
|
1−2
−300%
|
| Forza Horizon 4 | 10−12
+450%
|
2−3
−450%
|
| Shadow of the Tomb Raider | 5−6 | 0−1 |
| Watch Dogs: Legion | 3−4 | 0−1 |
4K
Epic Preset
| Red Dead Redemption 2 | 9−10
+200%
|
3−4
−200%
|
So konkurrieren GTX 960M und NVS 5400M in beliebten Spielen:
- GTX 960M ist 494% schneller in 900p
- GTX 960M ist 71% schneller in 1080p
- GTX 960M ist 650% schneller in 1440p
- GTX 960M ist 600% schneller in 4K
Hier ist die Bandbreite der Leistungsunterschiede bei beliebten Spielen:
- in Forza Horizon 4, mit 1080p-Auflösung und dem Medium Preset, ist der GTX 960M um 1580% schneller.
Alles in allem, in beliebten Spielen:
- Ohne Ausnahme übertraf GTX 960M NVS 5400M in allen 51 unserer Tests.
Zusammenfassung der Vor- und Nachteile
| Leistungsbewertung | 8.80 | 1.62 |
| Neuheit | 12 März 2015 | 1 Juni 2012 |
| Maximale Speicherkapazität | 4 GB | 2 GB |
| Technologischer Prozess | 28 nm | 40 nm |
| Leistungsaufnahme (TDP) | 75 Watt | 35 Watt |
GTX 960M hat eine um 443.2% höhere Gesamtleistungsbewertung, einen Altersvorsprung von 2 Jahren, eine 100% höhere maximale VRAM Menge, und ein 42.9% fortschrittlicheres Lithografieverfahren.
NVS 5400M hingegen hat 114.3% weniger Stromverbrauch.
Der GeForce GTX 960M ist unsere empfohlene Wahl, da er den NVS 5400M in Leistungstests schlägt.
Beachten Sie, dass GeForce GTX 960M für Laptops und NVS 5400M für mobile Workstations bestimmt ist.
Wenn Sie noch Fragen zur Wahl zwischen GeForce GTX 960M und NVS 5400M 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=44 and pop.lang="6" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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=44 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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=44 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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_44_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=44 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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=207 and pop.lang="6" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=207 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("2012-06-01","-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.62 - 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=207 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=207 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("2012-06-01","-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.62 - 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=207 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=207 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("2012-06-01","-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.62 - 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_207_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=207 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=207 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("2012-06-01","-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.62 - 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=44 and pop.lang="6" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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=44 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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=44 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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_44_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=44 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=44 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("2015-03-12","-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(8.8 - 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
)
)
