SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428978 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428978 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045535,614834,287849,753542,984705,603869,935118,546939,288397,1018050,902885,1026764,997683,58221,989255,819834,116969,110323,519470,261757,103802,687181,111009,272061,521856,1018596,688117,146331,7979,745313,988079,680832,731079,730931,293553,144571,928315,710151,864598,824143,171207,179400,983085,2638,339180,49878,1040939,423589,247221,685274,673709,482165,611488,764551,212726,576626,239649,257115,674148,266426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]