$sql=select * from `oc_seo_url` where `keyword`='chekhol-sgp-ultra-hybrid-mag-dlya-apple-iphone-14-pro-max-67-fioletovyj' and (`query` like 'product_id=%' or `query`='category=%')
$query=stdClass Object
(
[num_rows] => 1
[row] => Array
(
[seo_url_id] => 34209
[store_id] => 0
[language_id] => 3
[query] => product_id=580301
[keyword] => chekhol-sgp-ultra-hybrid-mag-dlya-apple-iphone-14-pro-max-67-fioletovyj
)
[rows] => Array
(
[0] => Array
(
[seo_url_id] => 34209
[store_id] => 0
[language_id] => 3
[query] => product_id=580301
[keyword] => chekhol-sgp-ultra-hybrid-mag-dlya-apple-iphone-14-pro-max-67-fioletovyj
)
)
)
=======================================
$_SERVER[REQUEST_URI]=/ru/chekhol-sgp-ultra-hybrid-mag-dlya-apple-iphone-14-pro-max-67-fioletovyj $href=chekhol-sgp-ultra-hybrid-mag-dlya-apple-iphone-14-pro-max-67-fioletovyj
$query=product_id=580301
$id=580301 $type=0
$sql=SELECT * FROM `oc_plink_links` where `type`='0' and `product_id`='580301'
$query->num_rows=0 $count= id=
INSERT INTO `oc_plink_links` (`id`,`product_id`,`category_id`,`type`,`language_id`,`anchor-ua`,`link-ua`,`anchor-ru`,`link-ru`) values ('27297','7243016','98','0','1','прозорі чохли на айфон х','https://inmobi.com.ua/chohly-dlya-iphone-x/transparent','прозрачные чехлы на айфон х','https://inmobi.com.ua/ru/chohli-dlya-iphone-x/transparent');
Fatal error: Uncaught Exception: Error: Duplicate entry '27297' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_plink_links` (`id`,`product_id`,`category_id`,`type`,`language_id`,`anchor-ua`,`link-ua`,`anchor-ru`,`link-ru`) values ('27297','7243016','98','0','1','прозорі чохли на айфон х','https://inmobi.com.ua/chohly-dlya-iphone-x/transparent','прозрачные чехлы на айфон х','https://inmobi.com.ua/ru/chohli-dlya-iphone-x/transparent'); in /home/inmobi/sites/inmobi.com.ua/system/library/db/mysqli.php:41
Stack trace:
#0 /home/inmobi/sites/inmobi.com.ua/system/library/db.php(45): DB\MySQLi->query('INSERT INTO `oc...')
#1 /home/inmobi/sites/inmobi.com.ua/catalog/model/extension/module/plink.php(82): DB->query('INSERT INTO `oc...')
#2 /home/inmobi/sites/storage/modification/system/engine/loader.php(460): ModelExtensionModulePlink->getLinks('580301', 0)
#3 /home/inmobi/sites/inmobi.com.ua/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/inmobi/sites/stora in /home/inmobi/sites/inmobi.com.ua/system/library/db/mysqli.php on line 41