SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4110 LIMIT 1 [ RunTime:0.000753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4110 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273581,620331,291288,774361,1035564,685551,172562,1047088,793140,601935,1010221,566224,643318,708722,515026,615573,822623,124817,831111,754489,819659,214797,412575,78604,1030935,1042478,851432,804597,245498,374367,254482,413532,863959,98299,330993,370358,929253,397361,500160,163610,694659,441091,122773,870405,394505,792083,608712,872659,410965,192574,799674,403183,305506,605374,840215,504203,865036,323318,955751,260271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]