SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52505 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52505 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434219,56815,866999,322471,261602,332195,913386,303859,107489,103706,859189,26327,756922,548873,419756,344371,36414,810209,212434,998111,639748,597044,656176,770389,865793,409733,991052,222404,1021564,842604,1043533,521930,768809,603838,1001261,259761,54286,327793,730110,899160,93413,773175,478677,960530,472530,37646,413777,420793,12356,858606,114210,616776,551543,1025427,901626,739979,264030,520951,458346,323748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]