SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 921013 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 921013 [ RunTime:0.003798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271153,422946,37540,283606,249571,152327,346568,310377,444543,146280,132646,257165,534422,233281,315573,735594,1041608,249801,143826,131911,31472,860204,252004,36198,706026,612526,428740,542019,418196,321475,139417,52209,47801,915568,599722,614783,348736,565174,1008829,695826,76776,714211,559882,401133,1038088,819345,593682,884983,350010,722871,297953,598575,67480,207997,768014,299328,907577,571756,170302,340105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 921013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 921013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]