SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55433 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55433 [ RunTime:0.004998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294981,380195,54989,1039485,987459,708527,521975,392677,1020771,76007,30899,450324,92396,396377,170773,709202,545282,700846,657573,598714,59979,422968,718562,611476,181132,288972,77744,969160,733086,608136,1029355,179675,460073,787492,436145,589657,597296,749633,185398,915394,915211,339361,425495,177810,901500,801893,69665,369123,265901,189318,382910,794842,298928,858312,703825,692767,714685,287271,433371,311672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]