SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199954 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199954 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135131,916181,837423,518929,134722,694030,644070,448939,609893,497810,159290,765555,236378,680253,69565,854066,779597,139840,422241,359548,526213,568303,528252,128653,473317,1002099,434706,451239,138949,491151,528940,580857,421417,760412,444625,525024,1007466,321839,397794,125519,778378,970476,963223,853199,387205,624435,620360,869748,18490,353814,340463,226339,713659,66825,1013713,335870,74997,19466,464377,1034148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]