SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351608 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351608 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414244,333962,40893,330669,417102,1018227,937543,971124,500445,627718,647721,402568,434654,606804,231385,179935,309701,283302,1023294,982559,138109,183100,949419,402655,707582,104180,651704,819680,932142,40064,999824,726375,342886,644841,646048,313234,263760,102693,351847,911167,488765,232271,60287,576043,220486,824534,169639,969425,673083,87808,569357,542960,483410,959639,229784,149040,66377,632745,770471,93753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]