SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345328 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345328 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85439,272188,604422,208648,572943,175746,728474,174956,528825,574703,343984,400890,716469,967959,181835,304213,79019,577972,457190,740881,727983,311728,932360,987860,151612,824525,355852,499734,753965,405362,433538,213502,686150,135915,538583,479216,209831,76758,103085,460245,125351,205596,997579,630516,182056,1004117,291536,1037464,54491,441537,1006950,279737,536338,777293,840960,484397,660517,543819,178171,308719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]