<?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 ('gran-harlech-lux-436')
/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' => 436, 'title' => 'Gran Harlech Lux', 'slug' => 'gran-harlech-lux-436', 'link_simulation' => '', 'ambiente_img' => '0909a2467b9bd39ad09520a3fbae2c3d.jpg', 'img_product_ambiente_url' => 'https://grupoembramaco.com.br/public/images/product/0909a2467b9bd39ad09520a3fbae2c3d.jpg', 'code' => 'P70658', 'id_category' => NULL, 'id_package' => 33, 'description' => NULL, 'attributes' => array ( 0 => array ( 'id' => 599, 'id_attribute' => 20, 'id_product' => 436, 'id_option' => 107, 'text' => 'Cozinha', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Cozinha', 'option_description' => NULL, ), 1 => array ( 'id' => 600, 'id_attribute' => 20, 'id_product' => 436, 'id_option' => 104, 'text' => 'Quarto', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Quarto', 'option_description' => NULL, ), 2 => array ( 'id' => 601, 'id_attribute' => 20, 'id_product' => 436, 'id_option' => 106, 'text' => 'Salas', 'attribute_title' => 'Ambiente ', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Salas', 'option_description' => NULL, ), 3 => array ( 'id' => 602, 'id_attribute' => 22, 'id_product' => 436, 'id_option' => 113, 'text' => 'Marmi', 'attribute_title' => 'Linha', 'attribute_type' => 2, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Marmi', 'option_description' => NULL, ), 4 => array ( 'id' => 603, 'id_attribute' => 10, 'id_product' => 436, 'id_option' => 84, 'text' => 'LC - Média Tráfego', 'attribute_title' => 'Local de Uso ', 'attribute_type' => 3, 'attribute_placement' => 1, 'name' => NULL, 'option_title' => 'LC - Média Tráfego', 'option_description' => NULL, ), 5 => array ( 'id' => 604, 'id_attribute' => 18, 'id_product' => 436, 'id_option' => 120, 'text' => '8', 'attribute_title' => 'Número de Faces', 'attribute_type' => 2, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => '8', 'option_description' => NULL, ), 6 => array ( 'id' => 605, 'id_attribute' => 19, 'id_product' => 436, 'id_option' => 100, 'text' => 'Parede', 'attribute_title' => 'Piso ou Parede', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Parede', 'option_description' => NULL, ), 7 => array ( 'id' => 606, 'id_attribute' => 19, 'id_product' => 436, 'id_option' => 99, 'text' => 'Piso', 'attribute_title' => 'Piso ou Parede', 'attribute_type' => 3, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'Piso', 'option_description' => NULL, ), 8 => array ( 'id' => 607, 'id_attribute' => 7, 'id_product' => 436, 'id_option' => 78, 'text' => 'Polido', 'attribute_title' => 'Tipologia', 'attribute_type' => 3, 'attribute_placement' => 1, 'name' => NULL, 'option_title' => 'Polido', 'option_description' => NULL, ), 9 => array ( 'id' => 608, 'id_attribute' => 17, 'id_product' => 436, 'id_option' => 87, 'text' => 'V2', 'attribute_title' => 'Variação de Tonalidade', 'attribute_type' => 2, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => 'V2', 'option_description' => NULL, ), ), 'ambientes' => array ( 0 => array ( 'id' => 383, 'id_ambiente' => 9, 'id_product' => 436, 'title' => 'Área Comercial', 'image' => '02f2ee443bffb1d2e6747b8748042865.webp', 'ambiente_title' => 'Área Comercial', ), 1 => array ( 'id' => 384, 'id_ambiente' => 7, 'id_product' => 436, 'title' => 'Banheiro', 'image' => '8a3d9b400b55703c999b5bc1daea3cda.webp', 'ambiente_title' => 'Banheiro', ), 2 => array ( 'id' => 385, 'id_ambiente' => 6, 'id_product' => 436, 'title' => 'Cozinha', 'image' => '56d54e0093b397c5cadc0c9010fd9f2e.webp', 'ambiente_title' => 'Cozinha', ), 3 => array ( 'id' => 386, 'id_ambiente' => 11, 'id_product' => 436, 'title' => 'Quarto', 'image' => '83723e064d4d485a47b9b38c2777b1b5.webp', 'ambiente_title' => 'Quarto', ), 4 => array ( 'id' => 387, 'id_ambiente' => 10, 'id_product' => 436, 'title' => 'Sacada Coberta', 'image' => '1f40181daba52caa745870a9b421d023.webp', 'ambiente_title' => 'Sacada Coberta', ), 5 => array ( 'id' => 388, 'id_ambiente' => 5, 'id_product' => 436, 'title' => 'Sala', 'image' => 'e3bb01ef5567dc6d4469dd7fbc2b2cd6.jpg', 'ambiente_title' => 'Sala', ), ), 'package' => array ( 0 => array ( 'id' => 33, 'title' => '62x121cm', 'specs' => array ( 0 => array ( 'id' => 312, 'id_package' => 33, 'id_spec' => 1, 'value' => '9,0mm', 'title' => 'Espessura', ), 1 => array ( 'id' => 313, 'id_package' => 33, 'id_spec' => 2, 'value' => '28', 'title' => 'Caixas/Pallet', ), 2 => array ( 'id' => 314, 'id_package' => 33, 'id_spec' => 3, 'value' => '48kg', 'title' => 'Peso/Caixa', ), 3 => array ( 'id' => 315, 'id_package' => 33, 'id_spec' => 4, 'value' => '1.344kg', 'title' => 'Peso do Pallet', ), 4 => array ( 'id' => 316, 'id_package' => 33, 'id_spec' => 5, 'value' => '2,26m²', 'title' => 'm²/Caixa', ), 5 => array ( 'id' => 317, 'id_package' => 33, 'id_spec' => 6, 'value' => '2mm', 'title' => 'Junta Mínima', ), 6 => array ( 'id' => 318, 'id_package' => 33, 'id_spec' => 7, 'value' => 'Sim', 'title' => 'Retificado', ), 7 => array ( 'id' => 319, 'id_package' => 33, 'id_spec' => 8, 'value' => '3', 'title' => 'Peças/Caixa', ), 8 => array ( 'id' => 352, 'id_package' => 33, 'id_spec' => 12, 'value' => '63,28', 'title' => 'm²/Pallet', ), ), ), ), 'features' => array ( ), 'images' => array ( 0 => array ( 'id' => 250, 'id_product' => 436, 'image' => '38eb8c9c747239f94dc51e4c016cb352.jpg', 'thumb' => '38eb8c9c747239f94dc51e4c016cb352_th.jpg', 'main' => 1, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/38eb8c9c747239f94dc51e4c016cb352.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/38eb8c9c747239f94dc51e4c016cb352_th.jpg', ), 1 => array ( 'id' => 251, 'id_product' => 436, 'image' => '08c0bf95f129f071fbb0cf6feb9e526f.jpg', 'thumb' => '08c0bf95f129f071fbb0cf6feb9e526f_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/08c0bf95f129f071fbb0cf6feb9e526f.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/08c0bf95f129f071fbb0cf6feb9e526f_th.jpg', ), 2 => array ( 'id' => 252, 'id_product' => 436, 'image' => '97dfc0e302a02051f18f00958fbc9c14.jpg', 'thumb' => '97dfc0e302a02051f18f00958fbc9c14_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/97dfc0e302a02051f18f00958fbc9c14.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/97dfc0e302a02051f18f00958fbc9c14_th.jpg', ), 3 => array ( 'id' => 253, 'id_product' => 436, 'image' => '7b788e8d232ac82cafd0ddf86ee20d45.jpg', 'thumb' => '7b788e8d232ac82cafd0ddf86ee20d45_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/7b788e8d232ac82cafd0ddf86ee20d45.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/7b788e8d232ac82cafd0ddf86ee20d45_th.jpg', ), 4 => array ( 'id' => 254, 'id_product' => 436, 'image' => '1cc9f23e2890bf16c6860c5c6a2a59bc.jpg', 'thumb' => '1cc9f23e2890bf16c6860c5c6a2a59bc_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/1cc9f23e2890bf16c6860c5c6a2a59bc.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/1cc9f23e2890bf16c6860c5c6a2a59bc_th.jpg', ), 5 => array ( 'id' => 255, 'id_product' => 436, 'image' => 'f9ecd4339982260cfb1d3b823226f6d2.jpg', 'thumb' => 'f9ecd4339982260cfb1d3b823226f6d2_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/f9ecd4339982260cfb1d3b823226f6d2.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/f9ecd4339982260cfb1d3b823226f6d2_th.jpg', ), 6 => array ( 'id' => 256, 'id_product' => 436, 'image' => '3d47de5ce63c764f1407230a95f7b241.jpg', 'thumb' => '3d47de5ce63c764f1407230a95f7b241_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/3d47de5ce63c764f1407230a95f7b241.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/3d47de5ce63c764f1407230a95f7b241_th.jpg', ), 7 => array ( 'id' => 257, 'id_product' => 436, 'image' => 'd9d610a25c16446068908ab36902b43d.jpg', 'thumb' => 'd9d610a25c16446068908ab36902b43d_th.jpg', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/d9d610a25c16446068908ab36902b43d.jpg', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/d9d610a25c16446068908ab36902b43d_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 (\'436\') 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/gran-harlech-lux-436'
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 = :6854d216dccae ', 'params' => array ( ':6854d216dccae' => 'gran-harlech-lux-436', ), )
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 (\'436\') ', '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 (\'436\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT package.id,package.title FROM package WHERE package.date_delete IS NULL AND id IN (\'33\') ', '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 (\'33\') ', '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 (\'436\') ', '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 (\'436\') 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 (\'33\') ', '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 (\'33\') ', '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 (\'436\') ', '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 (\'436\') ', '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 (\'436\') ', '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 (\'436\') GROUP BY product_downloadable.id ', 'params' => array ( ), )