Illuminate\Database\QueryException {#908
#sql: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
#bindings: array:7 [
0 => 1
1 => 1
2 => "HSA-320EA"
3 => 1
4 => 1
5 => 1
6 => 1
]
#message: "SQLSTATE[42000]: Syntax error or access violation: 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 '.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_' at line 1 (SQL: select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = 1 and `is_visible` = 1 and `url_title` = HSA-320EA and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = 1 and `is_visible` = 1 and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = 1 and `is_visible` = 1)) limit 1)"
#code: "42000"
#file: "/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 665
-previous: PDOException {#909
#message: "SQLSTATE[42000]: Syntax error or access violation: 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 '.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_' at line 1"
#code: "42000"
#file: "/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 327
+errorInfo: array:3 [
0 => "42000"
1 => 1064
2 => "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 '.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_' at line 1"
]
trace: {
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:327 {
Illuminate\Database\Connection->Illuminate\Database\{closure} …
› $statement = $this->prepared($this->getPdoForSelect($useReadPdo)
› ->prepare($query));
›
arguments: {
$statement: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:658 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› try {
› $result = $callback($query, $bindings);
› }
arguments: {
"select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
array:7 [ …7]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#806 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:334 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#806 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2140 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
$bindings: array:7 [ …7]
$useReadPdo: true
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2128 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns(Arr::wrap($columns), function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2572 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2129 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#905 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:521 {
Illuminate\Database\Eloquent\Builder->getModels($columns = […1]) …
› return $this->model->hydrate(
› $this->query->get($columns)->all()
› )->all();
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:505 {
Illuminate\Database\Eloquent\Builder->get($columns = […1]) …
› // n+1 query issue for the developers to avoid running a lot of queries.
› if (count($models = $builder->getModels($columns)) > 0) {
› $models = $builder->eagerLoadRelations($models);
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:143 {
Illuminate\Database\Eloquent\Builder->first($columns = […1]) …
› {
› return $this->take(1)->get($columns)->first();
› }
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/app/Http/Models/Product/Product.php:146 {
App\Http\Models\Product\Product::detail($url) …
› ->with(['ProductSubcate.ProductCate','getProductImg','getProductOnly','getProductIcon','getProductFeature','getProductArticle.getProductArticleThree','getProductFormat.getProductFormatItem'])
› ->first();
› }
}
/home/hartford/public_html/app/Http/Controllers/Front/ProductController.php:100 {
App\Http\Controllers\Front\ProductController->detail(Request $req) …
› $url=$req->url;
› $data=Product::detail($url);
› if(!$this->front->checkExist($data)){
arguments: {
$url: "HSA-320EA"
}
}
App\Http\Controllers\Front\ProductController->detail() {}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 {
Illuminate\Routing\Controller->callAction($method, $parameters) …
› {
› return call_user_func_array([$this, $method], $parameters);
› }
arguments: {
$function_name: array:2 [ …2]
$parameters: array:4 [ …4]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 {
Illuminate\Routing\ControllerDispatcher->dispatch(Route $route, $controller, $method) …
› if (method_exists($controller, 'callAction')) {
› return $controller->callAction($method, $parameters);
› }
arguments: {
$method: "detail"
$parameters: array:4 [ …4]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 {
Illuminate\Routing\Route->runController() …
› return $this->controllerDispatcher()->dispatch(
› $this, $this->getController(), $this->getControllerMethod()
› );
arguments: {
$route: Illuminate\Routing\Route {#373 …}
$controller: App\Http\Controllers\Front\ProductController {#487 …}
$method: "detail"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/RedirectOldMiddleware.php:33 {
App\Http\Middleware\RedirectOldMiddleware->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 {
Illuminate\Routing\Middleware\SubstituteBindings->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76 {
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle($request, Closure $next) …
› ) {
› return tap($next($request), function ($response) use ($request) {
› if ($this->shouldAddXsrfTokenCookie()) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 {
Illuminate\View\Middleware\ShareErrorsFromSession->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 {
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle($request, Closure $next) …
› {
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 {
Illuminate\Cookie\Middleware\EncryptCookies->handle($request, Closure $next) …
› {
› return $this->encrypt($next($this->decrypt($request)));
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#478 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#373 …}
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
$route: Illuminate\Routing\Route {#373 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure} …
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/AddHeaders.php:54 {
App\Http\Middleware\AddHeaders->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62 {
Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter($request) …
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure($request) {#418 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
Illuminate\Foundation\Http\Kernel->handle($request) …
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/public/index.php:50 {
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
}
}
+errorInfo: array:3 [
0 => "42000"
1 => 1064
2 => "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 '.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_' at line 1"
]
trace: {
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:665 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› catch (Exception $e) {
› throw new QueryException(
› $query, $this->prepareBindings($bindings), $e
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#806 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:334 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
$bindings: array:7 [ …7]
$callback: Closure($query, $bindings) {#806 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2140 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select en_product.*, n5HtOysndN.real_route AS img_url, n5HtOysndN.alt AS img_alt, eiV0Uy79i3.real_route AS premiun_img_url, eiV0Uy79i3.alt AS premiun_img_alt, KLPGpcZL1L.real_route AS premiun_block2_focus_icon1_url, KLPGpcZL1L.alt AS premiun_block2_focus_icon1_alt, lAvl4Oyrkv.real_route AS premiun_block2_focus_icon2_url, lAvl4Oyrkv.alt AS premiun_block2_focus_icon2_alt, MppjyWSWFf.real_route AS premiun_block2_focus_icon3_url, MppjyWSWFf.alt AS premiun_block2_focus_icon3_alt, JsVtLkZuYQ.real_route AS premiun_block2_focus_icon4_url, JsVtLkZuYQ.alt AS premiun_block2_focus_icon4_alt, 4E9qqx8rTb.real_route AS premiun_block2_focus_icon5_url, 4E9qqx8rTb.alt AS premiun_block2_focus_icon5_alt, EhsAptTGoh.real_route AS premiun_block2_focus_icon6_url, EhsAptTGoh.alt AS premiun_block2_focus_icon6_alt from `en_product` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `n5HtOysndN` on `en_product`.`img` = `n5HtOysndN`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `eiV0Uy79i3` on `en_product`.`premiun_img` = `eiV0Uy79i3`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `KLPGpcZL1L` on `en_product`.`premiun_block2_focus_icon1` = `KLPGpcZL1L`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `lAvl4Oyrkv` on `en_product`.`premiun_block2_focus_icon2` = `lAvl4Oyrkv`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `MppjyWSWFf` on `en_product`.`premiun_block2_focus_icon3` = `MppjyWSWFf`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `JsVtLkZuYQ` on `en_product`.`premiun_block2_focus_icon4` = `JsVtLkZuYQ`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `4E9qqx8rTb` on `en_product`.`premiun_block2_focus_icon5` = `4E9qqx8rTb`.`file_key` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `EhsAptTGoh` on `en_product`.`premiun_block2_focus_icon6` = `EhsAptTGoh`.`file_key` where `branch_id` = ? and `is_visible` = ? and `url_title` = ? and exists (select * from `en_product_subcate` where `en_product`.`f_id` = `en_product_subcate`.`id` and `branch_id` = ? and `is_visible` = ? and exists (select * from `en_product_cate` where `en_product_subcate`.`f_id` = `en_product_cate`.`id` and `branch_id` = ? and `is_visible` = ?)) limit 1"
$bindings: array:7 [ …7]
$useReadPdo: true
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2128 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns(Arr::wrap($columns), function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2572 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2129 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#905 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:521 {
Illuminate\Database\Eloquent\Builder->getModels($columns = […1]) …
› return $this->model->hydrate(
› $this->query->get($columns)->all()
› )->all();
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:505 {
Illuminate\Database\Eloquent\Builder->get($columns = […1]) …
› // n+1 query issue for the developers to avoid running a lot of queries.
› if (count($models = $builder->getModels($columns)) > 0) {
› $models = $builder->eagerLoadRelations($models);
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:143 {
Illuminate\Database\Eloquent\Builder->first($columns = […1]) …
› {
› return $this->take(1)->get($columns)->first();
› }
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/app/Http/Models/Product/Product.php:146 {
App\Http\Models\Product\Product::detail($url) …
› ->with(['ProductSubcate.ProductCate','getProductImg','getProductOnly','getProductIcon','getProductFeature','getProductArticle.getProductArticleThree','getProductFormat.getProductFormatItem'])
› ->first();
› }
}
/home/hartford/public_html/app/Http/Controllers/Front/ProductController.php:100 {
App\Http\Controllers\Front\ProductController->detail(Request $req) …
› $url=$req->url;
› $data=Product::detail($url);
› if(!$this->front->checkExist($data)){
arguments: {
$url: "HSA-320EA"
}
}
App\Http\Controllers\Front\ProductController->detail() {}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 {
Illuminate\Routing\Controller->callAction($method, $parameters) …
› {
› return call_user_func_array([$this, $method], $parameters);
› }
arguments: {
$function_name: array:2 [ …2]
$parameters: array:4 [ …4]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 {
Illuminate\Routing\ControllerDispatcher->dispatch(Route $route, $controller, $method) …
› if (method_exists($controller, 'callAction')) {
› return $controller->callAction($method, $parameters);
› }
arguments: {
$method: "detail"
$parameters: array:4 [ …4]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 {
Illuminate\Routing\Route->runController() …
› return $this->controllerDispatcher()->dispatch(
› $this, $this->getController(), $this->getControllerMethod()
› );
arguments: {
$route: Illuminate\Routing\Route {#373 …}
$controller: App\Http\Controllers\Front\ProductController {#487 …}
$method: "detail"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/RedirectOldMiddleware.php:33 {
App\Http\Middleware\RedirectOldMiddleware->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 {
Illuminate\Routing\Middleware\SubstituteBindings->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76 {
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle($request, Closure $next) …
› ) {
› return tap($next($request), function ($response) use ($request) {
› if ($this->shouldAddXsrfTokenCookie()) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 {
Illuminate\View\Middleware\ShareErrorsFromSession->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 {
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle($request, Closure $next) …
› {
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 {
Illuminate\Cookie\Middleware\EncryptCookies->handle($request, Closure $next) …
› {
› return $this->encrypt($next($this->decrypt($request)));
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#478 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#373 …}
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
$route: Illuminate\Routing\Route {#373 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure} …
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/AddHeaders.php:54 {
App\Http\Middleware\AddHeaders->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62 {
Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter($request) …
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure($request) {#418 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
Illuminate\Foundation\Http\Kernel->handle($request) …
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/public/index.php:50 {
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
}
}