SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195483 LIMIT 1 [ RunTime:0.000690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195483 [ RunTime:0.004703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29002,680415,607603,537952,246297,996377,101545,361551,870078,262425,460291,809596,829473,888012,154810,350808,384864,217806,780701,275480,646876,918204,388508,533669,575828,33187,346200,1036787,314088,291830,486106,644665,879724,401767,809700,423838,478080,1041132,460755,784993,955823,1432,735545,1004981,625208,685499,813134,250225,596414,1046492,329361,573960,376946,315592,212183,784417,398340,135327,326621,345228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002045s ]