GeForce GTX 960M vs GT 710M
Aggregierte Leistungsbewertung
Wir haben GeForce GTX 960M mit GeForce GT 710M verglichen, einschließlich Spezifikationen und Leistungsdaten.
GTX 960M übertrifft GT 710M um satte 665%, 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 GeForce GT 710M sowie über die Startzeit des Verkaufs und die Kosten zu diesem Zeitpunkt.
| Platz in der Leistungsbewertung | 460 | 1038 |
| Platz nach Beliebtheit | nicht in den Top-100 | nicht in den Top-100 |
| Bewertung der Kostenwirksamkeit | 1.52 | 0.49 |
| Architektur | Maxwell (2014−2018) | Fermi 2.0 (2010−2014) |
| Codename | N16P-GX | GF117 |
| Typ | Für Laptops | Desktop- |
| Veröffentlichungsdatum | 12 März 2015 (9 Jahre vor) | 9 Januar 2013 (11 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 210% besseres Preis-Leistungs-Verhältnis als GT 710M.
Detaillierte Spezifikationen
Allgemeine Parameter von GeForce GTX 960M und GeForce GT 710M: Anzahl der Shader, Frequenz des Videokerns, technologischer Prozess, Texturierungs- und Rechengeschwindigkeit. Diese Parameter sprechen indirekt über die Leistung von GeForce GTX 960M und GeForce GT 710M, 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 | 775 MHz |
| Boost-Frequenz | 1202 MHz | keine Angaben |
| Anzahl der Transistoren | 1,870 million | 585 million |
| Technologischer Herstellungsprozess | 28 nm | 28 nm |
| Leistungsaufnahme (TDP) | 75 Watt | 15 Watt |
| Texturiergeschwindigkeit | 47.04 | 12.40 |
| Gleitkomma-Leistung | 1,505 gflops | 297.6 gflops |
Formfaktor und Kompatibilität
nformationen zur Kompatibilität von GeForce GTX 960M und GeForce GT 710M mit anderen Computerkomponenten. Es ist nützlich, wenn Sie z.B eine zukünftige Computerkonfiguration auswählen oder die vorhandene aktualisieren möchten. Bei Desktop-Grafikkarten sind das die Schnittstelle und der Verbindungsbus (Kompatibilität mit dem Motherboard), die physischen Abmessungen der Grafikkarte (Kompatibilität mit dem Motherboard und dem Gehäuse) sowie zusätzliche Stromanschlüsse (Kompatibilität mit dem Netzteil). 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 | keine Angaben |
| Schnittstelle | MXM-B (3.0) | PCIe 2.0 x16 |
| SLI-Unterstützung | + | keine Angaben |
VRAM-Kapazität und -Typ
Die Parameter des auf GeForce GTX 960M und GeForce GT 710M 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 | 1 GB |
| Speicherbusbreite | 128 Bit | 64 Bit |
| Speicherfrequenz | 5000 MHz | 1800 MHz |
| Speicherbandbreite | 80.19 GB/s | 14.4 GB/s |
| Multiplexspeicher | - | keine Angaben |
Konnektivität und Ausgänge
Arten und Anzahl der Videoanschlüsse auf GeForce GTX 960M und GeForce GT 710M. 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 GeForce GT 710M 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 GeForce GT 710M 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 | + | 2.1 |
Synthetische Benchmark-Leistung
Nicht-Gaming-Benchmarks Leistung von GeForce GTX 960M und GeForce GT 710M. 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.
GTX 960M übertrifft GT 710M um 665% 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%
GTX 960M übertrifft GT 710M um 663% in Passmark.
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%
GTX 960M übertrifft GT 710M um 334% in GeekBench 5 OpenCL.
Spielleistung
Die Ergebnisse von GeForce GTX 960M und GeForce GT 710M 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
+692%
| 12−14
−692%
|
| Full HD | 36
+800%
| 4−5
−800%
|
| 1440p | 15
+1400%
| 1−2
−1400%
|
| 4K | 14
+1300%
| 1−2
−1300%
|
FPS-Leistung in beliebten Spielen
Full HD
Low Preset
| Cyberpunk 2077 | 14−16
+1300%
|
1−2
−1300%
|
Full HD
Medium Preset
| Assassin's Creed Odyssey | 25
+733%
|
3−4
−733%
|
| Assassin's Creed Valhalla | 12−14
+1200%
|
1−2
−1200%
|
| Battlefield 5 | 30
+900%
|
3−4
−900%
|
| Call of Duty: Modern Warfare | 18−20
+800%
|
2−3
−800%
|
| Cyberpunk 2077 | 14−16
+1300%
|
1−2
−1300%
|
| Far Cry 5 | 28
+833%
|
3−4
−833%
|
| Far Cry New Dawn | 31
+675%
|
4−5
−675%
|
| Forza Horizon 4 | 84
+740%
|
10−11
−740%
|
| Hitman 3 | 16−18
+750%
|
2−3
−750%
|
| Horizon Zero Dawn | 50−55
+733%
|
6−7
−733%
|
| Metro Exodus | 31
+675%
|
4−5
−675%
|
| Red Dead Redemption 2 | 24−27
+700%
|
3−4
−700%
|
| Shadow of the Tomb Raider | 48
+700%
|
6−7
−700%
|
| Watch Dogs: Legion | 55−60
+743%
|
7−8
−743%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 31
+675%
|
4−5
−675%
|
| Assassin's Creed Valhalla | 12−14
+1200%
|
1−2
−1200%
|
| Battlefield 5 | 23
+667%
|
3−4
−667%
|
| Call of Duty: Modern Warfare | 18−20
+800%
|
2−3
−800%
|
| Cyberpunk 2077 | 14−16
+1300%
|
1−2
−1300%
|
| Far Cry 5 | 24
+700%
|
3−4
−700%
|
| Far Cry New Dawn | 23
+667%
|
3−4
−667%
|
| Forza Horizon 4 | 71
+689%
|
9−10
−689%
|
| Hitman 3 | 16−18
+750%
|
2−3
−750%
|
| Horizon Zero Dawn | 50−55
+733%
|
6−7
−733%
|
| Metro Exodus | 26
+767%
|
3−4
−767%
|
| Red Dead Redemption 2 | 24−27
+700%
|
3−4
−700%
|
| Shadow of the Tomb Raider | 27−30
+867%
|
3−4
−867%
|
| The Witcher 3: Wild Hunt | 73
+711%
|
9−10
−711%
|
| Watch Dogs: Legion | 55−60
+743%
|
7−8
−743%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 11
+1000%
|
1−2
−1000%
|
| Assassin's Creed Valhalla | 12−14
+1200%
|
1−2
−1200%
|
| Call of Duty: Modern Warfare | 18−20
+800%
|
2−3
−800%
|
| Cyberpunk 2077 | 14−16
+1300%
|
1−2
−1300%
|
| Far Cry 5 | 18
+800%
|
2−3
−800%
|
| Forza Horizon 4 | 25
+733%
|
3−4
−733%
|
| Hitman 3 | 16−18
+750%
|
2−3
−750%
|
| Horizon Zero Dawn | 50−55
+733%
|
6−7
−733%
|
| Shadow of the Tomb Raider | 27−30
+867%
|
3−4
−867%
|
| The Witcher 3: Wild Hunt | 14
+1300%
|
1−2
−1300%
|
| Watch Dogs: Legion | 55−60
+743%
|
7−8
−743%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 24−27
+700%
|
3−4
−700%
|
1440p
High Preset
| Battlefield 5 | 14
+1300%
|
1−2
−1300%
|
| Far Cry New Dawn | 15
+1400%
|
1−2
−1400%
|
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 | 0−1 |
| Far Cry 5 | 10
+900%
|
1−2
−900%
|
| Forza Horizon 4 | 45
+800%
|
5−6
−800%
|
| Hitman 3 | 12−14
+1100%
|
1−2
−1100%
|
| Horizon Zero Dawn | 18−20
+800%
|
2−3
−800%
|
| Metro Exodus | 15
+1400%
|
1−2
−1400%
|
| 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
+700%
|
7−8
−700%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 14−16
+1400%
|
1−2
−1400%
|
4K
High Preset
| Battlefield 5 | 6 | 0−1 |
| Far Cry New Dawn | 7 | 0−1 |
| Hitman 3 | 5−6 | 0−1 |
| Horizon Zero Dawn | 35−40
+775%
|
4−5
−775%
|
| 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 | 0−1 |
| Assassin's Creed Valhalla | 4−5 | 0−1 |
| Call of Duty: Modern Warfare | 4−5 | 0−1 |
| Cyberpunk 2077 | 1−2 | 0−1 |
| Far Cry 5 | 4 | 0−1 |
| Forza Horizon 4 | 10−12
+1000%
|
1−2
−1000%
|
| 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
+800%
|
1−2
−800%
|
So konkurrieren GTX 960M und GT 710M in beliebten Spielen:
- GTX 960M ist 692% schneller in 900p
- GTX 960M ist 800% schneller in 1080p
- GTX 960M ist 1400% schneller in 1440p
- GTX 960M ist 1300% schneller in 4K
Zusammenfassung der Vor- und Nachteile
| Leistungsbewertung | 8.80 | 1.15 |
| Neuheit | 12 März 2015 | 9 Januar 2013 |
| Maximale Speicherkapazität | 4 GB | 1 GB |
| Leistungsaufnahme (TDP) | 75 Watt | 15 Watt |
GTX 960M hat eine um 665.2% höhere Gesamtleistungsbewertung, einen Altersvorsprung von 2 Jahren, und eine 300% höhere maximale VRAM Menge.
GT 710M hingegen hat 400% weniger Stromverbrauch.
Der GeForce GTX 960M ist unsere empfohlene Wahl, da er den GeForce GT 710M in Leistungstests schlägt.
Beachten Sie, dass GeForce GTX 960M für Laptops und GeForce GT 710M für Desktops bestimmt ist.
Wenn Sie noch Fragen zur Wahl zwischen GeForce GTX 960M und GeForce GT 710M 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=2390 and pop.lang="6" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2390 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("2013-01-09","-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.15 - 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=2390 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2390 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("2013-01-09","-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.15 - 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=2390 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2390 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("2013-01-09","-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.15 - 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_2390_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=2390 and pop.lang="6"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2390 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("2013-01-09","-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.15 - 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
)
)
