SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245509 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245509 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492080,772376,828986,31032,351992,402414,389832,980223,914200,745408,836777,1008077,538281,34998,698276,241129,258567,604578,796413,435677,181765,403236,174953,942140,245555,359445,715193,1045397,84980,77416,561737,652913,52937,768243,593936,876070,966540,72831,262666,657986,616909,417374,421846,913202,749949,515756,615142,234845,478004,505508,922491,668962,647443,259002,471309,765272,139440,48095,659924,582927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]