<?php
2/**
3* Objeto de funções de resultados e queries
4*
5* @package Icecream
6* @author Lucas/Postali
7*/
8 namespace Icecream;
9
10 use \PDO;
11 use \Fault;
12
13 trait _Results
14 {
15 private $_result;
16 private $_query;
17
18 /**
19 * Verifica se há resultados prontos
20 *
21 * @return boolean
22 */
23 public function hasResults ()
24 {
25 return is_null($this->_result) ? false : true;
26 }
27
28 /**
29 * Apaga os resultados anteriores
30 *
31 * @return null
32 */
33 public function eraseResults ()
34 {
35 $this->_result = null;
36 }
37
38 private $_throwError = false;
39
40 /**
41 * Informa se o erro deve ser exibido de maneira simples, com um Fault (false), ou de maneira severa (true)
42 *
43 * @param boolean $condition Condição
44 *
45 * @return Icecream
46 */
47 public function throwError ($condition = true)
48 {
49 if($condition === false || $condition === true)
50 $this->_throwError = $condition;
51
52 return $this;
53 }
54
55 /**
56 * Informa se o erro deve ser exibido de maneira simples, com um Fault (false), ou de maneira severa (true) para todas as instâncias do Icecream
57 *
58 * @param boolean $condition Condição
59 *
60 * @return null
61 */
62 static public function alwaysThrowError ($condition = true)
63 {
64 if($condition === false || $condition === true)
65 $GLOBALS['icecream_throw_error'] = $condition;
66 }
67
68 /**
69 * Cria um objeto de Fault de acordo com o erro do PDO
70 *
71 * @param object $object Objeto PDO
72 *
73 * @return object
74 */
75 private function _parseError ($object)
76 {
77 //Resgatar detalhes do erro
78 $error = $object->errorInfo();
79
80 $description = is_null($error[2]) ? 'Unknown error' : $error[2];
81
82 //Se permitido que o erro seja enviado
83 if($this->_throwError)
84 Error($description, false);
85
86 //Retornar um objeto Fault com detalhes do erro
87 else
88 return new Fault($description, $error[0], $this);
89
90 }
91
92 public $connection;
93
94 /**
95 * Executa um comando do PDO
96 *
97 * @param string $queryString String da query
98 * @param boolean $bind Permite o vínculo de parâmetros
99 *
100 * @return mixed
101 */
102 private function _exec ($queryString, $bind = true)
103 {
104 if(self::isTraceEnabled())
105 trace("Executing query", 'Icecream', ['query' => $queryString, 'params' => $this->getParam() ]);
106
107 //Abre a conexão
108 try
109 {
110 $this->connection = $this->_pdoConnection();
111
112 //Permitir que os valores retornem tipados (inteiros e floats)
113 if(substr($queryString, 0, 6) == "SELECT")
114 {
115 $this->connection->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
116 $this->connection->setAttribute(PDO::ATTR_EMULATE_PREPARES , false);
117 }
118 }
119 catch(PDOException $e)
120 {
121 return $this->_parseError($this->connection);
122 }
123
124 //Prepara a query
125 try
126 {
127 $query = $this->connection->prepare($queryString);
128 }
129 catch(PDOException $e)
130 {
131 return $this->_parseError($query);
132 }
133
134 //Caso a query tenha algum erro, retornar erro
135 if(!$query)
136 return $this->_parseError($this->connection);
137
138 //Incluir valores
139 if($bind === true)
140 $this->_bindParam($query);
141
142 //Executar query
143 $result = $query->execute();
144
145 //Verificar se houve erros
146 if(!$result)
147 return $this->_parseError($query);
148
149 return $query;
150 }
151 }
You can see detailed error trace in the console.
render ()
/var/www/castelliporcelanato.com.br/public/index.php 19
_processContent ()
/var/www/castelliporcelanato.com.br/public/Modules/Core/Navigation/Page.php 401
require ('/var/www/castelliporcelanato.com.br/public/View/castelli/produto.php')
/var/www/castelliporcelanato.com.br/public/Modules/Core/Navigation/Page.php 310
fetchProductBySlug ('butron-imbuia-493')
/var/www/castelliporcelanato.com.br/public/View/castelli/produto.php 24
selectFirst ()
/var/www/castelliporcelanato.com.br/public/Controllers/Product.php 431
_append (array ( 'id' => 493, 'title' => 'Butron Imbuia', 'slug' => 'butron-imbuia-493', 'link_simulation' => NULL, 'ambiente_img' => 'a4ae85bb9d6c445c85b9d3ecd324e6d8.jpg', 'img_product_ambiente_url' => 'https://grupoembramaco.com.br/public/images/product/a4ae85bb9d6c445c85b9d3ecd324e6d8.jpg', 'code' => '70734', 'id_category' => NULL, 'id_package' => 29, 'description' => NULL, 'attributes' => array ( 0 => array ( 'id' => 1471, 'id_attribute' => 10, 'id_product' => 493, 'id_option' => 82, 'text' => 'LD - Alto Tráfego', 'attribute_title' => 'Local de Uso ', 'attribute_type' => 3, 'attribute_placement' => 1, 'name' => NULL, 'option_title' => 'LD - Alto Tráfego', 'option_description' => NULL, ), 1 => array ( 'id' => 1472, 'id_attribute' => 18, 'id_product' => 493, 'id_option' => 124, 'text' => '9', 'attribute_title' => 'Número de Faces', 'attribute_type' => 2, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => '9', 'option_description' => NULL, ), 2 => array ( 'id' => 1473, 'id_attribute' => 19, 'id_product' => 493, 'id_option' => 100, 'text' => 'Parede', 'attribute_title' => 'Piso ou Parede', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Parede', 'option_description' => NULL, ), 3 => array ( 'id' => 1474, 'id_attribute' => 19, 'id_product' => 493, 'id_option' => 99, 'text' => 'Piso', 'attribute_title' => 'Piso ou Parede', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Piso', 'option_description' => NULL, ), 4 => array ( 'id' => 1475, 'id_attribute' => 20, 'id_product' => 493, 'id_option' => 103, 'text' => 'Banheiro', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Banheiro', 'option_description' => NULL, ), 5 => array ( 'id' => 1476, 'id_attribute' => 20, 'id_product' => 493, 'id_option' => 107, 'text' => 'Cozinha', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Cozinha', 'option_description' => NULL, ), 6 => array ( 'id' => 1477, 'id_attribute' => 20, 'id_product' => 493, 'id_option' => 104, 'text' => 'Quarto', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Quarto', 'option_description' => NULL, ), 7 => array ( 'id' => 1478, 'id_attribute' => 20, 'id_product' => 493, 'id_option' => 105, 'text' => 'Sacada Coberta', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Sacada Coberta', 'option_description' => NULL, ), 8 => array ( 'id' => 1479, 'id_attribute' => 20, 'id_product' => 493, 'id_option' => 106, 'text' => 'Salas', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Salas', 'option_description' => NULL, ), 9 => array ( 'id' => 1480, 'id_attribute' => 22, 'id_product' => 493, 'id_option' => 115, 'text' => 'Legno', 'attribute_title' => 'Linha', 'attribute_type' => 2, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Legno', 'option_description' => NULL, ), 10 => array ( 'id' => 1481, 'id_attribute' => 7, 'id_product' => 493, 'id_option' => 7, 'text' => 'Acetinado', 'attribute_title' => 'Tipologia', 'attribute_type' => 3, 'attribute_placement' => 1, 'name' => NULL, 'option_title' => 'Acetinado', 'option_description' => NULL, ), ), 'ambientes' => array ( 0 => array ( 'id' => 737, 'id_ambiente' => 7, 'id_product' => 493, 'title' => 'Banheiro', 'image' => '8a3d9b400b55703c999b5bc1daea3cda.webp', 'ambiente_title' => 'Banheiro', ), 1 => array ( 'id' => 738, 'id_ambiente' => 6, 'id_product' => 493, 'title' => 'Cozinha', 'image' => '56d54e0093b397c5cadc0c9010fd9f2e.webp', 'ambiente_title' => 'Cozinha', ), 2 => array ( 'id' => 739, 'id_ambiente' => 11, 'id_product' => 493, 'title' => 'Quarto', 'image' => '83723e064d4d485a47b9b38c2777b1b5.webp', 'ambiente_title' => 'Quarto', ), 3 => array ( 'id' => 740, 'id_ambiente' => 10, 'id_product' => 493, 'title' => 'Sacada Coberta', 'image' => '1f40181daba52caa745870a9b421d023.webp', 'ambiente_title' => 'Sacada Coberta', ), 4 => array ( 'id' => 741, 'id_ambiente' => 5, 'id_product' => 493, 'title' => 'Sala', 'image' => 'e3bb01ef5567dc6d4469dd7fbc2b2cd6.jpg', 'ambiente_title' => 'Sala', ), ), 'package' => array ( 0 => array ( 'id' => 29, 'title' => '20x122cm', 'specs' => array ( 0 => array ( 'id' => 280, 'id_package' => 29, 'id_spec' => 1, 'value' => '9,0mm', 'title' => 'Espessura', ), 1 => array ( 'id' => 281, 'id_package' => 29, 'id_spec' => 2, 'value' => '48', 'title' => 'Caixas/Pallet', ), 2 => array ( 'id' => 282, 'id_package' => 29, 'id_spec' => 3, 'value' => '30kg', 'title' => 'Peso/Caixa', ), 3 => array ( 'id' => 283, 'id_package' => 29, 'id_spec' => 4, 'value' => '1.440kg', 'title' => 'Peso do Pallet', ), 4 => array ( 'id' => 284, 'id_package' => 29, 'id_spec' => 5, 'value' => '1,47m²', 'title' => 'm²/Caixa', ), 5 => array ( 'id' => 285, 'id_package' => 29, 'id_spec' => 6, 'value' => '2mm', 'title' => 'Junta Mínima', ), 6 => array ( 'id' => 286, 'id_package' => 29, 'id_spec' => 7, 'value' => 'Sim', 'title' => 'Retificado', ), 7 => array ( 'id' => 287, 'id_package' => 29, 'id_spec' => 8, 'value' => '6', 'title' => 'Peças/Caixa', ), 8 => array ( 'id' => 348, 'id_package' => 29, 'id_spec' => 12, 'value' => '70,56', 'title' => 'm²/Pallet', ), ), ), ), 'features' => array ( 0 => array ( 'id' => 46, 'id_product' => 493, 'id_feature' => 1, 'title' => 'Lançamento', 'filter' => 1, 'name' => 'new', ), ), 'images' => array ( 0 => array ( 'id' => 690, 'id_product' => 493, 'image' => 'a4ae85bb9d6c445c85b9d3ecd324e6d8.jpg', 'thumb' => 'a4ae85bb9d6c445c85b9d3ecd324e6d8_th.jpg', 'main' => 1, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/a4ae85bb9d6c445c85b9d3ecd324e6d8.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/a4ae85bb9d6c445c85b9d3ecd324e6d8_th.jpg', ), 1 => array ( 'id' => 691, 'id_product' => 493, 'image' => '2fcb397aa7192df14e16f851eb140f23.jpg', 'thumb' => '2fcb397aa7192df14e16f851eb140f23_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/2fcb397aa7192df14e16f851eb140f23.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/2fcb397aa7192df14e16f851eb140f23_th.jpg', ), 2 => array ( 'id' => 692, 'id_product' => 493, 'image' => 'c77b409411f1ce3c894befe9ad1d5117.jpg', 'thumb' => 'c77b409411f1ce3c894befe9ad1d5117_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/c77b409411f1ce3c894befe9ad1d5117.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/c77b409411f1ce3c894befe9ad1d5117_th.jpg', ), 3 => array ( 'id' => 693, 'id_product' => 493, 'image' => '3e58bf2efff778b182089e954ca7b380.jpg', 'thumb' => '3e58bf2efff778b182089e954ca7b380_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/3e58bf2efff778b182089e954ca7b380.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/3e58bf2efff778b182089e954ca7b380_th.jpg', ), 4 => array ( 'id' => 694, 'id_product' => 493, 'image' => '941bcc13afa2ebaa7e9a26d39339e139.jpg', 'thumb' => '941bcc13afa2ebaa7e9a26d39339e139_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/941bcc13afa2ebaa7e9a26d39339e139.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/941bcc13afa2ebaa7e9a26d39339e139_th.jpg', ), 5 => array ( 'id' => 695, 'id_product' => 493, 'image' => 'a9d873b0b4758ebd7156731f1d3b6045.jpg', 'thumb' => 'a9d873b0b4758ebd7156731f1d3b6045_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/a9d873b0b4758ebd7156731f1d3b6045.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/a9d873b0b4758ebd7156731f1d3b6045_th.jpg', ), 6 => array ( 'id' => 696, 'id_product' => 493, 'image' => 'c5ff3da7abd43d27f42d25575d7f1874.jpg', 'thumb' => 'c5ff3da7abd43d27f42d25575d7f1874_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/c5ff3da7abd43d27f42d25575d7f1874.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/c5ff3da7abd43d27f42d25575d7f1874_th.jpg', ), 7 => array ( 'id' => 697, 'id_product' => 493, 'image' => 'a3d219b52efadc2815cf0a42bd26f8b9.jpg', 'thumb' => 'a3d219b52efadc2815cf0a42bd26f8b9_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/a3d219b52efadc2815cf0a42bd26f8b9.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/a3d219b52efadc2815cf0a42bd26f8b9_th.jpg', ), 8 => array ( 'id' => 698, 'id_product' => 493, 'image' => '2184876c55a284e25e0144e77fca2981.jpg', 'thumb' => '2184876c55a284e25e0144e77fca2981_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/2184876c55a284e25e0144e77fca2981.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/2184876c55a284e25e0144e77fca2981_th.jpg', ), ), 'category' => array ( ), ))
/var/www/castelliporcelanato.com.br/public/Modules/Classes/Icecream/_Select.php 210
resultList ('&&.id_product',
NULL,
true)
/var/www/castelliporcelanato.com.br/public/Modules/Classes/Icecream/_Select.php 536
select ()
/var/www/castelliporcelanato.com.br/public/Modules/Classes/Icecream/_Select.php 323
_selectQuery ()
/var/www/castelliporcelanato.com.br/public/Modules/Classes/Icecream/_Select.php 180
_exec ('SELECT product_downloadable.id,product_downloadable.name,product_downloadable.thumb,product_downloadable.id_product,product_ambiente.id_ambiente,product_downloadable.date_update,product_downloadable.file,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/product/\', product_downloadable.file) as file_url,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/product/\', product_downloadable.thumb) as thumb_url,product_downloadable.link,product_downloadable.id_downloadable,downloadable.title,downloadable.type,downloadable.section FROM product_downloadable LEFT JOIN (SELECT downloadable.id,downloadable.title,downloadable.type,downloadable.section FROM downloadable WHERE downloadable.date_delete IS NULL ) AS downloadable ON downloadable.id = product_downloadable.id_downloadable LEFT JOIN (SELECT product_ambiente.id,product_ambiente.id_ambiente,product_ambiente.id_product,ambiente.title,ambiente.image,ambiente.title AS ambiente_title FROM product_ambiente LEFT JOIN (SELECT ambiente.id,ambiente.title,ambiente.image,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/ambiente/\', ambiente.image) as img_ambiente_url FROM ambiente AS ambiente WHERE ambiente.date_delete IS NULL ORDER BY ambiente.title ASC ) AS ambiente ON ambiente.id = product_ambiente.id_ambiente WHERE product_ambiente.date_delete IS NULL ) AS product_ambiente ON product_ambiente.id_product = product_downloadable.id_product WHERE product_downloadable.date_delete IS NULL AND product_downloadable.id_product IN (\'493\') GROUP BY product_downloadable.id ')
/var/www/castelliporcelanato.com.br/public/Modules/Classes/Icecream/_Select.php 147
_parseError (PDO::__set_state(array( )))
/var/www/castelliporcelanato.com.br/public/Modules/Classes/Icecream/_Results.php 136
Error ('Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column \'product_ambiente.id_ambiente\' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by',
false)
/var/www/castelliporcelanato.com.br/public/Modules/Classes/Icecream/_Results.php 84
You can see detailed error trace in the console.
main
System ready
'/var/www/castelliporcelanato.com.br/public'
web
Starting session
true
web
Starting web module
''
Culture
Auto discovering culture
NULL
Culture
Setting culture
'Brasil'
Navigation\Navigation
Setting Navigation default timezone
'America/Sao_Paulo'
Navigation\Navigation
Setting Navigation default language
false
web
User
'216.73.216.143'
Navigation\Navigation
Interpreting URI
'produto/butron-imbuia-493'
Navigation\Page
Instancing using class 'CMSController\Manager'
'CMSController\\Manager'
Navigation\Page
Incorporating transactional functions from class 'CMSController\Manager'
array ( 0 => 'setPanel', )
Navigation\Page
Instancing using class 'Banners'
'Banners'
Navigation\Page
Incorporating transactional functions from class 'Banners'
array ( 0 => 'getBanners', 1 => 'saveBanner', 2 => 'removeBanner', 3 => 'saveBannerOrder', )
Navigation\Page
Instancing using class 'Product'
'Product'
Icecream
Executing query
array ( 'query' => 'SELECT attribute.id,attribute.title,attribute.type,attribute.filter,attribute.sort,attribute.placement,attribute.name FROM attribute WHERE attribute.date_delete IS NULL ORDER BY attribute.sort ASC ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT attribute_options.id,attribute_options.id_attribute,attribute_options.title,attribute_options.description FROM attribute_options WHERE attribute_options.date_delete IS NULL AND id_attribute IN (\'10\',\'17\',\'18\',\'19\',\'20\',\'22\',\'7\') ORDER BY attribute_options.title ASC ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT id_option FROM product_attribute WHERE date_delete IS NULL AND id_option IN (\'125\',\'90\',\'122\',\'96\',\'123\',\'98\',\'91\',\'97\',\'92\',\'93\',\'94\',\'95\',\'121\',\'120\',\'124\',\'7\',\'101\',\'102\',\'103\',\'114\',\'107\',\'118\',\'119\',\'80\',\'83\',\'84\',\'82\',\'85\',\'115\',\'113\',\'79\',\'117\',\'100\',\'116\',\'99\',\'78\',\'104\',\'81\',\'105\',\'106\',\'86\',\'87\',\'88\',\'89\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT feature.id,feature.title,feature.name,feature.filter FROM feature WHERE feature.date_delete IS NULL ', 'params' => array ( ), )
Navigation\Page
Incorporating transactional functions from class 'Product'
array ( 0 => 'list', 1 => 'getProductLiked', 2 => 'setFavorite', 3 => 'listRelated', 4 => 'save', 5 => 'remove', 6 => 'getDownloadables', 7 => 'getProductsHome', 8 => 'listFeatures', )
Navigation\Page
Instancing using class 'Ambientes'
'Ambientes'
Navigation\Page
Incorporating transactional functions from class 'Ambientes'
array ( 0 => 'list', 1 => 'save', 2 => 'remove', )
Navigation\Page
Instancing using class 'Attributes'
'Attributes'
Navigation\Page
Incorporating transactional functions from class 'Attributes'
array ( 0 => 'list', 1 => 'save', 2 => 'remove', 3 => 'listFilters', )
Navigation\Page
Instancing using class 'Newsletter'
'Newsletter'
Navigation\Page
Incorporating transactional functions from class 'Newsletter'
array ( 0 => 'save', )
Navigation\Tags
Including asset
'js/model'
Navigation\Tags
Including asset
'css/porcelanato/produtos'
Navigation\Tags
Including asset
'castelli/css'
Navigation\Tags
Including asset
'castelli/js'
Navigation\Tags
Including asset
'vue'
Navigation\Tags
Including asset
'tools'
Navigation\Tags
Including asset
'modal'
Navigation\Tags
Including asset
'vue/dynamic'
Navigation\Tags
Including asset
'components/castelli'
Navigation\Tags
Including asset
'components/porcelanato/produtos/details'
Icecream
Executing query
array ( 'query' => 'SELECT ambiente.id,ambiente.title,ambiente.image,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/ambiente/\', ambiente.image) as img_ambiente_url FROM ambiente WHERE ambiente.date_delete IS NULL ORDER BY ambiente.title ASC ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product.id,product.title,product.slug,product.link_simulation,product.ambiente_img,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/product/\', product.ambiente_img) as img_product_ambiente_url,product.code,product.id_category,product.id_package,product.description FROM product WHERE product.date_delete IS NULL AND slug = :6854d9b8e1597 ', 'params' => array ( ':6854d9b8e1597' => 'butron-imbuia-493', ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_attribute.id,product_attribute.id_attribute,product_attribute.id_product,product_attribute.id_option,CASE WHEN product_attribute.id_option IS NOT NULL THEN attribute_options.title ELSE product_attribute.text END AS text,attribute.title AS attribute_title,attribute.type AS attribute_type,attribute.placement AS attribute_placement,attribute.name,attribute_options.title AS option_title,attribute_options.description AS option_description FROM product_attribute LEFT JOIN (SELECT attribute.id,attribute.title,attribute.type,attribute.filter,attribute.sort,attribute.placement,attribute.name FROM attribute WHERE attribute.date_delete IS NULL ORDER BY attribute.sort ASC ) AS attribute ON attribute.id = product_attribute.id_attribute LEFT JOIN (SELECT attribute_options.id,attribute_options.id_attribute,attribute_options.title,attribute_options.description FROM attribute_options WHERE attribute_options.date_delete IS NULL ORDER BY attribute_options.title ASC ) AS attribute_options ON attribute_options.id = product_attribute.id_option WHERE product_attribute.date_delete IS NULL AND id_product IN (\'493\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_ambiente.id,product_ambiente.id_ambiente,product_ambiente.id_product,ambiente.title,ambiente.image,ambiente.title AS ambiente_title FROM product_ambiente LEFT JOIN (SELECT ambiente.id,ambiente.title,ambiente.image,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/ambiente/\', ambiente.image) as img_ambiente_url FROM ambiente AS ambiente WHERE ambiente.date_delete IS NULL ORDER BY ambiente.title ASC ) AS ambiente ON ambiente.id = product_ambiente.id_ambiente WHERE product_ambiente.date_delete IS NULL AND id_product IN (\'493\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT package.id,package.title FROM package WHERE package.date_delete IS NULL AND id IN (\'29\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT package_specs_values.id,package_specs_values.id_package,package_specs_values.id_spec,package_specs_values.value,package_specs.title FROM package_specs_values LEFT JOIN (SELECT package_specs.id,package_specs.title FROM package_specs WHERE package_specs.date_delete IS NULL ) AS package_specs ON package_specs.id = package_specs_values.id_spec WHERE package_specs_values.date_delete IS NULL AND id_package IN (\'29\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_feature.id,product_feature.id_product,product_feature.id_feature,feature.title,feature.filter,feature.name FROM product_feature JOIN (SELECT feature.id,feature.title,feature.name,feature.filter FROM feature WHERE feature.date_delete IS NULL ) AS feature ON feature.id = product_feature.id_feature WHERE product_feature.date_delete IS NULL AND id_product IN (\'493\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_image.id,product_image.id_product,product_image.image,product_image.thumb,product_image.main,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/product/\', product_image.image) as img_url,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/product/\', product_image.thumb) as img_thumb_url FROM product_image WHERE product_image.date_delete IS NULL AND id_product IN (\'493\') ORDER BY product_image.main DESC ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT package.id,package.title FROM package WHERE package.date_delete IS NULL AND id IN (\'29\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT package_specs_values.id,package_specs_values.id_package,package_specs_values.id_spec,package_specs_values.value,package_specs.title FROM package_specs_values LEFT JOIN (SELECT package_specs.id,package_specs.title FROM package_specs WHERE package_specs.date_delete IS NULL ) AS package_specs ON package_specs.id = package_specs_values.id_spec WHERE package_specs_values.date_delete IS NULL AND id_package IN (\'29\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_attribute.id,product_attribute.id_attribute,product_attribute.id_product,product_attribute.id_option,CASE WHEN product_attribute.id_option IS NOT NULL THEN attribute_options.title ELSE product_attribute.text END AS text,attribute.title AS attribute_title,attribute.type AS attribute_type,attribute.placement AS attribute_placement,attribute.name,attribute_options.title AS option_title,attribute_options.description AS option_description FROM product_attribute LEFT JOIN (SELECT attribute.id,attribute.title,attribute.type,attribute.filter,attribute.sort,attribute.placement,attribute.name FROM attribute WHERE attribute.date_delete IS NULL ORDER BY attribute.sort ASC ) AS attribute ON attribute.id = product_attribute.id_attribute LEFT JOIN (SELECT attribute_options.id,attribute_options.id_attribute,attribute_options.title,attribute_options.description FROM attribute_options WHERE attribute_options.date_delete IS NULL ORDER BY attribute_options.title ASC ) AS attribute_options ON attribute_options.id = product_attribute.id_option WHERE product_attribute.date_delete IS NULL AND id_product IN (\'493\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_feature.id,product_feature.id_product,product_feature.id_feature,feature.title,feature.filter,feature.name FROM product_feature JOIN (SELECT feature.id,feature.title,feature.name,feature.filter FROM feature WHERE feature.date_delete IS NULL ) AS feature ON feature.id = product_feature.id_feature WHERE product_feature.date_delete IS NULL AND id_product IN (\'493\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_ambiente.id,product_ambiente.id_ambiente,product_ambiente.id_product,ambiente.title,ambiente.image,ambiente.title AS ambiente_title FROM product_ambiente LEFT JOIN (SELECT ambiente.id,ambiente.title,ambiente.image,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/ambiente/\', ambiente.image) as img_ambiente_url FROM ambiente AS ambiente WHERE ambiente.date_delete IS NULL ORDER BY ambiente.title ASC ) AS ambiente ON ambiente.id = product_ambiente.id_ambiente WHERE product_ambiente.date_delete IS NULL AND id_product IN (\'493\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT category.id,category.title,category.image FROM category WHERE category.date_delete IS NULL AND id IN (\'\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT product_downloadable.id,product_downloadable.name,product_downloadable.thumb,product_downloadable.id_product,product_ambiente.id_ambiente,product_downloadable.date_update,product_downloadable.file,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/product/\', product_downloadable.file) as file_url,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/product/\', product_downloadable.thumb) as thumb_url,product_downloadable.link,product_downloadable.id_downloadable,downloadable.title,downloadable.type,downloadable.section FROM product_downloadable LEFT JOIN (SELECT downloadable.id,downloadable.title,downloadable.type,downloadable.section FROM downloadable WHERE downloadable.date_delete IS NULL ) AS downloadable ON downloadable.id = product_downloadable.id_downloadable LEFT JOIN (SELECT product_ambiente.id,product_ambiente.id_ambiente,product_ambiente.id_product,ambiente.title,ambiente.image,ambiente.title AS ambiente_title FROM product_ambiente LEFT JOIN (SELECT ambiente.id,ambiente.title,ambiente.image,CONCAT(\'https://grupoembramaco.com.br\',\'/public/images/ambiente/\', ambiente.image) as img_ambiente_url FROM ambiente AS ambiente WHERE ambiente.date_delete IS NULL ORDER BY ambiente.title ASC ) AS ambiente ON ambiente.id = product_ambiente.id_ambiente WHERE product_ambiente.date_delete IS NULL ) AS product_ambiente ON product_ambiente.id_product = product_downloadable.id_product WHERE product_downloadable.date_delete IS NULL AND product_downloadable.id_product IN (\'493\') GROUP BY product_downloadable.id ', 'params' => array ( ), )