SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330045 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330045 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212985,127340,738481,142151,76892,632967,154759,776376,672752,487775,412314,871360,178104,713714,947048,900514,1025238,217467,978866,102754,90432,57890,673644,381591,822376,555886,656550,752258,287007,612996,44078,293538,984819,710366,594824,338199,712948,564509,586158,187025,424361,889325,837306,257527,1038113,795913,516753,630398,361451,505917,252743,292986,577839,714324,416058,974673,148749,166138,880859,259839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002838s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002242s ]