SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195053 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195053 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143717,547891,371861,140941,390666,938872,925223,168574,693770,190012,171836,463666,71814,680632,698310,7915,809399,986125,1003234,303250,27911,366229,45925,638529,485512,306669,175653,354728,564230,479958,756674,585711,739464,953752,468258,217460,1047195,594819,784285,715504,577908,300868,839636,970688,1041622,403288,847497,334709,177273,1013504,80734,522977,91401,695184,246759,146421,141778,730674,927895,728361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]