SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 996083 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 996083 [ RunTime:0.004393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841450,709049,226574,1006422,191863,700680,395042,752198,358307,748358,422420,1012100,349624,354895,233972,892198,816681,685829,713640,469644,791812,534364,306812,486424,57449,729504,262969,353253,614413,761356,450850,307492,384295,473133,907940,962024,311157,871083,821446,710190,469301,320552,614728,213490,881473,617051,449454,107458,89055,847161,997886,724367,373429,693199,205469,492224,416131,318577,97765,366707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 996083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 996083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]