SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520089 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520089 [ RunTime:0.001415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80563,445049,257659,829308,776350,179815,462885,549982,342854,180099,693445,72104,710688,669867,145143,901345,505209,171233,794467,819952,998249,816272,143174,438140,961695,287484,119082,168309,480970,437485,931893,557992,931414,277288,497019,491887,896017,750353,364140,651200,46133,648303,100914,322458,226008,1001506,72792,554487,512345,705246,36889,357489,454576,553048,776929,386960,366388,89269,443133,892098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]