SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477312 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477312 [ RunTime:0.006105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114071,229469,116529,421127,495187,1011430,121842,262462,702798,495645,571471,731236,1043644,534978,39161,476932,905002,669536,450471,947308,990068,806747,425148,435103,351908,530882,30171,953432,100142,826538,692277,109580,77550,545065,731315,544436,630103,563065,362181,8853,591548,12158,819355,401888,471716,885579,134505,265898,856691,528708,493450,1004776,17592,288502,94347,841227,909325,783011,243440,19317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002585s ]