SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58438 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58438 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597913,686476,562931,504347,634725,351130,39113,348734,828991,596678,805472,153052,936050,972458,622300,152139,559189,559465,75074,537731,395652,503530,13040,528107,304099,259194,787125,847662,668571,83589,159075,858955,202001,585465,1030047,893677,1034492,513726,501682,665442,1016108,347801,851544,46076,694283,528042,22916,258372,983528,970622,4351,374403,486978,762349,706303,583820,743111,335030,763393,660781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]