у меня на ПК c Win 64 бит около 60 сек в phpMyAdmin занял этот запрос.
Showing rows 0 - 24 (130 total, Query took 60.2376 seconds.)
SELECT `file_title`, `file_url`, `published`, `virtuemart_media_id` FROM ytgb1_virtuemart_medias AS m LEFT JOIN ytgb1_virtuemart_product_medias AS pm USING(virtuemart_media_id) WHERE pm.virtuemart_media_id IS NULL AND m.file_type = 'product'
Интересно, что если условие is null заменить на is not null то
Showing rows 0 - 24 (23154 total, Query took 0.0018 seconds.)
SELECT `file_title`, `file_url`, `published`, `virtuemart_media_id` FROM ytgb1_virtuemart_medias AS m LEFT JOIN ytgb1_virtuemart_product_medias AS pm USING(virtuemart_media_id) WHERE pm.virtuemart_media_id IS NOT NULL AND m.file_type = 'product'
pm.virtuemart_media_id согласно структуре таблицы не null. может MySQL в моей версии и в версии ТС "спотыкается" на проверке этого поля на null?
--
-- Table structure for table `ytgb1_virtuemart_product_medias`
--
CREATE TABLE `ytgb1_virtuemart_product_medias` (
`id` int(1) UNSIGNED NOT NULL,
`virtuemart_product_id` int(1) UNSIGNED NOT NULL DEFAULT '0',
`virtuemart_media_id` int(1) UNSIGNED NOT NULL DEFAULT '0',
`ordering` int(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Database server
Server: localhost via TCP/IP
Server type: MySQL
Server version: 5.7.10 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
Web server
Apache/2.4.18 (Win64) PHP/5.6.17
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 5.6.17