SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987241 LIMIT 1 [ RunTime:0.001724s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987241 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576736,989844,345263,195857,7828,724340,419028,654594,1045072,447788,726039,1002389,848964,516891,562083,106148,945814,708444,641435,341387,862119,180434,10131,376845,172049,979620,601667,103121,160018,76946,224699,206109,919829,1025806,56692,548960,160077,265525,335144,336162,715735,177920,597593,561550,268220,14173,740239,140711,670340,966505,556176,589528,912455,231061,898507,305043,670010,369455,287672,270071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]