SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810999 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810999 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002526,20506,413509,211104,481345,391249,536456,621588,485183,170662,1033289,217443,188874,537903,819431,163180,270465,125190,963764,690939,139279,119147,813743,439962,276835,700555,617896,286581,342451,775586,328249,702991,965787,326937,492411,284548,916328,262810,76610,263767,389804,921799,41007,258594,222776,1020789,783033,1032880,320831,991030,1018595,889584,1026129,879795,453377,975848,620466,58227,939851,60929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001328s ]