<?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 ('abruzzo-gray-lux-plus-425')
/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' => 425, 'title' => 'Abruzzo Gray Lux Plus', 'slug' => 'abruzzo-gray-lux-plus-425', 'link_simulation' => '', 'ambiente_img' => 'e8d8e1f9b4069957cd5844d897f37c6c.jpg', 'img_product_ambiente_url' => 'https://grupoembramaco.com.br/public/images/product/e8d8e1f9b4069957cd5844d897f37c6c.jpg', 'code' => 'P70434', 'id_category' => NULL, 'id_package' => 35, 'description' => NULL, 'attributes' => array ( 0 => array ( 'id' => 492, 'id_attribute' => 20, 'id_product' => 425, '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' => 493, 'id_attribute' => 20, 'id_product' => 425, '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' => 494, 'id_attribute' => 20, 'id_product' => 425, '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' => 495, 'id_attribute' => 22, 'id_product' => 425, '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' => 496, 'id_attribute' => 10, 'id_product' => 425, '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' => 497, 'id_attribute' => 18, 'id_product' => 425, 'id_option' => 94, 'text' => '5', 'attribute_title' => 'Número de Faces', 'attribute_type' => 2, 'attribute_placement' => NULL, 'name' => NULL, 'option_title' => '5', 'option_description' => NULL, ), 6 => array ( 'id' => 498, 'id_attribute' => 19, 'id_product' => 425, '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' => 499, 'id_attribute' => 19, 'id_product' => 425, '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' => 500, 'id_attribute' => 7, 'id_product' => 425, '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' => 501, 'id_attribute' => 17, 'id_product' => 425, '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' => 431, 'id_ambiente' => 9, 'id_product' => 425, 'title' => 'Área Comercial', 'image' => '02f2ee443bffb1d2e6747b8748042865.webp', 'ambiente_title' => 'Área Comercial', ), 1 => array ( 'id' => 432, 'id_ambiente' => 7, 'id_product' => 425, 'title' => 'Banheiro', 'image' => '8a3d9b400b55703c999b5bc1daea3cda.webp', 'ambiente_title' => 'Banheiro', ), 2 => array ( 'id' => 433, 'id_ambiente' => 6, 'id_product' => 425, 'title' => 'Cozinha', 'image' => '56d54e0093b397c5cadc0c9010fd9f2e.webp', 'ambiente_title' => 'Cozinha', ), 3 => array ( 'id' => 434, 'id_ambiente' => 11, 'id_product' => 425, 'title' => 'Quarto', 'image' => '83723e064d4d485a47b9b38c2777b1b5.webp', 'ambiente_title' => 'Quarto', ), 4 => array ( 'id' => 435, 'id_ambiente' => 10, 'id_product' => 425, 'title' => 'Sacada Coberta', 'image' => '1f40181daba52caa745870a9b421d023.webp', 'ambiente_title' => 'Sacada Coberta', ), 5 => array ( 'id' => 436, 'id_ambiente' => 5, 'id_product' => 425, 'title' => 'Sala', 'image' => 'e3bb01ef5567dc6d4469dd7fbc2b2cd6.jpg', 'ambiente_title' => 'Sala', ), ), 'package' => array ( 0 => array ( 'id' => 35, 'title' => '82x82cm', 'specs' => array ( 0 => array ( 'id' => 328, 'id_package' => 35, 'id_spec' => 1, 'value' => '9,0mm', 'title' => 'Espessura', ), 1 => array ( 'id' => 329, 'id_package' => 35, 'id_spec' => 2, 'value' => '32', 'title' => 'Caixas/Pallet', ), 2 => array ( 'id' => 330, 'id_package' => 35, 'id_spec' => 3, 'value' => '46kg', 'title' => 'Peso/Caixa', ), 3 => array ( 'id' => 331, 'id_package' => 35, 'id_spec' => 4, 'value' => '1.472kg', 'title' => 'Peso do Pallet', ), 4 => array ( 'id' => 332, 'id_package' => 35, 'id_spec' => 5, 'value' => '2,02m²', 'title' => 'm²/Caixa', ), 5 => array ( 'id' => 333, 'id_package' => 35, 'id_spec' => 6, 'value' => '2mm', 'title' => 'Junta Mínima', ), 6 => array ( 'id' => 334, 'id_package' => 35, 'id_spec' => 7, 'value' => 'Sim', 'title' => 'Retificado', ), 7 => array ( 'id' => 335, 'id_package' => 35, 'id_spec' => 8, 'value' => '3', 'title' => 'Peças/Caixa', ), 8 => array ( 'id' => 354, 'id_package' => 35, 'id_spec' => 12, 'value' => '64,64', 'title' => 'm²/Pallet', ), ), ), ), 'features' => array ( ), 'images' => array ( 0 => array ( 'id' => 200, 'id_product' => 425, 'image' => '68fb02ccc81077889f7e26486208ab6f.webp', 'thumb' => '68fb02ccc81077889f7e26486208ab6f_th.webp', 'main' => 1, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/68fb02ccc81077889f7e26486208ab6f.webp', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/68fb02ccc81077889f7e26486208ab6f_th.webp', ), 1 => array ( 'id' => 201, 'id_product' => 425, 'image' => '625322a39df936c59c94a3c1e4b56613.webp', 'thumb' => '625322a39df936c59c94a3c1e4b56613_th.webp', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/625322a39df936c59c94a3c1e4b56613.webp', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/625322a39df936c59c94a3c1e4b56613_th.webp', ), 2 => array ( 'id' => 202, 'id_product' => 425, 'image' => '698d0bdcec42de87fd6470b12d88565a.webp', 'thumb' => '698d0bdcec42de87fd6470b12d88565a_th.webp', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/698d0bdcec42de87fd6470b12d88565a.webp', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/698d0bdcec42de87fd6470b12d88565a_th.webp', ), 3 => array ( 'id' => 203, 'id_product' => 425, 'image' => '624a442dfc1cdf605dd56ea12213eb26.webp', 'thumb' => '624a442dfc1cdf605dd56ea12213eb26_th.webp', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/624a442dfc1cdf605dd56ea12213eb26.webp', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/624a442dfc1cdf605dd56ea12213eb26_th.webp', ), 4 => array ( 'id' => 204, 'id_product' => 425, 'image' => '1a0a95631395b860f323ecd5eddf2530.webp', 'thumb' => '1a0a95631395b860f323ecd5eddf2530_th.webp', 'main' => 0, 'img_url' => 'https://grupoembramaco.com.br/public/images/product/1a0a95631395b860f323ecd5eddf2530.webp', 'img_thumb_url' => 'https://grupoembramaco.com.br/public/images/product/1a0a95631395b860f323ecd5eddf2530_th.webp', ), ), '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 (\'425\') 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/abruzzo-gray-lux-plus-425'
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 = :6854dbdc8350c ', 'params' => array ( ':6854dbdc8350c' => 'abruzzo-gray-lux-plus-425', ), )
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 (\'425\') ', '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 (\'425\') ', 'params' => array ( ), )
Icecream
Executing query
array ( 'query' => 'SELECT package.id,package.title FROM package WHERE package.date_delete IS NULL AND id IN (\'35\') ', '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 (\'35\') ', '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 (\'425\') ', '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 (\'425\') 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 (\'35\') ', '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 (\'35\') ', '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 (\'425\') ', '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 (\'425\') ', '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 (\'425\') ', '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 (\'425\') GROUP BY product_downloadable.id ', 'params' => array ( ), )