SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596240 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596240 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020334,485972,780514,55534,886637,820186,186268,639353,760122,680728,839419,404604,638085,815542,708342,838478,231294,750676,715176,787480,183162,890722,137073,223098,310002,844194,1009741,273252,212289,471450,627539,1019226,656829,7640,675178,316173,840143,1022300,463708,397833,35315,728686,220126,1037585,488786,79202,436972,736780,609566,553599,436010,855867,641336,194856,637701,414406,192050,916671,536477,374131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]