SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500071 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500071 [ RunTime:0.003012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658174,328848,461266,17341,919803,892960,216185,286918,963925,657346,1013747,724745,570887,598900,442750,301290,982948,159483,372085,740198,387066,55504,477928,1009905,644886,846644,629012,937509,890076,510135,486021,10686,954936,723070,491887,283419,295366,1034137,734886,384202,766243,512993,757882,351568,26664,365724,449538,140958,163964,7208,125601,611202,954214,141481,572172,148503,401191,1007543,477479,753243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]