SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435394 LIMIT 1 [ RunTime:0.001860s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435394 [ RunTime:0.003086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983844,309771,123394,142789,1035667,605326,1019578,262912,528545,629338,496045,20135,434102,456551,250011,945616,438645,669956,456771,418164,438877,16531,704168,217346,874796,730709,810720,462825,522760,90186,845697,966107,397052,61439,250188,17982,177106,949449,362667,600937,572498,212237,108970,461771,1032444,964097,628399,232047,1029066,195751,134891,426255,235538,89931,690259,694299,737827,468090,125709,825183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000837s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]