[ BEHAVIOR ] Run app\common\behavior\AppEnd @app_end [ RunTime:0.014558s ]
[Product::findCount] SQL: SELECT COUNT(DISTINCT t1.id) AS tp_count FROM `tbl_product` `t1` INNER JOIN `tbl_product_idx` `idx` ON `t1`.`id`=`idx`.`prodid` INNER JOIN ( SELECT `prodid` FROM `tbl_product_attr_idx` WHERE `catid` = 127 AND ( ( `attrid` = 9 AND `valueid` = 9 ) OR ( `attrid` = 200 AND `valueid` = 43178 ) ) GROUP BY `prodid` HAVING COUNT(DISTINCT attrid) >= 2 ) `attr_filter` ON `t1`.`id`=`attr_filter`.`prodid` WHERE `idx`.`catid` = 127 AND `t1`.`status` = 1 LIMIT 1
[Product::findList] SQL: SELECT `t1`.`id`,`t1`.`part`,`t1`.`urlname`,`t1`.`price`,`t1`.`stock`,`t1`.`minqty`,`t1`.`incqty`,`t1`.`weight`,`t1`.`volume`,`t1`.`footprint`,`t1`.`rohs`,`t1`.`url`,`t1`.`remote_url`,`t1`.`status`,`t1`.`createtime`,`t1`.`updatetime`,`idx`.`brandid`,`idx`.`catid` FROM `tbl_product` `t1` INNER JOIN `tbl_product_idx` `idx` ON `t1`.`id`=`idx`.`prodid` INNER JOIN ( SELECT `prodid` FROM `tbl_product_attr_idx` WHERE `catid` = 127 AND ( ( `attrid` = 9 AND `valueid` = 9 ) OR ( `attrid` = 200 AND `valueid` = 43178 ) ) GROUP BY `prodid` HAVING COUNT(DISTINCT attrid) >= 2 ) `attr_filter` ON `t1`.`id`=`attr_filter`.`prodid` WHERE `idx`.`catid` = 127 AND `t1`.`status` = 1 ORDER BY `id` ASC LIMIT 0,20
