SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497331 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497331 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928722,88421,919795,314197,132007,469902,96817,588508,142604,1020969,220020,122001,397202,405790,297407,964067,382076,778812,97133,688705,873355,138545,715776,172106,86019,52024,192294,453594,283526,1007125,1048592,957281,670727,726811,40983,269595,216285,1037058,144,347195,849747,222727,936685,974876,647074,137928,651113,61825,840695,989894,1022374,553191,515347,337358,763080,791025,48561,434295,437668,99601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]