SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286568 LIMIT 1 [ RunTime:0.000841s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286568 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622018,5806,340140,828401,831872,967174,85550,871107,107291,927904,895137,226810,19510,121373,269887,346265,792087,785663,606410,840117,288303,715239,455174,750456,553368,372566,226954,1000596,39527,243575,61964,353142,183403,861937,903713,940027,593594,371899,489306,738618,680085,190196,403184,617543,866498,858012,256604,429354,976135,857444,461645,448465,539538,171253,540883,673454,439225,989131,585289,531340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]