SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438002 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438002 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392083,188220,952399,534610,362869,501480,341700,737692,907102,980164,295920,487780,896567,450491,766997,40515,519971,192040,78839,662580,896634,531627,320618,560365,198908,1029973,423014,578041,34742,63177,971434,294743,101015,413609,120679,237260,516503,349192,853257,405592,800677,587274,935381,36829,745069,99489,949988,114002,183082,772275,360253,690967,1040745,891024,65947,847316,189449,254723,627925,118360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]