SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559796 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559796 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31882,778441,33299,417593,949541,247352,34480,767788,819379,413452,914405,972309,208110,993089,47951,541694,550623,984749,141061,327658,735641,29221,683079,992140,595594,612372,644910,144790,553081,512207,245215,701431,478619,892169,792013,221263,1015373,332408,823228,463679,284450,527217,282487,859488,777074,211416,801681,216045,517639,319054,630833,622635,534800,554130,5141,753698,83020,583366,791883,507488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001446s ]