SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5151 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5151 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513877,369778,554418,2863,811528,408726,386083,171868,106360,949454,50702,624541,855153,216988,471239,76890,186723,3859,205524,632302,11265,924460,133867,513243,272819,292019,407714,901212,132961,54305,568846,770337,85762,462723,1002856,308156,900561,272705,708209,854067,738488,794393,280881,235046,843499,81978,528233,797536,714600,833367,572312,179324,93628,900783,1001029,35407,685799,65495,865924,855079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]