SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840160 LIMIT 1 [ RunTime:0.002700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840160 [ RunTime:0.003176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763805,1003066,315043,424083,984749,740614,944044,393837,578102,368,429679,193294,827969,132011,694889,1022980,517646,321830,854323,180284,905721,182925,983067,952567,66784,253974,519447,821716,729165,883423,533840,99021,792736,1037977,161201,222858,760751,285056,215690,62746,401755,276850,297900,356951,28228,469648,233038,920973,937918,255227,175109,717564,235132,809440,310688,548417,294233,378649,81500,826218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001139s ]