SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290212 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290212 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445268,568154,334674,574558,68907,849834,277403,656022,463321,1013809,42146,445587,133531,84668,447622,867466,673889,810039,338245,966579,459532,425098,548325,87488,453771,417242,393194,404176,721947,289382,653401,1014290,220756,151644,892113,670791,447805,481456,357141,734133,972666,470948,520229,438866,461374,477027,277595,517056,659292,981074,243512,222873,948077,48219,664217,252805,110205,55658,528309,453888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]