SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005910 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005910 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387702,469953,854553,1013991,203386,647922,288760,67235,560785,625131,100469,1021244,260236,45246,490197,766211,235342,238668,886138,690606,620015,786146,615340,271992,269195,107161,796569,938866,922738,714478,1018743,272845,234306,674458,294771,67715,269904,751240,739987,899449,1022362,323658,1033495,1003820,999370,905128,745438,101166,884452,777054,934240,626913,523457,15570,887100,440669,979826,265389,422717,646159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]