SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401847 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401847 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199855,181185,394598,338525,859236,867754,56041,1029330,108640,948639,203152,515420,334358,126827,384814,856422,917096,524849,912576,126074,532242,810419,586300,884906,621026,417864,856500,141486,798560,18982,926797,919734,698804,217100,419430,201965,349993,347232,132281,898148,604605,202441,508550,37833,647126,345686,333204,304662,501841,654107,552235,854060,514200,350192,605566,711283,473561,807096,249896,393137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]