SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287313 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287313 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23066,818153,1013533,98460,1047248,494682,739250,165772,384814,682128,286229,744840,1038217,408678,725106,441015,150982,468721,852261,751846,302903,146225,341484,263727,983826,888491,668280,966745,998246,952965,225239,549757,135203,609855,801584,1016583,773170,412834,338726,585974,803913,549705,802860,230752,116995,905624,288420,147064,94638,391720,849042,974469,277012,834075,492552,960661,968860,971850,748722,616198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]