SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482609 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482609 [ RunTime:0.003909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220807,425076,864727,983707,460604,863775,711804,608541,463751,909417,406374,301974,865515,175999,153681,512661,705808,911282,447341,244112,708435,653541,502519,277915,626266,930870,538875,226063,247821,327320,420710,637543,123689,960677,570542,750383,20061,147019,859921,750540,578103,103534,994601,229858,179958,903722,321204,517143,248570,298992,736324,536480,559622,870117,34950,1005392,1018538,541627,577361,541265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002932s ]