SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 74108 LIMIT 1 [ RunTime:0.000943s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 74108 [ RunTime:0.002027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518797,770093,428140,585560,560319,386576,125209,91739,429163,1007211,253573,1016929,443319,532574,538472,10324,643507,423808,485650,484335,570498,188983,505397,289307,804710,658998,373872,222776,1005535,69654,297785,24265,470975,210831,928372,812958,646949,461419,479663,863321,392136,233099,860998,328891,130639,135724,122299,166801,25357,700096,891838,648439,584689,630528,528597,399717,1007079,739226,966431,96079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 74108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 74108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002262s ]