SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480200 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480200 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824613,974794,174600,629095,890648,219216,414605,284449,56250,304992,307476,257819,969782,745269,643389,609248,455533,504131,488418,356892,33151,89242,774034,549510,932328,503378,700388,282437,891568,197260,395420,651995,584554,654339,171756,446704,416188,74050,578444,801732,848428,857208,62822,180804,154135,469446,484637,453579,1026378,248407,478099,405799,484919,77500,948729,734375,220256,568082,352127,441165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]