SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426058 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426058 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621984,921618,41435,720503,194313,683681,136456,306716,452898,984701,386079,893417,145549,25533,779663,818504,557573,276914,419105,146113,198141,919939,667215,705889,897910,488708,446008,269997,1027158,553143,134570,330206,9165,747784,511761,925075,416339,662165,701732,899431,540480,664125,807289,637943,134294,54584,1012927,116554,844449,954214,357023,16918,683806,197493,527672,175146,507096,735999,134286,792956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]