SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044471 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044471 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549081,919374,3297,1016772,82245,22902,322692,101889,954723,752115,470804,316555,881868,881917,954117,823253,51600,233800,767153,874758,688150,760629,767101,1042109,320173,366721,29930,580576,733505,521126,203310,545190,979100,859097,850569,346990,309782,187433,353203,91722,40111,822908,46525,13191,719769,309212,247151,567454,540994,431246,161589,350456,654278,117724,336333,225039,551170,556649,424102,122996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]