SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67708 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67708 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620034,144613,820350,334855,357575,1027025,274740,980727,453091,973548,380362,29911,978490,451358,694198,810432,303827,542593,171893,263040,468810,212605,333942,690078,554017,767999,555469,365717,937752,624464,236932,533587,409453,917175,87429,303592,928416,487726,959751,467520,989071,359300,318314,923934,194156,80143,524357,216493,296737,182298,703978,22136,933824,598336,505185,214281,663014,759737,682694,387522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]