Рулонные шторы COMBO
По вашему запросу продуктов не найдено
Ссылка: /catalog/jaluzi/category/rulonnyie_shtoryi/country/kitaye/sort/price/color/raznyie/, Trace
array(10) { [0] => array(4) { ["function"] => string(8) "msgError" ["class"] => string(26) "Flexy_View_Helper_MsgError" ["type"] => string(2) "->" ["args"] => array(1) { [0] => &string(54) "По вашему запросу продуктов не найдено" } } [1] => array(4) { ["file"] => string(80) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Zend/View/Abstract.php" ["line"] => int(350) ["function"] => string(20) "call_user_func_array" ["args"] => array(2) { [0] => &array(2) { [0] => object(Flexy_View_Helper_MsgError)#77 (3) { ["_translator":protected] => NULL ["_closingBracket":protected] => NULL ["view"] => object(Flexy_View)#13 (27) { ["topTree"] => array(1) { ["Рулонные шторы COMBO"] => string(0) "" } ["topMenu"] => array(0) { } ["bodyTitle"] => string(72) "Рулонные шторы COMBO" ["bodyNotes"] => string(0) "" ["thisLink"] => string(83) "/catalog/jaluzi/category/rulonnyie_shtoryi/country/kitaye/sort/price/color/raznyie/" ["bodyComplate"] => bool(false) ["tplMain"] => string(8) "main.php" ["tplBody"] => string(8) "body.php" ["glb"] => NULL ["db"] => NULL ["_useViewStream":"Zend_View":private] => bool(false) ["_useStreamWrapper":"Zend_View":private] => bool(false) ["_path":"Zend_View_Abstract":private] => array(3) { ["script"] => array(2) { [0] => string(64) "/home/combo/domains/combo.uz/public_html/FlexyDir/views/catalog/" [1] => string(84) "/home/combo/domains/combo.uz/public_html/FlexyDir/application/default/views/catalog/" } ["helper"] => array(0) { } ["filter"] => array(0) { } } ["_file":"Zend_View_Abstract":private] => NULL ["_helper":"Zend_View_Abstract":private] => array(1) { ["MsgError"] => *RECURSION* } ["_helperLoaded":"Zend_View_Abstract":private] => array(0) { } ["_helperLoadedDir":"Zend_View_Abstract":private] => array(0) { } ["_filter":"Zend_View_Abstract":private] => array(0) { } ["_filterClass":"Zend_View_Abstract":private] => array(0) { } ["_filterLoaded":"Zend_View_Abstract":private] => array(0) { } ["_filterLoadedDir":"Zend_View_Abstract":private] => array(0) { } ["_escape":"Zend_View_Abstract":private] => string(16) "htmlspecialchars" ["_encoding":"Zend_View_Abstract":private] => string(5) "UTF-8" ["_lfiProtectionOn":"Zend_View_Abstract":private] => bool(true) ["_loaders":"Zend_View_Abstract":private] => array(1) { ["helper"] => object(Zend_Loader_PluginLoader)#15 (4) { ["_loadedPluginPaths":protected] => array(0) { } ["_loadedPlugins":protected] => array(1) { ["MsgError"] => string(26) "Flexy_View_Helper_MsgError" } ["_prefixToPaths":protected] => array(2) { ["Zend_View_Helper_"] => array(2) { [0] => string(17) "Zend/View/Helper/" [1] => string(75) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Zend/View/Helper/" } ["Flexy_View_Helper_"] => array(1) { [0] => string(76) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Flexy/View/Helper/" } } ["_useStaticRegistry":protected] => NULL } } ["_loaderTypes":"Zend_View_Abstract":private] => array(2) { [0] => string(6) "filter" [1] => string(6) "helper" } ["_strictVars":"Zend_View_Abstract":private] => bool(false) } } [1] => string(8) "msgError" } [1] => &array(1) { [0] => string(54) "По вашему запросу продуктов не найдено" } } } [2] => array(6) { ["file"] => string(75) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Flexy/Catalog.php" ["line"] => int(840) ["function"] => string(6) "__call" ["class"] => string(18) "Zend_View_Abstract" ["type"] => string(2) "->" ["args"] => array(2) { [0] => &string(8) "msgError" [1] => &array(1) { [0] => string(54) "По вашему запросу продуктов не найдено" } } } [3] => array(6) { ["file"] => string(75) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Flexy/Catalog.php" ["line"] => int(840) ["function"] => string(8) "msgError" ["class"] => string(10) "Flexy_View" ["type"] => string(2) "->" ["args"] => array(1) { [0] => &string(54) "По вашему запросу продуктов не найдено" } } [4] => array(6) { ["file"] => string(103) "/home/combo/domains/combo.uz/public_html/FlexyDir/application/default/controllers/CatalogController.php" ["line"] => int(61) ["function"] => string(7) "catalog" ["class"] => string(13) "Flexy_Catalog" ["type"] => string(2) "->" ["args"] => array(4) { [0] => &array(7) { ["controller"] => string(7) "catalog" ["action"] => string(6) "jaluzi" ["category"] => string(17) "rulonnyie_shtoryi" ["country"] => string(6) "kitaye" ["sort"] => string(5) "price" ["color"] => string(7) "raznyie" ["module"] => string(7) "default" } [1] => &string(6) "jaluzi" [2] => &array(3) { ["price"] => string(52) "по цене" ["-id"] => string(74) "по дате поступления" ["title"] => string(65) "по наименованию" } [3] => &array(1) { ["select"] => object(Flexy_Db_Select)#39 (4) { ["_bind":protected] => array(0) { } ["_adapter":protected] => object(Flexy_Db_Adapter_Pdo_Mysql)#4 (13) { ["_prefix"] => string(3) "co_" ["_pdoType":protected] => string(5) "mysql" ["_numericDataTypes":protected] => array(16) { [0] => int(0) [1] => int(1) [2] => int(2) ["INT"] => int(0) ["INTEGER"] => int(0) ["MEDIUMINT"] => int(0) ["SMALLINT"] => int(0) ["TINYINT"] => int(0) ["BIGINT"] => int(1) ["SERIAL"] => int(1) ["DEC"] => int(2) ["DECIMAL"] => int(2) ["DOUBLE"] => int(2) ["DOUBLE PRECISION"] => int(2) ["FIXED"] => int(2) ["FLOAT"] => int(2) } ["_defaultStmtClass":protected] => string(21) "Zend_Db_Statement_Pdo" ["_config":protected] => array(8) { ["host"] => string(9) "localhost" ["username"] => string(10) "combo_site" ["password"] => string(20) "sGEMageHkdzq8br8Vatd" ["dbname"] => string(10) "combo_site" ["charset"] => NULL ["persistent"] => bool(false) ["options"] => array(3) { ["caseFolding"] => int(0) ["autoQuoteIdentifiers"] => bool(true) ["fetchMode"] => int(2) } ["driver_options"] => array(0) { } } ["_fetchMode":protected] => int(2) ["_profiler":protected] => object(Zend_Db_Profiler)#3 (4) { ["_queryProfiles":protected] => array(41) { [0] => object(Zend_Db_Profiler_Query)#5 (5) { ["_query":protected] => string(7) "connect" ["_queryType":protected] => int(1) ["_startedMicrotime":protected] => float(1713495825.1225) ["_endedMicrotime":protected] => float(1713495825.1228) ["_boundParams":protected] => array(0) { } } [1] => object(Zend_Db_Profiler_Query)#9 (5) { ["_query":protected] => string(16) "SET NAMES `UTF8`" ["_queryType":protected] => int(2) ["_startedMicrotime":protected] => float(1713495825.1229) ["_endedMicrotime":protected] => float(1713495825.1229) ["_boundParams":protected] => array(0) { } } [2] => object(Zend_Db_Profiler_Query)#10 (5) { ["_query":protected] => string(66) "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));" ["_queryType":protected] => int(2) ["_startedMicrotime":protected] => float(1713495825.123) ["_endedMicrotime":protected] => float(1713495825.1231) ["_boundParams":protected] => array(0) { } } [3] => object(Zend_Db_Profiler_Query)#16 (5) { ["_query":protected] => string(77) "SELECT `co_struct`.* FROM `co_struct` WHERE (tree_level = 0) AND (status > 0)" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1246) ["_endedMicrotime":protected] => float(1713495825.125) ["_boundParams":protected] => array(0) { } } [4] => object(Zend_Db_Profiler_Query)#17 (5) { ["_query":protected] => string(146) "SELECT `co_struct`.* FROM `co_struct` WHERE (tree_level = 1) AND (var_name = 'catalog') AND (status > 0) AND (tree_left > 1) AND (tree_right < 38)" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1251) ["_endedMicrotime":protected] => float(1713495825.1253) ["_boundParams":protected] => array(0) { } } [5] => object(Zend_Db_Profiler_Query)#19 (5) { ["_query":protected] => string(56) "SELECT `co_struct`.* FROM `co_struct` WHERE (id IN (11))" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.128) ["_endedMicrotime":protected] => float(1713495825.1283) ["_boundParams":protected] => array(0) { } } [6] => object(Zend_Db_Profiler_Query)#20 (5) { ["_query":protected] => string(124) "SELECT `co_flexy_value`.`join_id`, `co_flexy_value`.`array` FROM `co_flexy_value` WHERE (table_id = 3) AND (join_id IN (11))" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1284) ["_endedMicrotime":protected] => float(1713495825.1285) ["_boundParams":protected] => array(0) { } } [7] => object(Zend_Db_Profiler_Query)#21 (5) { ["_query":protected] => string(395) "SELECT `s`.`id`, `sv`.`target`, `sv`.`var_name`, `sv`.`value`, `sv`.`is_only` FROM `co_struct` AS `s` INNER JOIN `co_struct_vars` AS `sv` WHERE (s.id = sv.struct_id) AND (s.tree_left <= 1) AND (s.tree_right >= 38) AND (s.status > 0) AND (sv.status > 0) AND ((sv.is_only = "") OR (sv.is_only="childs" AND sv.struct_id!=11) OR (sv.is_only="self" AND sv.struct_id=11)) ORDER BY `s`.`tree_left` ASC" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.129) ["_endedMicrotime":protected] => float(1713495825.1293) ["_boundParams":protected] => array(0) { } } [8] => object(Zend_Db_Profiler_Query)#24 (5) { ["_query":protected] => string(55) "SELECT `co_struct`.* FROM `co_struct` WHERE (id = '11')" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.131) ["_endedMicrotime":protected] => float(1713495825.1312) ["_boundParams":protected] => array(0) { } } [9] => object(Zend_Db_Profiler_Query)#26 (5) { ["_query":protected] => string(58) "SELECT `co_struct`.* FROM `co_struct` WHERE (id IN ('11'))" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1318) ["_endedMicrotime":protected] => float(1713495825.132) ["_boundParams":protected] => array(0) { } } [10] => object(Zend_Db_Profiler_Query)#27 (5) { ["_query":protected] => string(126) "SELECT `co_flexy_value`.`join_id`, `co_flexy_value`.`array` FROM `co_flexy_value` WHERE (table_id = 3) AND (join_id IN ('11'))" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1321) ["_endedMicrotime":protected] => float(1713495825.1322) ["_boundParams":protected] => array(0) { } } [11] => object(Zend_Db_Profiler_Query)#44 (5) { ["_query":protected] => string(80) "SELECT `co_catalog_type`.`id` FROM `co_catalog_type` WHERE (var_name = 'jaluzi')" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1446) ["_endedMicrotime":protected] => float(1713495825.1452) ["_boundParams":protected] => array(0) { } } [12] => object(Zend_Db_Profiler_Query)#47 (5) { ["_query":protected] => string(64) "SELECT `co_catalog_type`.* FROM `co_catalog_type` WHERE (id = 1)" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1458) ["_endedMicrotime":protected] => float(1713495825.146) ["_boundParams":protected] => array(0) { } } [13] => object(Zend_Db_Profiler_Query)#48 (5) { ["_query":protected] => string(209) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (var_name IN ('controller', 'action', 'category', 'country', 'sort', 'color', 'module', 'show')) AND (type IN ("select","tree")) ORDER BY `tree_left` ASC" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1461) ["_endedMicrotime":protected] => float(1713495825.1465) ["_boundParams":protected] => array(0) { } } [14] => object(Zend_Db_Profiler_Query)#49 (5) { ["_query":protected] => string(90) "SELECT `co_catalog_attr_list`.* FROM `co_catalog_attr_list` WHERE (id=24) AND (status="1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1475) ["_endedMicrotime":protected] => float(1713495825.1477) ["_boundParams":protected] => array(0) { } } [15] => object(Zend_Db_Profiler_Query)#51 (5) { ["_query":protected] => string(90) "SELECT `co_catalog_attr_list`.* FROM `co_catalog_attr_list` WHERE (id=24) AND (status="1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1478) ["_endedMicrotime":protected] => float(1713495825.1479) ["_boundParams":protected] => array(0) { } } [16] => object(Zend_Db_Profiler_Query)#52 (5) { ["_query":protected] => string(162) "SELECT `co_catalog_attr`.`id`, `co_catalog_attr`.`fast_db_suffix`, `co_catalog_attr`.`var_name` FROM `co_catalog_attr` WHERE (status = "1") AND (id = '3') LIMIT 1" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.148) ["_endedMicrotime":protected] => float(1713495825.1481) ["_boundParams":protected] => array(0) { } } [17] => object(Zend_Db_Profiler_Query)#53 (5) { ["_query":protected] => string(119) "SELECT `t`.* FROM `co_catalog_type` AS `t` INNER JOIN `co_catalog_attr` AS `p` WHERE (p.id = 3) AND (p.type_id = t.id)" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1482) ["_endedMicrotime":protected] => float(1713495825.1483) ["_boundParams":protected] => array(0) { } } [18] => object(Zend_Db_Profiler_Query)#54 (5) { ["_query":protected] => string(185) "SELECT `co_catalog_attr_list`.* FROM `co_catalog_attr_list` WHERE (attr_id = 3) AND (tree_left < 2) AND (tree_right > 3) AND (status = "1") AND (tree_level > 0) ORDER BY `tree_left` ASC" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1484) ["_endedMicrotime":protected] => float(1713495825.1486) ["_boundParams":protected] => array(0) { } } [19] => object(Zend_Db_Profiler_Query)#50 (5) { ["_query":protected] => string(158) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'controller') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1487) ["_endedMicrotime":protected] => float(1713495825.149) ["_boundParams":protected] => array(0) { } } [20] => object(Zend_Db_Profiler_Query)#55 (5) { ["_query":protected] => string(154) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'action') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1491) ["_endedMicrotime":protected] => float(1713495825.1492) ["_boundParams":protected] => array(0) { } } [21] => object(Zend_Db_Profiler_Query)#56 (5) { ["_query":protected] => string(156) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'category') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1493) ["_endedMicrotime":protected] => float(1713495825.1495) ["_boundParams":protected] => array(0) { } } [22] => object(Zend_Db_Profiler_Query)#58 (5) { ["_query":protected] => string(75) "SELECT `co_catalog_attr_list`.* FROM `co_catalog_attr_list` WHERE (id = 24)" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1497) ["_endedMicrotime":protected] => float(1713495825.1499) ["_boundParams":protected] => array(0) { } } [23] => object(Zend_Db_Profiler_Query)#59 (5) { ["_query":protected] => string(182) "SELECT `co_catalog_attr_list`.`id`, `co_catalog_attr_list`.`title` FROM `co_catalog_attr_list` WHERE (attr_id = '3') AND (status = "1") AND (tree_left >= '2') AND (tree_right <= '3')" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.15) ["_endedMicrotime":protected] => float(1713495825.1501) ["_boundParams":protected] => array(0) { } } [24] => object(Zend_Db_Profiler_Query)#60 (5) { ["_query":protected] => string(155) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'country') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1502) ["_endedMicrotime":protected] => float(1713495825.1504) ["_boundParams":protected] => array(0) { } } [25] => object(Zend_Db_Profiler_Query)#61 (5) { ["_query":protected] => string(76) "SELECT `co_catalog_attr_list`.* FROM `co_catalog_attr_list` WHERE (id = 116)" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1507) ["_endedMicrotime":protected] => float(1713495825.1508) ["_boundParams":protected] => array(0) { } } [26] => object(Zend_Db_Profiler_Query)#62 (5) { ["_query":protected] => string(183) "SELECT `co_catalog_attr_list`.`id`, `co_catalog_attr_list`.`title` FROM `co_catalog_attr_list` WHERE (attr_id = '22') AND (status = "1") AND (tree_left >= '2') AND (tree_right <= '3')" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1509) ["_endedMicrotime":protected] => float(1713495825.151) ["_boundParams":protected] => array(0) { } } [27] => object(Zend_Db_Profiler_Query)#63 (5) { ["_query":protected] => string(152) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'sort') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1512) ["_endedMicrotime":protected] => float(1713495825.1513) ["_boundParams":protected] => array(0) { } } [28] => object(Zend_Db_Profiler_Query)#64 (5) { ["_query":protected] => string(153) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'color') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1515) ["_endedMicrotime":protected] => float(1713495825.1516) ["_boundParams":protected] => array(0) { } } [29] => object(Zend_Db_Profiler_Query)#65 (5) { ["_query":protected] => string(75) "SELECT `co_catalog_attr_list`.* FROM `co_catalog_attr_list` WHERE (id = 80)" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1521) ["_endedMicrotime":protected] => float(1713495825.1522) ["_boundParams":protected] => array(0) { } } [30] => object(Zend_Db_Profiler_Query)#66 (5) { ["_query":protected] => string(185) "SELECT `co_catalog_attr_list`.`id`, `co_catalog_attr_list`.`title` FROM `co_catalog_attr_list` WHERE (attr_id = '14') AND (status = "1") AND (tree_left >= '26') AND (tree_right <= '27')" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1523) ["_endedMicrotime":protected] => float(1713495825.1525) ["_boundParams":protected] => array(0) { } } [31] => object(Zend_Db_Profiler_Query)#67 (5) { ["_query":protected] => string(154) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'module') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1526) ["_endedMicrotime":protected] => float(1713495825.1527) ["_boundParams":protected] => array(0) { } } [32] => object(Zend_Db_Profiler_Query)#68 (5) { ["_query":protected] => string(152) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (var_name = 'show') AND (fast_db_suffix != "") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1528) ["_endedMicrotime":protected] => float(1713495825.1529) ["_boundParams":protected] => array(0) { } } [33] => object(Zend_Db_Profiler_Query)#71 (5) { ["_query":protected] => string(863) "SELECT `op`.`attr_id` AS `other_attr_id`, COUNT(op.join_id) AS `cnt`, `vl_3`.`list_id` AS `value_3`, `vl_22`.`list_id` AS `value_22`, `vl_14`.`list_id` AS `value_14` FROM `co_catalog` AS `g` INNER JOIN `co_catalog_value_list` AS `op` INNER JOIN `co_catalog_attr` AS `p` INNER JOIN `co_catalog_value_list` AS `vl_3` INNER JOIN `co_catalog_value_list` AS `vl_22` INNER JOIN `co_catalog_value_list` AS `vl_14` WHERE (g.type_id=0 OR g.type_id = 1) AND (g.id = op.join_id) AND (g.status = "1") AND (p.id = op.attr_id) AND (vl_3.join_id = op.join_id) AND (vl_3.attr_id = 3) AND (vl_3.list_id = "24") AND (vl_22.join_id = op.join_id) AND (vl_22.attr_id = 22) AND (vl_22.list_id = "116") AND (vl_14.join_id = op.join_id) AND (vl_14.attr_id = 14) AND (vl_14.list_id = "80") AND (!FIND_IN_SET(op.attr_id,"3,22,14")) GROUP BY `op`.`attr_id` ORDER BY `p`.`tree_left` ASC" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1536) ["_endedMicrotime":protected] => float(1713495825.1555) ["_boundParams":protected] => array(0) { } } [34] => object(Zend_Db_Profiler_Query)#73 (5) { ["_query":protected] => string(238) "SELECT `co_catalog_attr`.`id`, `co_catalog_attr`.`title`, `co_catalog_attr`.`var_name`, `co_catalog_attr`.`type`, `co_catalog_attr`.`attr` FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (FIND_IN_SET(id,"")) AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1556) ["_endedMicrotime":protected] => float(1713495825.1558) ["_boundParams":protected] => array(0) { } } [35] => object(Zend_Db_Profiler_Query)#76 (5) { ["_query":protected] => string(854) "SELECT `op`.`attr_id` AS `other_attr_id`, COUNT(op.join_id) AS `cnt`, vl_3.list_id AS `value_3`, vl_22.list_id AS `value_22`, vl_14.list_id AS `value_14` FROM `co_catalog` AS `g` INNER JOIN `co_catalog_value_list` AS `op` INNER JOIN `co_catalog_attr` AS `p` INNER JOIN `co_catalog_value_list` AS `vl_3` INNER JOIN `co_catalog_value_list` AS `vl_22` INNER JOIN `co_catalog_value_list` AS `vl_14` WHERE (g.type_id=0 OR g.type_id = 1) AND (g.id = op.join_id) AND (g.status = "1") AND (p.id = op.attr_id) AND (vl_3.join_id = op.join_id) AND (vl_3.attr_id = 3) AND (vl_3.list_id = "24") AND (vl_22.join_id = op.join_id) AND (vl_22.attr_id = 22) AND (vl_22.list_id = "116") AND (vl_14.join_id = op.join_id) AND (vl_14.attr_id = 14) AND (vl_14.list_id = "80") AND (!FIND_IN_SET(op.attr_id,"3,22,14")) GROUP BY `op`.`attr_id` ORDER BY `p`.`tree_left` ASC" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1561) ["_endedMicrotime":protected] => float(1713495825.1579) ["_boundParams":protected] => array(0) { } } [36] => object(Zend_Db_Profiler_Query)#78 (5) { ["_query":protected] => string(238) "SELECT `co_catalog_attr`.`id`, `co_catalog_attr`.`title`, `co_catalog_attr`.`var_name`, `co_catalog_attr`.`type`, `co_catalog_attr`.`attr` FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (FIND_IN_SET(id,"")) AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.158) ["_endedMicrotime":protected] => float(1713495825.1582) ["_boundParams":protected] => array(0) { } } [37] => object(Zend_Db_Profiler_Query)#57 (5) { ["_query":protected] => string(153) "SELECT `co_catalog_attr`.`id` FROM `co_catalog_attr` WHERE (type_id=0 OR type_id = 1) AND (type = "number") AND (var_name = "special") AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1584) ["_endedMicrotime":protected] => float(1713495825.1586) ["_boundParams":protected] => array(0) { } } [38] => object(Zend_Db_Profiler_Query)#46 (5) { ["_query":protected] => string(95) "SELECT `co_catalog_attr`.* FROM `co_catalog_attr` WHERE (var_name = 'price') AND (status = "1")" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1587) ["_endedMicrotime":protected] => float(1713495825.1588) ["_boundParams":protected] => array(0) { } } [39] => object(Zend_Db_Profiler_Query)#80 (5) { ["_query":protected] => string(636) "SELECT SQL_CALC_FOUND_ROWS g.*, `vl_3`.`list_id` AS `value_3`, `vl_22`.`list_id` AS `value_22`, `vl_14`.`list_id` AS `value_14` FROM `co_catalog` AS `g` INNER JOIN `co_catalog_value_list` AS `vl_3` INNER JOIN `co_catalog_value_list` AS `vl_22` INNER JOIN `co_catalog_value_list` AS `vl_14` WHERE (g.status = "1") AND (g.type_id=0 OR g.type_id = 1) AND (vl_3.join_id = g.id) AND (vl_3.attr_id = 3) AND (vl_3.list_id = "24") AND (vl_22.join_id = g.id) AND (vl_22.attr_id = 22) AND (vl_22.list_id = "116") AND (vl_14.join_id = g.id) AND (vl_14.attr_id = 14) AND (vl_14.list_id = "80") GROUP BY `g`.`id` ORDER BY `g`.`price` ASC LIMIT 12" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1592) ["_endedMicrotime":protected] => float(1713495825.1615) ["_boundParams":protected] => array(0) { } } [40] => object(Zend_Db_Profiler_Query)#81 (5) { ["_query":protected] => string(19) "SELECT FOUND_ROWS()" ["_queryType":protected] => int(32) ["_startedMicrotime":protected] => float(1713495825.1616) ["_endedMicrotime":protected] => float(1713495825.1617) ["_boundParams":protected] => array(0) { } } } ["_enabled":protected] => bool(true) ["_filterElapsedSecs":protected] => NULL ["_filterTypes":protected] => NULL } ["_defaultProfilerClass":protected] => string(16) "Zend_Db_Profiler" ["_connection":protected] => object(PDO)#6 (0) { } ["_caseFolding":protected] => int(0) ["_autoQuoteIdentifiers":protected] => bool(true) ["_allowSerialization":protected] => bool(true) ["_autoReconnectOnUnserialize":protected] => bool(false) } ["_parts":protected] => array(11) { ["distinct"] => bool(false) ["columns"] => array(0) { } ["union"] => array(0) { } ["from"] => array(0) { } ["where"] => array(0) { } ["group"] => array(0) { } ["having"] => array(0) { } ["order"] => array(0) { } ["limitcount"] => NULL ["limitoffset"] => NULL ["forupdate"] => bool(false) } ["_tableCols":protected] => array(0) { } } } } } [5] => array(6) { ["file"] => string(84) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Zend/Controller/Action.php" ["line"] => int(518) ["function"] => string(6) "__call" ["class"] => string(17) "CatalogController" ["type"] => string(2) "->" ["args"] => array(2) { [0] => &string(12) "jaluziAction" [1] => &array(0) { } } } [6] => array(6) { ["file"] => string(97) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Zend/Controller/Dispatcher/Standard.php" ["line"] => int(308) ["function"] => string(8) "dispatch" ["class"] => string(22) "Zend_Controller_Action" ["type"] => string(2) "->" ["args"] => array(1) { [0] => &string(12) "jaluziAction" } } [7] => array(6) { ["file"] => string(83) "/home/combo/domains/combo.uz/public_html/FlexyDir/library/Zend/Controller/Front.php" ["line"] => int(954) ["function"] => string(8) "dispatch" ["class"] => string(35) "Zend_Controller_Dispatcher_Standard" ["type"] => string(2) "->" ["args"] => array(2) { [0] => object(Zend_Controller_Request_Http)#33 (15) { ["_paramSources":protected] => array(2) { [0] => string(4) "_GET" [1] => string(5) "_POST" } ["_requestUri":protected] => string(83) "/catalog/jaluzi/category/rulonnyie_shtoryi/country/kitaye/sort/price/color/raznyie/" ["_baseUrl":protected] => string(0) "" ["_basePath":protected] => NULL ["_pathInfo":protected] => string(83) "/catalog/jaluzi/category/rulonnyie_shtoryi/country/kitaye/sort/price/color/raznyie/" ["_params":protected] => array(7) { ["controller"] => string(7) "catalog" ["action"] => string(6) "jaluzi" ["category"] => string(17) "rulonnyie_shtoryi" ["country"] => string(6) "kitaye" ["sort"] => string(5) "price" ["color"] => string(7) "raznyie" ["module"] => string(7) "default" } ["_rawBody":protected] => NULL ["_aliases":protected] => array(0) { } ["_dispatched":protected] => bool(true) ["_module":protected] => string(7) "default" ["_moduleKey":protected] => string(6) "module" ["_controller":protected] => string(7) "catalog" ["_controllerKey":protected] => string(10) "controller" ["_action":protected] => string(6) "jaluzi" ["_actionKey":protected] => string(6) "action" } [1] => object(Zend_Controller_Response_Http)#34 (8) { ["_body":protected] => array(0) { } ["_exceptions":protected] => array(0) { } ["_headers":protected] => array(0) { } ["_headersRaw":protected] => array(0) { } ["_httpResponseCode":protected] => int(200) ["_isRedirect":protected] => bool(false) ["_renderExceptions":protected] => bool(false) ["headersSentThrowsException"] => bool(true) } } } [8] => array(6) { ["file"] => string(76) "/home/combo/domains/combo.uz/public_html/FlexyDir/application/Dispatcher.php" ["line"] => int(680) ["function"] => string(8) "dispatch" ["class"] => string(21) "Zend_Controller_Front" ["type"] => string(2) "->" ["args"] => array(0) { } } [9] => array(4) { ["file"] => string(49) "/home/combo/domains/combo.uz/public_html/rule.php" ["line"] => int(12) ["args"] => array(1) { [0] => string(76) "/home/combo/domains/combo.uz/public_html/FlexyDir/application/Dispatcher.php" } ["function"] => string(12) "require_once" } }
SQL: SELECT SQL_CALC_FOUND_ROWS g.*, `vl_3`.`list_id` AS `value_3`, `vl_22`.`list_id` AS `value_22`, `vl_14`.`list_id` AS `value_14` FROM `co_catalog` AS `g`
INNER JOIN `co_catalog_value_list` AS `vl_3`
INNER JOIN `co_catalog_value_list` AS `vl_22`
INNER JOIN `co_catalog_value_list` AS `vl_14` WHERE (g.status = "1") AND (g.type_id=0 OR g.type_id = 1) AND (vl_3.join_id = g.id) AND (vl_3.attr_id = 3) AND (vl_3.list_id = "24") AND (vl_22.join_id = g.id) AND (vl_22.attr_id = 22) AND (vl_22.list_id = "116") AND (vl_14.join_id = g.id) AND (vl_14.attr_id = 14) AND (vl_14.list_id = "80") GROUP BY `g`.`id` ORDER BY `g`.`price` ASC LIMIT 12