SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414389 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414389 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564620,780016,369659,545583,388567,226131,607562,118359,58804,483870,186962,611168,896415,10498,119920,661178,109159,382489,167789,278397,926689,770852,530582,849688,800617,9670,970591,754619,216219,817791,903817,931736,136748,140258,980545,812659,731848,742511,663326,207569,1644,626440,358935,241305,901261,81391,183307,347414,564085,721460,560169,458547,320270,570928,83071,169585,855871,847581,953754,192271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]