SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438054 LIMIT 1 [ RunTime:0.001740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438054 [ RunTime:0.007974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364718,811367,168144,1010662,934933,958408,380603,671139,609955,398064,1026096,450679,617757,995971,1010417,249925,484396,185023,784703,1004783,27634,617758,780266,681766,820789,842091,476191,992876,930531,1001425,1020201,462795,839281,491076,310264,702915,587448,83969,308404,301288,351489,165779,51064,924873,229040,695116,803571,127745,584100,231270,449946,726108,122361,328168,476532,441256,84625,857369,712785,726946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]