Quadro M6000 24 GB vs GeForce RTX 4070 SUPER
Note de performance globale
Nous avons comparé Quadro M6000 24 GB avec GeForce RTX 4070 SUPER, y compris les spécifications et les données de performance.
RTX 4070 SUPER surpasse M6000 24 GB d'un énorme 153% sur la base de nos résultats de référence agrégés.
Détails primaires
À propos du type (pour les ordinateurs de bureau ou les ordinateurs portables) et de l'architecture de Quadro M6000 24 GB, ainsi que le moment où les ventes ont commencé et le coût à ce moment-là.
| Place dans le classement des performances | 167 | 8 |
| Place par popularité | pas dans le top-100 | 28 |
| Évaluation du rapport coût-efficacité | 5.48 | 33.57 |
| Architecture | Maxwell 2.0 (2015−2019) | Ada Lovelace |
| Nom de code | GM200 | AD104 |
| Type | Pour les postes de travail | Desktop |
| Date de lancement | 5 Mars 2016 (8 ans il y a) | 17 Janvier 2024 (il y a moins d'un an) |
| Prix au moment du lancement | $4,999 | $699 |
Évaluation du rapport coût-efficacité
Pour obtenir un indice, nous comparons les performances des cartes vidéo et leur coût, en tenant compte du coût des autres cartes vidéo.
Le rapport qualité-prix de RTX 4070 SUPER est 513% meilleur que celui de M6000 24 GB.
Spécifications détaillées
Paramètres généraux Quadro M6000 24 GB et GeForce RTX 4070 SUPER: nombre de shaders, fréquence du noyau de vidéo, processus technologique, vitesse de texturation et de calcul. De manière indirecte, ils parlent de la performance de Quadro M6000 24 GB et GeForce RTX 4070 SUPER, bien qu'il soit nécessaire d'examiner les résultats des benchmarks et des tests de jeu pour une évaluation précise.
| Nombre de processeurs de shaders | 3072 | 7168 |
| Fréquence de noyau | 988 MHz | 1980 MHz |
| Fréquence en mode Boost | 1114 MHz | 2475 MHz |
| Nombre de transistors | 8,000 million | 35,800 million |
| Processus technologique de fabrication | 28 nm | 5 nm |
| Consommation d'énergie (TDP) | 250 Watt | 220 Watt |
| Vitesse de texturation | 285.2 | 584.6 |
| Performance à virgule flottante | 6,844 gflops | pas de données |
Facteur de forme et compatibilité
Les paramètres qui sont responsables de la compatibilité de Quadro M6000 24 GB et GeForce RTX 4070 SUPER avec d'autres composants de l'ordinateur.Utile, par exemple, lors du choix de la configuration d'un futur ordinateur ou pour une mise à niveau d'un ordinateur existant.Pour les cartes graphiques desktops, il s'agit d'une interface et d'un bus de connexion (compatible avec la carte mère), de dimensions physiques de la carte graphique (compatible avec la carte mère et le boîtier), de connecteurs d'alimentation supplémentaires (compatible avec un bloc d'alimentation).
| Interface | PCIe 3.0 x16 | PCIe 4.0 x16 |
| Longueur | 267 mm | 285 mm |
| Épaisseur | 2-slot | 2-slot |
| Connecteurs d'alimentation supplémentaires | 1x 8-pin | 1x 16-pin |
Capacité et type de VRAM
Les paramètres de la mémoire installée sur Quadro M6000 24 GB et GeForce RTX 4070 SUPER sont le type, la capacité, le bus, la fréquence et la bande passante. Pour les cartes graphiques intégrées dans le processeur qui ne disposent pas de leur propre mémoire, la mémoire vive partagée est utilisée.
| Type de mémoire | GDDR5 | GDDR6X |
| Capacité de mémoire maximale | 24 Gb | 12 Gb |
| Largeur de bus de mémoire | 384 Bit | 192 Bit |
| Fréquence de mémoire | 6612 MHz | 21000 MHz |
| Bande passante de la mémoire | 317.4 Gb/s | 504.2 Gb/s |
| Mémoire partagée | pas de données | - |
Connectivité et sorties
Les connecteurs vidéo disponibles sont listés sur Quadro M6000 24 GB et GeForce RTX 4070 SUPER. En règle générale, cette section n'est pertinente que pour les cartes vidéo de référence de bureau, car pour les ordinateurs portables, la disponibilité de certaines sorties vidéo dépend du modèle d'ordinateur portable.
| Connecteurs de vidéo | 1x DVI, 4x DisplayPort | 1x HDMI 2.1, 3x DisplayPort 1.4a |
| HDMI | pas de données | + |
Compatibilité API
Les API supportées par Quadro M6000 24 GB et GeForce RTX 4070 SUPER sont listées, ainsi que leurs versions.
| DirectX | 12 (12_1) | 12 Ultimate (12_2) |
| Modèle de shader | 6.4 | 6.7 |
| OpenGL | 4.6 | 4.6 |
| OpenCL | 1.2 | 3.0 |
| Vulkan | + | 1.3 |
| CUDA | 5.2 | 8.9 |
Performance de référence synthétique
Ce sont les résultats du test des Quadro M6000 24 GB et GeForce RTX 4070 SUPER de la performance de rendering dans les benchmarks sans rapport avec les jeux. Le score total est fixé de 0 à 100, où 100 correspond à la carte graphique la plus rapide du moment.
Score de référence synthétique combiné
Il s'agit de notre évaluation combinée des performances du benchmark. Nous améliorons régulièrement nos algorithmes de combinaison, mais si vous trouvez des incohérences, n'hésitez pas à en parler dans la section des commentaires, nous corrigeons généralement les problèmes rapidement.
GeForce RTX 4070 SUPER surpasse Quadro M6000 24 GB de 153% dans nos résultats de référence combinés.
Passmark
Il s'agit probablement du benchmark le plus omniprésent, faisant partie de la suite Passmark PerformanceTest. Il permet une évaluation approfondie de la carte graphique, en fournissant quatre tests distincts pour les versions 9, 10, 11 et 12 de Direct3D (le dernier étant effectué en résolution 4K si possible), et quelques autres tests engageant les capacités de DirectCompute.
Couverture de référence : 25%
GeForce RTX 4070 SUPER surpasse Quadro M6000 24 GB de 153% dans Passmark.
Performances de jeu
Les résultats Quadro M6000 24 GB et GeForce RTX 4070 SUPER dans les jeux, les valeurs sont mesurées en FPS.
FPS moyen pour tous les jeux PC
Voici les images par seconde moyennes dans un grand nombre de jeux populaires à différentes résolutions :
| Full HD | 80−85
−161%
| 209
+161%
|
| 1440p | 50−55
−166%
| 133
+166%
|
| 4K | 30−35
−180%
| 84
+180%
|
Performances en matière de FPS dans les jeux populaires
Full HD
Medium Preset
| Assassin's Creed Odyssey | 150−160
+0%
|
150−160
+0%
|
| Assassin's Creed Valhalla | 140−150
+0%
|
140−150
+0%
|
| Battlefield 5 | 240−250
+0%
|
240−250
+0%
|
| Call of Duty: Modern Warfare | 120−130
+0%
|
120−130
+0%
|
| Far Cry 5 | 110−120
+0%
|
110−120
+0%
|
| Far Cry New Dawn | 190−200
+0%
|
190−200
+0%
|
| Forza Horizon 4 | 240−250
+0%
|
240−250
+0%
|
| Hitman 3 | 120−130
+0%
|
120−130
+0%
|
| Horizon Zero Dawn | 270−280
+0%
|
270−280
+0%
|
| Metro Exodus | 150−160
+0%
|
150−160
+0%
|
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
| Shadow of the Tomb Raider | 300−350
+0%
|
300−350
+0%
|
| Watch Dogs: Legion | 150−160
+0%
|
150−160
+0%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 150−160
+0%
|
150−160
+0%
|
| Assassin's Creed Valhalla | 140−150
+0%
|
140−150
+0%
|
| Battlefield 5 | 240−250
+0%
|
240−250
+0%
|
| Call of Duty: Modern Warfare | 120−130
+0%
|
120−130
+0%
|
| Far Cry 5 | 110−120
+0%
|
110−120
+0%
|
| Far Cry New Dawn | 190−200
+0%
|
190−200
+0%
|
| Forza Horizon 4 | 240−250
+0%
|
240−250
+0%
|
| Hitman 3 | 120−130
+0%
|
120−130
+0%
|
| Horizon Zero Dawn | 270−280
+0%
|
270−280
+0%
|
| Metro Exodus | 150−160
+0%
|
150−160
+0%
|
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
| Shadow of the Tomb Raider | 428
+0%
|
428
+0%
|
| The Witcher 3: Wild Hunt | 170−180
+0%
|
170−180
+0%
|
| Watch Dogs: Legion | 150−160
+0%
|
150−160
+0%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 150−160
+0%
|
150−160
+0%
|
| Assassin's Creed Valhalla | 140−150
+0%
|
140−150
+0%
|
| Call of Duty: Modern Warfare | 120−130
+0%
|
120−130
+0%
|
| Far Cry 5 | 110−120
+0%
|
110−120
+0%
|
| Forza Horizon 4 | 240−250
+0%
|
240−250
+0%
|
| Hitman 3 | 120−130
+0%
|
120−130
+0%
|
| Horizon Zero Dawn | 270−280
+0%
|
270−280
+0%
|
| Shadow of the Tomb Raider | 381
+0%
|
381
+0%
|
| The Witcher 3: Wild Hunt | 201
+0%
|
201
+0%
|
| Watch Dogs: Legion | 139
+0%
|
139
+0%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
1440p
High Preset
| Battlefield 5 | 160−170
+0%
|
160−170
+0%
|
| Far Cry New Dawn | 110−120
+0%
|
110−120
+0%
|
1440p
Ultra Preset
| Assassin's Creed Odyssey | 90−95
+0%
|
90−95
+0%
|
| Assassin's Creed Valhalla | 100−110
+0%
|
100−110
+0%
|
| Call of Duty: Modern Warfare | 80−85
+0%
|
80−85
+0%
|
| Far Cry 5 | 80−85
+0%
|
80−85
+0%
|
| Forza Horizon 4 | 270−280
+0%
|
270−280
+0%
|
| Hitman 3 | 110−120
+0%
|
110−120
+0%
|
| Horizon Zero Dawn | 200−210
+0%
|
200−210
+0%
|
| Metro Exodus | 120−130
+0%
|
120−130
+0%
|
| Shadow of the Tomb Raider | 265
+0%
|
265
+0%
|
| The Witcher 3: Wild Hunt | 154
+0%
|
154
+0%
|
| Watch Dogs: Legion | 240−250
+0%
|
240−250
+0%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
4K
High Preset
| Battlefield 5 | 85−90
+0%
|
85−90
+0%
|
| Far Cry New Dawn | 65−70
+0%
|
65−70
+0%
|
| Hitman 3 | 70−75
+0%
|
70−75
+0%
|
| Horizon Zero Dawn | 220−230
+0%
|
220−230
+0%
|
| Metro Exodus | 130−140
+0%
|
130−140
+0%
|
| The Witcher 3: Wild Hunt | 133
+0%
|
133
+0%
|
4K
Ultra Preset
| Assassin's Creed Odyssey | 65−70
+0%
|
65−70
+0%
|
| Assassin's Creed Valhalla | 60−65
+0%
|
60−65
+0%
|
| Call of Duty: Modern Warfare | 50−55
+0%
|
50−55
+0%
|
| Far Cry 5 | 50−55
+0%
|
50−55
+0%
|
| Forza Horizon 4 | 140−150
+0%
|
140−150
+0%
|
| Shadow of the Tomb Raider | 132
+0%
|
132
+0%
|
| Watch Dogs: Legion | 62
+0%
|
62
+0%
|
4K
Epic Preset
| Red Dead Redemption 2 | 90−95
+0%
|
90−95
+0%
|
C'est ainsi que M6000 24 GB et RTX 4070 SUPER rivalisent dans les jeux populaires :
- RTX 4070 SUPER est 161% plus rapide dans 1080p.
- RTX 4070 SUPER est 166% plus rapide dans 1440p.
- RTX 4070 SUPER est 180% plus rapide dans 4K.
En somme, des jeux populaires :
- il y a un tirage au sort dans 66 tests (100%)
Résumé des avantages et des inconvénients
| Note de performance | 30.80 | 77.82 |
| Nouveauté | 5 Mars 2016 | 17 Janvier 2024 |
| Capacité de mémoire maximale | 24 Gb | 12 Gb |
| Processus technologique | 28 nm | 5 nm |
| Consommation d'énergie (TDP) | 250 Watt | 220 Watt |
M6000 24 GB a une quantité maximale de VRAM 100% plus élevée.
RTX 4070 SUPER, quant à lui, a un score de performance agrégé 152.7% plus élevé, un avantage de 7 ans, un 460% processus de lithographie plus avancé, et 13.6% de consommation d'énergie en moins.
Le GeForce RTX 4070 SUPER est notre choix recommandé car il bat le Quadro M6000 24 GB dans les tests de performance.
Il faut savoir que Quadro M6000 24 GB est destiné aux postes de travail et GeForce RTX 4070 SUPER est destiné aux ordinateurs de bureau.
Si vous avez encore des questions sur le choix entre Quadro M6000 24 GB et GeForce RTX 4070 SUPER - posez-les dans les commentaires et nous vous répondrons.
Comparaisons avec des GPU similaires
Nous avons sélectionné plusieurs comparaisons de cartes graphiques dont les performances sont plus ou moins proches de celles des cartes examinées, ce qui vous donne plus d'options probables à considérer.
Ошибка: Запрос 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=2460 and pop.lang="9" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9" where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2016-03-05","-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(30.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=2460 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-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(30.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=2460 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-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(30.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_desktop_1_2460_L9
[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=2460 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-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(30.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=10742 and pop.lang="9" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="9" where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2024-01-17","-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(77.82 - 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=10742 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2024-01-17","-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(77.82 - 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=10742 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2024-01-17","-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(77.82 - 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_desktop_1_10742_L9
[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=10742 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2024-01-17","-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(77.82 - 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=2460 and pop.lang="9" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9" where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2016-03-05","-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(30.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=2460 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-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(30.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=2460 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-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(30.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_desktop_1_2460_L9
[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=2460 and pop.lang="9"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="9"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-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(30.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
)
)
