SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586699 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586699 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852779,362619,455456,1008776,987407,371247,888160,968147,92846,908217,188494,425333,800903,814497,504517,428444,853036,659946,536310,277644,287005,203920,722547,1034032,784316,561907,252152,947372,241580,701686,698890,923853,1004878,467446,471324,531074,943984,47568,275747,113298,982740,684160,690695,335250,660199,103771,737008,276960,799394,720515,940293,389532,64373,161727,997236,792033,383065,1013712,921248,865515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]