SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68378 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68378 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182216,718190,165053,765786,793996,403132,28654,750747,54445,364834,318228,540542,481524,707190,413055,438368,975589,493775,972114,634576,526119,104513,1016959,714168,121429,478523,474384,157901,281229,490992,339291,782715,61789,819937,488447,761801,72039,207848,271641,152068,292369,415605,445841,724984,769081,1035004,262378,175906,807978,685791,497019,749866,1006890,1013770,453273,109549,383692,271883,778947,472587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]