SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31969 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31969 [ RunTime:0.004321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721778,903130,113265,66188,765935,592182,616378,958353,484959,497039,338700,501584,258504,635010,616411,925240,673401,645856,527743,516853,370171,949092,188430,259484,97982,998039,1025276,155770,909840,1029887,583582,822050,20156,1028339,303396,475030,349053,436425,665083,364542,756075,418380,604442,890472,948146,985301,293736,246945,621209,528413,99401,485220,443215,614559,300789,184641,751207,573377,144314,289307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]