SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460746 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460746 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252602,933745,268797,62252,240842,592586,101268,444535,912924,497164,66121,434531,7397,81520,614964,980819,176281,880283,278238,649707,1043176,174835,601126,303019,327332,871935,976848,1010897,444283,838902,981732,306610,271197,583352,682240,450722,1040080,149123,733032,610666,129779,703372,191298,712237,777112,892926,203010,891200,103860,1001735,133268,466737,288935,987975,354465,463670,738829,612596,611024,752212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]