SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20410 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20410 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140085,858254,320396,987785,946070,885287,298599,988643,94929,219184,279676,845510,1038613,705833,854978,328435,802239,540782,747060,624607,891518,586432,709605,856670,950637,520012,470062,730407,970297,293339,716630,710092,375937,375699,872742,976696,514368,995008,662855,662816,946044,682001,840650,392819,698896,906100,350177,43285,352910,875570,507855,389159,787691,419658,326340,383566,969717,3245,16024,266591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]