SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59616 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59616 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672228,1032307,932784,370321,847612,441218,190586,721816,42528,4158,451559,198817,195552,770430,844647,275355,206371,1011221,574723,453260,331526,1020473,328777,963956,762906,92012,461404,550254,826156,881276,851838,629129,465574,477726,980639,988659,322214,626103,928038,822243,857658,929187,1014715,630509,297518,220544,554869,675524,964895,926810,822639,717394,430357,176612,200473,477896,650655,325542,603193,331381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]