SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191035 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191035 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256398,302763,212994,224769,169574,577394,78094,464021,774306,383263,65000,541382,980824,963822,838738,766395,465531,664514,494373,542523,348624,44883,675566,18870,826590,269629,578770,601340,178765,393664,138792,961480,749871,393311,1000455,875040,724273,344011,726001,929975,350384,336500,278173,719636,604289,977496,474834,13301,644279,314006,4874,280832,488836,585252,1046989,190794,290625,790072,909657,824304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]