SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286953 LIMIT 1 [ RunTime:0.001951s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286953 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545517,380384,203684,333795,576964,725701,234133,376759,591984,288987,94420,939583,1045265,840248,647589,107334,414378,509399,669793,419511,1021958,386646,156746,404835,795657,785679,137287,932141,41661,545249,567011,87372,576021,59828,792014,540580,420659,973534,381672,142587,336988,77855,638743,743335,614293,717047,782806,848014,972138,262106,826351,474187,510575,4352,336234,225008,148785,419421,969834,827203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006561s ]