2024-08-17 11:20:59 --- EMERGENCY: ErrorException [ 2 ]: imagecreatefrompng(../storage/uploads/products/null.png): failed to open stream: No such file or directory ~ APPPATH/classes/Controller/Index/Imagercrop.php [ 336 ] in file:line
2024-08-17 11:20:59 --- DEBUG: #0 [internal function]: Kohana_Core::error_handler(2, 'imagecreatefrom...', '/var/www/batumi...', 336, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Imagercrop.php(336): imagecreatefrompng('../storage/uplo...')
#2 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Imagercrop.php(54): Controller_Index_Imagercrop->product_image(950, 631, 'k5pn12xoeur679g...', 'product', true)
#3 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Imagercrop->action_product()
#4 [internal function]: Kohana_Controller->execute()
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Imagercrop))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#7 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#8 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#9 {main} in file:line
2024-08-17 11:21:00 --- EMERGENCY: ErrorException [ 2 ]: imagecreatefrompng(../storage/uploads/products/null.png): failed to open stream: No such file or directory ~ APPPATH/classes/Controller/Index/Imagercrop.php [ 336 ] in file:line
2024-08-17 11:21:00 --- DEBUG: #0 [internal function]: Kohana_Core::error_handler(2, 'imagecreatefrom...', '/var/www/batumi...', 336, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Imagercrop.php(336): imagecreatefrompng('../storage/uplo...')
#2 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Imagercrop.php(54): Controller_Index_Imagercrop->product_image(950, 631, 'k5pn12xoeur679g...', 'product', true)
#3 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Imagercrop->action_product()
#4 [internal function]: Kohana_Controller->execute()
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Imagercrop))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#7 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#8 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#9 {main} in file:line
2024-08-17 16:24:35 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id INNER JOIN category_product AS c6 ON c6.product_id = c1.id AND c6.category_id = 583 WHERE c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:24:35 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(254): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_category()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:24:39 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id INNER JOIN category_product AS c6 ON c6.product_id = c1.id AND c6.category_id = 583 WHERE c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:24:39 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(254): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_category()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:15 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id INNER JOIN category_product AS c6 ON c6.product_id = c1.id AND c6.category_id = 583 WHERE c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:15 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(254): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_category()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:19 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id INNER JOIN category_product AS c6 ON c6.product_id = c1.id AND c6.category_id = 583 WHERE c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:19 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(254): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_category()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:22 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id INNER JOIN category_product AS c6 ON c6.product_id = c1.id AND c6.category_id = 583 WHERE c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:22 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(254): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_category()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:26 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id INNER JOIN category_product AS c6 ON c6.product_id = c1.id AND c6.category_id = 583 WHERE c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-08-17 16:26:26 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(254): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_category()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251