SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025123 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025123 [ RunTime:0.003099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188921,1044167,646126,1015460,596573,142567,340234,517754,183569,351041,673037,345914,978617,322318,290316,276421,867470,394145,374069,138868,602076,29311,774726,749976,993942,779411,990192,755672,489689,894637,654501,707787,223457,981470,409588,695558,559182,698857,907284,157489,648579,53249,185929,237253,627195,420459,786995,173092,480778,218032,952715,807364,145303,758200,746620,783565,951258,203365,430594,963100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025123 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025123 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]