SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50653 LIMIT 1 [ RunTime:0.000753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50653 [ RunTime:0.004484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568096,97093,395794,778245,229184,303362,294584,414629,906754,342439,491785,131570,580186,195644,409278,595525,391583,1005310,215590,735586,33423,823527,573636,612781,550468,277263,373335,529716,9433,489991,995333,318762,79600,770423,826856,544098,794921,490272,440842,796139,156654,774980,982451,501317,807993,427672,576907,546026,957454,286087,266535,129299,300467,198007,434896,283871,299924,451521,732978,301947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001049s ]