SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20054 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20054 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048608,8689,979285,490079,468041,392592,162015,759271,265806,205810,525469,64980,598624,706868,72024,249226,153661,431320,1012231,541554,651240,198224,940464,795817,804073,439380,296073,512353,309836,561199,911352,305107,498107,492148,959267,158638,759519,339785,294547,695306,256076,43874,315705,240619,727071,970307,206798,318075,982454,868257,651560,372570,428927,364050,333625,950251,714743,335439,704802,704925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]